{ "fileType": "BalanceCheat.Model", "formatVersion": 4, "modelSchemaVersion": 1, "calculationVersion": 4, "metadata": { "id": "synthetic-price-volume-forecast", "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": 0, "ar": 0, "inventory": 0, "otherCA": 0, "ppe": 0, "otherNCA": 0, "ap": 0, "otherCL": 0, "revolver": 0, "debt": 0, "otherNCL": 0, "equity": 0, "revenue": 0, "assets": 0 }, "years": [ { "revenue": 0, "growth": 0, "grossMargin": 0, "sga": 0, "da": 0, "taxRate": 0, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 0, "interestRate": 0, "payout": 0, "cogsAmount": 0, "sgaAmount": 0 }, { "revenue": null, "growth": 0, "grossMargin": 0, "sga": 0, "da": 0, "taxRate": 0, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 0, "interestRate": 0, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0 }, { "revenue": null, "growth": 0, "grossMargin": 0, "sga": 0, "da": 0, "taxRate": 0, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 0, "interestRate": 0, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0 }, { "revenue": null, "growth": 0, "grossMargin": 0, "sga": 0, "da": 0, "taxRate": 0, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 0, "interestRate": 0, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "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": {} }, "objects": [ { "id": "obj-1", "entityId": "entity-1", "instrumentId": null, "name": "Business Line A", "description": "", "group": "revenue", "kind": "driver", "unit": "EUR", "active": true, "base": 0, "periods": { "2026-01-01": { "method": "priceVolume", "price": 100, "volume": 4000 }, "2027-01-01": { "method": "priceVolume", "price": 100, "volume": 4400 }, "2028-01-01": { "method": "priceVolume", "price": 110, "volume": 4400 }, "2029-01-01": { "method": "priceVolume", "price": 115, "volume": 4800 } }, "events": [], "source": "user", "rule": null }, { "id": "obj-2", "entityId": "entity-1", "instrumentId": null, "name": "Business Line A direct costs", "description": "", "group": "cogs", "kind": "driver", "unit": "EUR", "active": true, "base": 0, "periods": { "2026-01-01": { "method": "priceVolume", "price": 50, "volume": { "ref": "obj-1:volume" } }, "2027-01-01": { "method": "priceVolume", "price": 50, "volume": { "ref": "obj-1:volume" } }, "2028-01-01": { "method": "priceVolume", "price": 50, "volume": { "ref": "obj-1:volume" } }, "2029-01-01": { "method": "priceVolume", "price": 50, "volume": { "ref": "obj-1:volume" } } }, "events": [], "source": "user", "rule": null } ], "authority": { "revenue": "detail", "cogs": "detail" }, "nextId": 3, "display": { "currency": "EUR", "fx": 1, "units": 1000 }, "notes": {} }, "active": "base", "nextObject": 3, "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" }, { "id": "2029-01-01", "start": "2029-01-01", "end": "2030-01-01", "kind": "forecast", "frequency": "annual", "year": 2029, "months": 12, "days": 365, "durationDays": 365, "yearFraction": 1, "dayCountBasis": "ACT/ACT", "rateBasis": "annualized", "fiscalYear": 2029, "fiscalQuarter": 1, "fiscalStart": "2029-01-01", "fiscalEnd": "2030-01-01", "fiscalYearEnd": { "month": 12, "day": 31 }, "fiscalStartMonth": 1, "label": "2029E" } ], "opening": { "cash": 0, "ar": 0, "inventory": 0, "otherCA": 0, "ppe": 0, "otherNCA": 0, "ap": 0, "otherCL": 0, "revolver": 0, "debt": 0, "otherNCL": 0, "equity": 0, "revenue": 0, "assets": 0 }, "breakdown": {}, "statements": { "2026-01-01": { "revenue": 400000, "growth": null, "grossMargin": 50, "sga": 0, "da": 0, "taxRate": 0, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 0, "interestRate": 0, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "cogs": -200000, "grossProfit": 200000, "otherOperatingIncome": 0, "sgaExpense": 0, "ebitda": 200000, "ebit": 200000, "interest": 0, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 200000, "tax": 0, "netIncome": 200000, "ar": 0, "grossAR": 0, "impairmentAllowance": 0, "inventory": 0, "ap": 0, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": 0, "changeInventory": 0, "changeAP": 0, "changeOtherWC": 0, "daAddback": 0, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 200000, "capexOut": 0, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": 0, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 200000, "cash": 200000, "ppe": 0, "otherNCA": 0, "otherNCL": 0, "currentAssets": 200000, "assets": 200000, "equity": 200000, "shareCapital": 0, "retainedEarnings": 0, "currentYearNetIncome": 200000, "dividends": 0, "liabilitiesEquity": 200000, "fcf": 200000, "totalCapex": 0, "collections": 400000, "suppliers": -200000, "operatingPayments": 0, "interestPaid": 0, "taxPaid": 0, "taxExpense": 0, "cashTax": 0, "taxPayable": 0, "interestExpense": 0, "cashInterest": 0, "interestPayable": 0, "roic": null, "roe": 200, "roa": 200, "ebitMargin": 50, "ebitdaMargin": 50, "fcfMargin": 50, "netDebt": -200000, "leverage": -1, "workingCapital": 200000, "nwc": 0, "ccc": 0, "currentRatio": null, "quickRatio": null, "beginningCash": 0, "balanceCheck": 0, "investedCapital": 0, "purchases": 200000, "equityIssued": 0, "buybacksOut": 0 }, "2027-01-01": { "revenue": 440000, "growth": 10.000000000000009, "grossMargin": 50, "sga": 0, "da": 0, "taxRate": 0, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 0, "interestRate": 0, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0, "cogs": -220000, "grossProfit": 220000, "otherOperatingIncome": 0, "sgaExpense": 0, "ebitda": 220000, "ebit": 220000, "interest": 0, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 220000, "tax": 0, "netIncome": 220000, "ar": 0, "grossAR": 0, "impairmentAllowance": 0, "inventory": 0, "ap": 0, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": 0, "changeInventory": 0, "changeAP": 0, "changeOtherWC": 0, "daAddback": 0, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 220000, "capexOut": 0, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": 0, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 220000, "cash": 420000, "ppe": 0, "otherNCA": 0, "otherNCL": 0, "currentAssets": 420000, "assets": 420000, "equity": 420000, "shareCapital": 0, "retainedEarnings": 200000, "currentYearNetIncome": 220000, "dividends": 0, "liabilitiesEquity": 420000, "fcf": 220000, "totalCapex": 0, "collections": 440000, "suppliers": -220000, "operatingPayments": 0, "interestPaid": 0, "taxPaid": 0, "taxExpense": 0, "cashTax": 0, "taxPayable": 0, "interestExpense": 0, "cashInterest": 0, "interestPayable": 0, "roic": null, "roe": 70.96774193548387, "roa": 70.96774193548387, "ebitMargin": 50, "ebitdaMargin": 50, "fcfMargin": 50, "netDebt": -420000, "leverage": -1.9090909090909092, "workingCapital": 420000, "nwc": 0, "ccc": 0, "currentRatio": null, "quickRatio": null, "beginningCash": 200000, "balanceCheck": 0, "investedCapital": 0, "purchases": 220000, "equityIssued": 0, "buybacksOut": 0 }, "2028-01-01": { "revenue": 484000, "growth": 10.000000000000009, "grossMargin": 54.54545454545454, "sga": 0, "da": 0, "taxRate": 0, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 0, "interestRate": 0, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0, "cogs": -220000, "grossProfit": 264000, "otherOperatingIncome": 0, "sgaExpense": 0, "ebitda": 264000, "ebit": 264000, "interest": 0, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 264000, "tax": 0, "netIncome": 264000, "ar": 0, "grossAR": 0, "impairmentAllowance": 0, "inventory": 0, "ap": 0, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": 0, "changeInventory": 0, "changeAP": 0, "changeOtherWC": 0, "daAddback": 0, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 264000, "capexOut": 0, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": 0, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 264000, "cash": 684000, "ppe": 0, "otherNCA": 0, "otherNCL": 0, "currentAssets": 684000, "assets": 684000, "equity": 684000, "shareCapital": 0, "retainedEarnings": 420000, "currentYearNetIncome": 264000, "dividends": 0, "liabilitiesEquity": 684000, "fcf": 264000, "totalCapex": 0, "collections": 484000, "suppliers": -220000, "operatingPayments": 0, "interestPaid": 0, "taxPaid": 0, "taxExpense": 0, "cashTax": 0, "taxPayable": 0, "interestExpense": 0, "cashInterest": 0, "interestPayable": 0, "roic": null, "roe": 47.82608695652174, "roa": 47.82608695652174, "ebitMargin": 54.54545454545454, "ebitdaMargin": 54.54545454545454, "fcfMargin": 54.54545454545454, "netDebt": -684000, "leverage": -2.590909090909091, "workingCapital": 684000, "nwc": 0, "ccc": 0, "currentRatio": null, "quickRatio": null, "beginningCash": 420000, "balanceCheck": 0, "investedCapital": 0, "purchases": 220000, "equityIssued": 0, "buybacksOut": 0 }, "2029-01-01": { "revenue": 552000, "growth": 14.049586776859503, "grossMargin": 56.52173913043478, "sga": 0, "da": 0, "taxRate": 0, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 0, "interestRate": 0, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0, "cogs": -240000, "grossProfit": 312000, "otherOperatingIncome": 0, "sgaExpense": 0, "ebitda": 312000, "ebit": 312000, "interest": 0, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 312000, "tax": 0, "netIncome": 312000, "ar": 0, "grossAR": 0, "impairmentAllowance": 0, "inventory": 0, "ap": 0, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": 0, "changeInventory": 0, "changeAP": 0, "changeOtherWC": 0, "daAddback": 0, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 312000, "capexOut": 0, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": 0, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 312000, "cash": 996000, "ppe": 0, "otherNCA": 0, "otherNCL": 0, "currentAssets": 996000, "assets": 996000, "equity": 996000, "shareCapital": 0, "retainedEarnings": 684000, "currentYearNetIncome": 312000, "dividends": 0, "liabilitiesEquity": 996000, "fcf": 312000, "totalCapex": 0, "collections": 552000, "suppliers": -240000, "operatingPayments": 0, "interestPaid": 0, "taxPaid": 0, "taxExpense": 0, "cashTax": 0, "taxPayable": 0, "interestExpense": 0, "cashInterest": 0, "interestPayable": 0, "roic": null, "roe": 37.142857142857146, "roa": 37.142857142857146, "ebitMargin": 56.52173913043478, "ebitdaMargin": 56.52173913043478, "fcfMargin": 56.52173913043478, "netDebt": -996000, "leverage": -3.1923076923076925, "workingCapital": 996000, "nwc": 0, "ccc": 0, "currentRatio": null, "quickRatio": null, "beginningCash": 684000, "balanceCheck": 0, "investedCapital": 0, "purchases": 240000, "equityIssued": 0, "buybacksOut": 0 } }, "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" }, "equityIssued": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "signed", "aggregation": "sum" }, "buybacksOut": { "unit": "currency", "scale": 1, "kind": "flow", "sign": "expense-negative", "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": [ { "id": "obj-1", "name": "Business Line A", "group": "revenue", "kind": "driver", "active": true, "periods": { "2026-01-01": { "values": { "value": 400000, "driverValue": 400000, "operatingFactor": 1 }, "units": { "value": { "unit": "currency", "scale": 1 }, "driverValue": { "unit": "currency", "scale": 1 }, "operatingFactor": { "unit": "fraction" } } }, "2027-01-01": { "values": { "value": 440000, "driverValue": 440000, "operatingFactor": 1 }, "units": { "value": { "unit": "currency", "scale": 1 }, "driverValue": { "unit": "currency", "scale": 1 }, "operatingFactor": { "unit": "fraction" } } }, "2028-01-01": { "values": { "value": 484000, "driverValue": 484000, "operatingFactor": 1 }, "units": { "value": { "unit": "currency", "scale": 1 }, "driverValue": { "unit": "currency", "scale": 1 }, "operatingFactor": { "unit": "fraction" } } }, "2029-01-01": { "values": { "value": 552000, "driverValue": 552000, "operatingFactor": 1 }, "units": { "value": { "unit": "currency", "scale": 1 }, "driverValue": { "unit": "currency", "scale": 1 }, "operatingFactor": { "unit": "fraction" } } } } }, { "id": "obj-2", "name": "Business Line A direct costs", "group": "cogs", "kind": "driver", "active": true, "periods": { "2026-01-01": { "values": { "value": 200000, "driverValue": 200000, "operatingFactor": 1 }, "units": { "value": { "unit": "currency", "scale": 1 }, "driverValue": { "unit": "currency", "scale": 1 }, "operatingFactor": { "unit": "fraction" } } }, "2027-01-01": { "values": { "value": 220000, "driverValue": 220000, "operatingFactor": 1 }, "units": { "value": { "unit": "currency", "scale": 1 }, "driverValue": { "unit": "currency", "scale": 1 }, "operatingFactor": { "unit": "fraction" } } }, "2028-01-01": { "values": { "value": 220000, "driverValue": 220000, "operatingFactor": 1 }, "units": { "value": { "unit": "currency", "scale": 1 }, "driverValue": { "unit": "currency", "scale": 1 }, "operatingFactor": { "unit": "fraction" } } }, "2029-01-01": { "values": { "value": 240000, "driverValue": 240000, "operatingFactor": 1 }, "units": { "value": { "unit": "currency", "scale": 1 }, "driverValue": { "unit": "currency", "scale": 1 }, "operatingFactor": { "unit": "fraction" } } } } } ], "adjusted": { "basis": "adjusted", "groups": [], "statements": { "2026-01-01": { "revenue": 400000, "growth": null, "grossMargin": 50, "sga": 0, "da": 0, "taxRate": 0, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 0, "interestRate": 0, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "cogs": -200000, "grossProfit": 200000, "otherOperatingIncome": 0, "sgaExpense": 0, "ebitda": 200000, "ebit": 200000, "interest": 0, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 200000, "tax": 0, "netIncome": 200000, "ar": 0, "grossAR": 0, "impairmentAllowance": 0, "inventory": 0, "ap": 0, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": 0, "changeInventory": 0, "changeAP": 0, "changeOtherWC": 0, "daAddback": 0, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 200000, "capexOut": 0, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": 0, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 200000, "cash": 200000, "ppe": 0, "otherNCA": 0, "otherNCL": 0, "currentAssets": 200000, "assets": 200000, "equity": 200000, "shareCapital": 0, "retainedEarnings": 0, "currentYearNetIncome": 200000, "dividends": 0, "liabilitiesEquity": 200000, "fcf": 200000, "totalCapex": 0, "collections": 400000, "suppliers": -200000, "operatingPayments": 0, "interestPaid": 0, "taxPaid": 0, "taxExpense": 0, "cashTax": 0, "taxPayable": 0, "interestExpense": 0, "cashInterest": 0, "interestPayable": 0, "roic": null, "roe": 200, "roa": 200, "ebitMargin": 50, "ebitdaMargin": 50, "fcfMargin": 50, "netDebt": -200000, "leverage": -1, "workingCapital": 200000, "nwc": 0, "ccc": 0, "currentRatio": null, "quickRatio": null, "beginningCash": 0, "balanceCheck": 0, "investedCapital": 0, "purchases": 200000, "equityIssued": 0, "buybacksOut": 0 }, "2027-01-01": { "revenue": 440000, "growth": 10.000000000000009, "grossMargin": 50, "sga": 0, "da": 0, "taxRate": 0, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 0, "interestRate": 0, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0, "cogs": -220000, "grossProfit": 220000, "otherOperatingIncome": 0, "sgaExpense": 0, "ebitda": 220000, "ebit": 220000, "interest": 0, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 220000, "tax": 0, "netIncome": 220000, "ar": 0, "grossAR": 0, "impairmentAllowance": 0, "inventory": 0, "ap": 0, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": 0, "changeInventory": 0, "changeAP": 0, "changeOtherWC": 0, "daAddback": 0, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 220000, "capexOut": 0, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": 0, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 220000, "cash": 420000, "ppe": 0, "otherNCA": 0, "otherNCL": 0, "currentAssets": 420000, "assets": 420000, "equity": 420000, "shareCapital": 0, "retainedEarnings": 200000, "currentYearNetIncome": 220000, "dividends": 0, "liabilitiesEquity": 420000, "fcf": 220000, "totalCapex": 0, "collections": 440000, "suppliers": -220000, "operatingPayments": 0, "interestPaid": 0, "taxPaid": 0, "taxExpense": 0, "cashTax": 0, "taxPayable": 0, "interestExpense": 0, "cashInterest": 0, "interestPayable": 0, "roic": null, "roe": 70.96774193548387, "roa": 70.96774193548387, "ebitMargin": 50, "ebitdaMargin": 50, "fcfMargin": 50, "netDebt": -420000, "leverage": -1.9090909090909092, "workingCapital": 420000, "nwc": 0, "ccc": 0, "currentRatio": null, "quickRatio": null, "beginningCash": 200000, "balanceCheck": 0, "investedCapital": 0, "purchases": 220000, "equityIssued": 0, "buybacksOut": 0 }, "2028-01-01": { "revenue": 484000, "growth": 10.000000000000009, "grossMargin": 54.54545454545454, "sga": 0, "da": 0, "taxRate": 0, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 0, "interestRate": 0, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0, "cogs": -220000, "grossProfit": 264000, "otherOperatingIncome": 0, "sgaExpense": 0, "ebitda": 264000, "ebit": 264000, "interest": 0, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 264000, "tax": 0, "netIncome": 264000, "ar": 0, "grossAR": 0, "impairmentAllowance": 0, "inventory": 0, "ap": 0, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": 0, "changeInventory": 0, "changeAP": 0, "changeOtherWC": 0, "daAddback": 0, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 264000, "capexOut": 0, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": 0, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 264000, "cash": 684000, "ppe": 0, "otherNCA": 0, "otherNCL": 0, "currentAssets": 684000, "assets": 684000, "equity": 684000, "shareCapital": 0, "retainedEarnings": 420000, "currentYearNetIncome": 264000, "dividends": 0, "liabilitiesEquity": 684000, "fcf": 264000, "totalCapex": 0, "collections": 484000, "suppliers": -220000, "operatingPayments": 0, "interestPaid": 0, "taxPaid": 0, "taxExpense": 0, "cashTax": 0, "taxPayable": 0, "interestExpense": 0, "cashInterest": 0, "interestPayable": 0, "roic": null, "roe": 47.82608695652174, "roa": 47.82608695652174, "ebitMargin": 54.54545454545454, "ebitdaMargin": 54.54545454545454, "fcfMargin": 54.54545454545454, "netDebt": -684000, "leverage": -2.590909090909091, "workingCapital": 684000, "nwc": 0, "ccc": 0, "currentRatio": null, "quickRatio": null, "beginningCash": 420000, "balanceCheck": 0, "investedCapital": 0, "purchases": 220000, "equityIssued": 0, "buybacksOut": 0 }, "2029-01-01": { "revenue": 552000, "growth": 14.049586776859503, "grossMargin": 56.52173913043478, "sga": 0, "da": 0, "taxRate": 0, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 0, "interestRate": 0, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0, "cogs": -240000, "grossProfit": 312000, "otherOperatingIncome": 0, "sgaExpense": 0, "ebitda": 312000, "ebit": 312000, "interest": 0, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 312000, "tax": 0, "netIncome": 312000, "ar": 0, "grossAR": 0, "impairmentAllowance": 0, "inventory": 0, "ap": 0, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": 0, "changeInventory": 0, "changeAP": 0, "changeOtherWC": 0, "daAddback": 0, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 312000, "capexOut": 0, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": 0, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 312000, "cash": 996000, "ppe": 0, "otherNCA": 0, "otherNCL": 0, "currentAssets": 996000, "assets": 996000, "equity": 996000, "shareCapital": 0, "retainedEarnings": 684000, "currentYearNetIncome": 312000, "dividends": 0, "liabilitiesEquity": 996000, "fcf": 312000, "totalCapex": 0, "collections": 552000, "suppliers": -240000, "operatingPayments": 0, "interestPaid": 0, "taxPaid": 0, "taxExpense": 0, "cashTax": 0, "taxPayable": 0, "interestExpense": 0, "cashInterest": 0, "interestPayable": 0, "roic": null, "roe": 37.142857142857146, "roa": 37.142857142857146, "ebitMargin": 56.52173913043478, "ebitdaMargin": 56.52173913043478, "fcfMargin": 56.52173913043478, "netDebt": -996000, "leverage": -3.1923076923076925, "workingCapital": 996000, "nwc": 0, "ccc": 0, "currentRatio": null, "quickRatio": null, "beginningCash": 684000, "balanceCheck": 0, "investedCapital": 0, "purchases": 240000, "equityIssued": 0, "buybacksOut": 0 } } }, "analysis": { "outputs": { "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": {}, "summary": null }, "tools": { "version": 1, "active": { "model.annual": true, "model.quarterly": false, "model.monthly": false, "model.weekly": false, "value.dcf": false, "value.comps": false, "value.precedents": false, "value.summary": false, "deals.lbo": false } }, "resolution": { "version": 1, "branches": {} } } ] } }