Excel Forum

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.