Key Takeaways
- A complete acquisition analysis models NOI growth, debt service, exit proceeds, and levered equity returns (IRR and NPV).
- The refinance vs. sell decision depends on tax costs, reinvestment opportunities, leverage comfort, and the spread between asset returns and debt costs.
- Cash-out refinancing extracts equity tax-free but increases leverage and debt service risk.
- The complete TVM toolkit integrates NPV, IRR, mortgage math, inflation adjustment, cross-horizon comparison, and risk-adjusted returns.
- Institutional-quality analysis models all cash flows, tests sensitivity to key assumptions, and compares risk-adjusted returns against opportunity costs.
This lesson pulls together the applied concepts from Track 2 — NPV, IRR, mortgage math, cross-horizon comparison, inflation adjustment, and risk-adjusted returns — by working through complete real-world real estate scenarios. Each example demonstrates how these tools interact in actual investment decisions.
Scenario: Acquisition Analysis for a 20-Unit Apartment Building
An investor evaluates a 20-unit apartment building priced at $2.4 million. Current NOI is $168,000 (7.0% cap rate). Projected NOI growth is 3% annually. The investor plans a 7-year hold with a sale at a projected 7.0% exit cap rate. Financing: 70% LTV ($1,680,000 loan) at 6.5% fixed for 30 years, producing monthly payments of $10,621 ($127,452 annually). Required equity return: 12%.
Year-1 cash-on-cash return: ($168,000 NOI - $127,452 debt service) / $720,000 equity = 5.6%. By year 7, NOI has grown to $206,632. Exit value at 7.0% cap: $206,632 / 0.07 = $2,951,886. After repaying the remaining loan balance of approximately $1,577,000 and deducting 5% disposition costs ($147,594), the investor receives approximately $1,227,292 in net sale proceeds. The 7-year IRR on equity is approximately 13.8%, and the NPV at the 12% required return is approximately $106,000 — positive, supporting the acquisition.
Scenario: Refinance vs. Sell Decision
After owning a property for five years, an investor has built significant equity through appreciation and amortization. The property is now worth $3.2 million with a remaining loan balance of $1.4 million. The investor can: (A) Sell, netting approximately $1.64 million after costs and repaying the loan, then reinvest. (B) Do a cash-out refinance at 75% LTV ($2.4M new loan), extracting approximately $1.0 million in tax-free proceeds while retaining ownership.
The TVM comparison: Selling triggers capital gains tax (federal + state, potentially 25–30% on the gain) but frees all capital. Refinancing defers taxes but increases leverage and debt service. If the property's unleveraged return (6.5%) exceeds the cost of the new debt (6.5% in this example), refinancing is neutral on a spread basis. However, the extracted $1.0 million can be deployed into another investment earning 10%+, creating a positive spread. The decision hinges on the reinvestment return, the tax cost of selling, and the investor's comfort with higher leverage.
Synthesis: The Complete TVM Toolkit
Track 2 has equipped you with a complete toolkit for applied TVM analysis. NPV and IRR evaluate specific deals. Mortgage math determines debt service and equity build-up. Cross-horizon comparison techniques prevent apples-to-oranges errors. Inflation adjustment reveals real wealth creation versus nominal illusions. Risk-adjusted metrics (Sharpe and Sortino ratios) ensure you are compensated for the risk you take.
In practice, these tools work together. A robust acquisition model starts with projected nominal cash flows (inflated at realistic rates), calculates NPV at a risk-appropriate discount rate, models debt service and amortization, computes levered IRR and cash-on-cash returns, and tests sensitivity to key variables (rent growth, exit cap rate, interest rate). The investor then compares the risk-adjusted return against the opportunity cost of alternative investments over the same time horizon. This disciplined, integrated approach is how institutional investors and top-performing individual investors evaluate every real estate opportunity.
Key Takeaways
- ✓A complete acquisition analysis models NOI growth, debt service, exit proceeds, and levered equity returns (IRR and NPV).
- ✓The refinance vs. sell decision depends on tax costs, reinvestment opportunities, leverage comfort, and the spread between asset returns and debt costs.
- ✓Cash-out refinancing extracts equity tax-free but increases leverage and debt service risk.
- ✓The complete TVM toolkit integrates NPV, IRR, mortgage math, inflation adjustment, cross-horizon comparison, and risk-adjusted returns.
- ✓Institutional-quality analysis models all cash flows, tests sensitivity to key assumptions, and compares risk-adjusted returns against opportunity costs.
Sources
- CFA Institute — Real Estate Valuation and Analysis(2025-01-20)
- Freddie Mac — Multifamily Market Outlook(2025-01-20)
Common Mistakes to Avoid
Running acquisition analysis without stress-testing key assumptions
Consequence: A deal that looks attractive under base-case assumptions may fail under realistic downside scenarios (higher vacancy, lower rent growth, cap rate expansion).
Correction: Always run at least three scenarios (base, optimistic, pessimistic) and test sensitivity to rent growth, exit cap rate, vacancy, and interest rates.
Treating cash-out refinance proceeds as profit rather than borrowed money
Consequence: Refinance proceeds must be repaid with interest. Extracting equity increases leverage and debt service, which can become unsustainable if property income declines.
Correction: Model the increased debt service from a refinance and verify the property's DSCR (debt service coverage ratio) remains above 1.25× under stress scenarios.
Making the refinance-vs-sell decision without calculating the tax cost of selling
Consequence: May sell when refinancing is clearly superior due to tax deferral, or vice versa.
Correction: Calculate the after-tax proceeds of selling (including depreciation recapture at 25% and capital gains at 15–20%) and compare against the after-refinance position. Include the present value of deferred taxes.
Test Your Knowledge
1.In the apartment scenario, why is the 13.8% levered IRR higher than the 7.0% unlevered cap rate?
2.What is the primary tax advantage of a cash-out refinance compared to selling?
3.Which combination of metrics provides the most comprehensive investment evaluation?