Future Value Calculation

S

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.
 
V

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top