Excel workbook · Catalog edition 2026
Damodaran Optimal Capital Structure and WACC
Aswath Damodaran (NYU Stern School of Business)
Sweep debt ratios from 0% to 90% to compare WACC, credit ratings, debt capacity and enterprise value in Damodaran’s pinned capital structure workbook.
- Inputs
- 37
- Outputs
- 86
- File size
- 99 KB
- Verification
- Independent scenario check
Try it
Try it loads a copy of this file from formualizer.com.
Saved workbook valuesOutput
| Row | C | D | E | F | G |
|---|---|---|---|---|---|
| 11 | Current | Optimal | Change | ||
| 12 | D/(D+E) Ratio = | 19.66% | 20.00% | 0.34% | |
| 13 | Total Debt = | $44,850 | $45,616 | $766 | |
| 14 | Beta for the Stock = | 1.02 | 1.02 | 0.00 | |
| 15 | Cost of Equity = | 10.64% | 10.66% | 0.02% | |
| 19 | WACC | 9.57% | 9.52% | -0.05% | |
| 21 | Enterprise value | $216,465 | $218,233 | $1,768 | |
| 22 | Value/share (Perpetual Growth) = | $100.30 | $101.27 | $0.97 |
What was checked
Changed-input scenarios match an independent calculation.
Scope and limitations
Catalog calculations, not certification.
Try it uses Formualizer formulas to resolve the circular credit ratings and link lease commitments to their inputs.
- All currency amounts use the same currency and millions scale; source example uses USD. Shares are millions. No FX conversion.
- Optimal means maximum enterprise value on the original 10-point 0%..90% debt grid, not continuous optimization.
- Native iterative normalization seeds each debt column with its published cached rating spread and EBITDA drop, then applies 64 fixed-point steps. Multiple equilibria are possible; nonconvergence is rejected.
- Source lookup data and country equity-premium mix remain pinned. Full flow maps all corporate inputs and lease commitments; use cellOverrides for lookup-table research.
- Source publisher redistribution permission has not been established; reference-only provenance does not grant redistribution rights.
- Discrete rating cycles have multiple equilibria; preserve publisher baseline seed, normalize to native formula DAG, reject nonconvergence. Link copied lease output commitments to input years 1..5. No JS calculation callbacks.
What it computes
Ports for the compact flow: quick_wacc_leverage_check. The full port contract includes all 123 ports.
Inputs (13)
| Port / description | Type / constraints / default |
|---|---|
ebitdaCurrency millions/year, positive EBITDA before lease adjustment. Overrides the source arithmetic formula. Default: 11767. | Type: number Default: 11767 |
depreciationCurrency millions/year, nonnegative depreciation and amortization. Default: 5200. | Type: number Default: 5200 |
interest_expenseCurrency millions/year, positive current debt interest expense. Default: 1653. | Type: number Default: 1653 |
tax_rateDecimal fraction 0..1 marginal corporate tax rate; explicit override of country lookup. Default: 0.25. | Type: number Default: 0.25 |
shares_outstandingMillions of shares, positive. Explicit independent override of source illustrative share-count formula. Default: 1826.8195413758724. | Type: number Default: 1826.8195413758724 |
share_priceCurrency/share, positive. Supply shares_outstanding together with share_price: when shares is omitted the source B19 formula 183230/share_price otherwise fixes equity capitalization. Default: 100.3. | Type: number Default: 100.3 |
equity_betaDimensionless current levered equity beta, positive. Default: 1.02. | Type: number Default: 1.02 |
book_debtCurrency millions, positive book debt; feeds market debt estimation. Default: 51608. | Type: number Default: 51608 |
current_debt_rateDecimal fraction/year, positive current pre-tax debt rate. Default: 0.069. | Type: number Default: 0.069 |
debt_maturity_yearsYears, positive weighted average remaining maturity; used when estimate_market_debt=Yes. Default: 4.2. | Type: number Default: 4.2 |
riskfree_rateDecimal fraction/year, positive risk-free rate in analysis currency. Default: 0.039. | Type: number Default: 0.039 |
equity_risk_premiumDecimal fraction/year, positive CAPM equity risk premium. Default: 0.0661. | Type: number Default: 0.0661 |
country_default_spreadDecimal fraction/year, nonnegative country credit spread. Default: 0.0181. | Type: number Default: 0.0181 |
Outputs (6)
| Port / description | Type / constraints / default |
|---|---|
current_waccDecimal fraction/year current WACC. | Type: number |
optimal_waccDecimal fraction/year WACC at enterprise-value maximizing grid ratio. | Type: number |
optimal_debt_ratioDecimal debt/(debt+equity) ratio; sweep grid 0..0.9 in 0.1 increments. | Type: number |
optimal_debtCurrency millions optimal debt. | Type: number |
optimal_enterprise_valueCurrency millions enterprise value at optimal leverage. | Type: number |
optimal_value_per_shareCurrency/share implied value after leverage change. | Type: number |
Questions this workbook answers
- What debt ratio minimizes WACC in Damodaran’s model?
- Compare optimal leverage and enterprise value
- Stress interest rates and EBITDA in a capital structure model
Questions and answers
What are the units and default assumptions?
All mapped corporate assumptions and activation switches, six lease commitments (output years 1..5 are natively linked to these inputs), and all 0%..90% leverage outputs. Rates use decimal fractions, amounts currency millions, shares millions. Omitted inputs retain source defaults. Nonconvergent credit-rating scenarios are rejected.
Is this publisher endorsed?
No. This independent mapping preserves source attribution and pins the original bytes. Public availability does not establish redistribution rights.
What is the edition?
2026 is the catalog acquisition edition, not a claim that the underlying Disney example was updated in 2026; source analysis date serial 43521 is in 2019.
For agents
Connect an MCP client to the catalog endpoint:
https://catalog.formualizer.com/v1/mcpSlug: damodaran-optimal-capital-structure · Edition: 2026
- search_workbooks
- Optional arguments: query (string), theme (string), tag (string).
- inspect_workbook
- Required: slug (string). Optional: edition (string), flow (string).
- evaluate_workbook
- Required: slug (string), inputs (object). Optional: edition (string), flow (string), cellOverrides (object), selectCells (array of strings), trace (boolean).
{
"name": "evaluate_workbook",
"arguments": {
"slug": "damodaran-optimal-capital-structure",
"edition": "2026",
"flow": "quick_wacc_leverage_check",
"inputs": {
"riskfree_rate": 0.049
}
}
}cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.
Flows
quick_wacc_leverage_check
quick wacc leverage check
13 main financial assumptions; source debt-estimation switches and No lease/No deduction-limit modes retain defaults. Rates are decimal fractions; currency amounts and shares are millions.
13 input ports · 6 output ports. Full membership in the port contract.
full_capital_structure_schedule
full capital structure schedule
37 input ports · 86 output ports. Full membership in the port contract.
REST example
Bundle scenario: rate_stress_quick_wacc_leverage_check · Flow: quick_wacc_leverage_check
curl 'https://catalog.formualizer.com/v1/models/damodaran-optimal-capital-structure/2026/evaluate?flow=quick_wacc_leverage_check' \
-H 'Content-Type: application/json' \
--data '{"inputs":{"riskfree_rate":0.049}}'Expected response
Expected values from the bundle, subject to the check level above.
{
"outputs": {
"current_wacc": 0.10370478535876729,
"optimal_wacc": 0.10471199524948197,
"optimal_debt_ratio": 0.2,
"optimal_debt": 45616.01199262912,
"optimal_enterprise_value": 212551.6163965906,
"optimal_value_per_share": 98.15778317019338
}
}Looking for another spreadsheet? Request a workbook.