🏠 Rent vs Buy & Home Purchase Analysis

For real estate agents and loan officers. Compare the projected net worth of buying a home vs renting and investing, compare homes and loan options side by side, and prepare a branded client report — based on the numbers you enter.

Tap ƒ to see the formula.

📍 Market preset Save presets with your local numbers on the Agent tab.
🏠 Buying a Home
The tax on a listing is usually the seller’s bill. In many areas the home is reassessed after a sale, at or near the price paid, so the buyer’s bill can be higher. Use the county’s estimate for a new owner where one is available.
▶ More options (HOA, maintenance, mortgage insurance, selling, rental income, buydown…)
Conventional PMI applies only when the down payment is below 20%. Rates depend on credit score and down payment.
Some states limit how fast the taxed value can rise (for example 2% a year in California for a home you keep). Property tax then grows at the lower of this rate and home appreciation.
For example a large HOA repair bill. Leave at 0 if none.
One point usually costs 1% of the loan and lowers the rate by an amount the lender sets — enter the rate that goes with these points above.
Lowers the cash needed at closing. It can pay closing costs, points and a buyer-paid buydown, not the down payment. Program limits: conventional 3% of the price with less than 10% down, 6% with 10–25%, 9% with more; FHA and USDA 6%; VA 4% in concessions (normal closing costs and market-rate discount points paid by the seller are not counted).
Paid on top of the regular payment from Year 1. It pays the loan off sooner and is counted in the cost of buying. With PMI ends set to Standard it does not end PMI sooner, and it does not lower FHA or USDA annual premiums (they follow the original payment schedule); Early cancellation uses the actual balance.
Federal rules allow one only on certain fixed-rate qualified loans: at most 2% in years 1–2 and 1% in year 3, none after. FHA, VA and USDA loans have none. Leave at 0 unless your loan states one.
The exclusion applies if the owner owned and lived in the home 2 of the 5 years before the sale, so this estimate applies it only to a sale at the end of Year 2 or later (a partial exclusion can apply to an earlier sale for some reasons, such as a job move — check with a tax professional). Gain above it is taxed. The estimate uses the purchase price as the cost basis and ignores improvements. State taxes not included.
For example a rented room, garage or ADU. It grows with the rent increase rate. Lenders count rental income only under their own rules, so this changes the budget, not necessarily loan approval.
The loan keeps its note rate. A subsidy lowers the payment in the first years; it does not change the balance.
🔁 Refinance (optional)
🏘️ Rental conversion scenario — simplified estimate (optional)
🧾 Federal tax benefit (optional)
📈 Market Assumptions
Applied to the growth of the invested cash in the net worth figures, on both paths (for example 15% long-term capital gains).
🏢 Renting
💡 How it works

Same cash on both paths: each year, both paths spend the same amount. The path with the lower housing cost invests the difference — the renter at the start (down payment and closing costs), and whichever path is cheaper in each later year.

Buy path: mortgage, property tax, insurance, HOA, maintenance and mortgage insurance. Net worth = home value − loan balance − selling costs, plus any invested savings.

Rent path: rent and renters insurance. Net worth = the invested cash, grown at the investment return.

Net-worth break-even: the first year buying's projected net worth catches up with renting + investing. The results show whether buying stays ahead after that.

Every value can be edited by hand, including the pre-filled figures — use the client’s quotes and your local market numbers.

🖼️ Property details (for the report)
Tap ƒ to see the formula.
Net-Worth Break-Even
—
Net Worth (Buy) at Year 10
—
Net Worth (Rent) at Year 10
—
Monthly Cost (Buy, Yr 1 est.)*
—
Monthly Cost (Rent, Yr 1 est.)
—
Difference at Year 10
—
💵 What you’ll pay each month (Year 1 estimate)
📈 Monthly cost over time: rent vs buying
🧮 Average monthly cost over the stay (after equity and appreciation are counted)
💰 Estimated cash needed upfront
Cash available (optional): $
📏 Debt-to-income (estimate)
Gross monthly income: $ · Other monthly debt payments: $
Limits to check against — edit to the lender’s numbers: front-end % · back-end %
🏦 Mortgage over time
🎯 If the monthly payment needs to come down
Payment the client is comfortable with: $ /mo
🔢 Monthly payment at other prices and rates
Net Worth Over Time — Buy vs Rent + Invest
Buy (home equity after selling costs + any invested savings)
Rent + Invest (portfolio)
Net-worth break-even year
Who is ahead each year (Buy − Rent + invest)
Buy ahead
Rent + invest ahead

Each bar is buying’s projected net worth minus renting + investing’s, for that year — the same figures as the Advantage column in the year-by-year table.

Year-by-Year BreakdownTap ƒ or any number to see its formula.
Year Buy: Total Cost Buy: Home Value Buy: Equity (gross) Buy: Invested Savings Buy: Net Worth Rent: Total Cost Rent: Portfolio Advantage
Open an empty Excel or Google Sheets sheet, click cell A1 once (don’t double-click), then press Ctrl + V (Cmd + V on Mac). Every cell keeps its formula, so you can change any input in the sheet and all results update automatically.

* Monthly Cost (Buy, Yr 1 est.) does not subtract any tax benefit, rental income or buydown. The year-by-year table includes those items, so its Year 1 figure can differ.

* Buy Net Worth = Home Value − Loan Balance − Selling Costs − any prepayment penalty and capital gains tax on a sale + Invested Savings. Both paths start from the same cash and spend the same amount each year; the cheaper path invests the difference at the investment return.

* Payments are worked out with the standard monthly mortgage formulas for each year (the same PMT, FV and NPER functions Excel uses). Conventional PMI is counted month by month until it ends (Standard follows the loan’s original payment schedule, so extra principal payments do not end it sooner); FHA and USDA annual premiums use each year’s average scheduled balance on the loan’s original payment schedule, as HUD and USDA do, so extra principal payments do not lower them. Actual eligibility, rates and rules vary by loan and lender.

* Year 1 property tax and maintenance are based on the purchase price (or the $ property tax entered). From Year 2 they follow the home value at the start of each year; property tax grows at the lower of home appreciation and the taxable value growth limit, if one is entered.

🏁 If the home is sold
Sold at the end of year · Next home price (optional): $
⏳ Buying now vs waiting
Wait years · Rate at that time % · Price change while waiting %/yr