Estimated market value support based on building square footage and area price per square foot.
Underwrite the rental deal before you buy it.
Analyze rental income, operating expenses, financing terms, renovation costs, valuation support, exit assumptions, and long-term investment performance through a comprehensive real estate underwriting model.
Year 1 net operating income divided by purchase price.
Annual before-tax cash flow relative to invested equity.
Total upfront capital including equity, closing costs, reserves, and cash-funded improvements.
Model Workspace
Build the deal from property basis to NOI, valuation, financing, and exit returnsStart with the asking price, building size, and market price support before underwriting income, expenses, valuation, and debt.
Enter unit-level rent, occupancy, renovation status, downtime, rent growth, and stabilized occupancy assumptions.
Rent Roll & Occupancy
Unit-level income and lease-up assumptions| Unit | Sq Ft | Monthly Rent | Occupied | Needs Reno | Months to Occupy | Remove |
|---|---|---|---|---|---|---|
| 1 |
Set current monthly operating costs and growth assumptions by expense category. Taxes, insurance, HOA, and general operating expenses can grow at different rates instead of using one blended opex rate.
Property taxes are separated from general opex because they often follow reassessment cycles and can grow differently from controllable expenses.
Insurance and flood coverage are grouped separately because premiums can rise faster than normal operating expenses in higher-risk markets.
HOA and common charges can follow their own assessment path, separate from taxes, insurance, and controllable operating costs.
Utilities, repairs, management, CapEx reserve, and miscellaneous expenses use one general opex growth rate to keep the model compact.
Set the primary mortgage assumptions. These inputs determine the loan amount, monthly mortgage payment, annual senior debt service, and DSCR.
Model the renovation budget, financed portion, cash-funded portion, and short-term renovation debt service. Auto mode estimates the budget from the local price-per-square-foot gap.
Review combined mortgage and renovation debt, total monthly debt service, DSCR, and cash needed to start the deal.
Control hold period, exit timing, terminal valuation, and return assumptions used in the pro forma.
Pro Forma
Year-by-year income, expenses, debt service, and returns| Line Item |
|---|
| Enter deal assumptions above to build the pro forma. |
Underwrite rent growth before underwriting the dream.
The value of an investment property is ultimately tied to the income it can realistically produce. Before relying on appreciation or assuming a future buyer will pay more, investors should test whether rent growth, occupancy, expenses, and debt service support the purchase price.
A disciplined rental property analysis starts with realistic income assumptions. Market rent, lease-up timing, vacancy loss, operating costs, renovation needs, and exit cap rates should be reviewed before capital is committed. The purpose of a pro forma is not to justify a purchase. Its purpose is to determine whether the investment creates value under realistic assumptions.