Forecast DP's 2020 income statement and balance sheet using the following relations ($ millions). Assume total...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 $184.4 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 $276.1 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 $167.3 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 $750 million of treasury stock. • Dividends will be $1,389.40 in 2020, and dividends payable will be 26.3% of dividends. DATA PROCESSING INC. Statement of Consolidated Earnings For Year Ended June 30, 2019, $ millions Total revenues $14,175.2 Operating expenses 7,145.9 Systems development and programming costs 636.3 Depreciation and amortization 304.4 Total cost of revenues 8,086.6 Selling, general, and administrative expenses 3,064.2 Interest expense 129.9 Total expenses 11,280.7 Other (income) expense, net (111.1) Earnings before income taxes 3,005.6 Provision for income taxes 712.8 Net earnings $2,292.8 DATA PROCESSING INC. Balance Sheet June 30,2020 $ millions Forecast Current assets Cash and cash equivalents $1,949.2 Accounts receivable, net 2,439.3 Other current assets 519.6 Total current assets before funds held for clients 4,908.1 Funds half for clients 29,434.2 Total current assets 34,342.3 Long-term receivables, net 23.8 Property, plant and equipment, net 764.2 Capitalized contract cost, net 2,428.5 Other assets 934.4 Goodwill 2,323.0 Intangible assets, net 1,071.5 Total assets $41,887.7 Current liabilities Accounts payable $125.5 Accrued expenses and other current liabilities 1,759.0 Accrued payroll and payroll-related expenses 721.1 Dividends payable 340.1 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,483.2 Client funds obligations 29,144.5 Total current liabilities 32,627.7 Long-term debt 2,002.2 Other liabilities 798.7 Deferred income taxes 659.9 Long-term deferred revenues 399.3 Total liabilities 36,487.8 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,183.2 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,399.9 Total liabilities and stockholders' equity $41,887.7 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 $184.4 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 $276.1 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 $167.3 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 $750 million of treasury stock. • Dividends will be $1,389.40 in 2020, and dividends payable will be 26.3% of dividends. DATA PROCESSING INC. Statement of Consolidated Earnings For Year Ended June 30, 2019, $ millions Total revenues $14,175.2 Operating expenses 7,145.9 Systems development and programming costs 636.3 Depreciation and amortization 304.4 Total cost of revenues 8,086.6 Selling, general, and administrative expenses 3,064.2 Interest expense 129.9 Total expenses 11,280.7 Other (income) expense, net (111.1) Earnings before income taxes 3,005.6 Provision for income taxes 712.8 Net earnings $2,292.8 DATA PROCESSING INC. Balance Sheet June 30,2020 $ millions Forecast Current assets Cash and cash equivalents $1,949.2 Accounts receivable, net 2,439.3 Other current assets 519.6 Total current assets before funds held for clients 4,908.1 Funds half for clients 29,434.2 Total current assets 34,342.3 Long-term receivables, net 23.8 Property, plant and equipment, net 764.2 Capitalized contract cost, net 2,428.5 Other assets 934.4 Goodwill 2,323.0 Intangible assets, net 1,071.5 Total assets $41,887.7 Current liabilities Accounts payable $125.5 Accrued expenses and other current liabilities 1,759.0 Accrued payroll and payroll-related expenses 721.1 Dividends payable 340.1 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,483.2 Client funds obligations 29,144.5 Total current liabilities 32,627.7 Long-term debt 2,002.2 Other liabilities 798.7 Deferred income taxes 659.9 Long-term deferred revenues 399.3 Total liabilities 36,487.8 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,183.2 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,399.9 Total liabilities and stockholders' equity $41,887.7
Expert Answer:
Related Book For
Financial Accounting
ISBN: 978-0077862268
2nd edition
Authors: J. David Spiceland, Wayne Thomas, Don Herrmann
Posted Date:
Students also viewed these accounting questions
-
Supply the missing income statement amounts for each of the following companies (amounts adapted, in millions): Requirement Prepare the income statement for Baker Company for the year ended December...
-
A recent income statement of Dragonwood Corporation reported the following data: If the company desired to earn a target profit of $1,270,000, it would have to sell: A. 5,778 units. B. 8,600 units....
-
Property taxes are based on assessed values of property. In most states, the law requires that assessed values be at or near market value of the property. In one Washington county, a tax protest...
-
A total weighted score of in an External Factor Evaluation (EFE) Matrix indicates that an organization is responding in an outstanding way to existing opportunities and threats in its industry. Oa....
-
In an ideal Brayton cycle, air is compressed from 95 kPa and 258C to 1100 kPa. Under cold-air-standard conditions, the thermal efficiency of this cycle is (a) 45 percent (b) 50 percent (c) 62 percent...
-
Consider the system \[\dot{\mathbf{x}}=\mathbf{A} \mathbf{x}\] where \(\mathbf{A}\) is given by \[\mathbf{A}=\left[\begin{array}{ccc}0 & 1 & 0 \\-b_{3} & 0 & 1 \\0 & -b_{2} & -b_{1}\end{array}ight]\]...
-
Political expectations, inflation, and unemployment Consider a country with two political parties, Democrats and Republicans. Democrats care more about unemployment than Republicans, and Republicans...
-
Lansbury Inc. had the balance sheet shown on the next page at December 31, 2011. During 2012, the following occurred.1. Lansbury Inc. sold part of its investment portfolio for $15,000. This...
-
3. Find the regular expression for the language accepted by the following automaton. b
-
The restaurant owner Lobster Jack wants to find out what the peak demand periods are, during the hours of operation, in order to be better prepared to serve his customers. He thinks that, on average,...
-
Table 1: Cargo Unit Financial Information 2019 (Triliun) 2018 (Triliun) Net income 8.3 5.6 Total assets 90 80 Shareholders Equity 50 40 Table 2: Catering Unit Financial Information 2019 (Triliun)...
-
According to Stewart (2003), what is "wrong" with accounting, and how did this contribute to the corporate scandals of the early 2000s? What recommendations does he make for "fixing" the problem?
-
. What information sources would be most significant in understanding the jobs in a chicken processing plant? For each one, explain why. Are dirty, dangerous, and unpleasant jobs an inevitable part...
-
Erin set up a savings fund for his son's education so that he would be able to withdraw $1,575 at the beginning of every month for the next 6 years. The fund earns 3.18% compounded quarterly. a. What...
-
The speed u of a car is governed by the two equations (after rescaling) du f-v dt df 2f+2 tanhu. dt where f is the traction force produced by the engine and u is the throttle position. (a) Obtain a...
-
2. Smart Incorp. has just paid a dividend of $2.00/share (i.e., Do), and the dividend is expected to grow at 85% for 3 years, 40% for 2 additional years, and 5% forever. The required rate of return...
-
a) Use the Product Rule to find the derivative of the given function. b) Find the derivative by multiplying the expressions first. y= (5x+3)x a) Use the Product Rule to find the derivative of the...
-
Using (1) or (2), find L(f) if f(t) if equals: t cos 4t
-
Below are transactions for Hurricane Company during 2012. a. On October 1, 2012, Hurricane lends $8,000 to another company. The other company signs a note indicating principal and 8% interest will be...
-
Clothing Frontiers began operations on January 1, 2012, and engages in the following transactions during the year related to stockholders' equity. January 1 Issues 600 shares of common stock for $40...
-
University Hero is considering expanding operations beyond its healthy sandwiches. Jim Axelrod, vice president of marketing, would like to add a line of smoothies with a similar health emphasis. Each...
-
Let \(X_{1}, \ldots, X_{n}\) be a set of independent and identically distributed random variables from a distribution \(F\) with variance \(\mu_{2}\) where \(E\left(\left|X_{1}ight|^{4}ight) a. Prove...
-
Consider a sequence of independent random variables \(\left\{X_{n}ight\}_{n=1}^{\infty}\) where \(X_{n}\) has probability distribution function \[f_{n}(x)= \begin{cases}2^{-(n+1)} &...
-
Let \(X_{1}, \ldots, X_{n}\) be a set of independent and identically distributed random variables from a shifted exponential density of the form \[f(x)= \begin{cases}\exp [-(x-\theta)] & \text { for...
Study smarter with the SolutionInn App