A real estate formula is a compact, decision-ready calculation you use to test deals quickly before committing capital. This guide pairs a one-page cheat sheet with a complete worked underwriting example, lender-facing ratios, and clear guidance on when each metric applies — so you can screen deals with confidence, not guesswork.
Mastering real estate formulas means knowing which metric to run first, verifying every input independently, and stress-testing rent and exit cap rate before committing capital.
| Point | Details |
|---|---|
| NOI is the foundation | Every valuation and lender ratio — cap rate, DSCR, debt yield — starts with a clean, verified NOI. |
| DSCR controls loan sizing | A DSCR below 1.20 typically prevents loan approval; engineer your deal structure before approaching a lender. |
| Heuristics screen, not confirm | The 1%, 50%, and 70% rules eliminate bad deals quickly but cannot replace full underwriting. |
| CFAT beats pre-tax cash flow | Depreciation creates paper losses that reduce taxable income, making after-tax returns higher than pre-tax figures suggest. |
| Stress-test two inputs first | Varying rent by ±10% and exit cap rate by ±50 basis points captures the majority of return variance on any hold. |
The table below covers every core metric in one place. Return to it while screening deals.
| Formula | Equation | Key Inputs | Result Unit | When to Use |
|---|---|---|---|---|
| Effective Gross Income (EGI) | Potential Gross Income − Vacancy & Credit Loss | Scheduled rents, vacancy rate | $ | First step in any income analysis |
| Net Operating Income (NOI) | EGI − Operating Expenses | EGI, taxes, insurance, maintenance | $ | Valuation, DSCR, cap rate |
| Cap Rate | NOI ÷ Property Value | NOI, market value or purchase price | % | Income-producing property valuation |
| Cash-on-Cash Return | Annual Pre-Tax Cash Flow ÷ Total Cash Invested | Cash flow, down payment + closing costs | % | Comparing leveraged returns |
| Gross Rent Multiplier (GRM) | Purchase Price ÷ Gross Annual Rent | Price, annual rent | Ratio | Quick residential screening |
| Loan-to-Value (LTV) | Loan Amount ÷ Appraised Value | Loan balance, appraised value | % | Loan sizing and pricing |
| DSCR | NOI ÷ Annual Debt Service | NOI, P&I payments | Ratio | Lender underwriting |
| IRR | Discount rate where NPV = 0 | Cash flow schedule, hold period | % | Multi-year investment comparison |
| NPV | Sum of discounted cash flows − Initial Investment | Discount rate, projected cash flows | $ | Go/no-go on a specific deal |
| Equity Multiple | Total Distributions ÷ Total Equity Invested | Cash flows + sale proceeds, equity in | Ratio | Syndication and fund reporting |
| GRM Example | $300K price ÷ $24,000 | $300K price, $2,000 per month rent | 12.5 | Residential screening benchmark |
Common input pitfalls to avoid:
For a comprehensive set of formal definitions and example calculations, PropertyMetrics covers NOI, cap rate, DSCR, LTV, IRR, and NPV in a focused reference.
Every income analysis starts with Potential Gross Income (PGI), the total rent if every unit were occupied and every tenant paid on time. Subtract vacancy and credit loss to arrive at Effective Gross Income (EGI). A related term, Gross Operating Income (GOI), is sometimes used interchangeably with EGI, though some practitioners define GOI as EGI plus ancillary income (laundry, parking, storage fees). For underwriting, treat them as the same unless your pro forma separates ancillary revenue.
Lenders and buyers who rely on seller-supplied occupancy figures without applying a market vacancy assumption routinely overpay.*
NOI = EGI − Operating Expenses
Operating expenses include property taxes, insurance, property management fees, maintenance, repairs, and reserves for replacement. They do not include mortgage payments, depreciation, or income taxes. That exclusion is intentional: NOI measures the property’s performance independent of how it is financed, which makes it comparable across deals with different capital structures.
A common mistake is treating the seller’s stated expenses as complete. Capital expenditure reserves (roof, HVAC, appliances) are frequently omitted from listing pro formas. Add them back before finalizing NOI.
Once you have NOI, subtract annual debt service (principal and interest) to get pre-tax cash flow. Divide that figure by total cash invested (down payment plus closing costs plus any upfront rehab) to get cash-on-cash return.
That figure tells you the yield on your actual dollars deployed, not on the full property value.
OER = Operating Expenses ÷ Effective Gross Income
OER is a sanity check.
Cap Rate = NOI ÷ Property Value
Rearranged: Property Value = NOI ÷ Cap Rate. That second form is how appraisers and brokers use it in practice.
Cap rate is a snapshot. It reflects one year of income at one point in time, so it is highly sensitive to both the NOI figure you input and the market yield environment. Rising interest rates tend to push cap rates up (values down); falling rates compress them. For a deeper look at how cap rates interact with financing, commercial real estate valuation approaches from J.P. Morgan explain the income capitalization method in context.
Pro Tip: *Never use a seller’s stated NOI to back-calculate value without independently verifying every income and expense line.
Yield on Cost = Stabilized NOI ÷ Total Project Cost
Yield on cost is the developer’s version of cap rate. It measures the return on what you actually spend to build or reposition an asset, not what you pay to acquire a stabilized one. The spread between yield on cost and the prevailing exit cap rate is the development spread — the reward for taking construction and lease-up risk. For ground-up projects, Capitalfunding’s construction loan program is structured around exactly this metric.
Equity Multiple = Total Distributions ÷ Total Equity Invested
It does not account for time, which is why IRR and equity multiple are used together in syndication and fund reporting.
Discounted cash flow methods account for the time value of money, which simple metrics like cap rate and cash-on-cash do not. They are the right tools when you are comparing multi-year holds or evaluating whether a deal justifies its risk.
Present Value (PV). PV = Future Cash Flow ÷ (1 + Discount Rate)^n. A $100,000 cash flow received in five years, discounted at 8%, is worth about $68,058 today. That gap is the cost of waiting.
Net Present Value (NPV). NPV sums the present value of all projected cash flows (including the reversion/sale proceeds) and subtracts the initial investment. A positive NPV means the deal exceeds your required return; negative means it falls short. Example: $500,000 investment, five years of $40,000 annual cash flow, $650,000 sale proceeds at year 5, 8% discount rate — NPV is approximately +$47,000, a go.
Internal Rate of Return (IRR). IRR is the discount rate that sets NPV to zero. It is the single most common return metric in commercial real estate underwriting. An IRR of 15% means the deal returns 15% annually on invested capital, accounting for the timing of every cash flow.
Modified IRR (MIRR). Standard IRR assumes interim cash flows are reinvested at the IRR itself — an optimistic assumption. MIRR corrects this by specifying a realistic reinvestment rate (often the cost of capital). For deals with large mid-hold cash flows, MIRR is the more honest figure.
Common IRR traps. Multiple sign changes in a cash flow schedule (negative, positive, negative) can produce multiple IRR solutions, none of which is uniquely correct. Always pair IRR with NPV and equity multiple to cross-check the result.
Sensitivity to discount rate. A 1-percentage-point change in your discount rate can shift NPV by tens of thousands of dollars on a mid-size deal. Run your NPV at your target rate, at +2%, and at −2% before committing.
Projected cash flow risk. IRR and NPV are only as reliable as the cash flow projections feeding them. Stress-test rent assumptions by ±10% and exit cap rate by ±50 basis points before treating the output as final.
These are the numbers your lender calculates before you do. Understanding them lets you structure deals that actually get funded.
LTV = Loan Amount ÷ Appraised Value
LTV determines which loan products are available and at what pricing. A lower LTV means less risk for the lender and, generally, better rate pricing for you.
DSCR = NOI ÷ Annual Debt Service
A DSCR below 1.0 means the property cannot service its own debt from operations. If NOI is $95,000, DSCR is 1.19 — just below a 1.20 minimum, which means the loan either needs to be sized down or the NOI assumption needs to hold up under scrutiny.
Pro Tip: To quickly estimate the maximum loan size a given NOI supports, divide NOI by the lender’s minimum DSCR, then divide that result by the loan constant (annual debt service per dollar of loan). This back-calculation tells you the ceiling before you run a full amortization schedule.
Debt Yield = NOI ÷ Loan Amount
Debt yield is a lender safeguard that removes the influence of interest rate and amortization period. Private lenders use debt yield precisely because it is rate-agnostic.
Loan Constant = Annual Debt Service ÷ Loan Amount
The loan constant expresses annual debt service as a percentage of the loan balance. It is useful for quickly comparing financing options: a lower constant means lower annual payments relative to the loan size.
Break-Even Ratio = (Operating Expenses + Debt Service) ÷ Gross Operating Income
For multifamily financing structures and how these ratios interact, Capitalfunding’s multifamily bridge loan program is built around exactly these underwriting thresholds.
These rules of thumb are screening filters, not substitutes for full underwriting. Use them to eliminate bad deals quickly, not to confirm good ones.
Caution: Every heuristic above was calibrated for a specific market era and asset type. Applying the 1% rule in San Francisco or the 70% rule in a market with 5% ARV appreciation assumptions will produce misleading results. Run full underwriting before committing.
For investors just building their underwriting discipline, Business Insider recommends starting with single-family homes to develop formula fluency before moving to more complex asset classes.
This deal, as structured, does not cash flow and falls below a 1.20 DSCR minimum. At $2,800/month with a $295,000 purchase price, cash flow turns positive and DSCR clears 1.20.
If NPV is positive, the deal meets your hurdle rate even though year-one cash flow is thin.
Those two inputs drive the vast majority of return variance on a standard rental hold. Stress-test them before you stress-test anything else.*
For a reusable spreadsheet template, include columns for: monthly rent, vacancy rate, each operating expense line, loan terms, annual debt service, pre-tax cash flow, cash-on-cash, cap rate, DSCR, and a five-year IRR/NPV block. Mirror the cheat-sheet table from the opening section so every formula is visible alongside its output.
HUD and USPAP appraisal standards require appraisers to consider all three primary approaches to value and to reconcile them when estimating market value. In practice, the choice of primary approach follows the asset type. J.P. Morgan’s guidance on commercial real estate valuation confirms the same principle: sales comparison for residential, income capitalization for income-producing commercial and multifamily, and the cost approach for specialized or owner-occupied properties with limited comparable sales.
Statistic callout: According to USPAP standards, appraisers must reconcile value indications from all applicable approaches — not simply select the one that supports a target price. That reconciliation requirement is the professional standard that separates a credible appraisal from a back-of-envelope estimate.
For a practical loan readiness checklist that maps these metrics to lender documentation requirements, the real estate investment loan checklist covers what lenders expect to see before underwriting begins.
The right tools eliminate arithmetic errors and let you run sensitivity scenarios in seconds.
IRR() and NPV() functions handle multi-year cash flow schedules directly. Google Sheets supports the same functions with identical syntax.=(ARV * 0.70) - Repair Costs. Paste in ARV and repair estimates for an instant MAO.When using any third-party app or online calculator, verify the underlying formula before trusting the output. Check that amortization schedules use the correct compounding period (monthly, not annual) and that NOI inputs exclude debt service. A calculator that buries a wrong assumption produces a confident-looking wrong answer.
Keep a one-page Google Sheets or Excel template that mirrors the cheat-sheet table from the opening section. Fast deal screening means having your formulas ready before the deal arrives, not building the model from scratch each time.
Depreciation is a non-cash tax deduction that reduces taxable income without reducing actual cash flow. The IRS allows residential rental property to be depreciated over 27.5 years and commercial property over 39 years. On a $325,000 property with $50,000 allocated to land (non-depreciable), the annual depreciation deduction is $275,000 ÷ 27.5 = $10,000. That $10,000 reduces your taxable income from the property without touching your bank account.
Cost segregation accelerates this benefit by reclassifying components (flooring, fixtures, landscaping) into shorter depreciation schedules of 5, 7, or 15 years. The result is larger deductions in the early years of ownership, improving after-tax returns significantly for investors in higher tax brackets. ChooseFI’s real estate investing guide highlights depreciation, cost segregation, and 1031 exchanges as the primary tax advantages that make real estate returns difficult to replicate in other asset classes.
Loan amortization works differently. Each mortgage payment splits between interest (tax-deductible for investment properties) and principal (not deductible, but builds equity). In the early years of a 30-year mortgage, the interest portion dominates. As the loan seasons, the principal portion grows, reducing the interest deduction while accelerating equity accumulation.
Pre-tax cash flow tells you what the property generates before the IRS takes its share. CFAT tells you what you actually keep.
CFAT = Pre-Tax Cash Flow − Tax Liability
Tax liability on rental income is calculated on taxable income, not cash flow. Taxable income equals NOI minus mortgage interest minus depreciation. Because depreciation is a non-cash deduction, taxable income is often substantially lower than pre-tax cash flow, and in many cases it is negative (a “paper loss”) even when the property generates positive cash flow.
A quick illustration using the worked example above: assume pre-tax cash flow is $5,000 (after adjusting purchase price), mortgage interest is $17,000, and depreciation is $10,000. Taxable income = $19,516 NOI − $17,000 interest − $10,000 depreciation = −$7,484. That paper loss can offset other passive income, reducing your overall tax bill.
CFAT is the most complete picture of what a property actually returns to you after financing and taxes. It is the figure that matters most for personal financial planning, even though NOI and cap rate are the metrics that drive valuation and lender decisions.
The formulas in this guide are tools, not conclusions. A cap rate tells you the implied yield at today’s NOI; it says nothing about whether that NOI is sustainable, whether the market is compressing or expanding, or whether your exit assumption is realistic. The math is only as good as the inputs behind it.
Start simple. Business Insider’s guidance for new investors aligns with what experienced underwriters observe in practice: investors who begin with single-family rentals develop formula fluency and financing familiarity before the stakes are high enough to matter. That discipline compounds. The investor who can run a clean NOI-to-DSCR analysis on a single-family rental will underwrite a 20-unit multifamily deal with the same rigor, just more rows.
Build repeatable templates. A one-page underwriting model you trust is worth more than a complex spreadsheet you rebuild differently each time. Consistency in your assumptions (vacancy rate, expense ratio, reserve allocation) makes your underwriting comparable across deals and credible to lenders.
Prioritize liquidity and exit assumptions. IRR is a function of when you sell and at what cap rate. Investors who underwrite an aggressive exit cap rate in year five and then face a rising rate environment discover that the math was right but the assumption was wrong. Model at least two exit scenarios: your base case and a 50-basis-point cap rate expansion.
From a private lending perspective, Capitalfunding focuses on three things when reviewing a deal: realistic NOI supported by verifiable rent rolls and expense history, a credible exit strategy (refinance, sale, or stabilization), and borrower experience with the asset class. The formulas you run before approaching a lender are the same ones the lender will run independently. Arriving with clean underwriting, documented assumptions, and a stress-tested cash flow model shortens the path to funding. For guidance on preparing that package, how to secure funding in a competitive market covers what lenders expect to see.
Investment strategy also shapes which metrics matter most. J.P. Morgan’s framework for commercial real estate investment strategies distinguishes core (stable NOI, low leverage), value-add (repositioning upside, moderate leverage), and opportunistic (development or distress, higher leverage and return targets). A core investor optimizes for DSCR and debt yield; an opportunistic developer focuses on yield on cost and IRR. Align your metrics to your strategy, not the other way around.
ADU strategies offer a practical middle path for investors who want rental income without the complexity of large multifamily. Why ADUs outperform large multifamily investments makes a compelling case for smaller-scale strategies that still benefit from the same NOI and cash-on-cash framework described here.
You have the formulas. The next step is capital that moves as fast as your analysis does. Capitalfunding is a direct private lender backed by a family office, with over $1 billion in closed loans and an A+ BBB rating. We close hard money and bridge loans in days, not weeks, and we finance deals that conventional lenders decline, including fix-and-flip projects, ground-up construction, and ultra-luxury single-family homes above $10 million. If your underwriting shows a deal worth pursuing, we want to hear about it. Explore our fix-and-flip loan program or contact us directly to discuss your next project.
This article is general information, not a substitute for advice from a qualified financial advisor. Consult a qualified financial professional about your own circumstances before acting on anything here.
Definitions vary among practitioners, so treat it as a budgeting reminder rather than a precise formula.
The “golden formula” most commonly refers to the cap rate equation: NOI ÷ Property Value. It is the single calculation that connects a property’s income to its market value and underpins most commercial real estate underwriting and valuation work.
The 70% Rule is designed for fix-and-flip deals and builds in a margin for holding costs, financing, and profit. It approximates the maximum allowable offer based on ARV and repair costs, but specific figures vary by deal.
NOI is property income after operating expenses but before debt service. Cash flow subtracts mortgage payments (principal and interest) from NOI. NOI measures the property’s performance independent of financing; cash flow measures what the investor actually receives after servicing the loan.
