"Money to My Ears" - University Championship (Spring 2022)

Description
Financial Modeling University Championship is a great place to learn financial modeling, compete for a prize fund and get recognized for your finance skills! Students from all over the world come together to showcase their skills and become the best among their peers. The competition was jointly organized by the Financial Modeling World Cup and Eller College of Management. This and all future competitions are open to any student regardless of age, gender, race, place of living or any other limiting factor. The finals of the Spring 2022 competition were live-streamed on the Financial Modeling World Cup YouTube channel.

Case study 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 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; Excel file with initial data and case assumptions
-Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold

This model awarded 400 points, while the whole 2h Round allowed to earn 1,000 points in total.

You can also buy tickets to participate in the future FMWC Stages at https://www.fmworldcup.com/product-category/regular-competition/