Stage 5 (2022) “Tesla’s Toil”

This is an actual case study that was presented to the participants of the Financial Modeling World Cup 2022, Stage 5 (July 22-25).

Case study description:
Your uncle, Nikola, has been doing some research on reducing his electricity bill. Until now he has not given energy usage much thought, but with electricity prices in the region rising, he is becoming more conscious about his monthly costs. He knows that you are a financial modeling wizard and would like your help in preparing an analysis of his estimated average monthly electricity consumption and the cost thereof. He would also like you to overlay some functionality to the model to help him assess the potential benefits of installing a solar and battery setup at his house to offset some of his consumption.

The downloadable file consists of the following:
–Task: PDF file with Case Materials; PDF file with Questions; Excel file with initial data and case assumptions
–Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold