Future Value

[kgrady]

<TABLE cellSpacing=0 cellPadding=2 width=283 border=0><TBODY><TR><TD width="59%" height=20>

Investment Amount​

​

</TD><TD width="41%" height=20>

€1,000,000​

​

</TD></TR><TR><TD width="59%" height=20>
</TD><TD width="41%" height=20>
</TD></TR><TR><TD width="59%" height=20>

Interest Rate per Year​

​

</TD><TD width="41%" height=20>

3%​

​

</TD></TR><TR><TD width="59%" height=20>
</TD><TD width="41%" height=20>
</TD></TR><TR><TD width="59%" height=20>

Number of Years​

​

</TD><TD width="41%" height=20>

5​

​

</TD></TR><TR><TD width="59%" height=20>
</TD><TD width="41%" height=20>
</TD></TR><TR><TD width="59%" height=20>

Future Value​

​

</TD><TD width="41%" height=20>
</TD></TR></TBODY></TABLE>

Hi

I need to work out the future value of the above investment. I have tried the Fv function which someone suggested. I'm sure this is right but I just cant get it to work! Can anyone help. Thanks for your help. Kathryn

 

[JimM]

When you say future value do you mean you want the total plus any interest the money has earnt - if so how is the interest calculated ie daily, monthly yearly etc and when is it compounded ?

Cheers

Jim

 

[SteveO59L]

=-fv(0.03,5,,1000000)

 

[mgirvin]

Try this:

Excel Workbook
	A	B
1	PV	1000000
2	Yearly Rate	0.03
3	Years	5
4	Formula 1	$ 1,159,274.07
5	Formula 2	$ 1,159,274.07
FV

Excel 2010

Cell Formulas
Range	Formula
B4	=FV(B2,B3,,-B1)
B5	=(1+B2)^B3*B1