Signature (Visual Basic / VBA)
Public Function Effect( _
ByVal vNominalRate As Variant _
, ByVal vPeriodsPerYear As Variant _
) As Variant
Code Example
Effect(.055, 4) = 0.0561448091821286
Effect(.055, 12) = 0.056407860385536
Effect(.055, 365) = 0.0565362369937314
Parameters
| Parameter | Description |
|---|---|
| vNominalRate | Nominal 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 EffectVerify Subroutine for more examples of this Function. |
| v2.0 Addition | This function is new to this version of Entisoft Tools. |