Calculating the projected revenue for an artist is an important step in the music licensing agreement process as it will help the client understand the revenue they can expect to achieve year-on-year, as well YouTube's share of the revenue. For the purposes of this task, assume the average revenue per thousand (RPM) views on YouTube is USD$7.00 - meaning the average income for each video is USD$7.00 per thousand views. Please also assume that YouTube takes a 20% share of the revenue. Please take the following steps: o Step 1: Download the album performance forecasting spreadsheet template that can be found in the resource section of this task. Step 2: Calculate the year-on-year growth rate (%) of Alaska Hunter's self-titled album, 'Alaska Hunter (Deluxe)' based on the data from Task 1. Calculate the difference between the performance of 'Alaska Hunter (Deluxe)' in 2017- 2018, and 2018-2019. o Step 3: Download the spreadsheet that contains the total number of views that the Alaska Hunter's latest 2020 album titled 'Cold Shoulder' has had to date. Step 4: Using the calculations of the year-on-year growth rate (%) of Alaska Hunter's self-titled album, 'Alaska Hunter (Deluxe)', calculate the forecasted views and forecasted revenue generated by the artist's most recent album titled 'Cold Shoulder' in 2020, 2021 and 2022. o Step 5: Calculate YouTube's 20% share of the revenue generated by the artist's most recent album titled 'Cold Shoulder' in 2020, 2021 and 2022. Please include your research and analysis in the following template excel spreadsheet. A B D TASK 2: ALASKA HUNTER | ALBUM PERFORMANCE FORECASTING 1 2 3 Album performance 4 Year Album Total Views Total Revenue 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 Total Views Total Revenue 11 2017 Alaska Hunter (Deluxe) 12 2018 Alaska Hunter (Deluxe) 13 Difference: 14 Year 1 Growth Rate (%): 15 16 2018 Alaska Hunter (Deluxe) 17 2019 Alaska Hunter (Deluxe) 18 Difference: 19 Year 2 Growth Rate (%): 20 21 Cold Shoulder' album performance forcast for 2020 22 Year Album Views Revenue ($7/1000 views) 23 2020 Cold Shoulder 24 25 Cold Shoulder' album performance forecast from 2020-2022 Year Album Views Forecast Views 26 27 2020 1,615,119,648 Cold Shoulder Cold Shoulder 28 2021 29 2022 Cold Shoulder E F G YouTube's Share YouTube's Share YouTube's Share Forecast Revenue ($7/1000 views) Forecast YouTube's Share (20% of revenue) Calculating the projected revenue for an artist is an important step in the music licensing agreement process as it will help the client understand the revenue they can expect to achieve year-on-year, as well YouTube's share of the revenue. For the purposes of this task, assume the average revenue per thousand (RPM) views on YouTube is USD$7.00 - meaning the average income for each video is USD$7.00 per thousand views. Please also assume that YouTube takes a 20% share of the revenue. Please take the following steps: o Step 1: Download the album performance forecasting spreadsheet template that can be found in the resource section of this task. Step 2: Calculate the year-on-year growth rate (%) of Alaska Hunter's self-titled album, 'Alaska Hunter (Deluxe)' based on the data from Task 1. Calculate the difference between the performance of 'Alaska Hunter (Deluxe)' in 2017- 2018, and 2018-2019. o Step 3: Download the spreadsheet that contains the total number of views that the Alaska Hunter's latest 2020 album titled 'Cold Shoulder' has had to date. Step 4: Using the calculations of the year-on-year growth rate (%) of Alaska Hunter's self-titled album, 'Alaska Hunter (Deluxe)', calculate the forecasted views and forecasted revenue generated by the artist's most recent album titled 'Cold Shoulder' in 2020, 2021 and 2022. o Step 5: Calculate YouTube's 20% share of the revenue generated by the artist's most recent album titled 'Cold Shoulder' in 2020, 2021 and 2022. Please include your research and analysis in the following template excel spreadsheet. A B D TASK 2: ALASKA HUNTER | ALBUM PERFORMANCE FORECASTING 1 2 3 Album performance 4 Year Album Total Views Total Revenue 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 Total Views Total Revenue 11 2017 Alaska Hunter (Deluxe) 12 2018 Alaska Hunter (Deluxe) 13 Difference: 14 Year 1 Growth Rate (%): 15 16 2018 Alaska Hunter (Deluxe) 17 2019 Alaska Hunter (Deluxe) 18 Difference: 19 Year 2 Growth Rate (%): 20 21 Cold Shoulder' album performance forcast for 2020 22 Year Album Views Revenue ($7/1000 views) 23 2020 Cold Shoulder 24 25 Cold Shoulder' album performance forecast from 2020-2022 Year Album Views Forecast Views 26 27 2020 1,615,119,648 Cold Shoulder Cold Shoulder 28 2021 29 2022 Cold Shoulder E F G YouTube's Share YouTube's Share YouTube's Share Forecast Revenue ($7/1000 views) Forecast YouTube's Share (20% of revenue)