Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Financial Ratio Analysis: Income Statement Info: Balance Sheet Info: Need: Long-term solvency, or liquidity ratios Asset Utilization, or turnover, ratios Profitability ratios Market Value Ratios

Financial Ratio Analysis:

Income Statement Info:

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Balance Sheet Info:

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Need:

Long-term solvency, or liquidity ratios

Asset Utilization, or turnover, ratios

Profitability ratios

Market Value Ratios

Fiscal year is January, December. All values USD millions. 2016 6,632 3.37% Sales/Revenue 2015 6,416 10.30% 2014 5,817 6.91% 2013 5,441 9.21% 2012 4.982 Sales Growth Cost of Goods Sold (COGS) incl. D&A 5,070 4,831 5,048 4,789 4,412 COGS excluding D&A 4,677 4.486 4,728 4,499 4154 Depreciation & Amortization Expense 393 345 290 258 320 263 Depreciation 337 288 258 230 Amortization of Intangibles COGS Growth 56 4.95% 1562 57 - 4.30% 1.585 57 5.41% 769 32 8.54% 652 28 - 570 Gross Income Gross Income Growth -1.45% 106.11% 17.94% 14.39% SG&A Expense 259 264 231 223 204 Other SG&A 259 264 231 223 204 SGA Growth -1.89% 14.29% 3.59% 9.31% EBIT 1,303 1,321 538 429 366 Unusual Expense (13) 16111 Non Operating Income/Expense 16 (118) 234 1 104119133140 - 157 Interest Expense Interest Expense Growth -12.61% -10.53% -5.00% -10.83% Gross Interest Expense 147 153 Interest Capitalized 112127 8 8 1,2161,097 14 623 13 279 165 8 209 Pretax Income Income Tax 420 222 11181 Income Tax - Current Domestic 155 43 10 4 5 Income Tax Current Foreign 32 - - Income Tax - Deferred Domestic 270 377 212 Consolidated Net Income 759 677 401 168 Net Income 759 677 401 168 Net Income Growth 12.11% 68.83% 138.69% 31.25% Net Income After Extraordinaries 759 677 401 168 128 Net Income Available to Common 168 128 759 677 401 2.221.981.19 EPS (Basic) 0.52 0.40 EPS (Basic) Growth 12.12% 66.39% 128.85% 30.62% - Basic Shares Outstanding 327 315 295 283 282 EPS (Diluted) 2.22 1.98 1.19 0.52 0.40 EPS (Diluted) Growth 12.60% 66.19% 130.59% 29.46% Diluted Shares Outstanding 342 345 343 343 344 EBITDA 1,696 160 1,666 858 719 624 EBITDA Growth 1.80% 94.17% 19.33% 15.22% EBIT 1,303 1,321538 429366 Fiscal year is January, December. All values USD millions. 2016 2015 2014 2013 2012 Cash & Short-Term Investments 971 971 876 876 708 627 731 731 318341225182 Cash Only 433 Short-Term Investments 538 558 367 402 549 Cash & Short-Term Investments Growth 10.84% 23.73% 12.92% -14.23% Cash & ST Investments / Total Assets 10.24% 10.12% 9.03% 8.53% 10.34% Total Accounts Receivable 172 136 136 136 136 129 129 106 106 Accounts Receivables, Net 172 136 136 129106 Acounts Receivable Growth 26.47% 0.00% 5.43% 21.70% Accounts Receivable Turnover 38.56 47.18 42.77 42.18 47.00 36 Inventories 47 44 46 48 Raw Materials - 46 48 Other Current Assets 377 317 227 310 135 252 126 Prepaid Expenses 172 119 Miscellaneous Current Assets 377 145 175 126 108 Total Current Assets 1,567 1,373 1,200 1,056 1,100 Net Property, Plant & Equipment 7,271 6,652 6,072 5,656 5,343 Property, Plant & Equipment - Gross 9,624 8,679 7,817 7208 6,652 Machinery & Equipment 8,091 7,250 6,440 5,9595,506 Construction in Progress 561 561 561 561 561 Other Property, Plant & Equipment 972 868 816 688 585 Accumulated Depreciation 2,353 2,027 1,745 1,552 1,309 Machinery & Equipment 1,823 1,573 1,354 1,185 995 Construction in Progress 185 161 93 Other Property, Plant & Equipment 345 293 221 345 152 Total Investments and Advances 293 12 112 252 121 121 251 120 171 221 187 187 Other Long-Term Investments 152 Intangible Assets 97937370129 400 430 373 397 311 Other Assets Tangible Other Assets 20. 400 430 373 397 311 Total Assets 9,487 8,660 7,839 7,350 7,070 Assets Total Growth 9.55% 10.47% 6.65% 3.96% ST Debt & Current Portion LT Debt 189 448 265 469 394 Current Portion of Long-Term Debt 189 189 448 448 205 265 208 469 180 394 Accounts Payable 242 846 Accounts Payable Growth 18.05% -1.44% 15.56% -78.72% Other Current Liabilities 1,792 1,622 1,463 368 Accrued Payroll 342 302 1,225 171 203 172 Miscellaneous Current Liabilities 1,450 1,320 1,260 1,054 196 Total Current Liabilities 2,223 2,275 1,936 1,874 1,608 Current Ratio 0.70 0.60 0.62 0.56 0.68 Quick Ratio 0.68 0.58 0.60 0.54 0.66 Cash Ratio 0.44 0.39 0.37 0.33 0.45 Long-Term Debt 1,652 1,867 2,455 2,590 2,457 Long-Term Debt excl. Capitalized Leases 1,528 1,727 2,300 2,493 2,457 Non-Convertible Debt 1,528 1.727 2,300 2,493 2,457 Capitalized Lease Obligations 124 140 155 97 Deferred Taxes 1.5091.218 832 605 481 Deferred Taxes - Credit 1,509 1,218 832 605 481 Other Liabilities 90 90 87 147 636 Other Liabilities (excl. Deferred Income) 90 90 87 147 636 Total Liabilities 5,474 5,450 5 ,310 5,216 5,182 Total Liabilities/Total Assets 57.70% 62.93% 67.74% 70.97% 73.30% Common Equity (Total) 4,013 3,2102 ,529 2,134 1,888 Common Stock Par/Carry Value Additional Paid-In Capital/Capital Surplus 2,050 1,896 1,711 1,573 1,495 Retained Earnings 2,446 1,679 1,002 601 433 Other Appropriated Reserves 13 (3) (366) (63) (125) - (43) (8) (35) Treasury Stock (500) Common Equity / Total Assets 42.30% 37.07% 32.26% 29.03% 26.70% Total Shareholders' Equity 4,013 3,210 2,529 2,134 1,888 Total Shareholders' Equity / Total Assets 42.30% 37.07% 32.26% 29.03% 26.70% Total Equity 4,013 3,2102,529 2,134 1,888 Liabilities & Shareholders' Equity 9,487 8.660 7,839 7,350 7,070 Fiscal year is January, December. All values USD millions. 2016 6,632 3.37% Sales/Revenue 2015 6,416 10.30% 2014 5,817 6.91% 2013 5,441 9.21% 2012 4.982 Sales Growth Cost of Goods Sold (COGS) incl. D&A 5,070 4,831 5,048 4,789 4,412 COGS excluding D&A 4,677 4.486 4,728 4,499 4154 Depreciation & Amortization Expense 393 345 290 258 320 263 Depreciation 337 288 258 230 Amortization of Intangibles COGS Growth 56 4.95% 1562 57 - 4.30% 1.585 57 5.41% 769 32 8.54% 652 28 - 570 Gross Income Gross Income Growth -1.45% 106.11% 17.94% 14.39% SG&A Expense 259 264 231 223 204 Other SG&A 259 264 231 223 204 SGA Growth -1.89% 14.29% 3.59% 9.31% EBIT 1,303 1,321 538 429 366 Unusual Expense (13) 16111 Non Operating Income/Expense 16 (118) 234 1 104119133140 - 157 Interest Expense Interest Expense Growth -12.61% -10.53% -5.00% -10.83% Gross Interest Expense 147 153 Interest Capitalized 112127 8 8 1,2161,097 14 623 13 279 165 8 209 Pretax Income Income Tax 420 222 11181 Income Tax - Current Domestic 155 43 10 4 5 Income Tax Current Foreign 32 - - Income Tax - Deferred Domestic 270 377 212 Consolidated Net Income 759 677 401 168 Net Income 759 677 401 168 Net Income Growth 12.11% 68.83% 138.69% 31.25% Net Income After Extraordinaries 759 677 401 168 128 Net Income Available to Common 168 128 759 677 401 2.221.981.19 EPS (Basic) 0.52 0.40 EPS (Basic) Growth 12.12% 66.39% 128.85% 30.62% - Basic Shares Outstanding 327 315 295 283 282 EPS (Diluted) 2.22 1.98 1.19 0.52 0.40 EPS (Diluted) Growth 12.60% 66.19% 130.59% 29.46% Diluted Shares Outstanding 342 345 343 343 344 EBITDA 1,696 160 1,666 858 719 624 EBITDA Growth 1.80% 94.17% 19.33% 15.22% EBIT 1,303 1,321538 429366 Fiscal year is January, December. All values USD millions. 2016 2015 2014 2013 2012 Cash & Short-Term Investments 971 971 876 876 708 627 731 731 318341225182 Cash Only 433 Short-Term Investments 538 558 367 402 549 Cash & Short-Term Investments Growth 10.84% 23.73% 12.92% -14.23% Cash & ST Investments / Total Assets 10.24% 10.12% 9.03% 8.53% 10.34% Total Accounts Receivable 172 136 136 136 136 129 129 106 106 Accounts Receivables, Net 172 136 136 129106 Acounts Receivable Growth 26.47% 0.00% 5.43% 21.70% Accounts Receivable Turnover 38.56 47.18 42.77 42.18 47.00 36 Inventories 47 44 46 48 Raw Materials - 46 48 Other Current Assets 377 317 227 310 135 252 126 Prepaid Expenses 172 119 Miscellaneous Current Assets 377 145 175 126 108 Total Current Assets 1,567 1,373 1,200 1,056 1,100 Net Property, Plant & Equipment 7,271 6,652 6,072 5,656 5,343 Property, Plant & Equipment - Gross 9,624 8,679 7,817 7208 6,652 Machinery & Equipment 8,091 7,250 6,440 5,9595,506 Construction in Progress 561 561 561 561 561 Other Property, Plant & Equipment 972 868 816 688 585 Accumulated Depreciation 2,353 2,027 1,745 1,552 1,309 Machinery & Equipment 1,823 1,573 1,354 1,185 995 Construction in Progress 185 161 93 Other Property, Plant & Equipment 345 293 221 345 152 Total Investments and Advances 293 12 112 252 121 121 251 120 171 221 187 187 Other Long-Term Investments 152 Intangible Assets 97937370129 400 430 373 397 311 Other Assets Tangible Other Assets 20. 400 430 373 397 311 Total Assets 9,487 8,660 7,839 7,350 7,070 Assets Total Growth 9.55% 10.47% 6.65% 3.96% ST Debt & Current Portion LT Debt 189 448 265 469 394 Current Portion of Long-Term Debt 189 189 448 448 205 265 208 469 180 394 Accounts Payable 242 846 Accounts Payable Growth 18.05% -1.44% 15.56% -78.72% Other Current Liabilities 1,792 1,622 1,463 368 Accrued Payroll 342 302 1,225 171 203 172 Miscellaneous Current Liabilities 1,450 1,320 1,260 1,054 196 Total Current Liabilities 2,223 2,275 1,936 1,874 1,608 Current Ratio 0.70 0.60 0.62 0.56 0.68 Quick Ratio 0.68 0.58 0.60 0.54 0.66 Cash Ratio 0.44 0.39 0.37 0.33 0.45 Long-Term Debt 1,652 1,867 2,455 2,590 2,457 Long-Term Debt excl. Capitalized Leases 1,528 1,727 2,300 2,493 2,457 Non-Convertible Debt 1,528 1.727 2,300 2,493 2,457 Capitalized Lease Obligations 124 140 155 97 Deferred Taxes 1.5091.218 832 605 481 Deferred Taxes - Credit 1,509 1,218 832 605 481 Other Liabilities 90 90 87 147 636 Other Liabilities (excl. Deferred Income) 90 90 87 147 636 Total Liabilities 5,474 5,450 5 ,310 5,216 5,182 Total Liabilities/Total Assets 57.70% 62.93% 67.74% 70.97% 73.30% Common Equity (Total) 4,013 3,2102 ,529 2,134 1,888 Common Stock Par/Carry Value Additional Paid-In Capital/Capital Surplus 2,050 1,896 1,711 1,573 1,495 Retained Earnings 2,446 1,679 1,002 601 433 Other Appropriated Reserves 13 (3) (366) (63) (125) - (43) (8) (35) Treasury Stock (500) Common Equity / Total Assets 42.30% 37.07% 32.26% 29.03% 26.70% Total Shareholders' Equity 4,013 3,210 2,529 2,134 1,888 Total Shareholders' Equity / Total Assets 42.30% 37.07% 32.26% 29.03% 26.70% Total Equity 4,013 3,2102,529 2,134 1,888 Liabilities & Shareholders' Equity 9,487 8.660 7,839 7,350 7,070

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_2

Step: 3

blur-text-image_3

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

Financial Accounting

Authors: Paul D. Kimmel, Jerry J. Weygandt, Donald E. Kieso

4th Edition

0471072419, 978-0471072416

More Books

Students also viewed these Accounting questions