Reference Data table Requirements 1. Use the data in the partial worksheet to prepare Emerson Production Company's classified balance sheet at December 31 of the current year. Use the report format. First you must calculate the adjusted balance for several of the balance-sheet accounts. 2. Calculate Emerson Production Company's net working capital, current ratio, and debt ratio at December 31. A year ago, net working capital was $5,790, the current ratio was. 1.66, and the debt ratio was 0.53 . Indicate whether the company's ability to pay its debts - both current and total-improved or deteriorated during the current year. Data table Requirement 1. Use the data in the partial worksheet to prepare Emerson Production Company's classified balance sheet at December 31 of the current year. Use the report format. First you must calculate the adjusted balance for several of the balance-sheet accounts. Let's prepare the balance sheet for Emerson Production Company. (If an input field is not used in the balance sheet leave the field empty, do not select a label or enter a zero.)