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 | |||||||||
|
|
||||||||||