EFFECT(R, P)

 

Description

This function returns the effective annual interest rate.

 

Parameters

 

R

Nominal rate.

 

P

Number of compounding periods per year.

 

Examples

 

EFFECT(6.75%, 5) = 0.06935