Blog · Finance metrics and formulas
Real estate financial statement analysis connects property operating income with capital spending, debt and cash needs. Follow a corporate property portfolio from statement exports through a worked operating and cash reconciliation.
Real estate financial statement analysis connects property operating performance to the cash a business must supply or can retain. Calculate net operating income, reconcile it to the property accounting result, then subtract the actual capital and financing cash requirements before making portfolio spending decisions.
Start with the property trial balance, rent and recovery detail, capital expenditure register, debt schedule and reconciled cash balances. Use the same fiscal period and property identifiers throughout. Keep actual postings distinct from budgets and proposed projects.
This review concerns a business-owned income-producing property portfolio. A headquarters building occupied by the business has a different revenue basis and should be reviewed separately. Eliminate intercompany rent and balances when reconciling the consolidated company, even if they are useful for internal responsibility reporting.
Write down the operating-income definition. Nareit's NOI explanation includes property revenue less operating expenses and excludes debt service, depreciation and capital expenditures. The exact scope still needs a consistent company policy, especially for property management charges and central costs.
Use real estate financial reporting for the reporting package and real estate financial modeling for forward assumptions. The task here is to explain actual results from completed periods.
An illustrative US company owns two commercial properties, East and West. The table shows one complete fiscal year in USD. Revenue is recognized revenue, and expenses are positive amounts. The example has no noncash rent adjustments.
| Annual statement line | East (USD) | West (USD) | Portfolio (USD) |
|---|---|---|---|
| Rental revenue | 820,000 | 560,000 | 1,380,000 |
| Tenant recoveries | 80,000 | 40,000 | 120,000 |
| Total property revenue | 900,000 | 600,000 | 1,500,000 |
| Property taxes | 90,000 | 80,000 | 170,000 |
| Utilities | 60,000 | 50,000 | 110,000 |
| Repairs and maintenance | 110,000 | 100,000 | 210,000 |
| Property management | 80,000 | 70,000 | 150,000 |
| Total property operating expenses | 340,000 | 300,000 | 640,000 |
| Net operating income | 560,000 | 300,000 | 860,000 |
| Depreciation | 140,000 | 90,000 | 230,000 |
| Interest expense | 110,000 | 70,000 | 180,000 |
| Property result before income taxes | 310,000 | 140,000 | 450,000 |
With rental revenue in row 2 and East in column B, enter the revenue total in B4:
=SUM(B2:B3)
Enter operating expenses in B9 and NOI in B10:
=SUM(B5:B8)
=B4-B9
The property result in B13 is:
=B10-B11-B12
Copy the formulas across to West. The portfolio column sums the property amounts on each row. Portfolio NOI margin is =D10/D4, or 57.3%, rounded to one decimal place. It is the ratio of total NOI to total revenue, rather than an average of property percentages.
The $450,000 result is a property-level subtotal before income taxes. It is not consolidated company net income: central expenses, other businesses and any excluded company items still need reconciliation.
NOI does not show whether collections funded the year's capital projects and debt repayments. The next table assumes interest paid equals interest expense. Working capital use includes changes in operating receivables, prepayments, payables and tenant-related operating balances; a negative amount releases cash.
| Cash bridge | East (USD) | West (USD) | Portfolio (USD) |
|---|---|---|---|
| Net operating income | 560,000 | 300,000 | 860,000 |
| Less interest paid | 110,000 | 70,000 | 180,000 |
| Less working capital use | 20,000 | -10,000 | 10,000 |
| Operating cash after interest | 430,000 | 240,000 | 670,000 |
| Less capital spending paid | 220,000 | 180,000 | 400,000 |
| Less debt principal repaid | 150,000 | 100,000 | 250,000 |
| Net property cash movement | 60,000 | -40,000 | 20,000 |
Rebuild this second table with NOI in B2. Operating cash in B5 is =B2-B3-B4; net property cash movement in B8 is:
=B5-B6-B7
West produces $300,000 of NOI but consumes $40,000 after the listed cash requirements. Its operating result is positive; its capital program and repayments require support from existing cash or the wider company. East provides $60,000, leaving the portfolio with a $20,000 increase.
Check the result from the accounting subtotal too: $450,000 plus $230,000 depreciation, less $10,000 working capital use, $400,000 capital spending and $250,000 principal equals $20,000. Interest is already deducted in the starting subtotal, so deducting it again would understate cash.
The SEC's financial-statement guide distinguishes operating, investing and financing cash flows. Keep those classifications in the final company report even when management also wants a combined property cash bridge.
The example has no new borrowing, asset sales, distributions, restricted-cash changes or other movements. Opening balances and the transactions already shown produce these closing balances:
| Balance roll-forward | Opening (USD) | Additions (USD) | Reductions (USD) | Closing (USD) |
|---|---|---|---|---|
| Cash | 300,000 | 20,000 | 0 | 320,000 |
| Debt principal | 5,250,000 | 0 | 250,000 | 5,000,000 |
| Property and equipment, net | 8,000,000 | 400,000 | 230,000 | 8,170,000 |
Each closing balance equals opening plus additions less reductions. Match cash to reconciled bank balances, debt to lender schedules, and property and equipment to the asset register. In a real file, separate unpaid capital invoices from capital spending paid; the accrual addition and investing cash movement need not occur together.
Use the monthly financial report template for a consistent statement layout. Document exceptions beside the reconciliation, following the traceability principles in AI for financial analysis.
The property controller owns the account ties. Asset managers explain maintenance and capital choices; treasury verifies debt payments and funding dates. Review those findings together before delaying a project or assuming another property can fund it.
Upload a sample of your own property statements, capital records and debt schedules to Covirage. Covirage maps the columns, its tools compute and check operating results and cash movements, and the external AI model explains the findings with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See FP&A reporting for the supporting portfolio reporting workflow.
No. Net operating income measures revenue after property operating expenses under a stated definition. Cash also reflects collection and payment timing, interest, principal repayments and capital spending. Build a separate reconciliation rather than assuming the NOI subtotal is available cash.
Capital expenditures are excluded from the NOI definition used here and appear in a separate cash bridge. Routine repairs remain operating expenses. Have the accounting team confirm classification under the company's capitalization policy before comparing properties or periods.
Use property-level revenue and expense detail, balance sheets, capital expenditure records, debt schedules and bank reconciliations for the same period. Retain property identifiers and intercompany flags so totals can be checked against the consolidated company statements.