AnsweredAssumed Answered

How to do Compound interest calculations in FMP?

Question asked by JudeAshton on Apr 30, 2014
Latest reply on May 2, 2014 by JudeAshton

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.

Outcomes