Video Instructions

Amortization Schedule Assignment
Total Time - 8 min 32 sec

Part 1 (1 min 43 secs) - Enter Headings, enlarge column, PMT function
Part 2 (1 min 1 sec) - Format currency, percent, decimals, Enter Headings
Part 3 (1 min 11 secs) - Create formulas for first payment
Part 4 (2 mins 8 secs) - Copy formulas, Change to Absolute Reference
Part 5 (1 min 5 secs) - Copy correct forlulas down - fat cross, thin cross
Part 6 (1 min 24 secs) - Save file as AMORT, Analyze car payment, payoff

To view the videos, you may need to download the