Step 1: You have been assigned Netflix Company' from Yahoo Finance communication services. Step 2: Collect annual reports of the assigned company Step 3: Please calculate all ratios that was covered in Chapter 3 for Netflix Company and show your workings in an Excel file but use the final values in your main report. Step 4: Investigation Year- From 2016 to 2019 (Before Covid19) and 2020 (After Covid19 attack / during pandemic). Total 5 year ratios. (Note: in yahoo finance the financial reports are only given starting from 2017. For 2016 or for all the five years you can download the annual reports by searching in google. Step 5: Explain and analyze the ratios (you have calculated in step 3) by emphasizing before and after the Covid19 attack. Step 6: Use graphs, charts in your analysis. Step 7: Submission date will be on 215 August, 2021, Saturday. You have to submit the soft copy of your report and excel file, you must also attach the required financial statements of the company. As of December 31, 2017 2016 S 2.822.795 $ 4,310,934 536,245 7,669,974 10,371,055 319,404 652,309 19,012,742 1,467,576 266,206 3,726,307 260,202 5,720,291 7,274,501 250,395 341,423 13,586,610 $ S Assets Current assets: Cash and cash equivalents Short-term investments Current content assets, net Other current assets Total current assets Non-current content assets, net Property and equipment, net Other non-current assets Total assets Liabilities and Stockholders' Equity Current liabilities: Current content liabilities Accounts payable Accrued expenses Deferred revenue Total current liabilities Non-current content liabilities Long-term debt Other non-current liabilities Total liabilities Commitments and contingencies (Note 5) Stockholders' equity: Preferred stock, $0.001 par value; 10,000,000 shares authorized at December 31, 2017 and 2016; no shares issued and outstanding at December 31, 2017 and 2016 Common stock, $0.001 par value; 4,990,000,000 shares authorized at December 31, 2017 and December 31, 2016, respectively; 433,392,686 and 430,054,212 issued and outstanding at December 31, 2017 and December 31, 2016, respectively Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 4,173,041 359,555 315,094 618,622 5,40 312 3,329,796 6,499,432 135,246 15,430,786 3,632,711 312,842 197,632 443,472 4,586,657 2,894,654 3,364,311 61,188 10,906,810 1,871,396 (20,557) 1,731,117 3,581,956 19,012,742 1,599,762 (48,565) 1,128,603 2,679,800 13,586,610 S $ As of December 31, 2019 2018 Assets $ 5,018,437 1,160,067 6,178,504 24,504,567 565,221 2,727,420 33,975,712 3,794,483 5,151,186 748,466 9,694,135 14,951,141 418,281 910,843 25,974,400 $ $ $ S Current assets: Cash and cash equivalents Current content assets, net Other current assets Total current assets Non-current content assets, net Property and equipment, net Other non-current assets Total assets Liabilities and Stockholders' Equity Current liabilities: Current content liabilities Accounts payable Accrued expenses and other liabilities Deferred revenue Total current liabilities Non-current content liabilities Long-term debt Other non-current liabilities Total liabilities Commitments and contingencies (Note 5) Stockholders' equity Preferred stock, $0.001 par value; 10,000,000 shares authorized at December 31, 2019 and 2018; no shares issued and outstanding at December 31, 2019 and 2018 Common stock, $0.001 par value; 4,990,000,000 shares authorized at December 31, 2019 and December 31, 2018, respectively; 438,806,649 and 436,598,597 issued and outstanding at December 31, 2019 and December 31, 2018, respectively Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 4,413,561 674,347 843,043 924,745 6,855,696 3,334,323 14,759,260 1,444,276 26,393,555 4,681,562 562,985 481,874 760,899 6,487,320 3,759,026 10,360,058 129,231 20,735,635 2,793,929 (23,521) 4,811,749 7,582,157 33,975,712 2,315,988 (19,582) 2,942,359 5,238,765 25,974,400 $ As of December 31, 2020 2019 8,205,550 $ 1,556,030 9,761,580 25,383,950 960,183 3,174,646 39,280,359 5,018,437 1,160,067 6,178,504 24,504,567 565,221 2,727,420 33,975,712 S $ 4,413,561 674,347 843,043 924,745 Assets Current assets: Cash and cash equivalents Other current assets Total current assets Content assets, net Property and equipment, net Other non-current assets Total assets Liabilities and Stockholders' Equity Current liabilities: Current content liabilities Accounts payable Accrued expenses and other liabilities Deferred revenue Short-term debt Total current liabilities Non-current content liabilities Long-term debt Other non-current liabilities Total liabilities Commitments and contingencies (Note 7) Stockholders' equity: Preferred stock, $0.001 par value; 10,000,000 shares authorized at December 31, 2020 and 2019, no shares issued and outstanding at December 31, 2020 and 2019 Common stock, 0.001 par value; 4,990,000,000 shares authorized at December 31, 2020 and December 31, 2019, respectively; 442,895,261 and 438,806,649 issued and outstanding at December 31, 2020 and December 31, 2019, respectively Accumulated other comprehensive income (loss) Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 4,429,536 $ 656,183 1,102,196 1,117,992 499,878 7,805,785 2,618,084 15,809,095 1,982,155 28,215,119 6,855,696 3,334,323 14,759,260 1,444,276 26,393,555 3,447,698 44,398 7,573,144 11,065,240 39,280,359 2,793,929 (23,521) 4,811,749 7,582,157 33,975,712 S Step 1: You have been assigned Netflix Company' from Yahoo Finance communication services. Step 2: Collect annual reports of the assigned company Step 3: Please calculate all ratios that was covered in Chapter 3 for Netflix Company and show your workings in an Excel file but use the final values in your main report. Step 4: Investigation Year- From 2016 to 2019 (Before Covid19) and 2020 (After Covid19 attack / during pandemic). Total 5 year ratios. (Note: in yahoo finance the financial reports are only given starting from 2017. For 2016 or for all the five years you can download the annual reports by searching in google. Step 5: Explain and analyze the ratios (you have calculated in step 3) by emphasizing before and after the Covid19 attack. Step 6: Use graphs, charts in your analysis. Step 7: Submission date will be on 215 August, 2021, Saturday. You have to submit the soft copy of your report and excel file, you must also attach the required financial statements of the company. As of December 31, 2017 2016 S 2.822.795 $ 4,310,934 536,245 7,669,974 10,371,055 319,404 652,309 19,012,742 1,467,576 266,206 3,726,307 260,202 5,720,291 7,274,501 250,395 341,423 13,586,610 $ S Assets Current assets: Cash and cash equivalents Short-term investments Current content assets, net Other current assets Total current assets Non-current content assets, net Property and equipment, net Other non-current assets Total assets Liabilities and Stockholders' Equity Current liabilities: Current content liabilities Accounts payable Accrued expenses Deferred revenue Total current liabilities Non-current content liabilities Long-term debt Other non-current liabilities Total liabilities Commitments and contingencies (Note 5) Stockholders' equity: Preferred stock, $0.001 par value; 10,000,000 shares authorized at December 31, 2017 and 2016; no shares issued and outstanding at December 31, 2017 and 2016 Common stock, $0.001 par value; 4,990,000,000 shares authorized at December 31, 2017 and December 31, 2016, respectively; 433,392,686 and 430,054,212 issued and outstanding at December 31, 2017 and December 31, 2016, respectively Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 4,173,041 359,555 315,094 618,622 5,40 312 3,329,796 6,499,432 135,246 15,430,786 3,632,711 312,842 197,632 443,472 4,586,657 2,894,654 3,364,311 61,188 10,906,810 1,871,396 (20,557) 1,731,117 3,581,956 19,012,742 1,599,762 (48,565) 1,128,603 2,679,800 13,586,610 S $ As of December 31, 2019 2018 Assets $ 5,018,437 1,160,067 6,178,504 24,504,567 565,221 2,727,420 33,975,712 3,794,483 5,151,186 748,466 9,694,135 14,951,141 418,281 910,843 25,974,400 $ $ $ S Current assets: Cash and cash equivalents Current content assets, net Other current assets Total current assets Non-current content assets, net Property and equipment, net Other non-current assets Total assets Liabilities and Stockholders' Equity Current liabilities: Current content liabilities Accounts payable Accrued expenses and other liabilities Deferred revenue Total current liabilities Non-current content liabilities Long-term debt Other non-current liabilities Total liabilities Commitments and contingencies (Note 5) Stockholders' equity Preferred stock, $0.001 par value; 10,000,000 shares authorized at December 31, 2019 and 2018; no shares issued and outstanding at December 31, 2019 and 2018 Common stock, $0.001 par value; 4,990,000,000 shares authorized at December 31, 2019 and December 31, 2018, respectively; 438,806,649 and 436,598,597 issued and outstanding at December 31, 2019 and December 31, 2018, respectively Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 4,413,561 674,347 843,043 924,745 6,855,696 3,334,323 14,759,260 1,444,276 26,393,555 4,681,562 562,985 481,874 760,899 6,487,320 3,759,026 10,360,058 129,231 20,735,635 2,793,929 (23,521) 4,811,749 7,582,157 33,975,712 2,315,988 (19,582) 2,942,359 5,238,765 25,974,400 $ As of December 31, 2020 2019 8,205,550 $ 1,556,030 9,761,580 25,383,950 960,183 3,174,646 39,280,359 5,018,437 1,160,067 6,178,504 24,504,567 565,221 2,727,420 33,975,712 S $ 4,413,561 674,347 843,043 924,745 Assets Current assets: Cash and cash equivalents Other current assets Total current assets Content assets, net Property and equipment, net Other non-current assets Total assets Liabilities and Stockholders' Equity Current liabilities: Current content liabilities Accounts payable Accrued expenses and other liabilities Deferred revenue Short-term debt Total current liabilities Non-current content liabilities Long-term debt Other non-current liabilities Total liabilities Commitments and contingencies (Note 7) Stockholders' equity: Preferred stock, $0.001 par value; 10,000,000 shares authorized at December 31, 2020 and 2019, no shares issued and outstanding at December 31, 2020 and 2019 Common stock, 0.001 par value; 4,990,000,000 shares authorized at December 31, 2020 and December 31, 2019, respectively; 442,895,261 and 438,806,649 issued and outstanding at December 31, 2020 and December 31, 2019, respectively Accumulated other comprehensive income (loss) Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 4,429,536 $ 656,183 1,102,196 1,117,992 499,878 7,805,785 2,618,084 15,809,095 1,982,155 28,215,119 6,855,696 3,334,323 14,759,260 1,444,276 26,393,555 3,447,698 44,398 7,573,144 11,065,240 39,280,359 2,793,929 (23,521) 4,811,749 7,582,157 33,975,712 S