track balance based on payments in Excel
 

I want to enter all of my debt (credit cards, student loans, car loans, etc.)
into a spreadsheet. Then I want to include interest rates and minimum
monthyly payments. I want to then set up a formula so that I can track the
balances out 5, 10, or 20 years in order to see their projected balance
decreases over time.