calculate-loan

01 Loan payments

Create a Detailed Budget and Debt Plan

Calculator No. 01-25294 · Updated · Formula and assumptions shown below

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

This page helps you create a detailed budget and debt repayment plan by calculating your monthly surplus or deficit based on your income, expenses, and debt payments. You enter your monthly take-home pay, fixed and variable expenses, and any extra debt payment you can make; the calculator shows your remaining cash flow and the total interest you could save by applying that extra amount to your highest-interest debt. The result gives you a clear target for how much you can realistically put toward debt each month.

Formula

The calculator uses two main formulas. First, the monthly surplus is simply income minus expenses minus extra debt payment:

Surplus = p – exp – extra

where p is monthly take-home pay, exp is all non-debt expenses, and extra is the additional amount you pay toward debt beyond the minimum.

For the debt payoff, the calculator assumes you make a fixed total monthly payment equal to the minimum payment on a 10-year term plus your extra amount. The minimum payment is calculated using the standard amortization formula:

Minimum payment = debt × (apr / 1200) / (1 – (1 + apr / 1200) ^ -120)

Then the number of months to pay off the debt is:

Months = ceil( -ln(1 – (apr / 1200) × debt / total_payment) / ln(1 + apr / 1200) )

Total interest is the total payment multiplied by months, minus the original debt balance.

Worked Example

Using the default values: p = $4,000, exp = $2,500, debt = $15,000, apr = 18%, extra = $200.

First, surplus = 4000 – 2500 – 200 = $1,300.

Minimum payment on a 10-year term at 18% APR: r = 18 / 1200 = 0.015. Minimum = 15000 × 0.015 / (1 – (1.015)^-120) ≈ 15000 × 0.015 / (1 – 0.1668) ≈ 225 / 0.8332 ≈ $270.03.

Total payment = 270.03 + 200 = $470.03 per month.

Months to pay off: -ln(1 – 0.015 × 15000 / 470.03) / ln(1.015) = -ln(1 – 0.4787) / 0.01489 = -ln(0.5213) / 0.01489 = 0.6514 / 0.01489 ≈ 43.75, rounded up to 44 months.

Total interest = 470.03 × 44 – 15000 = 20681.32 – 15000 = $5,681.32.

Assumptions

  • All debt is consolidated at one average APR; in reality, multiple debts have different rates.
  • The minimum payment is based on a 10-year amortization; actual minimums vary by lender.
  • Payments are made monthly at the end of each period, and interest compounds monthly.
  • No fees, penalties, or changes in interest rates are included.
  • The extra payment amount is assumed to be constant each month.

How to Use This Budget and Debt Plan

Start by gathering your recent pay stubs, bank statements, and credit card bills. Enter your monthly take-home pay (after taxes and deductions), then list all your regular expenses—rent, groceries, utilities, transportation, insurance, and any discretionary spending. The calculator subtracts those expenses and your extra debt payment from your income to show your surplus. A positive surplus means you have room to allocate more to debt; a negative surplus means you need to cut expenses or increase income before adding extra payments.

For the debt portion, you need your total outstanding balance and the average interest rate across all debts. If you have multiple debts, you can use the highest rate as the apr, or calculate a weighted average. The result shows how many months it will take to pay off the debt if you make the minimum payment plus the extra amount, and the total interest you will pay over that period.

Common Mistakes and Misconceptions

  • Forgetting irregular expenses: Annual insurance premiums, car registration, or holiday gifts are often left out. Add a monthly average for these.
  • Using gross income instead of take-home pay: Your budget must be based on what actually lands in your bank account, not your salary before taxes.
  • Mixing up APR and monthly rate: The calculator expects APR in percent per year; it converts to a monthly rate internally.
  • Ignoring minimum payments on other debts: This calculator assumes all debt is consolidated; if you have separate debts, you must include their minimum payments in your expenses.
  • Thinking the surplus is “extra money” to spend: A surplus is your opportunity to build an emergency fund or accelerate debt payoff, not a license to increase spending.

Strategies for Debt Repayment

Two common approaches are the debt snowball and the debt avalanche. The snowball method focuses on paying off the smallest balance first, which can provide psychological wins. The avalanche method targets the highest interest rate first, which mathematically minimizes total interest paid. Both require you to make minimum payments on all debts and put any extra money toward the chosen one. This calculator can model the avalanche approach by using the highest rate as your apr.

Another strategy is to increase your extra payment over time—for example, applying a yearly raise or bonus to your debt. The calculator assumes a constant extra amount, so you can recalculate with a higher extra to see the impact.

Comparing Scenarios

To compare different budget and debt plans, change one input at a time. For example, if you reduce expenses by $200, your surplus increases by $200, and if you apply that to debt, the months to payoff will drop. You can also compare the effect of a higher extra payment: a $300 extra payment versus $200 will shorten the payoff period and reduce total interest. Use the calculator multiple times to see the trade-off between monthly cash flow and long-term interest savings.

Limitations of This Calculator

This tool provides estimates based on the information you enter. It does not account for variable interest rates, balance transfer fees, late fees, or changes in your income or expenses. It also assumes you make the same payment every month until the debt is gone. Real life often includes unexpected costs; a detailed budget should include a buffer for emergencies. The result is an estimate, and your lender’s disclosure gives the exact figures for your specific loans.

Frequently Asked Questions

How do I calculate my average interest rate if I have multiple debts?

Multiply each debt balance by its APR, sum those products, then divide by the total balance. For example, a $5,000 card at 20% and a $10,000 loan at 10% gives (5000×0.20 + 10000×0.10) / 15000 = (1000 + 1000) / 15000 = 0.1333, or 13.33%.

Should I use the snowball or avalanche method?

The avalanche method saves more money in interest because it targets the highest rate first. The snowball method may be more motivating for some people because it produces quick wins. Choose the one you are more likely to stick with; the best plan is the one you actually follow.

What if my surplus is negative?

A negative surplus means your expenses exceed your income. You need to either reduce expenses, increase income, or both. Even a small reduction in discretionary spending can create room for debt payments. Consider tracking every expense for a month to see where money goes.

How much should I put toward debt versus savings?

Many financial educators suggest building a small emergency fund of $500 to $1,000 first, then focusing on high-interest debt. Once debt is under control, you can build a larger emergency fund of 3–6 months of expenses. This calculator does not include savings, so you can adjust your expense input to include a monthly savings contribution.

Does making extra payments reduce my total interest?

Yes, because extra payments reduce the principal balance faster, so less interest accrues over time. The calculator shows this by comparing the total interest with and without the extra amount. For the default example, without the extra payment (minimum only), you would pay 120 months of $270.03, totaling $32,403.60, with interest of $17,403.60. With the extra $200, you pay $5,681.32 in interest—a significant saving.

Remember, this calculator provides estimates for educational purposes. Your actual loan terms and lender disclosures will give the exact figures.

Related

Formula used
in p | Monthly take-home pay | $ | 4000 | 0 | 1000000
in exp | Total monthly expenses (excluding debt payments) | $ | 2500 | 0 | 1000000
in debt | Current total debt balance | $ | 15000 | 0 | 10000000
in apr | Average interest rate on debt (APR) | % | 18 | 0.01 | 100
in extra | Extra monthly payment toward debt | $ | 200 | 0 | 100000
out surplus | Monthly surplus/deficit | $ | p - exp - extra | 2
out months | Months to pay off debt | months | ceil(round(-ln(1 - (apr / 1200) * debt / (debt * (apr / 1200) / (1 - (1 + apr / 1200) ^ -120) + extra)) / ln(1 + apr / 1200), 6)) | 0
out total_int | Total interest paid | $ | (debt * (apr / 1200) / (1 - (1 + apr / 1200) ^ -120) + extra) * months - debt | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →