Balance Sheet ASSETS 12/31/16 12/31/17 Cash Accounts Receivable Inventory TOTAL CURRENT ASSETS $2,165 4,832 3.217 $10,214 Fixed Assets Gross Accum. Depreciation Net Fixed Assets $35,183 (22.640) $12,543 $2,647 5,614 INCOME STATEMENT 2.843 Period ended 12/31/17 $11,104 Sales $40,506 Cost of Goods 14,177 $39,456 Depreciation 2,212 (24.852) Other Expenses $17.275 $14,604 EBIT $6,842 Interest 180 $25,708 EBT $6,662 2.265 Net Income $4,397 TOTAL ASSETS $22,757 1. Calculate the following ratios for 2017 using working Excel formulas. Make sure to label each appropriately using the following cell (number of days, number of times, $,%, etc.) Round each answer to 2 decimal places (example: ROE of .1678 should display as 16.78%) (5 pts cach): a. Current Ratio b. Quick Ratio c. Debt to Equity Ratio d. Equity Multiplier e. Times Interest Earned f. Cash Coverage g. Inventory Turnover h. Days' Sales in Inventory i. Receivables Tumover j. Days' Sales in Receivables k. Total Asset Turnover 1. Profit Margin m. Return on Assets n. Retum on Equity o. P/E Ratio LIABILITIES $1,642 3,100 Accounts Payable Salary Payable TOTAL CURRENT LIABILITIES $1,420 Dividends 1.228 Addition to R/E $2,648 1.297 $2,080 Long-Term Debt TOTAL LIABILITIES S 409 3,057 2. Calculate Return on Equity using the Dupont Equation (10 pts.) S 1.823 3,903 EQUITY 10,000 8.854 $18,854 Common Stock Retained Earnings TOTAL EQUITY 12,500 10.151 $22,651 TOTAL LIABILITIES AND EQUITY TOTANDIABUITIES $22,757 $22,757 $25,708