Type the Excel function that grows a $5,000 deposit at 4.5 % for 8 years, compounded annually.
Type the Excel function that grows a $5,000 deposit at 4.5 % for 8 years, compounded annually.
Answer
=FV(0.045,8,0,-5000)
rate 0.045, nper 8, pmt 0, pv −5,000 (the deposit leaves your pocket) → 7,110.50, returned positive as money coming back.
Bigel, Introduction to Financial Analysis (CC BY 4.0) §10.2–10.5 — shapes only; Excel argument list authored fresh; original scenario