andrew@agcapitalcfo.com

Stage 2 (2020) “Charging Station”

Professional Excel Templates for your Business

Stage 2 (2020) "Charging Station"

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

Case description:

As a financial modeling consultant for GreenEnergo, the objective is to build a financial forecast for an “average” charging station the company is planning to open, which will be a part of its nationwide network of charging stations for electric car batteries. The financial forecast will include a 10-year monthly financial model, calculation of the project’s NPV and IRR, and determining the required level of state subsidies for the project to be economically feasible for GreenEnergo.

GreenEnergo plans to open a charging station and needs a financial model to forecast financials for the project before the full-scale nationwide rollout. The main challenge is to create a financial forecast for the charging station that can accurately predict the project’s profitability and feasibility over the next ten years. To create the financial forecast, several key assumptions need to be made regarding investment, bank loan, e-car market, and electricity sales.

The downloadable file consists of the following:
-Task: Excel file with given case assumptions; 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 400 points, 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 2 (2020) “Charging Station””

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