Investment Office — Columbia Model
Loading…
Market price
Implied IRR
EPV / Share
Margin of Safety
Price / EPV
Last Review
Executive Summary
Market Cap
Enterprise Value
MktCap + Debt + Leases − Cash
Normalized NOPAT
FCF (Latest FY)
Implied IRR (Equity)
— 
ROIC 3yr Avg
WACC
Key Model Inputs — Single Source of Truth
Valuation Inputs
Normalized NOPAT
Revenue Base
Normalized Op Margin
Tax Rate (Normalized)
WACC
Diluted Shares (M)
IRR Assumptions
Selected ROIC (reinv. growth)
Organic Growth (DP17)
Reinvestment Growth
Exit Multiple (DP15)
Sustainable Buybacks / Divs
Investment Horizon
Capital & Adjustments
S&M Capitalization
R&D Capitalization
SBC Treatment
Normalization Window
Items Normalized
Goodwill in RV (DP12)
Revenue & NOPAT (DCE Adj)
Operating & Net Margins (%)
CFO vs FCF vs Buybacks
Capital Deployment (Latest FY)
Income Statement
Balance Sheet
Cash Flow Statement
Revenue & Operating Income
Net Income / FCF / NOPAT
Margins (%)
CFO / FCF / CapEx
NOPAT Construction & DCE Adjustments
S&M Capitalization Parameters
GAAP Operating Income
S&M Total Expense
S&M 3yr Average
S&M Useful Life
S&M Growth Expense
S&M Asset (Unamortized)
R&D Capitalization
R&D Capitalization Status
R&D Useful Life
R&D Growth Expense
Normalization & Final NOPAT
Non-Recurring Items
Normalized Tax Rate
NOPAT Final (EPV Input)
NOPAT Build-up Table
Effective Tax Rate History (%)
Reproduction Value — Estimated Cost to Replicate Assets From Scratch
Tangible Assets
Intangible Assets (Reconstructed)
Other Assets
Liabilities (100% at Par)
Asset Summary
Tangible Assets
Intangible Assets
Other Assets
Total Reproduction Assets
Total Liabilities
Equity Value
Reproduction Value Equity
RV per Share
Moat Test — EPV / RV
EPV / RV ratio
Earnings Power Value — No-Growth, Steady-State Valuation
EPV Calculators — Adjust Sliders
Normalized NOPAT
WACC (%)
Tax Rate (%)
EPV Operations
EPV Equity
EPV / Share
EPV Bridge — Step by Step
EPV Sensitivity — NOPAT × WACC Heatmap
WACC Components
Equity Cost (Ke)
Risk-Free Rate (Rf)
Beta (β)
Equity Risk Premium (ERP)
Ke = Rf + β × ERP
Debt Cost (Kd)
Kd Pre-Tax
Kd Post-Tax
D / (D+E)
E / (D+E)
WACC Final
Ke × We + Kd × Wd
Return on Invested Capital & Capital Build-up
ROIC (Latest FY)
ROIC 3yr Avg (IRR Input)
ROIC − WACC Spread
Marginal ROIC (1yr)
Invested Capital Components (Latest FY)
ROIC & IC History Table
ROIC vs WACC (%)
Invested Capital vs NOPAT
Implied Equity IRR — Return Decomposition
IRR Calculators
Selected ROIC (Reinvestment)
Organic Growth Rate
Exit Multiple (EV/NOPAT)
Sustainable Buybacks / yr
Investment Horizon (years)
Distribution Yield (Div+Buyback+Int / EV)
Reinvestment Growth (ReinvRate × ROIC)
Organic Growth
Multiple Expansion / Compression (ann.)
Total Equity Return (IRR)
Hurdle Rate
Margin of Safety
Health Check — Quality & Financial Fitness Scorecard
Pass
Monitor
Fail
Metric Value Threshold Status Rationale
Quality Radar
Thesis Health — Tier-1 KPIs (per IPS §4.7)
CIO Decision Points — Model Assumptions Audit Trail
Summary — Columbia Synthesis
Thesis Narrative

Identity

Valuation

Operations

Columbia Valuation Ladder
Open Decision Journal
Research Documents