Week 6CHAPTER 06
How Do We Decide and Check Our Work? Triangulation, Decisions & Taxes
How to turn a valuation into a defensible decision and check it for reasonableness. Why honest valuation produces a range, not a point; the three approaches to value and what each captures; the four quick checks of price per unit, price per square foot, GRM, and implied cap rate; where practitioners source cap rates, comps, and replacement costs, and each source’s bias; reading method divergence as information; one- and two-variable sensitivity tables and coherent scenarios; NPV, IRR, MIRR, and the equity multiple on a worked $30M deal, with investment value vs. market value and the hold/sell/refinance/renovate rule; and the tax layer (property and income classification, depreciation, after-tax cash flow, and tax at sale) that can flip the verdict.
~170 min19 sections29 questions4 tools
Learning objectives (8)
Learning Objectives
By the end of this chapter you should be able to:
- 1Defend a valuation range: explain why honest valuation produces a range rather than a point estimate, and support the claim with the appraisal accuracy evidence.
- 2Deploy all three approaches: state what the income, sales comparison, and cost approaches each capture, where each breaks down, and when each deserves the most weight.
- 3Run the quick checks: screen any deal in minutes with price per unit, price per square foot, gross rent multiplier, and implied cap rate.
- 4Source the inputs: name the professional data sources for cap rates, comparable sales, and replacement costs, and state each source’s bias.
- 5Read divergence as information: diagnose what it means when cost exceeds income value, DCF exceeds direct cap, or comps diverge from income approaches.
- 6Map the range with sensitivity and scenarios: build one-variable and two-variable sensitivity tables and coherent base, downside, and upside cases.
- 7Decide with NPV, IRR, and their repairs: compute NPV, IRR, MIRR, and the equity multiple on the module’s worked deal, separate investment value from market value, and choose among holding, selling, refinancing, and renovating.
- 8Put taxes into the cash flows: classify property and income for tax purposes, compute depreciation and after-tax cash flows, estimate taxes due at sale, and state when the tax layer changes the investment decision.
Part One: Valuation Theory Overview. Section 1 of 19.
Part One · Honest Valuation Produces a Range, Not a Point
Valuation Theory Overview
Part One
Honest Valuation Produces a Range, Not a Point
Every valuation method requires assumptions, and different reasonable assumptions can produce different values. This is not a flaw in the process; it reflects the nature of real estate. A credible valuation is best understood as a supported range, even when the final conclusion is reported as a single point estimate.
Valuation Theory Overview
Every valuation method requires assumptions. Different reasonable assumptions can produce different values. This is not a flaw in the process; it reflects the nature of real estate. Unlike publicly traded securities with continuous price discovery, real estate transactions are infrequent, properties are heterogeneous, and information is unevenly distributed. As a result, a credible valuation is best understood as a supported range, even when the final conclusion is reported as a single point estimate.
Market value is commonly defined in appraisal practice as the most probable price a property should bring in a competitive and open market under normal sale conditions. The word probable matters. A property concluded at $28 million is not "worth exactly" $28,000,000 in a scientific sense. Rather, $28 million represents the analyst’s best supported conclusion within a reasonable range, perhaps $26 million to $30 million, depending on the evidence and assumptions.
Cole, Guilkey, and Miles (1986) examined appraisal values and transaction prices using institutional real estate data and found meaningful differences between appraised values and sale prices. Their work is often cited as evidence that real estate valuation contains unavoidable estimation error. The practical lesson is not that appraisals are unreliable; it is that valuation precision should not be overstated. A $10 million appraisal and a sale price modestly above or below that figure can both be consistent with normal valuation uncertainty.
The key question is not, "Is this number exactly right?" The better question is: What assumptions produce this number, how strong is the evidence behind them, and how sensitive is the value to changes in those assumptions?
Professional standards reinforce this point. USPAP does not mechanically require every valuation approach in every assignment. It requires the appraiser to develop a scope of work sufficient to produce credible assignment results, use methods appropriate to the assignment, and reconcile the evidence and approaches applied. The appraiser must determine which approaches are relevant, apply them carefully, and explain how the final conclusion is supported.
This chapter examines the three standard approaches to value: the income approach, sales comparison approach, and cost approach. It also covers quick-check metrics used for sanity testing and the process of triangulating multiple indicators into a defensible value range. The goal is not false precision. The goal is a well-supported valuation conclusion with a clear explanation of where the property most likely falls within the range.
Law 6: There is only one certain answer to any valuation model question. It depends.
Student Workflow: Valuation Triangulation in Seven Steps
Triangulation is the discipline of building a defensible value range from multiple independent approaches and metrics. A practical workflow runs in seven steps:
- Calculate quick checks: price per unit, price per square foot, gross rent multiplier, and implied cap rate. Determine whether the deal is in the right neighborhood before building a full model.
- Build the income approach: use direct capitalization for stabilized income and DCF for multi-year cash flows, capital costs, and terminal value.
- Pull and adjust comps: identify comparable sales and adjust for location, timing, condition, size, amenities, quality, financing terms, property rights, and transaction circumstances.
- Review replacement cost as a check: estimate land value plus replacement cost of improvements, less depreciation. This approach is most useful for new, proposed, or special-use properties, and less reliable for older income properties where depreciation is difficult to measure.
- Run sensitivities and scenarios: test cap rates, NOI, discount rates, exit cap rates, rent growth, and vacancy. Build base, downside, and upside scenarios.
- Reconcile into a range: weight the approaches based on property type, data quality, market evidence, and relevance. Write a reconciliation narrative explaining why some approaches received more weight than others.
- Compare market value to investment value: a property can be fairly valued by the market and still fail a specific buyer’s return requirements because of that buyer’s financing, tax position, cost of capital, or strategy.
Check Your Understanding
Knowledge Check 1
Triangulation, Decisions & Judgment
An appraiser concludes that a stabilized apartment property has a market value of $10,000,000. Three months later, the property sells for $9,300,000, and the investment committee asks whether the appraisal was defective based only on that difference. What is the best response?
Part Two
Three Approaches, Three Questions
Real estate valuation typically relies on three broad approaches: the income approach, the sales comparison approach, and the cost approach. Within the income approach, practitioners commonly use both direct capitalization and discounted cash flow analysis. They are not competing methods but complementary perspectives.
What Each Approach and Method Measures
| Approach / Method | What It Captures | Best For | Breaks Down When |
|---|---|---|---|
| Income: Direct Cap | Stabilized income stream converted to value via market-derived cap rate (V = NOI / R) | Stabilized properties in liquid markets with abundant cap rate evidence | Property is in transition (lease-up, renovation); thin markets with no comparable cap rate data |
| Income: DCF | Present value of projected cash flows over a hold period plus terminal value | Properties with changing income profiles, renovation plays, lease-up scenarios | Highly assumption-dependent; small changes in discount rate or growth rate produce large value swings |
| Sales Comparison | What the market actually paid for similar properties, adjusted for differences | Markets with frequent transactions and reasonably comparable properties | Heterogeneous properties, thin markets, or rapid price changes that make older comps unreliable |
| Cost Approach | Land value plus replacement cost of improvements minus depreciation | New construction feasibility, special-use properties, insurance valuation | Mature income-producing properties where depreciation estimation is subjective and replacement cost diverges from market value |
These three approaches are not competing methods but rather complementary perspectives. Each uses different data, makes different assumptions, and answers a slightly different question. Within the income approach, direct capitalization asks: "What is this income stream worth today based on how the market prices similar income streams?" DCF asks: "What is this property worth given my specific expectations about future income, expenses, and exit?" The sales comparison approach asks: "What did buyers actually pay for similar properties?" The cost approach asks: "What would it cost to create this property from scratch?"
No single approach is "best." The most reliable valuation uses all available approaches and examines whether they converge. Convergence builds confidence. Divergence reveals where assumptions need scrutiny.
Check Your Understanding
Knowledge Check 2
Triangulation, Decisions & Judgment
Assign the primary valuation approach or method to each assignment. Assignment 1: a stabilized 200-unit apartment complex in a market with twelve comparable apartment trades in the past year. Assignment 2: a half-leased office building entering an 18-month renovation and lease-up plan. Assignment 3: a church campus with no income and no comparable sales. Assignment 4: a production home in a subdivision where six nearly identical houses sold last quarter.
Part Three
Quick-Check Metrics Cut Through Complexity
Before building a full valuation model, experienced practitioners often run quick-check metrics to see whether a deal is broadly in line with the market. These are not full valuation methods. They are screening tools that help identify whether the price deserves deeper analysis, and where the underwriting questions should focus.
Four Screens: Price/Unit, Price/SF, GRM, Implied Cap
Price Per Unit is a common quick-check metric in multifamily real estate.
Price Per Unit = Price ÷ Number of Units
If the asking price for a 100-unit apartment complex is $35 million, the implied price per unit is $35,000,000 ÷ 100 = $350,000 per unit. If comparable properties recently traded at $220,000 to $260,000 per unit, the asking price requires explanation. The subject may have superior location, newer construction, stronger amenities, larger units, or completed renovations. The seller may also be pricing based on pro forma rents that have not yet been achieved. The metric does not answer the valuation question by itself, but it frames the first question.
Price Per Square Foot serves a similar function for office, retail, industrial, and some multifamily comparisons.
Price Per Square Foot = Price ÷ Rentable or Gross Building Area
A 50,000-square-foot office building offered at $15 million implies $15,000,000 ÷ 50,000 SF = $300/SF. If comparable buildings trade at $200 to $250/SF, the premium needs support. The analyst should confirm that the square footage basis is consistent, such as rentable square feet versus gross building area, because different measurement conventions can distort comparisons.
Gross Rent Multiplier (GRM) divides purchase price by gross annual rental income.
GRM = Price ÷ Gross Annual Rent
A property priced at $5 million with $500,000 in annual gross rent has a GRM of $5,000,000 ÷ $500,000 = 10.0x. GRM is most commonly used as a quick screen for smaller rental properties where detailed operating expense information may be limited. It is a blunt tool because it ignores vacancy, operating expenses, expense recoveries, capital costs, and income quality. A property with high expenses can have the same GRM as a property with strong margins, even though their values should differ. If similar properties trade at 8x to 9x GRM and the subject is priced at 12x, the premium requires explanation.
Implied Cap Rate reverses the direct capitalization formula. Instead of applying a cap rate to derive value, the analyst uses the known price and NOI to solve for the cap rate.
R = NOI ÷ Price
If a property sells for $25 million and generates $1.5 million in NOI, the implied cap rate is $1,500,000 ÷ $25,000,000 = 6.0%. The analyst can then compare the implied cap rate with market cap rates for similar properties. A lower implied cap rate may indicate a premium price, stronger expected growth, lower perceived risk, or aggressive underwriting. A higher implied cap rate may indicate a discount, higher risk, weaker growth, or a mispriced opportunity.
Application
Run quick checks before building a full model. If a property is priced at $350,000 per unit in a market where comparable assets trade near $250,000 per unit, shows a 4.0% implied cap rate when similar properties trade around 5.5%, and has a 14x GRM when comparable properties trade near 10x, the asking price appears aggressive. That does not automatically make the deal wrong. It tells the analyst what must be proven: stronger income growth, better asset quality, lower risk, superior location, or a business plan that justifies the premium.
Screen a deal in seconds. Enter price, units, square footage, gross rent, and NOI, then set the market benchmarks. The tool returns price per unit, price per square foot, GRM, and the implied cap rate, flagging each against the market. Defaults show a 120-unit, $1,650,000-NOI property at a $36,000,000 ask: $300,000/unit and a 4.6% implied cap, both about 20% above the $30,000,000 market evidence.
Check Your Understanding
Knowledge Check 3
Triangulation, Decisions & Judgment
A 120-unit multifamily property generates $1,650,000 of NOI. Comparable properties in the market trade at approximately $250,000 per unit and a 5.50% cap rate. A broker suggests an asking price of $33,000,000. What do the quick checks show?
Part Four
Where Practitioners Find the Inputs
The gap between academic valuation and professional practice often comes down to data sourcing. Knowing the formula Value = NOI ÷ Cap Rate is not enough; the analyst must also know where to find a defensible NOI, cap rate, comparable sale, rent comp, and replacement-cost estimate.
Cap Rates, Comps, and Costs, with Each Source’s Bias
Cap Rate Data.
- NCREIF Property Index, or NPI: tracks quarterly performance for institutional-quality, privately held U.S. commercial real estate. It is useful for benchmarking returns, income growth, appreciation, and appraisal-based valuation trends. Because NCREIF relies on appraised values rather than only closed transactions, its data can lag market turning points and may show appraisal smoothing.
- MSCI Real Capital Analytics, or RCA: tracks commercial real estate transaction activity, including sale prices, deal volume, buyer and seller information, and cap-rate evidence where available. Transaction-based data avoids some appraisal-smoothing issues, but it only reflects assets that actually traded.
- CBRE Cap Rate Survey: a periodic survey of active market participants and CBRE professionals. It provides cap-rate ranges by property type, market, class, and risk profile. It is useful for current sentiment and underwriting benchmarks, but it is survey-based rather than purely transaction-based.
Comparable Sales Data.
- CoStar: a widely used commercial real estate data platform. It provides property characteristics, sale comps, lease comps, tenant information, asking rents, and market analytics across major property types. Analysts should still verify transaction details, because database entries may omit concessions, assumed debt, seller financing, or other deal-specific terms.
- County assessor and recorder records: public records showing deeds, transfer dates, assessed values, and sometimes sale prices. They are inexpensive or free, but can lag, may be incomplete, and may not disclose full consideration in non-disclosure states or complex transactions.
- Broker opinions of value, or BOVs: brokers often have current intelligence on bids, failed deals, concessions, and transaction terms that have not yet appeared in databases. BOVs are useful market evidence, but they are not appraisals and should be evaluated for bias.
Replacement Cost Data.
- Marshall & Swift / CoreLogic: commonly used cost data for estimating replacement cost by building type, quality, and location. It is used by appraisers, insurers, and lenders.
- RSMeans / Gordian: construction cost data organized by assemblies, trades, and unit costs. It is more detailed and is often useful for developers, contractors, and analysts building more granular cost estimates.
Application
When sourcing cap rates, start with transaction-based evidence from sale comps and transaction databases when available. Use survey sources as a cross-check, especially when the market is thin or changing quickly. Use appraisal-based benchmarks, such as NCREIF, for institutional trend context, but remember that appraised values can lag current market pricing. The best practice is triangulation: no single source is perfect, but consistent evidence across several sources is usually much stronger than one unsupported data point.
Check Your Understanding
Knowledge Check 4
Triangulation, Decisions & Judgment
In a quarter when interest rates moved sharply, an analyst needs the most current read on where cap rates actually cleared in her submarket. Which source should she use as the best primary evidence, and what is the main caution?
Part Five
Divergence Among Methods Is Information, Not Error
The most common mistake in valuation triangulation is treating disagreement among methods as a problem to be solved by simple averaging. It is not. When the income, sales comparison, and cost approaches produce different values, the disagreement itself contains information about the market, the property, or the assumptions.
Diagnosing Method Divergences
Callback: The Gordon-Growth decomposition R = Y − g is established in Week 5 (Pricing & Risk). We apply it here to diagnose why a DCF value can diverge from a direct-cap value, not to re-derive it.
Cost Approach Exceeds Income Approach. When the cost to build a property exceeds what the income approach says the completed property is worth, the market is pricing below replacement cost. This often occurs in weak markets, oversupplied markets, or periods when construction costs and financing costs have risen faster than rents and values. For example, if it costs $60 million to build a 200-unit apartment complex, including land and construction, but the income approach values the completed asset at $50 million, new development is not economically feasible under current conditions. Developers are unlikely to start similar projects unless rents rise, costs fall, cap rates compress, or subsidies make the project viable. For an investor, buying below replacement cost may provide a margin of safety, but it is not automatically a bargain. The analyst must still ask why values are below cost and whether the income weakness is temporary or structural.
Income Approach Exceeds Cost Approach. The reverse condition, where market value exceeds replacement cost, can signal that development is economically attractive. Developers may be able to build new product for less than its stabilized value, which encourages new supply. Over time, that supply response can put pressure on rents, occupancy, and values. This is one of the long-run equilibrium mechanisms in real estate markets: when values materially exceed replacement cost, development becomes more attractive; when enough supply is delivered, competition tends to push values back toward cost, all else equal. The timing can be slow because entitlement, financing, and construction take years.
DCF Exceeds Direct Capitalization. When a DCF produces a higher value than direct capitalization, the DCF is usually assuming stronger growth, lower risk, lower capital costs, or a more favorable exit than the direct-cap evidence implies. The Gordon Growth relationship helps frame the issue: R = Y − g. If the market cap rate is 5.5%, but the DCF uses a 7.5% discount rate and assumes 3.0% long-term growth, the implied cap rate is 7.5% − 3.0% = 4.5%, which is 100 basis points below the observed market cap rate. The analyst must decide whether the property truly deserves a lower implied cap rate because of superior growth or lower risk, or whether the DCF assumptions are too optimistic.
Direct Capitalization Exceeds DCF. When direct capitalization produces a higher value than the DCF, the DCF may be using more conservative assumptions than the market appears to be pricing, such as slower rent growth, higher vacancy, larger capital expenditures, higher discount rates, or a weaker exit. That may be appropriate if the analyst has identified risks the market is underpricing, but the assumptions should be explicit and defensible.
Sales Comps Diverge From Income Approaches. When the sales comparison approach produces a different value from the income approaches, investigate the comparability and motivations behind the transactions. Buyers may pay premiums for location, scale, development potential, assumable financing, tax strategy, or portfolio fit. Conversely, distressed sales, related-party transactions, unusual financing, or estate sales may produce prices that do not reflect normal market value. Comparable sale adjustments should consider property rights conveyed, financing terms, conditions of sale, expenditures after purchase, market conditions, location, physical characteristics, economic characteristics, use, and nonrealty items. A comp is useful only after the analyst understands what actually traded and why.
| Divergence | Possible Interpretation | Analyst Response |
|---|---|---|
| Cost > Income | Market value below replacement cost; new supply may slow | Determine whether weakness is temporary or structural |
| Income > Cost | Development may be feasible; new supply may follow | Check pipeline, entitlement barriers, and construction timing |
| DCF > Direct Cap | DCF assumes stronger growth, lower risk, or better exit | Verify growth, capex, discount rate, and exit assumptions |
| Direct Cap > DCF | DCF assumptions are more conservative than market pricing | Decide whether conservatism is justified |
| Sales comps diverge | Comps may reflect different motivations, terms, or asset qualities | Adjust comps and reconcile based on reliability |
The goal is not to force all methods to agree. The goal is to understand why they differ and decide which evidence deserves the most weight.
Check Your Understanding
Knowledge Check 5
Triangulation, Decisions & Judgment
An acquisitions analyst is reviewing a submarket where building a new 200-unit apartment complex would cost approximately $60 million, including land and construction. Stabilized properties of similar quality are trading at income-approach values near $50 million. How should the analyst interpret the gap?
Knowledge Check 6
DCF & Terminal Value
Your DCF on a stabilized property produces a value of $33 million. Direct capitalization at the market cap rate produces a value of $30 million. The market cap rate is 5.5%. Your DCF uses a 7.5% discount rate and 2.5% long-run growth. How would you interpret or use this data?
Part Six
Sensitivity Analysis Maps the Boundaries of the Range
Sensitivity analysis replaces false precision with a clearer view of uncertainty. Instead of presenting only one value conclusion, the analyst shows how value changes when key assumptions change. This identifies which assumptions matter most and gives the decision-maker a defensible range rather than a single point estimate.
One-Variable and Two-Variable Sensitivity
A one-variable sensitivity table holds all assumptions constant except one, then shows the resulting value across a range of that variable. Common real estate variables to test include cap rate, discount rate, exit cap rate, vacancy rate, annual rent growth, capital costs, and NOI. For direct capitalization, cap rate sensitivity is especially important because small cap-rate changes can create large value changes. Example: a 120-unit multifamily property with $1,650,000 in NOI, valued by direct capitalization.
| Cap Rate | Indicated Value | Change From Base |
|---|---|---|
| 5.00% | $33,000,000 | +10.0% |
| 5.25% | $31,429,000 | +4.8% |
| 5.50% (base) | $30,000,000 | Base |
| 5.75% | $28,696,000 | −4.3% |
| 6.00% | $27,500,000 | −8.3% |
| 6.25% | $26,400,000 | −12.0% |
| 6.50% | $25,385,000 | −15.4% |
A 150-basis-point range in cap rates, from 5.00% to 6.50%, produces a value range from about $25.4 million to $33.0 million. That is a spread of about $7.6 million, or roughly 25% of the $30.0 million base case. The point is not that any value in the range is equally likely. The point is that cap-rate selection has a large effect on value and must be supported by market evidence.
Two-variable tables test the interaction of two assumptions at the same time. For direct capitalization, a common pairing is NOI and cap rate, which tests both income uncertainty and market pricing uncertainty. For DCF valuation, a common pairing is discount rate and exit cap rate. Example: indicated value in millions, varying by NOI and cap rate.
| NOI = $1.55M | NOI = $1.60M | NOI = $1.65M | NOI = $1.70M | NOI = $1.75M | |
|---|---|---|---|---|---|
| Cap 5.25% | $29.5M | $30.5M | $31.4M | $32.4M | $33.3M |
| Cap 5.50% | $28.2M | $29.1M | $30.0M | $30.9M | $31.8M |
| Cap 5.75% | $27.0M | $27.8M | $28.7M | $29.6M | $30.4M |
| Cap 6.00% | $25.8M | $26.7M | $27.5M | $28.3M | $29.2M |
| Cap 6.25% | $24.8M | $25.6M | $26.4M | $27.2M | $28.0M |
The two-variable table shows a range from $24.8 million in the high-cap-rate, low-NOI case to $33.3 million in the low-cap-rate, high-NOI case. That $8.5 million range is not analytical failure. It is an honest representation of the uncertainty in the two assumptions that drive value.
Scenario Analysis Adds Narrative to Numbers
Sensitivity tables show mechanical relationships. Scenario analysis adds economic logic by constructing coherent cases where multiple assumptions move together in ways that reflect plausible market conditions.
- Base case: current market rents, normalized vacancy, market-supported cap rate. This represents the most likely case based on current evidence.
- Downside case: rents decline 5%, vacancy rises 200 basis points, and the cap rate expands 50 basis points. This might represent a mild recession, new supply pressure, or local market softening.
- Upside case: rents grow above trend, vacancy improves, and the cap rate compresses modestly. This might represent a supply-constrained market with stronger-than-expected demand.
The assumptions in each scenario should be internally consistent. A downside case should not assume weaker rent growth while leaving vacancy and cap rates unchanged if those variables would likely move together. Use sensitivity tables and scenario analysis together: sensitivity tables show which variables move value the most, scenarios show what happens under coherent economic narratives. Together, they give the decision-maker both the mechanics and the reasoning behind the valuation range.
Worked example
Pricing the downside when rent, vacancy, and the cap rate move together
- Gross potential rent, 120 units
- $2,750,000
- Vacancy and credit loss, base case
- 5.0%, or $137,500
- Operating expenses
- $962,500
- Base Year 1 NOI
- $1,650,000 ($2,750,000 − $137,500 − $962,500)
- Base cap rate and indicated value
- 5.50%, giving $30,000,000
- Downside narrative
- Market rents fall 5%, vacancy rises 200 basis points to 7.0%, and the cap rate expands 50 basis points to 6.00%
- Expense treatment
- Operating expenses hold at $962,500, since payroll, taxes, and insurance tend not to fall with rent
FindThe downside indicated value, and how far it sits below the $30,000,000 base case.
- Cut the top line firstThe 5% rent decline applies to gross potential rent, before any vacancy adjustment, so the vacancy percentage is later taken on a smaller base. $2,750,000 × 0.95.$2,612,500 of gross potential rent
- Take the wider vacancy off the lower rent rollVacancy and credit loss at 7.0% is $2,612,500 × 0.07 = $182,875, so effective gross income becomes $2,612,500 − $182,875.$2,429,625 of effective gross income
- Hold expenses and re-solve NOINothing in the downside narrative reduces the cost of running the property, so expenses stay at $962,500. $2,429,625 − $962,500.$1,467,125 of NOI, about 11.1% below base
- Capitalize at the expanded rateThe same buyers who see weaker income also demand a higher yield, which is the third moving part. $1,467,125 ÷ 0.0600.$24,452,083
- Measure the drop against the income decline$30,000,000 − $24,452,083 = $5,547,917 of value lost, produced by an 11.1% decline in income.18.5% below the base case
AnswerThe coherent downside indicates about $24,452,083, roughly 18.5% below the $30,000,000 base case. An 11.1% fall in income produces an 18.5% fall in value because the cap rate widened at the same time. The result sits just under the $24.8 million corner of Figure 6.3, since a grid built around the base NOI never lets income fall that far.
Moving rent alone, with vacancy and the cap rate held flat, would have indicated $27,625,000, only about 8% below base, so a one-variable downside tends to understate the exposure by roughly half.
Build the sensitivity tables live. Set the base NOI and cap rate, the cap-rate step, and the NOI step, and the tool renders both the one-variable cap-rate table and the two-variable NOI × cap-rate grid, highlighting the base case. Defaults reproduce the $1,650,000-NOI, 5.50%-base example: the cap-rate ladder from $33.0M (5.00%) to $25.4M (6.50%), and the $24.8M–$33.3M two-variable span.
Check Your Understanding
Knowledge Check 7
Pro Forma & Forecasting
An analyst builds a two-variable sensitivity grid for a stabilized property valued by direct capitalization, varying Year 1 NOI from $1.55 million to $1.75 million and the cap rate from 5.25% to 6.25%; the indicated values across the grid range from $24.8 million to $33.3 million. If the market reprices to a 6.20% cap rate and Year 1 NOI comes in at $1.55 million, what is the indicated value, and what does that $24.8 million to $33.3 million span represent?
Knowledge Check 8
Pro Forma & Forecasting
A junior analyst builds a "downside case" by cutting rents 5% while leaving vacancy at the historical average and holding the cap rate at the market rate. What is wrong with this scenario, and what would a coherent downside look like?
Part Seven
NPV and IRR Convert a Valuation into a Decision
Parts One through Six built a defensible value range. A value range is not yet an investment decision. The decision depends on a specific price, specific assumptions, and a specific investor’s required return. A property can be fairly valued in the market and still fail a particular buyer’s return threshold.
The Worked Deal: A $30,000,000 120-Unit Acquisition
The deal extends the Part Six property. An investor contracts to buy a 120-unit multifamily asset for $30,000,000, equal to $250,000 per unit and a 5.50% going-in cap rate on $1,650,000 of Year 1 NOI. The underwriting assumptions are:
- NOI grows 3.0% annually
- Capital reserves are $66,000 in Year 1, escalating 2.0% annually
- Hold period is 5 years
- Exit cap rate is 5.75%, 25 basis points above the going-in cap rate
- Selling costs are 2.0% of gross sale price
- Cash flow before debt service, or CFBDS, equals NOI less reserves
| Year | NOI | Reserves | CFBDS |
|---|---|---|---|
| 1 | $1,650,000 | ($66,000) | $1,584,000 |
| 2 | $1,699,500 | ($67,320) | $1,632,180 |
| 3 | $1,750,485 | ($68,666) | $1,681,819 |
| 4 | $1,803,000 | ($70,040) | $1,732,960 |
| 5 | $1,857,090 | ($71,441) | $1,785,649 |
| Sale (end of Year 5) | $33,266,126 gross | ($665,323) | $32,600,803 net |
The exit value is based on Year 6 forward NOI, not Year 5 CFBDS: Year 6 NOI = $1,857,090 × 1.03 = $1,912,802. Gross reversion = $1,912,802 ÷ 0.0575 = $33,266,126. Net reversion = $33,266,126 × 0.98 = $32,600,803. Figures are computed from unrounded values and rounded for display; recomputing from rounded figures may differ by a few dollars.
Net Present Value Measures Dollars Added at the Required Return
NPV discounts every cash flow, including the purchase price, at the investor’s required return:
NPV = −Price + CF₁ ÷ (1 + r)¹ + … + (CFₙ + Net Reversion) ÷ (1 + r)ⁿ
A positive NPV means the investment exceeds the investor’s required return. A negative NPV means the investment falls short of that required return. This investor requires a 7.5% unlevered return. Discounting the CFBDS stream and net reversion at 7.5% produces a present value of $29,489,486. Against a $30,000,000 purchase price:
NPV = $29,489,486 − $30,000,000 = −$510,514
At the full asking price, the deal does not meet this investor’s 7.5% required unlevered return. The $29,489,486 figure is the investor’s investment value: the maximum price this buyer can pay and still earn the required return, given these assumptions. Market value reflects the most probable price between typical market participants. Investment value reflects what the asset is worth to a specific investor with a specific return requirement, strategy, financing, and tax position.
The negotiation implication is clear: under this buyer’s assumptions, the deal works near $29.5 million and falls short at $30.0 million. A buyer with a lower required return, stronger growth assumptions, cheaper capital, or different tax position could rationally pay more.
Check Your Understanding
Knowledge Check 9
Triangulation, Decisions & Judgment
A fund has a 7.5% unlevered required return. It is offered a property at a $30,000,000 asking price. The fund’s analyst discounts all expected property-level cash flows at 7.5% and calculates a present value of $29,120,000. What are the NPV, the investment value, and the correct action?
IRR States the Same Verdict as a Rate
The IRR is the discount rate that sets NPV equal to zero. On this deal, the unlevered IRR is 7.09%. The investor’s required unlevered return is 7.5%, so the verdict is the same as the NPV result: the deal does not meet the investor’s required return at the $30,000,000 price.
For conventional real estate cash flows, with one initial outflow followed by operating inflows and sale proceeds, NPV and IRR generally agree on the accept-or-reject decision when compared with a single hurdle rate. They can disagree when ranking mutually exclusive investments with different scale, timing, or reinvestment profiles.
Leverage Raises the Return and the Risk Together
Now finance the deal with a $18,000,000 permanent loan, equal to 60% LTV, at a 6.0% fixed rate with 30-year amortization. Annual debt service is $1,295,029, producing a 7.19% mortgage constant. The Year 1 DSCR is 1.27x, and the debt yield is 9.2%. Initial equity is $30,000,000 − $18,000,000 = $12,000,000. The loan balance after 60 payments is $16,749,784, which is repaid from sale proceeds at the end of Year 5.
| Year | CFBDS | Debt Service | Cash Flow After Debt Service | Cash-on-Cash |
|---|---|---|---|---|
| 1 | $1,584,000 | ($1,295,029) | $288,971 | 2.4% |
| 2 | $1,632,180 | ($1,295,029) | $337,151 | 2.8% |
| 3 | $1,681,819 | ($1,295,029) | $386,789 | 3.2% |
| 4 | $1,732,960 | ($1,295,029) | $437,931 | 3.6% |
| 5 | $1,785,649 | ($1,295,029) | $490,620 | 4.1% |
| Sale (end of Year 5) | $32,600,803 net | ($16,749,784) | $15,851,019 | n/a |
The levered IRR is 8.57%, compared with the 7.09% unlevered IRR. This is positive leverage because the property return exceeds the cost of debt. The equity multiple is 1.48x, and cash-on-cash return rises from 2.4% in Year 1 to 4.1% in Year 5. The early cash yield is still modest because the mortgage constant is 7.19%, not 6.0%: annual debt service includes both interest and principal repayment. That principal repayment reduces current cash flow but also reduces the loan balance, increasing equity proceeds at sale.
The general rule is that leverage magnifies equity outcomes. If the property performs well, leverage can increase equity returns. If the property underperforms, leverage can reduce or eliminate equity value more quickly. That is why levered equity requires a higher return than unlevered property cash flow. At a 9.0% levered equity required return, the levered NPV is −$221,258. Leverage improves the IRR from 7.09% to 8.57%, but it does not rescue the deal at a 9.0% equity hurdle. Borrowing concentrates the property’s results onto a smaller equity base; it does not turn an insufficient acquisition price into a strong investment.
MIRR Repairs the Reinvestment Assumption
Traditional IRR assumes interim cash flows can be reinvested at the IRR itself. That assumption can be unrealistic, especially for projects with large interim distributions, refinancing proceeds, or unusually high IRRs. The modified internal rate of return, or MIRR, addresses this by allowing separate assumptions for financing and reinvestment. Negative cash flows are discounted at the financing rate, positive interim cash flows are compounded forward at the reinvestment rate, and MIRR calculates the single annual rate connecting the present value of costs to the future value of benefits.
On this deal, assume interim equity cash flows are reinvested at 5.0%, a more conservative short-duration reinvestment rate than the 8.57% IRR. The terminal accumulation is $17,969,442 on $12,000,000 of equity, producing an MIRR of 8.41%. The gap between the 8.57% IRR and 8.41% MIRR is modest because most of the return comes from the sale, not interim cash flow. On deals with larger early distributions or higher IRRs, the gap can be more material. MIRR is useful when the assumed reinvestment rate matters to the investment conclusion.
The flagship deal model. Set the price, NOI and reserve growth, hold, exit cap, selling costs, loan terms, and required returns, and the tool computes the full before-tax verdict: unlevered NPV and IRR, levered NPV and IRR, equity multiple, cash-on-cash, and MIRR. Defaults reproduce the worked $30M deal exactly: investment value $29,489,486 (NPV −$510,514), unlevered IRR 7.09%, levered IRR 8.57%, equity multiple 1.48x, MIRR 8.41%.
Check Your Understanding
Knowledge Check 10
Triangulation, Decisions & Judgment
A fund with $12,000,000 of capital must choose between two mutually exclusive projects. Project S: invest $1,000,000 today and receive $3,000,000 at the end of Year 5 (IRR 24.6%; NPV at the 9% hurdle +$949,794; equity multiple 3.00x). Project L: invest $12,000,000 today, receive $700,000 in each of Years 1–4, and $19,200,000 in Year 5 (IRR 14.0%; NPV at the 9% hurdle +$2,746,487; equity multiple 1.83x). Which project should the fund choose, and why?
Knowledge Check 11
Leverage & Levered Returns
On a deal, the IRR is 8.57%, while the MIRR using a 5.0% reinvestment rate is 8.41%. A partner asks why MIRR is lower and when the difference would become large enough to affect a decision.
Hold, Sell, Refinance, or Renovate: One Rule Decides
Hold or Sell: the Decision Is Marginal. At the end of Year 5, the owner faces a new decision. The original purchase price is a sunk cost for this economic analysis. The relevant question is what the owner can earn from today forward by either selling now or continuing to hold. Selling today produces $32,600,803 of net sale proceeds before debt repayment and taxes. Holding means giving up that amount today in exchange for the Year 6 through Year 10 cash flows plus a Year 10 sale, underwritten here at a 6.00% exit cap rate. The marginal IRR of holding is 7.87%, the return earned on the capital left in the deal, measured from Year 5 forward. Against a 7.5% unlevered required return, holding is modestly favorable. The margin is narrow enough that a softer Year 10 exit assumption could change the answer, which is exactly why the hold-versus-sell decision should be sensitized.
Refinancing Is the Third Door. At the end of Year 5, the property supports a new 60% LTV loan against its $33,266,126 estimated value: New loan = $33,266,126 × 60% = $19,959,675. The existing loan balance is $16,749,784, so the refinance produces cash-out proceeds of $19,959,675 − $16,749,784 = $3,209,891. A refinance can be attractive for three reasons. First, loan proceeds are generally not taxable income because borrowed money must be repaid. Second, the owner keeps the asset and future cash flows. Third, the refinance pulls some equity out of the property without requiring a sale. The costs are also clear: debt service increases, DSCR declines, refinance risk moves to the new maturity date, and equity becomes more exposed to downside. Refinancing does not create value by itself. It changes the timing, risk, and distribution of cash flows.
Renovate, Refinance, Sell, or Hold. Renovation adds a fourth alternative: spend capital today to increase NOI and exit value. All four choices follow the same rule: lay out the incremental cash flows from today forward, discount them at the required return, and choose the alternative with the highest incremental NPV.
| Alternative | Incremental Cash Flows | Wins When |
|---|---|---|
| Hold | Keep CFBDS stream and later exit; forgo today’s net sale proceeds | Marginal return on retained proceeds exceeds the required return |
| Sell | Net proceeds today; forgo all future cash flows | Marginal return of holding falls below the required return, or capital has a higher-NPV use |
| Refinance | Tax-free cash-out today; higher debt service after; asset retained | Hold verdict is positive and the spread over new debt cost is positive |
| Renovate | Capital outlay now; higher NOI and exit value after | PV of the NOI and exit lift exceeds the renovation cost (incremental NPV > 0) |
The renovation test mirrors the development logic from earlier chapters. Compare the cost of the improvement with the value created by the additional income. Spending $2 million to create only $1.5 million of value is a negative-NPV renovation, even if the property looks better afterward.
Part Seven Lesson: Valuation estimates what the property is worth. NPV at the investor’s required return determines whether to act. Every later decision, whether to hold, sell, refinance, or renovate, is the same calculation restarted from today with the original purchase price excluded from the economic decision. Every number in this part was before tax. Part Eight adds the tax layer, which changes the cash flows and can sometimes change the decision.
Worked example
Testing a $2,000,000 renovation against the 5.75% exit cap rate
- Renovation cost, spent today
- $2,000,000
- Expected lift in annual NOI once stabilized
- $110,000
- Cap rate the market applies to this income
- 5.75%, the deal’s exit cap rate
- Decision rule
- Choose the alternative with the highest incremental NPV
FindWhether the renovation creates more value than it costs, and the NOI lift it would need to break even.
- Value the income the renovation buysThe lift is stabilized perpetual income, so it is capitalized rather than discounted year by year. $110,000 ÷ 0.0575.$1,913,043 of value created
- Net the value created against the cash spentIncremental NPV is what the improvement adds less what it costs. $1,913,043 − $2,000,000.−$86,957
- Read the same result as a yield on costThe renovation earns $110,000 on $2,000,000, or $110,000 ÷ $2,000,000, and that yield has to clear the rate at which the market values the income it produces.5.50% yield on cost against a 5.75% cap rate
- Solve for the lift that would break evenSetting value created equal to cost makes the required NOI lift the cost times the cap rate. $2,000,000 × 0.0575.$115,000 a year
AnswerAs underwritten, the renovation gives up about $86,957 of value, because a 5.50% yield on cost sits 25 basis points below the 5.75% rate at which the added income will be capitalized. It would need at least $115,000 of annual NOI lift to break even, and something above that to pay for construction risk and the disruption to occupancy while the work is under way.
A renovation is the development test in miniature, so the question is whether the yield on cost clears the cap rate the new income will be valued at, not whether the property looks better afterward.
Part Eight
Taxes Change the Cash Flows, and Sometimes the Decision
Everything to this point measured before-tax cash flows. Investors ultimately keep after-tax dollars, so taxes can change both returns and decisions. The tax layer creates benefits, especially depreciation, but also creates constraints: passive-loss limits, property classification issues, and tax due at sale when prior depreciation is recaptured or taxed as unrecaptured Section 1250 gain.
The Tax Code Classifies Property Before It Taxes It
The same real estate can receive different tax treatment depending on why the owner holds it. Classification comes first; consequences follow.
| Class | Held For | Tax Treatment |
|---|---|---|
| Personal residence | The owner’s own use | No depreciation; limited gain exclusion on sale; interest and property tax deductions subject to limits |
| Dealer property | Sale to others (inventory: flippers, condo converters, subdividers) | Gains taxed as ordinary income; no depreciation; no capital gain treatment regardless of holding period |
| Trade or business property (Section 1231) | Use in a trade or business, including rental operations | Depreciable; net Section 1231 gains taxed as capital gains, but the depreciation-related slice is unrecaptured Section 1250 gain, taxed up to 25% (see Taxes at Sale); net losses deductible as ordinary losses |
| Investment property | Appreciation (raw land, for example) | Capital asset; capital gain or loss on sale; generally no depreciation without business use |
Section 1231 is the category that matters most for this course. Rental real estate held for income production is generally treated as Section 1231 property if held longer than one year and not held primarily for sale to customers. The worked deal’s 120-unit rental property fits this framework. Dealer classification is the trap: a taxpayer who is effectively in the business of subdividing, developing, and selling property to customers may be treated as holding inventory, which can convert what students might expect to be capital gain into ordinary income.
Income Has Buckets, and Losses Stay in Their Bucket
For individual taxpayers, the passive activity rules divide income and losses into broad categories. Rental real estate is generally treated as passive, even if the owner is involved in management. That rule matters because passive losses generally offset only passive income. A rental property’s tax loss usually cannot shelter wages or portfolio income such as dividends and interest. Unused passive losses are suspended and carried forward. They are generally released when the taxpayer disposes of the entire activity in a fully taxable transaction to an unrelated party.
There are narrow exceptions. Some taxpayers who actively participate in rental real estate may deduct up to $25,000 of rental losses against nonpassive income, subject to income phaseouts. Taxpayers who qualify as real estate professionals and materially participate may treat rental real estate losses as nonpassive. The worked deal below assumes the investor has enough passive income from other properties to use each year’s passive loss currently. Without that assumption, the early tax savings would be delayed, often until the activity produces passive income or is sold.
Check Your Understanding
Knowledge Check 12
Taxes & After-Tax Cash Flow
Classify the most likely taxpayer position in each case. Case 1: a couple sells the home they live in. Case 2: an LLC buys 40 acres, subdivides the land, and markets lots to the public. Case 3: an investor owns a 120-unit rental property and reports a $272,351 tax loss this year, with $80,000 of salary, no other passive income, and no real estate professional status. Case 4: across an investor’s business-use real estate, net Section 1231 results for the year are a $400,000 loss.
Depreciation Is a Key Tax Benefit for Real Estate Assets
Depreciation allows an owner to deduct the cost of the building and other depreciable improvements over statutory recovery periods while the property generates income. The deduction does not require a new cash outlay in the year it is claimed, which is why depreciation is central to real estate tax planning. Five mechanics matter.
- Depreciable basis: the owner’s tax basis, generally purchase price plus capitalized acquisition costs, must be allocated between land and improvements. Land is not depreciable; improvements are. The worked deal allocates the $30,000,000 basis 80% to improvements and 20% to land, producing a $24,000,000 depreciable building basis and $6,000,000 of land basis.
- Cost recovery periods: residential rental property is generally depreciated over 27.5 years under GDS. Nonresidential real property is generally depreciated over 39 years under GDS. A mixed-use building is treated as residential rental property only if 80% or more of gross rental income comes from dwelling units; otherwise, the building is generally treated as nonresidential real property.
- Method and convention: real property is generally depreciated straight line using the mid-month convention, meaning the placed-in-service month and disposition month are treated as half-months. On a full-year simplified basis, the worked deal’s annual building depreciation is $24,000,000 ÷ 27.5 = $872,727. If placed in service in January, first-year depreciation is reduced under the mid-month convention. Accelerated depreciation does not apply to the building shell itself, but cost segregation may identify shorter-lived components, such as certain personal property or land improvements, that can be depreciated over shorter recovery periods.
- Later improvements: capital improvements made after acquisition are capitalized and depreciated separately beginning when placed in service. The recovery period depends on the type of improvement. A structural building improvement generally follows the building’s real-property recovery period, while certain personal property or land improvements may qualify for shorter lives.
- Tax depreciation versus economic depreciation: tax depreciation follows statutory rules. It does not necessarily measure actual physical wear, market value change, or economic obsolescence. At sale, depreciation affects adjusted basis and taxable gain. If the property sells above adjusted basis, prior depreciation can create unrecaptured Section 1250 gain, generally taxed at a maximum 25% federal rate for individuals under current rules.
One financing parallel completes the deduction inventory: up-front loan costs are generally not deducted immediately. They are amortized over the contractual loan term, not the amortization schedule. If the worked deal pays $360,000 of loan costs on a 10-year loan, the simplified annual deduction is $36,000 per year, and a Year 5 payoff would generally leave $180,000 of unamortized costs to deduct when the loan is retired. If the loan were truly a 30-year fully amortizing loan, the annual amortization would be $12,000, with $300,000 unamortized after five years.
Check Your Understanding
Knowledge Check 13
Taxes & After-Tax Cash Flow
An investor buys an apartment property that closes and is placed in service in January. The property has a $30,000,000 total basis, with 80% allocated to depreciable improvements and 20% to land. The borrower also pays $360,000 of up-front financing costs on a 30-year loan. What are the Year 1 depreciation deduction and the Year 1 financing-cost amortization deduction?
After-Tax Cash Flow on the Worked Deal
Taxable income and cash flow are different ledgers. Taxable income starts with NOI, then deducts interest expense, depreciation, and amortization of financing costs. Principal repayment reduces cash but is not deductible. Reserves reduce cash but generally are not currently deductible unless and until spent on deductible repairs; capital reserves are usually a cash flow item, not a tax deduction. Depreciation reduces taxable income without a current cash outlay. A simplified formula is:
Taxable Income = NOI − Interest − Depreciation − Financing Cost Amortization
After-Tax Cash Flow = Cash Flow After Debt Service − Tax Paid
If taxable income is negative and the investor can currently use the passive loss, the tax amount becomes a tax savings: ATCF = Cash Flow After Debt Service + Tax Savings. The table below assumes the investor has sufficient passive income from other properties to use the rental losses currently. Taxable income includes $12,000 per year of financing-cost amortization.
| Year | NOI | Interest | Depreciation | Taxable Income | Tax at 35% | ATCF |
|---|---|---|---|---|---|---|
| 1 | $1,650,000 | ($1,073,987) | ($836,364) | ($272,351) | $95,323 saved | $384,294 |
| 2 | $1,699,500 | ($1,060,354) | ($872,727) | ($245,581) | $85,953 saved | $423,104 |
| 3 | $1,750,485 | ($1,045,879) | ($872,727) | ($180,122) | $63,043 saved | $449,832 |
| 4 | $1,803,000 | ($1,030,512) | ($872,727) | ($112,240) | $39,284 saved | $477,215 |
| 5 | $1,857,090 | ($1,014,198) | ($836,364) | ($5,472) | $1,915 saved | $492,535 |
Year 1 shows the basic tax-shelter effect. The property produces $288,971 of cash flow after debt service but reports a $272,351 tax loss. Depreciation, a noncash deduction, helps turn positive cash flow into negative taxable income. Because the loss is assumed usable against other passive income, it produces $95,323 of tax savings, raising after-tax cash flow to $384,294. That shelter is generally a deferral, not permanent forgiveness: depreciation reduces adjusted basis, and the tax consequences appear at sale.
Two related deferral tools are worth noting. A Section 1031 like-kind exchange can defer gain on qualifying business or investment real estate if the requirements are met. Opportunity Zone investments can defer and potentially reduce certain eligible capital gains if statutory requirements are satisfied. These tools are complex and time-sensitive; they defer tax under specified rules rather than simply erase it.
Layer taxes onto the worked deal. Set the basis split, recovery period, ordinary rate, and the depreciation-recapture and capital-gain rates, and the tool builds the year-by-year taxable income, tax savings, and after-tax cash flow, then the tax due at sale (depreciation recapture first, then capital gain) and the after-tax levered IRR. Defaults reproduce the worked example: $4,290,909 of depreciation, $1,357,848 of sale tax, $14,493,171 of after-tax proceeds, and a 6.60% after-tax levered IRR on the $12,360,000 outlay (the $12,000,000 down payment plus $360,000 of financing costs), a −$215,428 NPV at the 7.0% after-tax hurdle.
Taxes at Sale: Recapture First, Then Capital Gain
Every dollar of depreciation reduces adjusted tax basis. At sale, the difference between amount realized and adjusted basis creates taxable gain. The worked deal claims $4,290,909 of depreciation over five years, leaving:
Adjusted Basis = $30,000,000 − $4,290,909 = $25,709,091
The net sale price is $32,600,803, so total gain is $32,600,803 − $25,709,091 = $6,891,712. For real property, the depreciation-related portion is commonly referred to as unrecaptured Section 1250 gain, taxed at a maximum 25% federal rate for individuals under current law. In this simplified example, the depreciation-related portion equals the depreciation claimed.
| Sale Tax Item | Amount | Rate | Tax |
|---|---|---|---|
| Total gain ($32,600,803 − $25,709,091) | $6,891,712 | n/a | n/a |
| Depreciation recapture portion (unrecaptured Section 1250 gain) | $4,290,909 | 25% | $1,072,727 |
| Remaining capital gain | $2,600,803 | 15% | $390,120 |
| Unamortized loan costs written off | ($300,000) | 35% | ($105,000) saved |
| Net tax due at sale | $1,357,848 |
The depreciation-related gain is taxed at 25% rather than the 15% long-term capital gain rate used in this simplified rate set. That is still favorable relative to the 35% ordinary rate used to value the annual deductions, and the tax has also been deferred until sale. After repaying the $16,749,784 loan balance and paying the sale tax, the equity holder receives $32,600,803 − $16,749,784 − $1,357,848 = $14,493,171. That compares with $15,851,019 before tax. If the property sold below adjusted basis, the result could be a Section 1231 loss, generally treated as an ordinary loss subject to the applicable Section 1231 and passive activity rules.
Check Your Understanding
Knowledge Check 14
Taxes & After-Tax Cash Flow
A rental property is sold with these tax facts: amount realized $34,000,000; original basis $30,000,000; accumulated depreciation $4,290,909; adjusted basis $25,709,091. A partner computes the sale tax as the total gain multiplied by the 15% capital gain rate, arriving at $1,243,636. Applying a 25% rate to the unrecaptured Section 1250 (depreciation) gain and a 15% rate to the remaining long-term capital gain, identify the error and the correct tax figure before any loan-cost write-off.
Credits Beat Deductions, and the After-Tax Verdict
Callback: LIHTC, the Historic Tax Credit, and Opportunity Zones were defined as capital sources in Week 3. Here we focus on the after-tax mechanics: why a dollar of credit beats a dollar of deduction.
Credits Beat Deductions Dollar for Dollar. A deduction reduces taxable income. A credit reduces the tax itself. For an investor in a 32% tax bracket, a $2,000 deduction saves $640 of tax. A $2,000 tax credit, if fully usable, saves the full $2,000. Two credit programs matter especially in real estate:
- Historic Rehabilitation Tax Credit: generally provides a federal credit equal to 20% of qualified rehabilitation expenditures for certified historic structures used in an income-producing activity. Under current rules, the credit is generally claimed ratably over five years.
- Low-Income Housing Tax Credit, or LIHTC: under Section 42, supports affordable housing by providing tax credits over a 10-year credit period. The credits are commonly described as the 4% credit and 9% credit, although the actual applicable percentage depends on program rules. LIHTC equity is a major financing source for affordable housing and is one reason low-income housing partnerships exist as a specialized investment class.
Credits can coexist with depreciation and other tax benefits, subject to basis adjustments, recapture rules, investor limitations, and compliance requirements. That is why credit-eligible projects may attract capital at returns that appear low before tax but make sense after tax.
The After-Tax Verdict on the Worked Deal
Assemble the after-tax equity cash flows. The initial outlay is the $12,000,000 down payment plus the $360,000 of up-front financing costs paid at closing, or $12,360,000 of equity in all. Financing costs are a real cash cost the before-tax analysis abstracted away; here they belong in the outlay, and they are the very item whose amortization and sale write-off produced the deductions above, so counting the deduction without counting the cash would double the benefit. Against that $12,360,000 run the annual ATCF stream and $14,493,171 of after-tax equity proceeds at sale. The after-tax levered IRR is 6.60%, compared with the 8.57% before-tax levered IRR. The gap reflects two forces: the tax on operating income and sale (softened because depreciation shelters income, the depreciation-related gain is taxed at 25% in the simplified model, and the remaining capital gain at 15%), and the $360,000 of financing costs the equity must now carry.
The comparison must use an after-tax required return. Before-tax cash flows should be compared with before-tax discount rates; after-tax cash flows should be compared with after-tax discount rates. At a 7.0% after-tax equity requirement, the after-tax NPV is −$215,428. The before-tax analysis rejected the deal at the asking price, and the after-tax analysis reaches the same verdict: the tax shelter narrows the shortfall but does not flip it. That is the honest lesson: taxes are real money and materially move returns (here they close most of a two-point IRR gap), but they rarely turn an over-market price into a good deal on their own. Whether a thin result lands just above or just below the line depends heavily on assumptions about depreciation, gain treatment, exit value, passive-loss usability, and investor-specific tax position, so the after-tax numbers must be run rather than assumed.
Before-tax cash flows belong with before-tax discount rates; after-tax cash flows belong with after-tax discount rates. Mixing the two is the most common error in after-tax analysis.