Future Value Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to calculate a simple future value and the Excel FV formula only
seems to allow for an investment based on periodic constant payments. My
example simply involves a PV today of $20000 and I want to know what the
future value is if I have nper of 12 months and my periodic interest rate is
11%/12. Thank you in advance for your assistance.
 
Hello:

Try setting the pmt to zero and setting the PV to 20000
ie =FV(0.11/12,12,0,20000) = ($22,314.38)
The Excel handles both contant payments and single amounts.
So just set each to desired value. Note if the investment
does not pay interest compounded monthly then amount
will be smaller.

Alternative: =20000*(1+0.11/12)^12

Pieter Vandenberg


: I am trying to calculate a simple future value and the Excel FV formula only
: seems to allow for an investment based on periodic constant payments. My
: example simply involves a PV today of $20000 and I want to know what the
: future value is if I have nper of 12 months and my periodic interest rate is
: 11%/12. Thank you in advance for your assistance.
 
Back
Top