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. |
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. |
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. |
All times are GMT +1. The time now is 02:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com