Credit Card Payoff Calculator Excel Tool

Tutorial: How To Use The Credit Card Payoff Calculator / Debt Snowball Calculator

This Excel Based Tool Allows You To Quickly Add Your Debt & Finds The Most Efficent Way To Pay Down Debt As Fast As Possible And Much More!

How To Use The Credit Card Payoff Calculator / Debt Snowball Calculator (Excel)

INSTALLATION & ACTIVATION

1. After placing your order, you'll receive a link to download the Debt Snowball Calculator.  You'll need to click on that link to download the file.

  • Once file has download double click on it.

2.  You will want to click Run and the install will begin.

3.  Next you will be promoted to enter your Activation Token.

  • Your activation token is sent by email once your order has been completed.

  • Note: Activation does require a internet connection (this only required at installation).

4.  After activation is successful, you will need to accept the license agreement.

5.  The install and activation process is complete!  You'll have two options when opening the tool

  • Original Workbook: This pulls up a clean copy of the file.

  • Choose Save..:  If you have saved any copies they can be opened by click here.

GETTING STARTED:

1. Start Date:  Enter the date you plan to starting paying off your debt.  We recommend using the current date or a date in the future.

2. Click The Update Debt Accounts Button:  This will bring up another window, which will allow you to add the credit card(s) and/or any other debt you want to payoff.

Adding Debt Accounts Into Excel Snowball Calculator Template

3.  Adding A Credit Card or Any Other Type of Debt:

  • Debt Account Name:  Here you can enter the name of the account (example "Chase Freedom Credit Card").

  • Debt Account Category:  Select the debt account category that closely fits your debt type.

  • Minimum Payment:  Enter the minimum payment or the installment payment.

    • Note: Use the fixed monthly payment for installment debt (car loans, student loans, personals loans...)

  • Interest Rate (APR) %:  This usually ranges between 3%-29%.

    • Example: If your Interest Rate was 14.99% APR  you will enter 14.99

  • Current Balance:  Enter the current balance of the debt.

4.  Adding Mortgage:

  • Once you select mortgage from the Debt Account Category drop-down. You'll see a new screen popup.

5. Click the Add Account button after you've filled out the all of the information in step 3.

6. Repeat steps 3-4 until you have all of your debt accounts list (limit 8).

7. If you need to change or delete an entry, double click on the line from the list and click delete.

  • Note: If you enter information incorrectly you will need to delete the entry and follow steps 3-4 to add the correct information.

USING THE DASHBOARD

Credit Card Payoff Dashboard

  1. Debt Scenario: All changes can be made here

    • Extra Monthly Payments: Allows you to see the impact of paying more than the minimum payments

    • Dates:  Changing this allows you to see the minimum payment balance vs the projected balance on any given date

  2. Debt Scenario (Preferences):

    • Date Increments: This changes the intervals on the date to allow you see the change month by month or year by year

    • Payment Increments: This changes the increments on "Extra Monthly Payment" ranging from $5 to $500

    • Default Date: Automatically jumps to the 1. First Payment, 2. Last Payment (Projected), and 3. Last Payment (Minimum) as you change the extra payments.