Show work please without excel.

Plug N Play Industries Ltd. Plug N Play Industries Ltd. December 31, 2006 Balance Sheets Income Statements for December 31, 2006 Assets Sales $455,000 Cash and cash equivalents $77,200 Expenses excluding depreciation $387,000 Short-term investments $13,400 EBITDA $68,000 Accounts Receivable S105,800 Depreciation $7.000 Inventories S43.500 EBIT $61.000 Total current assets $239,900 Interest Expense $8,500 Fixed assets $71,700 EBT S52.500 Total assets $311,600 Taxes (40%) $21,000 Net Income $31.500 Liabilities and equity Common dividends S12.600 Accounts payable $30,700 Addition to retained earnings $18.900 Accruals S30,400 Notes payable $16,700 Per Share Data Total current liabilities $77,800 Shares outstanding 10,000 Long-term debt $76,200 EPS 3.15 Total liabilities $154,000 DPS 1.26 Common stock $100,000 Stock Market Price 17.25 Retained Earnings $57,600 Tax rate 40% Total common equity $157,600 After Tax Cost of Capital Total liabilities and equity $311,600 (WACC) 12% Plug N RATIO Play a. Calculate the indicated ratios for Plug N Play and compare with the industry (provided in the following table). b. Based on the findings in part (a) outline Plug N Play's strengths and weaknesses based on liquidity, profitability, solvency, and activity as revealed by your analysis. Current Ratio Inventory Turnover Days Sales Outstanding (DSO) Fixed Asset Turnover (FATO) Total Asset Turnover (TATO) Total debt to total asset Times-Interest-Earned (TIE) Profit Margin on Sales (PM) Return on Asset (ROA) Return on Equity (ROE) Industry Average 2.8 X 10 X 30 days SX 1.8 X 40% 10 X 8% c. Construct the three factors Du Pont equation for both Plug N Play and the industry 12% 22%