{
  "spec": "fio",
  "spec_version": "0.3.0",
  "manifest": {
    "id": "damodaran-fcff-full-ginzu",
    "name": "Damodaran full FCFF Ginzu 2026",
    "description": "All amounts and share counts must use a consistent reporting scale. Rates are decimals. Source formulas are preserved when inputs are omitted.",
    "workbook": {
      "uri": "damodaran-fcff-full-ginzu.xlsx"
    }
  },
  "ports": [
    {
      "id": "company_name",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B4"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Company name; text Default: \"Eli Lilly \". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "capitalize_rd",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B6"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes activates rd_* capitalization inputs Default: \"Yes\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "capitalize_leases",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B7"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes activates lease_* inputs; avoid double counting leases already in debt Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "normalize_earnings",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B8"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes activates normalizer_* inputs Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "country",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B9"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Country of incorporation; exact lookup label Default: \"United States\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "operating_income",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B12"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "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."
    },
    {
      "id": "interest_expense",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B13"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 486. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "capital_spending",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B14"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 3448. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "depreciation",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B15"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 1527. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "effective_tax_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B16"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "decimal fraction (0.05 = 5%) Default: 0.20050041192445. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "marginal_tax_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B17"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "decimal fraction (0.05 = 5%) Default: 0.25. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "revenues",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B18"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 34124. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "noncash_working_capital",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B19"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 2411. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "change_working_capital",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B20"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Increase consumes cash; decrease releases cash; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 2225. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "book_debt",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B21"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 25226. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "book_equity",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B22"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 10864. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "cash",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B24"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 2928. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "non_operating_assets",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B25"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 3052. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "minority_interests",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B26"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 92. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "stock_traded",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B29"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes uses market debt/equity values; No uses private-company leverage inputs Default: \"Yes\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "stock_price",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B31"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Currency per share Default: 804.14. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "shares_outstanding",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B32"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Shares in same scale as amounts (millions for baseline) Default: 950.41. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 0.000001
      }
    },
    {
      "id": "market_debt",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B33"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 25226. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "use_book_debt_ratio",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B35"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "For stock_traded=No, Yes uses book debt ratio; No activates private_debt_ratio Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "private_debt_ratio",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B36"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when stock_traded=No and use_book_debt_ratio=No; decimal fraction (0.05 = 5%) Default: 0.35. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "risk_free_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B39"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "decimal fraction (0.05 = 5%) Default: 0.045. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "equity_risk_premium",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B40"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "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."
    },
    {
      "id": "synthetic_rating",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B43"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes activates synthetic_firm_type; No activates direct_cost_of_debt Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "actual_credit_rating",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B45"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Descriptive rating label; direct_cost_of_debt controls valuation when synthetic_rating=No Default: \"AAA\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "direct_cost_of_debt",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B46"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Pretax debt cost when synthetic_rating=No; decimal fraction (0.05 = 5%) Default: 0.0509. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "options_outstanding",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B49"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes activates option_* dilution inputs Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "option_count",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B50"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Count in same scale as shares Default: 50.998. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "option_strike",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B51"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Currency per share Default: 40.35. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "option_maturity",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B52"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Years Default: 8.3. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "option_volatility",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B53"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "decimal fraction (0.05 = 5%) Default: 0.25. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "option_price_basis",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B54"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Current Price uses stock_price; Estimated Value uses valuation Default: \"Current Price\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Current Price",
          "Estimated Value"
        ]
      }
    },
    {
      "id": "high_growth_years",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B58"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Years, integer 1–15 supported by source projection columns Default: 10. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 1,
        "max": 15
      }
    },
    {
      "id": "high_growth_beta",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B59"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Levered equity beta; dimensionless direct override Default: 0.9366996608369831. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "keep_current_debt_ratio",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B60"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "No activates high_growth_debt_ratio; Yes uses current market/book leverage Default: \"Yes\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "high_growth_debt_ratio",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B62"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when keep_current_debt_ratio=No; decimal fraction (0.05 = 5%) Default: 0.07. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "keep_working_capital_ratio",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B63"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "No activates working_capital_ratio Default: \"Yes\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "working_capital_ratio",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B65"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Noncash working capital/revenue; active when keep_working_capital_ratio=No; decimal fraction (0.05 = 5%) Default: 0.12. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "growth_from_fundamentals",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B66"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "No activates operating_income_growth; Yes uses ROC times reinvestment Default: \"Yes\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "operating_income_growth",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B67"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when growth_from_fundamentals=No; decimal fraction (0.05 = 5%) Default: 0.15. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "override_growth_fundamentals",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B71"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes activates high_growth_roc and high_growth_reinvestment when growth_from_fundamentals=Yes Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "high_growth_roc",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B72"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when override_growth_fundamentals=Yes; decimal fraction (0.05 = 5%) Default: 0.33. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "high_growth_reinvestment",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B73"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when override_growth_fundamentals=Yes; decimal fraction (0.05 = 5%) Default: 0.8811285024606358. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "fade_high_growth_inputs",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B75"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes gradually transitions growth, reinvestment and WACC in second half Default: \"Yes\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "stable_growth",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B78"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Perpetual growth below stable WACC; decimal fraction (0.05 = 5%) Default: 0.04. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "stable_beta",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B79"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Levered beta; dimensionless Default: 1. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "stable_erp",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B80"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "ERP in perpetuity; decimal fraction (0.05 = 5%) Default: 0.04921860682334804. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "stable_debt_ratio",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B81"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "decimal fraction (0.05 = 5%) Default: 0.2. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "stable_cost_of_debt",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B82"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Pretax debt cost in perpetuity; decimal fraction (0.05 = 5%) Default: 0.0509. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "stable_tax_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B83"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "decimal fraction (0.05 = 5%) Default: 0.25. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "stable_reinvestment_fundamental",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B85"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes activates stable_return_on_capital; No activates stable_capex_depreciation_ratio Default: \"Yes\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "stable_return_on_capital",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B86"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when stable_reinvestment_fundamental=Yes; decimal fraction (0.05 = 5%) Default: 0.15. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "stable_capex_depreciation_ratio",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!B87"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "CapEx/Depreciation; active when stable_reinvestment_fundamental=No; dimensionless ratio Default: 1.2. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "rd_amortization_years",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'R&D converter'!F6"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Years, integer 1–10; active when capitalize_rd=Yes Default: 10. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 1,
        "max": 10
      }
    },
    {
      "id": "rd_current_expense",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'R&D converter'!F7"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Current R&D; active when capitalize_rd=Yes; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 13113. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "rd_expense_year_minus_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'R&D converter'!B11"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "R&D 1 years before current year; active when capitalize_rd=Yes and within rd_amortization_years; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 8099. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "rd_expense_year_minus_2",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'R&D converter'!B12"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "R&D 2 years before current year; active when capitalize_rd=Yes and within rd_amortization_years; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 7901. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "rd_expense_year_minus_3",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'R&D converter'!B13"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "R&D 3 years before current year; active when capitalize_rd=Yes and within rd_amortization_years; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 6746. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "rd_expense_year_minus_4",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'R&D converter'!B14"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "R&D 4 years before current year; active when capitalize_rd=Yes and within rd_amortization_years; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 5835. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "rd_expense_year_minus_5",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'R&D converter'!B15"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "R&D 5 years before current year; active when capitalize_rd=Yes and within rd_amortization_years; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 7035. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "rd_expense_year_minus_6",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'R&D converter'!B16"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "R&D 6 years before current year; active when capitalize_rd=Yes and within rd_amortization_years; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 6209. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "rd_expense_year_minus_7",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'R&D converter'!B17"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "R&D 7 years before current year; active when capitalize_rd=Yes and within rd_amortization_years; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 5340. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "rd_expense_year_minus_8",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'R&D converter'!B18"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "R&D 8 years before current year; active when capitalize_rd=Yes and within rd_amortization_years; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 5331. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "rd_expense_year_minus_9",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'R&D converter'!B19"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "R&D 9 years before current year; active when capitalize_rd=Yes and within rd_amortization_years; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 4934. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "rd_expense_year_minus_10",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'R&D converter'!B20"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "R&D 10 years before current year; active when capitalize_rd=Yes and within rd_amortization_years; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 5588. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "lease_current_expense",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating lease converter'!E3"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Operating lease expense; active when capitalize_leases=Yes; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 504. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "lease_commitment_year_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating lease converter'!B6"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Lease commitment year 1; active when capitalize_leases=Yes; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 453. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "lease_commitment_year_2",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating lease converter'!B7"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Lease commitment year 2; active when capitalize_leases=Yes; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 371. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "lease_commitment_year_3",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating lease converter'!B8"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Lease commitment year 3; active when capitalize_leases=Yes; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 265. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "lease_commitment_year_4",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating lease converter'!B9"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Lease commitment year 4; active when capitalize_leases=Yes; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 180. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "lease_commitment_year_5",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating lease converter'!B10"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Lease commitment year 5; active when capitalize_leases=Yes; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 122. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "lease_commitment_years_six_plus",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating lease converter'!B11"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Lease commitment years 6 and beyond; active when capitalize_leases=Yes; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 259. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "synthetic_firm_type",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Ratings estimator'!C4"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "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.",
      "constraints": {
        "enum": [
          1,
          2,
          3
        ]
      }
    },
    {
      "id": "normalizer_approach",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Earnings Normalizer'!D2"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when normalize_earnings=Yes; 1 historical EBIT; 2 historical ROC; 3 sector margin Default: 3. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          1,
          2,
          3
        ]
      }
    },
    {
      "id": "normalizer_ebit",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Earnings Normalizer'!D5"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when normalize_earnings=Yes; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 3500. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "normalizer_roc",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Earnings Normalizer'!D8"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when normalize_earnings=Yes; decimal fraction (0.05 = 5%) Default: 0.22. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "normalizer_margin",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Earnings Normalizer'!D11"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when normalize_earnings=Yes; decimal fraction (0.05 = 5%) Default: 0.14716703458425312. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "prior_revenues",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!C18"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Previous year-end; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 28541. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "prior_working_capital",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!C19"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Previous year-end; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "prior_book_debt",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!C21"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Previous year-end; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 16239. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "prior_book_equity",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!C22"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Previous year-end; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 10775. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "prior_cash",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!C24"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Previous year-end; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 2212. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "prior_non_operating_assets",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!C25"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Previous year-end; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 2902. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "prior_minority_interests",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Master Inputs Start here'!C26"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Previous year-end; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 126. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "debt_maturity",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B14"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Years; ancillary market debt calculation Default: 3. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "worksheet_cost_of_debt",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B15"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Ancillary cost-of-capital debt rate; decimal fraction (0.05 = 5%) Default: 0.0365. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G5"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Country lookup label; active for operating-country ERP calculation Default: \"China\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_revenue_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H5"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Country revenue; same positive currency/scale as revenues; active for operating-country ERP calculation Default: 48421. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_2",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G6"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Country lookup label; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_revenue_2",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H6"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Country revenue; same positive currency/scale as revenues; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_3",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G7"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Country lookup label; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_revenue_3",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H7"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Country revenue; same positive currency/scale as revenues; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_4",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G8"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Country lookup label; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_revenue_4",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H8"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Country revenue; same positive currency/scale as revenues; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_5",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G9"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Country lookup label; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_revenue_5",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H9"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Country revenue; same positive currency/scale as revenues; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_6",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G10"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Country lookup label; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_revenue_6",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H10"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Country revenue; same positive currency/scale as revenues; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_7",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G11"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Country lookup label; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_revenue_7",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H11"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Country revenue; same positive currency/scale as revenues; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_8",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G12"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Country lookup label; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_revenue_8",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H12"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Country revenue; same positive currency/scale as revenues; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_9",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G13"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Country lookup label; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_revenue_9",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H13"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Country revenue; same positive currency/scale as revenues; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_10",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G14"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Country lookup label; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_revenue_10",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H14"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Country revenue; same positive currency/scale as revenues; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_11",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G15"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Country lookup label; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_revenue_11",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H15"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Country revenue; same positive currency/scale as revenues; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_12",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G16"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Country lookup label; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_revenue_12",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H16"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Country revenue; same positive currency/scale as revenues; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_13",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G17"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Country lookup label; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_country_revenue_13",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H17"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Country revenue; same positive currency/scale as revenues; active for operating-country ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_region_revenue_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H21"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Regional revenue (region label in workbook G21); same currency/scale as revenues; active for regional ERP calculation Default: 0. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_region_revenue_2",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H22"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Regional revenue (region label in workbook G22); same currency/scale as revenues; active for regional ERP calculation Default: 7440. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_region_revenue_3",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H23"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Regional revenue (region label in workbook G23); same currency/scale as revenues; active for regional ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_region_revenue_4",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H24"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Regional revenue (region label in workbook G24); same currency/scale as revenues; active for regional ERP calculation Default: 0. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_region_revenue_5",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H25"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Regional revenue (region label in workbook G25); same currency/scale as revenues; active for regional ERP calculation Default: 0. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_region_revenue_6",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H26"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Regional revenue (region label in workbook G26); same currency/scale as revenues; active for regional ERP calculation Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_region_revenue_7",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H27"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Regional revenue (region label in workbook G27); same currency/scale as revenues; active for regional ERP calculation Default: 0. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_region_revenue_8",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H28"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Regional revenue (region label in workbook G28); same currency/scale as revenues; active for regional ERP calculation Default: 21791. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_region_revenue_9",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H29"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Regional revenue (region label in workbook G29); same currency/scale as revenues; active for regional ERP calculation Default: 6175. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_region_revenue_10",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H30"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Regional revenue (region label in workbook G30); same currency/scale as revenues; active for regional ERP calculation Default: 1673. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_region_revenue_11",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H31"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Regional revenue (region label in workbook G31); same currency/scale as revenues; active for regional ERP calculation Default: 1540. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_industry_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G36"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"Drugs (Pharmaceutical)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_revenue_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H36"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: 84. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_industry_2",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G37"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_revenue_2",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H37"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_industry_3",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G38"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_revenue_3",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H38"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_industry_4",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G39"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_revenue_4",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H39"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_industry_5",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G40"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_revenue_5",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H40"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_industry_6",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G41"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_revenue_6",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H41"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_industry_7",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G42"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_revenue_7",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H42"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_industry_8",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G43"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_revenue_8",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H43"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_industry_9",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G44"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_revenue_9",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H44"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_industry_10",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G45"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_revenue_10",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H45"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_industry_11",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G46"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_revenue_11",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H46"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_industry_12",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G47"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "us_segment_revenue_12",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H47"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_industry_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G52"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"Advertising\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_revenue_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H52"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: 35538. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_industry_2",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G53"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_revenue_2",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H53"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_industry_3",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G54"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_revenue_3",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H54"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_industry_4",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G55"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_revenue_4",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H55"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_industry_5",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G56"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_revenue_5",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H56"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_industry_6",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G57"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_revenue_6",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H57"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_industry_7",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G58"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_revenue_7",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H58"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_industry_8",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G59"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_revenue_8",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H59"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_industry_9",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G60"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_revenue_9",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H60"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_industry_10",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G61"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_revenue_10",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H61"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_industry_11",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G62"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_revenue_11",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H62"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_industry_12",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!G63"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Industry lookup label; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "global_segment_revenue_12",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!H63"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Segment revenue; same currency/scale as revenues; used by multibusiness beta/industry WACC calculations Default: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "value_per_share",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation Model'!F71"
      },
      "schema": {
        "type": "number"
      },
      "description": "Intrinsic equity value; reporting currency per share"
    },
    {
      "id": "operating_asset_value",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation Model'!F63"
      },
      "schema": {
        "type": "number"
      },
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change"
    },
    {
      "id": "equity_value",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation Model'!F70"
      },
      "schema": {
        "type": "number"
      },
      "description": "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"
    },
    {
      "id": "initial_wacc",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation Model'!D31"
      },
      "schema": {
        "type": "number"
      },
      "description": "decimal fraction (0.05 = 5%)"
    },
    {
      "id": "terminal_fcff",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation Model'!D53"
      },
      "schema": {
        "type": "number"
      },
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change"
    },
    {
      "id": "terminal_value",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation Model'!D59"
      },
      "schema": {
        "type": "number"
      },
      "description": "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"
    },
    {
      "id": "pv_forecast_fcff",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation Model'!F61"
      },
      "schema": {
        "type": "number"
      },
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change"
    },
    {
      "id": "pv_terminal_value",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation Model'!F62"
      },
      "schema": {
        "type": "number"
      },
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change"
    },
    {
      "id": "terminal_wacc",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation Model'!D58"
      },
      "schema": {
        "type": "number"
      },
      "description": "decimal fraction (0.05 = 5%)"
    },
    {
      "id": "market_price_premium",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation Model'!F73"
      },
      "schema": {
        "type": "number"
      },
      "description": "Market price / intrinsic value minus one; fraction"
    },
    {
      "id": "rd_asset",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'R&D converter'!D35"
      },
      "schema": {
        "type": "number"
      },
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change"
    },
    {
      "id": "lease_debt",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Operating lease converter'!C30"
      },
      "schema": {
        "type": "number"
      },
      "description": "amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change"
    },
    {
      "id": "cost_of_equity",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation Model'!D27"
      },
      "schema": {
        "type": "number"
      },
      "description": "decimal fraction (0.05 = 5%)"
    },
    {
      "id": "pretax_cost_of_debt",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation Model'!D20"
      },
      "schema": {
        "type": "number"
      },
      "description": "decimal fraction (0.05 = 5%)"
    },
    {
      "id": "high_growth_rate",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation Model'!D34"
      },
      "schema": {
        "type": "number"
      },
      "description": "decimal fraction (0.05 = 5%)"
    },
    {
      "id": "reinvestment_rate",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation Model'!D24"
      },
      "schema": {
        "type": "number"
      },
      "description": "decimal fraction (0.05 = 5%)"
    }
  ]
}
