Help

APR Formula Recreated in Airtable

Topic Labels: Formulas
Solved
Jump to Solution
3212 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.