Sample output from the Deal Model vs. Actual Performance prompt in the Sonar AI Prompt Library, run against a NetSuite test account. Every name and number here is test data. Back to the post · The library
Investment-Thesis Scorecard · Confidential

Deal Model vs.
Actual Performance

Actual revenue, EBITDA, capex, and debt trajectory against the LBO base case — cumulative variance quantified, MOIC and IRR recalculated under the trajectories the ledger will actually support
PlatformAcme Food & Beverage
System of recordNetSuite OneWorld (production instance)
Report dateAugust 17, 2026
Actuals windowFull GL history: FY2024 (first operating year) – FY2026 YTD (Jan–Jul)
Hold assumptionRecently closed; Year 1 of a five-year hold
LBO model inputsIllustrative placeholders — entry multiple, base-case projections, and capital structure are not recorded in the ERP and must be supplied by the sponsor; every placeholder is shaded and labeled (Appendix A, assumption 1)
Prepared fromGeneral-ledger detail via SuiteQL; consistent with the 100-Day Financial Baseline and Add-On Synergy Tracker (Aug 2026)
Confidential — prepared for the sponsor and the office of the CFO
Deal Model vs. Actual · August 2026Acme Food & Beverage

—Executive Summary


+238%
Revenue FY24 → FY25
$1.90M → $6.42M (first full operating year)
$5.68M
FY26 Revenue, Jan–Jul
$9.7M annualized — but see the regime caveat
15.1% → 29.1%
EBITDA Margin FY25 → FY26 YTD
Half the gain is the unreconciled costing artifact
$2.01M
Cumulative Capex Since FY24
Front-loaded: leasehold build-out dominates
$10K
Total Debt on the Books
No term debt in the ERP — see the structural note
0.65×
MOIC — Worst Defensible Case
Baseline regime persists (Scenario A)
2.98×
MOIC — Most Defensible Case
New volume at historical margin (Scenario C)
4.4×
Spread Between Cases
The thesis IS the run-rate question

This scorecard compares the platform's actual financial trajectory — taken from the full general-ledger history — against the LBO base case, and recalculates the projected return under the trajectories the ledger will actually support. Because the deal closed recently, the honest form of the year-by-year comparison is: entry baseline vs. model, Year 1 actuals vs. plan, and a return recalculation that carries the unresolved questions from the 100-Day Baseline into the MOIC/IRR arithmetic — where their cost becomes explicit.

What the ledger supports

The growth story is real: revenue $1.90M (FY24, first operating year) → $6.42M (FY25) → $5.68M in seven months of FY26. EBITDA margin expanded from 15.1% (FY25) to 29.1% (FY26 YTD). Capex of $2.01M since FY24 is front-loaded build-out (leasehold improvements $1.24M), consistent with a platform investment phase, and FY26 capex is running well below prior years — the asset base is largely built.

What the ledger does not support

Roughly half the FY26 margin expansion sits in the unreconciled June–July costing artifact flagged in the baseline. The recalculated return is therefore not a number but a range, and the range is brutal: 0.65× MOIC / −8.2% IRR if the pre-June baseline regime is the true business, versus 2.98× / +24.4% if the June–July volume holds at the demonstrated historical margin structure, versus 5.07× / +38.4% only if the as-booked June–July economics are real — which this report does not treat as defensible until the costing reconciliation completes. No sponsor debt exists in the ERP ($10K line of credit only): either the deal was all-equity or acquisition debt sits at a holding company outside NetSuite — the debt-paydown scorecard cannot be computed from this instance either way, and that gap is itself a finding.

The spread between the defensible cases is 4.4× of invested capital. Nothing in the plan — no hire, no system, no synergy — moves the return as much as resolving which revenue regime is real and killing the costing artifact. The August close is not an accounting exercise; it is the thesis checkpoint.
Executive Summary · 2Acme Food & Beverage

1Actual Trajectory — Fiscal Year Scorecard


Actuals from the general ledger, by fiscal year
MetricFY2024*FY2025FY2026 YTD (Jan–Jul)FY2026 ann.†
Revenue ($)1,902,5116,423,2615,679,242≈9,735,843
Revenue growth (%)—+238+52 vs. FY25 (annualized)
EBITDA ($)314,263967,2401,654,514≈2,836,310
EBITDA margin (%)16.515.129.1—
Margin quality flagFY26 margin includes the unreconciled Jun–Jul costing artifact (100-Day Baseline §2.2); on the historical 34–43% gross-margin band, FY26 YTD EBITDA margin would be ≈13–16%, in line with FY25
Capex — gross additions ($)750,000995,000267,925≈459,300
Capex / revenue (%)39.415.54.7—
Debt balance ($)0010,000LOC only

* FY2024 is the first operating year (first postings Dec 2023; FY2023 activity $5.8K). † Simple 12/7 annualization of YTD — shown for scale only; the regime question (§3) makes any single FY26 annualization unreliable. FY2026 GL contains Aug+ activity and future-dated postings which are excluded via the Jan–Jul monthly series.

Revenue and EBITDA by fiscal year — $ millions
0 5 10 FY2024 FY2025 FY2026 $1.90M $6.42M $5.68M YTD ann. ≈$9.7M Revenue EBITDA Dashed = simple annualization (indicative only)
Source: GL by trandate year (Appendix B, Q1); FY26 YTD from the baseline's verified monthly series
Capex compositionCumulative gross additions $2.01M: leasehold improvements $1,235,000 (61%) · machinery & equipment $452,925 · furniture & fixtures $225,000 · automotive $100,000. The build-out is front-loaded (FY24–25 = 87% of the total) and FY26 capex intensity has fallen to 4.7% of revenue — the platform is past its investment phase, which is favorable for the free-cash-flow leg of the return. Note: the fixed-asset subledger reconciliation gap flagged in the baseline (no accumulated depreciation on leaseholds) applies to net-book figures; gross additions used here are unaffected.
Debt paydown — a structural blankThe ERP carries no term debt in any year: total debt is a $10,000 line of credit drawn in 2026. Either the acquisition was effectively all-equity, or — more likely in an LBO context — acquisition debt sits at a holding company outside this NetSuite instance. In that case the debt-paydown leg of the deal model cannot be scored from this system, interest service does not appear in the platform P&L (consistent with the baseline's finding of no interest lines), and covenant reporting runs off-ledger. Action: either bring holdco accounting into the ERP or supply the lender-model amortization schedule as a tracker input.
Actual Trajectory · 3–4Acme Food & Beverage

2Actual vs. Base Case — Variance Scorecard


Reading this tableThe Actual column is GL-verified. The Base case column is an illustrative placeholder (shaded) — the LBO model is not recorded in the ERP. The placeholder base case assumes underwriting off TTM EBITDA of $2.02M with 10% revenue growth, 24% stable margins, $400K/yr maintenance capex, and $1.5M/yr debt amortization. Replace with the sponsor's model to produce the true variance; the structure and the actuals stand regardless.
Year 1 scorecard (deal year = FY2026, in progress)
MetricBase case Y1Actual / run-rateVarianceAssessment (evidence-based)
Revenue ($M)9.579.74 ann.+0.17On plan if the Jun–Jul regime holds; $7.1M — an −26% miss — if it reverts (§3)
EBITDA ($M)2.222.84 ann.+0.62Apparent beat is ≈half costing artifact; artifact-adjusted ≈$1.5–1.7M = a miss. Not scoreable until the Aug close reconciles inventory absorption
Capex ($M)0.400.46 ann.−0.06Roughly on plan; investment phase complete
Debt paydown ($M)1.50n/an/aNo sponsor debt in the ERP — unmeasurable from this system (§1 structural note)
Working capitalneutral−$2.89M at riskunfavorableCounterparty-less journal AR/AP from the baseline; if the A/R portion writes off, it hits any equity-value bridge at close-out

Cumulative variance to base case

At month ~8 of Year 1, cumulative variance is dominated by a single unresolved question rather than by operational drift: the two defensible readings of the same ledger differ by ≈$2.6M of annualized revenue and ≈$1.3M of annualized EBITDA — larger than every other variance line combined. Formal cumulative tracking (plan-to-date vs. actual-to-date by quarter) should begin from the August 2026 close, the first under new ownership, with the sponsor's real base case loaded as the NetSuite budget (the baseline found budget coverage already exists for two fiscal years — the mechanism is in place).

Variance Scorecard · 5Acme Food & Beverage

3Recalculated Returns — MOIC / IRR Under Actual Trajectories


Return engine — assumptionsIllustrative capital structure (shaded methodology, Appendix A assumption 5): entry at 8.0× TTM EBITDA ($2.02M) = $16.17M, assumed all-equity per the ERP's debt evidence; five-year hold; exit at entry multiple (8.0×, no multiple expansion assumed); no interim distributions; scenario EBITDA start-points from the 100-Day Baseline's regime analysis with stated growth per scenario. Supply the actual entry equity, debt schedule, and base case to convert this from a sensitivity engine into the true scorecard. The relative spread between scenarios is the finding, and it survives any reasonable parameter set.
Scenario returns — five-year hold, exit at entry multiple
Scenario (from baseline §2.3)Start EBITDA ($)Growth p.a.Exit EBITDA ($)MOICIRRDefensibility
A — Baseline regime persists819,99110%1,320,6040.65×−8.2%Defensible worst case — the 10-month pre-June track record
B — TTM as reported2,021,5165%2,580,0241.28×+5.0%Arithmetically real but blends two regimes; weak planning basis
C — New volume at historical margin4,100,0008%6,024,2452.98×+24.4%Most defensible upside — requires Jun–Jul volume to persist (testable at the Aug close)
D — New regime as booked8,029,1405%10,247,4435.07×+38.4%Not defensible until the costing artifact is reconciled; do not present externally
MOIC by scenario — the return is a range until the regime question is answered
1.0× — capital returned 0.65× 1.28× 2.98× 5.07× A · baseline regime B · TTM blend C · volume + real margin D · as booked (unverified)
Illustrative return engine — relative spread is the finding; dashed bar = not defensible pending costing reconciliation

What moves the return, in order

  1. Resolving the regime question (A vs. C): worth 2.33× of MOIC — more than any operational initiative in the 100-day plan. Adjudicated by the August close: does invoice volume hold ≈220/month, and does reconciled gross margin land in or above the 34–43% band?
  2. Killing the costing artifact (C vs. D): worth knowing, not worth booking — presenting D externally before reconciliation risks a credibility-destroying restatement later.
  3. The $2.89M journal AR/AP resolution: a potential one-time equity-bridge hit at exit if the receivable side writes off; quantified in the baseline, carried here as a return-adjacent risk.
  4. Margin structure work (baseline 100-day plan): each sustained point of gross margin ≈$97K of EBITDA at Scenario C volume ≈$0.78M of exit value at 8× — material, but an order of magnitude below items 1–2.
Brutal honesty, as requested: on the ten-month track record this deal returns 0.65× — a loss. On the most defensible reading of the last two months it returns 2.98×. The difference is not execution; it is verification. Until the August close reconciles the June–July ledger, the honest answer to "how is the deal performing?" is a range with a 4.4× spread and a checklist for collapsing it.
Recalculated Returns · 6–7Acme Food & Beverage

4Thesis Checkpoint — Actions


Ranked actions to collapse the return range
#ActionOwner / timingReturn linkage
1Complete the August close with the inventory-costing reconciliationController · Day 30–45Adjudicates Scenario C vs. D margin; first data point on whether Jun–Jul volume persists. Collapses the widest leg of the 0.65×–2.98× range.
2Supply the actual LBO model (entry equity, debt schedule, base case by year)Sponsor · immediateConverts every shaded column in this scorecard from placeholder to true variance; load the base case as the NetSuite budget (mechanism already exists) to automate quarterly scoring.
3Resolve the holdco-debt visibility gapCFO + sponsor · Day 60Debt paydown — one of the four scorecard legs — is currently unmeasurable from the ERP. Bring holdco accounting in, or feed the lender amortization schedule as a standing input.
4Close out the $2.89M journal AR/AP by Day 30 (baseline action, return-linked here)Controller · Day 30Removes a potential one-time equity-bridge hit and cleans the working-capital peg before it compounds across the hold.
5Re-run this scorecard quarterly from the Sep closeCFO · standingWith real model inputs and a functioning close (baseline plan), this becomes the sponsor's standing thesis exhibit: actual vs. base case by quarter, cumulative variance, live MOIC/IRR band.
Thesis Checkpoint · 8Acme Food & Beverage

AAppendix A — Assumptions & Methodology


  1. LBO model inputs are illustrative placeholders. Entry multiple (8.0×), entry equity ($16.17M), base-case projections (10% growth, 24% margin, $400K capex, $1.5M amortization), and exit assumptions (entry multiple, 5-year hold, no distributions) are not recorded in the ERP and are shaded throughout. The actual-trajectory figures and the relative scenario spread are instance-derived and survive parameter replacement.
  2. Fiscal years by transaction date (TO_CHAR(trandate,'YYYY')), not posting period — the GL contains future-dated postings (baseline finding) and journal-posted history; trandate grouping is the stable basis. FY2026 figures use the Jan–Jul verified monthly series; the 12/7 annualization is labeled indicative.
  3. FY2024 is a partial first operating year (operations began Dec 2023; FY2023 = $5.8K). Growth off FY2024 overstates trend; FY25→FY26 is the meaningful comparison.
  4. EBITDA definition inherited from the 100-Day Baseline: revenue − COGS − opex excluding 6800-series D&A; other income/(expense) excluded; no interest or tax lines exist in the ledger.
  5. Return engine mechanics: MOIC = exit equity ÷ entry equity with exit equity = scenario exit EBITDA × entry multiple; IRR = MOIC^(1/5) − 1. All-equity assumed per the ERP debt evidence; if holdco leverage exists, equity MOIC/IRR sensitivity to it is not computable from this instance (assumption 7). Scenario start-points and their derivations are from the baseline's §2.3 regime analysis.
  6. Capex = gross debit additions to FixedAsset accounts, excluding accumulated-depreciation postings. The baseline's FAM reconciliation gap affects net book value, not gross additions.
  7. Debt evidence: zero LongTermLiab postings in any year; a single $10K LOC draw in 2026. The holdco-debt hypothesis is stated as such — the ERP cannot confirm or deny debt outside its books.
  8. Scenario C margin arithmetic uses the baseline's construction (Jun–Jul volume at ~38% GP midpoint, baseline opex structure); the "$97K per margin point" figure is 1% of Scenario C annualized revenue ($9.7M) at flow-through.
  9. Consistency with companion reports: TTM EBITDA ($2,021,516), regime figures, the costing-artifact finding, and the $2.89M journal AR/AP carry over from the 100-Day Baseline unchanged; no re-adjudication.
  10. Extraction date: all queries executed August 17, 2026 against the live production instance.
Appendix A · 9Acme Food & Beverage

BAppendix B — Data Lineage: Queries


Q1 — Annual P&L shape, full GL history
Used for: §1 fiscal-year scorecard (revenue, EBITDA components by year)
SELECT TO_CHAR(t.trandate,'YYYY') AS yr,
 ROUND(SUM(CASE WHEN a.accttype IN ('Income','OthIncome') THEN -tal.amount ELSE 0 END),0) AS revenue,
 ROUND(SUM(CASE WHEN a.accttype = 'COGS' THEN -tal.amount ELSE 0 END),0) AS cogs,
 ROUND(SUM(CASE WHEN a.accttype = 'Expense' AND a.acctnumber NOT LIKE '68%' THEN -tal.amount ELSE 0 END),0) AS opex_ex_da,
 ROUND(SUM(CASE WHEN a.acctnumber LIKE '68%' THEN -tal.amount ELSE 0 END),0) AS d_and_a,
 ROUND(SUM(CASE WHEN a.accttype = 'OthExpense' THEN -tal.amount ELSE 0 END),0) AS other_exp
FROM transactionaccountingline tal
JOIN transaction t ON tal.transaction = t.id
JOIN account a ON tal.account = a.id
WHERE t.posting = 'T'
  AND a.accttype IN ('Income','OthIncome','COGS','Expense','OthExpense')
GROUP BY TO_CHAR(t.trandate,'YYYY') ORDER BY yr
Q2 — Capex: fixed-asset postings by year and account
Used for: §1 capex rows and composition note (gross additions vs. accumulated depreciation separated by account)
SELECT TO_CHAR(t.trandate,'YYYY') AS yr, a.acctnumber, a.fullname,
       ROUND(SUM(tal.amount),0) AS net_postings
FROM transactionaccountingline tal
JOIN transaction t ON tal.transaction = t.id
JOIN account a ON tal.account = a.id
WHERE t.posting = 'T' AND a.accttype = 'FixedAsset'
GROUP BY TO_CHAR(t.trandate,'YYYY'), a.acctnumber, a.fullname
ORDER BY yr, a.acctnumber
Q3 — Debt activity: long-term liabilities and line of credit
Used for: §1 debt rows and the holdco structural note (returned only the $10K LOC — the finding)
SELECT TO_CHAR(t.trandate,'YYYY') AS yr, a.acctnumber, a.fullname,
       ROUND(SUM(tal.amount),0) AS net_postings
FROM transactionaccountingline tal
JOIN transaction t ON tal.transaction = t.id
JOIN account a ON tal.account = a.id
WHERE t.posting = 'T' AND (a.accttype = 'LongTermLiab' OR a.acctnumber = '2410')
GROUP BY TO_CHAR(t.trandate,'YYYY'), a.acctnumber, a.fullname
ORDER BY yr, a.acctnumber
Inherited series
FY2026 Jan–Jul monthly revenue/EBITDA, TTM EBITDA, regime scenario start-points, and the costing-artifact analysis are inherited from the 100-Day Financial Baseline (its Appendix B, Q7–Q9) — executed earlier in this engagement and not re-run.
Derived metrics (computed programmatically)
FY EBITDA aggregation, growth rates, capex composition and intensity, annualizations, and the scenario MOIC/IRR engine (MOIC = exit÷entry equity; IRR = MOIC^(1/5)−1) — all computed in the sandboxed calculation environment from the query outputs above.
This document was prepared from the platform's live NetSuite production environment on August 17, 2026, for internal sponsor-reporting purposes. LBO-model values are illustrative placeholders pending sponsor inputs and are shaded and labeled as such throughout; recalculated MOIC/IRR figures are scenario sensitivities, not forecasts or valuations. Actual-trajectory figures derive from unaudited general-ledger data; period-open status means historical figures may change until periods are locked. This document does not constitute audited financial statements, a fairness opinion, a quality-of-earnings report, or investment advice.
Appendix B · 10Acme Food & Beverage