andrew@agcapitalcfo.com

Stage 8 (2021) “Cats and Dogs”

Professional Excel Templates for your Business

Stage 8 (2021) "Cats and Dogs"

Cats and Dogs

This is an actual case from the Financial Modeling World Cup 2021, Stage 8 (August 20-23) competition. This case requires you to build a simple 3-way model, emphasizing sales and costs. It does not require revolver modeling, still, to get all the points, you should be able to put together the balance sheet.

Case description:

As a financial modeler, your objective is to create a 3-way financial projection model for Cat and Dog Food Inc. (C&D) and do a quick valuation for the company. The financial projection model should include a monthly P&L forecast for the next financial year based on the assumptions provided. You are also required to include the total numbers for the year in the financial model.

The challenge, in this case, is to create a financial projection model for C&D based on the given assumptions while ensuring that the cash balance is always positive. The model should also accurately reflect the company’s financial performance, taking into account various factors such as revenue, expenses, and taxes. Additionally, the model should be able to provide a quick valuation of the company, which requires accurate forecasting of the company’s future financial performance.

The downloadable file consists of the following:
Task: PDF file with Case Materials; PDF file with Questions; Excel file with Case Assumptions
Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold

This model awarded 400 regular points + 30 Extra Points for a bonus question, while the whole 2h Stage allowed to earn 1,150 points in total.

For your questions/suggestions/consideration please reach out to the Organizing Committee of the Financial Modeling World Cup at info@fmworldcup.com
You can also buy tickets to participate in the future FMWC Stages at https://fmworldcup.com/shop/

 

Reviews

There are no reviews yet.

Be the first to review “Stage 8 (2021) “Cats and Dogs””

Your email address will not be published. Required fields are marked *