How to calculate credit utilization
For one account, divide its balance by its credit limit, then multiply by 100. For the entered accounts combined, add the balances, add the limits, and divide the balance total by the limit total.
Credit utilization (%) = total entered balances ÷ total entered limits × 100.
For example, a balance of USD 900 against a USD 1,000 limit gives 90%. A second account with USD 900 against a USD 9,000 limit gives 10%. Combined utilization is USD 1,800 ÷ USD 10,000 = 18%. The simple average of 90% and 10% is 50%, which gives the smaller and larger limits the same weight.
Current balances and reported balances
Use comparable balances and limits for the question you are answering. A current balance can differ from the balance an issuer supplied to a credit bureau. Select the basis of your entries so the result labels it clearly. The calculator works with the figures you supply.
FICO explains that a credit report can show a previously reported balance even after your current balance changes. Credit scores also consider information beyond utilization. This worksheet measures the entered ratio.
How much would balances need to fall to reach a target?
Choose a target percentage. Multiply the combined limit by that percentage as a decimal, then round the maximum allowed balance down to a whole cent. If the entered balance is higher, the difference is the smallest reduction in whole cents that reaches the combined target under unchanged limits.
In the 18% example, a 15% target allows a combined balance of USD 1,500. The combined reduction is USD 300. If every account must individually reach 15%, the first needs a reduction of USD 750 and the second already meets the target. Those calculations answer different questions.
Rounding matters near a target. USD 1.00 against a USD 3.00 limit is about 33.33%, but the exact ratio is above an exact 33.33% target. Reducing the balance to USD 0.99 gives 33%. The calculation holds credit limits fixed and uses no new transactions, fees or interest.
Known limits and values over 100%
Enter a positive known limit for each account. A zero balance with a positive limit gives 0%. A balance above its entered limit gives a rate above 100%. A line with an unknown limit cannot contribute a defined denominator to this worksheet.
What a shared result contains
The worksheet calculates in your browser. If you choose to share, the link contains the combined balance and limit, balance basis, currency and optional target. Individual rows and account labels stay out of the link. Anyone who opens it can read those totals. You can copy a summary without creating a public link.
See FICO's guide to amounts owed and reported balances and the CFPB's credit-score guide. For payment and interest scenarios, use the Credit Cards Payoff Calculator.