# How To Make Your Own Debt Management Plan Calculator on MS Excel

Here are the steps in making a DMP calculator using MS Excel:

1. Open a new worksheet on MS-Excel. On Cell A1, type in “Balance” and on Cell B1, type “Payments”.
2. On Cell C1, type in “Interest Rate” and on D1, type in “Remaining Balance”.
3. Try putting in some numbers.  Try to type in “5000” for \$5,000 under “Balance”. Under Payment, type in “100” which stands for \$100 a month as payment, type in “.18” for 18 percent under Interest Rate.
4. Now, under “Remaining Balance”, you should type in an equation.  For this example, the equation should look like this:

=A2-B2+A2*(C2/12)

Now, this means to say that when you pay \$100, you only have taken off \$25.

You should take note that the Cells on your equation are not to be type but, rather, to be anchored.  That way, no matter how you change the data on the cells, the equation and the result should stay the same.

5. On the next row, your Remaining Balance should reflect on it. In this case, if the 1st balance is on A2, then, the next one should be on A3 by typing in this equation:

=D2

6. Below “Payment” on the next row, instead of typing “100”, make this equation:

=C2

And this is also true with the next row under “Interest Rate” and copy Cell D2 to Cell D3

7. Now that you have the equations in place, all you need to do is to drag Cells A3 to D3 all the way down.  All of the numbers will be carried over down the worksheet.  Drag down until you get a negative number as Balance or “0”.  This way, you can tell your remaining balance.

8. If you get the sum of all \$100 that you have paid, you will see how much you have paid totally against the first balance.  In this example, you should be able to sum up all \$100 to around \$9,000 minus your balance of \$5,000. That means, you have paid an interest of, at least, \$4000.

It’s really easy to find a debt management plan calculator.  If you can’t, you now have an idea on how to make one.