A Step-by-Step Debt Consolidation Worksheet: A Probably Funding Guide

Why Probably Funding recommends a worksheet before any offer

A worksheet turns a vague feeling of being behind into a handful of numbers you can compare. It tells you which debts are worth consolidating, what you pay now, and the exact loan terms that would leave you better off.

When I was a nonprofit credit counselor in Ohio, the first thing I handed every client was a blank sheet with seven columns. Not a brochure, not a product. Just the sheet. About a third of the people who filled it out discovered they did not need a loan at all; they needed to reorder their payments. Another third found that a consolidation personal loan would save them real money. The rest learned they needed a different kind of help first.

All three outcomes are useful, and you cannot know which is yours until the numbers are on paper. That is why Probably Funding suggests doing this before you request offers. A lender will show you a personal loan rate. Only your worksheet can tell you whether that rate helps.

You need about 30 minutes, your most recent statements, a calculator and a pencil or a spreadsheet. To make each step concrete, we will fill in a worksheet for Luis, a line cook in Toledo who earns $3,900 a month before taxes and carries three credit cards, a medical bill and a car loan.

Step 1: List every debt with its real numbers

Write down each debt's name, current balance, APR and minimum payment, pulled from your latest statement. Include everything, even debts you will not consolidate, because personal loan lenders see all of them.

Use statements, not memory. Every worksheet Probably Funding has seen go wrong started with a guessed balance. People routinely underestimate card balances by a few hundred dollars and forget APRs entirely. If a card has several rates, such as one for purchases and one for a past balance transfer, list the rate that applies to most of the balance and make a note.

Here is Luis's completed list. The last column is where the worksheet starts earning its keep.

The monthly interest column is a quick estimate, not what the statement will show to the penny, since issuers use daily balances. It is close enough to show where the money leaks. Luis's three cards cost him about $96 a month in interest alone. His car loan charges roughly $54, but on a balance nearly twice as large, at a rate a fraction as high.

Step 2: Decide which debts belong in a consolidation personal loan

Consolidate only debts with rates higher than the loan you are likely to get. Leave 0% plans and low-rate installment loans alone, because rolling them into a personal loan would raise their cost.

This is the step people skip, and it is the one that saves the most. A consolidation personal loan is useful when it replaces expensive debt with cheaper debt. It is harmful when it replaces cheap debt with more expensive debt.

For Luis, the three cards clearly qualify. Their rates run from 23.99% to 29.99%. The hospital payment plan charges nothing, so moving it into any personal loan would add interest to a bill that currently has none. The car loan at 7.9% is almost certainly cheaper than any personal loan he would be offered, and it is secured by the car, which is a different arrangement entirely.

So Luis's consolidation target is $650 + $2,400 + $1,350 = $4,400. That fits comfortably inside the $500 to $5,000 range that Probably Funding loans requests cover. If your target is larger than that, rank the eligible debts by APR and consolidate from the top down until you hit the limit.

Step 3: Calculate your blended APR and current monthly cost

Multiply each balance by its APR, add those products, and divide by the total balance. That blended APR is the number any personal loan offer has to beat, after fees.

For Luis:

• $650 × 29.99% = $194.94
• $2,400 × 26.49% = $635.76
• $1,350 × 23.99% = $323.87
• Sum: $1,154.57, divided by $4,400 = about 26.2% blended APR

Next, write down what Luis actually pays each month on these three cards, not just the minimums. His minimums total $143, but he has been sending $180 a month in total, putting the extra toward the Visa. At $180 a month and a 26.2% blended rate, the cards would be paid off in about 36 months, with roughly $1,964 in interest.

For comparison, if Luis dropped to minimums only, the cards would take well over 15 years to clear and cost more than $8,000 in interest, since card minimums shrink as the balance falls. That line on the worksheet tends to get people's attention. It got Luis's.

Note both figures on your sheet: current payment and current path. The consolidation question becomes simple. Does a personal loan beat the path you are really on?

Step 4: Check your debt-to-income ratio the way a lender will

Add all monthly debt payments plus rent or mortgage and divide by gross monthly income. Many lenders get cautious above roughly 40%, so knowing your number helps you predict the kind of offers you may see.

Your debt-to-income ratio is one of the first things a lender reviews. For Luis, monthly obligations are rent of $1,050, card minimums of $143, the hospital plan at $50 and the car at $265, for a total of $1,508. Divided by $3,900 in gross income, his ratio is about 38.7%.

That is workable but not roomy. It tells Luis two things. First, he should expect offers in the middle of the APR range rather than the lowest advertised rates. Second, a consolidation personal loan should not push his ratio up much. Replacing $143 in card minimums with a payment around $170 to $190 would nudge his ratio to roughly 39% to 40%, which most lenders consider alongside the fact that the cards are being paid off.

If your ratio is well above 45%, a personal loan may be hard to get at a helpful rate. That is useful to know before you apply through Probably Funding or anywhere else, and it may point you toward a nonprofit debt management plan instead. The eligibility page covers the other basics lenders look at, such as income stability and an active checking account.

Step 5: Write each personal loan offer in the same format

For every offer, record the loan amount, APR, origination fee, amount you would actually receive, term, monthly payment and total of payments. Compare by APR and total cost, never by interest rate or payment alone.

Once your worksheet has a target and a benchmark, you can request personal loan offers. Filling in the Probably Funding apply online form once is enough to reach participating lenders, and preliminary offers usually follow a soft credit check that your score never registers. Suppose Luis receives two personal loan offers through his Probably Funding loans request:

Offer A: lower rate, with a fee

• Loan amount $4,600, interest rate 18.5%, origination fee 4% ($184)
• Amount received after the fee: $4,416, enough to clear $4,400 in cards
• 30 months at about $192.67 a month; total of payments about $5,780
• APR including the fee: about 22.0%
• True cost: $5,780 repaid minus $4,416 received = about $1,364

Offer B: higher rate, no fee

• Loan amount $4,400, APR 21%, no origination fee
• 30 months at about $189.77 a month; total of payments about $5,693
• True cost: about $1,293 in interest
• Also offered over 36 months at about $165.77 a month, costing about $1,568

Here is the lesson Probably Funding would put on a sticky note: the offer with the lower interest rate is the more expensive one. Offer A advertises 18.5%, but its fee lifts the APR to about 22%, above Offer B's 21%. Every personal loan disclosure shows the APR for exactly this reason. If you only compared interest rates, you would choose wrong.

Step 6: Compare offers against your current path

Put three numbers side by side for each option: monthly payment, months to debt-free and total cost. A consolidation personal loan is worth taking when it wins on total cost without a payment you cannot carry.

Luis's worksheet now shows his choices clearly:

• Keep paying cards at $180: 36 months, about $1,964 in interest.
• Offer A, 30 months: $192.67 a month, 30 months, about $1,364 in total cost. Saves about $600.
• Offer B, 30 months: $189.77 a month, 30 months, about $1,293. Saves about $671.
• Offer B, 36 months: $165.77 a month, 36 months, about $1,568. Saves about $396 and lowers his monthly outlay by about $14.

Each option beats his current path, which is exactly the result Probably Funding hopes a worksheet will show. The question becomes which trade he prefers. Offer B at 30 months saves the most but raises his payment by about $10. Offer B at 36 months saves less but frees up $14 a month for his emergency fund. Neither is wrong. Luis picks the 30-month version, reasoning that a $10 stretch for two and a half years is worth $275 more in savings compared with the longer term.

You can model other terms with the personal loan calculator. If your consolidation target lands near $4,000, the $4,000 personal loan page has sample payment tables to sanity-check any offer you receive.

Step 7: Write your after-funding plan on the same page

Before you sign, decide how the cards will be paid off, what happens to them afterward, and where the monthly savings will go. Consolidation only works if the old balances stay at zero.

In nine years of counseling, the worksheets that ended well all had something written at the bottom. Not a feeling, a plan. Luis wrote four lines:

1. Ask the lender to pay the card issuers directly if offered; otherwise pay all three cards the same day the deposit posts, since fast personal loan funding only helps if the money goes straight to the balances.
2. Close the store card, which he rarely used. Keep the Visa and Mastercard open to protect his credit history, but remove them from his phone wallet.
3. Set autopay for the personal loan on the 3rd, two days after his paycheck lands on the 1st.
4. When the hospital plan is paid off in 18 months, move that $50 into savings rather than spending it.

That last line matters more than it looks. A consolidation personal loan gets you out of expensive debt. An emergency fund keeps you from needing it again. Even $50 a month becomes $600 by the end of a year, which covers a surprise tire or a copay without a card.

If any line on your plan feels shaky, especially the second, pause. Refilling the cards after consolidating is the most common way this strategy backfires, and it leaves people with the personal loan payment and the card payments together.

Your blank worksheet, ready to copy

Copy these headings onto paper or a spreadsheet: debt, balance, APR, minimum, monthly interest, consolidate yes or no. Then add your blended APR, current payment, current path, debt-to-income ratio, and one line per offer.

Here is the full structure Probably Funding suggests, in the order you fill it out:

• Section 1, debts: name, balance, APR, minimum, monthly interest, consolidate yes or no
• Section 2, target: total of the "yes" balances, blended APR, what you actually pay now, months and interest on your current path
• Section 3, ratio: gross monthly income, total monthly obligations, debt-to-income percentage
• Section 4, offers: amount, APR, fee, amount received, term, payment, total of payments, true cost
• Section 5, plan: payoff method, what happens to the cards, autopay date, where the savings go

Once it is complete, you will know whether to request personal loan offers, which ones to take seriously and what a good deal looks like for you. That is more than most people know when they first sit down with a lender. Bring it with you when you open the Probably Funding apply online form.

Probably Funding is a free connector service, not a lender. Participating lenders review your credit and set every rate and term, and an offer is likely for many profiles but never promised. If you are ready, our overview of debt consolidation loans explains what to expect from a Probably Funding personal loan request, including how long offers take and how some lenders pay creditors directly. Bring your worksheet. It will do most of the thinking for you, and fast personal loan funding means very little unless the loan is the right one.

Related posts

Can a Personal Loan Lower My Monthly Credit Card Payments?

A consolidation loan does not always shrink the monthly bill, but it usually shrinks the total cost. Here is how to tell which applies to you.

Read the guide →

How Lenders Read Your Debt-to-Income Ratio

Your DTI is monthly debt payments divided by gross income. See the ranges lenders like, what counts, and how consolidation shifts the number.

Read the guide →