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...
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 Macros Class 2 - Getting and Outputting Data - Workbook Included
Tutorial: Macro Class 2 - Covering how to get data from a spreadsheet, do something with that data,...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.