Lending Logic Lab Credit Utilization Tracker

Category: Personal Loans (also applies to Mortgage Refinancing, Home Equity Loans, and Business Loans)

Resource type: Tracker


What This Tracker Answers

How much of your available revolving credit are you using, and what is the cheapest way to bring that number down before you apply for a loan? Credit utilization is one of the most influential factors in many credit scoring models, and it is also one of the fastest to change. This tracker shows you how to measure it, set a target, and follow your progress month by month.


The Formulas

Step 1: Per-card utilization

Card Utilization = Card Balance ÷ Card Credit Limit

Step 2: Overall utilization

Overall Utilization = Total Balances on All Cards ÷ Total Credit Limits on All Cards

Scoring models typically look at both the overall figure and the individual card figures, so a single maxed-out card can hurt even when your overall ratio looks fine.

Step 3: Paydown needed to reach a target

Target Balance = Credit Limit × Target %

Paydown Needed = Current Balance − Target Balance

Run this for each card and for the total.

Step 4: Effect of a limit change

New Utilization = Total Balances ÷ (Total Limits + Limit Increase)

Step 5: Effect of closing a card

Utilization After Closing = (Total Balances − Balance on Closed Card) ÷ (Total Limits − Limit of Closed Card)

Closing a card with a zero balance raises your utilization, because its limit disappears from the denominator.

Step 6: Interest saved by paying down

Monthly Interest Saved = Paydown × (Card APR ÷ 12)


Worked Example

The scenario

A borrower plans to apply for a personal loan in three months.

Card Balance Limit Utilization APR
Card A $2,400 $5,000 48% 22%
Card B $1,200 $8,000 15% 19%
Card C $1,700 $2,000 85% 26%
Total $5,300 $15,000 35.3%

Reading the result: The overall ratio of 35.3% looks moderate, but Card C at 85% is a red flag on its own.

Step 1: Paydown needed at two targets

Target: 30% overall

  • Target balance: $15,000 × 0.30 = $4,500
  • Paydown: $5,300 − $4,500 = $800

Target: 10% overall

  • Target balance: $15,000 × 0.10 = $1,500
  • Paydown: $5,300 − $1,500 = $3,800

Step 2: Get every card under 30%

Card Balance 30% of Limit Paydown Needed
Card A $2,400 $1,500 $900
Card B $1,200 $2,400 $0 (already under)
Card C $1,700 $600 $1,100
Total $2,000

After paying $2,000, balances are $1,500 + $1,200 + $600 = $3,300, so overall utilization is $3,300 ÷ $15,000 = 22%.

Step 3: The budget version

If you can only pay down $1,100, put it all on Card C:

  • Card C: $600 ÷ $2,000 = 30%
  • Total balances: $4,200, so overall utilization is $4,200 ÷ $15,000 = 28%

Reading the result: The $1,100 payment fixes both the worst single card and the overall ratio. It also targets the highest APR first, saving about $1,100 × (0.26 ÷ 12) ≈ $24 per month in interest.


What-If Scenarios

Using the original balances ($5,300 total):

Scenario New Balances New Limits Utilization
Starting point $5,300 $15,000 35.3%
Pay $1,100 on Card C $4,200 $15,000 28.0%
Pay all $2,000 to reach 30% per card $3,300 $15,000 22.0%
Card A limit raised to $7,500 $5,300 $17,500 30.3%
Close Card B (a $8,000 limit) $4,100 $7,000 58.6%

The takeaway: Closing an old card with a low balance can sharply raise your utilization, so avoid it right before applying for a loan. A limit increase helps only if you don't spend into the new room.


Timing: When Your Balance Gets Reported

Card issuers generally report your balance to the credit bureaus around your statement closing date, not your payment due date. That means:

  • You can pay in full every month and still show high utilization if your balance is large on the statement date.
  • To lower the reported figure, pay down before the statement closes.
  • Multiple smaller payments during the month keep the statement balance low.

The Monthly Tracker

Fill this in on the same day each month, ideally just after each statement closes.

Line Item Month 0 Month 1 Month 2 Month 3
A Card A balance $2,400
B Card B balance $1,200
C Card C balance $1,700
D Total balances (A + B + C) $5,300
E Total limits $15,000
F Overall utilization (D ÷ E) 35.3%
G Highest single-card utilization 85%
H Target utilization 30%
I Paydown still needed $800
J Payment made this month
K Statement closing dates noted? Yes / No

How Lenders Generally View Utilization

Utilization What it generally suggests
0% to 9% Excellent; often associated with the strongest scores
10% to 29% Good; widely cited as a healthy range
30% to 49% Fair; may be costing you some points
50% to 74% High; likely a drag on your score
75% and above Very high; can signal strain to lenders

These ranges are rules of thumb, not official score cutoffs. Scoring models differ, and a score depends on many factors besides utilization. Lending Logic Lab provides educational information, not personalized financial advice.


How Utilization Connects to Your Loan Application

  • Credit score: A lower ratio can improve the score a lender sees, which can mean a lower rate.
  • DTI: Paying down cards lowers your minimum payments. Run the DTI Headroom Test to see how much room it creates.
  • Personal loan consolidation: If you use a personal loan to pay off cards, utilization drops sharply. The risk is running the cards back up, which leaves you with the loan and the balances. Consider keeping the cards open but unused, or locking them away.

Common Mistakes

  • Watching only the overall ratio. A single card near its limit can still hurt.
  • Paying only after the statement closes. The reported balance may already be high.
  • Closing old cards. You lose the limit and may raise your utilization.
  • Spending into a new limit. A higher limit helps only if the balance stays flat.
  • Paying down the low-rate card first. Target the highest-utilization and highest-APR cards first.
  • Assuming this fixes everything. Payment history, account age, and recent applications also matter.

Reader Checklist Before You Apply

  • List every card with its balance, limit, APR, and statement closing date
  • Calculate each card's ratio and your overall ratio
  • Set a target (30% as a minimum, under 10% if you can)
  • Calculate the paydown needed for each card
  • Pay the highest-utilization, highest-APR card first
  • Make payments before the statement closes
  • Re-run the tracker monthly until you apply
  • Avoid opening or closing cards in the weeks before applying

Lending Logic Lab provides educational information, not personalized financial advice. Confirm your figures with your lender.

Post a Comment

0 Comments