Help

Loan Payoff Date Estimator

589 0
cancel
Showing results for 
Search instead for 
Did you mean: 
raechyl
6 - Interface Innovator
6 - Interface Innovator

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