Vinyl Music Group is asking for an advance payment of $20M, which they calculated based on...

Transcribed Image Text:

Vinyl Music Group is asking for an advance payment of $20M, which they calculated based on the 2019 performance of Alaska Hunter's self-titled album, 'Alaska Hunter (Deluxe)'. Based on your findings from task 2, I'd like to invite you to determine whether YouTube should make the advance payment of $20M, and whether we should go ahead with this music licencing agreement. Please take the following steps: o Step 1: Refer to your data from task 2. • Step 2: Based on your data from task 2, calculate the forecasted revenue that Vinyl Music Group would earn for 'Cold Shoulder' in 2020: ▪ Calculate YouTube's projected total revenue and Vinyl Music Group's share of the projected total revenue for 'Cold Shoulder'. ▪ Determine whether YouTube should make the advance payment of $20M to Vinyl Music Group. When you have completed this final calculation, you will need to create a slideshow presentation to present your findings: • Step 1: Create a graph that illustrates the projected cut of the revenue Alaska Hunter's 'Cold Shoulder' album YouTube will receive between 2020 and 2022 (based on your findings from task 2). • Step 2: Prepare a slideshow presentation (approximately 5 slides) that captures the research and analysis you have performed in the previous tasks. The presentation should include the following: ■ Title page; ■ Executive summary; Graph and insights (include the graph you created above); ▪ Explanation of data analysis; ▪ Recommendations based on findings. B 1 2 A TASK 2: ALASKA HUNTER | ALBUM PERFORMANCE FORECASTING B Album performance 20 21 3 4 Year Album 5 2017 Alaska Hunter (Deluxe) 6 2018 Alaska Hunter (Deluxe) 7 2019 Alaska Hunter (Deluxe) 8 9 Year-on-year album performance 10 Year Album 11 2017 12 2018 13 14 15 16 2018 17 2019 18 19 Alaska Hunter (Deluxe) Alaska Hunter (Deluxe) Difference: Year 1 Growth Rate (%): Alaska Hunter (Deluxe) Alaska Hunter (Deluxe) Difference: Year 2 Growth Rate (%): с Total Views 511677238 703230114 26 27 2020 Cold Shoulder 28 2021 Cold Shoulder 29 2022 Cold Shoulder 30 $ 1105508566 $ Total Views 511677238 703230114 Total Revenue $ $ 191552876 $ 37% Cold Shoulder' album performance forcast for 2020 22 Year Album Views 23 2020 Cold Shoulder 703230114 $ 1105508566 $ 402278452 $ 57% Total Revenue $ 1,615,119,648 D 24 25 Cold Shoulder' album performance forecast from 2020-2022 Year Album Views 1,615,119,648 205,120,195. 279,783,946 3,581,671.00 4,922,611.00 4,822,622.00 3,581,671.00 4,922,611.00 1,340,940.00 37% 4,922,611.00 4,822,622.00 99,989.00 Revenue ($7/1000 views) Forecast Views 0% 1,615,119,648 22,212,713,918 43,478,386,280 YouTube's Share 716335 984623 984561 YouTube's Share E 716335 984623 984623 984561 YouTube's Share $268,288.00 37% -62 0% F Forecast Revenue ($7/1000 views) Forecast YouTube's Share (20% of revenue) 11305837.54 $15,488,997.43 $24,387,703.96 2261168 $3,097,799.00 $2,871,395.00 G Vinyl Music Group is asking for an advance payment of $20M, which they calculated based on the 2019 performance of Alaska Hunter's self-titled album, 'Alaska Hunter (Deluxe)'. Based on your findings from task 2, I'd like to invite you to determine whether YouTube should make the advance payment of $20M, and whether we should go ahead with this music licencing agreement. Please take the following steps: o Step 1: Refer to your data from task 2. • Step 2: Based on your data from task 2, calculate the forecasted revenue that Vinyl Music Group would earn for 'Cold Shoulder' in 2020: ▪ Calculate YouTube's projected total revenue and Vinyl Music Group's share of the projected total revenue for 'Cold Shoulder'. ▪ Determine whether YouTube should make the advance payment of $20M to Vinyl Music Group. When you have completed this final calculation, you will need to create a slideshow presentation to present your findings: • Step 1: Create a graph that illustrates the projected cut of the revenue Alaska Hunter's 'Cold Shoulder' album YouTube will receive between 2020 and 2022 (based on your findings from task 2). • Step 2: Prepare a slideshow presentation (approximately 5 slides) that captures the research and analysis you have performed in the previous tasks. The presentation should include the following: ■ Title page; ■ Executive summary; Graph and insights (include the graph you created above); ▪ Explanation of data analysis; ▪ Recommendations based on findings. B 1 2 A TASK 2: ALASKA HUNTER | ALBUM PERFORMANCE FORECASTING B Album performance 20 21 3 4 Year Album 5 2017 Alaska Hunter (Deluxe) 6 2018 Alaska Hunter (Deluxe) 7 2019 Alaska Hunter (Deluxe) 8 9 Year-on-year album performance 10 Year Album 11 2017 12 2018 13 14 15 16 2018 17 2019 18 19 Alaska Hunter (Deluxe) Alaska Hunter (Deluxe) Difference: Year 1 Growth Rate (%): Alaska Hunter (Deluxe) Alaska Hunter (Deluxe) Difference: Year 2 Growth Rate (%): с Total Views 511677238 703230114 26 27 2020 Cold Shoulder 28 2021 Cold Shoulder 29 2022 Cold Shoulder 30 $ 1105508566 $ Total Views 511677238 703230114 Total Revenue $ $ 191552876 $ 37% Cold Shoulder' album performance forcast for 2020 22 Year Album Views 23 2020 Cold Shoulder 703230114 $ 1105508566 $ 402278452 $ 57% Total Revenue $ 1,615,119,648 D 24 25 Cold Shoulder' album performance forecast from 2020-2022 Year Album Views 1,615,119,648 205,120,195. 279,783,946 3,581,671.00 4,922,611.00 4,822,622.00 3,581,671.00 4,922,611.00 1,340,940.00 37% 4,922,611.00 4,822,622.00 99,989.00 Revenue ($7/1000 views) Forecast Views 0% 1,615,119,648 22,212,713,918 43,478,386,280 YouTube's Share 716335 984623 984561 YouTube's Share E 716335 984623 984623 984561 YouTube's Share $268,288.00 37% -62 0% F Forecast Revenue ($7/1000 views) Forecast YouTube's Share (20% of revenue) 11305837.54 $15,488,997.43 $24,387,703.96 2261168 $3,097,799.00 $2,871,395.00 G

Answer rating: 100% (QA)

To address the question presented we need to analyze the data from the provided spreadsheet to determine whether YouTube should make an advance paymen... View the full answer