Perform Financial Calculations on Records like determining Present Value of investments, Future Value, Interest Payments, Payments, Principal Payments, Rate, Net Present Value, and Internal Rate of Return

**🔴 On2Air Actions has been shutdown to focus on our On2Air Backups Airtable app

Learn more about automated Airtable backups - on2air.com**

Function Type: Record Processing Functions

Finance Functions Available

These functions emulate the same formulas as those found in Excel and should result in similar answers.

• Present Value - Returns the present value of an investment, or the total amount that a series of future payments is worth now.
• Future Value - Returns the future value of an investment based on periodic, equal, payments and a constant interest rate.
• Payment - Calculates the payment for a loan based on a constant stream of equal payments and a constant interest rate.
• Interest Payment - Returns the calculated interest portion of a payment for a specific period based on a constant stream of equal payments and a constant interest rate.
• Principal Payment - Returns the calculated principal portion of a payment for a specific period based on a constant stream of equal payments and a constant interest rate.
• Rate - Returns the interest rate per period for a loan or investment.
• Net Present Value - Returns the net present value of an investment based on a constant rate of return and a series of future payments/investments (as negative values) and income/return (as positive values).
• Internal Rate of Return - Returns the internal rate of return for a series of cash flows. NOTE: There must be at least one negative and one positive value as part of the cash flow. Cash flows are assumed to be due in the same order they are arranged in the cash flow values array.