Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

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. ).

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Accounting Principles And Applications

Authors: Horace R. Brock

5th Edition

0070081522, 978-0070081529

More Books

Students also viewed these Accounting questions