Find the following using the excel info above:

1. find return on assets (ROA)

2. find return on equity (ROE)

3. find return on invested capital (ROIC)

4. find debt to assets ratio

5. find debt to equity ratio

6. find current ratio

7. find firms times interest earned

8. find cash conversion cycle (CCC)

please explain work/ formulas!

Assumptions Corporate tax rate 21% Income Statement Sales Cost of goods sold Gross margin Sales, general, and administraive expense Depreciation expense EBIT Interest Expense EBT Taxes Earnings $ 1,000.00 $ 500.00 $ 500.00 $ 100.00 $ 200.00 $ 200.00 $ 50.00 net income $ 150.00 $ $ 31.50 $ 118.50 150.00 Balance Sheet Cash Accounts receivable Inventory Total Current Assets $ 300.00 Accounts payable $ 500.00 Current portion of Long-term-debt $ 200.00 Short-term debt $ 1,000.00 Total current liabilities $ 500.00 $ 100.00 $ 100.00 $ 700.00 $ 500.00 $ 1,200.00 Property, plant, and equipment Accumulated depreciation Net property, plant and equipment Long-term debt $ 1,000.00 Total liabilities $ 400.00 $ 600.00 Common stock at par value Additional paid in capital Retained earnings Total shareholders' equity $ 50.00 $ 250.00 $ 100.00 $ 400.00 Total assets $ 1,600.00 Total liabilities and shareholders' equity $ 1,600.00 ROA ROE $0.12 $0.301 Assumptions Corporate tax rate 21% Income Statement Sales Cost of goods sold Gross margin Sales, general, and administraive expense Depreciation expense EBIT Interest Expense EBT Taxes Earnings $ 1,000.00 $ 500.00 $ 500.00 $ 100.00 $ 200.00 $ 200.00 $ 50.00 net income $ 150.00 $ $ 31.50 $ 118.50 150.00 Balance Sheet Cash Accounts receivable Inventory Total Current Assets $ 300.00 Accounts payable $ 500.00 Current portion of Long-term-debt $ 200.00 Short-term debt $ 1,000.00 Total current liabilities $ 500.00 $ 100.00 $ 100.00 $ 700.00 $ 500.00 $ 1,200.00 Property, plant, and equipment Accumulated depreciation Net property, plant and equipment Long-term debt $ 1,000.00 Total liabilities $ 400.00 $ 600.00 Common stock at par value Additional paid in capital Retained earnings Total shareholders' equity $ 50.00 $ 250.00 $ 100.00 $ 400.00 Total assets $ 1,600.00 Total liabilities and shareholders' equity $ 1,600.00 ROA ROE $0.12 $0.301