Office

profileeaglebird
SC_EX19_CS4-7a_myname_2.xlsx
Home>Applied Sciences homework help>Office

Documentation

Shelly Cashman Excel 2019 | Modules 4-7: SAM Capstone Project 1a
Victoria Streaming Service
CONSOLIDATE DATA AND USE FINANCIAL FUNCTIONS, TABLES, AND CHARTS
Author: ME j.r.
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.

U.S.

Victoria Streaming Service Date:
United States Standard: $ 9.95 Premium: $ 12.95
in 000s
2021 Revenue 2022 Revenue Projections
Type Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Quarter 1
Action 12,873 13,869 15,904 15,874 58,521.16 Increase revenue to 90,000 in Q4
Animation 10,027 11,096 11,124 11,006 43,253.26 84,309 90,000
Comedy 20,194 21,282 21,130 21,216 83,821.72 Increase revenue by 2% per quarter
Drama 9,489 10,036 10,799 9,803 40,127.56 84,309
Foreign 6,406 6,789 5,239 6,011 24,445.40
TV shows 20,397 21,656 22,244 22,770 87,067.50
Total $ 79,386.60 $ 84,727.86 $ 86,441.55 $ 86,680.59 $ 337,236.60

Canada

Victoria Streaming Service Date:
Canada Standard: $ 10.95 Premium: $ 13.95
in 000s
2021 Revenue 2022 Revenue Projections
Type Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Quarter 1
Action 9,069 9,083 9,120 10,015 37,287.30 Increase revenue to 60,000 in Q4
Animation 6,190 6,836 7,084 6,408 26,518.84 57,891
Comedy 12,006 12,488 12,339 12,411 49,244.36 Increase revenue by 2% per quarter
Drama 10,908 11,056 11,144 11,470 44,577.60 57,891
Foreign 7,731 7,792 8,046 8,174 31,743.15
TV shows 9,707 10,796 10,824 10,866 42,193.71
Total $ 55,610.71 $ 58,051.43 $ 58,558.03 $ 59,344.79 $ 231,564.96

U.K.

Victoria Streaming Service Date:
United Kingdom Standard: $ 11.95 Premium: $ 14.95
in 000s
2021 Revenue 2022 Revenue Projections
Type Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Quarter 1
Action 9,653 9,705 9,808 9,812 38,978 Increase revenue to 65,000 in Q4
Animation 7,190 7,227 8,265 8,303 30,986 61,521
Comedy 12,805 12,928 13,007 13,176 51,916 Increase revenue by 2% per quarter
Drama 10,498 11,611 11,652 10,736 44,497 61,521
Foreign 9,713 9,799 9,886 9,073 38,472
TV shows 10,228 10,282 10,335 10,389 41,234
Total $ 60,085.85 $ 61,552.39 $ 62,954.31 $ 61,489.84 $ 246,082.39

All Locations

Victoria Streaming Service
All Locations
in 000s
2021 Revenue
Type Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total
Action - 0
Animation - 0
Comedy - 0
Drama - 0
Foreign - 0
TV shows - 0
Total $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total revenue last year:

Original Content

ID Project Name Project Type Start Date Budget Approved? Project Information
AC533 Just Spirits Action movie 6/22 $45,500 Yes Project ID TV245
AC210 Tension Sunrise Action movie 6/22 $12,000 No Project Name
TV453 Against the Wall TV show 7/22 $22,500 No Start Date
TV697 Bayridge TV show 7/22 $28,500 Yes
AC328 The Castle Behind Me Action movie 9/22 $23,010 No Budget
CO720 Mack and Mack Comedy 9/22 $18,555 No > 15000
CO789 Space Plum Comedy 10/22 $25,000 No Number of Projects
CO329 Karate Night Comedy 10/22 $20,000 Yes
DR887 Never in Common Drama 11/22 $19,700 No
DR543 All My Friends Drama 11/22 $12,200 No Project Type
DR521 A Great Getaway Drama 1/23 $31,500 Yes Comedy
CO325 Teenage Miracle Mile Comedy 1/23 $24,000 No Average Budget
DR512 The Great Grasshopper Drama 2/23 $12,500 No
DR622 Downtown Bike Path Drama 2/23 $15,000 Yes Project Type Number Total Budget Average Budget
TV482 Because of Winston TV show 3/23 $24,500 No Action movie
AC736 Mad Music Action movie 3/23 $10,000 No Comedy
AC447 A Slight Case of Spring Action movie 3/23 $15,000 No Drama
TV245 Paradise Moon TV show 3/23 $14,000 Yes TV show
TV598 Good Gold Bad Blue TV show 3/23 $22,500 No
CO305 Shark Myths Comedy 4/23 $19,500 Yes
CO220 This Guy Laughed Comedy 4/23 $16,000 No
TV552 Celeste and Cecilia TV show 4/23 $50,000 Yes
Approved Projects
ID Project Name Project Type Approval Date Budget Approved?

Subtotals

ID Project Name Project Type Start Date Budget
AC533 Just Spirits Action movie 6/2/22 $ 45,500
AC210 Tension Sunrise Action movie 6/13/22 $ 12,000
TV453 Against the Wall TV show 7/12/22 $ 22,500
TV697 Bay ridge TV show 7/28/22 $ 28,500
AC328 The Castle Behind Me Action movie 9/1/22 $ 23,010
CO720 Mack and Mack Comedy 9/20/22 $ 18,555
CO789 Space Plum Comedy 10/3/22 $ 25,000
CO329 Karate Night Comedy 10/9/22 $ 20,000
DR887 Never in Common Drama 11/1/22 $ 19,700
DR543 All My Friends Drama 11/18/22 $ 12,200
DR521 A Great Getaway Drama 1/10/23 $ 31,500
CO325 Teenage Miracle Mile Comedy 1/13/23 $ 24,000
DR512 The Great Grasshopper Drama 2/22/23 $ 12,500
DR622 Downtown Bike Path Drama 2/28/23 $ 15,000
TV482 Because of Winston TV show 3/3/23 $ 24,500
AC736 Mad Music Action movie 3/13/23 $ 10,000
AC447 A Slight Case of Spring Action movie 3/19/23 $ 15,000
TV245 Paradise Moon TV show 3/20/23 $ 14,000
TV598 Good Gold Bad Blue TV show 3/23/23 $ 22,500
CO305 Shark Myths Comedy 4/9/23 $ 19,500
CO220 This Guy Laughed Comedy 4/12/23 $ 16,000
TV552 Celeste and Cecilia TV show 4/18/23 $ 50,000

Expansion Funding

Business Expansion
Loan Calculator
Loan Payment Calculator Scenarios 10 Years 15 Years 5 Years
Date 10/12/21 Rate 4.35% Loan Amount $ 1,720,000 $ 1,720,000
Purchase Distribution center Term in Months 180 Annual Interest Rate 4.45% 4.40% 4.55%
Price $ 2,150,000 Monthly Payment Monthly Interest Rate 0.37% 0.37% 0.38%
Down Payment $ 430,000 Total Interest Loan Period in Years 10 15 5
Loan Amount $ 1,720,000 Total Cost Loan Period in Months 120 180 60
Start Date 1/3/22 1/3/22 1/3/22
Varying Interest Rates and Terms Monthly Payment $ (16,000) $ (20,000)
Rate Number of Months Future Value n/a n/a
120 180 240
3.85% Candidate Properties
3.95% Type Contact State Months on Mkt
4.05%
4.15%
4.25%
4.35%
4.45%
4.55%
4.65%
4.75%
4.85%
4.95%
5.05%