ABC Company: Fill in the empty boxes

The attached problem has the financial statements with the empty boxes to fill.

Cutting Edge B2B Inc. Financial Plan 2011 Actual 2012 Actual 2013 Actual 2014 Actual Income Statement (Mil.$) Sales Cost of Goods Sold Gross Profit $73.84 $41.83 $93.28 $58.39 $115.93 $75.49 $138.84 $89.83 Selling, Gen & Adm Expenses Depreciation Expense EBIT $6.58 $5.91 $7.28 $6.37 $8.56 $7.31 $10.21 $9.86 Interest Expense Taxes Net Income Shares Outstanding (Millions) Earnings Per Share $4.76 $6.21 $5.23 $6.96 $6.69 $7.52 $8.88 $7.60 39.60 $0.00 40.36 $0.00 44.93 $0.00 53.91 $0.00 Allocation of Net Income: Dividends Addition to Retained Earnings $2.90 $3.17 $3.63 $4.36 Market Price / Share $6.21 $6.57 $6.68 $6.71 $4.27 $20.58 $26.73 $6.38 $24.39 $30.45 $7.62 $28.77 $36.75 $8.83 $34.11 $43.27 $331.64 $98.72 $423.92 $105.09 $503.87 $112.40 $613.28 $122.26 $31.83 $30.86 $63.43 $43.03 $83.84 $64.85 $94.41 $79.49 $90.00 $91.81 $130.00 $160.00 $220.00 Balance Sheet (Mil.$) Assets Current Assets Cash & Equivalents Accounts Receivables Inventories Total Current Assets Property, Plant & Equip. (PPE) Accumulated Depreciation Net PPE Total Assets Liabilities and Shareholders' Equity Current Liabilities Accounts Payable Short-term Debt Total Current Liabilities Long-term Debt Total Liabilities Shareholders' Equity Paid-in Capital Retained Earnings Total Shareholders' Equity Total Liab. & Share. Equity Cutting Edge B2B Inc. Financial Ratios Profitability Gross Profit Margin Operating Profit Margin Net Profit Margin Return On Assets (ROA) Return On Equity (ROE) Liquidity Current Quick Financial Leverage Debt to Total Assets Times Interest Earned Asset Turnover Ave. Collection Period Inventory Turnover Total Asset Turnover Market Value Price to Earnings (P/E Ratio) Market to Book Value 2011 Actual 2012 Actual 2013 Actual 2014 Actual DuPont System The following data are from Saratoga Farms, Inc, 2014 financial statement: Sales Net Income Total Assets Debt to TA Ratio $2,000,000 $200,000 $1,000,000 60% 1. Construct and solve the DuPont and Modified DuPont equations for Saratoga Farms. 2. What would be the impact on ROE if the debt to TA ratio were 80%? 3. What would be the impact on ROE if the debt to TA were 20%? Industry Comparisons Carrie White, the new financial analyst of Golden Products, Inc., has been given the task of reviewing the performance of her company over three recent years against the following industry information (figures in $000): Net Current Current Total Total Year Income Assets Liabilities Assets Liabilities 2012 $400 $500 $530 $3,800 $2,600 2013 425 520 510 3,900 2,500 2014 440 550 510 4,000 2,400 Sales $4,000 4,500 4,700 The industry averages are: Total Current Asset NI/Sale Ratio Turnover 0.0942 1.13 2.00 Should Carrie be critical of her company's performance? Be sure to calculate and show the required ratios for each year and the average for the three years using formulas