In: Finance
You will be paying off a mortgage of $250,000 over the next 25 years. You have signed a loan agreement with Me-Bank to secure a fixed rate of 5.00%. The mortgage loan is compounded annually.
a) What are the monthly payments? [4 points]
b) How much will your payments be over the first five years? [2 points]
c) What is the amount of principal that you pay off with the first payment? [2 points]
d) How much principal remains to be paid after the first five years? [2 points]
e) How much will remain to be paid off after you have made your payment at the end of the 15th year? [2 points]
.
1- | Monthly payment | amount of mortgage loan/PVAF at .4166% for 300 months | 250000/171.0737 | 1461.358 | |
PVAF at .4166% for 300 months | 1-(1+r)^-n /r | 1-(1.004166)^-300 /.4166% | .712693/.4166% | 171.0737 | |
2- | How much will your payments be over the first five years | amount of monthly payment*no. of months in 5 years | 1461.358*60 | 87681.48 | |
3- | Monthly payment in first payment | 1461.358 | |||
amount of interest payment in first monthly payment | 250000*.4166% | 1041.5 | |||
Amount of prinicpal paid | 1461.358-1041.5 | 419.86 | |||
4- | Balance in loan account after 5 years | principal*(1+r)^n - monthly payment*FVAF at .4166% for 60 months | 250000*1.004166^60 -(1461.358*68.0048) | 221447.5 | |
FVAf at .4166% for 60 months | (1+r)^n-1 /r | 1.004166^-60 -1 /.4166% | .283308/.4166% | 68.0048 | |
5- | Balance in loan account after 15 years | principal*(1+r)^n - monthly payment*FVAF at .4166% for 180 months | 250000*1.004166^180 -(1461.358*267.271) | 137784.2 | |
FVAf at .4166% for 60 months | 1+r^n -1 /r | 1.004166^180 -1 /.4166% | 1.113451/.4166% | 267.271 |