How can I set up a debt reduction plan?

[d_mcclure]

I want to set up a spreadsheet where I can track my debt reduction. I want
to be able to put in the balance owed, the interest rate, payment amount
(that can be changed). I want to be able to have all my debt on one
spreadsheet and show progress on each individual debt as well as on the debt
as a whole. I have seen software you can buy that does this but I am sure
that you can do it in Excel somehow. Excel 2000 or later.

[MWE]

check out the "PV" (present value) worksheet function. It should get you going.

[Sareimer]

This will amortize debt in total. If you're Excel Saavy you'll be able to modify to meet your needs.