Professional Excel Templates for your Business
FMUC - Round 1 - "Money to My Ears"
This is an actual case study that was presented to the participants of the Financial Modeling University Championship, Round 1 (April 2022).
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 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; 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 sign-up for the future MECC here.