Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Calculate Inventory Turnover Ratio, Day's Sales in Inventory, Receivables Turnover, Day's Sales in Receivables, Total Asset Turnover (TAT). Please answers step by step. Thank you!
Calculate Inventory Turnover Ratio, Day's Sales in Inventory, Receivables Turnover, Day's Sales in Receivables, Total Asset Turnover (TAT).
Please answers step by step. Thank you!
Balance Sheet Standard Restatement: Template: Period Type: Latest Filings Latest on Right Annual Order: Go Enable Freeze Panes More Options >> View All 2015 2016 2017 2018 2019 2020 Dec-31-2017 USD Dec-31-2018 USD Dec-31-2019 USD Sep-30-2020 USD 2,438.0 1,795.0 4,233.0 1,207.0 1,207.0 2,217.0 440.0 2,437.0 2,950.0 5,387.0 1,074.0 1,074.0 2,001.0 299.0 2,822.0 2,696.0 5,518.0 1,392.0 1,392.0 2,072.0 277.0 In Millions of the reported currency, except per share items. Chart Selected Items Balance Sheet as of: Currency ASSETS Cash And Equivalents Short Term Investments Total Cash & ST Investments Accounts Receivable Total Receivables Inventory Prepaid Exp. Other Current Assets Total Current Assets Gross Property, Plant & Equipment Accumulated Depreciation Net Property, Plant & Equipment Long-term Investments # Goodwill Other Intangibles Deferred Tax Assets, LT Other Long-Term Assets Total Assets LIABILITIES Accounts Payable # Accrued Exp. + Curr. Port. of LT Debt Curr. Port. of Leases + Curr. Income Taxes Payable Other Current Liabilities Total Current Liabilities Long-Term Debt # Long-Term Leases Pension & Other Post-Retire. Benefits Def. Tax Liability, Non-Curr. Other Non-Current Liabilities Total Liabilities Common Stock Additional Paid In Capital #Retained Earnings # Treasury Stock Comprehensive Inc. and Other Total Common Equity Total Equity Total Liabilities And Equity 1,656.0 2,813.0 4,469.0 1,278.0 1,278.0 1,957.0 768.0 262.0 8,734.0 4,789.0 (2,125.0) 2,664.0 32.0 4,362.0 1,056.0 264.0 530.0 17,642.0 8,097.0 5,425.0 (2,242.0) 3,183.0 .0 4,362.0 717.0 295.0 458.0 17,137.0 8,761.0 6,077.0 (2,437.0) 3,640.0 28.0 4,362.0 409.0 197.0 621.0 18,018.0 9,259.0 5,698.0 (2,508.0) 3,190.0 31.0 4,362.0 322.0 299.0 744.0 18,207.0 466.0 1,164.0 500.0 478.0 1,144.0 749.0 388.0 1,116.0 500.0 73.0 46.0 411.0 1,180.0 550.0 128.0 103.0 44.0 2,258.0 3,577.0 2,474.0 4,319.0 2,185.0 6,247.0 103.0 69.0 1,278.0 9,882.0 89.0 78.0 1,303.0 7,305.0 1,741.0 1,776.0 34,662.0 (27,458.0) (384.0) 10,337.0 10,337.0 17,642.0 118.0 42.0 1,190.0 8,143.0 1,741.0 1,950.0 37,906.0 (32,130.0) (473.0) 8,994.0 8,994.0 17,137.0 2,123.0 5,303.0 259.0 93.0 78.0 1,255.0 9,111.0 1,741.0 2,110.0 39,898.0 (34,495.0) (347.0) 8,907.0 8,907.0 18,018.0 1,741.0 2,257.0 41,305.0 (36,643.0) (335.0) 8,325.0 8,325.0 18,207.0 466.0 1,164.0 500.0 478.0 1,144.0 749.0 388.0 1,116.0 500.0 73.0 46.0 411.0 1,180.0 550.0 128.0 103.0 44.0 2,258.0 2,123.0 2,474.0 4,319.0 2,185.0 6,247.0 3,577.0 103.0 69.0 1,278.0 9,882.0 89.0 78.0 1,303.0 7,305.0 1,741.0 1,776.0 34,662.0 (27,458.0) (384.0) 10,337.0 10,337.0 17,642.0 118.0 42.0 1,190.0 8,143.0 1,741.0 1,950.0 37,906.0 (32,130.0) (473.0) 8,994.0 8,994.0 17,137.0 5,303.0 259.0 93.0 78.0 1,255.0 9,111.0 1,741.0 2,110.0 39,898.0 (34,495.0) (347.0) 8,907.0 8,907.0 18,018.0 1,741.0 2,257.0 41,305.0 (36,643.0) (335.0) 8,325.0 8,325.0 18,207.0 LIABILITIES + Accounts Payable + Accrued Exp. Curr. Port. of LT Debt Curr. Port. of Leases Curr. Income Taxes Payable Other Current Liabilities Total Current Liabilities Long-Term Debt | Long-Term Leases Pension & Other Post-Retire. Benefits Def. Tax Liability, Non-Curr. Other Non-Current Liabilities Total Liabilities Common Stock Additional Paid In Capital | Retained Earnings #Treasury Stock Comprehensive Inc. and Other Total Common Equity Total Equity Total Liabilities And Equity Supplemental Items Total 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 Debt Debt Equiv. of Unfunded Proj. Benefit Obligat... Debt Equivalent Oper. Leases Equity Method Investments Inventory Method Raw Materials Inventory Work in Progress Inventory Finished Goods Inventory Land Buildings Machinery Full Time Employees Accum. Allowance for Doubtful Accts Order Backlog Filing Date Restatement Type Calculation Type 983.8 983.2 $ 10.51 4,919.0 $ 5.00 4,077.0 (392.0) (121.0) NA 26.0 NA 126.0 1,089.0 742.0 127.0 2,467.0 2,195.0 29,714 8.0 NA Feb-20-2020 NC RUP 938.5 945.2 $ 9.52 3,915.0 $ 4.14 5,068.0 835.0 6.0 NA 21.0 NA 181.0 1,070.0 966.0 128.0 2,497.0 2,800.0 29,888 19.0 1,500.0 Feb-20-2020 NC REP 934.0 932.0 $ 9.56 4,136.0 $ 4.44 6,135.0 748.0 (107.0) 856.0 24.0 NA 176.0 916.0 909.0 126.0 2,504.0 3,110.0 29,768 8.0 1,000.0 Feb-20-2020 o REP 917.9 917.6 $ 9.07 3,641.0 $ 3.97 6,797.0 1,279.0 NA NA 27.0 NA 192.0 959.0 921.0 NA NA NA NA 12.0 NA Oct-21-2020 o REP Income Statement Restatement: Latest Filings Enable Freeze Panes Template: Standard Period Type: Annual 2015 Order: Latest on Right Go More Options >> View All 2016 2017 2018 2019 2020 In Millions of the reported currency, except per share items. Chart Selected Items For the Fiscal Period Ending Currency Reclassified 12 months Dec-31-2017 USD 12 months Dec-31-2018 USD 12 months Dec-31-2019 USD LTM 12 months Sep-30-2020 USD 14,961.0 15,784.0 14,383.0 13,735.0 14,961.0 5,347.0 9,614.0 15,784.0 5,507.0 10,277.0 1,716.0 1,559.0 14,383.0 5,219.0 9,164.0 1,650.0 1,544.0 13,735.0 5,015.0 8,720.0 1,629.0 1,528.0 1,754.0 1,508.0 318.0 318.0 288.0 201.0 13.0 3,580.0 6,034.0 (78.0) 3,593.0 6,684.0 (125.0) 3,482.0 5,682.0 (170.0) 3,371.0 5,349.0 (187.0) (78.0) 135.0 6,091.0 (11.0) (125.0) 130.0 6,689.0 (6.0) (170.0) 180.0 5,692.0 15.0 (187.0) 196.0 5,358.0 (9.0) 3.0 21.0 (2.0) # Revenue Other Revenue Total Revenue Cost Of Goods Sold Gross Profit Selling General & Admin Exp. # R & D Exp. Depreciation & Amort. Amort. of Goodwill and Intangibles Other Operating Expense/(Income) Other Operating Exp., Total Operating Income Interest Expense Interest and Invest. Income Net Interest Exp. Other Non-Operating Inc. (Exp.) EBT Excl. Unusual Items Restructuring Charges Impairment of Goodwill + Gain (Loss) On Sale Of Assets Other Unusual Items EBT Incl. Unusual Items Income Tax Expense Earnings from Cont. Ops. Earnings of Discontinued Ops. Extraord. Item & Account. Change Net Income to Company Minority Int. in Earnings Net Income Pref. Dividends and Other Adj. NI to Common Incl Extra Items NI to Common Excl. Extra Items Per Share Items Basic EPS Basic EPS Excl. Extra Items Weighted Avg. Basic Shares Out. Diluted EPS Diluted EPS Excl. Extra Items Weighted Avg. Diluted Shares Out. Normalized Basic EPS Normalized Diluted EPS 5,728.0 6,080.0 2,398.0 3,682.0 6,686.0 1,106.0 5,580.0 711.0 5,017.0 5,347.0 370.0 4,977.0 3,682.0 5,580.0 5,017.0 4,977.0 3,682.0 5,017.0 4,977.0 32.0 26.0 34.0 3,648.0 3,648.0 5,580.0 43.0 5,537.0 5,537.0 4,985.0 4,985.0 4,951.0 4,951.0 $ 3.68 3.68 991.0 $ 5.33 5.33 936.0 $ 5.36 5.36 924.0 $ 3.61 3.61 1,012.0 $ 3.84 3.76 $ 5.71 5.71 970.0 $ 5.59 5.59 990.0 $ 4.31 4.22 $ 5.24 5.24 952.0 $ 5.28 5.28 937.0 $ 3.62 3.57 $ 3.80 3.74 Balance Sheet Standard Restatement: Template: Period Type: Latest Filings Latest on Right Annual Order: Go Enable Freeze Panes More Options >> View All 2015 2016 2017 2018 2019 2020 Dec-31-2017 USD Dec-31-2018 USD Dec-31-2019 USD Sep-30-2020 USD 2,438.0 1,795.0 4,233.0 1,207.0 1,207.0 2,217.0 440.0 2,437.0 2,950.0 5,387.0 1,074.0 1,074.0 2,001.0 299.0 2,822.0 2,696.0 5,518.0 1,392.0 1,392.0 2,072.0 277.0 In Millions of the reported currency, except per share items. Chart Selected Items Balance Sheet as of: Currency ASSETS Cash And Equivalents Short Term Investments Total Cash & ST Investments Accounts Receivable Total Receivables Inventory Prepaid Exp. Other Current Assets Total Current Assets Gross Property, Plant & Equipment Accumulated Depreciation Net Property, Plant & Equipment Long-term Investments # Goodwill Other Intangibles Deferred Tax Assets, LT Other Long-Term Assets Total Assets LIABILITIES Accounts Payable # Accrued Exp. + Curr. Port. of LT Debt Curr. Port. of Leases + Curr. Income Taxes Payable Other Current Liabilities Total Current Liabilities Long-Term Debt # Long-Term Leases Pension & Other Post-Retire. Benefits Def. Tax Liability, Non-Curr. Other Non-Current Liabilities Total Liabilities Common Stock Additional Paid In Capital #Retained Earnings # Treasury Stock Comprehensive Inc. and Other Total Common Equity Total Equity Total Liabilities And Equity 1,656.0 2,813.0 4,469.0 1,278.0 1,278.0 1,957.0 768.0 262.0 8,734.0 4,789.0 (2,125.0) 2,664.0 32.0 4,362.0 1,056.0 264.0 530.0 17,642.0 8,097.0 5,425.0 (2,242.0) 3,183.0 .0 4,362.0 717.0 295.0 458.0 17,137.0 8,761.0 6,077.0 (2,437.0) 3,640.0 28.0 4,362.0 409.0 197.0 621.0 18,018.0 9,259.0 5,698.0 (2,508.0) 3,190.0 31.0 4,362.0 322.0 299.0 744.0 18,207.0 466.0 1,164.0 500.0 478.0 1,144.0 749.0 388.0 1,116.0 500.0 73.0 46.0 411.0 1,180.0 550.0 128.0 103.0 44.0 2,258.0 3,577.0 2,474.0 4,319.0 2,185.0 6,247.0 103.0 69.0 1,278.0 9,882.0 89.0 78.0 1,303.0 7,305.0 1,741.0 1,776.0 34,662.0 (27,458.0) (384.0) 10,337.0 10,337.0 17,642.0 118.0 42.0 1,190.0 8,143.0 1,741.0 1,950.0 37,906.0 (32,130.0) (473.0) 8,994.0 8,994.0 17,137.0 2,123.0 5,303.0 259.0 93.0 78.0 1,255.0 9,111.0 1,741.0 2,110.0 39,898.0 (34,495.0) (347.0) 8,907.0 8,907.0 18,018.0 1,741.0 2,257.0 41,305.0 (36,643.0) (335.0) 8,325.0 8,325.0 18,207.0 466.0 1,164.0 500.0 478.0 1,144.0 749.0 388.0 1,116.0 500.0 73.0 46.0 411.0 1,180.0 550.0 128.0 103.0 44.0 2,258.0 2,123.0 2,474.0 4,319.0 2,185.0 6,247.0 3,577.0 103.0 69.0 1,278.0 9,882.0 89.0 78.0 1,303.0 7,305.0 1,741.0 1,776.0 34,662.0 (27,458.0) (384.0) 10,337.0 10,337.0 17,642.0 118.0 42.0 1,190.0 8,143.0 1,741.0 1,950.0 37,906.0 (32,130.0) (473.0) 8,994.0 8,994.0 17,137.0 5,303.0 259.0 93.0 78.0 1,255.0 9,111.0 1,741.0 2,110.0 39,898.0 (34,495.0) (347.0) 8,907.0 8,907.0 18,018.0 1,741.0 2,257.0 41,305.0 (36,643.0) (335.0) 8,325.0 8,325.0 18,207.0 LIABILITIES + Accounts Payable + Accrued Exp. Curr. Port. of LT Debt Curr. Port. of Leases Curr. Income Taxes Payable Other Current Liabilities Total Current Liabilities Long-Term Debt | Long-Term Leases Pension & Other Post-Retire. Benefits Def. Tax Liability, Non-Curr. Other Non-Current Liabilities Total Liabilities Common Stock Additional Paid In Capital | Retained Earnings #Treasury Stock Comprehensive Inc. and Other Total Common Equity Total Equity Total Liabilities And Equity Supplemental Items Total 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 Debt Debt Equiv. of Unfunded Proj. Benefit Obligat... Debt Equivalent Oper. Leases Equity Method Investments Inventory Method Raw Materials Inventory Work in Progress Inventory Finished Goods Inventory Land Buildings Machinery Full Time Employees Accum. Allowance for Doubtful Accts Order Backlog Filing Date Restatement Type Calculation Type 983.8 983.2 $ 10.51 4,919.0 $ 5.00 4,077.0 (392.0) (121.0) NA 26.0 NA 126.0 1,089.0 742.0 127.0 2,467.0 2,195.0 29,714 8.0 NA Feb-20-2020 NC RUP 938.5 945.2 $ 9.52 3,915.0 $ 4.14 5,068.0 835.0 6.0 NA 21.0 NA 181.0 1,070.0 966.0 128.0 2,497.0 2,800.0 29,888 19.0 1,500.0 Feb-20-2020 NC REP 934.0 932.0 $ 9.56 4,136.0 $ 4.44 6,135.0 748.0 (107.0) 856.0 24.0 NA 176.0 916.0 909.0 126.0 2,504.0 3,110.0 29,768 8.0 1,000.0 Feb-20-2020 o REP 917.9 917.6 $ 9.07 3,641.0 $ 3.97 6,797.0 1,279.0 NA NA 27.0 NA 192.0 959.0 921.0 NA NA NA NA 12.0 NA Oct-21-2020 o REP Income Statement Restatement: Latest Filings Enable Freeze Panes Template: Standard Period Type: Annual 2015 Order: Latest on Right Go More Options >> View All 2016 2017 2018 2019 2020 In Millions of the reported currency, except per share items. Chart Selected Items For the Fiscal Period Ending Currency Reclassified 12 months Dec-31-2017 USD 12 months Dec-31-2018 USD 12 months Dec-31-2019 USD LTM 12 months Sep-30-2020 USD 14,961.0 15,784.0 14,383.0 13,735.0 14,961.0 5,347.0 9,614.0 15,784.0 5,507.0 10,277.0 1,716.0 1,559.0 14,383.0 5,219.0 9,164.0 1,650.0 1,544.0 13,735.0 5,015.0 8,720.0 1,629.0 1,528.0 1,754.0 1,508.0 318.0 318.0 288.0 201.0 13.0 3,580.0 6,034.0 (78.0) 3,593.0 6,684.0 (125.0) 3,482.0 5,682.0 (170.0) 3,371.0 5,349.0 (187.0) (78.0) 135.0 6,091.0 (11.0) (125.0) 130.0 6,689.0 (6.0) (170.0) 180.0 5,692.0 15.0 (187.0) 196.0 5,358.0 (9.0) 3.0 21.0 (2.0) # Revenue Other Revenue Total Revenue Cost Of Goods Sold Gross Profit Selling General & Admin Exp. # R & D Exp. Depreciation & Amort. Amort. of Goodwill and Intangibles Other Operating Expense/(Income) Other Operating Exp., Total Operating Income Interest Expense Interest and Invest. Income Net Interest Exp. Other Non-Operating Inc. (Exp.) EBT Excl. Unusual Items Restructuring Charges Impairment of Goodwill + Gain (Loss) On Sale Of Assets Other Unusual Items EBT Incl. Unusual Items Income Tax Expense Earnings from Cont. Ops. Earnings of Discontinued Ops. Extraord. Item & Account. Change Net Income to Company Minority Int. in Earnings Net Income Pref. Dividends and Other Adj. NI to Common Incl Extra Items NI to Common Excl. Extra Items Per Share Items Basic EPS Basic EPS Excl. Extra Items Weighted Avg. Basic Shares Out. Diluted EPS Diluted EPS Excl. Extra Items Weighted Avg. Diluted Shares Out. Normalized Basic EPS Normalized Diluted EPS 5,728.0 6,080.0 2,398.0 3,682.0 6,686.0 1,106.0 5,580.0 711.0 5,017.0 5,347.0 370.0 4,977.0 3,682.0 5,580.0 5,017.0 4,977.0 3,682.0 5,017.0 4,977.0 32.0 26.0 34.0 3,648.0 3,648.0 5,580.0 43.0 5,537.0 5,537.0 4,985.0 4,985.0 4,951.0 4,951.0 $ 3.68 3.68 991.0 $ 5.33 5.33 936.0 $ 5.36 5.36 924.0 $ 3.61 3.61 1,012.0 $ 3.84 3.76 $ 5.71 5.71 970.0 $ 5.59 5.59 990.0 $ 4.31 4.22 $ 5.24 5.24 952.0 $ 5.28 5.28 937.0 $ 3.62 3.57 $ 3.80 3.74Step 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