### Title

How to do Compound interest calculations in FMP?

### Post

Hi there,

I am using FMPro 13 on Apple Mac. I have Excel that uses a formula

=FV(Appendix!B3,'Personal Details'!B39,0,-B4,0)

While I know it references other sheets, I am trying to recreate the formula in FMPro. We have data in the database it references.

I have tried to do the FV command, but we are struggling trying to get it to do the compound interest. Any ideas?

Thanks in advance.

Okay, we resolved the formula.

2000*(1+.025)^10

2000 is the payment or you can point it to a total, 0.25 is the interest rate and 10 is year to retirement.

Thanks for everyones help.