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.
Saved workbook valuesOutput
| Row | A | B | C | D |
|---|---|---|---|---|
| 15 | ||||
| 16 | Terminal cash flow | $1,855.23 | ||
| 17 | Terminal cost of capital | 8.81% | ||
| 18 | Terminal value | $43,858.82 | ||
| 19 | PV(Terminal value) | $21,122.99 | ||
| 24 | Value of operating assets = | $37,517.53 | ||
| 31 | Value of equity in common stock | $31,015.53 | ||
| 33 | Estimated 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 / description | Type / constraints / default |
|---|---|
revenuesamount 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_incomeReported 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_oneNext-year revenue growth; decimal fraction (0.05 = 5%) Default: 0.05. Omitted ports preserve the source cell, including its formula. | Type: number |
margin_year_oneNext-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_fiveRevenue 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_marginTarget pretax operating margin; decimal fraction (0.05 = 5%) Default: 0.14063146094259696. Omitted ports preserve the source cell, including its formula. | Type: number |
margin_convergence_yearYear (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_fiveRevenue 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_tenRevenue 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_ratedecimal fraction (0.05 = 5%) Default: 0.0458. Omitted ports preserve the source cell, including its formula. | Type: number |
override_terminal_growthYes activates terminal_growth Default: "No". Omitted ports preserve the source cell, including its formula. | Type: string Constraints: one of: Yes, No |
terminal_growthPerpetual 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_modeSelect 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_waccActive 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_regionActive 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_groupActive 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 / description | Type / constraints / default |
|---|---|
value_per_shareIntrinsic equity value; reporting currency per share | Type: number |
operating_asset_valueFailure-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_valueCommon 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_waccdecimal fraction (0.05 = 5%) | Type: number |
terminal_fcffTerminal FCFF; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change | Type: number |
terminal_valueValue 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/mcpSlug: 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.