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....
-
Suppose fX,Y (x, y)= xye(x+y), x >0, y >0. Prove for any real numbers a, b, c, and d that P(a < X < b, c < Y < d) = P(a < X < b) P(c < Y < d) thereby establishing the independence of X and Y.
-
Was IBM's stock price reaction to their October 2012 earnings announcement efficient? Explain your reasoning.
-
Explain how Bayes optimal classifier and the nave Bayes classifier work.
-
A company manufactures a liquid product called Crystal. The basic ingredients are put into process in Department 1. In Department 2, other materials are added that increase the number of units being...
-
A rumor is spread in a school. For 0 < a < 1 and b > 0, the time t at which a fraction p of the school population has heard the rumor is given by t(p) = [ " b dx. x(1 - x) dz (a) Evaluate the...
-
A. Steve Jackson (birthdate December 13, 1965) is a single taxpayer living at 3215 Pacific Dr., Apt. B, Pacific Beach, CA 92109. His Social Security number is 465-88-9415. In 2018, Steves earnings...
-
1. Refer to the exhibit. What will router R1 do with a packet that has a destination IPv6 address of 2001:db8:cafe:5::1? R1# show ipv6 route S :: /0 [1/0] via Serial0/0/0, directly connected C 2001:...
-
If explaining how use a good evaluation can lead to better decision-making by DMFT managers and other stakeholders what or how would I show qualitative and quantitative evidence?
-
https://www.youtube.com/watch?v=SL-Whfy-o3Y using the video above What are the four key survival traits that are killing us now? What is the connection with mental illness?
-
Use the graph data view to plot monthly price data for 2008. From September 2008 to December 2008 retail gasoline prices in the United States?
-
How are inquiry-based instructional methods well-suited to cross-disciplinary instruction in humanities content areas? What are some benefits and challenges of implementing inquiry-based instruction?...
-
What role do family dynamics and parental investment play in either facilitating or constraining intergenerational mobility ?
-
Annabelle, Boden, and Christy form ABC Partnership as equal partners. Annabelle and Boden contribute cash of $50,000 each and Christy contributes equipment with a $100,000 fair market value and...
-
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...
-
Use the Any Entry pattern to model entries in a spreadsheet style application. a. Draw a class diagram of using Any Entry pattern. b. Generate a significant use case for this context. c. Map the use...
-
List and explain essential properties of analysis patterns.
-
A pattern is not intended to represent a model for a complete system. Explain.
Study smarter with the SolutionInn App