Bookmarks    
nPr and nCr    
Random Number    
SD Calculator    
Sample Size    
Percent Error    
Density    
Molarity    
Molar Mass    
Ohm's Law    
Watts to Amps    
Voltage Drop    
Long Division    
Mixed Numbers    
Rounding    
Nth Root    
Exponents    
Half-Life    
Polar Form    
De Moivre    
3D Distance    
Point to Line    
Cross Product    
Determinant    
Sin Cos Tan    
Triangle Area    
Scale Factor    
Sector Area    
Ellipse Area    
Cube Volume    
Box Volume    
Sphere Volume    
Cone Volume    
Pipe Volume    
Time Duration    
Time Card    
Present Value    
Future Value    
Churn Rate    
A/B Test Calc    
SEO Traffic    
Ideal Weight    
Fat Intake    
Child Height    
Golf Handicap    
Heat Index    
Wind Chill    
Dew Point    
Download Time    
kWh to Cost    
AC Size (BTU)    
Heating Costs    
LED Savings    
Trip Gas Cost    
Tire Size    
Solar Output    
Solar Payback    
Battery Size    
Wall Area    
Gravel Needed    
Mortar Mix    
Slope Grade    
Curtain Size    
Soil Needed    
Sod Needed    
Ramp Length    
Blind Size    
Drain Slope    
Board Feet    
Heat Loss    
Furniture Fit    
Moving Boxes    
Plywood Cuts    
Shelf Sag    
   Add
Probability and random number calculators
Independent Events
Independent Events
Two Events Solver
Two Events Solver
Repeated Trials
Repeated Trials
Bayes' Theorem
Bayes' Theorem
Expected Value
Expected Value
Binomial Distribution
Binomial Distribution
nPr and nCr
nPr and nCr
Circular Permutation
Circular Permutation
With Repetition
With Repetition
Random Number
Random Number
Averages and statistics calculators
Average Calculator
Average Calculator
Mean Median Mode
Mean Median Mode
SD Calculator
SD Calculator
Quartiles & IQR
Quartiles & IQR
Frequency Table
Frequency Table
Correlation (r)
Correlation (r)
Normal Probability
Normal Probability
Z-Score Calculator
Z-Score Calculator
Confidence Interval
Confidence Interval
Sample Size
Sample Size
Mark & Recapture
Mark & Recapture
P-Value Calculator
P-Value Calculator
Percentage and ratio calculators
Percentage Calc
Percentage Calc
Percent Change
Percent Change
Percent Difference
Percent Difference
Percent Error
Percent Error
Ratio Calculator
Ratio Calculator
Discount Calculator
Discount Calculator
Sales Tax Calculator
Sales Tax Calculator
Margin Calculator
Margin Calculator
Speed calculators
Speed Calculator
Speed Calculator
Density and concentration calculators
Density
Density
Molarity
Molarity
Molar Mass
Molar Mass
Physics and electricity calculators
Ohm's Law
Ohm's Law
Watts to Amps
Watts to Amps
Resistor Colors
Resistor Colors
Voltage Drop
Voltage Drop
Unit conversion calculators
Weight Converter
Weight Converter
Shoe Size Converter
Shoe Size Converter
Integer and signed number calculators
Long Division
Long Division
LCM Calculator
LCM Calculator
GCF Calculator
GCF Calculator
Integer Calculator
Integer Calculator
Prime Factorization
Prime Factorization
Diophantine Solver
Diophantine Solver
Modulo Calculator
Modulo Calculator
Factor Calculator
Factor Calculator
Roman Numerals
Roman Numerals
Fraction, decimal and rounding calculators
Fraction Calculator
Fraction Calculator
Mixed Numbers
Mixed Numbers
Simplify Fractions
Simplify Fractions
Fraction to Decimal
Fraction to Decimal
Decimal to Fraction
Decimal to Fraction
Rounding
Rounding
Equation and inequality calculators
Linear Equation
Linear Equation
Linear Systems
Linear Systems
Quadratic Formula
Quadratic Formula
Absolute Value
Absolute Value
Quadratic Inequality
Quadratic Inequality
Polynomial calculators
Binomial Theorem
Binomial Theorem
Square root and nth root calculators
Simplify Radicals
Simplify Radicals
Nth Root
Nth Root
Exponent and logarithm calculators
Exponents
Exponents
Log Calculator
Log Calculator
Number of Digits
Number of Digits
Scientific Notation
Scientific Notation
Sci. Notation Math
Sci. Notation Math
Half-Life
Half-Life
Complex number calculators
Complex Numbers
Complex Numbers
Polar Form
Polar Form
De Moivre
De Moivre
Function and graph calculators
Slope Calculator
Slope Calculator
Linear Function
Linear Function
Direct & Inverse Variation
Direct & Inverse Variation
y = ax² Calculator
y = ax² Calculator
Distance Formula
Distance Formula
3D Distance
3D Distance
Section Formula
Section Formula
Point to Line
Point to Line
Lat/Long Distance
Lat/Long Distance
Complete the Square
Complete the Square
Circle Equation
Circle Equation
Conic Sections
Conic Sections
Polar Coordinates
Polar Coordinates
Sequence calculators
Arithmetic Sequence
Arithmetic Sequence
Geometric Sequence
Geometric Sequence
Fibonacci Sequence
Fibonacci Sequence
Recurrence Relation
Recurrence Relation
Vector calculators
Vector Calculator
Vector Calculator
Cross Product
Cross Product
Matrix calculators
Matrix Calculator
Matrix Calculator
Determinant
Determinant
Inverse Matrix
Inverse Matrix
Plane geometry calculators
Sin Cos Tan
Sin Cos Tan
Degrees ⇔ Radians
Degrees ⇔ Radians
a sin θ + b cos θ
a sin θ + b cos θ
Triangle Solver
Triangle Solver
Triangle Area
Triangle Area
Right Triangle
Right Triangle
Pythagorean Theorem
Pythagorean Theorem
Polygon Angles
Polygon Angles
Scale Factor
Scale Factor
Parallel Lines
Parallel Lines
Rectangle Area
Rectangle Area
Parallelogram Area
Parallelogram Area
Trapezoid Area
Trapezoid Area
Circle Calculator
Circle Calculator
Sector Area
Sector Area
Inscribed Angle
Inscribed Angle
Ellipse Area
Ellipse Area
Solid geometry calculators
Cube Volume
Cube Volume
Cube Surface Area
Cube Surface Area
Box Volume
Box Volume
Box Surface Area
Box Surface Area
Cylinder Volume
Cylinder Volume
Cylinder Surface
Cylinder Surface
Sphere Volume
Sphere Volume
Sphere Surface
Sphere Surface
Spherical Cap Volume
Spherical Cap Volume
Cap Surface Area
Cap Surface Area
Ellipsoid Volume
Ellipsoid Volume
Ellipsoid Surface
Ellipsoid Surface
Pyramid Volume
Pyramid Volume
Pyramid Surface
Pyramid Surface
Cone Volume
Cone Volume
Cone Surface Area
Cone Surface Area
Frustum Volume
Frustum Volume
Frustum Surface Area
Frustum Surface Area
Pipe Volume
Pipe Volume
Capsule Volume
Capsule Volume
Capsule Surface Area
Capsule Surface Area
Date and time calculators
Age Calculator
Age Calculator
Days Between Dates
Days Between Dates
Date Calculator
Date Calculator
Hours From Now
Hours From Now
Day of the Week
Day of the Week
Time Calculator
Time Calculator
Time Zone Converter
Time Zone Converter
Hours Calculator
Hours Calculator
Time Duration
Time Duration
Time Card
Time Card
Finance and economics calculators
Compound Interest
Compound Interest
Simple Interest
Simple Interest
Interest Calculator
Interest Calculator
TVM Calculator
TVM Calculator
Present Value
Present Value
Future Value
Future Value
ROI Calculator
ROI Calculator
IRR Calculator
IRR Calculator
Payback Period
Payback Period
Average Return
Average Return
GDP Calculator
GDP Calculator
Web marketing and ad metric calculators
CTR Calculator
CTR Calculator
Conversion Rate
Conversion Rate
CPC, CPM & CPA
CPC, CPM & CPA
ROAS Calculator
ROAS Calculator
Break-Even CPA
Break-Even CPA
LTV Calculator
LTV Calculator
CAC Calculator
CAC Calculator
Churn Rate
Churn Rate
A/B Test Calc
A/B Test Calc
A/B Sample Size
A/B Sample Size
SEO Traffic
SEO Traffic
Break-Even Point
Break-Even Point
Markup vs. Margin
Markup vs. Margin
CAGR Calculator
CAGR Calculator
Health and fitness calculators
BMI Calculator
BMI Calculator
Sleep Calculator
Sleep Calculator
Calorie Calculator
Calorie Calculator
BMR Calculator
BMR Calculator
TDEE Calculator
TDEE Calculator
Ideal Weight
Ideal Weight
Body Fat Calculator
Body Fat Calculator
Lean Body Mass
Lean Body Mass
Calories Burned
Calories Burned
Protein Intake
Protein Intake
Macro Calculator
Macro Calculator
Carb Calculator
Carb Calculator
Fat Intake
Fat Intake
Child Height
Child Height
Sports calculators
Golf Handicap
Golf Handicap
Pace Calculator
Pace Calculator
1RM Calculator
1RM Calculator
Target Heart Rate
Target Heart Rate
Weather calculators
Heat Index
Heat Index
Wind Chill
Wind Chill
Dew Point
Dew Point
Computer calculators
Base Converter
Base Converter
Subnet Calculator
Subnet Calculator
Download Time
Download Time
Household energy and budget calculators
Electricity Cost
Electricity Cost
kWh to Cost
kWh to Cost
Yearly kWh to Cost
Yearly kWh to Cost
AC Size (BTU)
AC Size (BTU)
AC Running Cost
AC Running Cost
Heating Costs
Heating Costs
Gas vs Electric
Gas vs Electric
LED Savings
LED Savings
Salary Calculator
Salary Calculator
Budget Calculator
Budget Calculator
Car calculators
Trip Gas Cost
Trip Gas Cost
EV Charging Cost
EV Charging Cost
EV vs Gas Cost
EV vs Gas Cost
MPG Calculator
MPG Calculator
Tire Size
Tire Size
Solar power and battery calculators
Solar Output
Solar Output
Solar Panel Count
Solar Panel Count
Solar Payback
Solar Payback
Battery Size
Battery Size
Home and DIY calculators
Tile Calculator
Tile Calculator
Stair Calculator
Stair Calculator
Concrete Volume
Concrete Volume
Wall Area
Wall Area
Wallpaper Rolls
Wallpaper Rolls
Paint Calculator
Paint Calculator
Flooring Needed
Flooring Needed
Exterior Walls
Exterior Walls
Gravel Needed
Gravel Needed
Mortar Mix
Mortar Mix
Slope Grade
Slope Grade
Lumber Cut List
Lumber Cut List
Lot Coverage/FAR
Lot Coverage/FAR
Sheet Vinyl Roll
Sheet Vinyl Roll
Insulation Needed
Insulation Needed
Curtain Size
Curtain Size
TV Size & Distance
TV Size & Distance
Soil Needed
Soil Needed
Sod Needed
Sod Needed
Block Calculator
Block Calculator
Brick Calculator
Brick Calculator
Deck Materials
Deck Materials
Ramp Length
Ramp Length
Pilot Hole Size
Pilot Hole Size
Room Ventilation
Room Ventilation
Paint Thinning
Paint Thinning
Baseboard & Trim
Baseboard & Trim
Blind Size
Blind Size
Picture Hanging
Picture Hanging
Drain Slope
Drain Slope
Screw Calculator
Screw Calculator
Board Feet
Board Feet
Fence Calculator
Fence Calculator
Wood Shrinkage
Wood Shrinkage
Caulk Calculator
Caulk Calculator
Heat Loss
Heat Loss
Furniture Fit
Furniture Fit
Moving Boxes
Moving Boxes
Storage Capacity
Storage Capacity
Plywood Cuts
Plywood Cuts
Shelf Sag
Shelf Sag

Monthly Budget Calculator (Income, Expenses and Housing Ratio)

Enter as much of your income and spending as you know. You can choose monthly or yearly for each item. Blank items count as $0, so you do not have to fill in everything.

Enter amounts as numbers in dollars (commas are fine). For "Taxes and payroll deductions", federal and state income taxes plus Social Security and Medicare (7.65%) often come to about 20 to 30% of gross pay for employees (it depends on your income, state and family). Your pay stub shows your own rate.
Result and graph
Enter as much of your income and spending as you know on the left and press "Calculate". Your balance and a breakdown of your spending (pie chart and table) will appear here.

What you can do on this page

  • Enter your income, such as wages, and your spending, such as housing, food and phone, as monthly or yearly amounts, and you instantly see your yearly and monthly gross income, take-home pay, total spending and balance (surplus or deficit)
  • Spending is grouped into 9 categories (housing, utilities, food and more), and a pie chart and a breakdown table show at a glance where your money goes
  • It also shows your housing ratio (housing ÷ gross income) and your housing plus debt ratio, which adds loan payments, as percentages
  • Take-home pay is estimated with a single "taxes and payroll deductions (%)" rate, so you can use it without knowing your exact taxes
  • A plain-language explanation of the formulas, common US budgeting guidelines such as the 50/30/20 rule, and copy-and-paste formulas for Excel, Google Sheets and Python are all on this page
Taxes and payroll deductions are only estimated with a rough rate; this is not an exact tax calculation. Also, the right shares for a household vary a lot with family size, where you live and your goals. The guidelines on this page are common starting points that many people use, not a guarantee of the right answer.

What is this calculation used for?

Deciding how much rent you can afford

A common US guideline is to keep rent at or below about 30% of your gross income. If you earn $4,500 a month before taxes, that is about \(4{,}500 \times 0.3 = 1{,}350\) dollars. Many landlords also ask that your income be about 3 times the rent, which is the same idea.
This guideline is not a hard rule. In expensive cities, housing often takes more, and many people make up for it by spending less elsewhere. What matters is checking with the balance formula, before you sign, that you can stay in surplus at that rent. Rent is a fixed expense that you cannot easily change once you sign a lease.

Thinking about how much mortgage to take on (debt-to-income ratio)

The housing plus debt ratio on this page is the same idea lenders use when they approve a mortgage: the debt-to-income ratio (DTI). Under the common 28/36 rule, a gross income of $80,000 a year (about $6,667 a month) means housing of about \(6{,}667 \times 0.28 \approx 1{,}867\) dollars a month, and all debt payments including housing of about \(6{,}667 \times 0.36 \approx 2{,}400\) dollars a month. Car loans, student loans and credit card minimum payments all count toward the 36%.
But "the most a lender will approve" and "what you can comfortably repay" are different things. Borrowing up to the limit can squeeze your savings for college and retirement, so check your room to spare with your balance as well.

Planning to pay yourself first (how much you can save each month)

"Saving whatever is left over" often means nothing is left over. Instead, count your savings as spending first (for example, 20% of a $5,000 monthly take-home pay, \(5{,}000 \times 0.2 = 1{,}000\) dollars, as in the 50/30/20 rule) and use this page to check that your balance still stays in surplus. That is how you plan to pay yourself first.
If the balance goes negative, look through the breakdown table for other spending you can cut, rather than cutting the savings.

Estimating your take-home pay after a raise or a new job

The salary in a job offer is gross income. For many employees, take-home pay is roughly 70 to 80% of gross, depending on taxes and deductions. A raise is taxed at your top (marginal) rates, so with federal, state and payroll taxes adding up to about 30% at the margin, a $5,000 raise means about \(5{,}000 \times (1 - 0.30) = 3{,}500\) dollars more to spend.
Knowing the take-home formula shows that "$5,000 more in salary" is not "$5,000 more to spend", so you can compare job offers and raises by how they really change your life. (Exact taxes depend on your income and deductions, so this is only an estimate.)

Deciding where to cut first when you review your budget

As the balance formula \(B = T - E\) shows, spending $100 less a month has the same effect as $100 more take-home pay a month: $1,200 a year. And cutting spending is usually more within your control than raising your income.
The standard approach is to start with the categories that take the largest share in the breakdown and with fixed expenses such as rent, phone plans, subscriptions and insurance. Cutting a fixed expense once keeps saving you money every month.

Formulas and figures

Turning a monthly amount into a yearly amount
Figure
Standard notation (the usual math form)
\(A\) \(=\) \(M\) \(\times\) \(12\)
In words (symbols replaced with words)
③ \(A\): yearly amount \(=\) ① \(M\): monthly amount \(\times\) ② \(12\): months in a year
The formula in words
① Take the \(M\): monthly amount
② multiply it by \(12\): months in a year
③ and you get the \(A\): yearly amount
Quick example
Rent of $1,200 a month, turned into a yearly amount, is
\(A\): yearly rent \(=\) monthly ($1,200) \(\times\) months in a year (12)
\(1{,}200 \times 12 = 14{,}400\)
Key idea
A budget mixes things you pay every month (rent, groceries) with things you pay once or a few times a year (property tax, insurance premiums, travel). You cannot add them up as they are, so this calculator first puts every item on a yearly basis and then adds them. To go from yearly to monthly, divide by 12. Yearly bills do not show up in a month-to-month budget, so they are easy to forget, but converting to yearly amounts puts them into the full picture of your year.
Take-home pay (gross income minus taxes and deductions)
Figure
Standard notation (the usual math form)
\(T\) \(=\) \(G\) \(\times\) \(\left(1-\dfrac{r}{100}\right)\)
In words (symbols replaced with words)
③ \(T\): take-home pay \(=\) ① \(G\): gross income \(\times\) ② share you keep
The formula in words
① Take the \(G\): gross income
② multiply it by the share you keep \(\left(1-\dfrac{r}{100}\right)\) (the whole, \(1\), minus the rough rate of taxes and deductions \(r\) (%) turned into a decimal by dividing by 100)
③ and you get the \(T\): take-home pay
Quick example
With a gross income of $80,000 a year and a rough rate of 22% for taxes and deductions, take-home pay is
\(T\): take-home pay \(=\) gross income ($80,000) \(\times\) share you keep (0.78)
\(1 - \dfrac{22}{100} = 0.78\)
\(80{,}000 \times 0.78 = 62{,}400\)
Key idea
For employees in the US, federal income tax, state and local income tax, and payroll taxes (Social Security 6.2% and Medicare 1.45%, 7.65% in total) often add up to about 20 to 30% of gross pay. The exact share depends on your income, filing status, state and deductions, so your pay stub or last year's tax return is the most reliable way to find your own rate. Pre-tax contributions, such as to a traditional 401(k) or a health savings account (HSA), lower your taxes, so your real tax burden can be a little lighter than this estimate (the contributions themselves still leave your paycheck).
Your balance (surplus or deficit)
Figure
Standard notation (the usual math form)
\(B\) \(=\) \(T\) \(-\) \(E\)
In words (symbols replaced with words)
③ \(B\): balance \(=\) ① \(T\): take-home pay \(-\) ② \(E\): total spending
The formula in words
① Take the \(T\): take-home pay
② subtract the \(E\): total spending
③ and you get the \(B\): balance (positive means a surplus, negative means a deficit)
Quick example
For a household with a take-home pay of $62,400 a year and total spending of $61,300 a year, the balance is
\(B\): balance \(=\) take-home pay ($62,400) \(-\) total spending ($61,300)
\(62{,}400 - 61{,}300 = 1{,}100\)
Key idea
On this page, money set aside for savings and investing counts as "spending" (the "pay yourself first" approach, where you set savings aside first). So even a balance of about $0 means your savings are already taken care of. On the other hand, if you leave savings out and the balance is exactly $0, you are not saving anything at all. Keep in mind which way you entered your numbers when you read the result.
Housing ratio (housing costs as a share of income)
Figure
Standard notation (the usual math form)
\(R\) \(=\) \(H\) \(\div\) \(G\) \(\times\) \(100\)
In words (symbols replaced with words)
④ \(R\): housing ratio (%) \(=\) ① \(H\): housing costs (yearly) \(\div\) ② \(G\): gross income (yearly) \(\times\) ③ \(100\): to a percent
The formula in words
① Take the \(H\): housing costs (yearly)
② divide it by the \(G\): gross income (yearly)
③ multiply by \(100\) to turn it into a percent
④ and you get the \(R\): housing ratio
Quick example
With housing costs of $17,800 a year and a gross income of $80,000 a year, the housing ratio is
\(R\): housing ratio \(=\) housing ($17,800) \(\div\) gross income ($80,000) \(\times\) 100
\(17{,}800 \div 80{,}000 \times 100 = 22.25\)
Key idea
If you add car loan, credit card and student loan payments to the housing costs \(H\) on top of the fraction, you get the housing plus debt ratio, and this calculator shows both. Common US guidelines are to keep housing at or below about 30% of gross income (spending more than 30% is what the US Department of Housing and Urban Development calls "cost-burdened"), and the 28/36 rule that mortgage lenders often use: housing at or below 28% and all debt payments including housing at or below 36% of gross income (the debt-to-income ratio, DTI). But the most a lender will approve and what you can comfortably pay are not the same. The right shares vary a lot with your family, where you live and your plans, so use the guidelines as a starting point and check them against your own balance.
Your budget balance is "take-home pay − total spending". The keys are to put monthly and yearly items on the same yearly basis before adding them, and to set savings aside first as part of your spending (pay yourself first).

Symbols and terms

Symbols

\(M\) M The monthly amount - what you pay (or receive) each month. (Example - rent of $1,200 a month)
\(A\) A The yearly amount - the amount for a full year. You can get it from the monthly amount with \(A = M \times 12\).
\(G\) G Gross income (yearly) - your total income before taxes and deductions, from the first letter of "gross".
\(r\) small r The rough rate of taxes and payroll deductions (%) - about how much of your gross income goes to taxes and payroll deductions.
\(T\) T Take-home pay (yearly) - your income after taxes and deductions, the money you can actually spend.
\(E\) E Total spending (yearly) - the total of all spending categories. On this page it includes money set aside for savings and investing. From the first letter of "expenses".
\(B\) B The balance (yearly) - what is left after subtracting total spending from take-home pay. Positive is a surplus, negative is a deficit. From the first letter of "balance".
\(H\) H Housing costs (yearly) - the total of rent or mortgage payments, HOA dues and maintenance, property tax, and homeowners or renters insurance. From the first letter of "housing".
\(R\) capital R The housing ratio (%) - housing costs as a share of gross income, from the first letter of "ratio".

Terms

gross income Income before taxes and deductions. The salary in a job offer ("$60,000 a year") is usually gross income.
take-home pay Income after federal and state income taxes, payroll taxes and other deductions are taken out - the money actually deposited in your account that you can spend. Economists call a similar amount "disposable income".
payroll taxes Taxes taken from each paycheck for Social Security (6.2%) and Medicare (1.45%), often shown as FICA on a pay stub. Together with income taxes and deductions such as health insurance premiums, they make up most of the gap between gross and take-home pay.
pay yourself first A way of saving where you set aside savings as soon as you are paid and live on what is left. It is said to work better than "saving whatever is left over", and this page follows the same idea by counting savings and investing as spending. Automatic transfers and 401(k) contributions from your paycheck are common ways to do it.
fixed expenses Spending that stays about the same every month, such as rent, insurance and phone plans. Cutting one keeps saving you money every month, so budget reviews usually start with fixed expenses.
variable expenses Spending that changes from month to month, such as groceries and entertainment. Unlike fixed expenses, saving on them takes effort every month, and the effect changes month by month.
debt-to-income ratio Your monthly debt payments (including housing) divided by your gross monthly income, often shortened to DTI. Mortgage lenders really use it: the common 28/36 rule means housing at or below 28% and all debt payments at or below 36% of gross income, and car loans, student loans and credit card minimums all count.
50/30/20 rule A simple budgeting guideline widely used in the US - about 50% of take-home pay for needs (housing, utilities, groceries, insurance, minimum debt payments), 30% for wants (dining out, hobbies, travel) and 20% for savings and extra debt payoff. It is a starting point; in high-cost areas, needs often take more than 50%.

Good to know before you start

Here is what helps you use the calculation on this page with real understanding, not just by pressing the button.

Percents (Grades 6–7)
  • Being able to turn "22%" into the decimal 0.22 (dividing a percent by 100 gives a decimal)
  • Knowing that part = whole × percent (take-home pay = gross income × the share you keep)
Large numbers and estimating (Grade 4)
  • Being able to read and write large numbers with commas, such as 62,400
  • Being able to estimate by rounding to get a rough idea
Months and years
  • Knowing that 1 year = 12 months, so monthly × 12 = yearly and yearly ÷ 12 = monthly
Positive and negative numbers (Grades 6–7)
  • Knowing what signed numbers such as "+1,100" and "−240" mean for a balance (plus = surplus, minus = deficit)

How to calculate it in Excel

Copy the whole table below and paste it into cell A1 in Excel. It works as is.
Table to turn a monthly amount into a yearly amount
Monthly amount ($) 1200
Months in a year 12
Yearly amount ($) =B1*B2
Table to find take-home pay
Gross income ($ per year) 80000
Taxes and deductions (%) 22
Take-home pay ($ per year) =B1*(100-B2)/100
Table to find the balance
Take-home pay ($ per year) 62400
Total spending ($ per year) 61300
Balance ($ per year) =B1-B2
Table to find the housing ratio
Housing costs ($ per year) 17800
Gross income ($ per year) 80000
Housing ratio (%) =B1/B2*100
After pasting, B1 and B2 are your inputs and B3 is calculated automatically.
The first table shows 14,400 in B3 (a yearly rent of $1,200 a month), and the second shows 62,400 in B3 (take-home pay from $80,000 gross at 22%).
The third table is the balance: if B3 is positive, like 1,100, it is a surplus; if negative, a deficit. The fourth table is the housing ratio, and B3 shows 22.25 (%).
Just replace B1 and B2 with your own numbers.

How to calculate it in Google Sheets

Copy the whole table below and paste it into cell A1 in Google Sheets. It works as is.
Table to turn a monthly amount into a yearly amount
Monthly amount ($) 1200
Months in a year 12
Yearly amount ($) =B1*B2
Table to find take-home pay
Gross income ($ per year) 80000
Taxes and deductions (%) 22
Take-home pay ($ per year) =B1*(100-B2)/100
Table to find the balance
Take-home pay ($ per year) 62400
Total spending ($ per year) 61300
Balance ($ per year) =B1-B2
Table to find the housing ratio
Housing costs ($ per year) 17800
Gross income ($ per year) 80000
Housing ratio (%) =B1/B2*100
The same formulas as in Excel work as is. Copy the whole table, paste it into cell A1, and replace B1 and B2 with your own numbers.

How to calculate it in Python

tax_rate = 22  # rough rate of taxes and payroll deductions (%)

# Income and spending: (amount, "m" = monthly or "y" = yearly)
incomes = {
    "Wages and salary": (6400, "m"),
    "Investment income": (1200, "y"),
    "Other income": (2000, "y"),
}
expenses = {
    "Housing (rent or mortgage, HOA)": (1250, "m"),
    "Property tax and home insurance": (2800, "y"),
    "Utilities and phone": (390, "m"),
    "Food": (800, "m"),
    "Transportation": (570, "m"),
    "Car insurance and registration": (1500, "y"),
    "Insurance and health care": (260, "m"),
    "Children and education": (300, "m"),
    "Debt payments": (200, "m"),
    "Savings and investing": (550, "m"),
    "Other": (330, "m"),
    "Travel": (1200, "y"),
}

def annual(amount, unit):
    # Monthly amounts are multiplied by 12 to put them on a yearly basis
    return amount * 12 if unit == "m" else amount

gross_income = sum(annual(a, u) for a, u in incomes.values())
net_income = gross_income * (100 - tax_rate) / 100
total_expenses = sum(annual(a, u) for a, u in expenses.values())
balance = net_income - total_expenses

print(f"Gross income: ${gross_income:,.0f} per year")
print(f"Take-home pay: ${net_income:,.0f} per year")
print(f"Total spending: ${total_expenses:,.0f} per year")
print(f"Balance: {balance:+,.0f} dollars per year")
Runs with the standard library only. Change the amounts and "m" (monthly) or "y" (yearly) to match your budget and run it. In this example, gross income is $80,000, take-home pay $62,400, total spending $61,300 and the balance +$1,100 (a surplus).

How to write it in LaTeX and other math languages (copy and paste)

Turning a monthly amount into a yearly amount
A = M × 12
A = M \times 12
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
  <mrow>
    <mi>A</mi>
    <mo>=</mo>
    <mi>M</mi>
    <mo>&#x00D7;</mo>
    <mn>12</mn>
  </mrow>
</math>
A = M xx 12
m*12
A := M*12;
A = M*12;
A = M × 12
Take-home pay (gross income minus taxes and deductions)
T = G × (1 − r/100)
T = G \left(1 - \dfrac{r}{100}\right)
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
  <mrow>
    <mi>T</mi>
    <mo>=</mo>
    <mi>G</mi>
    <mo>&#x00D7;</mo>
    <mrow>
      <mo>(</mo>
      <mn>1</mn>
      <mo>&#x2212;</mo>
      <mfrac><mi>r</mi><mn>100</mn></mfrac>
      <mo>)</mo>
    </mrow>
  </mrow>
</math>
T = G (1 - r/100)
g*(1 - r/100)
T := G*(1 - r/100);
T = G*(1 - r/100);
T = G(1 - r/100)
Your balance (surplus or deficit)
B = T − E
B = T - E
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
  <mrow>
    <mi>B</mi>
    <mo>=</mo>
    <mi>T</mi>
    <mo>&#x2212;</mo>
    <mi>E</mi>
  </mrow>
</math>
B = T - E
t - ex
B := T - E;
B = T - E;
B = T − E
Housing ratio (housing costs as a share of income)
R = H ÷ G × 100
R = \dfrac{H}{G} \times 100
<math xmlns="http://www.w3.org/1998/Math/MathML" display="block">
  <mrow>
    <mi>R</mi>
    <mo>=</mo>
    <mfrac><mi>H</mi><mi>G</mi></mfrac>
    <mo>&#x00D7;</mo>
    <mn>100</mn>
  </mrow>
</math>
R = H/G xx 100
h/g*100
R := H/G*100;
R = H/G*100;
R = H/G × 100

How to have ChatGPT  do the calculation

You are a household budget calculation assistant. Do the following calculation by actually running Python code, and base your answer only on the numbers from the execution result (do not answer by mental math or guessing).

Here is my budget:
- Income (gross): wages $6,400 a month, investment income $1,200 a year, other income $2,000 a year
- Rough rate of taxes and payroll deductions: 22%
- Spending: housing (rent or mortgage, HOA) $1,250 a month, property tax and home insurance $2,800 a year, utilities and phone $390 a month, food $800 a month, transportation $570 a month, car insurance and registration $1,500 a year, insurance and health care $260 a month, children and education $300 a month, debt payments $200 a month, savings and investing $550 a month, other $330 a month, travel $1,200 a year

Multiply the monthly items by 12 to put everything on a yearly basis, then find each of the following:
1. Gross income (yearly) and take-home pay (yearly)
2. Total spending (yearly)
3. The balance (take-home pay − total spending, and whether it is a surplus or a deficit)
4. The housing ratio (yearly housing costs ÷ gross income × 100; housing is $1,250 a month plus $2,800 a year)

Show the formulas you used and the numbers from the execution result.

How to Use
  1. 1
    Enter your numbers
    Type the numbers you want to calculate with into the input fields
  2. 2
    Calculate
    Press the "Calculate" button
  3. 3
    Check the result
    The result appears on the spot. The same page also explains the idea behind the calculation and the formula
  DataChef Features
Easy and Free
Unlimited conversions for free.
No technical knowledge required.
Intuitive and user-friendly operation.
No Registration Required
Available immediately after access.
Can be used without registering personal information.
Safe and Secure
Fully SSL encrypted communication.
Automatic file deletion by clicking "download".
Fast
High-speed site access
and rapid file conversion.
No Watermark
No watermark.
No attribution required.
Commercial Use Available
Free for commercial use.
No need to contact us for commercial use permission.