My premium support inside Salesforce staff can not help.
We have always calculated a principle and interest payment using, Microsoft Excel, a financial calculator or loan software.
They all have a "PMT" function and salesforce does not.
This is absolutely critical for us and has stopped us in our tracks. Using "simple" interest will NOT cut it for us, as we are a commercial loan company.
Has anyone successfully written a principle & interest formula in salesforceeaze?
I want to build a payment calculation that would show the P&I (principal and interest) payment for a loan. My variables would be loan amount, term, and interest rate. When I put in the complete mathematical formula I get an error. I seem to have narrowed the problem down to the negative exponent that is needed in the payment calculation. Any suggestions for a work around, or other solution?
