Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Fill out the table Income Statement For the Fiscal Period Ending Reclassified 12 months Dec 31-2015 USD Reclassified 12 months Dec-31-2016 USD Reclassified 12 months

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
image text in transcribed
Fill out the table
Income Statement For the Fiscal Period Ending Reclassified 12 months Dec 31-2015 USD Reclassified 12 months Dec-31-2016 USD Reclassified 12 months Dec 31 2017 USD 12 months Dec 31-2018 USD 12 months Dec 31-2019 USD Currency 200,628.0 237.162.0 279,3320 255,583.0 Revenue Other Revenue Total Revenue 239.854.0 15520 241,406.0 200,628.0 237,162.0 279,332.0 255,583.0 Cost Of Goods Sold Gross Profit 163,6050 77,801.0 132.7590 67,869.0 159 0530 78,109.0 190.7520 88,580.0 178,431.0 77,152.0 10,961.0 1,5230 11.783.0 1,4670 11.893.0 1.790.0 12,300.0 1,4660 12, 168.0 1.269.0 Selling General & Admin Exp. Exploration/Drilling Costs R&D Exp Depreciation & Amort Other Operating Expense/Income) Other Operating Exp. Total Operating Income 18,0480 32.8340 18.708.0 31,3750 17.893.0 32.459.0 18,0450 35.230.0 18,8980 33,186,0 63,366.0 63,333.0 64,035.0 67,041.0 65,521.0 14,435.0 4,536.0 14,074.0 21,539.0 11,631.0 (3110) (4530) (8010) (766.0) (830.0) Interest Expense Interest and Invest, Income Net Interest Exp. (311.0) (453.0) (601.0) (766.0) (830.0) 7.6440 14.0 4,8060 5.4410 Income (Loss) from Affiliates Currency Exchange Gains (Loss) Other Non-Operating Inc Exp.) EBT Excl. Unusual Items 5.380.0 (234.0) 1.7210 20,340.0 7.3550 (1960) 1.7280 29,660.0 9980 9,887.0 1.2140 17,456.0 21,782.0 Impairment of Goodwill Gain (Loss) On Sale Of invest Gain (Loss) On Sale Of Assets Asset Whitedown Other Unusual items EBT Incl. Unusual Items (420) 2260 1 6820 (3.600.0) 3340 (2.000.0) 1.993.0 (7000) 2 7000 (1000) 21.966.0 7,969.0 18,674.0 30,953.0 20,056.0 S&P Capital IQ Income Tax Expense Earnings from Cont. Ops. 5.415.0 16,551.0 (4060) 8,375.0 (11740) 19,848.0 9,5320 21,421.0 5.2820 14,774.0 16,551.0 8,375.0 19,848.0 21,421.0 14,774.0 Earnings of Discontinued Ops Extraord. Item & Account Change Net Income to Company Minority Int. in Earnings Net Income (401.0) 16.150.0 (535.0) 7.840.0 (1380) 19.710.0 15810) 20.840.0 (4340) 14.340.0 Pref. Dividends and Other Adi NI to Common Incl Extra Items NI to Common Excl. Extra Items 16,150.0 16,150.0 7,840.0 7,840.0 19,710.0 19,710.0 20,840.0 20,840.0 14,340.0 14,340.0 Per Share Items Basic EPS Basic EPS Excl. Extra Items Weighted Avg Basic Shares Out $385 3.85 4.1960 $1.88 1.88 4.177.0 $4.63 4.63 4.256.0 $4.88 4.88 4.270.0 $3.36 3.36 4.270.0 Diluted EPS Diluted EPS Excl. Extra items Weighted Avg Diluted Shares Out $385 3.85 4 1960 $1.88 1.88 4.177.0 $463 4.63 42560 $4.88 4.88 4 270.0 $3.36 3.36 4.2700 Normalized Basic EPS Normalized Diluted EPS $421 $3.15 3.15 $1.35 1.35 $2.95 2.95 $2.45 2.45 421 $288 74.9% 52.98 158.8% $3.06 66.0% $323 66.2% $3.43 102.2% Dividends per Share Payout Ratio % Shares per Depository Receipt 0.25 0.25 0.25 0.25 0.25 Supplemental Items EBITDA EBITA EBIT EBITDAR As Reported Total Revenue Effective Tax Rate % 32.483.0 144350 14.435 0 36 4120 249 2480 24.794 23 2440 4 536,0 4.536.0 26.335.0 208.114.0 NM 31,9670 14,074,0 14,074 0 34.585 0 244,363 0 NM 39.5840 21.539.0 21 539 0 42.299.0 290 2120 30 8% 30.5290 11,6310 11.6310 340050 264 8380 26.3% Normalized Net Income Interest Capitalized Interest on Long Term Debt Non-Cash Pension Expense Filing Date Restatement Type Calculation Type 132128 4820 NA 1.599.0 Feb-28-2018 RC REP 5.6444 708.0 NA 1.3930 Feb-27-2019 RO REP 12.574 5 7490 NA 1.3890 Feb-26-2020 RO REP 17.956 5 6520 NA 9310 Feb-28-2020 NC REP 10 4760 7310 1330 9220 Feb-28-2020 REP Supplemental Operating Expense Items Supplemental Operating Expense Items S&P Capital IQ RSD EXO Exploration/Drilling Expenses Net Rental Exp Imputed Oper Lease Interest Exp Imputed Oper Lease Depreciation 1.0080 1.5230 3,9290 7352 3.1938 10580 1.4670 3,091,0 7049 2.386.1 1,063.0 1,790.0 2,6180 6645 1,953.5 1.116.0 1.466.0 2.7150 768.7 1946.3 1.2140 1,269.0 3,476,0 958.6 2.517.4 Stock-Based Comp. Unallocated Stock-Based Comp., Total 8550 855.0 880.0 880.0 8560 856.0 7740 774.0 7410 741.0 Balance Sheet Balance Sheet as of: Dec-31-2018 Dec-31-2019 Dec 31 2015 USD Dec 31 2016 USD Dec 31 2017 USD USD USD Currency ASSETS Cash And Equivalents Total Cash & ST Investments 3.1770 30420 3.089 0 3,7050 3.705.0 3,6570 3,657.0 3,177.0 3.042.0 3,089.0 16,0330 Accounts Receivable Other Receivables Total Receivables 13.243.0 6,632.0 19,875.0 212740 43230 19.638.0 5.063 0 21.1000 5,8660 5.3510 21.3940 25.5970 24,701,0 26,966.0 15.0800 16.5920 18.9580 18 528.0 Inventory Deferred Tax Assets. Curr. Other Current Assets Total Current Assets 16 245.0 1329.0 1.4690 1.285.0 41,416,0 1,3680 47,134.0 1 2720 47.973.0 1.409.0 50.052.0 42.623.0 4473370 493.335.0 Gross Property. Plant & Equipment Accumulated Depreciation Net Property, Plant & Equipment (1957320 251.605.0 453.9150 209.610) 244,224,0 477 1350 12245550 252,630.0 477 1900 (230.0890) 247.101.0 (233,6340) 259,651.0 20.0110 3.4210 18.4900 Long term investments Deferred Tax Assets LT Other Long Term Assets Total Assets 20140 41200 19 5100 24 5280 3.3180 210010 25 5920 3 2000 29.4810 3.2680 20 1450 330.314 S&P Capital IQ LIABILITIES 246940 21,0630 32000 Accounts Payable Accrued Exp Short-term Borrowings Curr Port of LT Debt Curt Port of Lenses Curr.Income Taxes Payable Other Current Liabilities Total Current Liabilities 18,0740 2,9370 18 2040 5580 33010 17,8010 2,653.0 10,870,0 2560.0 21,7010 3,311,0 13,164,0 4,7660 13,1880 4,0700 3.0450 18,8770 1.617.0 1,310.0 1,580.0 12,610,0 63,989.0 2,8020 11,4010 53.976.0 2,6120 2,6150 10.7390 47.633.0 11,7840 57,771.0 12.9250 57,138,0 18,6870 1,2380 Long-Term Debt Long-Term Leases Pension & Other Post-Retire Benefits Def Tax Liability, Non-Curr Other Non-Current Libilities Total Liabilities 22.6470 36,818.0 27,7070 1.225.0 20,680.0 34,0410 25.193.0 156,484.0 23,079.0 1,3270 21.132.0 26.8930 23.969.0 154,191.0 19.2350 1,3030 20.2720 27,244.0 22.476.0 147,668.0 24 6720 62910 223040 25 620.0 20.783.0 163659.0 26,5820 159,948.0 11,6120 12.1570 14.6560 15,258.0 15 6370 Common Stock Additional Paid in Capital Retained Earrings Treasury Stock Comprehensive Inc. and Other Total Common Equity 412.444.0 (229.7340) 123.5110 170,811.0 407 8310 (230 4240) 222390 167,325.0 4145400 (225.2460) (16.2020) 187,688.0 421,653 0 (225 553.0) (195640) 191,794.0 421 3410 (225,8350) (19.493.0 191.650.0 Minority interest 5.9990 6.505.0 6.8120 6.734.0 7 2880 Total Equity 176.310.0 173.830.0 194.500.0 198,528.0 190.933.0 Total Liabilities And Equity 336,758.0 330,3140 343.691.0 346.196.0 362,597.0 Supplemental Items Tots Shares Out on Filing Date Total Shares Out on Balance Sheet Date Book Value Share Tangible Book Value Tangible Book Value/Share Total Debt Net Dobi Debt Equiv. of Unfunded Proj. Benefit Obligation Debt Equivalent Oper Leases Total Minority interest Equity Method investments 41520 4.156.0 $41.1 170 9110 5411 4,148.5 4,1480 $40 34 167 3250 540.34 42.7820 39.1050 13,320.0 24 728 0 6.5050 20.8100 4.237.5 4.239.0 54428 187.6880 $4428 423360 39. 1590 130300 20 9440 68120 24 3540 42348 42370 $45.27 191.7940 $45.27 377960 34 7540 12,9320 21.720.0 6.7340 26,382.0 42322 42340 54528 191,650,0 $45 26 52,767.0 49.8780 14,325 0 27 8080 7.2880 29.291.0 34 9620 15 2900 31,4320 5.9990 20 3370 Total Minority interest Equity Method Investments 5,9990 20,3370 6 5050 20,8100 68120 24 3540 6,7340 26,3820 7,2080 29,291 0 S&P Capital IQ Inventory Method LIFO Reserve Raw Materials Inventory Finished Goods Inventory Full Time Employees Accum. Allowance for Doubtful Accts Filing Date Restatement Type Calculation Type LIFO (45000) 4.2000 120370 73.500 1070 Feb-28-2018 NC LIFO 18.1000 42030 10.8770 71.100 750 Feb-27-2019 NC RUP LIFO (10,8000) 4.1210 12.8710 69,600 720 Feb 20-2000 NC RUP UFO (8.200.0) 4,1550 14 8030 71.000 61.0 Feb-26-2020 NC REP LIFO (9.7000) 4,518.0 14,010,0 74.900 34.0 Feb-26-2020 RUP REP 2015 2016 2017 2018 2019 1. Short Term Solvancy Ratios Current Ratio (x) Quick Ratio (x) Cash Ratio (%) Net Working Capital to Total Assets (%) II. Long Term Solvency Ratios Total Debt Ratio (%) Debt Equity Ratio (x) Equity Multiplier (x) Long Term Debt Ratio* (%) Times Interest Earned Ratio (x) III. Asset Management Ratios Inventory Turnover (x) Days' Sales in Inventory (Day) Receivable Turnover (x) Days' Sales in Receivables (Day) Fixed Asset Turnover (x) Total Asset Turnover (x) IV. Profitability Ratios ** Profit Margin (%) Operating Margin (%) Gross Margin (95) Return on Assets (%) Return on Equity ** (%) V. Market Value Ratios V. Market Value Ratios Earning Per Share (5) Dividend Per Share (5) Dividend Payout Ratio Price Earning Ratio (x) Market-to-Book Ratio (x) Book Value Per Share ($) Stock Price at the End of the Year

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

For Heintz/parrys College Accounting, Chapters 1-15, 22nd Edition, [instant Access]

Authors: James A. Heintz, Robert W. Parry

22nd Edition

1305669886, 9781305669888

More Books

Students also viewed these Accounting questions

Question

=+a. Write two different, but related, headlines.

Answered: 1 week ago