Finance Functions

Last modified: December 08, 2019

A finance function applies financial algorithms or mathematical calculations.

FinanceCAGR(BeginningValue, EndingValue, NumYears): Compound Annual Growth Rate: The geometric mean growth rate on an annualized basis.

FinanceEffectiveRate(NominalRate, PaymentsPerYear): Effective Annual Interest Rate: The interest rate on a loan or financial product restated from the nominal interest rate as an interest rate with annual compound interest payable in arrears

FinanceFV(Rate, NumPayments, PaymentAmount, PresentValue, PayAtPeriodBegin): Future Value of an Investment: The value of an asset at a specified time in the future assuming a certain interest rate or rate of return.

FinanceFVSchedule(Principle, Year1Rate, Year2Rate): Future Value Schedule: The future value of an initial principal after applying a series of interest rates to an investment.

FinanceIRR(Value1, Value2): Internal Rate of Return: The interest rate at which the costs of the investment lead to the benefits of the investment. This means that all gains from the investment are inherent to the time value of money and that the investment has a zero net present value at this interest rate.

FinanceMIRR(FinanceRate, ReinvestRate, Value1, Value2): Modified Internal Rate of Return: A modification of the internal rate of return that aims to resolve some problems with the IRR. The MIRR is a financial measure of an investment's attractiveness.

FinanceMXIRR(FinanceRate, ReinvestRate, Value1, Date1, Value2, Date2): Modified Internal Rate of Return of an investment with dates

FinanceNominalRate(EffectiveRate, PaymentsPerYear): Nominal Annual Interest Rate: An interest rate is called nominal if the frequency of compounding (such as a month) is not identical to the basic time unit (normally a year).

FinanceNPER(Rate, PaymentAmount, PresentValue, FutureValue, PayAtPeriodBegin): Number of periods for an investment or loan

FinanceNPV(Rate, Value1, Value2): Net Present Value of an investment: Measures the excess or shortfall of cash flows, in present value terms, once financing charges are met.

FinancePMT(Rate, NumPayments, PresentValue, FutureValue, PayAtPeriodBegin): Calculates payments on a loan

FinancePV(Rate, NumPayments, PaymentAmount, FutureValue, PayAtPeriodBegin): Present Value of an Investment: The value on a given date of a future payment or series of future payments, discounted to reflect the time value of money and other factors such as investment risk.

FinanceRate(NumPayments, PaymentAmount, PresentValue, FutureValue, PayAtPeriodBegin): Returns the interest rate (per period)

FinanceXIRR(Value1, Date1, Value2, Date2): Internal Rate of Return of an investment with dates

FinanceXNPV(Rate, Value1, Date1, Value2, Date2): Net Present Value of an investment with dates

Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.