andrew@agcapitalcfo.com

Stage 3 (2020) “Power-Up Builders”

Professional Excel Templates for your Business

Stage 3 (2020) "Power-Up Builders"

This is a case from the Financial Modeling World Cup 2020, Stage 3 (Nov 20-23) competition. It can be used to expand your knowledge of financial modeling and train for future FMWC Stages.

Case description:

To create a high-level forecast for Power-Up Builders, Inc. (PUB) to determine whether the company can finance its plan to increase sales four times in 2021, and to design a flexible financial model that can instantly recalculate PUB’s financial projections according to different contract combinations.

PUB’s completed contracts for 2020 amounted to 50 million Evergreen Dollars (EGD). However, the company now has contracts for almost 200 million EGD for 2021, which would require a fast pace of growth. PUB must decide whether to attract investor financing or grow at a slower pace to finance this expansion, as bankruptcy is inevitable otherwise. The CEO is reluctant to attract investor money, so a financial model is needed to determine if PUB can finance the expansion through its own resources.

The downloadable file consists of the following:
-Task: Excel file with given case assumptions and model template; PDF file with Case Materials; PDF file with Questions.
-Solution: Excel file with the full Solution Model; PDF file with correct Answers in Bold.

This model awarded 450 points + 100 Extra points for the bonus question, while the whole 2h Stage allowed to earn 1,000 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 3 (2020) “Power-Up Builders””

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