{ "fileType": "BalanceCheat.Model", "formatVersion": 4, "modelSchemaVersion": 1, "calculationVersion": 4, "metadata": { "id": "synthetic-dcf-worked", "name": "Example Company", "createdAt": "2026-01-01T00:00:00.000Z", "modifiedAt": "2026-01-01T00:00:00.000Z" }, "view": {}, "workspace": { "scenarioVersion": 2, "core": { "schemaVersion": 1, "modelType": "advanced", "revision": 0, "id": "company-1", "currency": "EUR", "calendar": { "calculation": "annual", "startYear": 2026, "actualYears": 0, "fiscalYearEnd": { "month": 12, "day": 31 } }, "policies": { "basis": "legacy-v1" }, "scope": { "version": 1, "rootEntityId": "entity-1" }, "instruments": {}, "legacy": { "type": "industrial", "name": "Example Company", "origin": "blank", "allowZero": true, "actual": { "revenue": 0, "cogs": 0, "sga": 0 }, "otherCARate": 0, "otherCLRate": 0, "opening": { "cash": 500000, "ar": 200000, "inventory": 100000, "otherCA": 0, "ppe": 1000000, "otherNCA": 0, "ap": 100000, "otherCL": 0, "revolver": 0, "debt": 500000, "otherNCL": 0, "equity": 1200000, "revenue": 0, "assets": 1800000 }, "years": [ { "revenue": 2000000, "growth": 0, "grossMargin": 0, "sga": 0, "da": 100000, "taxRate": 25, "capex": 150000, "dso": 0, "dio": 0, "dpo": 0, "debt": 500000, "interestRate": 8, "payout": 0, "cogsAmount": 1000000, "sgaAmount": 200000 }, { "revenue": 2200000, "growth": 0, "grossMargin": 0, "sga": 0, "da": 110000, "taxRate": 25, "capex": 170000, "dso": 0, "dio": 0, "dpo": 0, "debt": 500000, "interestRate": 8, "payout": 0, "cogsAmount": 1100000, "sgaAmount": 220000, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0 }, { "revenue": 2400000, "growth": 0, "grossMargin": 0, "sga": 0, "da": 120000, "taxRate": 25, "capex": 190000, "dso": 0, "dio": 0, "dpo": 0, "debt": 500000, "interestRate": 8, "payout": 0, "cogsAmount": 1200000, "sgaAmount": 240000, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0 } ], "currency": "EUR", "calendar": { "startYear": 2026, "actualYears": 0, "fiscalYearEnd": { "month": 12, "day": 31 } }, "actuals": {}, "forecastInputs": { "2026": { "ar": 220000, "inventory": 120000, "ap": 110000, "interest": 40000, "tax": 165000 }, "2027": { "ar": 260000, "inventory": 140000, "ap": 120000, "interest": 40000, "tax": 182500 }, "2028": { "ar": 300000, "inventory": 160000, "ap": 130000, "interest": 40000, "tax": 200000 } } }, "objects": [], "authority": {}, "nextId": 1, "display": { "currency": "EUR", "fx": 1, "units": 1000 }, "notes": {}, "valuation": { "version": 1, "enabled": { "dcf": true, "comps": false, "precedents": false, "lbo": false, "summary": true }, "dcf": { "basis": "reported", "groups": null, "bridgePeriod": 2026, "bridge": { "cash": null, "grossDebt": null, "leases": 0, "minority": 0, "pension": 0, "nonOperatingAssets": 0, "investments": 0, "other": 0, "shares": null }, "start": 2026, "end": 2028, "terminalAfter": 2028, "terminalYear": 2028, "valuationDate": "2026-01-01", "convention": "year-end", "stub": true, "taxMode": "unlevered", "otherFCF": {}, "waccSources": { "taxRate": "input", "costDebt": "input", "capital": "input" }, "wacc": { "override": 10, "riskFree": null, "beta": null, "erp": null, "country": 0, "size": 0, "other": 0, "costDebt": null, "taxRate": null, "equityValue": null, "debtValue": null, "debtWeight": null }, "terminal": { "method": "pg", "growth": 2, "multiple": 8, "metric": "ebitda", "fcf": null, "normalize": false, "revenueGrowth": null, "ebitMargin": null, "ebitdaMargin": null, "taxRate": null, "capexRate": null, "daRate": null, "nwcRate": null, "other": 0 }, "sensitivity": { "waccStep": 1, "growthStep": 1, "multipleStep": 1, "steps": 1 } }, "comps": { "basis": "reported", "groups": null, "bridgePeriod": 2026, "bridge": { "cash": null, "grossDebt": null, "leases": 0, "minority": 0, "pension": 0, "nonOperatingAssets": 0, "investments": 0, "other": 0, "shares": null }, "targetPeriod": 2026, "peerPeriod": "LTM", "metric": "ebitda", "statistic": "median", "override": null, "peers": {} }, "precedents": { "basis": "reported", "groups": null, "bridgePeriod": 2026, "bridge": { "cash": null, "grossDebt": null, "leases": 0, "minority": 0, "pension": 0, "nonOperatingAssets": 0, "investments": 0, "other": 0, "shares": null }, "targetPeriod": 2026, "metric": "ebitda", "statistic": "median", "override": null, "synergyAdjusted": false, "transactions": {} }, "lbo": { "basis": "reported", "groups": null, "bridgePeriod": 2026, "bridge": { "cash": null, "grossDebt": null, "leases": 0, "minority": 0, "pension": 0, "nonOperatingAssets": 0, "investments": 0, "other": 0, "shares": null }, "entryYear": 2026, "exitYear": 2028, "entryMode": "multiple", "entryEV": null, "entryEquity": null, "entryMultiple": null, "entryMetric": "ebitda", "exitMultiple": null, "exitMetric": "ebitda", "transactionFeeRate": 0, "transactionFees": null, "financingFeeRate": 0, "financingFees": null, "rollover": 0, "otherUses": 0, "otherSources": 0, "refinanceDebt": null, "minimumCash": 0, "sweep": 100, "exitFees": 0, "exitBridge": { "leases": null, "minority": null, "pension": null, "nonOperatingAssets": null, "investments": null, "other": null }, "managementOwnership": null, "ownershipConvention": "pro-rata-management-dilution", "otherSourcesTreatment": "non-participating", "taxPolicy": { "entryNOL": "inherit", "pikDeductible": true }, "tranches": {}, "distributions": {} }, "summary": { "basis": "ev", "outputs": { "dcf.pg": { "enabled": true, "label": "", "order": 0 }, "dcf.exit": { "enabled": true, "label": "", "order": 1 }, "comps.ebitda": { "enabled": true, "label": "", "order": 2 }, "precedents.ebitda": { "enabled": true, "label": "", "order": 3 } } } }, "tools": { "version": 1, "active": { "model.annual": true, "model.quarterly": false, "model.monthly": false, "model.weekly": false, "value.dcf": true, "value.comps": false, "value.precedents": false, "value.summary": true, "deals.lbo": false } } }, "active": "base", "nextObject": 1, "nextScenario": 1, "nextOverride": 1, "whatIf": { "nextId": 1, "transactions": [] }, "scenarios": [ { "id": "base", "name": "Base", "overrides": [] } ] }, "snapshot": { "version": 4, "calculationVersion": 4, "modelSchemaVersion": 1, "generatedAt": "2026-01-01T00:00:00.000Z", "scenarios": [ { "id": "base", "name": "Base", "currency": "EUR", "moneyScale": 1, "periods": [ { "id": "2026-01-01", "start": "2026-01-01", "end": "2027-01-01", "kind": "forecast", "frequency": "annual", "year": 2026, "months": 12, "days": 365, "durationDays": 365, "yearFraction": 1, "dayCountBasis": "ACT/ACT", "rateBasis": "annualized", "fiscalYear": 2026, "fiscalQuarter": 1, "fiscalStart": "2026-01-01", "fiscalEnd": "2027-01-01", "fiscalYearEnd": { "month": 12, "day": 31 }, "fiscalStartMonth": 1, "label": "2026E" }, { "id": "2027-01-01", "start": "2027-01-01", "end": "2028-01-01", "kind": "forecast", "frequency": "annual", "year": 2027, "months": 12, "days": 365, "durationDays": 365, "yearFraction": 1, "dayCountBasis": "ACT/ACT", "rateBasis": "annualized", "fiscalYear": 2027, "fiscalQuarter": 1, "fiscalStart": "2027-01-01", "fiscalEnd": "2028-01-01", "fiscalYearEnd": { "month": 12, "day": 31 }, "fiscalStartMonth": 1, "label": "2027E" }, { "id": "2028-01-01", "start": "2028-01-01", "end": "2029-01-01", "kind": "forecast", "frequency": "annual", "year": 2028, "months": 12, "days": 366, "durationDays": 366, "yearFraction": 1, "dayCountBasis": "ACT/ACT", "rateBasis": "annualized", "fiscalYear": 2028, "fiscalQuarter": 1, "fiscalStart": "2028-01-01", "fiscalEnd": "2029-01-01", "fiscalYearEnd": { "month": 12, "day": 31 }, "fiscalStartMonth": 1, "label": "2028E" } ], "opening": { "cash": 500000, "ar": 200000, "inventory": 100000, "otherCA": 0, "ppe": 1000000, "otherNCA": 0, "ap": 100000, "otherCL": 0, "revolver": 0, "debt": 500000, "otherNCL": 0, "equity": 1200000, "revenue": 0, "assets": 1800000 }, "breakdown": {}, "statements": { "2026-01-01": { "revenue": 2000000, "growth": null, "grossMargin": 50, "sga": 0, "da": -100000, "taxRate": 25, "capex": 150000, "dso": 0, "dio": 0, "dpo": 0, "debt": 500000, "interestRate": 8, "payout": 0, "cogsAmount": 1000000, "sgaAmount": 200000, "cogs": -1000000, "grossProfit": 1000000, "otherOperatingIncome": 0, "sgaExpense": -200000, "ebitda": 800000, "ebit": 700000, "interest": -40000, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 660000, "tax": -165000, "netIncome": 495000, "ar": 220000, "grossAR": 220000, "impairmentAllowance": 0, "inventory": 120000, "ap": 110000, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": -20000, "changeInventory": -20000, "changeAP": 10000, "changeOtherWC": 0, "daAddback": 100000, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 565000, "capexOut": -150000, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": -150000, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 415000, "cash": 915000, "ppe": 1050000, "otherNCA": 0, "otherNCL": 0, "currentAssets": 1255000, "assets": 2305000, "equity": 1695000, "shareCapital": 0, "retainedEarnings": 1200000, "currentYearNetIncome": 495000, "dividends": 0, "liabilitiesEquity": 2305000, "fcf": 415000, "totalCapex": 150000, "collections": 1980000, "suppliers": -1010000, "operatingPayments": -200000, "interestPaid": -40000, "taxPaid": -165000, "taxExpense": 165000, "cashTax": 165000, "taxPayable": 0, "interestExpense": 40000, "cashInterest": 40000, "interestPayable": 0, "roic": 42.33870967741936, "roe": 34.196891191709845, "roa": 24.116930572472594, "ebitMargin": 35, "ebitdaMargin": 40, "fcfMargin": 20.75, "netDebt": -415000, "leverage": -0.51875, "workingCapital": 1145000, "nwc": 230000, "ccc": 43.79999999999999, "currentRatio": 11.409090909090908, "quickRatio": 10.318181818181818, "beginningCash": 500000, "balanceCheck": 0, "investedCapital": 1280000, "purchases": 1020000 }, "2027-01-01": { "revenue": 2200000, "growth": 10.000000000000009, "grossMargin": 50, "sga": 0, "da": -110000, "taxRate": 25, "capex": 170000, "dso": 0, "dio": 0, "dpo": 0, "debt": 500000, "interestRate": 8, "payout": 0, "cogsAmount": 1100000, "sgaAmount": 220000, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0, "cogs": -1100000, "grossProfit": 1100000, "otherOperatingIncome": 0, "sgaExpense": -220000, "ebitda": 880000, "ebit": 770000, "interest": -40000, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 730000, "tax": -182500, "netIncome": 547500, "ar": 260000, "grossAR": 260000, "impairmentAllowance": 0, "inventory": 140000, "ap": 120000, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": -40000, "changeInventory": -20000, "changeAP": 10000, "changeOtherWC": 0, "daAddback": 110000, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 607500, "capexOut": -170000, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": -170000, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 437500, "cash": 1352500, "ppe": 1110000, "otherNCA": 0, "otherNCL": 0, "currentAssets": 1752500, "assets": 2862500, "equity": 2242500, "shareCapital": 0, "retainedEarnings": 1695000, "currentYearNetIncome": 547500, "dividends": 0, "liabilitiesEquity": 2862500, "fcf": 437500, "totalCapex": 170000, "collections": 2160000, "suppliers": -1110000, "operatingPayments": -220000, "interestPaid": -40000, "taxPaid": -182500, "taxExpense": 182500, "cashTax": 182500, "taxPayable": 0, "interestExpense": 40000, "cashInterest": 40000, "interestPayable": 0, "roic": 43.258426966292134, "roe": 27.80952380952381, "roa": 21.190130624092888, "ebitMargin": 35, "ebitdaMargin": 40, "fcfMargin": 19.886363636363637, "netDebt": -852500, "leverage": -0.96875, "workingCapital": 1632500, "nwc": 280000, "ccc": 49.77272727272728, "currentRatio": 14.604166666666666, "quickRatio": 13.4375, "beginningCash": 915000, "balanceCheck": 0, "investedCapital": 1390000, "purchases": 1120000 }, "2028-01-01": { "revenue": 2400000, "growth": 9.090909090909083, "grossMargin": 50, "sga": 0, "da": -120000, "taxRate": 25, "capex": 190000, "dso": 0, "dio": 0, "dpo": 0, "debt": 500000, "interestRate": 8, "payout": 0, "cogsAmount": 1200000, "sgaAmount": 240000, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0, "cogs": -1200000, "grossProfit": 1200000, "otherOperatingIncome": 0, "sgaExpense": -240000, "ebitda": 960000, "ebit": 840000, "interest": -40000, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 800000, "tax": -200000, "netIncome": 600000, "ar": 300000, "grossAR": 300000, "impairmentAllowance": 0, "inventory": 160000, "ap": 130000, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": -40000, "changeInventory": -20000, "changeAP": 10000, "changeOtherWC": 0, "daAddback": 120000, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 670000, "capexOut": -190000, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": -190000, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 480000, "cash": 1832500, "ppe": 1180000, "otherNCA": 0, "otherNCL": 0, "currentAssets": 2292500, "assets": 3472500, "equity": 2842500, "shareCapital": 0, "retainedEarnings": 2242500, "currentYearNetIncome": 600000, "dividends": 0, "liabilitiesEquity": 3472500, "fcf": 480000, "totalCapex": 190000, "collections": 2360000, "suppliers": -1210000, "operatingPayments": -240000, "interestPaid": -40000, "taxPaid": -200000, "taxExpense": 200000, "cashTax": 200000, "taxPayable": 0, "interestExpense": 40000, "cashInterest": 40000, "interestPayable": 0, "roic": 43.44827586206896, "roe": 23.59882005899705, "roa": 18.94238358326756, "ebitMargin": 35, "ebitdaMargin": 40, "fcfMargin": 20, "netDebt": -1332500, "leverage": -1.3880208333333333, "workingCapital": 2162500, "nwc": 330000, "ccc": 54.749999999999986, "currentRatio": 17.634615384615383, "quickRatio": 16.403846153846153, "beginningCash": 1352500, "balanceCheck": 0, "investedCapital": 1510000, "purchases": 1220000 } }, "statementUnits": { "revenue": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "growth": { "unit": "percent", "kind": "rate", "sign": "signed", "aggregation": "weighted" }, "grossMargin": { "unit": "percent", "kind": "ratio", "sign": "signed", "aggregation": "recompute" }, "sga": { "unit": "percent", "kind": "rate", "sign": "signed", "aggregation": "weighted" }, "da": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "expense-negative", "aggregation": "sum" }, "taxRate": { "unit": "percent", "kind": "rate", "sign": "signed", "aggregation": "weighted" }, "capex": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "dso": { "unit": "days", "kind": "ratio", "sign": "signed", "aggregation": "recompute" }, "dio": { "unit": "days", "kind": "ratio", "sign": "signed", "aggregation": "recompute" }, "dpo": { "unit": "days", "kind": "ratio", "sign": "signed", "aggregation": "recompute" }, "debt": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "interestRate": { "unit": "percent", "kind": "rate", "sign": "signed", "aggregation": "weighted" }, "payout": { "unit": "percent", "kind": "rate", "sign": "signed", "aggregation": "weighted" }, "cogsAmount": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "sgaAmount": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "cogs": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "expense-negative", "aggregation": "sum" }, "grossProfit": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "otherOperatingIncome": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "sgaExpense": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "expense-negative", "aggregation": "sum" }, "ebitda": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "ebit": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "interest": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "expense-negative", "aggregation": "sum" }, "interestIncome": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "impairment": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "expense-negative", "aggregation": "sum" }, "otherOperatingExpense": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "expense-negative", "aggregation": "sum" }, "manualOtherNonCashExpense": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "expense-negative", "aggregation": "sum" }, "ebt": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "tax": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "expense-negative", "aggregation": "sum" }, "netIncome": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "ar": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "grossAR": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "impairmentAllowance": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "inventory": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "ap": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "otherCA": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "otherCL": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "nonCashProvision": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "changeAR": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "changeInventory": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "changeAP": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "changeOtherWC": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "daAddback": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "otherNonCash": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "operatingNonCash": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "nonOperatingReclassification": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "cfo": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "capexOut": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "expense-negative", "aggregation": "sum" }, "disposalProceeds": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "otherOperatingCF": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "otherInvestingCF": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "otherFinancingCF": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "cfi": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "debtIssued": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "debtRepaid": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "revolver": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "fundingChange": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "dividendsOut": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "expense-negative", "aggregation": "sum" }, "cff": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "cashChange": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "cash": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "ppe": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "otherNCA": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "otherNCL": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "currentAssets": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "assets": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "equity": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "shareCapital": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "retainedEarnings": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "currentYearNetIncome": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "dividends": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "liabilitiesEquity": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "fcf": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "totalCapex": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "collections": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "suppliers": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "operatingPayments": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "interestPaid": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "taxPaid": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "taxExpense": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "cashTax": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "taxPayable": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "interestExpense": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "cashInterest": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "interestPayable": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "roic": { "unit": "percent", "kind": "ratio", "sign": "signed", "aggregation": "recompute" }, "roe": { "unit": "percent", "kind": "ratio", "sign": "signed", "aggregation": "recompute" }, "roa": { "unit": "percent", "kind": "ratio", "sign": "signed", "aggregation": "recompute" }, "ebitMargin": { "unit": "percent", "kind": "ratio", "sign": "signed", "aggregation": "recompute" }, "ebitdaMargin": { "unit": "percent", "kind": "ratio", "sign": "signed", "aggregation": "recompute" }, "fcfMargin": { "unit": "percent", "kind": "ratio", "sign": "signed", "aggregation": "recompute" }, "netDebt": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "leverage": { "unit": "multiple", "kind": "multiple", "sign": "signed", "aggregation": "recompute" }, "workingCapital": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "nwc": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "ccc": { "unit": "days", "kind": "ratio", "sign": "signed", "aggregation": "recompute" }, "currentRatio": { "unit": "multiple", "kind": "multiple", "sign": "signed", "aggregation": "recompute" }, "quickRatio": { "unit": "multiple", "kind": "multiple", "sign": "signed", "aggregation": "recompute" }, "beginningCash": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "first" }, "balanceCheck": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "investedCapital": { "unit": "currency", "scale": 1, "kind": "stock", "sign": "signed", "aggregation": "last" }, "purchases": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "arAdjustment": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "inventoryAdjustment": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "extraDividend": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "equipmentPurchase": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "extraDA": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "scenarioBorrowing": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "scenarioRepayment": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" } }, "objects": [], "adjusted": { "basis": "adjusted", "groups": [], "statements": { "2026-01-01": { "revenue": 2000000, "growth": null, "grossMargin": 50, "sga": 0, "da": -100000, "taxRate": 25, "capex": 150000, "dso": 0, "dio": 0, "dpo": 0, "debt": 500000, "interestRate": 8, "payout": 0, "cogsAmount": 1000000, "sgaAmount": 200000, "cogs": -1000000, "grossProfit": 1000000, "otherOperatingIncome": 0, "sgaExpense": -200000, "ebitda": 800000, "ebit": 700000, "interest": -40000, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 660000, "tax": -165000, "netIncome": 495000, "ar": 220000, "grossAR": 220000, "impairmentAllowance": 0, "inventory": 120000, "ap": 110000, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": -20000, "changeInventory": -20000, "changeAP": 10000, "changeOtherWC": 0, "daAddback": 100000, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 565000, "capexOut": -150000, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": -150000, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 415000, "cash": 915000, "ppe": 1050000, "otherNCA": 0, "otherNCL": 0, "currentAssets": 1255000, "assets": 2305000, "equity": 1695000, "shareCapital": 0, "retainedEarnings": 1200000, "currentYearNetIncome": 495000, "dividends": 0, "liabilitiesEquity": 2305000, "fcf": 415000, "totalCapex": 150000, "collections": 1980000, "suppliers": -1010000, "operatingPayments": -200000, "interestPaid": -40000, "taxPaid": -165000, "taxExpense": 165000, "cashTax": 165000, "taxPayable": 0, "interestExpense": 40000, "cashInterest": 40000, "interestPayable": 0, "roic": 42.33870967741936, "roe": 34.196891191709845, "roa": 24.116930572472594, "ebitMargin": 35, "ebitdaMargin": 40, "fcfMargin": 20.75, "netDebt": -415000, "leverage": -0.51875, "workingCapital": 1145000, "nwc": 230000, "ccc": 43.79999999999999, "currentRatio": 11.409090909090908, "quickRatio": 10.318181818181818, "beginningCash": 500000, "balanceCheck": 0, "investedCapital": 1280000, "purchases": 1020000 }, "2027-01-01": { "revenue": 2200000, "growth": 10.000000000000009, "grossMargin": 50, "sga": 0, "da": -110000, "taxRate": 25, "capex": 170000, "dso": 0, "dio": 0, "dpo": 0, "debt": 500000, "interestRate": 8, "payout": 0, "cogsAmount": 1100000, "sgaAmount": 220000, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0, "cogs": -1100000, "grossProfit": 1100000, "otherOperatingIncome": 0, "sgaExpense": -220000, "ebitda": 880000, "ebit": 770000, "interest": -40000, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 730000, "tax": -182500, "netIncome": 547500, "ar": 260000, "grossAR": 260000, "impairmentAllowance": 0, "inventory": 140000, "ap": 120000, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": -40000, "changeInventory": -20000, "changeAP": 10000, "changeOtherWC": 0, "daAddback": 110000, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 607500, "capexOut": -170000, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": -170000, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 437500, "cash": 1352500, "ppe": 1110000, "otherNCA": 0, "otherNCL": 0, "currentAssets": 1752500, "assets": 2862500, "equity": 2242500, "shareCapital": 0, "retainedEarnings": 1695000, "currentYearNetIncome": 547500, "dividends": 0, "liabilitiesEquity": 2862500, "fcf": 437500, "totalCapex": 170000, "collections": 2160000, "suppliers": -1110000, "operatingPayments": -220000, "interestPaid": -40000, "taxPaid": -182500, "taxExpense": 182500, "cashTax": 182500, "taxPayable": 0, "interestExpense": 40000, "cashInterest": 40000, "interestPayable": 0, "roic": 43.258426966292134, "roe": 27.80952380952381, "roa": 21.190130624092888, "ebitMargin": 35, "ebitdaMargin": 40, "fcfMargin": 19.886363636363637, "netDebt": -852500, "leverage": -0.96875, "workingCapital": 1632500, "nwc": 280000, "ccc": 49.77272727272728, "currentRatio": 14.604166666666666, "quickRatio": 13.4375, "beginningCash": 915000, "balanceCheck": 0, "investedCapital": 1390000, "purchases": 1120000 }, "2028-01-01": { "revenue": 2400000, "growth": 9.090909090909083, "grossMargin": 50, "sga": 0, "da": -120000, "taxRate": 25, "capex": 190000, "dso": 0, "dio": 0, "dpo": 0, "debt": 500000, "interestRate": 8, "payout": 0, "cogsAmount": 1200000, "sgaAmount": 240000, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0, "cogs": -1200000, "grossProfit": 1200000, "otherOperatingIncome": 0, "sgaExpense": -240000, "ebitda": 960000, "ebit": 840000, "interest": -40000, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 800000, "tax": -200000, "netIncome": 600000, "ar": 300000, "grossAR": 300000, "impairmentAllowance": 0, "inventory": 160000, "ap": 130000, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": -40000, "changeInventory": -20000, "changeAP": 10000, "changeOtherWC": 0, "daAddback": 120000, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 670000, "capexOut": -190000, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": -190000, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 480000, "cash": 1832500, "ppe": 1180000, "otherNCA": 0, "otherNCL": 0, "currentAssets": 2292500, "assets": 3472500, "equity": 2842500, "shareCapital": 0, "retainedEarnings": 2242500, "currentYearNetIncome": 600000, "dividends": 0, "liabilitiesEquity": 3472500, "fcf": 480000, "totalCapex": 190000, "collections": 2360000, "suppliers": -1210000, "operatingPayments": -240000, "interestPaid": -40000, "taxPaid": -200000, "taxExpense": 200000, "cashTax": 200000, "taxPayable": 0, "interestExpense": 40000, "cashInterest": 40000, "interestPayable": 0, "roic": 43.44827586206896, "roe": 23.59882005899705, "roa": 18.94238358326756, "ebitMargin": 35, "ebitdaMargin": 40, "fcfMargin": 20, "netDebt": -1332500, "leverage": -1.3880208333333333, "workingCapital": 2162500, "nwc": 330000, "ccc": 54.749999999999986, "currentRatio": 17.634615384615383, "quickRatio": 16.403846153846153, "beginningCash": 1352500, "balanceCheck": 0, "investedCapital": 1510000, "purchases": 1220000 } } }, "analysis": { "outputs": { "valuation.dcf.pg.ev": { "value": 6059504.132231403, "unit": "currency", "dependencies": [ "dcf.assumptions", "model.periods", "adjustments.groups" ] }, "valuation.dcf.pg.equity": { "value": 6474504.132231403, "unit": "currency", "dependencies": [ "dcf.assumptions", "model.periods", "adjustments.groups" ] }, "valuation.dcf.pg.perShare": { "value": null, "unit": "currency/share", "dependencies": [ "dcf.assumptions", "model.periods", "adjustments.groups" ] }, "valuation.dcf.exit.ev": { "value": 6944177.310293011, "unit": "currency", "dependencies": [ "dcf.assumptions", "model.periods", "adjustments.groups" ] }, "valuation.dcf.exit.equity": { "value": 7359177.310293011, "unit": "currency", "dependencies": [ "dcf.assumptions", "model.periods", "adjustments.groups" ] }, "valuation.dcf.exit.perShare": { "value": null, "unit": "currency/share", "dependencies": [ "dcf.assumptions", "model.periods", "adjustments.groups" ] }, "valuation.lbo.irr": { "value": null, "unit": "percent", "dependencies": [ "lbo.assumptions", "model.periods", "adjustments.groups" ] }, "valuation.lbo.moic": { "value": null, "unit": "multiple", "dependencies": [ "lbo.assumptions", "model.periods", "adjustments.groups" ] }, "valuation.lbo.sponsor": { "value": null, "unit": "currency", "dependencies": [ "lbo.assumptions", "model.periods", "adjustments.groups" ] }, "valuation.lbo.proceeds": { "value": null, "unit": "currency", "dependencies": [ "lbo.assumptions", "model.periods", "adjustments.groups" ] }, "valuation.lbo.entryEV": { "value": null, "unit": "currency", "dependencies": [ "lbo.assumptions", "model.periods", "adjustments.groups" ] }, "valuation.lbo.exitEV": { "value": null, "unit": "currency", "dependencies": [ "lbo.assumptions", "model.periods", "adjustments.groups" ] } }, "operators": { "dcf": { "domain": "value", "basis": "reported", "groups": null, "error": null, "outputs": [ { "id": "dcf.pg", "label": "DCF – Perpetuity growth", "low": { "ev": 4919608.797987175, "equity": 5334608.797987175, "perShare": null, "adjustment": 415000, "items": { "cash": 915000, "grossDebt": 500000, "leases": 0, "minority": 0, "pension": 0, "nonOperatingAssets": 0, "investments": 0, "other": 0, "shares": null } }, "mid": { "ev": 6059504.132231403, "equity": 6474504.132231403, "perShare": null, "adjustment": 415000, "items": { "cash": 915000, "grossDebt": 500000, "leases": 0, "minority": 0, "pension": 0, "nonOperatingAssets": 0, "investments": 0, "other": 0, "shares": null } }, "high": { "ev": 7956022.220351821, "equity": 8371022.220351821, "perShare": null, "adjustment": 415000, "items": { "cash": 915000, "grossDebt": 500000, "leases": 0, "minority": 0, "pension": 0, "nonOperatingAssets": 0, "investments": 0, "other": 0, "shares": null } }, "dependencies": [ "dcf.assumptions", "model.periods", "adjustments.groups" ] }, { "id": "dcf.exit", "label": "DCF – Exit multiple", "low": { "ev": 6066848.075248366, "equity": 6481848.075248366, "perShare": null, "adjustment": 415000, "items": { "cash": 915000, "grossDebt": 500000, "leases": 0, "minority": 0, "pension": 0, "nonOperatingAssets": 0, "investments": 0, "other": 0, "shares": null } }, "mid": { "ev": 6944177.310293011, "equity": 7359177.310293011, "perShare": null, "adjustment": 415000, "items": { "cash": 915000, "grossDebt": 500000, "leases": 0, "minority": 0, "pension": 0, "nonOperatingAssets": 0, "investments": 0, "other": 0, "shares": null } }, "high": { "ev": 7867221.120144798, "equity": 8282221.120144798, "perShare": null, "adjustment": 415000, "items": { "cash": 915000, "grossDebt": 500000, "leases": 0, "minority": 0, "pension": 0, "nonOperatingAssets": 0, "investments": 0, "other": 0, "shares": null } }, "dependencies": [ "dcf.assumptions", "model.periods", "adjustments.groups" ] } ], "rows": [ { "year": 2026, "ebit": 700000, "taxes": 175000, "nopat": 525000, "da": 100000, "capex": 150000, "changeNWC": 30000, "other": 0, "fcff": 445000, "stub": 1, "time": 1, "discountFactor": 0.9090909090909091, "cashFlow": 445000, "pv": 404545.45454545453 }, { "year": 2027, "ebit": 770000, "taxes": 192500, "nopat": 577500, "da": 110000, "capex": 170000, "changeNWC": 50000, "other": 0, "fcff": 467500, "stub": 1, "time": 2, "discountFactor": 0.8264462809917354, "cashFlow": 467500, "pv": 386363.6363636363 }, { "year": 2028, "ebit": 840000, "taxes": 210000, "nopat": 630000, "da": 120000, "capex": 190000, "changeNWC": 50000, "other": 0, "fcff": 510000, "stub": 1, "time": 3, "discountFactor": 0.7513148009015775, "cashFlow": 510000, "pv": 383170.54845980456 } ], "values": { "terminalMetric": 960000, "pvFCFF": 1174079.6393688954, "pgTV": 6502500, "exitTV": 7680000, "terminalTime": 3, "impliedMultiple": 6.7734375, "impliedGrowth": 3.15018315018315 } } }, "summary": { "basis": "ev", "rows": [ { "id": "dcf.pg", "label": "DCF – Perpetuity growth", "low": 4919608.797987175, "mid": 6059504.132231403, "high": 7956022.220351821, "available": true }, { "id": "dcf.exit", "label": "DCF – Exit multiple", "low": 6066848.075248366, "mid": 6944177.310293011, "high": 7867221.120144798, "available": true } ] } }, "tools": { "version": 1, "active": { "model.annual": true, "model.quarterly": false, "model.monthly": false, "model.weekly": false, "value.dcf": true, "value.comps": false, "value.precedents": false, "value.summary": true, "deals.lbo": false } }, "resolution": { "version": 1, "branches": {} } } ] } }