Sunday, July 15, 2007

Loan Amortization Tutorial Added

For some reason, I get quite a few requests for amortization schedules, so I have created a new loan amortization schedule tutorial and posted it to my Excel tutorials. It starts out by describing in detail how to amortize a loan using formulas, moves into using the IPMT and PPMT functions, and then creates a full amortization schedule. At the end, I made it a bit fancier by adding IF statements, conditional formatting, and charts.

You can access the tutorial at this link.

I also created a tutorial for the TI 83, TI 83 Plus, and TI 84 Plus calculators. One of the cool things about

Continue reading...