excel capstone project
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:mark wester 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 ServiceDate: United StatesStandard:$ 9.95Premium:$ 12.95 in 000s 2021 Revenue2022 Revenue Projections TypeQuarter 1Quarter 2Quarter 3Quarter 4TotalQuarter 1 Action12,87313,86915,90415,87458,521.16Increase revenue to 90,000 in Q4 Animation10,02711,09611,12411,00643,253.2684,30990,000 Comedy20,19421,28221,13021,21683,821.72Increase revenue by 2% per quarter Drama9,48910,03610,7999,80340,127.5684,309 Foreign6,4066,7895,2396,01124,445.40 TV shows20,39721,65622,24422,77087,067.50 Total$ 79,386.60$ 84,727.86$ 86,441.55$ 86,680.59$ 337,236.60 Canada Victoria Streaming ServiceDate: CanadaStandard:$ 10.95Premium:$ 13.95 in 000s 2021 Revenue2022 Revenue Projections TypeQuarter 1Quarter 2Quarter 3Quarter 4TotalQuarter 1 Action9,0699,0839,12010,01537,287.30Increase revenue to 60,000 in Q4 Animation6,1906,8367,0846,40826,518.8457,891 Comedy12,00612,48812,33912,41149,244.36Increase revenue by 2% per quarter Drama10,90811,05611,14411,47044,577.6057,891 Foreign7,7317,7928,0468,17431,743.15 TV shows9,70710,79610,82410,86642,193.71 Total$ 55,610.71$ 58,051.43$ 58,558.03$ 59,344.79$ 231,564.96 U.K. Victoria Streaming ServiceDate: United KingdomStandard:$ 11.95Premium:$ 14.95 in 000s 2021 Revenue2022 Revenue Projections TypeQuarter 1Quarter 2Quarter 3Quarter 4TotalQuarter 1 Action9,6539,7059,8089,81238,978Increase revenue to 65,000 in Q4 Animation7,1907,2278,2658,30330,98661,521 Comedy12,80512,92813,00713,17651,916Increase revenue by 2% per quarter Drama10,49811,61111,65210,73644,49761,521 Foreign9,7139,7999,8869,07338,472 TV shows10,22810,28210,33510,38941,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 TypeQuarter 1Quarter 2Quarter 3Quarter 4Total 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 IDProject NameProject TypeStart DateBudgetApproved?Project Information AC533Just SpiritsAction movie6/22$45,500YesProject IDTV245 AC210Tension SunriseAction movie6/22$12,000NoProject Name TV453Against the WallTV show7/22$22,500NoStart Date TV697BayridgeTV show7/22$28,500Yes AC328The Castle Behind MeAction movie9/22$23,010NoBudget CO720Mack and MackComedy9/22$18,555No> 15000 CO789Space PlumComedy10/22$25,000NoNumber of Projects CO329Karate NightComedy10/22$20,000Yes DR887Never in CommonDrama11/22$19,700No DR543All My FriendsDrama11/22$12,200NoProject Type DR521A Great GetawayDrama1/23$31,500YesComedy CO325Teenage Miracle MileComedy1/23$24,000NoAverage Budget DR512The Great GrasshopperDrama2/23$12,500No DR622Downtown Bike PathDrama2/23$15,000YesProject TypeNumberTotal BudgetAverage Budget TV482Because of WinstonTV show3/23$24,500NoAction movie AC736Mad MusicAction movie3/23$10,000NoComedy AC447A Slight Case of SpringAction movie3/23$15,000NoDrama TV245Paradise MoonTV show3/23$14,000YesTV show TV598Good Gold Bad BlueTV show3/23$22,500No CO305Shark MythsComedy4/23$19,500Yes CO220This Guy LaughedComedy4/23$16,000No TV552Celeste and CeciliaTV show4/23$50,000Yes Approved Projects IDProject NameProject TypeApproval DateBudgetApproved? Subtotals IDProject NameProject TypeStart DateBudget AC533Just SpiritsAction movie6/2/22$ 45,500 AC210Tension SunriseAction movie6/13/22$ 12,000 TV453Against the WallTV show7/12/22$ 22,500 TV697Bay ridgeTV show7/28/22$ 28,500 AC328The Castle Behind MeAction movie9/1/22$ 23,010 CO720Mack and MackComedy9/20/22$ 18,555 CO789Space PlumComedy10/3/22$ 25,000 CO329Karate NightComedy10/9/22$ 20,000 DR887Never in CommonDrama11/1/22$ 19,700 DR543All My FriendsDrama11/18/22$ 12,200 DR521A Great GetawayDrama1/10/23$ 31,500 CO325Teenage Miracle MileComedy1/13/23$ 24,000 DR512The Great GrasshopperDrama2/22/23$ 12,500 DR622Downtown Bike PathDrama2/28/23$ 15,000 TV482Because of WinstonTV show3/3/23$ 24,500 AC736Mad MusicAction movie3/13/23$ 10,000 AC447A Slight Case of SpringAction movie3/19/23$ 15,000 TV245Paradise MoonTV show3/20/23$ 14,000 TV598Good Gold Bad BlueTV show3/23/23$ 22,500 CO305Shark MythsComedy4/9/23$ 19,500 CO220This Guy LaughedComedy4/12/23$ 16,000 TV552Celeste and CeciliaTV show4/18/23$ 50,000 Expansion Funding Business Expansion Loan Calculator Loan Payment CalculatorScenarios10 Years15 Years5 Years Date10/12/21Rate4.35%Loan Amount$ 1,720,000$ 1,720,000 PurchaseDistribution centerTerm in Months180Annual Interest Rate4.45%4.40%4.55% Price$ 2,150,000Monthly PaymentMonthly Interest Rate0.37%0.37%0.38% Down Payment$ 430,000Total InterestLoan Period in Years10155 Loan Amount$ 1,720,000Total CostLoan Period in Months12018060 Start Date1/3/221/3/221/3/22 Varying Interest Rates and TermsMonthly Payment$ (16,000)$ (20,000) RateNumber of MonthsFuture Valuen/an/a 120180240 3.85%Candidate Properties 3.95%TypeContactStateMonths on Mkt 4.05% 4.15% 4.25% 4.35% 4.45% 4.55% 4.65% 4.75% 4.85% 4.95% 5.05%