{"id":94694,"date":"2022-08-12T00:00:00","date_gmt":"2022-08-12T00:00:00","guid":{"rendered":"https:\/\/nursingstudybay.com\/2022\/08\/12\/financial-metrics-for-decision-making-2\/"},"modified":"2022-08-12T00:00:00","modified_gmt":"2022-08-12T00:00:00","slug":"financial-metrics-for-decision-making-2","status":"publish","type":"post","link":"https:\/\/www.colapapers.com\/assessments\/financial-metrics-for-decision-making-2\/","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=\"BhaHRYdjJn\"><p><a href=\"https:\/\/thestrategystory.com\/2020\/09\/13\/netflix-pivoting-business-model\/\" target=\"_blank\" rel=\"noopener\">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=U0YpSQehBI#?secret=BhaHRYdjJn\" data-secret=\"BhaHRYdjJn\" 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% of your final grade. \u2022 You must complete this assignment on an individual basis. \u2022 Deadline: Friday 14th October 2022, 11.59pm AEST (Sydney time) \u2022 [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1467,1463,1466,1464,1474,1473,1472,1471,1462,1468,1461,1469,1470,1465],"tags":[8856,8865,8861,8862,8860,8863,114,8857,8729,8859,31,8858,8864,8855,8854,8853],"class_list":["post-94694","post","type-post","status-publish","format-standard","hentry","category-academic-paper-writing-services","category-best-nursing-paper-writing-service","category-cheap-custom-essay-writing-service","category-help-with-writing-nursing-papers","category-nr","category-nur","category-nurs","category-nursing-dissertation-writers-help","category-nursing-paper-writing-service-in-3-hours","category-online-nursing-papers","category-paying-someone-to-write-a-paper","category-professional-nursing-essay-writers","category-reliable-nursing-writing-help","category-write-my-nursing-paper","tag-best-nursing-papers","tag-essay-on-good-health","tag-health-care-essays-from-students","tag-health-essay-in-english","tag-health-essay-sample-free-health-essays","tag-healthcare-essay-examples","tag-healthcare-essay-writing-service","tag-help-with-writing-an-essay","tag-medical-essay-writing-service-by-medical-professionals","tag-nursing-essay-papers","tag-nursing-essay-writing-service","tag-nursing-paper-writers","tag-nursing-paper-writing-services","tag-professional-nursing-writing-services","tag-short-essay-about-health-best-nursing-essay-writing-service","tag-short-essay-on-good-health"],"_links":{"self":[{"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/posts\/94694","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/comments?post=94694"}],"version-history":[{"count":0,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/posts\/94694\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/media?parent=94694"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/categories?post=94694"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.colapapers.com\/assessments\/wp-json\/wp\/v2\/tags?post=94694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}