Acquisition Excel Model
Originally published: 18/05/2019 08:33
Last version published: 30/06/2020 16:31
Publication number: ELQ-62587-3
View all versions & Certificate

Acquisition Excel Model

A model to help plan and determine outcomes of acquiring different businesses

This model is currently being used by my fund to evaluate acquisition opportunities as they are discovered. Whether you are looking a purchasing a small side project or a full time business you will want to understand the likely outcomes as well as the cash needed to make the purchase and run the business.

Buying a business is a costly endeavor in terms of time and money. knowing what to expect from it over the years is a vital part of the decision making process that you don't want overlook.

This tool includes:
1) A backlog of available opportunities
2) Monthly Loan payment calculations
3) Monthly Cash needs calculations
4) Expected dividends and income on a % ownership basis
5) 10 year time horizon
6) Easy comparison between multiple opportunities
7) Easy to use sensitivity Analysis on key variables (interest rates, down payments, etc.)
8) Built in Links to a knowledge base of Finance/Accounting concepts to help you develop your skills
9) Rate of Return calculations and explanations to help you make the best decision possible
10) Variable acquisition and sale dates to allow for any scenario

The model has been built to be extremely simple to use while offering maximal flexibility and analysis.

This Best Practice includes
1 Excel Workbook

Acquire business license for $10.00

Add to cart

Add to bookmarks


Further information

To help determine the best business acquisition and loan terms

If you are looking at a business or multiple businesses to acquire and trying to understand potential outcomes and returns


  • Rate this Downloadable Best Practice

    Write a review

  • David Hamilton380(last updated: 04/06/2021 06:17)
  • Brandon Bruce, SSBBP, EMBA(last updated: 22/12/2020 13:19)
  • Mohd. Faizal Mohd. Zaki(last updated: 22/07/2020 13:04)
  • Díana Pena(last updated: 10/07/2020 14:42)
  • Jared Coleman(last updated: 04/03/2020 12:19)
  • Cody Hebert(last updated: 15/01/2020 21:25)
    Clearly see financial projections before the purchase.
    Instead of finding yourself 1-3 years into the business and still not financially stable, use this model to see if the business is worth the cost upfront!
  • Ayoub HS(last updated: 07/01/2020 17:36)


Discussion feed for Acquisition Excel Model

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

4.7 / 5 (7 votes)

please wait...