FMUC (2022) - Round 1 "Money To My Ears"

Description
Financial Modeling World Cup is an annual competition dedicated to financial modeling with a view of promoting healthy competition and education. FMWC challenges participants through a range of different types of questions. To answer everything correctly and win prizes, it takes a wide spectrum of skills and knowledge related to financial modeling. The competition is structured in a way that each participant accumulates points during the season by participating in as many Stages as they desire. At the end of the season (December), the overall winners are announced and the prize fund is distributed. Additional monthly prize money is distributed to the best-performing participants of each stage.


Money to My Ears case was premiered during the FMUC 2022 - Round 1.


Case description:
You have just started as an analyst at a music publishing company. The music publisher controls copyrights and collects royalties from many sources throughout the world. Royalties are earned when songs are used in various ways, such as broadcasts, streams, and sales. The publisher has paid advances of royalties to several songwriters and will recoup those advances from the royalties it collects.
Your job is first to organize the data such that you can calculate monthly revenue per songwriter. Second, you will analyze which songwriters have repaid their advances and calculate the publisher’s internal rate of return (IRR) on its investment in those songwriters.



The downloadable file consists of the following:
-Task: PDF file with Case Materials; PDF file with Questions
-Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold


You can also buy tickets to participate in the future MECC at https://www.fmworldcup.com/microsoft-excel-collegiate-challenge/