Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question : 53. preform ratio analyst using the ratios. you should present them in a similar format as the text: group by category, list name
Question : 53.
preform ratio analyst using the ratios. you should present them in a similar format as the text: group by category, list name of ratio, formula in words, and the ratio calculation. Give a short explanation of your conclusion about the company after each category of ratio. ( i.e. How liquid is your company? How efficiently is it using it's assets? ECT. ).
Paste Merge & Center - Format Painter ter BIU- Clipboard Conditional Format as Cell Formatting Table Styles - Styles Font Alignment Number 020 F G H I J K L DISCOVERY, INC. CONSOLIDATED BALANCE SHEETS (in millions, except par value) N- December 31, 2018 2017 Common Size Analysis 2018 217 Horizontal Analysis $ Change % Change 986 2,620 313 312 4,231 3,069 7,309 1,838 410 434 9,991 2,213 597 7,073 1,770 335 576 22,555 3.03% 32.41% 8.05% 8.15% 0.96% 1.82% 0.96% 1.92% 13.00% 44.30% 9.43% 9.81% 2.46% 2.65% 39.96% 31.36% 29.72% 7.85% 2.87% 1.49% 2.57% 2.55% 100.00% 100.00% (6323) 782 (97) (122) (5760) 856 203 5933 7904 600 259 9995 -86.51% 42.55% 23.66% -28.11% -57.65% 38.68% 34.00% 83.88% 446.55% 179.10% 44.97% 44.31% 800 13,006 9,674 935 835 32,550 6 Assets 7 Current assets: 8 Cash and cash equivalents 9 Receivables, net 10 Content rights, net 11 Prepaid expenses and other current assets 12 Total current assets 13 Noncurrent content rights, net 14 Property and equipment, net 15 Goodwill 16 Intangible assets, net 17 Equity method investments including note receivable 18 Other noncurrent assets 19 Total assets 20 LIABILITIES AND EQUITY 21 Curent liabilities 22 Accounts payable 23 Accrued liabilities 24 Deferred revenues 25 Curent portion of debt 26 Total current liabilities 27 Noncurrent portion of debt 28 Deferred income taxes 29 Other noncurrent liabilities 30 Total liabilities 31 Commitments and contingencies (See Note 22) 22. Emrity Sheet1 Sheet2 Sheet3 Ready 325 1,563 249 1,860 3,997 15,185 1,811 1,040 22,033 277 1,309 255 30 1,871 14,755 319 587 17,532 1.00% 4.80% 0.76% 5.71% 12.28% 46.65% 5.56% 3.20% 67.69% 1.23% 5.80% 1.13% 0.13% 8.30% 65.42% 1.41% 2.60% 77.73% 48 254 (6) 1,830 2,126 430 1,492 453 4,501 17.33% 19.40% -2.35% 6100.00% 113.63% 2.91% 467.71% 77.17% 25.67% Type here to search Calibri General BIU - Ba Copy Format Painter Clipboard - S.A. 2. Wrap Text Merge & Center - Paste $. % . Inser Conditional Format as Cell Formatting Table Styles - Styles Font Alignment Number 020 X H C D 1,860 3 0 3,997 1,871 15,185 14,755 1,8113 19 1,040587 22,033 17,532 5.71% 12.28% 46.65% 5.56% 3.20% 67.69% G 0.13% 8.30% 65.42% 1.41% 2.60% 77.73% 1,830 6100.00% 2,126 113.63% 4302.91% 1,492467.71% 453 77.17% 4,501 25.67% 25 Current portion of debt 26 Total current habilities 27 Noncurrent portion of debt 28 Deferred income taxes 29 Other noncurrent liabilities 30 Total liabilities 31 Commitments and contingencies (See Note 22) 32 Equity 33 Discovery, Inc. stockholders' equity Series A-1 convertible preferred stock. $0.01 par value; 34 8 shares authorized issued, and outstanding Series C-1 convertible preferred stock. $0.01 par vahe: 6 shares authorized, issued, and outstanding 0.00% 0.00% #DIV/0! oo - 35 0.00% 0.00% O #DIV/0! 0.01% 0.00% 100.00% ON 0.00% 0.00% 0 #DIV/0! Series A common stock $0.01 par value; 1,700 shares authorized: 160 and 157 shares issued; and 157 and 154 36 shares outstanding Series B convertible common stock $0.01 par value, 100 37 shares authorized; 7 shares issued and outstanding Series C common stock 30.01 par value, 2,000 shares authorized, S24 and 383 shares issued, and 360 and 219 38 shares outstanding 39 Additional paid-in capital 40 Treasury stock, at cost 167 shares 41 Retained earnings 42 Accumulated other comprehensive loss 43 Total Discovery, Inc. stockholders' equity 44 Noncontrolling interests 45 Total equity 46 Total abilities and equity 10,6477,295 (6,737) (6,737) 5,254 4,632 (785) (585) 8,386 4,610 1,716 10,1024 ,610 32,135 22,142 0.02% 32.71% -20.70% 16.14% -2.41% 25.76% 5.27% 31.04% 98.73% 0.02% 32.34% -29.87% 20.54 -2.59% 20.44% 0.00% 20.44% 98.17% 3,352 0 622 (200) 3,776 1,716 5,492 9,993 25.00% 45.95% 0.00% 13.43% 34.19% 81.91% #DIV/0! 1 19.1396 4 5.13% 49 (Source: 10-K, page 76] Sheet1 Sheet2 Sheet3 Ready Type here to search Paste BIU - - S. Merge & Center $ % * Format Painter Clipboard Conditional Format as Cell Formatting Table Styles Styles Font Alignment Number N24 CDEF DISCOVERY, INC. CONSOLIDATED STATEMENTS OF OPERATIONS (in millions, except per share amounts) December 31 2018 2017 4,538 3,474 5,514 3,073 501 326 10,553 6,873 Common Size Analysis 2018 2017 43.00% 50.55% 52.25% 44.71% 4.75% 4.74% 100.00% 100.00% Horizontal Analysis $ Change % Change 1,064 30.63% 2,441 79.43% 175 53.68% 3,680 53.54% 3,935 2,656 37.29% 38.64% 1,279 48.16% 2,620 0 1,768 1,327 330 75 6 Revenues: 7 Distribution 8 Advertising 9 Other 10 Total revenues 11 Cost and expenses: Costs of revenues, excluding depreciation 12 and amortization 13 Selling, general and administrative 14 Impairment of goodwill 15 Depreciation and amortization 16 Restructuring and other charges 17 (Gain) loss on disposition 18 Total costs and expenses 19 Operating income 20 Interest expense, net 21 Loss on extinguishment of debt 22 Loss from equity investees, net 23 Other (expense) income, net 24 Income (loss) before income taxes 25 Income tax expense 26 Net income (loss) 27 interests Net income attributable to redeemable 28 noncontrolling interests Sheet1 Sheet2 Sheet3 Ready 4 852 1,327 1,068 675 (88) 2,459 1,221 (254) 1,398 750 1870 8,619 1,934 (729) 0 163) 6,160 713 1475) (54) 24.83% 0.00% 13.25% 7.11% 0.80% 81.67% 18.33% -6.91% 0.00% -0.60% -1.14% 9.68% -3.23% 6.45% -0.63% -0.19% 25.72% 19.31% 4.80% 1.09% 0.06% 89.63% 10.37% -6.91% 0.79% 3.07% -1.60% -1.99% -2.56% -4.55% 0.00% -0.35% 48.19% 100.00% 323.64% 900.00% -2200.00% 39.92% 171.25% 53.47% -100.00% -70.14% 9.09% 845.99% 93.75% -317.57% #DIV/0! -16.67% 54 211 120 110) 1,022 (137) (176) (313) 148 (10) 1,159 (165) 994 (67) (341 681 (67) (20) (24) 4 1 Type here to search 53. Perform ratio analysis using the ratios. You should present them in a similar format as the text: group by category, list name of ratio, formula in words, and the ratio calculation. Give a short explanation of your conclusions about the each category of ratios (i.e. How liquid is your company? How efficiently is it using its assets? etc.). Conclusions: 54. Are you optimistic or pessimistic regarding the future of your chosen corporation? Explain. I am not optimistic about the future of Discovery Communications. In a day and Page 6 of 7 2041 words LE Paste Merge & Center - Format Painter ter BIU- Clipboard Conditional Format as Cell Formatting Table Styles - Styles Font Alignment Number 020 F G H I J K L DISCOVERY, INC. CONSOLIDATED BALANCE SHEETS (in millions, except par value) N- December 31, 2018 2017 Common Size Analysis 2018 217 Horizontal Analysis $ Change % Change 986 2,620 313 312 4,231 3,069 7,309 1,838 410 434 9,991 2,213 597 7,073 1,770 335 576 22,555 3.03% 32.41% 8.05% 8.15% 0.96% 1.82% 0.96% 1.92% 13.00% 44.30% 9.43% 9.81% 2.46% 2.65% 39.96% 31.36% 29.72% 7.85% 2.87% 1.49% 2.57% 2.55% 100.00% 100.00% (6323) 782 (97) (122) (5760) 856 203 5933 7904 600 259 9995 -86.51% 42.55% 23.66% -28.11% -57.65% 38.68% 34.00% 83.88% 446.55% 179.10% 44.97% 44.31% 800 13,006 9,674 935 835 32,550 6 Assets 7 Current assets: 8 Cash and cash equivalents 9 Receivables, net 10 Content rights, net 11 Prepaid expenses and other current assets 12 Total current assets 13 Noncurrent content rights, net 14 Property and equipment, net 15 Goodwill 16 Intangible assets, net 17 Equity method investments including note receivable 18 Other noncurrent assets 19 Total assets 20 LIABILITIES AND EQUITY 21 Curent liabilities 22 Accounts payable 23 Accrued liabilities 24 Deferred revenues 25 Curent portion of debt 26 Total current liabilities 27 Noncurrent portion of debt 28 Deferred income taxes 29 Other noncurrent liabilities 30 Total liabilities 31 Commitments and contingencies (See Note 22) 22. Emrity Sheet1 Sheet2 Sheet3 Ready 325 1,563 249 1,860 3,997 15,185 1,811 1,040 22,033 277 1,309 255 30 1,871 14,755 319 587 17,532 1.00% 4.80% 0.76% 5.71% 12.28% 46.65% 5.56% 3.20% 67.69% 1.23% 5.80% 1.13% 0.13% 8.30% 65.42% 1.41% 2.60% 77.73% 48 254 (6) 1,830 2,126 430 1,492 453 4,501 17.33% 19.40% -2.35% 6100.00% 113.63% 2.91% 467.71% 77.17% 25.67% Type here to search Calibri General BIU - Ba Copy Format Painter Clipboard - S.A. 2. Wrap Text Merge & Center - Paste $. % . Inser Conditional Format as Cell Formatting Table Styles - Styles Font Alignment Number 020 X H C D 1,860 3 0 3,997 1,871 15,185 14,755 1,8113 19 1,040587 22,033 17,532 5.71% 12.28% 46.65% 5.56% 3.20% 67.69% G 0.13% 8.30% 65.42% 1.41% 2.60% 77.73% 1,830 6100.00% 2,126 113.63% 4302.91% 1,492467.71% 453 77.17% 4,501 25.67% 25 Current portion of debt 26 Total current habilities 27 Noncurrent portion of debt 28 Deferred income taxes 29 Other noncurrent liabilities 30 Total liabilities 31 Commitments and contingencies (See Note 22) 32 Equity 33 Discovery, Inc. stockholders' equity Series A-1 convertible preferred stock. $0.01 par value; 34 8 shares authorized issued, and outstanding Series C-1 convertible preferred stock. $0.01 par vahe: 6 shares authorized, issued, and outstanding 0.00% 0.00% #DIV/0! oo - 35 0.00% 0.00% O #DIV/0! 0.01% 0.00% 100.00% ON 0.00% 0.00% 0 #DIV/0! Series A common stock $0.01 par value; 1,700 shares authorized: 160 and 157 shares issued; and 157 and 154 36 shares outstanding Series B convertible common stock $0.01 par value, 100 37 shares authorized; 7 shares issued and outstanding Series C common stock 30.01 par value, 2,000 shares authorized, S24 and 383 shares issued, and 360 and 219 38 shares outstanding 39 Additional paid-in capital 40 Treasury stock, at cost 167 shares 41 Retained earnings 42 Accumulated other comprehensive loss 43 Total Discovery, Inc. stockholders' equity 44 Noncontrolling interests 45 Total equity 46 Total abilities and equity 10,6477,295 (6,737) (6,737) 5,254 4,632 (785) (585) 8,386 4,610 1,716 10,1024 ,610 32,135 22,142 0.02% 32.71% -20.70% 16.14% -2.41% 25.76% 5.27% 31.04% 98.73% 0.02% 32.34% -29.87% 20.54 -2.59% 20.44% 0.00% 20.44% 98.17% 3,352 0 622 (200) 3,776 1,716 5,492 9,993 25.00% 45.95% 0.00% 13.43% 34.19% 81.91% #DIV/0! 1 19.1396 4 5.13% 49 (Source: 10-K, page 76] Sheet1 Sheet2 Sheet3 Ready Type here to search Paste BIU - - S. Merge & Center $ % * Format Painter Clipboard Conditional Format as Cell Formatting Table Styles Styles Font Alignment Number N24 CDEF DISCOVERY, INC. CONSOLIDATED STATEMENTS OF OPERATIONS (in millions, except per share amounts) December 31 2018 2017 4,538 3,474 5,514 3,073 501 326 10,553 6,873 Common Size Analysis 2018 2017 43.00% 50.55% 52.25% 44.71% 4.75% 4.74% 100.00% 100.00% Horizontal Analysis $ Change % Change 1,064 30.63% 2,441 79.43% 175 53.68% 3,680 53.54% 3,935 2,656 37.29% 38.64% 1,279 48.16% 2,620 0 1,768 1,327 330 75 6 Revenues: 7 Distribution 8 Advertising 9 Other 10 Total revenues 11 Cost and expenses: Costs of revenues, excluding depreciation 12 and amortization 13 Selling, general and administrative 14 Impairment of goodwill 15 Depreciation and amortization 16 Restructuring and other charges 17 (Gain) loss on disposition 18 Total costs and expenses 19 Operating income 20 Interest expense, net 21 Loss on extinguishment of debt 22 Loss from equity investees, net 23 Other (expense) income, net 24 Income (loss) before income taxes 25 Income tax expense 26 Net income (loss) 27 interests Net income attributable to redeemable 28 noncontrolling interests Sheet1 Sheet2 Sheet3 Ready 4 852 1,327 1,068 675 (88) 2,459 1,221 (254) 1,398 750 1870 8,619 1,934 (729) 0 163) 6,160 713 1475) (54) 24.83% 0.00% 13.25% 7.11% 0.80% 81.67% 18.33% -6.91% 0.00% -0.60% -1.14% 9.68% -3.23% 6.45% -0.63% -0.19% 25.72% 19.31% 4.80% 1.09% 0.06% 89.63% 10.37% -6.91% 0.79% 3.07% -1.60% -1.99% -2.56% -4.55% 0.00% -0.35% 48.19% 100.00% 323.64% 900.00% -2200.00% 39.92% 171.25% 53.47% -100.00% -70.14% 9.09% 845.99% 93.75% -317.57% #DIV/0! -16.67% 54 211 120 110) 1,022 (137) (176) (313) 148 (10) 1,159 (165) 994 (67) (341 681 (67) (20) (24) 4 1 Type here to search 53. Perform ratio analysis using the ratios. You should present them in a similar format as the text: group by category, list name of ratio, formula in words, and the ratio calculation. Give a short explanation of your conclusions about the each category of ratios (i.e. How liquid is your company? How efficiently is it using its assets? etc.). Conclusions: 54. Are you optimistic or pessimistic regarding the future of your chosen corporation? Explain. I am not optimistic about the future of Discovery Communications. In a day and Page 6 of 7 2041 words LE
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