pls help thanks

PAINTER VERSION BACK 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. Wh 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 Liabilities and Equity! Assets: Cash and marketable securities Accounts payable and accruals Accounts receivable Notes payable 300,000 Inventory Total current abattles Total current assets Long-term debt $2,000,000 Common stock Net plant and equipment $1.250.000 Retained earnings $8,000,000 Total liabilities and equity Total assets You have the following information: Debt ratio 40% 050 33 days Current Inventory turnover ratio - 5.000 Net sales - $1.71 million Cost of goods sold - $2.0480 million Click if you would like to show Work for this questioni Open So work PAINTER VERSION BACK 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. Wh 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 Liabilities and Equity! Assets: Cash and marketable securities Accounts payable and accruals Accounts receivable Notes payable 300,000 Inventory Total current abattles Total current assets Long-term debt $2,000,000 Common stock Net plant and equipment $1.250.000 Retained earnings $8,000,000 Total liabilities and equity Total assets You have the following information: Debt ratio 40% 050 33 days Current Inventory turnover ratio - 5.000 Net sales - $1.71 million Cost of goods sold - $2.0480 million Click if you would like to show Work for this questioni Open So work