Stage 4 (2021) “Roca Rola Rollover”

BSV Investing, a private equity firm, plans to invest in Roca Rola Co., a soft drink manufacturer, and wants to know the equity returns that can be realized if the company is acquired and sold after six years. Your role is to create a financial model to calculate equity returns for an LBO acquisition of Roca Rola Co. by BSV Investing.

This is an actual case from the Financial Modeling World Cup 2021, Stage 4 (Apr 16-19) competition. This case deals with a Leveraged Buyout (LBO) model. The competition showed that this is a topic that many participants are struggling with. Use this case to practice dealing with LBO’s.

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 full Solution Model; PDF file with correct Answers in Bold

This model awarded 550 regular points and 100 points for the 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