Version

UltraCalcFunctionRate Class

Calculates the per-period interest rate for a series of cash flows (an annuity).
Syntax
'Declaration
 
Public Class UltraCalcFunctionRate 
   Inherits BuiltInFunctionBase
public class UltraCalcFunctionRate : BuiltInFunctionBase 
Remarks

RATE(nPeriods, amount, presentValue, paymentDue, futureValue, estimate)

NPeriods are the total number of cash flows, whether a payment (negative amount) or a receipt (positive amount) occuring periodically with a fixed time period between each cash flow.

Amount is the amount of cash paid (negative) or received (positive). It must be held constant over the course of the annuity.

PresentValue is the value today of the series of future payments. Payments made in the future are discounted by the interest rate being calculated, because it is assumed that at that interest rate a smaller sum could be invested today and would grow to the amount at a future time when that payment became due.

PaymentDue indicates whether cash flows occur at the beginning of each period (1) or at the end of each period (0). If not specified, the payments at the end of each period is assumed.

FutureValue is the accumulated balance attained after nPeriods payments have been made and accrued interest at the calculated rate. If left unspecified, the default future value is assumed to be zero (this represents reaching zero loan liability, when a loan has been fully repaid).

Estimate is an approximation of the interest rate used to start the calculation (which works by iteratively refining the estimate until it converges on the correct value). When no estimate is given a default of 10% is assumed.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also