Acquisition Planning Excel Model Template

Description
Timeline: up to 8 year rolling monthly and annual model with the ability to enter both actual and forecast data. The model start date and forecast start date of the model are flexible as are the units.

Outputs: Summary financials and margins, Dashboard, fully integrated Financial Statements (Income Statement, Balance Sheet and Cash Flow statement), net present value valuation (NPV), Igraph of cash flows and debt, indication of equity injection requirements

Assumptions:
Ability to enter historic Income Statement assumptions and an opening Balance Sheet on the Actuals tab for the platform asset
Acquisition planning assumptions include the acquisition name, the date of acquisition, the company value, the current adjusted EBITDA (profit before depreciation, amortisation, interest and tax charges), the ability to enter deferred payments (sometimes referred to as vendor loans), the ability for acquisition target management/owners to rollover/keep some of their equity, the ability to use a mix of senior debt vendor loans additional equity and existing group cash for acquisitions.
Simple platform and bolt on acquisition operating assumptions include the first forecast year sales, the annual growth rate thereafter, the gross margin, overhead as a percentage of sales, the actual fixed assets, and the annual capex spend.

Other assumptions include additional overhead cost and systergistic savings earned over time. Furthermore the user can enter fixed asset and capex assumptions, working capital days and VAT/sales tax assumptions, corporate/income tax assumptions, dividend withdrawal assumptions, CAPM and NPV valuation assumptions.