Excel Forum



Excel Finance Class 28: Relationship Between APR, Period Rate and Effective Annual Rate


Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate) and Period Rate. Learn how to solve for any one of these using math formulas or the Excel functions: EFFECT, NOMINAL and the period rate formula.





Got a Question? Ask it Here in the Forum.