In: Finance
You plan to deposit $4,500 per month in your kid’s college fund for 12 consecutive years. Assuming an annual rate of 6% how much should you expect to have on the account at the end of year 12?
| Particulars | Amount | Calculations | |
| Deposit(PMT) | $ 4,500.00 | ||
| Period = 12*12 = | 144 | =12*12 | |
| Annual Rate | 6.00% | ||
| Monthly Rate | 0.50% | =6%/12 | |
| Account Balance | |||
| After 12 Years(FV) | $945,675.73 | =-FV(D6,D4,D3) | |
| OR | |||
| Account Balance | |||
| After 12 Years(FV) | $ 945,675.73 | =4500*((((1.005)^144)-1)/0.005) |

Please Thumbs Up
Thanks