In: Finance
Present value(PV) | $2,800,000 | |||||||||
Total Term in years | 8 | |||||||||
Number of months | 96 | (8*12) | ||||||||
Monthly interest rate | 0.6667% | (8/12)% | ||||||||
Residual Value at end of term (FV) | $1,400,000 | (0.5*2800000) | ||||||||
Monthly Annuity | $29,125.44 | (Using PMT function with Rate=0.6667%,Nper=96,PV=-2800000, FV=1400000) | ||||||||
Amount of AnnuityJeremy will receive | $29,125 | |||||||||
|