The model is confessing. Read it that way.
Every spreadsheet has one or two numbers quietly carrying the sales pitch. Find them before they start carrying your money.
If one assumption saves the deal, it is not conservative. It is fragile. The useful move is not memorizing "Operating expenses: the full breakdown." It is knowing what you would verify next.
Operating expenses are the cost of running the property before debt service and capital events.
They are not whatever survives after somebody finishes admiring the rent growth. They are taxes, insurance, payroll, repairs, utilities, contracts, management, and administration. In machinery terms, revenue is the output gauge. Operating expenses are the oil, belts, filters, and labor keeping the needle off zero.
Skip one because it makes the model prettier and the property will put it back. Usually with a rush charge.
Open the machine
The categories are simple. The proof is where people suddenly become poets.
| Bucket | What belongs there | What to check |
|---|---|---|
| Taxes | Property taxes and assessments | Current bill, reassessment rules |
| Insurance | Property, liability, wind, flood where applicable | Renewal quote, not last year’s wish |
| Payroll | On-site staff, leasing, maintenance | Staffing plan and market wages |
| Repairs and maintenance | Routine fixes | T-12 detail and unit condition |
| Utilities | Water, sewer, electric, gas, trash | Bills and reimbursement policy |
| Contract services | Landscaping, pest, security, cleaning | Vendor contracts |
| Management | Property management fee | Management agreement |
| Admin and marketing | Office, software, leasing ads | General ledger detail |
Capital expenditures are different. Replacing a roof is not the same as fixing a sink. Blend those together and you lose the wear schedule: routine operations look artificially heavy one year, while the future replacement bill quietly disappears from the next.
If the accounting cannot tell a repair from a replacement, the underwriting cannot tell normal operation from a machine eating its own parts.
A math example sponsors do not frame
Assume EGI is $1,100,000 and modeled operating expenses are $440,000.
Expense ratio:
$440,000 / $1,100,000 = 40.0%
Now taxes are understated by $45,000 after reassessment, insurance renews $38,000 higher, and payroll is short $25,000.
Revised expenses:
$440,000 + $45,000 + $38,000 + $25,000 = $548,000
Revised expense ratio:
$548,000 / $1,100,000 = 49.8%
Nothing exotic happened. The tax bill arrived, the insurer named its price, and employees expected market wages. Three ordinary parts wore out the 40.0% story.
That is not a footnote. That is NOI taking the full repair bill.
Historical, normalized, and projected are different tools
Good review separates historical, normalized, and projected expenses.
| Version | Question |
|---|---|
| Historical | What did the seller actually spend? |
| Normalized | What should a competent operator spend? |
| Projected | What does this plan assume after takeover? |
Historical spending can be too low because maintenance was deferred. It can also be too high because the seller ran a bloated operation or booked costs strangely. Normalizing is the work of explaining those differences line by line. Projecting is the work of proving what changes after takeover, when it changes, and who can actually deliver it.
Do not let “we operate better” remove payroll, repairs, or contracts without a staffing plan, vendor quote, or operating history. Better operators still change filters. They just know which filter, how often, and what failure costs.
Pull the service records
Start with the general ledger. Tie the largest lines to the documents that created them:
- Tax bills, assessments, and the post-sale reassessment method.
- Insurance policies, current loss runs, and a renewal or acquisition quote.
- Payroll registers, staffing schedules, and market compensation.
- Utility bills by month, meter arrangement, and reimbursement collections.
- Repair invoices, work-order history, service contracts, and unit-condition reports.
- The management agreement and the actual fee calculation.
A percentage is a dashboard light. It tells you where to open the hood; it does not identify the failed part.
Red flags with fingerprints
Slow down when taxes still reflect the seller’s basis, insurance is carried at last year’s premium, or repairs fall while an aging property somehow needs less attention. The same goes for payroll savings without a coverage schedule, utilities without twelve months of bills, and management fees calculated on the wrong revenue base.
The sharpest red flag is a total with no general-ledger detail. A clean annual number can hide twelve ugly months, owner-paid expenses, miscoding, or work that simply was not done.
Ask the questions that force the expense story to show its parts:
- Which five lines move NOI the most if the assumption is wrong?
- What did the seller pay, what should normal operation cost, and what exactly changes in year one?
- Which expenses reset at sale or renewal?
- What maintenance has been postponed rather than eliminated?
- Who supplied each quote, and when does it expire?
The five-line proof
Pick the five largest expense lines and put the source document beside each one. Then add 10% to controllable operating expenses and rerun NOI. If the deal becomes fragile, that fragility was already in the machine. You just took the cover off.
Build costs from the general ledger and current quotes, not from a percentage someone liked. Percentages are summaries. Invoices, contracts, bills, payroll records, and maintenance history are sources.
PR Steinfurth Equity provides educational information only. Nothing on this website is an offer to sell or a solicitation of an offer to buy any security, nor investment, legal, or tax advice. Any securities offering is made only to qualified investors through official offering documents. Real estate investments involve risk, including possible loss of principal. Past performance is not indicative of future results.