3. Ratio Analysis Attachments - Compute the ratios listed below to be included as attachments to your report. You must show details of your calculations. You must include the following required ratios for the most recent fiscal year end: e. Days' sales uncollected f. Days' sales in inventory (if applicable) g. Debt ratio h. Debt-to-equity ratio i. Profit margin ratio j. Gross margin ratio (if applicable) k. Return on common stockholder's equity I. Price-earnings (PE) ratio m. Dividend yield Please complete the above ratios using year 2018 and the income statement and balance sheet below. Income Statement: DEC. 31, 2017 Horizontal Anald's $ Change Change Vertical Analysis Dec 31, 2018 Dec 31, 2017 100.0% $1.037,053 $268,599 $1 305,652 $115,980 $2,3.7 $112.613 .11.18% 0.86% 8.70 100.00% 29.01% 129.41% 25.99% CONSOLIDATED STATEMENTS OF OPERATIONS-USD (S)shares in Thousands, $ in Thousands Dec 31, 2018 Revenues Betri: $921,093 $270,916 Total Revenues $1.192.209 Operating Esperses Cost of sales $272,183 Operating genera and administrative $307.119 Property and other tres $171,259 Decreation and depletion $174.476 Totel Operating Exeens $925.737 Operating Income $266,272 Interest Expense net $91,988 Other Income|Expense, net $3,966 Income before Income Taxe $178,250 Income Tax Benzit |Expense) $18.710 Net Income $196,960 29.63% 33,34% 18.59% 18.4% 100.50% $410,349 $294.833 $.62,614 $.66 137 $1033.903 $271,749 $92,253 $3,415 $176,071 $13,368 $162,703 $137,466 33.50% $12.3.6 4.18% $8,615 5.32% $9.319 .02% 3109.166 -10,46% $5,477 2.02% $2750.30% $7,381 216.13 $2,179 1.24% $12,078 239.96% $14,257 21.05 28.SIN 3257% 2843% 15.68% 16.02% 99.70% 26,20% 8.97% 0.338 16.99% 1.29% 15,6% 9.09% 0.43% 19.15% 2.03% 21.98% $49,984,562 Average Common Stars Outstanding Besic aming per Putrage Common Share Diluted Earringsper Ave ere Cameron Share $3.94 $48,557,599 $3.35 $3,34 $1,426,963 $ 1 $1 2.948 17.618 17.37% $392 Balance Sheet: CONSOLIDATED BALANCE SHEETS-USD $$ in Thousands Horizontal Analysis $Charge Change Vertical Analysis Dec 31, 2011 Dec 31, 2017 Dec 31, 2018 Dec 31, 2017 AUS 0.16% 0.07% $7860 $7451 $162 373 $50 815 $3R 431 $10.755 $277685 $4,521 31: $357 588 $137 SR 550,206 $5,544 376 $8473 $3.556 $182,282 $52432 $37669 $11.947 $296359 $4,358.265 $357586 $354316 $54391 $5,420,917 $613 $3,895 $19,909 $1,6.7 $762 $1,192 -$13,674 $163,053 $0 $63,265 $4,185 $223.459 7235 10953% -1092% 3.08% 2.02% 998% 630% 3.74% 0.00% 23.50% 7 695 124 0.14% 0.11% 2.888 0.90% 0.61% 0.15% 4.92% 80.10% 631% 2.75% 0.89% 1000 0.22% 5.47% 80.47% 6.67% 6.54% 1.03% 100.0% $2,298 $2,133 0.04% 0.01% 0.03% 154% Cash and cashqaivalents Restricted cash Accounts receivable.net Inventories Regulerbrysets Other 1 Total currentes 1 Property, plant, and equipment, net 2 Goodwill 1 curry assets 4 Other no current assets 5 TOTAL ASSETS Liabilities 7 Current maturitiof capitalists ! Startumborrowings Accounts peable 1 kcred perse 1 Regulatoryliabilities 2 Total current abilities ! Long-term captallesses 4 Long-term debt 5 Deferred income Mencuentratorylialities 7 Other current abilities Total liabilities Stockholders equity : Commons.ock par value$.01, authorised 200,000,000 stares sued and 1 Treasury stack at cost 2 Paid in captal 1 Betained emines + Accurrulated other comprehersive oss 5 Total Shareholders Equity I TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY 597043 $216,792 540 876 $347 009 $19.915 $2,102 345 $394618 $138265 $399 822 $3,701994 $85.180 $210.047 515 342 $632 233 $22 213 $1,793416 $340.729 $417,701 $$15.705 $3,522.002 $165 7745 $319,556 300.00% $1,893 221% $6,745 3215 $25,534 166.43% $285,229 45115 $2,298 -1035% $368,929 17234 $53.839 15 82% $20,584 93% $15,8933 82% $79,992 2218 3.84% 0.72% 615% 0.35% 37.25% 6.9% 7.78% 7.08% 65.59% 1.57% 3.87% 0.25% 11.66% 0.41% 33.09% 6.25% 7.73% 2.67% 66.82% $539 -595,546 $1,499070 $548 259 $9.934 1.942 382 $5,644 376 0.01% -1.7EX 26.66% $530 $96376 $1,445,181 $458 352 $8,772 1.798.915 $5.420.917 $9 $830 $53,689 $69,901 $1,162 $143.467 $223.459 170% 086% 3.73% 1961% 1325% 7985 2.125 0015 -1.69% 26.55% 9.71% 0.18% 3441% 00.00% 0.15% 3118 100.0%