Future Value Calculation

[SJT]

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.

 

[Peo Sjoblom]

=FV(11%/12,12,,-20000)


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[vandenberg p]

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.