# Future Value

##### New Member
<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

### 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
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

##### Well-known Member
=-fv(0.03,5,,1000000)

Last edited:

#### mgirvin

##### Well-known Member
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