SC_EX19_CS4-7a_MimiHoang_2.xlsx.xlsx - Author Note Do not...

This preview shows page 1 - 11 out of 25 pages.

Author:Note: Do
Victoria Streaming ServiceCONSOLIDATE DATA AND USE FINANCIAL FUNCTIONS, TABLES, AND CHARTSMimi HoangShelly Cashman Excel 2019| Modules 4-7: SAM Capstone Project 1ao not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAwebsite.
M
Victoria Streaming ServicUnited Statesin 000s2021 RevenueTypeQuarter 1Quarter 2Quarter 3Action12,873 13,869 15,904 Animation10,027 11,096 11,124 Comedy20,194 21,282 21,130 Drama9,489 10,036 10,799 Foreign6,406 6,789 5,239 TV shows20,397 21,656 22,244 Total$ 79,386.60 $ 84,727.86 $ 86,441.55
ceDate:4/27/2020Standard:$ 9.95 Quarter 4TotalQuarter 115,874 58,521.16 Increase revenue to11,006 43,253.26 84,309 21,216 83,821.72 Increase revenue by9,803 40,127.56 84,309 6,011 24,445.40 22,770 87,067.50 $ 86,680.59 $ 337,236.60
Premium:$ 12.95 2022 Revenue ProjectionsQuarter 2Quarter 3Quarter 4o 90,000 in Q4 86,206 88,103 90,000 y 2% per quarter85,995 87,715 89,470
Victoria Streaming ServicCanadain 000s2021 RevenueTypeQuarter 1Quarter 2Quarter 3Action9,069 9,083 9,120 Animation6,190 6,836 7,084 Comedy12,006 12,488 12,339 Drama10,908 11,056 11,144 Foreign7,731 7,792 8,046 TV shows9,707 10,796 10,824 Total$ 55,610.71 $ 58,051.43 $ 58,558.03
ceDate:4/27/2020Standard:$ 10.95 Quarter 4TotalQuarter 110,015 37,287.30 Increase revenue to6,408 26,518.84 57,891 12,411 49,244.36 Increase revenue by11,470 44,577.60 57,8918,174 31,743.15 10,866 42,193.71 $ 59,344.79 $ 231,564.96
Premium:$ 13.95 2022 Revenue ProjectionsQuarter 2Quarter 3Quarter 4o 60,000 in Q4 57,892 57,893 57,894 y 2% per quarter59,04960,23061,435
Victoria Streaming ServicUnited Kingdomin 000s2021 RevenueType

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture