Excel Forum
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 Magic Trick 623: PayDay LoansAre Bad Finance -- APR & EAR & Amortization Table


Learn how to see the painful near-extortion that Pay Day Loans inflict on people using Excel. Learn how to calculate APR (Annual Percentage Rate), EAR (Effective Annual Rate), an Amortization Table and the EAR for a loan that takes a fee out up front. Learn Excel financial formulas and see the EFFECT and RATE functions.

In this video the Excel is beautiful but the financial havoc that Pay Day Loans inflict can be painful!





Got a Question? Ask it Here in the Forum.