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.
Saved workbook valuesOutput
| Row | B | C | D | E | F |
|---|---|---|---|---|---|
| 51 | Growth Rate in Stable Phase = | 4.00% | |||
| 52 | Reinvestment Rate in Stable Phase = | 26.67% | |||
| 53 | FCFF in Stable Phase = | $32,078.09 | |||
| 54 | Cost of Equity in Stable Phase = | 9.42% | |||
| 55 | Equity/ (Equity + Debt) = | 80.00% | |||
| 63 | Value of operating assets of the firm = | $377,775.83 | |||
| 70 | Value of Equity in Common Stock = | $358,437.83 | |||
| 71 | Value 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 / description | Type / constraints / default |
|---|---|
operating_incomeReported 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_ratedecimal fraction (0.05 = 5%) Default: 0.045. Omitted ports preserve the source cell, including its formula. | Type: number |
equity_risk_premiumDirect 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_ratingYes 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_debtPretax 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_yearsYears, 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_betaLevered equity beta; dimensionless direct override Default: 0.9366996608369831. Omitted ports preserve the source cell, including its formula. | Type: number |
keep_current_debt_ratioNo 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_ratioActive 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_fundamentalsNo 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_growthActive 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_growthPerpetual 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_ratiodecimal 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_debtPretax 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_fundamentalYes 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_capitalActive 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_type1 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 / description | Type / constraints / default |
|---|---|
value_per_shareIntrinsic equity value; reporting currency per share | Type: number |
operating_asset_valueamount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change | Type: number |
equity_valueCommon 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_waccdecimal fraction (0.05 = 5%) | Type: number |
terminal_fcffamount 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-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.