Future Value

kgrady

New Member
Joined
Jul 17, 2010
Messages
3
<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
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

JimM

Well-known Member
Joined
Nov 11, 2003
Messages
675
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
 

mgirvin

Well-known Member
Joined
Dec 15, 2005
Messages
1,213
Try this:
Excel Workbook
AB
1PV1000000
2Yearly Rate0.03
3Years5
4Formula 1$ 1,159,274.07
5Formula 2$ 1,159,274.07
FV
Excel 2010
Cell Formulas
RangeFormula
B4=FV(B2,B3,,-B1)
B5=(1+B2)^B3*B1
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,938
Messages
5,508,228
Members
408,670
Latest member
lhmwnrexcel

This Week's Hot Topics

Top