Financial

Financial functions perform a variety of different calculations associated with annuities, loans, investments, principal, interest, and payments.

Note

Beginning with Analytics 12.0, a change made by Microsoft to its Visual C++ Redistributable Package, an Analytics prerequisite, causes the results of some Analytics financial functions to differ slightly from the results in previous versions of Analytics.

The Visual C++ change was made by Microsoft to improve computational precision. As a result, rounding in Analytics functions such as PMT( ) and FVSCHEDULE( ) now behaves differently.

Function descriptions

Function	Description
CUMIPMT( )	Returns the cumulative interest paid on a loan during a range of periods.
CUMPRINC( )	Returns the cumulative principal paid on a loan during a range of periods.
EFFECTIVE( )	Returns the effective annual interest rate on a loan.
FVANNUITY( )	Returns the future value of a series of payments calculated using a constant interest rate. Future value is the sum of the payments plus the accumulated compound interest.
FVLUMPSUM( )	Returns the future value of a current lump sum calculated using a constant interest rate.
FVSCHEDULE( )	Returns the future value of a current lump sum calculated using a series of interest rates.
IPMT( )	Returns the interest paid on a loan for a single period.
NOMINAL( )	Returns the nominal annual interest rate on a loan.
NPER( )	Returns the number of periods required to pay off a loan.
PMT( )	Returns the amount of the periodic payment (principal + interest) required to pay off a loan.
PPMT( )	Returns the principal paid on a loan for a single period.
PVANNUITY( )	Returns the present value of a series of future payments calculated using a constant interest rate. Present value is the current, lump-sum value.
PVLUMPSUM( )	Returns the present value required to generate a specific future lump sum calculated using a constant interest rate. Present value is the current, lump-sum value.
RATE( )	Returns the interest rate per period.

[ Back to top ]

ACL Scripting Guide 14.1