Type the formula for the future value of a $1,000 deposit at 5 % over three years.

Answer

=FV(0.05,3,0,-1000)

Returns 1,157.63. The deposit is out of your pocket (negative), so the future value comes back positive.

Bigel, Introduction to Financial Analysis (CC BY 4.0) §10.2 — the compounding formula only