{
  "spec": "fio",
  "spec_version": "0.3.0",
  "manifest": {
    "id": "damodaran-fcff-simple-ginzu",
    "name": "Damodaran simple 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-simple-ginzu.xlsx"
    }
  },
  "ports": [
    {
      "id": "company_name",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B4"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Company name; text Default: \"Almarai\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "country",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B7"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Country of incorporation; exact country lookup label Default: \"Saudi Arabia\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "industry_us",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B8"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "US industry; exact lookup label Default: \"Food Processing\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "industry_global",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B9"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Global industry; exact lookup label Default: \"Food Processing\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "revenues",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B11"
      },
      "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: 21765.4. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "operating_income",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!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: 3060.9. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "interest_expense",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!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: 493.4. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "book_equity",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!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: 10667.8. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "book_debt",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!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: 45063. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "capitalize_rd",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B16"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Capitalize R&D; Yes activates all rd_* inputs Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "capitalize_leases",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B17"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Capitalize leases; Yes activates lease_* inputs. Avoid double counting leases already in reported debt Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "cash",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!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: 19000. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "non_operating_assets",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!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: 21119. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "minority_interests",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B20"
      },
      "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: 1558. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "shares_outstanding",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B21"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Share count in the same scale as amounts (millions of shares for baseline); positive Default: 4315. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 0.000001
      }
    },
    {
      "id": "stock_price",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B22"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Currency per share; positive Default: 72.28. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "effective_tax_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B23"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "decimal fraction (0.05 = 5%) Default: 0.175. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "marginal_tax_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B24"
      },
      "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": "growth_year_one",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B26"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Next-year revenue growth; decimal fraction (0.05 = 5%) Default: 0.05. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "margin_year_one",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B27"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Next-year pretax EBIT/revenue; decimal fraction (0.05 = 5%) Default: 0.14063146094259696. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "growth_years_two_five",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B28"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Revenue CAGR in years 2–5; decimal fraction (0.05 = 5%) Default: 0.05. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "target_margin",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B29"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Target pretax operating margin; decimal fraction (0.05 = 5%) Default: 0.14063146094259696. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "margin_convergence_year",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B30"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Year (1–10) at which target margin is reached Default: 5. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 1,
        "max": 10
      }
    },
    {
      "id": "sales_capital_years_one_five",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B31"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Revenue per unit of invested capital, ratio >0, years 1–5 Default: 1.708537671031893. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 0.000001
      }
    },
    {
      "id": "sales_capital_years_six_ten",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B32"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Revenue per unit of invested capital, ratio >0, years 6–10 Default: 1.708537671031893. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 0.000001
      }
    },
    {
      "id": "risk_free_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B34"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "decimal fraction (0.05 = 5%) Default: 0.0458. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "options_outstanding",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B37"
      },
      "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": "'Input sheet'!B38"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Option count; same share scale as shares_outstanding Default: 7.72. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "option_strike",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B39"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Currency per share Default: 1.29. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "option_maturity",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B40"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Years Default: 7. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "option_volatility",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B41"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Annualized stock volatility; decimal fraction (0.05 = 5%) Default: 0.45. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "override_stable_wacc",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B45"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes activates stable_wacc Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "stable_wacc",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B46"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "WACC after year 10; active when override_stable_wacc=Yes; decimal fraction (0.05 = 5%) Default: 0.0705501574064654. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "override_stable_roc",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B48"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes activates stable_roc Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "stable_roc",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B49"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Return on capital in perpetuity; active when override_stable_roc=Yes; decimal fraction (0.05 = 5%) Default: 0.15. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "override_failure",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B51"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes activates failure_probability Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "failure_probability",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B52"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when override_failure=Yes; decimal fraction (0.05 = 5%) Default: 0.12. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "failure_proceeds_basis",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B53"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Distress proceeds base; B = book capital, V = estimated company value Default: \"V\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "B",
          "V"
        ]
      }
    },
    {
      "id": "failure_recovery",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B54"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Proceeds as fraction of chosen basis; decimal fraction (0.05 = 5%) Default: 0.5. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 0,
        "max": 1
      }
    },
    {
      "id": "override_reinvestment_lag",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B56"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes activates reinvestment_lag_years Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "reinvestment_lag_years",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B57"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Years, integer 0–3; active when override_reinvestment_lag=Yes Default: 1. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "min": 0,
        "max": 3
      }
    },
    {
      "id": "keep_effective_tax_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B59"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes holds effective tax rate through terminal year; No transitions to marginal tax rate Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "override_nol",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B61"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes activates initial_nol Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "initial_nol",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B62"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Prior loss carryforward; active when override_nol=Yes; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 731.4000000000001. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "override_terminal_riskfree",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B64"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes activates terminal_riskfree_rate Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "terminal_riskfree_rate",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B65"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when override_terminal_riskfree=Yes; decimal fraction (0.05 = 5%) Default: 0.02. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "override_terminal_growth",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B67"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes activates terminal_growth Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "terminal_growth",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B68"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Perpetual growth; below terminal WACC; active when override_terminal_growth=Yes; decimal fraction (0.05 = 5%) Default: -0.05. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "override_trapped_cash",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B70"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Yes activates trapped_cash and trapped_cash_foreign_tax Default: \"No\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Yes",
          "No"
        ]
      }
    },
    {
      "id": "trapped_cash",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B71"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when override_trapped_cash=Yes; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change Default: 140000. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "trapped_cash_foreign_tax",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Input sheet'!B72"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Foreign tax rate or cash discount; active when override_trapped_cash=Yes; decimal fraction (0.05 = 5%) Default: 0.15. 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: 3. 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: 85622. 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: 73213. 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: 56052. 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: 42740. 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: \"(blank)\". 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: \"(blank)\". 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: \"(blank)\". 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: \"(blank)\". 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: \"(blank)\". 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: \"(blank)\". 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: \"(blank)\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "lease_current_expense",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating lease converter'!E4"
      },
      "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: 295. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "lease_commitment_year_1",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating lease converter'!B7"
      },
      "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: 287. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "lease_commitment_year_2",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating lease converter'!B8"
      },
      "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: 235. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "lease_commitment_year_3",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating lease converter'!B9"
      },
      "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: 194. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "lease_commitment_year_4",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating lease converter'!B10"
      },
      "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: 151. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "lease_commitment_year_5",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating lease converter'!B11"
      },
      "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: 98. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "lease_commitment_years_six_plus",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Operating lease converter'!B12"
      },
      "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: 605. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "cost_of_capital_mode",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B11"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Select WACC approach Default: \"Detailed\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "I will input",
          "Detailed",
          "Industry Average",
          "Distribution"
        ]
      }
    },
    {
      "id": "direct_wacc",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B12"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when cost_of_capital_mode=I will input; decimal fraction (0.05 = 5%) Default: 0.09. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "beta_mode",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B21"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Active when cost_of_capital_mode=Detailed Default: \"Single Business(US)\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Direct Input",
          "Single Business(US)",
          "Multibusiness(US)",
          "Single Business(Global)",
          "Multibusiness(Global)"
        ]
      }
    },
    {
      "id": "direct_beta",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B22"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Levered beta; active when beta_mode=Direct Input and cost_of_capital_mode=Detailed Default: 1.2. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "erp_mode",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B25"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "ERP approach; active when cost_of_capital_mode=Detailed Default: \"Operating regions\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Will Input",
          "Country of Incorporation",
          "Operating regions",
          "Operating countries"
        ]
      }
    },
    {
      "id": "direct_erp",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B26"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when erp_mode=Will Input and cost_of_capital_mode=Detailed; decimal fraction (0.05 = 5%) Default: 0.06. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "debt_cost_mode",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B33"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Active when cost_of_capital_mode=Detailed Default: \"Actual rating\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Direct Input",
          "Actual rating",
          "Synthetic Rating"
        ]
      }
    },
    {
      "id": "direct_cost_of_debt",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B34"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Active when debt_cost_mode=Direct Input; decimal fraction (0.05 = 5%) Default: 0.04. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "actual_credit_rating",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B35"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Exact synthetic-rating table label; active when debt_cost_mode=Actual rating Default: \"A1/A+\". Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "synthetic_firm_type",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B36"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "1 large manufacturing; 2 small/risky nonfinancial; 3 financial; active when debt_cost_mode=Synthetic Rating Default: 2. Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          1,
          2,
          3
        ]
      }
    },
    {
      "id": "debt_maturity",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B32"
      },
      "schema": {
        "type": "number"
      },
      "required": false,
      "description": "Straight debt maturity; years Default: 3. Omitted ports preserve the source cell, including its formula."
    },
    {
      "id": "industry_wacc_mode",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B66"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Active when cost_of_capital_mode=Industry Average Default: \"Multibusiness(US)\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Single Business(US)",
          "Multibusiness(US)",
          "Single Business(Global)",
          "Multibusiness(Global)"
        ]
      }
    },
    {
      "id": "distribution_region",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B70"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Active when cost_of_capital_mode=Distribution Default: \"US\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "Emerging",
          "Europe",
          "Global",
          "Japan",
          "US"
        ]
      }
    },
    {
      "id": "distribution_risk_group",
      "dir": "in",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B71"
      },
      "schema": {
        "type": "string"
      },
      "required": false,
      "description": "Active when cost_of_capital_mode=Distribution Default: \"Median\". Omitted ports preserve the source cell, including its formula.",
      "constraints": {
        "enum": [
          "First Decile",
          "First Quartile",
          "Median",
          "Third Quartile",
          "Ninth Decile"
        ]
      }
    },
    {
      "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: \"United States\". 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: 193636. 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: \"China\". 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: 500. 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: \"Rest of the World\". 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: 31335. 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: \"(blank)\". 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: 5455. 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: \"(blank)\". 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: 5830. 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: \"(blank)\". 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: 16774. 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: \"(blank)\". 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: 8078. 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: 10924. 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: \"Computers/Peripherals\". 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: 195010. 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: \"Electronics (General)\". 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: 43000. 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: \"Entertainment\". 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: 15000. 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: \"Electronics (General)\". 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: 81363. 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 output'!B33"
      },
      "schema": {
        "type": "number"
      },
      "description": "Intrinsic equity value; reporting currency per share"
    },
    {
      "id": "operating_asset_value",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation output'!B24"
      },
      "schema": {
        "type": "number"
      },
      "description": "Failure-adjusted value of operating assets; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change"
    },
    {
      "id": "equity_value",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation output'!B31"
      },
      "schema": {
        "type": "number"
      },
      "description": "Common equity value after debt, minority interests and options; amount in the workbook reporting currency and scale (millions for the supplied example); positive unless loss or cash-flow change"
    },
    {
      "id": "initial_wacc",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B13"
      },
      "schema": {
        "type": "number"
      },
      "description": "decimal fraction (0.05 = 5%)"
    },
    {
      "id": "terminal_fcff",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation output'!B16"
      },
      "schema": {
        "type": "number"
      },
      "description": "Terminal FCFF; 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 output'!B18"
      },
      "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 output'!B20"
      },
      "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 output'!B19"
      },
      "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 output'!B17"
      },
      "schema": {
        "type": "number"
      },
      "description": "decimal fraction (0.05 = 5%)"
    },
    {
      "id": "price_to_value",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Valuation output'!B35"
      },
      "schema": {
        "type": "number"
      },
      "description": "Market price / intrinsic value; ratio"
    },
    {
      "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'!C28"
      },
      "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": "'Cost of capital worksheet'!B62"
      },
      "schema": {
        "type": "number"
      },
      "description": "decimal fraction (0.05 = 5%)"
    },
    {
      "id": "pretax_cost_of_debt",
      "dir": "out",
      "shape": "scalar",
      "location": {
        "a1": "'Cost of capital worksheet'!B37"
      },
      "schema": {
        "type": "number"
      },
      "description": "decimal fraction (0.05 = 5%)"
    }
  ]
}
