Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help determine the balances below Question 1 Partially correct Mark 20.00 out of 48.00 7 Flag question Analyze, Forecast, and Interpret Income Statement and

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

please help determine the balances below

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Question 1 Partially correct Mark 20.00 out of 48.00 7 Flag question Analyze, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of DP Inc. DATA PROCESSING INC. Statement of Consolidated Earnings For Year Endedjune 30. 2019, 5 millions Total revenues ' $113402 Operating expenses ' 5,716.7 Systems development and programming costs ' 509.0 Depreciation and amortization 243.5 Total cost of revenues 6,469.2 Selling, general, and administrative expenses ' 2,451.4 Interest expense ' 103.9 Total expenses ' 9,024.5 Other (income) expense, net i (88.9) Earnings before income taxes ' 2,404.6 Provision for income taxes ' 570.2 Net earnings ' $1,834.4 DATA PROCESSING INC. Balance Sheet $mi|lions June 30. 2019 Current assets Cash and cash equivalents ' 31,5595 Accounts receivable, net 1,951.4 Funds half for clients 23,5474 Total current assets 27,474.0 Longterm receivables, net ' 19.0 i 611.4 Other current assets 415.7 Total current assets before funds held for clients 3,926.6 Property. plant and equipment, net Capitalized contract cost, net 1,942.8 Other assets 7475 Goodwill 1,858.4 Intangible assets, net 8572 Total assets $335103 Current liabilities Accounts payable $100.4 Accrued expenses and other current liabilities 1,407.2 Accrued payroll and payroll-related expenses 576.9 Dividends payable 272.1 Short-term deferred revenues 176.6 Obligations under reverse repurchase agreements 209.6 Income taxes payable 43.8 Total current liabilities before client funds obligations 2,786.6 Client funds obligations 23,315.6 Total current liabilities 26,1022 Long~term debt 1,601.8 Other liabilities 639.0 Deferred income taxes 527.9 Long-term deferred revenues 319.4 Total liabilities 29,1903 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, 511.0 shares; outstanding 347.4 shares 51.1 Capital in excess of par value 9466 Retained earnings 14,0005 Treasury stock, at cost: 1636 shares (10,472.4) Accumulated other comprehensive loss (205.8) Total stockholders' equity 4,320.0 Total liabilities and stockholders' equity $335103 Forecast DP's 2020 income statement and balance sheet using the following relations ($ millions). Assume total revenues grow by 13% in 2020. All other percentages (other than sales growth and provision for income taxes) are based on historic percent of total revenues. CAPEX for 2020 will be 1.1% of total revenue, and depreciation will be $147.5 million. Goodwill, long-term debt, preferred stock, common stock, and Accumulated other comprehensive loss will not change for the year. The company will acquire intangibles equal to 2.9% of total revenues and will record amortization expense of $220.9 million. Income taxes will be 25% of pretax income and income taxes payable will be 7.7% of 2020 tax expense. The company will award $133.8 million of stock-based compensation, which 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. The company will continue its stock repurchases. DP will repurchase $600 million of treasury stock. - Dividends will be $1,111.50 in 2020, and dividends payable will be 26.3% of dividends. Note: Round your answers to one decimal place (for example, enter 14.6 for 14.55555). DATA PROCESSING, INC. Forecasted Income Statement For Year Ended June 30,2020 $ millions Forecast Total Revenues 12,814.4 V Operating expenses 6,593.7 X Systems development & programming costs 575 V Depreciation and Amortization 368.4 V Total cost of revenues 7,537.3 x Selling, general, and administrative expenses 2,770.1 x Interest expense 103.9 V Total Expenses 10,424.53 x Other(income)/expense, net (100.5) x Earnings before income taxes 2,490.1 x Provision for income taxes 622.2 x Net Earnings $ 1,867.9 x DATA PROCESSING, INC. Forecasted Balance Sheet 5 millions June 30, 2020 Forecast Current assets Cash and cash equivalents $ 2,167 3: Accounts receivable, net 2,205 ./ Other current assets 469.75 at Total current assets before funds held for clients 4,841.7 x Funds held for clients 26,609 x Total current assets 31,450 X LongV-termireceivables,net . , V 721.477 x Property, plant and equipment, net 604 ./ Capitalized Contract Cost, Net 2,195.4 at Other assets 844,675 v Goodwill 1,858.4 V Intangible assets, net 1.007 V Total assets $ 37,983 a: Current liabilities Accounts payable 113.5 v Accrued expenses and other current liabilities 1,590.1 V Accrued payroll and payroll-related expenses 651.9 V Dividends payable 292.3 ./ Shortterm deferred revenues 199.6 x Obligations under reverse repo agreements 809.6 x Income taxes payable 45.6 at Total current liabilities before client funds obligations 3,495.2 3: Client funds obligations 26,346.6 ./ Total current liabilities 29,8413 3: Long-term debt 1,601.8 v Other liabilities 722 x Deferred income taxes 5965 X LongV-termidreferred revenues . . . V 3617 3: Total liabilities $ 33,330.464 x Shareholders' equity: Preferred stock, $1.00 par value: Authorized, Shareholders' equity: Preferred stock, $1.00 par value: Authorized, 0.3 shares; issued, none 0 0/ Common stock, $0.10 parvalue: authorized, 1,000!) shares; issued, S1110 shares; outstanding 34714 shares 51.1 V Capital in excess of par value 1.080 V Retained earnings 14.798] x Treasury stock, at cost: 163.6 shares (11,072.4) v Accumulated other comprehensive loss (205) 0/ Total stockholders' equity 6,873.8 at Total liabilities and stockholders' equity 5 39,996 X

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

Students also viewed these Accounting questions