Angus Cartwright III Real Estate Investment Case Notes

Angus Cartwright III Real Estate Investment Case Notes

Overview

  • Harvard Business School case (Angus Cartwright III) analyzing four real estate investment opportunities for two cousins, Judy and John DeRight, in the Arlington/Montgomery County, MD area to achieve diversification and a minimum after-tax leveraged return of 12%.
  • Two clients: John DeRight (recently sold his business, seeks diversification, invest up to half of stock) and Judy DeRight (owns a chemical company, seeks diversification, wants property managed by a professional firm; has substantial short-term securities and liquid assets).
  • Advisor: Angus Cartwright III, based in Arlington, VA; develops a preliminary and full financial analysis framework to evaluate four properties.
  • Properties evaluated:
    • Alison Green: 100-unit garden apartment, Montgomery County, MD. Purchase price around $9.6M; target sales price $12.5M in year 10.
    • 900 Stony Walk: 75,000 sf office building (5 stories); Arlington area; purchase ~$11.5–11.6M; target sale $14.5M in year 10.
    • Ivy Terrace: 80-unit garden apartment under construction near Arlington; purchase price ~$8.4–$8.6M; target sale $10.5M in year 10.
    • The Fowler Building: 60,000 sf office building (two stories) under construction; Arlington area; purchase price ~$9.4–9.6M; target sale $13.3M in year 10.
  • Goal: determine whether four properties meet the clients’ needs, with careful consideration of leverage, occupancy, capital reserves, taxes, depreciation, and exit strategy over a 10-year holding period.
  • Cartwright uses a structured framework (Exhibits and Appendix) to compare simple and discounted returns, cash flows, tax effects, and capital gains implications.

Key Assumptions (foundational principles used in the analysis)

  • Holding period: 10 years for all properties; sale at year 10.
  • Ordinary income tax rate: 35% (for calculations of taxes on operating income).
  • Capital gains tax rate on appreciation: 15%.
  • Tax on depreciation recapture: 25%.
  • Initial equity investment funded by clients (no equity financing from outside sources beyond what's shown in Exhibits).
  • Real estate taxes assumed at market rates: 10% of gross rents for Arlington, 12% in Montgomery County.
  • Vacancy assumptions in cash flow models:
    • Alison Green and 900 Stony Walk: 5% vacancy throughout holding period (after applying 93% occupancy guarantees for Ivy Terrace and Fowler until leases reach 93%),
    • Ivy Terrace and Fowler Building: 93% occupancy initially due to guarantees, then 7% vacancy thereafter.
  • Cash flow growth assumptions (Cash Flow from Operations, CFO):
    • 3% annual growth for Alison Green, Ivy Terrace, and 900 Stony Walk.
    • 4% annual growth for The Fowler Building (above others) due to stronger upside potential once stabilized.
  • Reserves (capital expenditures) treatment:
    • Apartment reserves: $250 per apartment per year (not deductible as a current expense; treated as a capital reserve; spent at end of year 10 to prepare for sale).
    • Office reserves: $0.30 per rentable square foot per year (also a capital reserve, spent at sale).
  • Leasehold payments: The Fowler Building has annual leasehold payments of $70,000; Ivy Terrace and 900 Stony Walk have no leasehold payments.
  • Depreciation treatments:
    • Residential properties: straight-line depreciation over 27.5 years; land value allocated for depreciation as shown per property.
    • Nonresidential properties (offices): straight-line depreciation over 39 years; land value allocated for depreciation as shown per property.
  • Land and depreciation bases used for tax calculations:
    • Alison Green: depreciable base $7,500,000; land value $2,100,000; depreciation over 27.5 years.
    • 900 Stony Walk: depreciable base $7,500,000? (In Exhibit 1a depreciation base is noted; land value $3,500,000; 39-year life for office).
    • Ivy Terrace: full $8.4M purchase price depreciated over 27.5 years; land lease considerations apply; leasehold and mortgage terms described separately.
    • The Fowler Building: depreciable base $7,500,000; land leaseholds; 39-year life for depreciation.
  • Financing terms (illustrative examples for each property):
    • Alison Green: $6,000,000 mortgage, 6% interest, 10-year term, 30-year amortization; annual constant payments around 7.26% of loan; equity investment $3.6M; initial purchase price $9.6M; leasehold payments $0.
    • 900 Stony Walk: $8,000,000 mortgage, 6.5% interest, 10-year term, 20-year amortization; equity $3.? (not explicitly stated in the Exhibit excerpt here but implied by equity structure in Exhibit 1a); purchase price around $11.5–11.6M.
    • Ivy Terrace: $5.5 million mortgage, 6% interest, 10-year term, 30-year amortization; land lease terms (99-year lease); equity and purchase price per Exhibit 1a.
    • The Fowler Building: $7.0 million mortgage, 7.5% interest, 10-year term, 25-year amortization; leasehold payments $70,000; equity investment as per Exhibit 1a.
  • Portfolio-level considerations:
    • Diversification across apartment and office asset types to balance risk and potential inflation protection.
    • Geographic proximity in the Arlington/Montgomery County region to enable effective property management and potential macroeconomic hedges.
    • Importance of professional property management, long-term rental guarantees, occupancy stabilization, and capital replacement planning.

Exhibit Snapshots (key figures used in the analysis)

  • Exhibit 1a — Alison Green, 900 Stony Walk, Ivy Terrace, The Fowler Building (selected fields):
    • Number of units / rentable space: Alison Green 100 units; 900 Stony Walk 67,000 sf; Ivy Terrace A) (80 units); The Fowler Building (60,000 sf).
    • Gross Purchase Price: Alison Green $9,600,000; 900 Stony Walk $11,500,000; Ivy Terrace $8,400,000; The Fowler Building $9,400,000.
    • Depreciable Base: Alison Green $7,500,000; 900 Stony Walk $7,500,000; Ivy Terrace $7,???; The Fowler Building $7,500,000.
    • Depreciable Life (Capital Recovery Period): 27.5 years for residential; 39 years for nonresidential.
    • Estimated Sales Price (Year 10): Alison Green $12,500,000; 900 Stony Walk $14,500,000; Ivy Terrace $10,500,000; The Fowler Building $13,300,000.
    • Expected Year of Sale: 10 for all four.
    • Cash Flow from Operations (CFO): Alison Green $870,200; 900 Stony Walk not shown in this extract; Ivy Terrace and Fowler CFOs follow from Exhibit 2.
    • Annual Increase in CFO: 3% (Alison Green); 4% for Fowler; others 3%.
    • Equity Investment: Alison Green $3,600,000; others per Exhibit 1a.
    • Amount of First Mortgage: Alison Green $6,000,000; others per exhibit.
    • Mortgage terms: 6% rate, 10-year term; 30-year amortization (Alison Green); 6.5% for 900 Stony Walk with 20-year amortization; 6% for Ivy Terrace with 30-year amortization; 7.5%/25-year amortization for Fowler.
    • Interest, Payment Schedules: shown in Exhibit 5/Exhibit 6; constant loan payments vary by property.
    • Leasehold/Effective rent details and other items: The Fowler Building includes $70,000 annual leasehold payments; others have none.
  • Exhibit 2 — First-Year Project Setups (000s):
    • Gross Rents, Vacancies, Effective Gross Income, Real Estate Taxes, Other Operating Expenses, Capital Reserves, Cash Flow From Operations, Finance Payments, Lease Payments, Before Tax Cash Flow.
    • Alison Green: CFO $870.2; Vacancy -$72.0; Real Estate Taxes -$172.8; Other Op Expenses -$300.0; Capital Reserves -$25.0; BTCF $434.3; Financing -$435.9; Before Tax Cash Flow $434.3.
    • 900 Stony Walk — CFO and BTCF values follow Exhibit 2 format (not fully listed in the excerpt).
    • Ivy Terrace — CFO and BTCF values follow the same format.
    • The Fowler Building — CFO and BTCF values follow the same format.
  • Exhibit 3 — Major comparables metrics (for price justification):
    • Price per unit or per rentable sf: Alison Green $96,000 per unit; 900 Stony Walk $171.64 per sf; other metrics include Rentable Space related values.
    • Real Estate Taxes / Gross Revenue: 12% (Alison Green); Other Operating Expenses per unit / per sf: $3,000 / $5.50; RE Taxes + Operating Expenses per unit / sf: $4,728; Occupancy: 95% (as-built).
  • Exhibit 4 — Break-even analysis (occupancy):
    • Alison Green: Current occupancy 95%; Added margin 30.16%; Break-even occupancy 64.84%; LTV 62.50%; Debt Coverage Ratio (DCR) 2.00.
  • Exhibit 5 — Projected Cash Flow (Alison Green) (table shown in thousands):
    • Year 0: Cash Flow from Operations $870.20; Financing -$435.89; BTCF $434.31; Amortization $75.89; Reserve $25.00; Depreciation -$272.73; Taxable Income $262.47; Tax Payable @35% -$91.87; After Tax Cash Flow $342.44; Equity in -$3,600.00; Net Cash from Sale $6,421.02; Total Return $6,917.53; Purchase Price $9,600.00; Sales Price $12,500.00; Net Book Value $7,122.73; Gain on Sale $5,377.27; Taxes on Depreciation $1,?; Mortgage Balance $4,999.66.
    • Year 1–10 cash flows include annual CFO growth (3%), financing payments fixed, depreciation, tax calculations, and eventual sale. Detailed numbers are in Exhibit 5 and the cross-referenced table in Exhibit 8.
  • Exhibit 6 — Financial Analysis (Alison Green, 900 Stony Walk, Ivy Terrace, The Fowler Building):
    • Equity Required: $3,600,000 for Alison Green (per Exhibit 1a).
    • Cap rates: Purchase Cap Rate 9.06%; Sale Cap Rate 9.08%.
    • Cash-on-Cash Return (Year 1): 12.06%.
    • Increase in Capital Value: 30.21%.
    • Internal Rate of Return (IRR): 14.93%.
    • Net Present Value (NPV) at 12%: $734.29k.
    • Profitability Index (PI): 20.4%.
  • Exhibit 7 — Ranking by simple and discounted return measures:
    • Rankings for Alison Green, 900 Stony Walk, Ivy Terrace, The Fowler Building across measures: Cap Rate (Purchase), Cap Rate (Sale), Cash-on-Cash, IRR, NPV, PI.
  • Exhibit 8 — Breakdown for Alison Green IRR of 14.93% (cash flow streams):
    • Cash Flow Before Tax; Income Tax Payable; Futures (capital gains and depreciation effects); Net Cash from Sale; Total returns. IE: Year-by-year CF before tax and after tax streams; tax payable grows from 21% to 29% over time; sale effects contribute to Futures.
  • Exhibit 9 — IRR and associated metrics per project and a detailed capital structure snapshot; Recap: IRR 14.93% for Alison Green; NPV $734k; Cap rates and cash-on-cash figures summarized in Exhibit 6.
  • Exhibit 10 — Breakdown of “Futures” for Alison Green by component (Year 1–10):
    • Return on initial cash (equity) $3,600; Mortgage amortization; Increase in sales price; 25% tax on depreciation; Capital gains tax on increased sale price; Net cash from sale; Proportions used to explain how futures contribute to IRR.
  • Exhibit 11–12 — Summaries and interpretations of tax effects, depreciation recapture, and the effects of different streams on the overall IRR and NPV; emphasize that depreciation and mortgage amortization interact with taxes to produce after-tax cash flows.
  • Appendix (Method for Financial Analysis) — Step-by-step framework for evaluating income-producing real estate: variables to establish; cash flow computations; tax calculations; gain on sale; taxes on depreciation; capital gains taxes; net cash flow from sale; IRR computation; sensitivity of component streams; and the approach to discounting cash flows to compute NPV and IRR.

Detailed Methodology (Appendix) and Calculations

  • Step 1: Establish key variables per property:
    • A. Gross Purchase Price
    • B. Depreciable base = Gross Purchase Price − Land Value
    • C. Depreciable life (capital recovery period): 27.5 years (residential) or 39 years (commercial)
    • D. Method of Depreciation: Straight-line (as described)
    • E. Estimated Sales Price (Year of sale)
    • F. Estimated Cash Flow from Operations (CFO) per year
    • G. Annual CFO growth rate
    • H. Leasehold payments
    • I. Equity Investment
    • J. Mortgage details (amount, rate, term, amortization)
    • K. Interest rate and annual carrying cost of mortgage
    • L. Owner’s income tax bracket (assume 35% if unknown)
  • Step 2: Compute Cash Flow Before Income Taxes (CFBIT):
    • CFBIT = CFO − Total Financing Payments − Leasehold (if any) − Real Estate Taxes? (per formulation) – typically CFO minus financing payments gives BTCF; reserves may be treated separately.
    • The ratio CFBIT / Equity Investment yields the cash-on-cash return.
    • Free and Clear return (Cap Rate) = CFO / Gross Purchase Price (or total project cost, depending on convention).
  • Step 3: Determine Taxable Income for each year:
    • Taxable Income = CFO − Interest − Depreciation − Leasehold (if any) + other deductions (per model).
  • Step 4: Income Tax Payable = Taxable Income × Tax Bracket (35% assumed).
  • Step 5: Cash Flow After Income Taxes = CFBIT − Tax Payable + Non-cash items adjustments (e.g., depreciation recapture handled at sale; reserves treated based on policy).
  • Step 6: Gain on Sale at end of Year 10 = Net Sales Price − Book Value at sale (which equals original cost plus capital improvements less depreciation taken).
  • Step 7: Taxes on Depreciation Recapture (Depreciation Tax) = (Total Depreciation Taken) × 25%
  • Step 8: Capital Gains Taxes on Sale = Remaining gain after depreciation recapture × 15% (subject to installment sale rules if applicable).
  • Step 9: Net Cash Flow from Sale = Net Sales Price − Mortgage Balance − Taxes Payable on sale.
  • Step 10: Internal Rate of Return (IRR) by discounting the net after-tax cash flows year-by-year at a rate that sets NPV to zero (the discount rate that satisfies ∑ CFt/(1+r)^t = 0 with CF0 as negative equity).
  • Step 11: If IRR is known, decompose the component cash flows by discounting each stream at IRR to see the relative contributions of each stream to the total return.
  • Notes on interpretation:
    • The depreciation deduction can create losses that reduce ordinary taxes and improve after-tax cash flow; depreciation recapture taxes apply upon sale.
    • The mortgage amortization is a non-deductible cash outflow for tax purposes; it affects after-tax cash flow via reduced taxes (through interest deduction) but not the base depreciation calculation.
    • The reserve allocations (capital reserves) are non-cash expenses for operating period; they affect book basis and later tax depreciation but are not tax-deductible in the year spent.

Key Formulas (LaTeX syntax)

  • Simple return measures:
    • Capitalization Rate (Purchase) = racCFOPurchaseextPricerac{CFO}{Purchase ext{ }Price}
    • Capitalization Rate (Sale) = racBTCFSalesextPriceext(ornetsalevalueaftertransactioncosts)rac{BTCF}{Sales ext{ }Price} ext{ (or net sale value after transaction costs)}
    • Cash-on-Cash Return (year 1) = racAfterTaxextCashextFlowEquityextInvestmentrac{AfterTax ext{ }Cash ext{ }Flow}{Equity ext{ }Investment}
  • Discounted return measures:
    • Internal Rate of Return (IRR) is the discount rate r that satisfies
      ext{NPV} = ext{CF}0 + rac{ ext{CF}1}{(1+r)^1} + rac{ ext{CF}2}{(1+r)^2} + \, rac{ ext{CF}{10}}{(1+r)^{10}} = 0.
    • Net Present Value (NPV) at discount rate r:
      ext{NPV}(r) =
      rac{ ext{CF}1}{(1+r)^1} + rac{ ext{CF}2}{(1+r)^2} + \, rac{ ext{CF}{10}}{(1+r)^{10}} + ext{CF}0.
    • Increase in Capital Value (ICV) = racextSalesPrice−extPurchasePriceextPurchasePrice.rac{ ext{Sales Price} - ext{Purchase Price}}{ ext{Purchase Price}}.
    • Break-even Occupancy (illustrative, per Exhibit 4) is the occupancy level at which BTCF (after financing) equals zero; e.g., for Alison Green, BEO = 64.84% with current occupancy 95% and added margin 30.16%.
  • Taxes on sale and depreciation recapture:
    • Depreciation Tax on total depreciation taken = ext{Total Depreciation} imes 25eta ext%.
    • Capital Gains Tax on sale = remaining gain × 15 ext% (subject to tax law constraints).
  • Cash Flow From Operations (CFO) growth:
    • CFOt = CFO0 × (1 + g)^t, with g = 0.03 for most properties and g = 0.04 for Fowler.
  • Reserve spending at sale (simplified):
    • All reserves assumed to be spent at end of Year 10, increasing book value by the total reserve amount, with subsequent tax treatment handled in sale calculations.

How the Four Projects Align with Client Goals

  • Alison Green:
    • Strongest initial cash-on-cash and IRR metrics among the four (IRR ~14.93% in Exhibit 6; NPV positive).
    • 62.5% loan-to-value; debt coverage ratio ~2.0; occupancy ~95% initially.
    • Cash flow and sale projections support the DeRights’ 12% after-tax hurdle with room for sensitivity via sale price and cap rate changes.
  • 900 Stony Walk:
    • Office property with 75,000 sf; 95% occupancy historically; risk profile tied to office market demand; higher cap rate potential but different tax treatment due to depreciation and future sale values.
  • Ivy Terrace:
    • Under construction; capital gains potential from sale at year 10; depreciation benefits via 27.5-year schedule; leasehold considerations given land use and 99-year lease with initial occupancy guarantees.
  • The Fowler Building:
    • Office property with leaseholds and 93% occupancy target; higher growth rate (4%) in CFO; potential for higher appreciation in sales price due to below-market initial leases and rapid rent-up.
  • Cartwright’s approach emphasizes:
    • First cut screening via simple metrics (cap rate, cash-on-cash, break-even analyses).
    • Detailed, tax-adjusted projections (IRR, NPV) to guide negotiations and price ceilings.
    • Understanding the sensitivity of returns to occupancy, sale timing, mortgage structure, and tax law assumptions.
    • Clear visualization of who benefits from which cash flow stream (income vs. tax shields vs. sale gains) to tailor client advice and negotiation strategy.

Practical and Real-World Implications

  • Tax strategy matters: depreciation, tax shields, and capital gains planning significantly influence after-tax returns; depreciation recapture and capital gains taxes can materially change outcomes at sale.
  • Financing terms and leverage drive cash-on-cash and risk: higher loan amounts improve cash flow initially but increase default risk if occupancy or rents decline.
  • Capital reserves are prudent but reduce immediate cash flow; how reserves are treated for tax purposes (basis adjustments on sale) can materially affect gains.
  • Exit strategy and price realization: assumptions about sale prices and cap rates heavily influence IRR and NPV, underscoring the importance of market research and scenario planning.
  • Portfolio construction: The mix of apartment and office properties in a near geography offers diversification benefits and potential for cross-management efficiencies, but requires careful market analysis and ongoing oversight.

Summary of Core Learnings for Exam Preparedness

  • How to structure an income-producing property analysis: establish inputs, compute CFO, derive BTCF, apply taxes (ordinary, depreciation, capital gains), calculate after-tax cash flows, and model sale at end of holding period.
  • How to compute and interpret key metrics: Cap Rate (purchase and sale), Cash-on-Cash Return, IRR, NPV, Profitability Index, and Break-even Occupancy.
  • The role of reserves and leasehold payments in shaping cash flows and tax outcomes.
  • The importance of debt service, debt coverage ratios, and loan-to-value in risk assessment and lender perspective.
  • The value of presenting a breakdown of future cash flows by sources (Before Tax Cash Flow, Taxes, Futures, and Net Cash from Sale) to inform client discussions and decision-making.

Notes on Exhibits and Appendix Access

  • Exhibits 1 through 6 provide the data framework, pro forma setups, comparables, break-even analyses, and the final IRR/NPV results for Alison Green (the primary case example in the material).
  • Exhibit 8 presents the year-by-year tax and futures breakdown that contributes to the overall IRR of 14.93% for Alison Green.
  • Exhibit 9 and Exhibit 12 consolidate IRR and NPV results across properties and present a comparative view.
  • Exhibit 10 provides a breakdown of the “Futures” component of the return to illustrate where gains and tax effects arise.
  • The Appendix method provides a step-by-step algorithm to replicate the analysis for any income-producing real estate project, including depreciation rules, tax treatment, and IRR/NPV computations.

Quick References (Key Figures for Alison Green in Exhibit 6)

  • Equity Required: 3,600,0003,600,000
  • Cap Rate (Purchase): 9.06 ext{ t ext%}
  • Cap Rate (Sale): 9.08 ext{ t ext%}
  • Cash-on-Cash Return (Year 1): 12.06 ext{ t ext%}
  • Increase in Capital Value: 30.21 ext{ t ext%}
  • IRR: 14.93 ext{ t ext%}
  • NPV @ 12%: 734.29k734.29k
  • Profitability Index: 20.4 ext{ t ext%}
  • Estimated Sales Price (Year 10) for Alison Green: 12,500,00012,500,000
  • Purchase Price (Alison Green): 9,600,0009,600,000
  • Mortgage: 6,000,0006,000,000 at 6 ext{%}, 10-year term, 30-year amortization
  • CFO Year 1: 870.2k870.2k; BTCF Year 1: 434.3k434.3k; After-Tax Cash Flow Year 1: 342.44k342.44k

End of Notes