Function Math Financial Class

Nominal

Calculates the nominal annual interest rate, given the effective annual interest rate and the number of compounding periods per year.

Signature (Visual Basic / VBA)

Public Function Nominal( _
      ByVal vEffectiveRate As Variant _
    , ByVal vPeriodsPerYear As Variant _
    ) As Variant

Code Example

    Nominal(.055,   4) = 0.0539006977649699
    Nominal(.055,  12) = 0.0536603870045163
    Nominal(.055, 365) = 0.0535446939881523

Parameters

Parameter Description
vEffectiveRate Effective annual interest rate. Must be greater than zero (>0), otherwise this function returns Null.
vPeriodsPerYear Number of compounding periods per year. vPeriodsPerYear is truncated to an integer number, and the result must be greater than or equal to one (>=1), otherwise this function will return Null.

Notes & Version History

Details See the NominalVerify Subroutine for more examples of this Function.
v2.0 Addition This function is new to this version of Entisoft Tools.