Monthly amortization schedule. Sherry and Sam want to purchase a condo at the coast. They will spend $640,000 on the condo and are taking out a loan for the condo for twenty years at 7.2% interest. a. What is the monthly payment on the mortgage? Construct the amortization of the loan for the twenty years in a spreadsheet to show the interest cost, the principal reduction, and the ending balance each month. b. Then change the amortization to reflect that after ten years, Sherry and Sam will increase their monthly payment to $7,300 per month. When will they fully repay the mortgage with this increased payment if they apply all the extra dollars above the original payment to the principal? a. What is the monthly payment on the mortgage? The monthly interest rate on the mortgage is 0.6000000 %. (Round to seven decimal places.) The monthly payment on the mortgage is $4849.16. (Round to the nearest cent.)

Monthly amortization schedule. Sherry and Sam want to purchase a condo at the coast. They will spend $640,000 on the condo and are taking out a loan for the condo for twenty years at 7.2% interest. a. What is the monthly payment on the mortgage? Construct the amortization of the loan for the twenty years in a spreadsheet to show the interest cost, the principal reduction, and the ending balance each month. b. Then change the amortization to reflect that after ten years, Sherry and Sam will increase their monthly payment to $7,300 per month. When will they fully repay the mortgage with this increased payment if they apply all the extra dollars above the original payment to the principal? a. What is the monthly payment on the mortgage? The monthly interest rate on the mortgage is 0.6000000 %. (Round to seven decimal places.) The monthly payment on the mortgage is $4849.16. (Round to the nearest cent.)

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 27M

See similar textbooks

Similar questions

We suggest the use of a spreadsheet to create the amortization tables. You take out a 30-year mortgage for $80,000 at 9.25%, to be paid off monthly. Construct an amortization table showing how much you will pay in interest each year for the first 15 years and how much goes toward paying off the principal. If you sell your house after 15 years, how much will you still owe on the mortgage according to the amortization table? HINT [See Example 8.] (Round your answer to the nearest cent.) $
You are planning on buying a new house and want to make sure you can afford the monthly payments. The house you picked will necessitate you borrow $300,000. You think you can get the following. mortgage terms: borrow $300,000 at a fixed quoted (nominal) annual rate of 3.775%; to be paid off in equal monthly payments over 15 years.Compute the required monthly payment, and prepare an amortization table, showing for each month the beginning balance, payment, payment applied to interest, payment applied to principal, and ending. balance. (Assume monthly compounding) (solution needs to be in excel)
You plan to purchase a $240,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 8 percent. You will make a down payment of 10 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b Construct the amortization schedule for the first six payments.
The Joneses are interested in purchasing a house listed at $580,000 in Thunder Bay. They are prepared to make a down payment of $200,000 and the rest of the money is financed by a mortgage offered by Royal Bank. The mortgage rate is 12% (APR compounded semiannually).a. What is the effective monthly rate on this mortgage?b. If the Joneses choose an amortization period of 10 years, what will be the monthly payment on their mortgage loan?c. What is the interest portion of the 25th payment? What is the principal portion of that payment? Please answer fast I give you upvote.
You plan to purchase a $240,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 8 percent. You will make a down payment of 10 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Construct the amortization schedule for the first six payments. Complete this question by entering your answers in the tabs below. Required A Required B Construct the amortization schedule for the first six payments. (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Amortization Schedule for first 6 payments (months) Month Beginning Loan Balance Payment Interest Principal Ending Loan Balance 1 2 3 4 5 6
Example: In this exercise prepare an amortization schedule showing the payments for each loan. Joan Varozza plans to borrow $20,000 to stock her small boutique. She will repay the loan with semiannual payments for 5 years at 7% interest. SET UP AN AMORTIZATION TABLE
A family buys a home by taking out a 15-year fixed-rate mortgage of $240,000 at 4.3% interest. What is their monthly payment? Round their answer up to the next whole dollar. How much will they pay over the course of 15 years? With this payment, much interest will they pay over the life of the loan? Complete the first three lines of this amortization table, using the payment you found above. Round each entry in the table to the nearest cent. Payment Number Interest Payment Principal Payment Balance of Loan 1 2 3 Submit Question
b) You have decided to buy an apartment costing $140,000. At present you have $10,000 to be paid as down payment and your bank CAB agrees to provide you with the remaining amount of money. The interest rate is 12% to be repaid in 5 years period. Find the annual payment to be amortized and also prepare a schedule of amortization.
You take out a 30-year $150,000 mortgage loan with an APR of 12% and monthly payments. In 11 years, you decide to sell your house and pay off the mortgage. What is the principal balance on the loan? Use Excel
Shaun and Kelsey decide they will buy a three-bedroom condo, with a $1,150,000 mortgage from Royal Trust (25 year amortization, 3.5% compounded semi-annually, 5 year term). Royal Trust has a policy of rounding monthly payments up to the next $100 dollar.What will be the size of their final payment?
You have been shopping for a new home. You have a choice of financing.You can choose either a $200,000 mortgage at 4.75 percent for 30 years, ora $200,000 mortgage at 3.5 percent for 15 years.a. Calculate the monthly payment for both the 30-year and 15-yearmortgages.b. Calculate the amount of interest paid over the life of the loan for bothmortgages.c. Choose the best mortgage for you and explain your answer.
You borrow $300,000 to buy a house; if the annual interest rate is 4% and the term of the loan is 20 years, what is the annual payment required to retire the mortgage loan? Complete the loan amortization schedule for the first payment: Payment Interest Portion Principal Portion Ending Balance #1