How to calculate effective rate of interest in excel?
Answers
Answered by
4
For example, change the nominal interest rate (APR) in B1 to 6% and the effective interest rate (APY) in B3 changes to 6.17%. Using the EFFECT function in Excel, you can figure out any effective interest rate given any nominal rate and the number of compounding periods in a year.
this is your answer I hope so it can be helpful to you
this is your answer I hope so it can be helpful to you
Similar questions