{ "fileType": "BalanceCheat.Model", "formatVersion": 4, "modelSchemaVersion": 1, "calculationVersion": 4, "metadata": { "id": "synthetic-statement-example", "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": 2024, "actualYears": 2, "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": 1200000, "ar": 1000000, "inventory": 800000, "otherCA": 0, "ppe": 5000000, "otherNCA": 0, "ap": 800000, "otherCL": 0, "revolver": 0, "debt": 3000000, "otherNCL": 0, "equity": 4200000, "revenue": 0, "assets": 8000000 }, "years": [ { "revenue": 10000000, "growth": 0, "grossMargin": 40, "sga": 0, "da": 0, "taxRate": 25, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 3000000, "interestRate": 5, "payout": 0, "cogsAmount": 0, "sgaAmount": 0 }, { "revenue": 12000000, "growth": 0, "grossMargin": 40, "sga": 0, "da": 0, "taxRate": 25, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 3500000, "interestRate": 5, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0 }, { "revenue": 13200000, "growth": 0, "grossMargin": 40, "sga": 0, "da": 900000, "taxRate": 25, "capex": 1500000, "dso": 0, "dio": 0, "dpo": 0, "debt": 3500000, "interestRate": 5, "payout": 0, "cogsAmount": 7920000, "sgaAmount": 2400000, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0 } ], "currency": "EUR", "calendar": { "startYear": 2024, "actualYears": 2, "fiscalYearEnd": { "month": 12, "day": 31 } }, "actuals": { "2024": { "revenue": 10000000, "cogs": 6000000, "sga": 2000000, "da": 500000, "capex": 500000, "ar": 1000000, "inventory": 800000, "ap": 800000, "interest": 150000, "tax": 337500 }, "2025": { "revenue": 12000000, "cogs": 7200000, "sga": 2200000, "da": 700000, "capex": 1800000, "ar": 2200000, "inventory": 2000000, "ap": 960000, "interest": 150000, "tax": 437500 } }, "forecastInputs": { "2026": { "ar": 2500000, "inventory": 2400000, "ap": 1056000, "interest": 175000, "tax": 451250 } } }, "objects": [], "authority": {}, "nextId": 1, "display": { "currency": "EUR", "fx": 1, "units": 1000 }, "notes": {} }, "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": "2024-01-01", "start": "2024-01-01", "end": "2025-01-01", "kind": "actual", "frequency": "annual", "year": 2024, "months": 12, "days": 366, "durationDays": 366, "yearFraction": 1, "dayCountBasis": "ACT/ACT", "rateBasis": "annualized", "fiscalYear": 2024, "fiscalQuarter": 1, "fiscalStart": "2024-01-01", "fiscalEnd": "2025-01-01", "fiscalYearEnd": { "month": 12, "day": 31 }, "fiscalStartMonth": 1, "label": "2024A" }, { "id": "2025-01-01", "start": "2025-01-01", "end": "2026-01-01", "kind": "actual", "frequency": "annual", "year": 2025, "months": 12, "days": 365, "durationDays": 365, "yearFraction": 1, "dayCountBasis": "ACT/ACT", "rateBasis": "annualized", "fiscalYear": 2025, "fiscalQuarter": 1, "fiscalStart": "2025-01-01", "fiscalEnd": "2026-01-01", "fiscalYearEnd": { "month": 12, "day": 31 }, "fiscalStartMonth": 1, "label": "2025A" }, { "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" } ], "opening": { "cash": 1200000, "ar": 1000000, "inventory": 800000, "otherCA": 0, "ppe": 5000000, "otherNCA": 0, "ap": 800000, "otherCL": 0, "revolver": 0, "debt": 3000000, "otherNCL": 0, "equity": 4200000, "revenue": 0, "assets": 8000000 }, "breakdown": {}, "statements": { "2024-01-01": { "revenue": 10000000, "growth": null, "grossMargin": 40, "sga": 0, "da": -500000, "taxRate": 25, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 3000000, "interestRate": 5, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "cogs": -6000000, "grossProfit": 4000000, "otherOperatingIncome": 0, "sgaExpense": -2000000, "ebitda": 2000000, "ebit": 1500000, "interest": -150000, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 1350000, "tax": -337500, "netIncome": 1012500, "ar": 1000000, "grossAR": 1000000, "impairmentAllowance": 0, "inventory": 800000, "ap": 800000, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": 0, "changeInventory": 0, "changeAP": 0, "changeOtherWC": 0, "daAddback": 500000, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 1512500, "capexOut": -500000, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": -500000, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 1012500, "cash": 2212500, "ppe": 5000000, "otherNCA": 0, "otherNCL": 0, "currentAssets": 4012500, "assets": 9012500, "equity": 5212500, "shareCapital": 0, "retainedEarnings": 4200000, "currentYearNetIncome": 1012500, "dividends": 0, "liabilitiesEquity": 9012500, "fcf": 1012500, "totalCapex": 500000, "collections": 10000000, "suppliers": -6000000, "operatingPayments": -2000000, "interestPaid": -150000, "taxPaid": -337500, "taxExpense": 337500, "cashTax": 337500, "taxPayable": 0, "interestExpense": 150000, "cashInterest": 150000, "interestPayable": 0, "roic": 18.75, "roe": 21.51394422310757, "roa": 11.903012490815577, "ebitMargin": 15, "ebitdaMargin": 20, "fcfMargin": 10.125, "netDebt": 787500, "leverage": 0.39375, "workingCapital": 3212500, "nwc": 1000000, "ccc": 36.49999999999999, "currentRatio": 5.015625, "quickRatio": 4.015625, "beginningCash": 1200000, "balanceCheck": 0, "investedCapital": 6000000, "purchases": 6000000 }, "2025-01-01": { "revenue": 12000000, "growth": 19.999999999999996, "grossMargin": 40, "sga": 0, "da": -700000, "taxRate": 25, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 3500000, "interestRate": 5, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0, "cogs": -7200000, "grossProfit": 4800000, "otherOperatingIncome": 0, "sgaExpense": -2200000, "ebitda": 2600000, "ebit": 1900000, "interest": -150000, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 1750000, "tax": -437500, "netIncome": 1312500, "ar": 2200000, "grossAR": 2200000, "impairmentAllowance": 0, "inventory": 2000000, "ap": 960000, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": -1200000, "changeInventory": -1200000, "changeAP": 160000, "changeOtherWC": 0, "daAddback": 700000, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": -227500, "capexOut": -1800000, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": -1800000, "debtIssued": 500000, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 500000, "cashChange": -1527500, "cash": 685000, "ppe": 6100000, "otherNCA": 0, "otherNCL": 0, "currentAssets": 4885000, "assets": 10985000, "equity": 6525000, "shareCapital": 0, "retainedEarnings": 5212500, "currentYearNetIncome": 1312500, "dividends": 0, "liabilitiesEquity": 10985000, "fcf": -2027500, "totalCapex": 1800000, "collections": 10800000, "suppliers": -8240000, "operatingPayments": -2200000, "interestPaid": -150000, "taxPaid": -437500, "taxExpense": 437500, "cashTax": 437500, "taxPayable": 0, "interestExpense": 150000, "cashInterest": 150000, "interestPayable": 0, "roic": 18.578878748370272, "roe": 22.364217252396166, "roa": 13.126640830103764, "ebitMargin": 15.833333333333332, "ebitdaMargin": 21.666666666666668, "fcfMargin": -16.895833333333332, "netDebt": 2815000, "leverage": 1.0826923076923076, "workingCapital": 3925000, "nwc": 3240000, "ccc": 119.63888888888889, "currentRatio": 5.088541666666667, "quickRatio": 3.0052083333333335, "beginningCash": 2212500, "balanceCheck": 0, "investedCapital": 9340000, "purchases": 8400000 }, "2026-01-01": { "revenue": 13200000, "growth": 10.000000000000009, "grossMargin": 40, "sga": 0, "da": -900000, "taxRate": 25, "capex": 1500000, "dso": 0, "dio": 0, "dpo": 0, "debt": 3500000, "interestRate": 5, "payout": 0, "cogsAmount": 7920000, "sgaAmount": 2400000, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0, "cogs": -7920000, "grossProfit": 5280000, "otherOperatingIncome": 0, "sgaExpense": -2400000, "ebitda": 2880000, "ebit": 1980000, "interest": -175000, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 1805000, "tax": -451250, "netIncome": 1353750, "ar": 2500000, "grossAR": 2500000, "impairmentAllowance": 0, "inventory": 2400000, "ap": 1056000, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": -300000, "changeInventory": -400000, "changeAP": 96000, "changeOtherWC": 0, "daAddback": 900000, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 1649750, "capexOut": -1500000, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": -1500000, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 149750, "cash": 834750, "ppe": 6700000, "otherNCA": 0, "otherNCL": 0, "currentAssets": 5734750, "assets": 12434750, "equity": 7878750, "shareCapital": 0, "retainedEarnings": 6525000, "currentYearNetIncome": 1353750, "dividends": 0, "liabilitiesEquity": 12434750, "fcf": 149750, "totalCapex": 1500000, "collections": 12900000, "suppliers": -8224000, "operatingPayments": -2400000, "interestPaid": -175000, "taxPaid": -451250, "taxExpense": 451250, "cashTax": 451250, "taxPayable": 0, "interestExpense": 175000, "cashInterest": 175000, "interestPayable": 0, "roic": 14.936632468316235, "roe": 18.79718823223119, "roa": 11.560755345381569, "ebitMargin": 15, "ebitdaMargin": 21.818181818181817, "fcfMargin": 1.134469696969697, "netDebt": 2665250, "leverage": 0.9254340277777777, "workingCapital": 4678750, "nwc": 3844000, "ccc": 131.06818181818184, "currentRatio": 5.43063446969697, "quickRatio": 3.157907196969697, "beginningCash": 685000, "balanceCheck": 0, "investedCapital": 10544000, "purchases": 8320000 } }, "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": { "2024-01-01": { "revenue": 10000000, "growth": null, "grossMargin": 40, "sga": 0, "da": -500000, "taxRate": 25, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 3000000, "interestRate": 5, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "cogs": -6000000, "grossProfit": 4000000, "otherOperatingIncome": 0, "sgaExpense": -2000000, "ebitda": 2000000, "ebit": 1500000, "interest": -150000, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 1350000, "tax": -337500, "netIncome": 1012500, "ar": 1000000, "grossAR": 1000000, "impairmentAllowance": 0, "inventory": 800000, "ap": 800000, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": 0, "changeInventory": 0, "changeAP": 0, "changeOtherWC": 0, "daAddback": 500000, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 1512500, "capexOut": -500000, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": -500000, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 1012500, "cash": 2212500, "ppe": 5000000, "otherNCA": 0, "otherNCL": 0, "currentAssets": 4012500, "assets": 9012500, "equity": 5212500, "shareCapital": 0, "retainedEarnings": 4200000, "currentYearNetIncome": 1012500, "dividends": 0, "liabilitiesEquity": 9012500, "fcf": 1012500, "totalCapex": 500000, "collections": 10000000, "suppliers": -6000000, "operatingPayments": -2000000, "interestPaid": -150000, "taxPaid": -337500, "taxExpense": 337500, "cashTax": 337500, "taxPayable": 0, "interestExpense": 150000, "cashInterest": 150000, "interestPayable": 0, "roic": 18.75, "roe": 21.51394422310757, "roa": 11.903012490815577, "ebitMargin": 15, "ebitdaMargin": 20, "fcfMargin": 10.125, "netDebt": 787500, "leverage": 0.39375, "workingCapital": 3212500, "nwc": 1000000, "ccc": 36.49999999999999, "currentRatio": 5.015625, "quickRatio": 4.015625, "beginningCash": 1200000, "balanceCheck": 0, "investedCapital": 6000000, "purchases": 6000000 }, "2025-01-01": { "revenue": 12000000, "growth": 19.999999999999996, "grossMargin": 40, "sga": 0, "da": -700000, "taxRate": 25, "capex": 0, "dso": 0, "dio": 0, "dpo": 0, "debt": 3500000, "interestRate": 5, "payout": 0, "cogsAmount": 0, "sgaAmount": 0, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0, "cogs": -7200000, "grossProfit": 4800000, "otherOperatingIncome": 0, "sgaExpense": -2200000, "ebitda": 2600000, "ebit": 1900000, "interest": -150000, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 1750000, "tax": -437500, "netIncome": 1312500, "ar": 2200000, "grossAR": 2200000, "impairmentAllowance": 0, "inventory": 2000000, "ap": 960000, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": -1200000, "changeInventory": -1200000, "changeAP": 160000, "changeOtherWC": 0, "daAddback": 700000, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": -227500, "capexOut": -1800000, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": -1800000, "debtIssued": 500000, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 500000, "cashChange": -1527500, "cash": 685000, "ppe": 6100000, "otherNCA": 0, "otherNCL": 0, "currentAssets": 4885000, "assets": 10985000, "equity": 6525000, "shareCapital": 0, "retainedEarnings": 5212500, "currentYearNetIncome": 1312500, "dividends": 0, "liabilitiesEquity": 10985000, "fcf": -2027500, "totalCapex": 1800000, "collections": 10800000, "suppliers": -8240000, "operatingPayments": -2200000, "interestPaid": -150000, "taxPaid": -437500, "taxExpense": 437500, "cashTax": 437500, "taxPayable": 0, "interestExpense": 150000, "cashInterest": 150000, "interestPayable": 0, "roic": 18.578878748370272, "roe": 22.364217252396166, "roa": 13.126640830103764, "ebitMargin": 15.833333333333332, "ebitdaMargin": 21.666666666666668, "fcfMargin": -16.895833333333332, "netDebt": 2815000, "leverage": 1.0826923076923076, "workingCapital": 3925000, "nwc": 3240000, "ccc": 119.63888888888889, "currentRatio": 5.088541666666667, "quickRatio": 3.0052083333333335, "beginningCash": 2212500, "balanceCheck": 0, "investedCapital": 9340000, "purchases": 8400000 }, "2026-01-01": { "revenue": 13200000, "growth": 10.000000000000009, "grossMargin": 40, "sga": 0, "da": -900000, "taxRate": 25, "capex": 1500000, "dso": 0, "dio": 0, "dpo": 0, "debt": 3500000, "interestRate": 5, "payout": 0, "cogsAmount": 7920000, "sgaAmount": 2400000, "arAdjustment": 0, "inventoryAdjustment": 0, "extraDividend": 0, "equipmentPurchase": 0, "extraDA": 0, "scenarioBorrowing": 0, "scenarioRepayment": 0, "cogs": -7920000, "grossProfit": 5280000, "otherOperatingIncome": 0, "sgaExpense": -2400000, "ebitda": 2880000, "ebit": 1980000, "interest": -175000, "interestIncome": 0, "impairment": 0, "otherOperatingExpense": 0, "manualOtherNonCashExpense": 0, "ebt": 1805000, "tax": -451250, "netIncome": 1353750, "ar": 2500000, "grossAR": 2500000, "impairmentAllowance": 0, "inventory": 2400000, "ap": 1056000, "otherCA": 0, "otherCL": 0, "nonCashProvision": 0, "changeAR": -300000, "changeInventory": -400000, "changeAP": 96000, "changeOtherWC": 0, "daAddback": 900000, "otherNonCash": 0, "operatingNonCash": 0, "nonOperatingReclassification": 0, "cfo": 1649750, "capexOut": -1500000, "disposalProceeds": 0, "otherOperatingCF": 0, "otherInvestingCF": 0, "otherFinancingCF": 0, "cfi": -1500000, "debtIssued": 0, "debtRepaid": 0, "revolver": 0, "fundingChange": 0, "dividendsOut": 0, "cff": 0, "cashChange": 149750, "cash": 834750, "ppe": 6700000, "otherNCA": 0, "otherNCL": 0, "currentAssets": 5734750, "assets": 12434750, "equity": 7878750, "shareCapital": 0, "retainedEarnings": 6525000, "currentYearNetIncome": 1353750, "dividends": 0, "liabilitiesEquity": 12434750, "fcf": 149750, "totalCapex": 1500000, "collections": 12900000, "suppliers": -8224000, "operatingPayments": -2400000, "interestPaid": -175000, "taxPaid": -451250, "taxExpense": 451250, "cashTax": 451250, "taxPayable": 0, "interestExpense": 175000, "cashInterest": 175000, "interestPayable": 0, "roic": 14.936632468316235, "roe": 18.79718823223119, "roa": 11.560755345381569, "ebitMargin": 15, "ebitdaMargin": 21.818181818181817, "fcfMargin": 1.134469696969697, "netDebt": 2665250, "leverage": 0.9254340277777777, "workingCapital": 4678750, "nwc": 3844000, "ccc": 131.06818181818184, "currentRatio": 5.43063446969697, "quickRatio": 3.157907196969697, "beginningCash": 685000, "balanceCheck": 0, "investedCapital": 10544000, "purchases": 8320000 } } }, "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": {} } } ] } }