Overview

CFI FinMo competition for 2020. This submission achieved 3rd place in the World Championship. In 2020 competitors had to act as an Investment Banking Analyst advising The Coca-Cola Company. Creating M&A financial model to evaluate the target companies and determine which investment case will be most attractive to the acquirer. Concentrating on the transaction outcomes and structure. The following deliverables are available:

  • Financial Model – excel based template, valuing the acquirer and target companies;
  • Pitch Deck – presentation of the analysis with the transaction recommendation;
  • Power BI – dynamic presentation in the visualization tool;

Financial model includes the 3 types of valuations: discounted cash flow, comparable multiples and comparable transactions. To present comprehensive accretion / dilution analyses the sensitivities macro is introduced. Apart from Power BI visualisation model incorporates the excel based visuals.

If you are looking for more project finance templates please follow the links below:

  • Project Finance Base – flexible Project Finance model - applicable to any industry - https://marketplace.corporatefinanceinstitute.com/financial-model-templates/project-finance-model-base/
  • Project Finance Power BI – dynamic Dashboard for the project finance.
  • Project Finance Unlimited Scenarios – unlimited amount of scenarios and cost profiles - https://marketplace.corporatefinanceinstitute.com/financial-model-templates/project-finance-model-unlimited-scenarios/
  • Project Finance Advanced Timeline - flexible timeline including the developing stage - https://marketplace.corporatefinanceinstitute.com/financial-model-templates/project-finance-model-advanced-timeline/
Reviews Add a review
No reviews yet

More From Samir Asadov

Browse our top rated business templates. See All
Mortgage Calculator
2,534
0
 The unique tool will help you to make the optimal decision and pick the best mortgage. The model follows the…
Event Table Allocator
3,226
0
In the modern work environment to benefit the most from the events (Christmas Dinner, team-building sessions, client conferences), organizers are…
Project Finance Model - Advanced Senior Debt
3,025
0
This project finance model is an advance version of the model you can find under the following link: https://marketplace.corporatefinanceinstitute.com/financial-model-templates/project-finance-model-base/ The…
Project Finance Model - Dynamic Excel Visualization
3,343
0
This project finance model is an advance version of the model you can find under the following link: https://marketplace.corporatefinanceinstitute.com/financial-model-templates/project-finance-model-base/ It…
Project Finance Model - Scenarios & Ratios & Timeline
3,509
0
This project finance model is an advanced version of the model you can find under the following link: https://www.eloquens.com/tool/yZ54Hr1A/finance/project-finance-models/project-financing-model-scenarios-ratios It…
Project Finance Model - Scenarios & Ratios
3,363
0
This project finance model is an advance version of the model you can find under the following link: https://www.eloquens.com/tool/XvxKFxl5/finance/project-finance-models/project-finance-model-unlimited-scenarios It…
See All