Set Potential Rent
Set potential gross rent from rentable units or area and market rent, or the property’s monthly rent input.

It is an editable Excel workbook that projects five years of property-level rental revenue, operating costs, three scenarios, financial statements, and management reports.
Use the workbook to translate property rent starts, monthly rent, occupancy, concessions, credit loss, other income, costs, staffing, capital spending, and financing into a structured forecast.
Inputs flow through the model’s calculations into scenario comparisons, financial statements, and management views so operating changes can be reviewed consistently.
The model calculates recurring rental revenue property by property, moving from potential rent through occupancy, concessions, other income, credit loss, and monthly EGI.
Set potential gross rent from rentable units or area and market rent, or the property’s monthly rent input.
Apply occupancy to potential gross rent to calculate occupied rent.
Reduce occupied rent by concessions to determine base rent.
Add enabled property income and subtract credit loss to calculate monthly EGI.
Sum monthly EGI across active properties after each rent-start date for annual rental revenue.
The Rent Revenue worksheet groups property rent starts, monthly rent, occupancy, effective gross income, and property operating expense assumptions in one operating view.
The Corp_OPEX worksheet separates variable and fixed expenses, with timing, annual spending assumptions, periodicity, and monthly forecast output for operating planning.
The Scenarios view compares Low, Base, and High revenue and operating-income paths across the five-year forecast for structured decision analysis.
The Dashboard combines setup controls, scenario assumptions, scenario outputs, key metrics, profitability, cash flow, property sale results, and investment payback charts.
The ready-made workbook fits recurring property-rental planning; materially different revenue logic, operating schedules, or reporting structures are better suited to custom modeling.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or reporting from the ready-made workbook.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive an editable Excel workbook with five-year projections, scenario analysis, financial statements, and management reports available by instant download.
Modify the supplied assumptions and inputs in the fully editable Excel file.
Plan across the model’s five-year projection horizon with linked operating and financial outputs.
Compare Low, Base, and High cases in the dedicated Scenarios view.
Review the Income Statement, Cash Flow Statement, Balance Sheet, Dashboard, Summary, and analytical reports.
The essential answers are visible in full, with no accordion clicks required.
It calculates property-level rental revenue from potential rent, occupancy, concessions, enabled other income, and credit loss, then sums monthly EGI across active properties.
You can change property details, rent-start dates, rentable units or area, rent, occupancy, concessions, credit loss, rent escalation when modeled, and enabled other-income assumptions.
The Scenarios view compares Low, Base, and High revenue, net operating income, margins, and operating income across the forecast.
The product gallery shows the Income Statement, Cash Flow Statement, Balance Sheet, Dashboard, Summary, Valuation, Break-Even, Sources & Uses, ROIC, Ratios, DuPont, Charts, and KPIs.
Yes. Financial Models Lab offers custom financial modeling for different revenue logic, operating schedules, or reporting requirements.
No. The workbook is a planning forecast driven by editable assumptions, not a guarantee of future business results.
Get instant access to a downloadable short term rental proforma template that includes everything you need to build a complete financial plan for your property management business.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark
I’m not strong in Excel, but this template made the model feel manageable instead of overwhelming. I saved hours because I could follow the setup without digging into advanced formulas.
I used to struggle to spot margins and break-even points, but this model put them in plain view. It helped me map out pricing and see a clearer path before booking a meeting.
One broken formula used to throw off my whole sheet, so this template was a relief. The structure helped me catch issues fast and cut cleanup time by a few hours.