This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
How do I write the equivalent of Excel’s PMT formula in AirTable field that produces the equivalent result in Excel? In Excel it’s =PMT(rate,nper,pv). In Excel I adapted it as =PMT(rate/12,nper12,pv)-1** which also produced the monthly payment as a p...
Here’s why.
My loan amount was $720K. My interest rate is 4%. My Loan Term is 10 years.
When I used the formula unaltered it returned a value for monthly payment of $88,768.48.
When I adapted it I got a payment value of $7,3332.66 , which is much clo...
