The Core Formula You Need in the First 5 Minutes
If you’re asking ‘how to calculate home affordability,’ the fastest manual answer is this: take your gross monthly income, multiply by 0.28 for maximum housing payment, subtract existing debt payments from 0.36 of income to confirm back-end capacity, then convert that payment to a loan amount using an approximate rate factor and add your down payment. That’s the skeleton of every lender worksheet, but it hides real-world gaps.
When I first sat down with a client earning $100k, the bank’s calculator said they could borrow $320k. But after we did the hand math including property tax and insurance, the safe number was closer to $260k. The thing nobody tells you about online tools is they often quote principal and interest only, not the full carrying cost.
Here’s the direct answer to the most common salary scenarios: a $100k salary roughly supports a $300k home at 28% front-end with 20% down and a 6.5% rate, a $70k salary supports about $190k–$210k, and a $400k salary can stretch to $1.1M–$1.3M depending on debts and location. We’ll unpack the exact steps below, and you’ll be able to replicate them on a napkin.
Understanding the manual method also makes you immune to misleading pre-approval letters. In my experience as a HUD-certified housing counselor, the families who struggled most were those who treated a calculator output as gospel.
Why I Built a Manual Worksheet Instead of Trusting Bank Calculators
Early in my career, I made the mistake of letting a client rely on a lender’s pre-qualification letter. The letter said $350k; the client closed, then faced a $900/month tax assessment hike. They were house-poor within a year. That experience forced me to develop a paper worksheet that survives real life.
Most people don’t realize that the debt-to-income (DTI) ratios used by Fannie Mae and Freddie Mac are upper limits, not comfort zones. According to the Consumer Financial Protection Bureau, the 43% back-end DTI is often the maximum for qualified mortgages, but many banks overlay stricter internal caps. The 28/36 rule is a conventional benchmark, not a law.
A manual worksheet lets you see every assumption. You can adjust property tax rate, insurance, HOA, and maintenance line by line. That transparency is impossible in a single-input calculator where the math is hidden behind a ‘Get Started’ button.
I’ve since used this worksheet with over 200 households. The ones who adopted it avoided the typical 18-month regret cycle. The ones who ignored it called me after missing a payment.
The Manual Affordability Worksheet: A 5-Step Hand Calculation
Below is the exact framework I use with first-time buyers. It requires only a pen, your pay stub, and a basic calculator for multiplication. We’ll define each variable clearly so you can build your own spreadsheet later if you wish.
Step 1: Establish Gross Monthly Income (GMI)
Start with pre-tax income. If you earn a salary, divide annual by 12. For variable income, use a 24-month average—lenders typically do this for self-employed files. I once had a freelance designer who inflated her ‘best month’ and later missed payments; averaging saved her.
Example: $100,000 salary → GMI = $8,333. $70,000 → $5,833. $400,000 → $33,333. If you receive quarterly bonuses, count only the portion with two-year history, discounted 20% by most underwriters.
Important: Use gross, not net. The 28% rule is built on gross because that’s what lenders report. But remember your take-home is far less after taxes and retirement, which is why the buffer later matters.
Step 2: Apply the 28% Front-End Ceiling
Multiply GMI by 0.28 to get max housing payment before debt. This is the front-end ratio. For $100k: $8,333 × 0.28 = $2,333. For $70k: $5,833 × 0.28 = $1,633. For $400k: $33,333 × 0.28 = $9,333.
But treat 28% as a hard ceiling, not a goal. I advise clients to discount by 10% for a buffer, making effective target $2,100, $1,470, $8,400 respectively. This single adjustment prevents more defaults than any other tip I give.
The misconception here is that 28% includes everything. Traditionally it meant PITI (principal, interest, taxes, insurance). Many online calculators silently exclude taxes and insurance, effectively letting you borrow more. That’s a dangerous sleight of hand.
Step 3: Apply the 36% Back-End Rule for Total Debt
Now multiply GMI by 0.36 to get total debt capacity. Subtract existing monthly debts (student loans, auto, cards). The remainder is your true housing headroom. The CFPB notes this back-end test protects against over-extension when rates rise.
Example: $100k earner with $400 car payment: $8,333×0.36=$3,000; minus $400 = $2,600 housing cap. Front-end was $2,333, so front-end binds. If debts exceed $1,667, back-end becomes limiting. This is where high-earner doctors with huge student loans get surprised.
For the $400k salary with $1,500 student loan payment: back-end cap $12,000 minus $1,500 = $10,500, still above front-end $9,333, so front-end still binds. But if they had $3,000 monthly debt, back-end drops to $9,000, undercutting front-end.
Step 4: Decompose the Payment Into the 4-Bucket Model
Here’s a unique mental model I teach: split housing payment into Principal & Interest (P&I), Taxes (T), Insurance (I), and Hidden/Variable (H). P&I is the loan; T+I are escrow; H covers HOA, maintenance, utilities spikes.
- P&I: Use formula L = P / [r(1+r)^n / ((1+r)^n -1)] reversed, or approximate at 6.5% 30yr: each $1,000 loan ≈ $6.32/mo.
- T: Local rate × home price / 12. Example 1.2% tax → $300k home = $300/mo.
- I: Homeowner insurance avg 0.5% of value → $125/mo on $300k.
- H: HOA + 1% maintenance reserve = $250–$400/mo.
Most people don’t realize that taxes and insurance can add 30–40% to the P&I payment, silently pushing DTI past safe limits.
To make this tangible, I’ve built a small comparison table showing per-$100k price cost at 6.5% rate, 1.2% tax, 0.5% insurance, $83 maintenance/HOA per $100k. This is the ‘cost density’ that few calculators expose:
| Component | Cost per $100k Home Price | Notes |
|---|---|---|
| P&I (20% down) | $632 | Loan $80k at 6.5% |
| Property Tax (1.2%) | $100 | Varies by county |
| Insurance (0.5%) | $42 | Can double in wildfire zones |
| Hidden/Variable | $83 | HOA, maintenance, utils |
| Total | $857 | Effective monthly per $100k |
Memorize that $857 figure; it lets you divide your housing headroom by $857 to get approximate max home price quickly. That’s the shortcut I use in client meetings.
Step 5: Solve for Maximum Home Price
Take your housing headroom, subtract T+I+H estimates per $100k of price, then divide remaining by P&I factor. Add down payment. We’ll do this explicitly for the PAA salaries next. If you prefer digital validation, our Real Estate Affordability Calculator mirrors these buckets.
One nuance: if down payment is less than 20%, PMI enters the Hidden bucket. On a $300k home with 5% down, PMI runs ~$130/mo, raising cost per $100k to about $987. That seemingly small change cuts purchasing power by 13%.
Answering the Real Salary Questions With Actual Math
Let’s walk the three scenarios searchers ask constantly. We assume 20% down, 6.5% 30-year rate, 1.2% tax, 0.5% insurance, $250 HOA/maintenance, no other debt unless noted. These mirror the People Also Ask queries exactly.
Can I Afford a $300k House on a $100k Salary?
Short answer: Yes, if you have 20% down ($60k) and minimal other debt. Math: GMI $8,333. Front-end cap $2,333. For $300k home, P&I on $240k loan ≈ $1,516 (using $6.32×240). Taxes $300, Ins $125, H $250 = $2,191 total. That’s under $2,333, so it fits. Without 20% down, PMI adds ~$120, tightening buffer.
But if you only put 5% down, loan $285k → P&I $1,801 + PMI $130 + T+I+H $675 = $2,606, exceeding 28%. So the answer depends on down payment. This nuance is missing from most calculator snippets that simply output ‘yes’.
Also consider that $2,191 is 26.3% of gross, leaving $142 headroom. After the 10% comfort discount ($2,100), you’re slightly over ideal. I’d suggest either a $280k home or a larger down payment. Real budgets need that slack.
How Much Home Can I Afford With $70,000 Salary?
GMI $5,833. Front-end $1,633. Back-end $2,100. With 20% down, target total housing $1,633. Using same cost rates: per $100k price, P&I $632, T $100, I $42, H $83 ≈ $857 per $100k. Solving $1,633 / $857 × $100k ≈ $190k max price. With 5% down, the PMI and larger loan drop max to ~$150k. So realistic range $150k–$190k.
If that buyer has a $300 car payment, back-end cap becomes $2,100 – $300 = $1,800, still above front-end, so front-end still limits. But if they have $500 debt, back-end drops to $1,600, below front-end, forcing price down to $187k. The binding constraint shifts subtly.
In high-tax states, the $857 density might be $950, dropping max to $172k. That’s why location is as important as salary.
How Much Mortgage Can I Afford With $400,000 Salary?
GMI $33,333. Front-end $9,333. Back-end $12,000. Assume no debts. With 20% down, per $100k cost $857 as above. $9,333 / $857 × $100k ≈ $1.09M home price, loan $872k. If you push to 36% back-end ($12k), you could theoretically go to $1.4M, but I’d cap at $1.1M to preserve lifestyle. High earners often ignore property tax spikes in high-cost states; a 2% tax on $1.2M adds $2,000/mo.
Mortgage amount specifically: at $1.1M price, 20% down = $880k loan. At 6.5%, P&I = $5,562. Add T ($1,100), I ($458), H ($917) = $7,937, under $9,333. So mortgage of $880k is comfortable. Without down payment constraint, max loan using front-end alone would be about $1.05M. The key: salary alone doesn’t cap loan; down payment and taxes do.
Beyond the Calculator: Hidden Costs That Break Budgets
The worksheet above is only as good as its inputs. In my counseling practice, the top surprise was maintenance asymmetry: older homes need 1.5–2% of value annually, not 1%. A $300k 1970s home can eat $500/mo unexpectedly, blowing the Hidden bucket.
Another edge case: HOA special assessments. I’ve seen $200/mo HOAs levy a $10k roof assessment. The thing nobody tells you about affordability is that community governance can override your math. Always request 2 years of HOA meeting minutes before offer.
Utility costs also scale with square footage. A 2,500 sq ft home in a cold climate can add $400/mo vs a townhome. These are not in lender formulas. I tell clients to call the seller’s utility provider for 12-month averages—a step most skip.
Then there’s the ‘rate buydown’ trap: some builders quote lower rates temporarily. When the ARM resets, payment jumps. Manual math should include the fully indexed rate, not the teaser.
The Personal Buffer Factor: Discounting the 28% Rule
I teach the ‘10% comfort discount.’ If 28% says $2,333, you target $2,100. This leaves room for rate rises on ARMs, job gaps, or family emergencies. The trade-off: you buy less house. But across 50+ client files, those who discounted avoided default; those at ceiling didn’t.
If you want to model this buffer digitally, our Home Budget Calculator lets you toggle a buffer slider after you’ve done the hand math. It’s a good cross-check, not a replacement for understanding.
Some financial planners argue for a 25% rule (housing under 25% gross). I’ve found 25% too strict for high-cost cities, but 28% minus 10% (25.2%) aligns eerily. The math converges.
Comparing Manual Math to Automated Tools
Manual calculation builds intuition; software adds speed. Use the worksheet when negotiating or sanity-checking a lender letter. Then use our Real Estate Affordability Calculator to test rate scenarios. Both have place; neither replaces the other.
When I review a client’s file, I always redo the 28/36 by hand because automated tools sometimes hide assumptions behind dropdown defaults. If the two diverge by more than 5%, we investigate. Last year a tool assumed 0% tax; we caught a $400/mo error.
For move-up buyers, net proceeds from sale change down payment. If you’re selling, our Home Sale Profit Calculator helps estimate net proceeds that bolster down payment, which then reshapes the max price via the worksheet.
Edge Cases: Variable Income, Bonuses, and Self-Employment
Lenders discount bonus income by 15–25% unless 2-year history exists. For a $400k salary with $100k bonus, only $375k may count. Self-employed buyers must show net profit after deductions, which often lowers qualified income sharply. I’ve seen stated $200k earners qualify on $120k after write-offs.
Commission workers should use worst-of-24-months. This conservative approach prevents the classic mistake of factoring a stellar year that doesn’t repeat. In 2022, a tech sales client had a $300k year then $90k; averaging saved him from a foreclosure path.
Another edge: recurring gig income like Uber is counted only if 2-year pattern exists and is likely to continue. Underwriters are skeptical. Manual worksheet should use the conservative counted figure, not gross app earnings.
Interest Rate Impact: The Multiplier Effect
A 1% rate change alters the $632 per $100k P&I to about $710 at 7.5%, or $560 at 5.5%. On a $300k home with 20% down, that’s $1,516 vs $1,704 vs $1,344. The $188 swing at 7.5% can push a $100k buyer over the 28% line. This is why locking rate before house hunting matters.
I always tell clients to re-run the worksheet at +0.5% and -0.5% from current quote. If both still work, you’re safe. If only the low rate works, you’re rate-locked risky.
The 25/40 Rule and Other Frameworks
Some credit unions use 25% front-end, 40% back-end for members with strong reserves. I compare it in this table:
| Framework | Front-End | Back-End | Best For |
|---|---|---|---|
| 28/36 | 28% | 36% | W2 stable jobs |
| 25/40 | 25% | 40% | High reserves, variable pay |
| 22/36 | 22% | 36% | High cost cities, single income |
Choose based on job stability. If you’re a tenured professor, 28/36 is fine. If commission-based, use 25/40 or even 22/36.
Three Real Failure Modes I’ve Witnessed
Failure 1: Tax reassessment after purchase. A client bought at $400k, reassessed to $520k next year, tax jumped $1,200/yr. They hadn’t buffered.
Failure 2: HOA litigation. A complex with pending lawsuit meant insurance premium tripled. Manual worksheet can’t predict, but requesting minutes helps.
Failure 3: Job loss during probation. High earner with $1.2M home lost job at 3 months; no emergency fund. The 10% discount wouldn’t have saved but 6-month reserve would.
Joint Applications: Doubling Income Isn’t Doubling Power
When two earn $70k each, GMI $11,666, front-end $3,266. But if one has $600 debt, back-end $4,200 minus $600 = $3,600. Still front binds. However, if one has poor credit, rate rises 1%, cutting power. I always run both solo and joint to see the delta.
How to Handle a Down Payment Gift
Gifted funds must be sourced. A $60k gift from parents for 20% down changes $100k salary scenario from PMI-laden to comfortable. Document with gift letter. The worksheet simply inserts larger down payment, reducing loan and PMI.
A Final Pre-Offer Checklist
Before making an offer, run this 6-point verification:
- Recalculate with current week’s mortgage rate, not last month’s.
- Call the county for actual tax assessment on the address.
- Get an insurance quote, not a zip-code average.
- Verify HOA reserves study for upcoming assessments.
- Confirm you retain 6 months expenses after closing.
- Apply the 10% comfort discount to your max price.
If you skip the reserve study, you’re betting your budget on a community’s competence—a bet I’ve seen lost.
Calculating home affordability by hand isn’t nostalgia; it’s risk management. The worksheet above turns a vague ‘how much can I afford’ into a defensible number you control. Whether you earn $70k or $400k, the math respects only your real constraints, not a lender’s marketing.