In: Finance
1. Calculate the maximum value of a home which a buyer may purchase based on a pre-approved mortgage with the following characteristics. | ||||||||||
Loan Amount | 80% | of Purchase Price | ||||||||
Loan Term (nper) | 20 | years | 240 | months | fully amortizing | |||||
Payments (PMT) | $1,750 | per month | ||||||||
Interest Rate (i) | 3.95% | per year | 0.33% | per month | ||||||
Future Value (FV) | 0 | (fully amortizing) | ||||||||
Maximum Value of Loan (PV) | ||||||||||
Maximum Value of Home |
Compute the present value (PV) of loan, using the equation as shown below:
Present value = Monthly payments*PVIFA0.33%, 240 months
= $1,750*165.5973
= $289,795.28
Hence, the PV of the loan is $289,795.28.
Working note:
Compute the PVIFA factor at 0.33% and 240 months, using the equation as shown below:
PVIFA = {1 – (1 + Rate)-Number of periods}/ Rate
= {1 – (1 + 0.0033)-240}/ 0.33%
= 165.5973
Hence, the PVIFA at 0.33% and 240 payments are 165.5973.
Compute the value of the home, using the equation as shown below:
Home value = Loan value/ Percentage of loan
= $289,795.28/ 80%
= 362,244.10
Hence, the value of the home is $362,244.10.