Net worth is one line: assets minus liabilities. It's easy to calculate and easy to trust too much, because a single number can't tell you how leveraged the underlying balance sheet actually is. Debt-to-asset ratio fixes that, and it takes about ten minutes to build a spreadsheet that calculates it correctly and keeps updating as your numbers change.
The formula
Debt-to-asset ratio is total liabilities divided by total assets, expressed as a percentage.
debt_to_asset_ratio = total_liabilities / total_assets
That's the whole formula. The work is in building an accurate list of both sides, which is where most people's first attempt at this goes wrong.
Step 1: List every asset with its current fair value, not what you paid
Open a new sheet with three columns: Asset, Category, Value. List everything: checking and savings balances, brokerage accounts, retirement accounts, home value (use a recent estimate, not the purchase price), vehicles at current resale value, and any other significant property. Undervaluing or overvaluing any one asset skews the ratio more than people expect, especially with a house, since purchase price and current market value can be far apart after a few years.
Step 2: List every liability at its current balance
Second sheet or a second block: Liability, Category, Balance. Mortgage principal remaining (not the original loan amount), auto loans, student loans, credit card balances, any personal loans. Use current statement balances, not original amounts borrowed.
Step 3: Sum each side and divide
=SUM(assets_range)
=SUM(liabilities_range)
=liabilities_total / assets_total
Format the result cell as a percentage. A ratio under 30% is generally considered low leverage, 30 to 50% is moderate, and above 50% means more than half of what you technically "own" is actually still owed to someone else. None of these are hard rules, but they're useful reference points.
Step 4: Add a liquidity ratio column while you're at it
Since you already have the asset list broken into categories, tag each asset as liquid (cash, savings, taxable brokerage) or illiquid (retirement accounts, home equity, vehicles), then sum the liquid ones and divide by total net worth. This gives you a second ratio in the same spreadsheet with almost no extra work, and it answers a different question than debt-to-asset ratio does: not how leveraged you are, but how much of what you own you could actually access quickly.
=liquid_assets_total / (assets_total - liabilities_total)
Why both ratios together matter more than either alone
A low debt-to-asset ratio with a low liquidity ratio still leaves you exposed, just to a different kind of risk. You're not over-leveraged, but you also can't get to your money fast if something goes wrong. A breakdown of why identical net worth totals can hide very different financial risk walks through a side-by-side example of two people with the same net worth and opposite ratio profiles, which makes the practical difference a lot more concrete than the formulas alone.
Step 5: Add conditional formatting so the ratio flags itself
This is optional but worth the extra two minutes. Add a conditional format rule on the debt-to-asset ratio cell: green under 30%, yellow 30 to 50%, red above 50%. Same thing on the liquidity ratio cell, just inverted, since you want that one to be higher rather than lower. This turns a spreadsheet you'd otherwise only check when you remember into one that gives you a visual signal the moment you update a number, which matters more than it sounds like it should. Most people who build a "just check it manually" spreadsheet stop checking it manually within a couple of months.
Common mistakes when building this the first time
The most common one is forgetting to update the mortgage balance from the original loan amount to the current remaining principal. It's an easy field to set once and never touch again, and a few years into a 30 year mortgage the difference between original balance and current balance can be tens of thousands of dollars, which meaningfully understates your actual equity and overstates your debt-to-asset ratio.
The second common mistake is leaving retirement accounts out of the liquid/illiquid split entirely and just lumping them into "assets" without a category tag. That defeats the point of building the liquidity ratio column in the first place, since the whole reason to tag categories is to be able to filter and sum by liquid status later without redoing the list from scratch.
Skipping the spreadsheet
If building and maintaining the spreadsheet isn't something you want to keep up with quarter over quarter, a free net worth tracker by EvvyTools runs both calculations automatically. You enter assets and liabilities by category once, and it recalculates net worth, debt-to-asset ratio, and liquidity ratio every time you update a number, plus a percentile ranking by age bracket if you want that context too.
The manual spreadsheet version is worth building at least once even if you end up using a tool afterward, because writing the formula yourself makes it obvious how sensitive the ratio is to how you value illiquid assets like a house or a business. Small changes in how you estimate home value can move the debt-to-asset ratio by several percentage points, which is a good reminder to update those estimates periodically rather than treating them as fixed.
A source worth bookmarking
If you want to sanity check your ratio against national data, the Federal Reserve's Survey of Consumer Finances publishes household balance sheet statistics broken out by age and income bracket, and Investor.gov has a solid plain-language primer on liquidity and leverage if either term needs more context before you build this out for your own numbers. If you want a plain explainer of leverage as a finance concept before applying it to your own spreadsheet, Investopedia covers the underlying concept in more depth than most calculators bother to explain.
Extending it further: per-asset leverage instead of just the aggregate
Once the basic version is working, a useful next step is calculating leverage per asset rather than just in aggregate. Link each liability to a specific asset column (mortgage to the house, auto loan to the car) and calculate a per-asset ratio: that liability divided by that asset's value. This surfaces something the aggregate ratio hides, namely that most households carry almost all of their leverage in one or two places, usually the mortgage, while everything else is close to unleveraged. Knowing that concentration matters if you're ever deciding where to focus extra debt paydown, since the aggregate number alone doesn't tell you which asset the risk is actually sitting in.
=house_liability / house_value
=vehicle_liability / vehicle_value
This adds maybe five minutes to the initial build and gives you a genuinely more useful diagnostic than the single aggregate ratio, especially if your assets include anything beyond a primary residence, like a rental property or a business.
Once the spreadsheet exists, updating it quarterly takes a couple of minutes, and it catches the kind of leverage creep that a single net worth number never will.
A last note on keeping the sheet accurate over time
Set a recurring calendar reminder to update the numbers, quarterly is usually enough, since a spreadsheet with stale balances is barely better than not having one at all. The value of this exercise comes entirely from the numbers being current. An accurate ratio from six months ago tells you very little about your leverage today, especially if home values or account balances have moved meaningfully in either direction since the last update.
Top comments (0)