formualizer

Excel workbook · Catalog edition 2026

Damodaran Full FCFF Ginzu DCF Valuation

Aswath Damodaran (NYU Stern School of Business)

NYU Stern multi-sheet discounted FCFF valuation with cost of capital, R&D capitalization, operating leases, country risk and equity dilution.

Inputs
175
Outputs
16
File size
168 KB
Verification
Engine regression check

Try it

Try it loads a copy of this file from formualizer.com.

Valuation ModelB51:F73

Saved workbook valuesOutput

RowBCDEF
51Growth Rate in Stable Phase =4.00%
52Reinvestment Rate in Stable Phase =26.67%
53FCFF in Stable Phase =$32,078.09
54Cost of Equity in Stable Phase =9.42%
55Equity/ (Equity + Debt) =80.00%
63Value of operating assets of the firm =$377,775.83
70Value of Equity in Common Stock =$358,437.83
71Value of equity per share =$377.14

What was checked

Scenarios match the engine’s own earlier results, not an independent check.

Scope and limitations

Catalog calculations, not certification.

Pinned 2026 catalog snapshot; source example dates and data are preserved.

    What it computes

    Ports for the compact flow: quick_dcf_valuation. The full port contract includes all 191 ports.

    Inputs (17)
    Port / descriptionType / constraints / default
    operating_income

    Reported EBIT; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 7040. Omitted ports preserve the source cell, including its formula.

    Type: number

    risk_free_rate

    decimal fraction (0.05 = 5%) Default: 0.045. Omitted ports preserve the source cell, including its formula.

    Type: number

    equity_risk_premium

    Direct ERP override, replaces source regional-ERP formula; decimal fraction (0.05 = 5%) Default: 0.04921860682334804. Omitted ports preserve the source cell, including its formula.

    Type: number

    synthetic_rating

    Yes activates synthetic_firm_type; No activates direct_cost_of_debt Default: "No". Omitted ports preserve the source cell, including its formula.

    Type: string

    Constraints: one of: Yes, No

    direct_cost_of_debt

    Pretax debt cost when synthetic_rating=No; decimal fraction (0.05 = 5%) Default: 0.0509. Omitted ports preserve the source cell, including its formula.

    Type: number

    high_growth_years

    Years, integer 1–15 supported by source projection columns Default: 10. Omitted ports preserve the source cell, including its formula.

    Type: number

    Constraints: min: 1; max: 15

    high_growth_beta

    Levered equity beta; dimensionless direct override Default: 0.9366996608369831. Omitted ports preserve the source cell, including its formula.

    Type: number

    keep_current_debt_ratio

    No activates high_growth_debt_ratio; Yes uses current market/book leverage Default: "Yes". Omitted ports preserve the source cell, including its formula.

    Type: string

    Constraints: one of: Yes, No

    high_growth_debt_ratio

    Active when keep_current_debt_ratio=No; decimal fraction (0.05 = 5%) Default: 0.07. Omitted ports preserve the source cell, including its formula.

    Type: number

    Constraints: min: 0; max: 1

    growth_from_fundamentals

    No activates operating_income_growth; Yes uses ROC times reinvestment Default: "Yes". Omitted ports preserve the source cell, including its formula.

    Type: string

    Constraints: one of: Yes, No

    operating_income_growth

    Active when growth_from_fundamentals=No; decimal fraction (0.05 = 5%) Default: 0.15. Omitted ports preserve the source cell, including its formula.

    Type: number

    stable_growth

    Perpetual growth below stable WACC; decimal fraction (0.05 = 5%) Default: 0.04. Omitted ports preserve the source cell, including its formula.

    Type: number

    stable_debt_ratio

    decimal fraction (0.05 = 5%) Default: 0.2. Omitted ports preserve the source cell, including its formula.

    Type: number

    Constraints: min: 0; max: 1

    stable_cost_of_debt

    Pretax debt cost in perpetuity; decimal fraction (0.05 = 5%) Default: 0.0509. Omitted ports preserve the source cell, including its formula.

    Type: number

    stable_reinvestment_fundamental

    Yes activates stable_return_on_capital; No activates stable_capex_depreciation_ratio Default: "Yes". Omitted ports preserve the source cell, including its formula.

    Type: string

    Constraints: one of: Yes, No

    stable_return_on_capital

    Active when stable_reinvestment_fundamental=Yes; decimal fraction (0.05 = 5%) Default: 0.15. Omitted ports preserve the source cell, including its formula.

    Type: number

    synthetic_firm_type

    1 large manufacturing; 2 small/risky nonfinancial; 3 financial. Actual operative source cell; Master Inputs B44 is disconnected. Active when synthetic_rating=Yes Default: 1. Omitted ports preserve the source cell, including its formula.

    Type: number

    Constraints: one of: 1, 2, 3

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

    Intrinsic equity value; reporting currency per share

    Type: number

    operating_asset_value

    amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change

    Type: number

    equity_value

    Common equity after debt, minority interests and options; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change

    Type: number

    initial_wacc

    decimal fraction (0.05 = 5%)

    Type: number

    terminal_fcff

    amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change

    Type: number

    terminal_value

    Value at end of forecast; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change

    Type: number

    Questions this workbook answers

    • Calculate intrinsic equity value using Damodaran FCFF Ginzu
    • Value a company with R&D capitalization and operating leases
    • Compare corporate DCF growth and discount rate scenarios

    Questions and answers

    What units do inputs use?

    Use one consistent reporting currency and scale for all amounts and share counts. Rates are decimal fractions; value per share is currency per share.

    Does 2026 mean all source assumptions are dated 2026?

    No. It identifies this pinned catalog edition. Historical company examples, valuation dates and embedded lookup data remain exactly as published in the source file.

    How are model modes activated?

    Use each companion mode switch together with its inputs, for example cost_of_capital_mode and direct_wacc, or capitalize_rd and rd_* history.

    For agents

    Connect an MCP client to the catalog endpoint:

    https://catalog.formualizer.com/v1/mcp

    Slug: damodaran-fcff-full-ginzu · 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-fcff-full-ginzu",
        "edition": "2026",
        "flow": "quick_dcf_valuation",
        "inputs": {
          "operating_income": 7040,
          "growth_from_fundamentals": "No",
          "operating_income_growth": 0.15,
          "high_growth_years": 10,
          "risk_free_rate": 0.045,
          "equity_risk_premium": 0.05,
          "high_growth_beta": 1,
          "synthetic_rating": "No",
          "direct_cost_of_debt": 0.055,
          "stable_growth": 0.03,
          "stable_return_on_capital": 0.15,
          "keep_current_debt_ratio": "No",
          "high_growth_debt_ratio": 0.1,
          "stable_debt_ratio": 0.2,
          "stable_cost_of_debt": 0.055
        }
      }
    }

    cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.

    Flows

    quick_dcf_valuation

    Quick DCF valuation

    Growth and discount-rate sensitivities. All unprovided assumptions retain source values/formulas. Amounts and shares use consistent reporting scale; rates are decimals.

    17 input ports · 6 output ports. Full membership in the port contract.

    full_fcff_ginzu_model

    Full FCFF Ginzu model

    All mapped assumptions, R&D history, lease schedule, geography and segment schedules, mode switches and valuation diagnostics. Defaults retain source formulas. Further uncurated chart/lookup cells are accessible through cellOverrides.

    175 input ports · 16 output ports. Full membership in the port contract.

    REST example

    Bundle scenario: pharma_growth_quick_dcf_valuation · Flow: quick_dcf_valuation

    curl 'https://catalog.formualizer.com/v1/models/damodaran-fcff-full-ginzu/2026/evaluate?flow=quick_dcf_valuation' \
      -H 'Content-Type: application/json' \
      --data '{"inputs":{"operating_income":7040,"growth_from_fundamentals":"No","operating_income_growth":0.15,"high_growth_years":10,"risk_free_rate":0.045,"equity_risk_premium":0.05,"high_growth_beta":1,"synthetic_rating":"No","direct_cost_of_debt":0.055,"stable_growth":0.03,"stable_return_on_capital":0.15,"keep_current_debt_ratio":"No","high_growth_debt_ratio":0.1,"stable_debt_ratio":0.2,"stable_cost_of_debt":0.055}}'

    Expected response

    Expected values from the bundle, subject to the check level above.

    {
      "outputs": {
        "value_per_share": 266.1017131206563,
        "operating_asset_value": 272243.72916700295,
        "equity_value": 252905.72916700295,
        "initial_wacc": 0.08962500000000001,
        "terminal_fcff": 28076.072353395783,
        "terminal_value": 517531.2876201987
      }
    }

    Looking for another spreadsheet? Request a workbook.