Real Estate Deal Analysis in 2026: The Simple Underwriting Template I Use to Decide Yes or No Fast
Why most deal analysis is either too shallow or too complicated
Real estate investors tend to fall into one of two traps.
Trap one: they eyeball it.
“If it feels like it cash flows, I’ll buy it.”
Trap two: they build a spreadsheet so complex that they never make decisions.
In 2026, the most effective underwriting is simple, conservative, and repeatable. You want a template that forces you to model reality and identify risk, without turning every decision into a week-long project.
This guide gives you a clean underwriting template you can use for long-term rentals, mid-term rentals, or short-term rentals.
The 10 inputs you need before you do anything
Before you underwrite, get these numbers.
- Purchase price
- Down payment and loan terms
- Interest rate and amortization
- Expected rent or average monthly revenue
- Property taxes
- Insurance
- Utilities responsibility
- HOA or condo fees
- Expected repairs and capex reserve
- Property management cost assumption
If you do not have these, you are not underwriting yet. You are guessing.
Step 1: Model income conservatively
Do not use the best-case rent.
Use conservative income based on realistic comps.
Long-term rentals
Use local rent comps. Then use a conservative number.
Mid-term rentals
Use realistic monthly averages, not the best travel nurse month.
Short-term rentals
Use a conservative average across the year, not peak season.
Step 2: Apply a vacancy factor even if you “won’t have vacancy”
Every property has a vacancy.
If you underwrite zero vacancy, you are underwriting a fantasy.
Vacancy might be:
5 percent for a stable LTR
Higher for mid-term, depending on demand
Higher for STR depending on seasonality and management
The point is not the exact number. The point is that it exists.
Step 3: Model operating expenses like a real operator
Here is a simple expense stack I use.
Property taxes
Insurance
Repairs and maintenance reserve
Capex reserve
Property management or owner time cost
Utilities if owner-paid
HOA if applicable
Landscaping and snow removal
Pest control
Leasing and advertising
Licensing and permits, where applicable
Supplies for furnished rentals
If you leave out reserves, you are not underwriting the property. You are underwriting a perfect year.
Step 4: Calculate net operating income
Net operating income is simply:
Income minus operating expenses, excluding debt service.
This number matters because it tells you whether the property is operationally strong before financing.
A weak NOI can sometimes be fixed by better operations, but you need to identify that honestly.
Step 5: Add financing and calculate real cash flow
Debt service is the mortgage payment.
Cash flow is:
NOI minus debt service.
This is the number most investors focus on, but it is not the only number that matters.
Step 6: Calculate cash on cash return
Cash on cash return is:
Annual cash flow divided by cash invested.
Your cash investment usually includes:
Down payment
Closing costs
Initial repairs
Initial furnishing, if applicable
Initial reserves
This tells you how hard your cash is working.
Step 7: Stress test the deal
If you want to be a real operator, stress test.
Ask:
What if rent is 10 percent lower?
What if the vacancy is double?
What if repairs are higher?
What if insurance increases?
What if interest rates change on a future refinance?
What if local regulations change for STR?
If the deal breaks under mild stress, it is not a stable deal.
Step 8: Identify the risk category
Every deal has a risk category.
Low risk: stable LTR in a strong area with conservative leverage
Medium risk: value-add deal with a manageable renovation scope
High risk: aggressive STR with seasonal demand and high leverage
Your risk category should match your experience and your reserves.
Step 9: Decide your exit plan before you buy
Do you plan to:
Hold long-term
Refinance after stabilization
1031 exchange later
Sell after improvements
Convert the rental model later
Your exit plan affects what numbers matter most.
Step 10: Make a decision with a simple scorecard
I like a simple scorecard:
Does it cash flow after reserves?
Does it survive a mild stress test?
Is the neighborhood and tenant demand strong?
Is the property condition manageable?
Do I have the reserves to survive surprises?
Does this fit my portfolio strategy?
If you cannot say yes, say no.
The one-page underwriting template
Here is a simple template you can copy and use.
Purchase price:
Down payment:
Loan amount:
Interest rate:
Term:
Monthly payment:
Gross monthly income:
Fewer vacancies:
Effective monthly income:
Monthly operating expenses:
Taxes:
Insurance:
Utilities:
HOA:
Repairs and maintenance reserve:
Capex reserve:
Management:
Other:
Monthly NOI:
Monthly debt service:
Monthly cash flow:
Cash invested (total):
Annual cash flow:
Cash on cash return:
Stress test notes:
Exit plan:
Decision: Yes or No
Common underwriting mistakes in 2026
Using the best-case rent
Ignoring vacancy
Ignoring reserves
Ignoring insurance increases
Ignoring the property taxes reassessment risk
Assuming maintenance will be minimal
Underestimating turnover and leasing costs
Buying because “everyone else is doing it.”
Important note
This article is educational and is not financial advice. Deal analysis depends on market conditions, financing terms, property condition, and operational execution. Work with qualified professionals to evaluate specific deals.