คู่มือโดยละเอียดเร็วๆ นี้
เรากำลังจัดทำคู่มือการศึกษาที่ครอบคลุมสำหรับ เครื่องคิดเลข NOI กลับมาเร็วๆ นี้เพื่อดูคำอธิบายทีละขั้นตอน สูตร ตัวอย่างจริง และเคล็ดลับจากผู้เชี่ยวชาญ
Net Operating Income (NOI) is the foundational income metric in commercial real estate investing. It measures the income a property generates from its operations after subtracting all operating expenses, but before deducting debt service (mortgage payments), income taxes, depreciation, and capital expenditures. NOI represents the pure economic productivity of a real estate asset, independent of how it is financed or owned, making it the standard measure for comparing properties across different ownership structures and financing arrangements. NOI is central to real estate valuation through the capitalization rate (cap rate) method: Property Value = NOI / Cap Rate. A property generating $120,000 in NOI in a market with a 6% cap rate would be valued at $2,000,000. This direct relationship makes NOI the single most impactful number in any real estate transaction — small improvements to NOI have a multiplied effect on property value. Investors, lenders, and appraisers all focus on NOI for different reasons. Investors use it to measure return on investment and compare competing opportunities. Lenders calculate the Debt Service Coverage Ratio (DSCR = NOI / Annual Debt Service) to determine how safely a property's income covers mortgage payments — most commercial lenders require a minimum DSCR of 1.20–1.25x. Appraisers use NOI in the income approach to establish market value. Key inputs to NOI include gross potential rent (all units rented at market rates), less vacancy and credit loss allowances, plus other income (parking, laundry, storage, late fees), minus operating expenses. Operating expenses include property taxes, insurance, utilities, maintenance, management fees, and reserves for replacement. What NOI does NOT include: mortgage principal and interest, depreciation, income taxes, and large capital expenditures — these are 'below the NOI line.'
NOI = Gross Potential Income − Vacancy & Credit Loss + Other Income − Operating Expenses Alternatively: NOI = Effective Gross Income (EGI) − Operating Expenses Where: EGI = Gross Potential Income − Vacancy Loss + Other Income
- 1Calculate Gross Potential Income (GPI): multiply each unit's monthly market rent by 12, then sum across all units. This is the theoretical maximum income at full occupancy.
- 2Estimate Vacancy and Credit Loss: apply a market-appropriate vacancy rate (typically 5–10% for stabilized properties) to GPI to account for empty units and non-paying tenants.
- 3Add Other Income: include all ancillary revenue streams that the property generates beyond rent — parking, laundry, storage, signage, etc.
- 4Sum GPI − Vacancy + Other Income to arrive at Effective Gross Income (EGI), the realistic expected revenue.
- 5Calculate total Operating Expenses: property taxes, insurance, property management fees (typically 8–10% of EGI), maintenance and repairs, utilities paid by landlord, landscaping, and a reserve for replacement (typically 5–10% of GPI).
- 6Subtract Operating Expenses from EGI to arrive at NOI. Verify that debt service, depreciation, income taxes, and large capital improvements are NOT included in operating expenses.
GPI = 10 × $1,500 × 12 = $180,000. Vacancy loss = $180,000 × 7% = $12,600. EGI = $180,000 − $12,600 + $3,600 = $171,000. NOI = $171,000 − $54,000 = $117,000. Wait — with $54K operating expenses, NOI = $171K − $54K = $117K. At a 6% cap rate, this property would appraise at approximately $1,950,000.
EGI = $200,000 − $14,000 + $8,000 = $194,000. Operating Expenses = $22K + $8K + $15K + $16K + $10K = $71,000. NOI = $194,000 − $71,000 = $123,000. This commercial property trades in a market with 6.5% cap rates, implying a value of $123,000 / 0.065 = $1,892,308.
DSCR = $150,000 / $115,000 = 1.304x. Most commercial lenders require a minimum DSCR of 1.20–1.25x. This property's NOI comfortably covers its mortgage payments with a 30% cushion. A DSCR below 1.0x means the property does not generate enough income to cover its debt service — a major red flag for lenders.
Before: Value = $80,000 / 0.06 = $1,333,333. After renovation: Value = $110,000 / 0.06 = $1,833,333. Value created = $500,000. Investment cost = $150,000. Net value creation = $350,000 — an excellent return on the renovation investment. This is the classic value-add real estate strategy: improve NOI, multiply through the cap rate.
Annual Rent = $2,200 × 12 = $26,400. EGI = $26,400 − $2,200 (vacancy) = $24,200. Operating Expenses = $4,800 + $1,500 + $2,400 + $2,640 = $11,340. NOI = $24,200 − $11,340 = $12,860. On a $200,000 purchase, this yields a 6.43% cap rate — a solid return for a single-family rental in most markets.
Property valuation via the income approach (Value = NOI / Cap Rate), representing an important application area for the Noi Calculator in professional and analytical contexts where accurate noi ulator calculations directly support informed decision-making, strategic planning, and performance optimization
Lender underwriting: DSCR calculation determines maximum loan amount, representing an important application area for the Noi Calculator in professional and analytical contexts where accurate noi ulator calculations directly support informed decision-making, strategic planning, and performance optimization
Investment comparison: ranking competing acquisition opportunities, representing an important application area for the Noi Calculator in professional and analytical contexts where accurate noi ulator calculations directly support informed decision-making, strategic planning, and performance optimization
Asset management: tracking NOI growth as a measure of operational improvement, representing an important application area for the Noi Calculator in professional and analytical contexts where accurate noi ulator calculations directly support informed decision-making, strategic planning, and performance optimization
Sale price negotiation: every $10,000 of NOI improvement adds $100,000–$200,000 to value in typical cap rate environments, representing an important application area for the Noi Calculator in professional and analytical contexts where accurate noi ulator calculations directly support informed decision-making, strategic planning, and performance optimization
Triple-Net (NNN) leases: In commercial properties with NNN leases, the tenant
Triple-Net (NNN) leases: In commercial properties with NNN leases, the tenant pays property taxes, insurance, and maintenance directly. The landlord's NOI calculation is simpler — but NOI is still reduced by management fees and any landlord-borne expenses.. In the Noi Calculator, this scenario requires additional caution when interpreting noi ulator results. The standard formula may not fully account for all factors present in this edge case, and supplementary analysis or expert consultation may be warranted. Professional best practice involves documenting assumptions, running sensitivity analyses, and cross-referencing results with alternative methods when noi ulator calculations fall into non-standard territory.
Short-term rentals (Airbnb): Revenue is highly variable and subject to
Short-term rentals (Airbnb): Revenue is highly variable and subject to seasonality, platform fees (15–20%), and higher cleaning/maintenance costs. Use a realistic annual occupancy rate rather than assuming full occupancy.. In the Noi Calculator, this scenario requires additional caution when interpreting noi ulator results. The standard formula may not fully account for all factors present in this edge case, and supplementary analysis or expert consultation may be warranted. Professional best practice involves documenting assumptions, running sensitivity analyses, and cross-referencing results with alternative methods when noi ulator calculations fall into non-standard territory.
When noi ulator input values approach zero or become negative in the Noi
When noi ulator input values approach zero or become negative in the Noi Calculator, mathematical behavior changes significantly. Zero values may cause division-by-zero errors or trivially zero results, while negative inputs may yield mathematically valid but practically meaningless outputs in noi ulator contexts. Professional users should validate that all inputs fall within physically or financially meaningful ranges before interpreting results. Negative or zero values often indicate data entry errors or exceptional noi ulator circumstances requiring separate analytical treatment.
Ground leases: If the property sits on a ground lease, the annual ground rent
Ground leases: If the property sits on a ground lease, the annual ground rent payment is an operating expense that reduces NOI — often significantly.. In the Noi Calculator, this scenario requires additional caution when interpreting noi ulator results. The standard formula may not fully account for all factors present in this edge case, and supplementary analysis or expert consultation may be warranted. Professional best practice involves documenting assumptions, running sensitivity analyses, and cross-referencing results with alternative methods when noi ulator calculations fall into non-standard territory.
| Property Type | OE as % of EGI | Key Expense Driver |
|---|---|---|
| Multifamily (Class A) | 35–45% | Professional management, amenities |
| Multifamily (Class C) | 45–55% | Higher maintenance, turnover costs |
| Office (Full-Service Gross Lease) | 50–60% | Landlord pays all utilities and janitorial |
| Retail (Triple-Net Lease) | 10–20% | Tenants pay most operating costs |
| Industrial / Warehouse | 20–35% | Low management intensity |
| Self-Storage | 30–40% | Moderate management, security costs |
| Single-Family Rental | 35–50% | Property management, maintenance |
What is not included in NOI?
NOI deliberately excludes mortgage principal and interest payments (debt service), income taxes, depreciation, and large capital expenditures (roof replacement, major renovations). These are excluded because they depend on financing decisions and tax structure rather than the property's operational performance. Excluding them makes NOI an apples-to-apples comparison tool across properties with different financing.
How is NOI different from cash flow?
NOI is above the line — it measures the property's operating income before financing. Cash flow (specifically, Cash Flow Before Tax or CFBT) is what you actually pocket after paying the mortgage: CFBT = NOI − Annual Debt Service. A property can have strong NOI but negative cash flow if it is over-leveraged. Conversely, a property with modest NOI might produce excellent cash flow if purchased without debt.
What expenses are included in operating expenses for NOI?
Operating expenses include property taxes, insurance, property management fees, maintenance and repairs, landlord-paid utilities, landscaping, pest control, advertising for tenants, and reserves for replacement (a budgeted amount for future capital items like roof, HVAC, appliances). They do NOT include mortgage payments, depreciation, amortization, income taxes, or large one-time capital improvements.
What is a replacement reserve and why include it in NOI?
A replacement reserve is a budgeted annual amount set aside to fund future capital expenditures like roof replacement, HVAC systems, and major appliance replacements. Prudent NOI analysis includes reserves (typically 5–10% of GPI or $200–$500 per unit per year) to reflect the true economic cost of property ownership. Omitting reserves inflates NOI and overstates property value — a common trick used to make properties look more profitable than they are.
How do I handle capital expenditures in NOI analysis?
Large, non-recurring capital expenditures (new roof, major renovation) are not included in NOI or operating expenses. However, the annual reserve for replacement IS included. When analyzing a property, it is critical to review the property's condition and anticipated near-term capex needs — if a $50,000 roof replacement is due in two years, that cost should factor into your purchase price negotiation even though it won't appear in the NOI statement.
What vacancy rate should I use in my NOI calculation?
Use the market vacancy rate for comparable properties in the submarket, not necessarily the current physical vacancy of the specific property. A newly acquired property might be 100% occupied but the market vacancy is 8% — a prudent underwriting uses the market rate. Conversely, a recently renovated property might be temporarily 15% vacant, but stabilized operations suggest 5%. Lenders and appraisers use stabilized vacancy assumptions, not point-in-time snapshots.
How does NOI relate to cap rate and property value?
The direct relationship is: Value = NOI / Cap Rate. The cap rate is determined by the market — it reflects prevailing investor return expectations for a given property type and location. If cap rates compress (fall), the same NOI is worth more. If cap rates expand (rise), the same NOI is worth less. This is why real estate values fell sharply in 2022–2023 as rising interest rates pushed cap rates higher, even when NOI was unchanged.
Can NOI be negative?
Yes. A property with high vacancy, low rents, or excessive operating costs can produce negative NOI. This situation is financially dangerous — it means the property loses money before even making a mortgage payment. Distressed properties, buildings undergoing major renovation, or poorly managed assets can temporarily post negative NOI. Investors acquiring such properties must have a clear value-add plan and sufficient capital reserves to fund the period of negative NOI.
เคล็ดลับโปร
Always build a T-12 (Trailing 12-Month) analysis of actual income and expenses using bank statements and rent rolls, not just the seller's pro forma. The difference between actual NOI and projected NOI is where most real estate investment mistakes are made.
คุณรู้ไหม?
Cap rate compression (falling cap rates) was so dramatic from 2010 to 2022 that many US multifamily properties saw their values double or triple even without any improvement in NOI — purely because investor return requirements fell. A $100,000 NOI property worth $1.25M at an 8% cap rate became worth $2M at a 5% cap rate, all else equal.
เอกสารอ้างอิง