Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Future Value Calculation
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Future Value Calculation
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 SJT wrote: : 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
Open CSV causes calculation in manual calc mode | Excel Discussion (Misc queries) | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |