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. |