Part 1

You will use this Excel workbook with two worksheets to assist you in completing this part of the assessment. The first worksheet is the Balance Sheet and Income Statement for ABC Company. The second worksheet contains a breakdown of categories of ratios where you will complete the calculations for each ratio. You will also enter the formula written out as to what information you have used to do the calculations.

ABOVE are the 3 spreads with data the professor provided in order to fill in the below spread.

Appendix A Technology 3-Year Average for Industry Averages Profitability Gross Margin Operating Profit Margin 66.15% Net Profit Margin 12.04% Earnings per Share 6.01% 1.49 Management Effectiveness Return on Equity Return on Assets Return on Investment Quick Ratio Current Ratio Debt-to-Equity Total Debt to Equity 12.40% 5.61% 14.42 2.87 2.57 61.01% 57.08% Efficiency Total Asset Turnover Inventory Turnover 0.55 Accounts Receivable Turnover 44.98 8.21 Ratio Calculations Liquidity Ratios Current Ratio Quick Ratio Activity Ratios Inventory Turnover Accounts Recievables Turnover Total Asset Turnover Average Collection Period Financing Ratios Debt Ratio Debt-to-Equity Ratio Times Interest Earned Ratio Market Ratios Earnings per Share (EPS) Price Earnings (PE) Profitability Ratios Return on Equity (ROE) Return on Assets (ROA) Net Profit Margin Operating Profit Margin 2015 2014 2013 Formula Used (Write out formulas)