{"id":47639,"date":"2022-10-18T06:09:58","date_gmt":"2022-10-18T06:09:58","guid":{"rendered":"https:\/\/www.essaybishops.co.uk\/financial-metrics-for-decision-making\/"},"modified":"2022-10-18T06:09:58","modified_gmt":"2022-10-18T06:09:58","slug":"financial-metrics-for-decision-making","status":"publish","type":"post","link":"https:\/\/www.essaybishops.com\/essays\/financial-metrics-for-decision-making\/","title":{"rendered":"Financial Metrics for Decision Making"},"content":{"rendered":"<p>Page 1 of 6<br \/>\nBusiness Case<br \/>\n25624 Financial Metrics for Decision Making<br \/>\nSpring session 2022<br \/>\nPage 2 of 6<br \/>\nGeneral information and instructions<br \/>\n\u2022 This business case accounts for 40% of your final grade.<br \/>\n\u2022 You must complete this assignment on an individual basis.<br \/>\n\u2022 Deadline: Friday 14th October 2022, 11.59pm AEST (Sydney time)<br \/>\n\u2022 You need to submit via Canvas:<br \/>\no A written report<br \/>\n\u25aa .pdf format only<br \/>\n\u25aa The report should answer each of the questions<br \/>\no An Excel spreadsheet<br \/>\n\u25aa .xlsx format only<br \/>\n\u25aa The spreadsheet must contain all calculations you perform in the Revenue<br \/>\nworksheet.<br \/>\n\u25aa Aim to structure and format your Excel solution in the most efficient way<br \/>\npossible and use financial modelling best practices.<br \/>\n\u2022 This task includes a milestone assessment component that evaluates academic English<br \/>\nlanguage proficiency. You may be guided to further language support after the completion<br \/>\nof this subject if your results in this milestone task indicate you need more help with your<br \/>\nlanguage skills.<br \/>\n\u2022 All assignment-related queries must be posted on the Canvas discussion board.<br \/>\nE-mail queries related to the assignment will not be entertained.<br \/>\nFrom prior experience, technical difficulties often can be traced back to students trying to<br \/>\nupload their work a few minutes prior to the deadline. Tip: do not wait until 11.55pm on<br \/>\n14th Oct to submit your work via Canvas. Late submissions will receive zero credit unless a<br \/>\nspecial consideration with valid reasons and documentation is filed.<br \/>\nGrading<br \/>\n\u2022 Both components (the written report and the Excel spreadsheet) will be graded.<br \/>\n\u2022 The written report will be marked based on the<br \/>\n\u2022 The Excel spreadsheet will be marked based on the efficiency and clarity with which<br \/>\nsolutions are produced.<br \/>\n\u2022 Late submissions will receive zero credit unless a special consideration with valid rea- sons<br \/>\nand documentation is filed.<br \/>\nData<br \/>\n\u2022 In the Assignment page on Canvas, you will find the workbook Netflix Revenue Model.xlsx.<br \/>\nThe workbook contains quarterly revenue and subscriptions data from September 2018 to<br \/>\nJune 2022.<br \/>\n\u2022 Perform your calculations based on the data in these spreadsheets.<br \/>\n\u2022 Search for additional data as required.<br \/>\nPage 3 of 6<br \/>\nNetflix\u2019s Latest Pivot<br \/>\nNetflix success is largely attributed to the company\u2019s ability to pivot their business model. The first<br \/>\npivot was when the company shifted their DVD home delivery service to becoming the leading online<br \/>\nstreaming platform. More recently, the second pivot was in response to the inherent risk of being a<br \/>\ncontent distribution platform: content producers could refuse to deliver their content via Netflix<br \/>\n(Disney, Paramount, etc.). Netflix response was to become a content creation business themselves1<br \/>\n.<br \/>\nBoth pivots were successfully landed, providing Netflix with a sustained increase in subscriptions. The<br \/>\ncompany\u2019s reflexes are now being put to the test once again, this time as a more mature business.<br \/>\nIn the first quarter of 2022, Netflix lost subscribers for the first time in 10 years. The drop came after<br \/>\nthe growth experienced throughout the pandemic, gaining millions of users per quarter through 2021.<br \/>\nThe decline in number of subscribers adds to the trouble the company faces because of the large<br \/>\nnumber of households sharing their accounts with families and friends. In response, Netflix began<br \/>\nexperimenting with a feature that monitors whether someone accesses an account from outside the<br \/>\nhome and offers the ability to raise the price by adding &#8216;sub-accounts&#8217; for other people.<br \/>\nDuring the Q1 2022 earnings call, Netflix\u2019s management unveiled that they were considering rolling<br \/>\nout an ad-supported tier to re-ignite subscription growth &#8211; especially in UCAN (USA and Canada). The<br \/>\nmarket feels much more penetrated given the COVID pulled-forward bump2<br \/>\n. Instead of paying the full<br \/>\nsubscription, Netflix will offer the possibility of paying less in exchange for watching ads, thus<br \/>\n1 Misra, A. 2020. Netflix \u2013 Constantly Pivoting its Business Model to Success. Sep 13, 2020.<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"uZhLLTMmU1\"><p><a href=\"thestrategystory.com\/2020\/09\/13\/netflix-pivoting-business-model\/\">Netflix \u2013 Constantly Pivoting its Business Model to Success<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Netflix \u2013 Constantly Pivoting its Business Model to Success&#8221; &#8212; The Strategy Story\" src=\"https:\/\/thestrategystory.com\/2020\/09\/13\/netflix-pivoting-business-model\/embed\/#?secret=2syWJFWxY2#?secret=uZhLLTMmU1\" data-secret=\"uZhLLTMmU1\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><br \/>\n2 Wells Fargo, 2022. Equity research. NFLX: The AVOD Devil Is in the Detail. Jun 3, 2022.<br \/>\nhttps:\/\/wellsfargo.bluematrix.com\/docs\/pdf\/d5ef4344-9429-4eb6-bdda-382f2a44ad57.pdf<br \/>\nPage 4 of 6<br \/>\neliminating one of the great advantages of the streaming service over traditional television. The<br \/>\ntimeline to introduce this new subscription tier has been brought forward a couple of times.<br \/>\nNetflix is the most expensive streaming service, compared to rivals from giants like Disney and<br \/>\nAmazon, especially if we want the full experience with the best video and sound quality. So-called<br \/>\n&#8216;sub-accounts&#8217; and new ad-supported subscriptions will become the cheapest way to use Netflix3<br \/>\n.<br \/>\nIn addition to these measures, Netflix executives want to increase their presence in markets outside<br \/>\nthe United States, where growth is stronger, producing more local content and improving the quality<br \/>\nof its series.<br \/>\nThe company faces several potential ways forward:<br \/>\n\u2022 Remaining a pure Subscription video-on-demand (SVOD) player<br \/>\n\u2022 Introducing a second subscription tier with the Advertising video-on-demand (AVOD) model<br \/>\n\u2022 Opening sub-accounts to monetise the large segment of password-sharing users<br \/>\nIn this context, it is worth evaluating the potential impacts each combination of products will have on<br \/>\nthe company\u2019s revenue stream. Please use the Excel workbook provided to do a quarterly revenue<br \/>\n3 Translated by Content Engine LLC. (2022). Netflix loses users for the first time in a decade and plans to<br \/>\nintroduce advertising. CE Noticias Financieras.<br \/>\nhttps:\/\/www.proquest.com\/docview\/2653220902?parentSessionId=jwgbxZhsHdcKlLloJSTvkPJOu7bpZkXvzVVl<br \/>\nWN5YZPk%3D&amp;pq-origsite=primo&amp;accountid=17095<br \/>\nPage 5 of 6<br \/>\nforecast for Netflix from September 2022 to June 2025 under each scenario described in the<br \/>\nquestions.<br \/>\nIn each scenario, you can search for data to support your assumptions. This Wells Fargo Equity<br \/>\nResearch report could be of great use.<br \/>\nRead the report<br \/>\nPlease make you to reference your sources and to form your own views and not to simply \u201ccopy and<br \/>\npaste\u201d from reports.<br \/>\nQUESTION 1. DISCUSSION ON FORECASTING TECHNICS [4 marks]<br \/>\nBefore you build your own Revenue forecasts, please watch these two videos created by a tutor who<br \/>\nused Netflix to teach forecasting using:<br \/>\n\u2022 Holt\u2019s Method https:\/\/youtu.be\/55_vmSIba3A, and<br \/>\n\u2022 Regression model https:\/\/youtu.be\/089eZCuBhtg<br \/>\nIn the written report, use bullet points to:<br \/>\n\u2022 highlight the main limitations in using these technics<br \/>\n\u2022 propose amendments to the methods to make them more appropriate to forecast Netflix\u2019s<br \/>\nrevenue<br \/>\n\u2022 This question does not have a spreadsheet component.<br \/>\nQUESTION 2. FORECAST REVENUE | PURE SVOD PLAYER [6 marks]<br \/>\n\u2022 Assuming Netflix decides to add maintain their current business model as is, please use the<br \/>\n\u201cQuestion 2\u201d section in the Revenue worksheet to do a quarterly revenue forecast for<br \/>\nNetflix from September 2022 to June 2025.<br \/>\n\u2022 Include any inputs and assumptions in the Inputs worksheet<br \/>\n\u2022 This question does not have a written report component.<br \/>\nPage 6 of 6<br \/>\nQUESTION 3. FORECAST REVENUE | SVOD and AVOD [8 marks]<br \/>\n\u2022 Assuming Netflix decides to add a second subscription tier with the Advertising video-on demand (AVOD) model, please use the \u201cQuestion 3\u201d section in the Revenue worksheet to do<br \/>\na quarterly revenue forecast for Netflix from September 2022 to June 2025.<br \/>\n\u2022 Include any inputs and assumptions in the Inputs worksheet.<br \/>\n\u2022 Make sure you at least account for:<br \/>\no cannibalisation across products,<br \/>\no new potential customers and<br \/>\no different attrition rates by product<br \/>\no advertising revenue<br \/>\n\u2022 This question does not have a written report component.<br \/>\nQUESTION 4. FORECAST REVENUE | SVOD, AVOD AND SUB-ACCOUNTS [8 marks]<br \/>\n\u2022 Assuming Netflix decides to:<br \/>\no add a second subscription tier with the Advertising video-on-demand (AVOD) model,<br \/>\no add sub-accounts for \u201csharing-password\u201d customers<br \/>\nplease use the \u201cQuestion 4\u201d section in the Revenue worksheet to do a quarterly<br \/>\nrevenue forecast for Netflix from September 2022 to June 2025.<br \/>\n\u2022 Include any inputs and assumptions in the Inputs worksheet.<br \/>\n\u2022 Make sure you at least account for:<br \/>\no cannibalisation across products,<br \/>\no new potential customers and<br \/>\no different attrition rates by product<br \/>\no advertising revenue<br \/>\n\u2022 This question does not have a written report component.<br \/>\nQUESTION 5. OUTPUTS [6 marks]<br \/>\n\u2022 In the Outputs worksheet, please use tables and charts to report the key results of your<br \/>\nanalysis.<br \/>\n\u2022 Please include any sensitivity analysis you judge relevant<br \/>\n\u2022 This question does not have a written report component.<br \/>\nQUESTION 6. DISCUSS YOUR FINDINGS [6 marks]<br \/>\nIn the written report, use bullet points to:<br \/>\n\u2022 Discuss your main findings<br \/>\n\u2022 Propose a way forward to the Netflix management<br \/>\nQUESTION 7. FINANCIAL MODELLING BEST PRACTICES [2 marks]<br \/>\nThe use of financial modelling best practices in the revenue model, inputs and outputs will be<br \/>\nmarked in this question.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Page 1 of 6 Business Case 25624 Financial Metrics for Decision Making Spring session 2022 Page 2 of 6 General information and instructions \u2022 This business case accounts for 40%\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6892,6891,6894,6893],"tags":[576,6606,630,596,594,610,625,434],"class_list":["post-47639","post","type-post","status-publish","format-standard","hentry","category-custom-same-day-essays","category-custom-writings-writers","category-do-my-essay-mla-format","category-write-my-paper-hub-writers","tag-best-dissertation-writing-services","tag-best-research-paper-writing-services","tag-college-paper-writing-service","tag-dissertation-writing-services-cost","tag-dissertation-writing-services-near-me","tag-dissertation-writing-services-reviews","tag-legit-research-paper-writing-services","tag-thesis-writing-services"],"_links":{"self":[{"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/posts\/47639","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/comments?post=47639"}],"version-history":[{"count":0,"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/posts\/47639\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/media?parent=47639"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/categories?post=47639"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.essaybishops.com\/essays\/wp-json\/wp\/v2\/tags?post=47639"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}