formualizer

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.

Optimal CS WorksheetC11:G22

Saved workbook valuesOutput

RowCDEFG
11CurrentOptimalChange
12D/(D+E) Ratio =19.66%20.00%0.34%
13Total Debt =$44,850$45,616$766
14Beta for the Stock =1.021.020.00
15Cost of Equity =10.64%10.66%0.02%
19WACC9.57%9.52%-0.05%
21Enterprise value $216,465$218,233$1,768
22Value/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 / descriptionType / constraints / default
ebitda

Currency millions/year, positive EBITDA before lease adjustment. Overrides the source arithmetic formula. Default: 11767.

Type: number

Default: 11767

depreciation

Currency millions/year, nonnegative depreciation and amortization. Default: 5200.

Type: number

Default: 5200

interest_expense

Currency millions/year, positive current debt interest expense. Default: 1653.

Type: number

Default: 1653

tax_rate

Decimal fraction 0..1 marginal corporate tax rate; explicit override of country lookup. Default: 0.25.

Type: number

Default: 0.25

shares_outstanding

Millions of shares, positive. Explicit independent override of source illustrative share-count formula. Default: 1826.8195413758724.

Type: number

Default: 1826.8195413758724

share_price

Currency/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_beta

Dimensionless current levered equity beta, positive. Default: 1.02.

Type: number

Default: 1.02

book_debt

Currency millions, positive book debt; feeds market debt estimation. Default: 51608.

Type: number

Default: 51608

current_debt_rate

Decimal fraction/year, positive current pre-tax debt rate. Default: 0.069.

Type: number

Default: 0.069

debt_maturity_years

Years, positive weighted average remaining maturity; used when estimate_market_debt=Yes. Default: 4.2.

Type: number

Default: 4.2

riskfree_rate

Decimal fraction/year, positive risk-free rate in analysis currency. Default: 0.039.

Type: number

Default: 0.039

equity_risk_premium

Decimal fraction/year, positive CAPM equity risk premium. Default: 0.0661.

Type: number

Default: 0.0661

country_default_spread

Decimal fraction/year, nonnegative country credit spread. Default: 0.0181.

Type: number

Default: 0.0181

Outputs (6)
Port / descriptionType / constraints / default
current_wacc

Decimal fraction/year current WACC.

Type: number

optimal_wacc

Decimal fraction/year WACC at enterprise-value maximizing grid ratio.

Type: number

optimal_debt_ratio

Decimal debt/(debt+equity) ratio; sweep grid 0..0.9 in 0.1 increments.

Type: number

optimal_debt

Currency millions optimal debt.

Type: number

optimal_enterprise_value

Currency millions enterprise value at optimal leverage.

Type: number

optimal_value_per_share

Currency/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/mcp

Slug: 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.