Given
interest rate r=2% monthly
Loan Value = Present Value of 1st year instalment + Present Value of 2nd year instalment +Present Value of 3rd year instalment
1st year instalment A1=$5000
Present Value of 1st year instalment= 5000*(1-(1+2%)^-12)/2%=$52876.71
Month | Instalment | PV of Instalment |
13 | 4750 | 3671.90 |
14 | 4500 | 3410.44 |
15 | 4250 | 3157.81 |
16 | 4000 | 2913.78 |
17 | 3750 | 2678.11 |
18 | 3500 | 2450.56 |
19 | 3250 | 2230.90 |
20 | 3000 | 2018.91 |
21 | 2750 | 1814.38 |
22 | 2500 | 1617.10 |
23 | 2250 | 1426.85 |
24 | 2000 | 1243.44 |
PV of 2nd year | 28634.19 |
Month | Instalment | PV of Instlment |
25 | 2300 | 1401.92 |
26 | 2600 | 1553.71 |
27 | 2900 | 1699.00 |
28 | 3200 | 1838.00 |
29 | 3500 | 1970.89 |
30 | 3800 | 2097.87 |
31 | 4100 | 2219.11 |
32 | 4400 | 2334.79 |
33 | 4700 | 2445.08 |
34 | 5000 | 2550.14 |
35 | 5300 | 2650.15 |
36 | 5600 | 2745.25 |
PV of 3rd year | 25505.89 |
Loan Value = Present Value of 1st year instalment + Present Value of 2nd year instalment +Present Value of 3rd year instalment =52876.71+28634.19+25505.89=$107016.80
Get Answers For Free
Most questions answered within 1 hours.