What is an acquisition financial model?
An acquisition financial model is an Excel workbook or spreadsheet that connects the purchase price, transaction financing, closing payments, ownership, and post-closing cash generation. Its job is not merely to produce an answer. It should let a reviewer trace that answer back to the inputs, sources, and formulas that produced it.
For an entrepreneurship-through-acquisition buyer, the model usually sits between an initial underwriting model and the final closing mechanics. It should show what the buyer expects to pay, how the transaction will be funded, what must move at closing, who owns what afterward, and whether the business is expected to have enough liquidity to operate and service debt.
This guide uses Acquisition Financial Model as the public name because it describes the artifact and matches common search language. Workbook remains the precise file-level term for an .xlsx containing several related worksheets. Spreadsheet is a useful plain-language synonym. ETA is an intended audience, not part of the product name.
Sources for this answer
Technical standard
A.1 ICAEW, Twenty principles for good spreadsheet practiceICAEW says spreadsheet design should identify and facilitate use by its intended audience.
If a spreadsheet is intended to be understood and used by others, the design should facilitate this.
See Institute of Chartered Accountants in England and Wales, Twenty principles for good spreadsheet practice (2024).
What are sources and uses in an acquisition model?
Sources and uses is the transaction-capitalization bridge. Uses show how much capital the acquisition requires; sources show where that capital comes from. Total sources should equal total uses.
Typical uses include purchase consideration, debt payoff, transaction expenses, and required cash at closing. Typical sources include acquisition debt, buyer equity, seller financing, and rollover equity. The schedule answers a financing question: how is the transaction funded?
The SBA's business-plan guidance reflects the same basic discipline: identify the funding required and explain how it will be used. That guidance is not an acquisition-model standard, but it illustrates why sources and uses belong together.
Sources for this answer
Internet resource
B.1 U.S. Small Business Administration, Plan your businessThe SBA's funding-request guidance tells borrowers to state the funding required and explain its intended use.
Give a detailed description of how you’ll use your funds.
See U.S. Small Business Administration, Write your business plan, Funding request.
What is a closing funds flow?
A closing funds flow is a point-in-time execution schedule showing the amounts that must move at closing, the payor and recipient for each payment, and the payment's purpose. It is not an ordinary operating cash-flow forecast.
The schedule may include purchase consideration, debt payoff, transaction expenses, escrows, holdbacks, and other closing payments. It should reconcile to the applicable uses, but it serves a different purpose: the closing funds flow organizes execution; sources and uses explains capitalization.
The filed transaction document cited here defines a dated flow-of-funds memorandum as a distinct closing instrument. It also separately identifies a supplemental sources-and-uses schedule. That separation supports using different worksheet names for different jobs.
Sources for this answer
Internet resource
C.1 Village Super Market, Inc., Credit Agreement exhibitThe filed agreement defines a dated flow-of-funds memorandum as a separate instrument among the transaction's funding parties.
“Flow of Funds Memorandum” shall mean that certain Flow of Funds Memorandum, dated as of the date hereof by and among Lender, Fund Investor, Investment Fund, Borrower, Leverage Lender and certain other parties thereto.
See Village Super Market, Inc., Current Report (Form 8-K), Exhibit 10.1, Credit Agreement (filed Dec. 29, 2025).
What is an operating cash-flow forecast?
An operating cash-flow forecast projects recurring liquidity after closing, usually by month or year. It should show revenue, operating expenses, debt service, and the resulting change in cash over time.
This forecast answers a time-series question that neither the closing funds flow nor sources and uses answers: can the acquired business generate enough cash to operate and meet its obligations after the transaction? The U.S. Small Business Administration includes projected income statements, balance sheets, and cash-flow statements among the financial projections used in business planning.
For readability, call the worksheet Operating Cash Flow Forecast. The label Funds Flow (Monthly) invites readers to confuse recurring operations with the closing payment schedule.
Sources for this answer
Official source · Agency guidance
D.1 U.S. Small Business Administration, Write your business planSBA guidance identifies projected income statements, balance sheets, and cash-flow statements as financial projections used in business planning.
Provide a prospective financial outlook for the next five years.
See U.S. Small Business Administration, Plan your business, Financial projections.
What is a cap table, and why include one?
In this model, a capitalization table, or cap table, shows who owns the company before and after the transaction. Including a dedicated cap-table worksheet makes ownership changes visible and gives the ownership check an independent, reviewable home. Public-company filings likewise use ownership tables to present holders and percentages, although their disclosure purpose is different.
A simple acquisition model can use neutral holders such as Party A and Party B and show pre-transaction and post-transaction percentages. The total in each column should equal 100%. Separate ownership-and-returns calculations may then link to the post-transaction column instead of re-entering percentages.
The public example uses fictional parties and synthetic figures. It demonstrates the structure without publishing a client's identity or economics. A real model may need additional rows for rollover sellers, management equity, option pools, preferred interests, or contingent issuance.
Sources for this answer
Internet resource
E.1 Filed acquisition agreement, capitalization provisionThe filed acquisition agreement uses a capitalization table to state the company's capitalization immediately before closing.
Company Capitalization Table sets forth the capitalization of Company upon completion of the Equity Pre-Closing Transactions immediately before Closing.
See Acquisition Agreement, Section 3.2(b), filed as Exhibit 2.1 (2026).
Why define each economic input only once?
Defining each economic input once prevents two cells from silently becoming competing sources of truth. Every schedule that needs the value should link to the same named input or canonical input cell.
Duplicate inputs create a review problem: two cells can begin with the same number, then diverge after one is updated. A single input section makes changes deliberate and allows the workbook to distinguish entered assumptions from derived results.
ICAEW's Twenty principles for good spreadsheet practice supports the same architecture from the formula side: do not embed changeable values in formulas, and calculate a value once before referring back to it.
Sources for this answer
Technical standard
F.1 ICAEW, Twenty principles for good spreadsheet practiceICAEW recommends keeping changeable values outside formulas and calculating a result once before referring back to it.
Perform a calculation once and then refer back to that calculation.
See Institute of Chartered Accountants in England and Wales, Twenty principles for good spreadsheet practice (2024).
What makes an acquisition model source-aware?
A source-aware model associates each input with a stable source identifier, status, unit, and explanatory note. It distinguishes confirmed, estimated, derived, and unresolved values so a later communication cannot silently rewrite the provenance of an earlier assumption.
Use one source identifier for each communication or document. A sender's name is not enough: two messages from the same person can contain different facts or supersede one another. The model should preserve which message, agreement, lender quote, diligence response, or calculation supports each value.
The UK government's AQuA Book calls for documented assumptions and data, logs of inputs and decisions, and records of verification and validation. That discipline makes handoff easier because a reviewer can filter unresolved inputs and trace a changed output to the assumption that moved.
Sources for this answer
Official source · Agency guidance
G.1 UK Government, The AQuA BookThe AQuA Book calls for documentation of analytical assumptions and data, decision logs, and verification and validation records.
All analysis shall have user documentation, even if the only user is the analyst leading the analysis.
See UK Government Analysis Function, The AQuA Book, §§ 2, 8.3 (2025 edition).
How should the workbook be organized?
Use a fixed, reader-oriented order: Read Me, Inputs, Sources & Uses, Closing Funds Flow, Operating Cash Flow Forecast, Cap Table, Ownership & Returns, and Checks. Each worksheet should answer one recognizable question.
The structure moves from instructions and assumptions to transaction mechanics, operating performance, ownership, returns, and verification. Related worksheets can link to one another, but each input should still originate in one place.
Do not create temporary worksheets and then rename or relocate them during generation. Build the final topology directly. A deterministic sheet order makes structural snapshots meaningful and reduces formula-rewrite risk during refactors.
Sources for this answer
Technical standard
H.1 ICAEW, Twenty principles for good spreadsheet practiceICAEW recommends separating inputs, workings, and outputs and using a consistent structure.
Separate and clearly identify inputs, workings and outputs.
See Institute of Chartered Accountants in England and Wales, Twenty principles for good spreadsheet practice (2024).
How should formulas be written for reviewability?
Prefer short, consistent formulas that link to canonical inputs and clearly labeled totals. Calculate a result once, then reference it wherever else it is needed.
Long formulas assembled through manual coordinate arithmetic are hard to inspect in Python and hard to audit in Excel. Builder code should use named records and small formula helpers, while presentation helpers handle cell placement and styles. This is an abstraction over repetitive mechanics, not a new financial language.
ICAEW's spreadsheet principles emphasize simple formulas, avoiding fixed values inside formulas, and calculating a value once before referring to that result elsewhere.
Sources for this answer
Technical standard
I.1 ICAEW, Twenty principles for good spreadsheet practiceICAEW recommends simple, consistent formulas, avoiding embedded fixed values, and calculating a value once before reusing it.
Keep formulae as short and simple as practicable.
See Institute of Chartered Accountants in England and Wales, Twenty principles for good spreadsheet practice (2024).
How do you know the workbook checks are reliable?
Put every check formula beside a human-readable assertion, inspect the workbook's calculated results, and run negative controls that intentionally violate each material assertion. A green check is evidence only if the relevant failure makes it turn red.
A formula can compare a value with itself, depend on the same defective formula twice, or return PASS regardless of the condition it claims to test. Classify each assertion as an independent check or a consistency check so reviewers understand what evidence it provides.
ICAEW's spreadsheet-review guidance treats review of business logic and assumptions as distinct from review of formulas and construction. A trustworthy verification process needs both.
Sources for this answer
Technical standard
J.1 ICAEW, How to Review a SpreadsheetICAEW distinguishes review of business logic and assumptions from review of formulas and spreadsheet construction and says both are needed.
Different approaches are needed to review the business logic and assumptions in a spreadsheet versus the formulas and construction of it – neither alone is sufficient.
See Institute of Chartered Accountants in England and Wales, How to Review a Spreadsheet, at 5.
What are negative controls in a financial model?
A negative control deliberately breaks one workbook invariant and confirms that the corresponding check fails. It tests the detector, not merely the unmodified model.
Examples include changing a source without changing uses, breaking the pre- or post-transaction ownership total, removing an input's source identifier, or making monthly operating cash flow negative. Each mutation should fail the intended assertion independently of the displayed check cell.
Negative controls should operate on temporary copies. They should never alter the user's source file or delivered workbook.
Sources for this answer
Official source · Agency guidance
K.1 UK Government, The AQuA BookThe AQuA Book requires analytical user documentation; the negative-control technique described here is an implementation choice, not a rule stated in that guidance.
All analysis shall have user documentation, even if the only user is the analyst leading the analysis.
See UK Government Analysis Function, The AQuA Book, §§ 2, 8.3 (2025 edition).
Why recalculate the XLSX outside the Python writer?
Writing formula text into an XLSX package is not the same as calculating it. The delivered workbook should be recalculated and inspected in the spreadsheet engine used for review so formula errors and engine differences are visible.
The generator can store deterministic formula caches for testing, but those caches do not prove that Excel or another spreadsheet engine agrees. Microsoft describes calculation as the process that computes formulas and displays their resulting values.
Verification should also scan calculated cells for errors such as #REF!, #DIV/0!, #VALUE!, and #NAME?. Inspect the exact file intended for delivery, not an earlier copy with the same name.
Sources for this answer
Vendor documentation
L.1 Microsoft Support, Change formula recalculation, iteration, or precision in ExcelMicrosoft distinguishes formulas stored in cells from the calculation process that computes and displays their results.
Calculation is the process of computing formulas and then displaying the results as values in the cells that contain the formulas.
See Microsoft Support, Change formula recalculation, iteration, or precision in Excel.
What should a deterministic structural snapshot cover?
At minimum, snapshot the sheet order, key formulas, formula-error scan, and all-checks-pass result. When refactoring a mature builder, compare recalculated workbooks cell by cell before removing the temporary compatibility fixture.
The snapshot is not a substitute for financial review. It is a regression tool that catches accidental changes in workbook topology and formulas. Pair it with negative controls, which answer a different question: whether the checks detect known failures.
Once a behavior-preserving refactor has been accepted and the new architecture is the only implementation, delete one-off comparison fixtures that require maintaining two builders. Keep the durable structural snapshot and behavioral controls.
Sources for this answer
Technical standard
M.1 ICAEW, How to Review a SpreadsheetICAEW distinguishes logic review from review of formulas and spreadsheet construction, supporting separate behavioral and structural verification.
Different approaches are needed to review the business logic and assumptions in a spreadsheet versus the formulas and construction of it – neither alone is sufficient.
See Institute of Chartered Accountants in England and Wales, How to Review a Spreadsheet, at 5.
What does the free Excel example include?
The downloadable example includes synthetic inputs, sources and uses, closing funds flow, a monthly operating cash-flow forecast, a neutral Party A and Party B cap table, ownership-and-returns calculations, and declared checks. It contains no client information or payment instructions.
The example is intended for inspection and adaptation. Its fictional values are not market terms, and its formulas do not determine whether a transaction is advisable. Replace every synthetic assumption with authorized, independently reviewed inputs for the specific transaction.
Download the free acquisition financial model Excel workbook, or use the same page to install the skill pack and inspect its scripts.
Sources for this answer
Internet resource
N.1 OpenAgreements synthetic acquisition financial modelThe downloadable workbook identifies itself as an illustrative modeling aid and contains the schedules described in this guide.
This workbook is an illustrative modeling aid. Confirm legal, tax, accounting, valuation, financing, and wire details with appropriate advisers.
See OpenAgreements, Synthetic Acquisition Financial Model example (2026).