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

You can also buy tickets to participate in the future FMWC Stages here.

Product – Let us do the work for you!

Contact our team if you’re looking for additional support with your company’s financial needs! You can request model adjustments for any template found on our website or request a completely customized financial template with your company’s data (operational budgets, cashflow projections, valuation models, cost analysis and other models).

Our company has over 12 years of experience as outsourced CFOs creating and improving financial models for different industries. Over these years we have worked with 500+ companies from 20+ countries in the world. We bet you won’t be able to name an industry we haven’t made financial models for.

The customization services are performed by the same team of analysts that organizes the Financial Modeling World Cup (our group’s company). The Financial Modeling World Cup is the world’s largest financial modeling competition, enjoyed by top-class modelers from all over the world. Our team is trusted by such big names as Microsoft, the main sponsors of the tournament, and ESPN who broadcast the tournaments to TV audience. You can learn more about FMWC here.

We typically charge a fixed price, depending on the amount of work. The most popular pricing plans are $199, $749 and $1,499 (see details).

Drop us a line at info@cfotemplates.com and we’ll get back to you with an offer!

Have feedback or suggestions? Get in touch with our founder & CEO, Andrew Grigolyunovich, CFA: andrew@fmworldcup.com