In: Finance
To Answer this question we need to apply time value of money to Annuity.
An annuity is a stream of equal periodic cash flows, over a specified time period. These cash flows are usually annual but can occur at other intervals, such as monthly or quarterly.
The future value of the ordinary annuity is calculated as shown below using Excel spreadsheet.