12.4 Reconstructing the Operating Statement
Key Takeaways
- The standard reconstructed operating statement flows as: PGI − vacancy and collection loss = EGI; EGI − operating expenses = NOI.
- Reconstruction replaces the owner’s accounting statement with market-supported rents, vacancy, expenses, and consistent reimbursement treatment for appraisal use.
- NOI is before debt service, book depreciation, and income taxes; those items are removed when present on owner statements.
- Work every line in order—exam traps often insert mortgage payments, capital projects, or personal expenses into “NOI” calculations.
- Stabilized reconstructed NOI is the income input most often capitalized with an overall rate in direct capitalization (Chapter 13).
The Statement the Exam Expects You to Build
ECO VI.d Direct capitalization methods explicitly includes reconstruction of the operating statement. Even before you multiply by a factor or divide by a cap rate, you must produce a clean net operating income. Chapters 12.1–12.3 gave the ingredients; this section is the recipe and the kitchen math.
Master formula chain
Potential Gross Income (PGI)
− Vacancy and Collection Loss
= Effective Gross Income (EGI)
− Operating Expenses (including reserves if applicable)
= Net Operating Income (NOI)
Optional detail form:
Rental income at market (or contract, per rights)
+ Other income
+ Expense reimbursements
= PGI
− Vacancy & collection loss
= EGI
− Fixed expenses
− Variable expenses
− Replacement allowance
= NOI
Never in the NOI stack for standard real-property NOI:
- Debt service
- Depreciation (accounting)
- Income taxes
- Capital improvements as raw one-year dumps (normalize)
- Business enterprise expenses unrelated to real estate
Why “Reconstruct”?
Owner statements serve tax, cash management, or vanity accounting. Appraisers reconstruct to answer: What NOI would a typical investor expect on a stabilized, market basis for the rights appraised?
| Owner statement issue | Reconstruction action | |---|---|---| | Below-market rents on fee simple job | Reprice to market rent | | No management fee (self-managed) | Impute market management | | Mortgage payment listed as expense | Remove debt service | | Depreciation listed | Remove | | Roof replacement in repairs | Normalize; use reserves | | Personal truck / travel in expenses | Remove | | Vacancy ignored (shows only collected rent) | Build PGI then apply V&C | | Reimbursements netted against expenses only | Show gross income and expenses consistently |
Full Worked Reconstruction — Multifamily Case
Given: Owner’s “Annual Operating Statement” (as provided)
Property: 48-unit apartment community
Rights / premise: Fee simple, stabilized market value, direct capitalization
Unit mix & owner scheduled rents (monthly):
| Type | Units | Owner rent/mo | Market rent/mo |
|---|---|---|---|
| Studio | 8 | $900 | $950 |
| 1BR | 24 | $1,100 | $1,200 |
| 2BR | 16 | $1,350 | $1,450 |
Owner’s cash report (annual):
| Owner line | Amount |
|---|---|
| Rents collected | $620,000 |
| Laundry and parking income | $14,400 |
| Real estate taxes | $48,000 |
| Insurance | $14,000 |
| Utilities (landlord) | $36,000 |
| Repairs & maintenance | $72,000 |
| Payroll / on-site | $40,000 |
| “Administrative” | $18,000 |
| Mortgage payments | $132,000 |
| Depreciation | $55,000 |
| Capital: new roof (this year) | $96,000 (included inside the $72,000 repairs? Owner footnote: $96,000 roof is in addition to $72,000 repairs—owner total “building costs” confused) |
Clarify owner total claimed expenses: Owner presents expenses as taxes + insurance + utilities + repairs $72,000 + payroll + admin + mortgage + depreciation + roof $96,000. You will not accept that total.
Additional market data:
- Stabilized vacancy & collection: 5% of rental PGI (other income assumed durable; no vacancy on laundry/parking per local practice in this problem)
- Market management fee: 4% of EGI (owner listed $0 management; “administrative” includes office supplies $6,000 that are legitimate OE, and $12,000 of personal travel to remove)
- Market payroll for this size: $42,000 (owner close)
- Utilities, taxes, insurance: market-supported as stated
- Ordinary repairs stabilized: $28,000 (owner $72,000 includes deferred catch-up painting of $44,000—one-time; remove from annual OE and treat as immediate CapEx later if needed)
- Roof: new 20-year roof just installed for $96,000 → annual reserve going forward $96,000 / 20 = $4,800 (not $96,000 in OE)
- Immediate CapEx already spent by seller is not in annual OE; if roof were still needed, you might deduct PV from value—here roof is done
- Other income market: $14,400 supported
Step 1 — Potential Gross Income (market rents)
Annual market rental PGI:
| Type | Units | Rent/mo | Annual |
|---|---|---|---|
| Studio | 8 | $950 | 8 × 950 × 12 = $91,200 |
| 1BR | 24 | $1,200 | 24 × 1,200 × 12 = $345,600 |
| 2BR | 16 | $1,450 | 16 × 1,450 × 12 = $278,400 |
| Rental PGI | $715,200 |
Other income: $14,400
Some appraisers define PGI = rental + other = $729,600. We will apply V&C to rental only per market practice stated:
Step 2 — Vacancy & Collection → EGI
V&C = 5% × $715,200 = $35,760
Effective rental income = $715,200 − $35,760 = $679,440
EGI = $679,440 + $14,400 = $693,840
Contrast with owner “rents collected” $620,000: Owner figure embeds below-market rents, whatever actual vacancy occurred, and collection issues—not the fee simple stabilized base.
Step 3 — Reconstruct operating expenses
| Expense | Owner | Reconstruction | Notes |
|---|---|---|---|
| Real estate taxes | $48,000 | $48,000 | Keep |
| Insurance | $14,000 | $14,000 | Keep |
| Utilities | $36,000 | $36,000 | Keep |
| Repairs & maintenance | $72,000 | $28,000 | Remove $44,000 deferred catch-up |
| Roof | $96,000 | $0 as OE; reserve below | Capital |
| Replacement allowance (roof) | — | $4,800 | $96,000 / 20 |
| Payroll | $40,000 | $42,000 | Market |
| Administrative | $18,000 | $6,000 | Remove $12,000 personal travel |
| Management | $0 | 4% × $693,840 = $27,754 | Impute |
| Mortgage | $132,000 | $0 | Debt service |
| Depreciation | $55,000 | $0 | Non-cash |
| Total OE | inflated | $206,554 | Sum below |
OE total check:
48,000 + 14,000 + 36,000 + 28,000 + 4,800 + 42,000 + 6,000 + 27,754 = $206,554
OE ratio = $206,554 ÷ $693,840 ≈ 29.8% (plausible for many multifamily; exam may not require ratio but it is a reasonableness check).
Step 4 — NOI
NOI = EGI − OE = $693,840 − $206,554 = $487,286
Rounded for reporting: $487,000 (or keep exact if stem divides cleanly).
Step 5 — Optional value indication preview (not required to finish reconstruction)
If market OAR = 7.5% and rates are extracted on NOI after reserves:
Value ≈ $487,286 ÷ 0.075 ≈ $6,497,147 ≈ $6,500,000.
If someone wrongly “NOI’d” the owner books:
Owner income ≈ $620,000 + $14,400 = $634,400
Owner expenses including mortgage, depreciation, roof, bloated repairs ≈ far too high → garbage NOI. This is why reconstruction exists.
Side calculation — What if V&C applied to total PGI?
PGI total $729,600 × 5% = $36,480 V&C
EGI = $729,600 − $36,480 = $693,120
(Management 4% = $27,725; OE ≈ $206,525; NOI ≈ $486,595.)
Follow the stem’s vacancy base. Differences are small here but can be large when other income is huge (parking structures, cell antennas).
Worked Reconstruction — Small Retail (NNN-ish) Case
Facts
- 12,000 SF strip; fee simple market analysis
- Market rent $22/SF NNN = $264,000 base rent PGI
- Market reimbursements at stabilization: taxes $36,000 + insurance $9,000 + CAM $30,000 = $75,000
- PGI = $264,000 + $75,000 = $339,000
- Vacancy & collection 6% on PGI (including recoveries, per stem) → V&C = $20,340; EGI = $318,660
- Landlord OE: management 3% of EGI = $9,560; structural reserve $6,000; unreimbursed misc. $2,000
- Landlord also “pays” taxes/insurance/CAM $75,000 fully reimbursed
| Line | Amount |
|---|---|
| Base rent | $264,000 |
| Reimbursements | $75,000 |
| PGI | $339,000 |
| − V&C 6% | −$20,340 |
| EGI | $318,660 |
| − Taxes | −$36,000 |
| − Insurance | −$9,000 |
| − CAM | −$30,000 |
| − Management | −$9,560 |
| − Structural reserve | −$6,000 |
| − Misc. | −$2,000 |
| NOI | $226,100 |
Note: Reimbursements $75,000 − recoverable expenses $75,000 = 0 before vacancy. After 6% vacancy on PGI, recoveries in EGI are haircut with rent, so recoverable expenses at 100% of “full” can leave a shortfall—advanced stems may gross-up or adjust recoverable expenses to occupied levels. If the exam says expenses are “as incurred at stabilized occupancy,” match expense dollars to the stabilized world.
Compact Drill Set (Do These Cold)
Drill A
PGI $400,000; V&C 8%; OE $150,000. NOI?
EGI = $368,000; NOI = $218,000.
Drill B
EGI $500,000; fixed OE $100,000; variable OE 15% of EGI; reserves $12,000. NOI?
Variable = $75,000; OE = $187,000; NOI = $313,000.
Drill C — Strip the junk
Owner NOI claim: Income $300,000; expenses $200,000 including $80,000 debt service and $20,000 depreciation. True OE = $100,000 if those are the only improper items and remaining $100,000 is valid OE.
Appraisal NOI = $300,000 − $100,000 = $200,000 (if $300,000 is already EGI). Always verify whether “income” is PGI or EGI.
Drill D — Units to PGI to NOI
30 units × $1,500/mo market rent; other income $6,000/year; V&C 7% on rent only; OE $95,000.
Rental PGI = 30 × 1,500 × 12 = $540,000
V&C = $37,800
EGI = $540,000 − $37,800 + $6,000 = $508,200
NOI = $508,200 − $95,000 = $413,200
Drill E — Reimbursement consistency
Base rent PGI $200,000; reimbursements $40,000; V&C 5% on total PGI; OE = $40,000 recoverable + $25,000 other.
PGI = $240,000; V&C = $12,000; EGI = $228,000; OE = $65,000; NOI = $163,000.
Order-of-Operations Exam Discipline
- Fix rights and rent premise (market vs contract).
- Build PGI (rents, other income, reimbursements).
- Deduct V&C → EGI.
- Build market OE (fixed, variable, reserves); delete debt, tax depreciation, income tax, personal, capital bombs.
- NOI = EGI − OE.
- Only then apply cap rate / multiplier (Chapter 13).
Wrong order classic: Deduct expenses from PGI, then apply vacancy—misstates variable expenses and breaks the EGI definition.
Owner Statement → Appraisal Statement Mapping Table
| Owner artifact | Appraisal line |
|---|---|
| Rent roll / scheduled rent | Start of PGI (then mark to market if required) |
| Cash collected | Not PGI; reflects vacancy/collection already |
| CAM recoveries | Reimbursement income |
| Property tax bill | OE (fixed) |
| Mortgage PITI | Remove P&I; taxes/insurance may stay if in PITI—split carefully |
| “Net income” on Schedule E | Not appraisal NOI |
| CapEx invoices | Reserves / separate CapEx / immediate repair deduction |
| Percentage rent received | Income (variable; stabilize) |
Common Exam Traps — Reconstruction
| Trap | Correct move |
|---|---|
| Capitalizing owner’s cash flow after debt service | Use NOI before debt service |
| Using rents collected as PGI without adding vacancy back | Build full PGI; deduct explicit V&C |
| Keeping depreciation | Remove |
| Keeping mortgage interest only (but not principal) | Remove all debt service |
| Gross rent with NNN expense set | Reconstruct to a consistent lease basis |
| 100% occupancy forever | Apply market V&C |
| Forgetting imputed management | Add market management |
| Double-counting reserves and full capital expense same year as perpetual OE | Normalize |
| Applying cap rate to EGI | Cap rates for direct cap typically on NOI, not EGI (multipliers may use EGI/PGI—different tools) |
| Mixing leased fee contract income with fee simple expense structure carelessly | Match rights and lease terms |
Mini Case — Spot the Errors (Then Fix)
Stem NOI claim $180,000 derived as:
- Collected rent $250,000
- Expenses: $40,000 tax, $10,000 insurance, $20,000 maintenance, $50,000 mortgage interest, $30,000 depreciation → total “exp” $150,000
- $250,000 − $70,000? (inconsistent owner math in stems is common)
Your rebuild (assume collected rent reflects 10% vacancy already on market PGI):
If market PGI = $250,000 / 0.90 = $277,778, V&C 10% = $27,778, EGI = $250,000.
OE = 40k + 10k + 20k = $70,000 (mortgage and depreciation out).
NOI = $180,000.
Ironically the number matches a wrong path sometimes—process still matters when numbers differ.
Alternate: if $250,000 is PGI not collected: EGI = $225,000 at 10% V&C; NOI = $155,000. Labels change everything.
Chapter 12 Synthesis
| Section | Skill |
|---|---|
| 12.1 Sources of income | Contract vs market rent; reimbursements; gross/net/percentage leases; owner/operator income |
| 12.2 Occupancy/vacancy | Physical vs economic vacancy; collection loss; market vs stabilized; EGI math |
| 12.3 Operating expenses | Fixed vs variable; reserves/CapEx; exclude debt, depreciation, income tax |
| 12.4 Operating statement | Full PGI → EGI → NOI reconstruction |
Income Approach weight reminder: ~19% CG / ~8% CR / ~4.5% LR. Residential candidates still need clean EGI/NOI arithmetic; General candidates need fluency under time pressure. Chapter 13 takes this NOI into multipliers, overall rates, cap rate derivation, yield capitalization, and property rights (fee simple / leased fee / leasehold).
Pocket card (write on scratch paper in the exam room)
PGI − V&C = EGI − OE = NOI
In OE: taxes, insurance, utilities (as landlord), mgmt, maint, reserves…
Out of OE: mortgage, depreciation, income tax, personal, capital bombs
Rent premise: market (fee simple) vs contract (leased fee)
Reimbursements: income + expense both, if landlord pays and recovers
Potential gross income is $520,000, vacancy and collection loss is 6%, and operating expenses are $175,000. What is net operating income?
An owner’s annual statement shows effective income of $400,000 and expenses of $260,000. The $260,000 includes $90,000 of mortgage principal and interest and $25,000 of accounting depreciation; the remaining $145,000 are valid operating expenses. Reconstructed NOI is: