Effective Rate of Return in Excel

Originally published at: Effective Rate of Return in Excel - Excelbuddy.com

Learn how to calculate the effective rate of return in Excel. The Effective Annual Return (EAR) is the annual rate per year of an investment taking into consideration compounding periods. Some investments compound monthly, quarterly, or annually. If you have ever opened up a newspaper or watched a TV commercial, chances are you have seen…