show work in excel with formulas and cell infomation. thank you.

G D H Place your answer in the corresponding answer box for each question. Failure to do so will result in no credit. Further, your work must support your answer or you will not receive credit 5 T IS. Use the financial information below for Crary Day, Inc. for the following questions. 1 10 Balance Sheet 2017 Cash $ Accounts receive Inventory Other currents Total current assets 123,985 S 365,000 540,000 9,560 1,038, 545 13 14 2018 159 ROS 348,960 350.000 9.780 877,516 2017 689.000 162 300 6,80 858,180 Accounts payable Accrued expenses Other current abates Total current liabilities 2018 626 500 178,500 6,800 811,899 16 17 18 Long-term debet Total long-term abilities 895 600 895.600 885.000 885,900 Property, plant, and equipment, gross Accumulated depreciation Property, plant, and equipment, net 4,569,098 02.196013) 2,173,085 4.750.986 (2.244.238) 2.505,78 Total liabilities 20 1,753,780 1,697.799 22 Owens quity Rendering Totalmersity 759.850 698 000 1.457.850 759,850 926,645 Total assets 3,211,630 3.384,294 Total liabilities and owners' equity 3,211,630 3,384,294 28 Income Statement 30 11 Sales Cost of goods sold Selling and administrative expenses Depreciation Operating income Totest pse Pretax income Tunes Net Income 2017 1,050.000 438.000 117,000 198,500 296,500 3.540 292,960 61,522 231 438 2018 1,350,000 461,800 370,168 225 400 292,632 3,208 289.424 60729 228,645 35 36 37 C D 228,645 Net Income 231,438 38 39 40 What is net capital spending for 2018? 42 43 44 What is the operating cash flow for 2018? 45 46 47 48 What is cash flow to the firm for 2018? 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 06 67 Calculate the following raties based on the financial statements above: Current Ratio Inventory Turnover Days in receivables Return on equity 69 70 Capital intensity