Excel Forum
Similar Content
RATE Function - Calculate an Interest Rate in Excel
Tutorial: The Rate function in Excel (RATE) calculates the interest rate for a financial transaction...
Remove Spaces Between Text in Excel
Tutorial: How to remove spaces from the middle of text in Excel.  This includes removing all spaces...
Enter a Constant Value in a Defined Name in Excel - Text, Numbers, Formulas, Etc.
Tutorial: In Excel you can store values in Defined Names.  Often people use a Defined Name to refe...



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.