Expense-to-Income Ratio
Calculate what percentage of your income goes to expenses - a quick way to see where your money is going.
=total_expenses / total_income How It Works
The expense-to-income ratio shows what fraction of your income goes to spending. It’s the flip side of your savings rate - if your expense ratio is 80%, your savings rate is 20%.
Syntax
=total_expenses / total_incomeFormat result as percentage.
Example
Monthly Numbers:
- Gross Income: $6,000
- Total Expenses: $4,800
Formula: =4800/6000
Result: 80% expense-to-income ratio
This means 20% of income is available for saving or investing.
Expense Ratio Benchmarks
| Ratio | Interpretation |
|---|---|
| Under 50% | Very lean - significant room for saving |
| 50-70% | Healthy - solid balance between spending and saving |
| 70-85% | Typical - some room to optimize |
| 85-95% | Tight - limited buffer for unexpected costs |
| Over 95% | Worth reviewing - very little margin |
Variations
By Category
Breaking expenses into categories shows where the money actually goes:
=category_expenses / total_income| Category | Amount | % of Income |
|---|---|---|
| Housing | $1,800 | =1800/6000 (30%) |
| Transportation | $600 | =600/6000 (10%) |
| Food | $500 | =500/6000 (8%) |
| Insurance | $400 | =400/6000 (7%) |
| Utilities | $300 | =300/6000 (5%) |
| Discretionary | $1,200 | =1200/6000 (20%) |
| Total | $4,800 | 80% |
Net Income Version
Using take-home pay instead of gross income:
=total_expenses / net_incomeThis version can exceed 100% if you’re dipping into savings - useful to know.
Setting Up an Expense Ratio Tracker
| A | B | C |
|---|---|---|
| Income | $6,000 | |
| Expenses | ||
| Housing | $1,800 | =B3/B1 |
| Transport | $600 | =B4/B1 |
| Food | $500 | =B5/B1 |
| Other | $1,900 | =B6/B1 |
| Total Expenses | =SUM(B3:B6) | =B7/B1 |
Pro Tips
-
Track monthly - one month can be misleading, so a 3-month average gives a clearer picture
-
Use gross income for comparisons - most published benchmarks reference gross income
-
Separate fixed vs variable - fixed expenses are harder to change, so focus optimization on variable ones
-
Pair with category tracking - the overall ratio tells you the total, categories tell you the story
Common Errors
- Mixing gross and net income - pick one and stay consistent
- Missing irregular expenses - annual subscriptions, insurance premiums, and quarterly bills add up
- Excluding debt payments - loan and credit card payments are expenses in this context