Type the Excel function for the future value of $2,500 deposited at the end of each year for 20 years at 7 %.

Answer

=FV(0.07,20,-2500)

pmt −2,500 (deposits leave your pocket) → 102,488.73 positive. The FVAF 40.9955 is greater than n = 20.

Bigel, Introduction to Financial Analysis (CC BY 4.0) §11.5–11.6, §11.22 (payment = principal ÷ PVAF) — shape only; Excel PMT authored fresh; original scenarios