Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Loan Payoff Date Estimator

62 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Would anyone be able to help me adapt the following formula to Airtable?

N = –[ln(1 – [(PV * i) / PMT_] ) / ln(1 + _i)]

N = Number of months remaining
PV = Present Value
PMT = Payment Amount

I'm struggling with an otherwise simple operation because I'm not sure how to account for the natural logarithm in Airtable. I'm ok with something that gets close enough, because the idea is I just want to arrive at an estimated payoff date. Doesn't have to be 100% accurate, just a decent estimate.

Thanks for any insight.

0 Replies 0