In: Finance
A house was bought for $300,000 with a mortgage of $240,000.
The interest rate is 2.8% and the term is 20 years (paid monthly).
If the house appreciates at 2% per year and the selling fees are about 8%, what is the reversion to the homeowner who has occupied the property at the end of year 12?
Rversion value at the end of 12 years | Amounts $ | |
Estimated Future value | 380472.5384 | |
Less | Remaining loan balance | 112306.87 |
Less | Estimated selling expense | 30437.8 |
Reversion value | 237727.87 | |
Equal monthly payment for 20 years | =240000/Present value annuity factor(2.8%/12,240 months) | |
=240000/183.6078 | ||
1307.134011 | ||
Installment Paid till 12 years | =1307.134*144 months | |
188227.296 | ||
Interst paid till then | 60534.16211 | |
Principal repayment | 127693.1339 | |
Closing balance of loan at the end of 12th year | 112306.87 | |
Estimated Future value | =300000*(1.02)12 | |
380472.5384 | ||
Selling expneses | =380472.5*.08 | |
30437.8 |
Repayement schedule as attached.