Complete the Netflix Incorporated Spreadsheet with your calculations of the
indicated (green boxes) financial ratios. Calculate your financial ratios for the
spreadsheet from the PDF files of the company’s Income Statements and
Balance Sheets for Fiscal 2016-2020 attached to this unit in Blackboard
(Mergent Online Financial Statements).
NOTE: Use the “Commonly Used Financial Ratios” PDF file formulas for the
financial ratio calculations.
NOTE: Netflix Inc.’s 2020 Fiscal Year Ended 12/31/2020.
NOTE: Use the Property & Equipment, Net line on the balance sheet for
Fixed Assets.
NOTE: Use the Net Earnings (Loss) per share – diluted line as the answer for
the EPS (diluted) line on your spreadsheet.
TIP: Use n=4 in your CAGR calculation.
Submission Instructions:
Upload one file to Blackboard, the completed spreadsheet (.XLS or .XLSX format)
NOTE: Do not submit .PDF files for this assignment.
0 comments