Question

In: Finance

You plan to purchase a $180,000 house using a 15-year mortgage obtained from your local credit...

You plan to purchase a $180,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 5.5 percent. You will make a down payment of 10 percent of the purchase price.

a. Calculate your monthly payments on this mortgage.
b. Calculate the amount of interest and, separately, principal paid in the 20th payment.
c. Calculate the amount of interest and, separately, principal paid in the 110th payment.
d. Calculate the amount of interest paid over the life of this mortgage.

(For all requirements, do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16))

Solutions

Expert Solution

cost of house 180000
Down payment-10% of cost of house 180000*10% 18000
amount borrowed 162000
Monthly Interest rate 5.5/12 0.46%
period = n = 15*12 180
1-
Monthly payment = amount borrowed/PVAF at .45833% for 180 months 162000/122.38692 1323.67
PVAF at .45833% for 180 months 1-(1+r)^-n / r r =.45833% n =180 .560936/.45833% 122.3869265
2-
Balance at the end of year 19th monthly payment PV*(1+r)^n -[ Monthly payment* (1+r)^n-1 / r)] 162000*(1.0045833)^19 - [1323.67* (1.0045833^19 -1 )/.45833% 176704.7-[1323.67*(.09077/.45833%) 176704.7-26214.59 150490.11
Balance at the end of 19th payment 150490.11
Monthly payment = amount borrowed/PVAF at .45833% for 180 months 1323.67
Interest = balance at the end of 19th payment *monthly interest rate 150490.11*.45833% 689.7413212
Principal payment in 20th payment = Monthly payment-Interest 1323.67-689.74 633.93
3-
Balance at the end of year 109th monthly payment PV*(1+r)^n -[ Monthly payment* (1+r)^n-1 / r)] 162000*(1.0045833)^109 - [1323.67* (1.0045833^109 -1 )/.45833% 266676.1-[1323.67*(.646149/.45833%) 266676.1-186609.5 80066.6
Balance at the end of 109th payment 80066.6
Monthly payment = amount borrowed/PVAF at .45833% for 180 months 1323.67
Interest = balance at the end of 109th payment *monthly interest rate 80066.6*.45833% 366.9692478
Principal payment in 110th payment = Monthly payment-Interest 1323.67-366.9692 956.7007522
4-
total Interest paid over the loan period =(monthly payment*no. of payment)-Principal borrowed (1323.67*180)-162000 76260.6

Related Solutions

You plan to purchase a $150,000 house using a 15-year mortgage obtained from your local credit...
You plan to purchase a $150,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 6.25 percent. You will make a down payment of 10 percent of the purchase price. a. Calculate your monthly payments on this mortgage. (Do not round intermediate calculations. Round your answer to 2 decimal places. (e.g., 32.16))   Monthly payment $ b. Calculate the amount of interest and, separately, principal paid in the 20th payment. (Do not...
You plan to purchase a $150,000 house using a 15-year mortgage obtained from your local credit...
You plan to purchase a $150,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 6.75 percent. You will make a down payment of 15 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Calculate the amount of interest and, separately, principal paid in the 60th payment. c. Calculate the amount of interest and, separately, principal paid in the 150th payment. d. Calculate the amount of...
You plan to purchase a $150,000 house using a 15-year mortgage obtained from your local credit...
You plan to purchase a $150,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 6.25 percent. You will make a down payment of 10 percent of the purchase price. a. Calculate your monthly payments on this mortgage. (Do not round intermediate calculations. Round your answer to 2 decimal places. (e.g., 32.16))   Monthly payment $    b. Calculate the amount of interest and, separately, principal paid in the 20th payment. (Do not...
You plan to purchase a $200,000 house using a 15-year mortgage obtained from your local credit...
You plan to purchase a $200,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 7 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.   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))...
You plan to purchase a $160,000 house using a 15-year mortgage obtained from your local credit...
You plan to purchase a $160,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 6 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.    A-Calculate your monthly payments on this mortgage. (Do not round intermediate calculations. Round your answer to 2 decimal places. (e.g., 32.16)) Monthly...
You plan to purchase a house for $175,000 using a 15-year mortgage obtained from your local...
You plan to purchase a house for $175,000 using a 15-year mortgage obtained from your local bank. You will make a down payment of 25 percent of the purchase price. You will not pay off the mortgage early. (LG 7-3) a. Your bank offers you the following two options for payment: Option 1: Mortgage rate of 5 percent and zero points. Option 2: Mortgage rate of 4.75 percent and 2 points. Which option should you choose? b. Your bank offers...
You plan to purchase a house for $200,000 using a 15-year mortgage obtained from your local...
You plan to purchase a house for $200,000 using a 15-year mortgage obtained from your local bank. You will make a down payment of 10 percent of the purchase price. You will not pay off the mortgage early. Assume the homeowner will remain in the house for the full term and ignore taxes in your analysis. a. Your bank offers you the following two options for payment. Which option should you choose? Option 1: Mortgage rate of 6.25 percent and...
You plan to purchase a house for $247,000 using a 15-year mortgage obtained from your local...
You plan to purchase a house for $247,000 using a 15-year mortgage obtained from your local bank. You will make a down payment of 20 percent of the purchase price. You will not pay off the mortgage early. Assume the homeowner will remain in the house for the full term and ignore taxes in your analysis. a. Your bank offers you the following two options for payment. Which option should you choose? Option 1: Mortgage rate of 6.8 percent and...
You plan to purchase a house for $127,000 using a 15-year mortgage obtained from your local...
You plan to purchase a house for $127,000 using a 15-year mortgage obtained from your local bank. You will make a down payment of 10 percent of the purchase price. You will not pay off the mortgage early. Assume the homeowner will remain in the house for the full term and ignore taxes in your analysis. a. Your bank offers you the following two options for payment. Which option should you choose? Option 1: Mortgage rate of 5.75 percent and...
You plan to purchase a $200,000 house using a 30-year mortgage obtained from your local credit...
You plan to purchase a $200,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 6.50 percent. You will make a down payment of 20 percent of the purchase price. (LG 7-4) a. Calculate your monthly payments on this mortgage. b. Construct the amortization schedule for the first six payments. please show in excel
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT