CFI - FinMo 2020
Originally published: 22/12/2020 08:51
Publication number: ELQ-72861-1
View all versions & Certificate
certified

CFI - FinMo 2020

3rd place in the Financial Modelling Competition

Description
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://www.eloquens.com/tool/7jq0HrME/finance/project-finance-models/project-finance-model-base
• Project Finance Power BI – dynamic Dashboard for the project finance - https://www.eloquens.com/tool/bbwpsd4l/engineering/power-bi-models/project-finance-model-power-bi
• Project Finance Unlimited Scenarios – unlimited amount of scenarios and cost profiles - https://www.eloquens.com/tool/XvxKFxl5/finance/project-finance-models/project-finance-model-unlimited-scenarios
• Project Finance Advanced Timeline - flexible timeline including the developing stage - https://www.eloquens.com/tool/vvAztVyg/finance/project-finance-models/project-finance-model-advanced-timeline

This Best Practice includes
1 Excel based model, 1 Power BI file, 1 Excel Data file, 1 PDF presentation

Acquire business license for $3.00

Add to cart

Add to bookmarks

Discuss

Reviews

  • Rate this Downloadable Best Practice

    Write a review

  • Hafizal Aziz(last updated: 24/12/2020 08:07)
  • Amir Ganic(last updated: 23/12/2020 09:43)

keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Samir Asadov CFA

keyboard_arrow_leftkeyboard_arrow_right

Related categories


See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on CFI - FinMo 2020?

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


4.5 / 5 (2 votes)

please wait...