Franchise Acquisition Model
  • Franchise Acquisition Model
  • Franchise Acquisition Model
  • Franchise Acquisition Model
  • Franchise Acquisition Model
  • Franchise Acquisition Model
  • Franchise Acquisition Model
  • Franchise Acquisition Model
  • Franchise Acquisition Model
  • Franchise Acquisition Model
Originally published: 14/09/2019 12:12
Last version published: 25/10/2019 20:18
Publication number: ELQ-76749-3
View all versions & Certificate
certified

Franchise Acquisition Model

Franchise Acquisition Excel Model - Based on Orange Theory Studios

Description
So you want to build a franchise empire. This model allows you to input upfront capital costs, expected revenues drivers, expenses, and more to see how timing and quantity of acquired franchises impacts future returns.

Scenarios and sensitivities are built in, and all charts are linked, allowing you to immediately evaluate different outcomes and strategies.

To use this model, simply input your revenue and expense drivers, the number of desired franchise units, and the number of desired franchises. If so desired, you can populate different cases to see how cash flows are impacted by differing assumptions. Changing between scenarios is easy, simply type the number of the scenario you wish to run.

All changeable inputs are available on the drivers tab. The rest of the model is calculation driven, therefore there is no need to make additional changes. The build tab allows you to see the layering of additional franchises. The model tab sums the total of all franchises. Finally the summary tab gives a high-level annual view of total revenues, expenses, cash flows, etc. At the bottom of the summary tab, I incorporated return metrics based on varying discount rates, as well as four relevant charts that dynamically update based on the assumptions and case flowing through the model.

This Best Practice includes
1 Excel Model

Prather Financial offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews

  • Be the first to review this Downloadable Tool

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Franchise Acquisition Model?

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


0.0 / 5 (0 votes)

please wait...