Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Show work of C please without excel. Thank you. Plug N Play Industries Ltd. Plug N Play Industries Ltd. December 31, 2006 Balance Sheets Income
Show work of C 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 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 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 1.8 X 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) 40% 10 X 8% 12% 22%Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started