Revenue & Calc
Set rent by apartment class, occupied share, and launch date. Monthly calculations allocate one occupied pool without duplicating available units.

The Real Estate Rental Financial Model is an Excel template forecasting rent, property expenses, staffing, and investment performance. Monthly revenue comes from available apartments, occupied share, five unit classes, and their individual rents.
The illustration models an owner-operated, 48-unit suburban Columbus, Ohio apartment property acquired with equity. Its 2026–2030 projections include an optimistic 15% rent premium over a previous baseline, not verified leases or market averages.
Rent assumptions feed monthly calculations, operating budgets, projected statements, funding schedules, and investment analysis.
Set rent by apartment class, occupied share, and launch date. Monthly calculations allocate one occupied pool without duplicating available units.
Budget repairs, external trades, collection costs, taxes, insurance, services, and salaries separately.
Schedule acquisitions, improvements, equipment, owner equity, and optional debt; the example has no confirmed outside funding.
Income Statement, Cash Flow, Balance Sheet, Summary, and Sources & Uses connect operating results to working capital and funding.
Rent equals occupied apartment-months allocated across five classes multiplied by each class’s monthly rent.
Studios, two one-bedroom classes, and two two-bedroom classes account for approximately 8.33%, 25%, 16.67%, 33.33%, and 16.67% of the same 48-apartment pool.
Occupancy is 85%, 90%, 93%, 94%, and 94% from 2026 through 2030. Example 2026 monthly rents include $1,265 for studios, $1,495 for standard one-bedrooms, and $2,070 for renovated two-bedrooms.
The Revenue Forecast links class-specific rents and occupancy to annual totals. Monthly Calc activates rent in January 2026, treating the launch month as full; earlier months earn none.
$82,340 potential monthly rent at full occupancy × 85% occupied share × 12 active months = $839,868 annual revenue.
Operating expenses separate repair costs, revenue-linked fees and losses, fixed budgets, and payroll.
COGS covers repair materials and contracted trades at approximate rates of 1.74% and 2.61% of revenue. Adjusted rates preserve the original dollar budgets for unchanged physical activity despite the rent premium.
Variable costs include 0.2% collection fees and 1% rent losses. Fixed budgets cover property taxes, insurance, utilities, grounds, professional services, software, advertising, communications, and inspections.
The COGS and Operating Expenses report separates direct costs, revenue-linked fees, and fixed expenses. Monthly property taxes rise from $7,500 in 2026 to $8,700 in 2030.
| Expense group | 2026 | 2030 |
|---|---|---|
| Direct costs (COGS) | $36,516 | $45,391 |
| Variable expenses | $10,078 | $12,528 |
| Fixed expenses | $191,400 | $221,640 |
| Payroll | $65,000 | $65,000 |
| Total operating expenses | $302,994 | $344,559 |
Whole-dollar display rounding can create small differences in the sum of displayed rows.
The Payroll Forecast budgets 0.5 manager FTE at $75,000 base per full-time role and 0.5 maintenance FTE at $55,000. Annual salaries total $65,000; contracted trades remain separate.
Startup assets, land and preopening cash, working capital, reserves, and equity are budgeted separately from operating expenses.
The $5,396,000 asset budget comprises a $4,800,000 building, $480,000 improvements, $96,000 appliances, $12,000 maintenance equipment, and office furniture and IT.
The Capital Expenditure Plan schedules property and equipment purchases and tracks depreciation for eligible assets. Nondepreciable acquisitions remain separate from operating repairs.
Also budgeted are $1,350,000 in land and prelaunch cash, $6,263 initial working capital, and a $73,649 reserve. Estimated owner funding totals $6,825,912 without confirmed outside financing.
The Sources and Uses of Funds report connects equity and optional debt with acquisition, startup spending, and retained cash. No loan is secured or drawn in the all-cash example.
The 48-apartment optimistic case projects annual revenue, operating expenses, and EBITDA for 2026–2030.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $839,868 | $302,994 | $536,874 |
| 2027 | $916,844 | $314,705 | $602,139 |
| 2028 | $975,897 | $325,541 | $650,356 |
| 2029 | $1,015,189 | $335,281 | $679,908 |
| 2030 | $1,043,987 | $344,559 | $699,428 |
Selected scenario estimates, rounded to whole dollars; forecast figures are not historical results or local market averages.
In 2030, $1,043,987 revenue produces $699,428 EBITDA, a 67.00% margin. Before the premium, 2030 revenue was $907,814 and EBITDA $564,890, a 62.23% margin.
The case is documented through EBITDA only. Income Statement, Cash Flow, and Balance Sheet reports exist, but verified after-tax profit and ending cash figures were not supplied.
The Cash Flow Forecast reconciles operating, investing, and financing movements to closing cash. Use it to analyze collections, property purchases, equity injections, and liquidity instead of equating EBITDA with cash.
Returns, scenario controls, and valuation reports evaluate different acquisition decisions.
Sales break-even compares rents against operating thresholds; cash break-even tests timing of cash coverage. Payback tracks recovery of invested cash, while annual ROIC measures return on invested capital.
Dashboard Low, Base, and High controls vary revenue and cost assumptions. Debt schedules model optional loans, and Valuation discounts unlevered free cash flow with terminal assumptions.
The Returns analysis compares break-even, cumulative project cash flow, investment payback, and annual ROIC. No verified payback date, IRR, or ROIC value is supplied.
For apartment buyers and operators, the template connects unit mix, occupancy, costs, and acquisition capital.
Edit unit mix, rents, occupancy, costs, staffing, launch date, and funding for the target property. Compare the resulting earnings, cash requirements, and returns.
Validate local rents, taxes, insurance, building condition, and purchase costs; the illustrated property is not a market survey or appraisal.
These answers clarify how the spreadsheet handles apartment inventory, rent assumptions, financing, and the distinction between operating earnings and investor returns.
Yes. The Revenue sheet has distinct annual rent assumptions for studios, standard and renovated one-bedrooms, and standard and renovated two-bedrooms.
No. Annual occupied shares are 85%, 90%, 93%, 94%, and 94%, applied to the same 48-unit capacity.
No. The premium is an optimistic planning selection, not an observed local lease level or verified industry benchmark.
Yes. The example includes 0.5 FTE for each role, totaling $65,000 in fixed annual base salary; the stated case excludes employer taxes and benefits.
No. The illustrated acquisition is all-cash, although Dashboard debt controls can model optional financing structures.
No. Returns separately evaluates break-even, payback, and annual ROIC. No verified payback period or ROIC outcome was provided.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
The low, base, and high cases were already set up, so I wasn’t bouncing between versions anymore. It cut my scenario work by about 6 hours and made the assumptions easy to compare.
I didn’t have to start from scratch, which made the whole build feel manageable. I had a working rental model the same day and booked my planning meeting right after.
The statements and charts were finally together in one file, so I wasn’t hunting across tabs and folders. That cleaned up my monthly reporting and saved me a couple of hours each update.