Z ECP 3 0 Protected View Home Insert Page Layout Dots Review View i Protected Www This file ongnated from an internet location and might be una chick for more deta nabledding - Complete the ratios using the data available for Automatic Data Processing (ADP.) Using Ratio Computation Complete the ratios using the data available for Automatic Data Processing (ADP.) Using actual financial stateme decisions. For example, ADP has no inventory listed, so the quick ratio is the same as the current ratio. But, shoul Included as cash in the cash ratio? We chose not to include them, but a strong argument can be made for its incle 2015 2014 Short-Term Solvency, or Liquidity, Measures Current ratio Quick ratio: Cash ratio: Long-Term Solvency Measures Total debt ratio: Debt-equity ratio: Equity multiplier Times interest earned: Cash coverage Asset Management, or Turnover, Measures Inventory turnover: Days' sales in Inventory: Receivables turnover Days' sales in receivables: Total asset turnover Profitability Measures Profit marging Return on assets (ROA): Return on equity (ROE): Dan TARD e 99 F nancial statements introduces students to real world atio. But, should short term marketable securities be made for its inclusion. PM TAT* EM ROE Dupont Identity Return on equity (ROE): The originated from an Internet location and might be unsate. Chick for more detaili r able Editing Complete the ratios using the data available for Automatic Data Processing (ADP) Using actual financial statements introduces students to real wo Polected View Automatic Data Processing (ADP) Jun 30, 2015 Jun 30, 2014 Commonsize 2015 2014 $ 7,928.3 $ 7,595.4 377.7 2,632.5 10,938.5 373.4 2,257.6 10,226.4 5,290.8 5512 5,625.3 595.4 206.9 6,427.6 2,496.9 6,041 2,370.3 B&BOOBS 65 61 REVENUES: Revenues, other than interest on funds held for clients and PEO revenues Interest on funds held for dients PEO revenues TOTAL REVENUES EXPENSES: Operating expenses Systems development and programming costs Depreciation and amortiration TOTAL COSTS OF REVENUES Selling Reneral and administrative expenses Goodwill impairment Interest expense TOTAL EXPENSES Other income, net EARNINGS FROM CONTINUING OPERATIONS BEFORE INCOME TAXES Provision for income taxes NET EARNINGS FROM CONTINUING OPERATIONS EARNINGS FROM DISCONTINUED OPERATIONS BEFORE INCOME TAXES Provision for income taxes NET EARNINGS FROM DISCONTINUED OPERATIONS NET EARNINGS Basic Emines Per Share from Continuing Operations Basic earnings per share from discontinued operations BASIC EARNINGS PER SHARE Diluted earnings per share from continuing operations Diluted earnings per share from discontinued operations DILUTED EARNINGS PER SHARE Basic weighted average shares outstanding Diluted weighted average shares outstanding 8,931 (63.2) 2,070.7 8,417.4 (70.21 1,879.2 6.36.6 1,242.6 1,376.5 171.5 414.9 141.6 2733 $1,452.5 $2.91 0.16 3.07 2.89 $1.515.9 $2.59 0.57 3.17 2.57 0.57 0.16 $3.05 72.6 $ 3.14 475.8 483.1 ginated from an inte location and might be uale. Click for more details. Erable doing Complete the ratios using the data available for Automatic Data Processing (ADP.) Using actual financial statements introduces students to O Po w e Commonsize Jun 30, 2014 Jun 30, 2015 $1,619.3 26.6 1,565.9 $1,5 2,032.2 1,498.8 33 39 BSRB 2,430.2 Consolidated Balance Sheets USD [S] Sin Millions Assets Cash and cash equivalents Short-term marketable securities Accounts receivable, net Other current sets Assets of discontinued operations Total current assets before funds held for dients Funds held for clients Total current assets Long-term marketable securities Long term receivables, net Property, plant and Equipment, Net Other arts Goodwill Intangible wets, net Total assets 3,239 24.355.3 28,8092 322 672.7 1.220.8 1793.5 50? 33, 110.5 22,059.8 1945 627,3 Accounts payable Accrued expenses and other current liabilities Accrued payroll and payroll related expenses Dividends payable Short-term deferred revenues Obligations under commercial paper borrowing Income taxes payable Liabilities of discontinued operations Total current liabilities before client funds obligations Cent funds obligations Total current liabilities Long-term debt Other abilities Deferred income taxes Long term deferred revenues 24,650.5 6443 172.1 27.2 2,463.2 24,650.5 27,113.7 Short-term deferred revenues Obligations under commercial paper borrowing Income taxes payable Liabilities of discontinued operations Total current liabilities before client funds obligations Client funds obligations Total current liabilities Long term debt Other liabilities Deferred income taxes Long-term deferred revenues Total liabilities Stockholders' equity: Preferred stock. $1.00 par value: Authorized, 0.3 shares, issued, none Common stock, 50.10 par value: Authorized, 1,000.0 shares; issued 638.7 shares at June 30, 2014 and June 30, 2013; outstanding. 480.2 and 482.6 shares at June 30, 2014 and 2013, respectively Capital in excess of par value Retained earnings Treasury stock - at cost: 158.5 and 156.1 shares at June 30, 2014 and June 30, 2013, respectively Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity 2,173 19.7 601.5 5,204.2 18,163.4 24,167.6 11.5 619.4 215.9 375,2 25,389.6 644.3 172.1 362.7 28, 302 63.9 63.9 663.3 101 13,460.3 (9,118.4) 545.2 13,632.9 (7,750) 102 103 104 105 (260.6) 4,808.5 $ 33, 110.5 178.2 6,670.2 $32,059.8 Ready e 9 E Z ECP 3 0 Protected View Home Insert Page Layout Dots Review View i Protected Www This file ongnated from an internet location and might be una chick for more deta nabledding - Complete the ratios using the data available for Automatic Data Processing (ADP.) Using Ratio Computation Complete the ratios using the data available for Automatic Data Processing (ADP.) Using actual financial stateme decisions. For example, ADP has no inventory listed, so the quick ratio is the same as the current ratio. But, shoul Included as cash in the cash ratio? We chose not to include them, but a strong argument can be made for its incle 2015 2014 Short-Term Solvency, or Liquidity, Measures Current ratio Quick ratio: Cash ratio: Long-Term Solvency Measures Total debt ratio: Debt-equity ratio: Equity multiplier Times interest earned: Cash coverage Asset Management, or Turnover, Measures Inventory turnover: Days' sales in Inventory: Receivables turnover Days' sales in receivables: Total asset turnover Profitability Measures Profit marging Return on assets (ROA): Return on equity (ROE): Dan TARD e 99 F nancial statements introduces students to real world atio. But, should short term marketable securities be made for its inclusion. PM TAT* EM ROE Dupont Identity Return on equity (ROE): The originated from an Internet location and might be unsate. Chick for more detaili r able Editing Complete the ratios using the data available for Automatic Data Processing (ADP) Using actual financial statements introduces students to real wo Polected View Automatic Data Processing (ADP) Jun 30, 2015 Jun 30, 2014 Commonsize 2015 2014 $ 7,928.3 $ 7,595.4 377.7 2,632.5 10,938.5 373.4 2,257.6 10,226.4 5,290.8 5512 5,625.3 595.4 206.9 6,427.6 2,496.9 6,041 2,370.3 B&BOOBS 65 61 REVENUES: Revenues, other than interest on funds held for clients and PEO revenues Interest on funds held for dients PEO revenues TOTAL REVENUES EXPENSES: Operating expenses Systems development and programming costs Depreciation and amortiration TOTAL COSTS OF REVENUES Selling Reneral and administrative expenses Goodwill impairment Interest expense TOTAL EXPENSES Other income, net EARNINGS FROM CONTINUING OPERATIONS BEFORE INCOME TAXES Provision for income taxes NET EARNINGS FROM CONTINUING OPERATIONS EARNINGS FROM DISCONTINUED OPERATIONS BEFORE INCOME TAXES Provision for income taxes NET EARNINGS FROM DISCONTINUED OPERATIONS NET EARNINGS Basic Emines Per Share from Continuing Operations Basic earnings per share from discontinued operations BASIC EARNINGS PER SHARE Diluted earnings per share from continuing operations Diluted earnings per share from discontinued operations DILUTED EARNINGS PER SHARE Basic weighted average shares outstanding Diluted weighted average shares outstanding 8,931 (63.2) 2,070.7 8,417.4 (70.21 1,879.2 6.36.6 1,242.6 1,376.5 171.5 414.9 141.6 2733 $1,452.5 $2.91 0.16 3.07 2.89 $1.515.9 $2.59 0.57 3.17 2.57 0.57 0.16 $3.05 72.6 $ 3.14 475.8 483.1 ginated from an inte location and might be uale. Click for more details. Erable doing Complete the ratios using the data available for Automatic Data Processing (ADP.) Using actual financial statements introduces students to O Po w e Commonsize Jun 30, 2014 Jun 30, 2015 $1,619.3 26.6 1,565.9 $1,5 2,032.2 1,498.8 33 39 BSRB 2,430.2 Consolidated Balance Sheets USD [S] Sin Millions Assets Cash and cash equivalents Short-term marketable securities Accounts receivable, net Other current sets Assets of discontinued operations Total current assets before funds held for dients Funds held for clients Total current assets Long-term marketable securities Long term receivables, net Property, plant and Equipment, Net Other arts Goodwill Intangible wets, net Total assets 3,239 24.355.3 28,8092 322 672.7 1.220.8 1793.5 50? 33, 110.5 22,059.8 1945 627,3 Accounts payable Accrued expenses and other current liabilities Accrued payroll and payroll related expenses Dividends payable Short-term deferred revenues Obligations under commercial paper borrowing Income taxes payable Liabilities of discontinued operations Total current liabilities before client funds obligations Cent funds obligations Total current liabilities Long-term debt Other abilities Deferred income taxes Long term deferred revenues 24,650.5 6443 172.1 27.2 2,463.2 24,650.5 27,113.7 Short-term deferred revenues Obligations under commercial paper borrowing Income taxes payable Liabilities of discontinued operations Total current liabilities before client funds obligations Client funds obligations Total current liabilities Long term debt Other liabilities Deferred income taxes Long-term deferred revenues Total liabilities Stockholders' equity: Preferred stock. $1.00 par value: Authorized, 0.3 shares, issued, none Common stock, 50.10 par value: Authorized, 1,000.0 shares; issued 638.7 shares at June 30, 2014 and June 30, 2013; outstanding. 480.2 and 482.6 shares at June 30, 2014 and 2013, respectively Capital in excess of par value Retained earnings Treasury stock - at cost: 158.5 and 156.1 shares at June 30, 2014 and June 30, 2013, respectively Accumulated other comprehensive income Total stockholders' equity Total liabilities and stockholders' equity 2,173 19.7 601.5 5,204.2 18,163.4 24,167.6 11.5 619.4 215.9 375,2 25,389.6 644.3 172.1 362.7 28, 302 63.9 63.9 663.3 101 13,460.3 (9,118.4) 545.2 13,632.9 (7,750) 102 103 104 105 (260.6) 4,808.5 $ 33, 110.5 178.2 6,670.2 $32,059.8 Ready e 9 E