Question: Pls do in excel thx. Use the following information for Ingersoll, Inc. Assume the tax rate is 21 percent. 2018 2019 Sales $ 16,073 $

Pls do in excel thx.

Pls do in excel thx. Use the following information for Ingersoll, Inc.

Assume the tax rate is 21 percent. 2018 2019 Sales $ 16,073

$ 15,636 Depreciation 1.751 1,826 Cost of goods sold 4,429 4,797 Other

Use the following information for Ingersoll, Inc. Assume the tax rate is 21 percent. 2018 2019 Sales $ 16,073 $ 15,636 Depreciation 1.751 1,826 Cost of goods sold 4,429 4,797 Other expenses 991 869 Interest 840 971 Cash 6,202 6,736 Accounts receivable 8,130 9,697 Short-term notes 1,260 1,237 payable Long-term debt 20,590 24,861 Net fixed assets 51,086 54,543 Accounts payable 4,528 4,914 Inventory 14,436 15,378 Dividends 1,400 1.708 Prepare a balance sheet for this company for 2018 and 2019. (Do not round intermediate calculations.) INGERSOLL, INC Balance Sheet as of Dec. 31 2018 2019 Assets Prepare a balance sheet for this company for 2018 and 2019. (Do not round intermediate calculations.) INGERSOLL, INC. Balance Sheet as of Dec. 31 2018 2019 Assets Current assets $ 86,354 Total assets Liabilities & Equity Current liabilities $ 6,151 Total liabilities & owners' equity Prepare an income statement for this company for 2018 and 2019. (Enter all answers as positive values. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) TACO SWELL, INC. Income Statement 2018 2019 Sales COGS Other expenses Depreciation EBIT Interest EBT Taxes Net income Dividends Additions to RE

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!