formualizer

Excel workbook · Catalog edition 2026

Damodaran Simple 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
169
Outputs
14
File size
281 KB
Verification
Engine regression check

Try it

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

Valuation outputA15:D35

Saved workbook valuesOutput

RowABCD
15
16Terminal cash flow$1,855.23
17Terminal cost of capital8.81%
18Terminal value$43,858.82
19PV(Terminal value)$21,122.99
24Value of operating assets =$37,517.53
31Value of equity in common stock$31,015.53
33Estimated value /share$7.19

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 183 ports.

    Inputs (16)
    Port / descriptionType / constraints / default
    revenues

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

    Type: number

    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: 3060.9. Omitted ports preserve the source cell, including its formula.

    Type: number

    growth_year_one

    Next-year revenue growth; decimal fraction (0.05 = 5%) Default: 0.05. Omitted ports preserve the source cell, including its formula.

    Type: number

    margin_year_one

    Next-year pretax EBIT/revenue; decimal fraction (0.05 = 5%) Default: 0.14063146094259696. Omitted ports preserve the source cell, including its formula.

    Type: number

    growth_years_two_five

    Revenue CAGR in years 2–5; decimal fraction (0.05 = 5%) Default: 0.05. Omitted ports preserve the source cell, including its formula.

    Type: number

    target_margin

    Target pretax operating margin; decimal fraction (0.05 = 5%) Default: 0.14063146094259696. Omitted ports preserve the source cell, including its formula.

    Type: number

    margin_convergence_year

    Year (1–10) at which target margin is reached Default: 5. Omitted ports preserve the source cell, including its formula.

    Type: number

    Constraints: min: 1; max: 10

    sales_capital_years_one_five

    Revenue per unit of invested capital, ratio >0, years 1–5 Default: 1.708537671031893. Omitted ports preserve the source cell, including its formula.

    Type: number

    Constraints: min: 0.000001

    sales_capital_years_six_ten

    Revenue per unit of invested capital, ratio >0, years 6–10 Default: 1.708537671031893. Omitted ports preserve the source cell, including its formula.

    Type: number

    Constraints: min: 0.000001

    risk_free_rate

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

    Type: number

    override_terminal_growth

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

    Type: string

    Constraints: one of: Yes, No

    terminal_growth

    Perpetual growth; below terminal WACC; active when override_terminal_growth=Yes; decimal fraction (0.05 = 5%) Default: -0.05. Omitted ports preserve the source cell, including its formula.

    Type: number

    cost_of_capital_mode

    Select WACC approach Default: "Detailed". Omitted ports preserve the source cell, including its formula.

    Type: string

    Constraints: one of: I will input, Detailed, Industry Average, Distribution

    direct_wacc

    Active when cost_of_capital_mode=I will input; decimal fraction (0.05 = 5%) Default: 0.09. Omitted ports preserve the source cell, including its formula.

    Type: number

    distribution_region

    Active when cost_of_capital_mode=Distribution Default: "US". Omitted ports preserve the source cell, including its formula.

    Type: string

    Constraints: one of: Emerging, Europe, Global, Japan, US

    distribution_risk_group

    Active when cost_of_capital_mode=Distribution Default: "Median". Omitted ports preserve the source cell, including its formula.

    Type: string

    Constraints: one of: First Decile, First Quartile, Median, Third Quartile, Ninth Decile

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

    Intrinsic equity value; reporting currency per share

    Type: number

    operating_asset_value

    Failure-adjusted value of operating assets; 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 value 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

    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-simple-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-simple-ginzu",
        "edition": "2026",
        "flow": "quick_dcf_valuation",
        "inputs": {
          "revenues": 21765.4,
          "operating_income": 3060.9,
          "growth_year_one": 0.08,
          "margin_year_one": 0.145,
          "growth_years_two_five": 0.07,
          "target_margin": 0.17,
          "margin_convergence_year": 5,
          "sales_capital_years_one_five": 1.8,
          "sales_capital_years_six_ten": 1.9,
          "risk_free_rate": 0.0458,
          "cost_of_capital_mode": "I will input",
          "direct_wacc": 0.085,
          "override_terminal_growth": "Yes",
          "terminal_growth": 0.025
        }
      }
    }

    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.

    16 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.

    169 input ports · 14 output ports. Full membership in the port contract.

    REST example

    Bundle scenario: growth_margin_expansion_quick_dcf_valuation · Flow: quick_dcf_valuation

    curl 'https://catalog.formualizer.com/v1/models/damodaran-fcff-simple-ginzu/2026/evaluate?flow=quick_dcf_valuation' \
      -H 'Content-Type: application/json' \
      --data '{"inputs":{"revenues":21765.4,"operating_income":3060.9,"growth_year_one":0.08,"margin_year_one":0.145,"growth_years_two_five":0.07,"target_margin":0.17,"margin_convergence_year":5,"sales_capital_years_one_five":1.8,"sales_capital_years_six_ten":1.9,"risk_free_rate":0.0458,"cost_of_capital_mode":"I will input","direct_wacc":0.085,"override_terminal_growth":"Yes","terminal_growth":0.025}}'

    Expected response

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

    {
      "outputs": {
        "value_per_share": 8.932177474349684,
        "operating_asset_value": 45044.34580181889,
        "equity_value": 38542.34580181889,
        "initial_wacc": 0.085,
        "terminal_fcff": 3558.5482311468345,
        "terminal_value": 56395.37608790547
      }
    }

    Looking for another spreadsheet? Request a workbook.