Show work of B please without excel. Thank you.

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 $12.600 Accounts payable $30,700 Addition to retained earnings $18.900 Accruals $30,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 S157,600 After Tax Cost of Capital Total liabilities and equity $311,600 (WACC) 12% RATIO Plug N 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. C. Construct the three factors Du Pont equation for both Plug N Play and the industry Industry Average 2.8 X 10 X 30 days SX 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) 1.8 X 40% 10 X 8% 12% 22%