Picture this: you spend three weekends touring homes, fall completely in love with a four-bedroom colonial at $450,000, and then discover the monthly payment is $800 more than you can comfortably handle. That’s not just disappointing. It’s the kind of setback that makes people give up on homeownership entirely.
The fix is simple, but most buyers skip it. Run your numbers before you fall in love with a listing. That’s exactly what this guide is designed to help you do.
My name is Duane Buziak, and I’ve been helping buyers across Virginia, Florida, Tennessee, Georgia, DC, North Carolina, South Carolina, and Maryland find the right loan since 2014. At MortgageRateHawk.com, our approach is straightforward: we don’t just look, we hunt. And every great hunt starts with knowing your target before you pull the trigger.
By the time you finish this guide, you’ll have a completed, personalized home affordability worksheet you can bring directly into a pre-approval call. No guessing. No surprises. Just your real number, calculated the same way lenders calculate it.
Here’s what we’re covering in six steps, plus a full FAQ section at the end:
Step 1: Gather your income and debt numbers.
Step 2: Calculate your debt-to-income ratio.
Step 3: Run a fully worked dollar example with real math.
Step 4: Compare loan types side-by-side in a structured table.
Step 5: Set your true affordability ceiling, including cash to close.
Step 6: Stress-test your number and lock in a pre-approval.
Let’s get into it.
Step 1: Gather Your Income and Debt Numbers (Your Worksheet Raw Materials)
Before you can calculate anything meaningful, you need two clean numbers written down: your total gross monthly income and your total monthly debt obligations. Think of this as pulling together your raw materials before building anything.
Income sources that count for mortgage qualification:
W-2 wages: Your base salary or hourly pay, averaged from your two most recent pay stubs. Straightforward for most buyers.
Self-employment income: Lenders use your net income after deductions, averaged over two years of tax returns. If you write off a lot of expenses, your qualifying income may be lower than your gross revenue suggests.
Rental income: Typically 75% of gross rental income (to account for vacancies) can count, but documentation requirements vary by loan type.
Social Security or disability income: Fully countable and often grossed up by 25% since it’s non-taxable, which can actually help your qualifying income.
Alimony or child support: Countable if documented and likely to continue for at least three years from closing date.
Each of these income types is verified differently, which is why lenders ask for specific documents. The good news: pulling your last two pay stubs and your two most recent federal tax returns right now does double duty. You’ll need these same documents for your pre-approval anyway.
Monthly debt obligations that count in your DTI:
Car payments: The full monthly payment, not the balance.
Student loan payments: The required monthly payment (more on deferment situations in the FAQ below).
Minimum credit card payments: The minimum shown on your statement, not what you actually pay.
Personal loans and installment loans: Any required monthly payment.
Here’s what does NOT count in your debt-to-income ratio: utilities, subscriptions, groceries, gym memberships, or any other living expenses. Lenders are only counting legally obligated debt payments.
Common pitfall to avoid: If you’re buying with a co-borrower, you need to capture both sides of the ledger. Both incomes count toward qualifying, which is great. But both debt loads count too. Forgetting to include a co-borrower’s car payment or student loans is one of the most common worksheet errors buyers make.
Worksheet success indicator for Step 1: You have a single gross monthly income figure and a single monthly debt total written down. If you’re buying solo, it’s your numbers. If you’re buying with a partner, it’s the combined household figures.
Step 2: Calculate Your Debt-to-Income Ratio (The Number Lenders Actually Use)
Your debt-to-income ratio, or DTI, is the single most important number in mortgage qualification. It tells lenders what percentage of your gross monthly income goes toward debt payments. Understanding how it works puts you in control of the conversation before you ever talk to a lender.
There are two versions of DTI you’ll hear about. The front-end DTI covers only your proposed housing costs: principal, interest, taxes, insurance, and HOA if applicable. The back-end DTI covers all monthly debts including housing. Lenders focus primarily on back-end DTI. The CFPB explains DTI in plain language if you want a deeper reference.
The formula:
Back-End DTI = (Total Monthly Debts + Estimated Housing Payment) ÷ Gross Monthly Income × 100
Write that formula on your worksheet. You’ll use it in Step 3 with real numbers.
2026 DTI thresholds by loan type:
Conventional loans (Fannie Mae): Typically allows up to 45-50% back-end DTI when run through Fannie Mae’s Desktop Underwriter system. The Fannie Mae Selling Guide governs these guidelines.
FHA loans: Allows up to 57% back-end DTI with compensating factors (strong credit score, significant reserves). HUD’s FHA Single Family Handbook 4000.1 is the governing document.
VA loans: No hard DTI cap, but 41% is the standard benchmark. Residual income requirements often matter more than DTI for VA. Guidelines are set by the VA.
USDA loans: Typically caps back-end DTI at 41%, though exceptions exist with strong compensating factors.
Common pitfall: Using your take-home (net) pay instead of your gross income. This is the single most common math error on affordability worksheets. Always use your gross monthly income before taxes and deductions. If your W-2 shows $102,000 annually, your gross monthly income is $8,500, not whatever hits your bank account after taxes.
If your DTI comes out above 45%: Don’t panic, but do flag it now. Paying down one debt before applying can shift your DTI meaningfully. For example, eliminating a $350/month car payment on a $8,500 gross income reduces your back-end DTI by about 4 percentage points. That can be the difference between conventional approval and needing to explore FHA.
Worksheet success indicator for Step 2: You have your current back-end DTI percentage calculated and you know which loan type’s threshold you fall under. Write the percentage down next to the formula on your worksheet.
Step 3: Run the Fully Worked Dollar Example (A Real Number, Not a Range)
This is where the worksheet goes from theory to actual math. Follow along with this scenario, then replicate the steps with your own numbers in the blank fields.
Scenario setup: Virginia buyer, gross household income $8,500/month, existing monthly debts $450 (car payment + student loan minimums), targeting a $385,000 home purchase in 2026.
Down payment calculation (5% conventional):
$385,000 × 5% = $19,250 down payment
Loan amount: $385,000 – $19,250 = $365,750
Note: The FHFA 2026 conforming loan limit confirms this loan amount stays well within conventional loan territory for most counties. Verify the current limit at FHFA.gov for your specific county, as high-cost areas have higher limits.
Estimated monthly PITI breakdown (illustrative — your rate will vary based on credit and market conditions):
Principal + Interest: At an illustrative 6.875% rate on a 30-year fixed loan of $365,750, the P&I payment is approximately $2,403/month.
Estimated property taxes (Virginia average): Virginia’s effective property tax rate varies by county. Using a conservative estimate of $285/month for a $385,000 home in a mid-range Virginia county.
Homeowners insurance: Approximately $120/month for a home in this price range in Virginia. Get an actual quote early — this number varies significantly by location and coverage level.
PMI (Private Mortgage Insurance): Required because the down payment is less than 20%. PMI on a conventional loan at this loan amount typically runs approximately $150-$180/month depending on credit score. Using $165/month for this illustration.
Estimated total PITI: $2,403 + $285 + $120 + $165 = $2,973/month
Back-end DTI calculation:
($450 existing debts + $2,973 PITI) ÷ $8,500 gross income × 100
= $3,423 ÷ $8,500 × 100
= 40.3% back-end DTI
At 40.3%, this buyer falls comfortably under the conventional threshold of 45-50% and also under the VA benchmark of 41%. This is a workable scenario.
What if this buyer uses FHA instead?
FHA requires only 3.5% down: $385,000 × 3.5% = $13,475 down, loan amount = $371,525.
The slightly larger loan changes P&I modestly, but the bigger difference is FHA’s Mortgage Insurance Premium (MIP): an upfront MIP of 1.75% of the loan amount (often rolled into the loan) plus an annual MIP of approximately 0.55% for most buyers, which adds roughly $170/month to the payment.
FHA MIP stays for the life of the loan if your down payment is less than 10%, per HUD guidelines. PMI on a conventional loan cancels at 78% LTV. Over a 5-7 year hold, that difference matters — which is exactly what the Step 4 comparison table will show you.
Worksheet success indicator for Step 3: You’ve run this math with the scenario numbers above and you can now replicate each line item with your own income, debts, and target purchase price. Write your own PITI estimate and DTI percentage in your worksheet fields before moving to Step 4.
Step 4: Compare Loan Types Side-by-Side (The Hunt Starts Here)
Same home. Same buyer. Four different loan structures. This is where the hunt gets interesting, because the monthly payment can vary meaningfully depending on which loan type fits your situation. Watch. Compare. Save.
The table below uses the $385,000 home from Step 3 as the baseline. Use it to identify which row describes your situation, then model your specific numbers.
| Loan Type | Min Down Payment | 2026 Min Credit Score (Guideline) | Max Back-End DTI Guideline | Monthly MIP/PMI/Fee Impact | Who Qualifies |
|---|---|---|---|---|---|
| Conventional | 3-5% ($11,550-$19,250 on $385K) | 620+ typical | 45-50% (Fannie Mae DU) | PMI ~$150-$200/mo; cancels at 78% LTV | Most buyers with qualifying credit and income |
| FHA | 3.5% ($13,475 on $385K) | 580+ for 3.5% down; 500-579 requires 10% down | Up to 57% with compensating factors (HUD) | Upfront MIP 1.75% + ~$170/mo annual MIP; life of loan if <10% down | Buyers with lower credit scores or limited down payment |
| VA | 0% ($0 down) | No official minimum; lenders often set 620 | 41% benchmark; no hard cap | No monthly PMI; one-time funding fee (varies by use and down payment) | Eligible veterans, active duty, surviving spouses |
| USDA | 0% ($0 down) | 640+ typical for automated approval | 41% back-end typical | Upfront guarantee fee + annual fee (~0.35% of loan balance/yr) | Buyers in eligible rural/suburban areas; income limits apply |
VA loan note: Zero down payment, no monthly PMI, and a one-time funding fee that varies based on down payment amount and whether it’s first or subsequent use. VA cash-out refinancing allows up to 100% LTV. Eligibility and current guidelines are maintained at VA.gov.
USDA loan note: Zero down payment with geographic and income eligibility requirements. Property must be in a USDA-designated eligible area. Check current eligibility maps at USDA Rural Development.
Conventional loan note: PMI cancels automatically at 78% LTV under the Homeowners Protection Act, per CFPB guidance. You can also request cancellation at 80% LTV. Fannie Mae’s Selling Guide governs conventional underwriting standards.
FHA loan note: MIP stays for the life of the loan if your down payment is less than 10%. If you put 10% or more down, MIP cancels after 11 years, per HUD Handbook 4000.1.
The key insight from this table: the loan type with the lowest down payment is not automatically the most affordable over time. A VA loan with a one-time funding fee can outperform FHA with lifetime MIP over a 5-year hold, even when starting from the same purchase price. Your worksheet helps you model your specific scenario rather than guessing.
For more detail on each program, explore the FHA Loans, VA Loans, Conventional Loans, and First-Time Homebuyer Programs pages at MortgageRateHawk.com.
Step 5: Set Your True Affordability Ceiling (Cash to Close + Reserves)
Here’s the part most affordability calculators skip entirely. Your monthly payment is only half the affordability picture. The other half is whether you have enough liquid assets to actually get to the closing table.
Plenty of buyers qualify on DTI but stumble on cash to close. Knowing this before you start shopping saves weeks of wasted effort.
Cash-to-close components for the Step 3 scenario ($385,000 home, 5% conventional):
Down payment: $19,250 (already calculated in Step 3).
Estimated closing costs: Closing costs typically run 2-5% of the loan amount. On a $365,750 loan, that’s roughly $7,315 to $18,288. A realistic midpoint estimate for a Virginia purchase is approximately $9,000-$11,000 depending on lender fees, title costs, and local transfer taxes. Use 2.5-3% as your worksheet planning figure until you have a Loan Estimate in hand.
Prepaid items: These are not fees, but funds collected upfront to fund your escrow account. Expect to prepay: homeowners insurance (often a full year upfront, approximately $1,440 in this scenario), property tax escrow (2-3 months, approximately $570-$855), and prepaid interest (depends on closing date, typically a few hundred dollars).
Total estimated cash to close in this scenario: $19,250 down + $10,000 closing costs + $2,500 prepaids = approximately $31,750.
If cash to close is the binding constraint, there are options worth exploring. Seller concessions allow the seller to contribute toward your closing costs, reducing your out-of-pocket requirement. Lender credits can also offset closing costs in exchange for a slightly higher rate. These are no-out-of-pocket closing options, not a free lunch, but they’re legitimate tools when liquid assets are tight.
Reserve requirement: Many loan programs want to see 2-3 months of PITI remaining in your savings account after closing. Using the Step 3 PITI of $2,973/month, that’s approximately $5,946 to $8,919 in reserves. Add this to your worksheet ceiling as a separate line item.
Revised total liquid assets needed: $31,750 (cash to close) + $6,000-$9,000 (reserves) = approximately $37,750 to $40,750 in total liquid assets before shopping.
If your current savings fall short of this number, explore down payment assistance programs before assuming homeownership is out of reach. Many DPA programs can bridge the gap on cash to close specifically.
Worksheet success indicator for Step 5: Your worksheet now has three distinct numbers: your maximum comfortable monthly payment, your maximum loan amount based on DTI, and your minimum liquid assets needed to close including reserves. These three numbers together define your real affordability ceiling.
Step 6: Stress-Test Your Number and Lock In a Pre-Approval
You have your numbers. Now poke holes in them before a lender does. A stress-tested worksheet is worth far more than an optimistic one.
Three stress-test scenarios to run before you call a lender:
Rate increase scenario: What if rates are 0.5% higher than your estimate when you lock? On a $365,750 loan, a half-point rate increase adds roughly $110-$115/month to your P&I payment. Does your budget still work? Does your DTI stay under the threshold?
Property tax variance: Property tax estimates from online calculators are often based on the previous owner’s assessed value. After purchase, reassessment can push taxes higher. Build in a 10-15% buffer on your tax estimate.
Income disruption: If you’re a two-income household, run the numbers on one income only. You don’t need to qualify on one income, but you should know whether you could make payments for a few months if circumstances changed.
If your worksheet survives all three stress tests, you’re ready for pre-approval. If it doesn’t, you now know exactly which variable to address first.
Pre-qualification vs. pre-approval: These are not the same thing. Pre-qualification is typically based on self-reported numbers and carries little weight with sellers. Pre-approval involves verified income, assets, and credit, and it gives you real negotiating leverage. The CFPB’s mortgage shopping resources explain what to look for when comparing lender offers.
One more thing: if you’re worried about credit inquiries, Duane Buziak offers a soft-pull credit check that does not impact your score. It’s a no-pressure starting point to see where you stand before committing to a full application.
Completing this worksheet means you walk into that pre-approval call with your numbers already organized. You know your income, your debts, your DTI, your target loan amount, and your cash-to-close requirement. You’re not guessing. You’re hunting.
Worksheet success indicator for Step 6: Your worksheet is complete, stress-tested, and you know your floor, ceiling, and cash-to-close target. You’re ready to make the call.
10 Questions Homebuyers Ask About Affordability Worksheets (Answered)
FAQ 1: What gross income do I use if I’m self-employed?
Use your net income after deductions, averaged over your two most recent years of federal tax returns. Lenders look at your Schedule C or K-1 and apply the same deductions the IRS sees. If your net income fluctuates significantly year to year, lenders typically use the lower of the two years or a two-year average, depending on the direction of the trend.
FAQ 2: Does my student loan count even if it’s in deferment?
Yes. Even if your student loan is in deferment, lenders will impute a monthly payment. For conventional loans, lenders typically use 1% of the outstanding balance as the monthly obligation if no payment is documented. For FHA, the approach is similar. Don’t assume a deferred loan disappears from your DTI calculation, because it doesn’t.
FAQ 3: What credit score do I need to qualify?
It depends on the loan type. FHA allows scores as low as 580 with 3.5% down, per HUD Handbook 4000.1. Conventional loans typically require 620 or higher. VA loans have no official minimum score set by the VA, but most lenders apply a 620 floor. Higher scores generally unlock lower rates, so even if you qualify at 620, improving your score before applying can save meaningful money over the life of the loan.
FAQ 4: Can I include overtime or bonus income?
Yes, if it’s documented for two or more years and the employer or income history suggests it’s likely to continue. Lenders will typically average your overtime or bonus income over 24 months. If you just started receiving bonuses, you may need to wait until you have a two-year history before it counts toward qualifying income.
FAQ 5: How do I estimate property taxes for my worksheet?
The most accurate method is to look up the specific property on your county assessor’s public database. Most counties have online portals where you can search by address and see the current assessed value and tax bill. If you’re not targeting a specific property yet, use the county’s average effective tax rate applied to your target purchase price as a planning estimate.
FAQ 6: What is the 2026 conforming loan limit?
Conforming loan limits are set annually by the FHFA. Limits vary by county, with higher limits in designated high-cost areas. Always verify the current limit at FHFA.gov for the specific county where you’re buying, since using an outdated figure can affect whether your loan qualifies as conventional or requires jumbo financing.
FAQ 7: Does the worksheet change if I’m buying with a co-borrower?
Yes, on both sides. Both incomes count toward qualifying gross income, which increases your purchasing power. But both debt loads count too, which can raise your DTI if the co-borrower carries significant monthly obligations. Run the combined DTI calculation using the formula from Step 2 with both income and debt figures combined.
FAQ 8: How much should I budget for homeowners insurance?
This varies significantly by state, location, home age, and coverage level. As a rough planning figure, many buyers budget $100-$200/month, but this range is wide for good reason. Florida buyers in particular should factor in elevated premiums given the current insurance market there. Get an actual quote from an insurance agent early in the process, before you’re under contract, so you’re not surprised at closing.
FAQ 9: What is PMI and when does it go away on a conventional loan?
PMI stands for private mortgage insurance. It’s required on conventional loans when your loan-to-value ratio exceeds 80%, meaning your down payment is less than 20%. Under the Homeowners Protection Act, your lender must automatically cancel PMI when your loan balance reaches 78% of the original purchase price, based on your scheduled payments. You can also request cancellation at 80% LTV if you have a good payment history. The CFPB’s PMI resource covers your rights under this law in detail.
FAQ 10: Is a home affordability calculator the same as a pre-approval?
No, and the difference matters. An affordability calculator or worksheet estimates your range based on the numbers you input. It’s a planning tool. Pre-approval is a verified lender commitment based on your actual documentation: pay stubs, tax returns, bank statements, and a credit pull. Sellers and their agents treat pre-approval as meaningful. A calculator result is not. Complete the worksheet first to organize your thinking, then move to pre-approval to make it official.
Your Numbers Are Ready. Now Let’s Hunt.
You’ve done the work most buyers skip entirely. You have a gross income figure, a debt total, a DTI calculation, a PITI estimate, a cash-to-close target, and a stress-tested ceiling. That’s not just a worksheet. That’s a strategy.
The next move is turning that worksheet into a verified pre-approval so you can make competitive offers with confidence. Duane Buziak works with buyers across Virginia, Florida, Tennessee, Georgia, DC, North Carolina, South Carolina, and Maryland, connecting them to hundreds of wholesale lenders to find the loan structure that fits their actual situation, not just the first option that comes up.
Same-day return calls. Personalized guidance from pre-approval through closing. A soft-pull credit check that won’t affect your score. And a comparison approach that hunts for your rate rather than settling for the first number on the table.
Get your free rate comparison and personalized loan match today at MortgageRateHawk.com, or call Duane Buziak directly at 804-212-8663. Your worksheet is ready. Let’s find your home.
