Acquisition Planning Excel Model Template
  • Acquisition Planning Excel Model Template
  • Acquisition Planning Excel Model Template
  • Acquisition Planning Excel Model Template
  • Acquisition Planning Excel Model Template
  • Acquisition Planning Excel Model Template
  • Acquisition Planning Excel Model Template
  • Acquisition Planning Excel Model Template
  • Acquisition Planning Excel Model Template
Originally published: 18/01/2019 10:39
Last version published: 18/01/2019 10:41
Publication number: ELQ-58059-2
View all versions & Certificate
certified

Acquisition Planning Excel Model Template

Acquisition planning model for up to 10 bolt on acquisitions (assumes that you already own the platform asset)

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.

This Best Practice includes
1 powerpoint slide of instructions, 1 excel model template

Acquire business license for $90.00

Add to cart

Add to bookmarks

Discuss

Further information

To help an investor to plan bolt-on acquisitions to an existing base to better understand cash and funding requirements
To calculate a valuation of the enhanced group following subsequent bolt on

For use by someone who works in private equity, corporate finance, internal M&A, M&A, corporate development, start-ups, anyone looking to purchase a privately owned business
Someone with a good understanding of corporate finance, accounting and how models work

Where the user does not have experience of using models
Where the user wants proper business consolidation accounting - this model take a high level approach to the integration of each bolt on acquisition
Where the user is not financially literate
Where the user also needs to assess the acquisition of the platform asset (we have an alternative model for this called: Platform & bolt on acquisition planning model)

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from ModellingGuy

See all
keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Acquisition Planning Excel Model Template

The user community and author are here to help. Go ahead!

  • DANNAH BLIN
    Hi, how to change the currency (units) from £ 000 into $ 000 (US dollars)
    arrow_drop_uparrow_drop_downReply reply
    • Ashley Boonin
      Hi Dannah - thank you for your question. I refer you to our private message. For other users this is found in the grouped section at the top of the assumptions page.
      arrow_drop_uparrow_drop_downReply reply


    0.0 / 5 (0 votes)

    please wait...