andrew@agcapitalcfo.com

FMUC – Round 1 – “Money to My Ears”

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.

Reviews

There are no reviews yet.

Be the first to review “FMUC – Round 1 – “Money to My Ears””

Your email address will not be published. Required fields are marked *