Question 12 Complete the balance sheet of Crane Corporation, (Round answers to the nearest whole dollar, e.o. 125. Use 365 days for calculation.) Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update any values that may have been pre entered in the template based on the textbook version of the problem.) Crane Corporation Balance Sheet as of December 31, 2017 Assets: Cash and marketable securities Accounts receivable Inventory Liabilities and Equity Accounts payable and accruals Notes payable 4870 Accounts pavable and acous 300,000 Total current lRiabilities Long-term debt Common stock Retained earnings Total liabilities and equity Total current assets $2,000,000 Net plant and equipment $1,250,000 Total assets $8,000,000 You have the following information: Debt ratio DSO Current rat Inventory turnover ratio 5.000 Net sales Cost of goods sold$2,0480 million 40% 33 days $1.71 milion Click if you would like to Show Work for this question: OSh