What Is the Home Buying & Mortgage Workbook?
The Home Buying & Mortgage Workbook is a home buying spreadsheet with 15 pre-built tabs that cover every financial decision in the home buying process — from affordability analysis to closing day and beyond. Available for both Excel and Google Sheets. You enter your core financial data once in the Control Panel, and most tabs calculate automatically. A few tabs have additional inputs for scenario-specific analysis.
The workbook includes an Affordability Dashboard with debt-to-income analysis, a Rent vs Buy break-even calculator over 5, 10, and 20-year horizons, a Down Payment savings tracker, a side-by-side Mortgage Comparison for three loan scenarios, a full month-by-month Amortization Schedule with auto PMI drop, an Extra Payments impact calculator, a 23-line-item Closing Costs estimator with estimate vs actual columns, a weighted Home Search Scorer for comparing up to five properties, a First-Year Homeowner Budget for expenses most buyers forget, a Maintenance Reserve tracker for big-ticket repair planning, and a Net Worth Projector comparing buying vs renting and investing. It also includes a Beginner Guide for first-time buyers and a Pro Strategy Guide covering DTI optimization, ARM vs fixed analysis, and points strategy.
Choose Your Format
Three purchase options — Excel only, Google Sheets only, or both in the bundle. Same workbook, same 15 tabs, same formulas. Pick the format you'll actually use.
Complete Bundle
Both formats in one purchase. Run your numbers in Excel at home, collaborate with a partner in Google Sheets — same workbook, your choice.
Google Sheets Only
The full 15-tab workbook for Google Sheets. Copy to your Drive and start running scenarios in minutes.
Excel Only
The full 15-tab workbook as an Excel file. Download, open, and start analyzing affordability the same day.
Who It's For
The Home Buying & Mortgage Workbook is built for:
- First-time home buyers who want to understand what they can actually afford before talking to a lender — not after.
- Anyone comparing mortgage options who needs to see three loan scenarios side by side with total cost, monthly payment, and interest differences clearly laid out.
- Renters deciding whether to buy who want a real break-even analysis — not a rule of thumb — over 5, 10, and 20-year horizons.
- Buyers saving for a down payment who want to track progress toward their goal with a timeline and monthly contribution targets.
- Homeowners in their first year who need a realistic budget that includes the expenses most buyers forget — maintenance, utilities, setup costs, and HOA fees.
What's Inside
Fifteen tabs covering every stage of the home buying process. Here's what you get:
Control Panel + Guides
One Setup, Everything CalculatesEnter your income, debts, savings, target home price, interest rate, and loan term on the Control Panel. Most tabs calculate from these inputs automatically. The Beginner Guide walks first-time buyers through the workbook step by step. The Pro Guide covers advanced strategies like DTI optimization, points analysis, and ARM vs fixed decision frameworks.
Affordability Dashboard
Know Before You ShopVisual analysis of your debt-to-income ratios — housing-to-income, total DTI, and FHA maximum. Each metric shows your value, the guideline, the max allowed, and a pass/fail status. See your monthly housing cost and whether your budget can handle it before you start looking at listings.
Rent vs Buy & Down Payment
The Real ComparisonThe Rent vs Buy calculator compares total cost of buying versus renting and investing the difference over 5, 10, and 20 years — factoring in appreciation, rent increases, investment returns, and selling costs. The Down Payment tracker shows your savings goal, current balance, monthly contribution, and projected timeline to reach your target.
Mortgage Comparison & Amortization
Three Loans, Full VisibilityCompare three mortgage scenarios side by side — different rates, terms, down payments, or loan types. See monthly payment, total interest, total cost, and break-even point for each. The Amortization tab shows a full month-by-month schedule with principal, interest, balance, and automatic PMI drop when you hit 80% loan-to-value.
Extra Payments & Closing Costs
See the Impact of Every DollarThe Extra Payments calculator shows how additional monthly or annual lump-sum payments reduce total interest and shorten your loan term. The Closing Costs estimator itemizes 23 line items across lender fees, title charges, prepaid items, and government fees — with estimate and actual columns so you can compare against your Loan Estimate document.
Home Scorer, First-Year Budget & Maintenance
Compare, Budget, and Plan AheadThe Home Search Scorer lets you rate and compare up to five properties on weighted criteria you define — location, price, size, condition, and more. The First-Year Budget covers expenses most buyers forget: utilities, setup costs, HOA, lawn care, and maintenance. The Maintenance Reserve tracker projects replacement timelines and costs for every major home system — roof, HVAC, water heater, appliances — based on age and expected lifespan.
How to Start Using It
Download the Workbook
Purchase on Etsy and download the Excel file or copy the Google Sheets version. Start on the Read Me tab for a guide to every tab and what it does.
Fill In the Control Panel
Enter your income, debts, savings, target home price, down payment, interest rate, and loan term. This takes five minutes and drives most of the workbook automatically.
Check Your Affordability
Open the Affordability Dashboard to see your DTI ratios and whether your target home fits your budget. Adjust the Control Panel inputs until the numbers work.
Compare Scenarios
Use the Mortgage Comparison tab to evaluate different loan options. Run the Rent vs Buy calculator to see if buying makes financial sense for your timeline. Check the Extra Payments tab to see how additional payments affect your total cost.
Score Properties and Plan for Move-In
As you tour homes, use the Home Scorer to compare them objectively. Once you're under contract, fill in the Closing Costs estimator with your Loan Estimate figures. Use the First-Year Budget and Maintenance Reserve tabs to plan your homeowner finances.
Why This Instead of Online Calculators
Online mortgage calculators give you one number — a monthly payment. They don't show you the amortization schedule, the total interest over the life of the loan, or what happens if you pay an extra $200 per month. They don't compare three loan scenarios side by side. They don't factor in closing costs, first-year homeowner expenses, or maintenance reserves. This workbook does all of it in one file.
Free spreadsheet templates usually cover one piece of the puzzle — a mortgage calculator or a budget sheet. This workbook covers the entire buying process from affordability analysis through your first year of ownership. Fifteen tabs, all connected to one Control Panel, all calculating from your actual numbers.
This is the workbook you'll wish you had when you realize the lender's estimate didn't include half the costs you're about to pay. One file. Every number. No surprises.
Visit the Etsy shop for the most up-to-date pricing, sales, and discounts.