Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

APR Formula Recreated in Airtable

Topic Labels: Formulas
Solved
Jump to Solution
3393 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Utah_Mortgage
4 - Data Explorer
4 - Data Explorer

Is it possible to recreate this formula in Airtable?

APR_Formula

Where:

  • i = IRR
    L = Loan amount
    F = Points and all other lender fees
    P = Monthly payment
    n = Month when the balance is paid in full
    Bn = Balance in month n

This equation can be solved for i only through a series of successive approximations, which must be done by computer. Many calculators will also do it provided that all the values of P are the same.

I’m trying to solve for i

All items except for i would be supplied via columns inside Airtable

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Since it can only be solved via successive approximations, you cannot calculate it in a single formula in Airtable.

However, it can be calculated by a custom script in the Scripting block. If no-one posts a Script, you could probably hire a consultant to write it for you.

See Solution in Thread

1 Reply 1
kuovonne
18 - Pluto
18 - Pluto

Since it can only be solved via successive approximations, you cannot calculate it in a single formula in Airtable.

However, it can be calculated by a custom script in the Scripting block. If no-one posts a Script, you could probably hire a consultant to write it for you.