Question
NetFlix 1) Follow the instructions Download Financial Statements and obtain the data from finance.yahoo.com. Note, just a screenshot or copy/paste into excel is sufficient, you
NetFlix
1) Follow the instructions Download Financial Statements and obtain the data from finance.yahoo.com. Note, just a screenshot or copy/paste into excel is sufficient, you do not need to subscribe to yahoo finance plus to download. 2) Using the information found on the Profile page of the company and other resources, write an introduction of the company as the cover page of the report. 3) Download balance sheet and income statement (aka statement of income or statement of operations) for years 2020 and 2021, add them to the report. Use the data for ratio analysis. 4) Refer to the textbook and use the data to perform Financial Statement Ratio Analysis for both 2020 and 2021. If there are missing items in the data, use zero for the calculation. This is likely to be the case for inventory turnover for service companies, etc. Calculate the following ratios: a) Net Working Capital b) Current Ratio c) Inventory turnover d) Accounts receivable turnover e) Accounts payable turnover f) Fixed asset turnover g) Total asset turnover h) Debt ratio i) Equity multiplier j) Times interest earned k) Profit margin 5) Compare the ratios of 2020 and 2021, explain if each ratio improved or deteriorated over time. The detailed analysis will be the most important part of your work and the textbook offers great help. Feel free to search internet for additional reports and analysis about the company and this information may help you understand why the ratios changed over time. A sentence or two for each line item is enough provided it addresses the trend. Required Material in Your Report: Part 1: Introduction to the company. Part 2: Balance Sheet and Income Statement for 2020 and 2021. Part 3: Ratio Analysis for each year with all the ratios listed above, items a-k. Part 4: Comparison of ratios over time with brief written analysis.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started