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.

APR Formula Recreated in Airtable

Topic Labels: Formulas
Solved
Jump to Solution
1887 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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.