Please provide a SUBSTANTIAL RESPONSE and show ALL calculations

PROBLEM 1-6 You are an analyst reviewing Foxx Company. The following data are available for your financial Financial analysis (unless otherwise indicated, all data are as of December 31, Year 2): Statement Relations Balance Sheet Days' sales in inventory36 days Gross profit margin ratio . . . . . . . . . . . . . . 50% 16 Accounts receivable turnover. Beginning accounts Return on end-of-year common equity $0,000 Expenses (excluding cost of goods sold).. $450,000 20% recevab Total debt to equity ratio . . . . urrent assets Required Using these data, construct the December 31, Year 2, balance sheet for your analysis. Current as- sets consist of cash, accounts receivable, and inventory. accounts receivable, inventory, total noncurrent assets, total current assets, total current liabilities total noncurrent liabilities, and equity Balance sheet classifications include cash, CHECK Total assets, $500,000