Mastering Financial Functions in Excel: A Capstone Guide
School
Northern Alberta Institute of Technology**We aren't endorsed by this school
Course
CMIS 1101
Subject
Accounting
Date
Dec 10, 2024
Pages
19
Uploaded by GrandNeutron15812
Author:
Victoria Streaming ServiceCONSOLIDATE DATA AND USE FINANCIAL FUNCTIONS, TABLES, AND CHARTSTanner VisserNote: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file froShelly Cashman Excel 2019| Modules 4-7: SAM Critical Thinking Capstone Project 1c
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:12/10/2024Standard:$ 9.95 Premium:2022 RevenuQuarter 4TotalQuarter 1Quarter 215,874 58,521.16 Increase revenue to 90,000 in Q4 11,006 43,253.26 84,309 86,206 21,216 83,821.72 Increase revenue by 2% per quarter9,803 40,127.56 84,309 85,995 6,011 24,445.40 22,770 87,067.50 $ 86,680.59 $ 337,236.60
$ 12.95 ue ProjectionsQuarter 3Quarter 488,103 90,000 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:12/10/2024Standard:$ 10.95 Premium:2022 RevenuQuarter 4TotalQuarter 1Quarter 210,015 37,287.30 Increase revenue to 60,000 in Q4 6,408 26,518.84 57,891 57,892 12,411 49,244.36 Increase revenue by 2% per quarter11,470 44,577.60 57,891 59,049 8,174 31,743.15 10,866 42,193.71 $ 59,344.79 $ 231,564.96
$ 13.95 ue ProjectionsQuarter 3Quarter 457,893 57,894 60,230 61,435
Victoria Streaming ServicUnited Kingdomin 000s2021 RevenueTypeQuarter 1Quarter 2Quarter 3Action9,653 9,705 9,808 Animation7,190 7,227 8,265 Comedy12,805 12,928 13,007 Drama10,498 11,611 11,652 Foreign9,713 9,799 9,886 TV shows10,228 10,282 10,335 Total$ 60,085.85 $ 61,552.39 $ 62,954.31
ceDate:12/10/2024Standard:$ 11.95 Premium:2022 RevenuQuarter 4TotalQuarter 1Quarter 29,812 38,978 Increase revenue to 65,000 in Q4 8,303 30,986 61,521 61,522 13,176 51,916 Increase revenue by 2% per quarter10,736 44,497 61,521 62,751 9,073 38,472 10,389 41,234 $ 61,489.84 $ 246,082.39
$ 14.95 ue ProjectionsQuarter 3Quarter 461,523 61,524 64,006 65,286
Victoria Streaming ServicAll Locationsin 000s2021 RevenueTypeQuarter 1Quarter 2Quarter 3Action31,594.80 32,657.24 34,832.15 Animation23,407.00 25,159.39 26,473.95 Comedy45,004.37 46,698.55 46,476.99 Drama30,894.80 32,702.56 33,595.51 Foreign23,849.88 24,380.33 23,171.36 TV shows40,332.31 42,733.61 43,403.93 Total195,084.00 $ 204,332.00 $ 207,954.00 TotaAction16.5%Anima12.4Comedy22.7%Drama15.9%Foreign11.6%TV shows20.9%
ceQuarter 4Total35,702.04 134,786.23 25,717.36 100,757.70 46,802.44 184,982.35 32,009.58 129,202.45 23,258.62 94,660.19 44,025.18 170,495.03 $ 207,516.00 $ 814,884.00 al revenue last year: 767,912.10 ation4%
IDProject NameProject TypeStart DateBudgetApproved?AC533Just SpiritsAction movie6/22$45,500Yes AC210Tension SunriseAction movie6/22$12,000No TV453Against the WallTV show7/22$22,500No TV697BayridgeTV show7/22$28,500Yes AC328The Castle Behind MeAction movie9/22$23,010No CO720Mack and MackComedy9/22$18,555No CO789Space PlumComedy10/22$25,000No CO329Karate NightComedy10/22$20,000Yes DR887Never in CommonDrama11/22$19,700No DR543All My FriendsDrama11/22$12,200No DR521A Great GetawayDrama1/23$31,500Yes CO325Teenage Miracle MileComedy1/23$24,000No DR512The Great GrasshopperDrama2/23$12,500No DR622Downtown Bike PathDrama2/23$15,000Yes TV482Because of WinstonTV show3/23$24,500No AC736Mad MusicAction movie3/23$10,000No AC447A Slight Case of SpringAction movie3/23$15,000No TV245Paradise MoonTV show3/23$14,000Yes 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 ProjectsIDProject NameProject TypeApproval DateBudgetApproved?
Project InformationProject IDTV245Project NameStart DateBudget> 15000Number of ProjectsProject TypeComedyAverage BudgetProject TypeNumberTotal BudgetAverage BudgetAction movieComedyDramaTV show
IDProject NameProject TypeStart DateBudgetAC533Just SpiritsAction movie6/2/2022$ 45,500 AC210Tension SunriseAction movie6/13/2022$ 12,000 TV453Against the WallTV show7/12/2022$ 22,500 TV697Bay ridgeTV show7/28/2022$ 28,500 AC328The Castle Behind MeAction movie9/1/2022$ 23,010 CO720Mack and MackComedy9/20/2022$ 18,555 CO789Space PlumComedy10/3/2022$ 25,000 CO329Karate NightComedy10/9/2022$ 20,000 DR887Never in CommonDrama11/1/2022$ 19,700 DR543All My FriendsDrama11/18/2022$ 12,200 DR521A Great GetawayDrama1/10/2023$ 31,500 CO325Teenage Miracle MileComedy1/13/2023$ 24,000 DR512The Great GrasshopperDrama2/22/2023$ 12,500 DR622Downtown Bike PathDrama2/28/2023$ 15,000 TV482Because of WinstonTV show3/3/2023$ 24,500 AC736Mad MusicAction movie3/13/2023$ 10,000 AC447A Slight Case of SpringAction movie3/19/2023$ 15,000 TV245Paradise MoonTV show3/20/2023$ 14,000 TV598Good Gold Bad BlueTV show3/23/2023$ 22,500 CO305Shark MythsComedy4/9/2023$ 19,500 CO220This Guy LaughedComedy4/12/2023$ 16,000 TV552Celeste and CeciliaTV show4/18/2023$ 50,000
Business ExpansionLoan CalculatorLoan Payment CalculatorDate10/12/2021Rate4.35%PurchaseDistribution centerTerm in Months180Price$ 2,150,000 Monthly Payment$ 13,026.41 Down Payment$ 430,000 Total Interest$ 624,753.96 Loan Amount$ 1,720,000 Total Cost$ 2,774,753.96 Varying Interest Rates and TermsRateNumber of Months$ 13,026 1201802403.85%3.95%4.05%4.15%4.25%4.35%4.45%4.55%4.65%4.75%4.85%4.95%5.05%
Scenarios10 Years15 Years5 YearsLoan Amount$ 1,720,000 $ 1,720,000 Annual Interest Rate4.45%4.40%4.55%Monthly Interest Rate0.37%0.37%0.38%Loan Period in Years10155Loan Period in Months12018060Start Date1/3/20221/3/20221/3/2022Monthly Payment$ (16,000)$ (20,000)Future Valuen/an/aCandidate PropertiesTypeContactStateMonths on Mkt