Question: THE HOUSE VALUE IS $ 5 4 5 , 0 0 0 Assume that you can make 1 5 % down payment on the house
THE HOUSE VALUE IS $ Assume that you can make down payment on the house the annual interest rate is for a year fixed mortgage with one point paid at the time of closing. Based on the asking price of the house, answer the following questions:
a What is the amount of the down payment?
b What is the mortgage amount?
c What is the cost of onepoint?
d Use Excel to calculate the amount of monthly mortgage payment for a year loan. Check your result using the loans formula and show all your work.
e Calculate the amount of interest paid with the first monthly payment.
f Determine how much of the first payment on the mortgage is applied to the principal.
g What is the total amount paid for the house over years?
h Calculate the total interest paid for the year loan.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
