Please provide solution with formulas

Thank you

IE5-2 Preparing an Income Statement and a Balance Sheet from a Trial Balance The following is a list of accounts for Solodia Company: Required: Use the list of accounts to: 1. Prepare a Multiple Step Income Statement in good form. Note: Maintain the order in which the accounts appear in the list. 2. Prepare a Classified Balance Sheet. Note: Maintain Current Assets and Current Liabilities in order of liquidity. 3. Compute Return on Assets rounded to one decimal place. 4. Compute Earnings per Share rounded to the nearest cent. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. Required: Use the list of accounts to: 1. Prepare a Multiple Step Income Statement in good form. Note: Maintain the order in which the accounts appear in the list. 2. Prepare a Classified Balance Sheet. Note: Maintain Current Assets and Current Liabilities in order of liquidity. 3. Compute Return on Assets. 4. Compute Earnings per Share. 87 Liabilities and Stockholders' Equity 88 Current Liabilities: 89 Accounts Payable 90 Income Tax Payable 91 Notes Payable 92 Salaries and Wages Payable