Question

1 Approved Answer

Posted on Jul 15, 2024

please use above graphs and input requrired info in template provided below!! PLEASE DO I WILL THUMBS UP!!! 2015 2016 2017 2018 2019 $1,809.3 5,431.8

please use above graphs and input requrired info in template provided below!! PLEASE DO I WILL THUMBS UP!!! image text in transcribed

2015 2016 2017 2018 2019 $1,809.3 5,431.8 $ 1,467.6 5,720.3 $ 2.822.8 7,670,0 $ 3,794,5 9,694.1 $ 5,018,4 6.178.5 Selected Balance Sheet Data Cash and cash equivalents Current assets Total current and non-current content assets Total assets Current liabilities Long-term debt" Stockholders' equity Cash Flow Data Net cash (used in provided by operating activities Net cash provided by (used in) investing activities Net cash provided by (used in) financing activities 7.218.8 10,202.9 3,529,6 2,371.4 2.223.4 14,682.0 13,586,6 4,586.7 3,3643 2,679.8 20.112 20 19,012.7 5,466,3 6,499.4 3,582.0 20.107.5 25.974,4 6,487.3 10,360.1 5,238,8 $24,504.5 33.975.7 6,855.7 14.759.3 7,5822 $(1.474.0) $ (749.4) $(1.785.9) $(2.680.5) $ (2.887.3) 49.8 (179.2) 34.3 (339.1) (387.1) 1,091.3 1.640.3 3,077.0 4,048.5 4,505.7 2017 2016 2018 2019 2015 $6.779.5 $8,830.7 $11,692.7 $15.794.3 $20,156.4 4.591.5 2,188.0 6,257.5 2.800.8 7,659.7 4,033.0 9.967.5 5.826.8 12,440.2 7.716.2 Revenues Cost of revenues (almost all of which relates to amortization of content assets) Gross profit Operating expenses Technology and development Marketing General and administrative Total operating expenses Operating income Interest and other income (expense) Income before income taxes Provision for (benefit from) income taxes Net income Net income per share: Basic Diluted Weighted average common shares outstanding (in millions) Basic Diluted 650.8 824.1 407.3 1.8822 305.8 (163.9) 141.9 19.2 $ 122.6 780.2 1,097.5 315.7 2,421.0 379.8 30.8 260.5 73.8 $ 186.7 1,052.8 1,278.0 863.6 3,194.4 838.7 (591.5) 485.3 (73.6) 558.9 1.221.8 2,369.5 630.3 4.221.6 1,605.2 (378.80 1,226.5 15.2 $ 1.211.2 1.545.1 2,652.5 914,4 5.112.0 2,604.3 (542.0) 2,062.2 195.3 1,866.9 $ $ $ $ $ 0.29 0.28 0.44 0.43 1.29 1.25 2.78 2.68 4.26 4.13 425.9 436.5 428.8 438.7 431.9 446.8 435.4 451.2 437.8 451.8 Balance Sheet Year 1 Year 2 Year 3 Year Current Assets Inventory Fixed or Non-Current Assets Total Assets Current Llabilities CAGR example Long Term Debt Total Uabilities Shareholders Equity Retained Earnings 15 14 12 10 Income Statement 173 144 120 100 101 57 55 15 15 15 15 Sales or Revenues CAGR example Cost of Good Sold Gross Profit General & Administrative (G&A) Research & Development (R&D) Interest Expense Depreciation Allowance Total Operating Expenses Net Operating Profit Income Tax EBIT EBITDA Net Profit (Income) Common Sire Example 17.3 12 9.4 8.5 Cash Flow Statement Cash from Operations Selected Key Ratios - formulae on accompanying worksheet in this Year 1 Year 2 Year 3 Profitability Ratios Sear4 Efficiency Ratios Liquidity Ratios Leverage Ratios Operating measures Market Value & Investment Ratios OTHER RELEVANT FINANCIALLY RELATED INFO FROM OTHER EXHIBITS IN CASE Relevant info these may require different approaches e. Relevant info Relevant info Relevant info ust and craft their own as necessary with appropriate cell formulae as nec the points you make in the Financial Analysis Section in the Appendix Year 5 CAGR Trend Year 3 Yeard Common Size Balance Sheet Year 1 Year 2 Current Assets Fixed Assets Total Assets 100% 100% 100% 100% 19 Current Liabilities Long term Liabilities Equity L.E 100% 100% 100% 100% Common Sire Income Statement Year 1 Year 2 100% 100% Year 4 Year 3 100% 100% 135 58.4% 57.5% 64 55.8% 55.0% DO) 15 8.7% 10.4% 12.5% 15.0% 10.0% 78% 8.3% 11.2 8.5% document Year 5 Trend 2015 2016 2017 2018 2019 $1,809.3 5,431.8 $ 1,467.6 5,720.3 $ 2.822.8 7,670,0 $ 3,794,5 9,694.1 $ 5,018,4 6.178.5 Selected Balance Sheet Data Cash and cash equivalents Current assets Total current and non-current content assets Total assets Current liabilities Long-term debt" Stockholders' equity Cash Flow Data Net cash (used in provided by operating activities Net cash provided by (used in) investing activities Net cash provided by (used in) financing activities 7.218.8 10,202.9 3,529,6 2,371.4 2.223.4 14,682.0 13,586,6 4,586.7 3,3643 2,679.8 20.112 20 19,012.7 5,466,3 6,499.4 3,582.0 20.107.5 25.974,4 6,487.3 10,360.1 5,238,8 $24,504.5 33.975.7 6,855.7 14.759.3 7,5822 $(1.474.0) $ (749.4) $(1.785.9) $(2.680.5) $ (2.887.3) 49.8 (179.2) 34.3 (339.1) (387.1) 1,091.3 1.640.3 3,077.0 4,048.5 4,505.7 2017 2016 2018 2019 2015 $6.779.5 $8,830.7 $11,692.7 $15.794.3 $20,156.4 4.591.5 2,188.0 6,257.5 2.800.8 7,659.7 4,033.0 9.967.5 5.826.8 12,440.2 7.716.2 Revenues Cost of revenues (almost all of which relates to amortization of content assets) Gross profit Operating expenses Technology and development Marketing General and administrative Total operating expenses Operating income Interest and other income (expense) Income before income taxes Provision for (benefit from) income taxes Net income Net income per share: Basic Diluted Weighted average common shares outstanding (in millions) Basic Diluted 650.8 824.1 407.3 1.8822 305.8 (163.9) 141.9 19.2 $ 122.6 780.2 1,097.5 315.7 2,421.0 379.8 30.8 260.5 73.8 $ 186.7 1,052.8 1,278.0 863.6 3,194.4 838.7 (591.5) 485.3 (73.6) 558.9 1.221.8 2,369.5 630.3 4.221.6 1,605.2 (378.80 1,226.5 15.2 $ 1.211.2 1.545.1 2,652.5 914,4 5.112.0 2,604.3 (542.0) 2,062.2 195.3 1,866.9 $ $ $ $ $ 0.29 0.28 0.44 0.43 1.29 1.25 2.78 2.68 4.26 4.13 425.9 436.5 428.8 438.7 431.9 446.8 435.4 451.2 437.8 451.8 Balance Sheet Year 1 Year 2 Year 3 Year Current Assets Inventory Fixed or Non-Current Assets Total Assets Current Llabilities CAGR example Long Term Debt Total Uabilities Shareholders Equity Retained Earnings 15 14 12 10 Income Statement 173 144 120 100 101 57 55 15 15 15 15 Sales or Revenues CAGR example Cost of Good Sold Gross Profit General & Administrative (G&A) Research & Development (R&D) Interest Expense Depreciation Allowance Total Operating Expenses Net Operating Profit Income Tax EBIT EBITDA Net Profit (Income) Common Sire Example 17.3 12 9.4 8.5 Cash Flow Statement Cash from Operations Selected Key Ratios - formulae on accompanying worksheet in this Year 1 Year 2 Year 3 Profitability Ratios Sear4 Efficiency Ratios Liquidity Ratios Leverage Ratios Operating measures Market Value & Investment Ratios OTHER RELEVANT FINANCIALLY RELATED INFO FROM OTHER EXHIBITS IN CASE Relevant info these may require different approaches e. Relevant info Relevant info Relevant info ust and craft their own as necessary with appropriate cell formulae as nec the points you make in the Financial Analysis Section in the Appendix Year 5 CAGR Trend Year 3 Yeard Common Size Balance Sheet Year 1 Year 2 Current Assets Fixed Assets Total Assets 100% 100% 100% 100% 19 Current Liabilities Long term Liabilities Equity L.E 100% 100% 100% 100% Common Sire Income Statement Year 1 Year 2 100% 100% Year 4 Year 3 100% 100% 135 58.4% 57.5% 64 55.8% 55.0% DO) 15 8.7% 10.4% 12.5% 15.0% 10.0% 78% 8.3% 11.2 8.5% document Year 5 Trend