In: Finance
Winston deposits $A in an account today. He plans to withdraw $200 at the beginning of every year for 15 years, first withdrawal today. The account earns j2 = 6% for the first 8 years and j2 = 4% thereafter. What is the value of A?
b) Deposits of $300 are made at the end of each month for five years into an account that earns interest at j2 = 5%. The account credits simple interest for fractional periods. What is the accumulated value of this account just after the 60th monthly deposit is made?
Part A:
= CF * [ ( PVAF @6%, 8) + PVAF ( 4%, 9 to 15) ]
= $ 200 * [ 6.5823 + 3.9917 ]
= $ 200 * 10.5741
= $ 2114.82
Value Today = PV of CFs received
| Year | CF | PVF | Disc CF |
| 1 | $ 200.00 | 1.0000 | $ 200.00 |
| 2 | $ 200.00 | 0.9434 | $ 188.68 |
| 3 | $ 200.00 | 0.8900 | $ 178.00 |
| 4 | $ 200.00 | 0.8396 | $ 167.92 |
| 5 | $ 200.00 | 0.7921 | $ 158.42 |
| 6 | $ 200.00 | 0.7473 | $ 149.45 |
| 7 | $ 200.00 | 0.7050 | $ 140.99 |
| 8 | $ 200.00 | 0.6651 | $ 133.01 |
| 9 | $ 200.00 | 0.6395 | $ 127.90 |
| 10 | $ 200.00 | 0.6149 | $ 122.98 |
| 11 | $ 200.00 | 0.5912 | $ 118.25 |
| 12 | $ 200.00 | 0.5685 | $ 113.70 |
| 13 | $ 200.00 | 0.5466 | $ 109.33 |
| 14 | $ 200.00 | 0.5256 | $ 105.12 |
| 15 | $ 200.00 | 0.5054 | $ 101.08 |
| Value Today | $2,114.82 |
Part B:
| Month | Dep | Int | Total |
| 1 | $ 300.00 | $ 73.75 | $ 373.75 |
| 2 | $ 300.00 | $ 72.50 | $ 372.50 |
| 3 | $ 300.00 | $ 71.25 | $ 371.25 |
| 4 | $ 300.00 | $ 70.00 | $ 370.00 |
| 5 | $ 300.00 | $ 68.75 | $ 368.75 |
| 6 | $ 300.00 | $ 67.50 | $ 367.50 |
| 7 | $ 300.00 | $ 66.25 | $ 366.25 |
| 8 | $ 300.00 | $ 65.00 | $ 365.00 |
| 9 | $ 300.00 | $ 63.75 | $ 363.75 |
| 10 | $ 300.00 | $ 62.50 | $ 362.50 |
| 11 | $ 300.00 | $ 61.25 | $ 361.25 |
| 12 | $ 300.00 | $ 60.00 | $ 360.00 |
| 13 | $ 300.00 | $ 58.75 | $ 358.75 |
| 14 | $ 300.00 | $ 57.50 | $ 357.50 |
| 15 | $ 300.00 | $ 56.25 | $ 356.25 |
| 16 | $ 300.00 | $ 55.00 | $ 355.00 |
| 17 | $ 300.00 | $ 53.75 | $ 353.75 |
| 18 | $ 300.00 | $ 52.50 | $ 352.50 |
| 19 | $ 300.00 | $ 51.25 | $ 351.25 |
| 20 | $ 300.00 | $ 50.00 | $ 350.00 |
| 21 | $ 300.00 | $ 48.75 | $ 348.75 |
| 22 | $ 300.00 | $ 47.50 | $ 347.50 |
| 23 | $ 300.00 | $ 46.25 | $ 346.25 |
| 24 | $ 300.00 | $ 45.00 | $ 345.00 |
| 25 | $ 300.00 | $ 43.75 | $ 343.75 |
| 26 | $ 300.00 | $ 42.50 | $ 342.50 |
| 27 | $ 300.00 | $ 41.25 | $ 341.25 |
| 28 | $ 300.00 | $ 40.00 | $ 340.00 |
| 29 | $ 300.00 | $ 38.75 | $ 338.75 |
| 30 | $ 300.00 | $ 37.50 | $ 337.50 |
| 31 | $ 300.00 | $ 36.25 | $ 336.25 |
| 32 | $ 300.00 | $ 35.00 | $ 335.00 |
| 33 | $ 300.00 | $ 33.75 | $ 333.75 |
| 34 | $ 300.00 | $ 32.50 | $ 332.50 |
| 35 | $ 300.00 | $ 31.25 | $ 331.25 |
| 36 | $ 300.00 | $ 30.00 | $ 330.00 |
| 37 | $ 300.00 | $ 28.75 | $ 328.75 |
| 38 | $ 300.00 | $ 27.50 | $ 327.50 |
| 39 | $ 300.00 | $ 26.25 | $ 326.25 |
| 40 | $ 300.00 | $ 25.00 | $ 325.00 |
| 41 | $ 300.00 | $ 23.75 | $ 323.75 |
| 42 | $ 300.00 | $ 22.50 | $ 322.50 |
| 43 | $ 300.00 | $ 21.25 | $ 321.25 |
| 44 | $ 300.00 | $ 20.00 | $ 320.00 |
| 45 | $ 300.00 | $ 18.75 | $ 318.75 |
| 46 | $ 300.00 | $ 17.50 | $ 317.50 |
| 47 | $ 300.00 | $ 16.25 | $ 316.25 |
| 48 | $ 300.00 | $ 15.00 | $ 315.00 |
| 49 | $ 300.00 | $ 13.75 | $ 313.75 |
| 50 | $ 300.00 | $ 12.50 | $ 312.50 |
| 51 | $ 300.00 | $ 11.25 | $ 311.25 |
| 52 | $ 300.00 | $ 10.00 | $ 310.00 |
| 53 | $ 300.00 | $ 8.75 | $ 308.75 |
| 54 | $ 300.00 | $ 7.50 | $ 307.50 |
| 55 | $ 300.00 | $ 6.25 | $ 306.25 |
| 56 | $ 300.00 | $ 5.00 | $ 305.00 |
| 57 | $ 300.00 | $ 3.75 | $ 303.75 |
| 58 | $ 300.00 | $ 2.50 | $ 302.50 |
| 59 | $ 300.00 | $ 1.25 | $ 301.25 |
| 60 | $ 300.00 | $ - | $ 300.00 |
| After after 60 Months | $ 20,212.50 |
Int = Deposit * (5%/12) * No. of Months balance