View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 299
Default Future Value Calculation

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


--


Regards,

Peo Sjoblom

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


"SJT" wrote in message
...
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.