Sub Math Financial Class

InternalRateOfReturnVerify

Signature (Visual Basic / VBA)

Private Sub InternalRateOfReturnVerify()
    'Verify that the InternalRateOfReturn function works correctly.

    Const Epsilon = 0.000000000001 ' 1E-12

    Debug.Assert Approx(InternalRateOfReturn(Array(-4000, 500, 5000)), 0.182279554197971, Epsilon)
    Debug.Assert Approx(InternalRateOfReturn(Array(4000, -500, -5000)), 0.182279554197953, Epsilon)
    
End Sub