PLEASE HELP ME!!!

Analyze, Forecast, and Interpret Income Statement and Balance Sheet

Following are the income statement and balance sheet of ADP Inc.

Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places.

AUTOMATIC DATA PROCESSING INC.
Statement of Consolidated Earnings
For Year Ended June 30, 2019, $ millions
Total revenues	$11,624.0
Operating expenses	5,860.0
Systems development and programming costs	636.3
Depreciation and amortization	304.4
Total cost of revenues	6,800.7
Selling, general, and administrative expenses	2,513.0
Interest expense	107.0
Total expenses	9,420.7
Other (income) expense, net	(91.0)
Earnings before income taxes	2,294.3
Provision for income taxes	712.8
Net earnings	$1,581.5

AUTOMATIC DATA PROCESSING INC.
Balance Sheet
$ millions	June 30,2019
Current assets
Cash and cash equivalents	$1,598.0
Accounts receivable, net	2,439.3
Other current assets	519.6
Total current assets before funds held for clients	4,556.9
Funds held for clients	24,136.0
Total current assets	28,692.9
Long-term receivables, net	23.8
Property, plant and equipment, net	627.0
Capitalized contract cost, net	2,428.5
Other assets	934.4
Goodwill	2,323.0
Intangible assets, net	1,071.5
Total assets	$36,101.1
Current liabilities
Accounts payable	$125.5
Accrued expenses and other current liabilities	1,442.0
Accrued payroll and payroll-related expenses	721.1
Dividends payable	279.0
Short-term deferred revenues	220.7
Obligations under reverse repurchase agreements	262.0
Income taxes payable	54.8
Total current liabilities before client funds obligations	3,105.1
Client funds obligations	23,898.0
Total current liabilities	27,003.1
Long-term debt	2,002.2
Other liabilities	655.0
Deferred income taxes	659.9
Long-term deferred revenues	399.3
Total liabilities	30,719.5
Shareholders' equity
Preferred stock, $1.00 par value; Authorized, 0.3 shares; issued , none
Common stock, $0.10 par value; Authorized, 1,000.0 shares;
issued, 638.7 shares; outstanding 434.2 shares	63.9
Capital in excess of par value	1,164.9
Retained earnings	17,500.6
Treasury stock, at cost: 204.5 shares	(13,090.5)
Accumulated other comprehensive loss	(257.3)
Total stockholders' equity	5,381.6
Total liabilities and stockholders' equity	$36,101.1

Forecast ADPs 2020 income statement and balance sheet using the following relations ($ millions). Note: Complete the entire question in Excel (template provided above). Using Excel, format each answer to two decimal places. Use Increase Decimal or Decrease Decimal to adjust decimal places. Do not round answers. Then enter the answers into the provided spaces below with _two decimal places_. Note: Use negative signs with answers, when appropriate.

Assumptions
Total revenue growth	13.00%	growth
CAPEX as a percentage of total revenue	1.10%	% of total revenue
Depreciation	$184.4	million
Acquired intangibles as a percentage of total revenue	2.90%	% of total revenue
Amortization	$276.1	million
Provision for income taxes	25.00%	% percentage of earnings before income taxes in 2020
Taxes payable	7.70%	% of provision for income taxes in 2020
Stock-based compensation	$167.3	increases Capital in excess of par value by the same amount. Assume that the company routinely includes this form of compensation in operating expenses each year.
Stock repurchases	$750.0	million
Dividends	$1,389.4	million
Dividends payable	26.30%	% of dividends
Goodwill, long-term debt, preferred stock, common stock, and Accumulated other comprehensive loss		No change in $ amount
All other percentages are based on historic percent of total revenues

AUTOMATIC DATA PROCESSING INC.

	Balance Sheet
	$ millions	June 30,2020
	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	?
	Long-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	?
	Long-term debt	?
	Other liabilities	?
	Deferred income taxes	?
	Long-term deferred revenues	?
	Total liabilities	?
	Shareholders' equity	?
	Preferred stock, $1.00 par value; Authorized, 0.3 shares; issued , none	?
	Common stock, $0.10 par value; Authorized, 1,000.0 shares;	?
	issued, 638.7 shares; outstanding 434.2 shares	?
	Capital in excess of par value	?
	Retained earnings	?
	Treasury stock, at cost: 204.5 shares	?
	Accumulated other comprehensive loss	?
	Total stockholders' equity	?
	Total liabilities and stockholders' equity	?