Need help completing the blue areas

AUTOMATIC DATA PROCESS'NG 'NC Statement of Consolidated Earnings For Year Ended June 30 2019 S millions Total revenues Operating expenses Systems development and programming costs Depreciation and amortization Total cost of revenues Selling, general, and administrative expenses Interest expense Total expenses Other (income) expense, net Earnings before income taxes Prcwision for income taxes Net earnings Assumptions Total revenue growth CAPEX as a percentage of total revenue Depreciation Acquired intangibles as a percentage of total revenue Amortization Prcwision for income taxes Taxes payable Stock-based compensation Stock repurchases Dividends Dividends payable Goodwill, long-term debt, preferred stock common stock and Accumulated other comprehensive loss All other percentages are based on historic percent of total revenues 512, 1911 6,1450 636 3 304 4 7,085 7 2,6351 1120 9,8327 2,454 3 7128 1300% 110% S 184 5276 2500% 770% S 167 5750 S 1,389 2630% AUTOMATIC DATA PROCESSING 'NC aa nce Sheet S millions Current assets Cash and cash equivalents Accounts receivable, net Other current assets Total current assets before funds held for clients Funds held for clients Total current assets lane-term receivables, net Property, plant and equipment, net Capitalized contract cost, net Other assets Goodwill Intangible assets, net Total assets Current liabilities Accounts payable Accrued expenses and other current liabilities Accrued payroll and payroll-related expenses Dividends payable Short-term deferred revenues Obligations under reverse repurchase agreements Income taxes payable Total current liabilities before client funds obligations Client funds obligations Total current liabilities lane-term debt Other liabilities Deferred income taxes Long-term deferred revenues Total liabilities Shareholders' equity June 30 19 Note: Format cells so each amount shows two decimal places. Do not round amounts - use Increase Decima/ or Decrease Decima/ in Excel toolbar to adjust. Then in MSC, enter the answers with two decimal places AUTOMATIC DATA PROCESSING INC. Statement of Consolidated Earnings Year Ended June 30, 2020, S millions Total revenues Operating expenses Systems development and programming costs Depreciation and amortization Total cost of revenues Selling, general, and administrative expenses Interest expense Total expenses Other (income) expense, net Earnings before income taxes Prcwision for income taxes , none 51,676.0 2,439 3 5196 4,634 25 3131 29,947 657 .o 2,428 s 2,323.0 10718 1,5131 7211 2921 3,189 1 25 0 28,2531 2,0022 32,001B 1,167 g 17,500 E (13,090B) (257B) 53846 Net earnings S millions Current assets AUTOMATIC DATA PROCESSING INC. Balance Sheet June 30,2020 Preferred stock SLOO par value; Authorized, OS shares; issued Common stock SCIO par value; Authorized, shares; issued, 6387 shares; outstanding 434.2 shares Capital in excess of par value Retained earnings Treasury stock at cost: 2045 shares Accumulated other comprehensive loss Total stockholders' equity Total liabilities and stockholders' equity growth of total reven u e million % of total revenue million percentage of earnings before income taxes in 2020 % of provision for income taxes in 2020 increases Capital in excess of par value bvthe same amount Assume that the company mutinelv includes this form of compensation in operating expenses each year. million million of dividends No change in S amount Cash and cash equivalents Accounts receivable, net Other current assets Total current assets before funds held for clients Funds held for clients Total current assets lane-term receivables, net Property, plant and equipment, net Capitalized contract cost, net Other assets Goodwill Intangible assets, net Total assets Current liabilities Accounts payable Accrued expenses and other current liabilities Accrued payroll and payroll-related expenses Dividends payable Short-term deferred revenues Obligations under reverse repurchase agreements Income taxes payable Total current liabilities before client funds obligations Client funds obligations Total current liabilities Inns-term debt Other liabilities Deferred income taxes lane-term deferred revenues Total liabilities Shareholders' equity Preferred stock 51.00 par value; Authorized, OS shares; Common stock SCIO par value; Authorized, issued, 638 7 shares; outstanding 434.2 shares Capital in excess of par value Retained earnings Treasury stock at cost: 2045 shares Accumulated other comprehensive loss Total stockholders' equity Total liabilities and stockholders' equity issued , none