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....
-
Refrigerant-12 enters a compressor operating at steady state as saturated vapor at -7oC and exits at 1000 kPa. The compressor has an isentropic efficiency of 75%. Ignoring the heat transfer between...
-
The following table shows UK nominal GDP for the years 1979, 1981, 1990, 1992, 2008 and 2011. It also shows the GDP deflator where 2013 = 100. 1979 1981 1990 1992 2008 2011 Nominal GDP (bn) 219.559...
-
Do workers have a right to privacy at their jobs? Do you think it is possible to establish and maintain effective standards for employee privacy while instituting a controlled environment to prevent...
-
Below are certain events that took place at Hazzard, Inc. , last year: a. Short-term investment securities were purchased. b. Equipment was purchased. c. Accounts payable increased. d. Deferred taxes...
-
(a) Show that 1 = Resz-kf(2) cot(T2) = f(k), provided f(z) is analytic at z = k (k Z). (b) Let I be a square contour, with corners at (N+1/2)(1+i), N = Z+. Show that for z on TN. |cot(TZ)|2, (c)...
-
J. D. Williams, Inc., is an investment advisory firm that manages more than $120 million in funds for its numerous clients. The company uses an asset allocation model that recommends the portion of...
-
Q9. The number of possible isomers for [Ru(bpy)Cl] is (bpy = 2,2-bipyridine) (a) 2 (b) 3 (c) 4 (d) 5
-
Question 15 The body of this loop always happens at least one time. O selection loop O for loop O while loop O do while loop
-
Santagos Industries gathered the following information from its accounting records for the year ended December 31, 2022, prior to adjustment: Net credit sales for the year $730,000 Accounts...
-
Shore Co. sold merchandise to Blue Star Co. on account, $111,200, terms FOB shipping point, n/30. Thecost of the goods soldis $66,720. Shore paid freight of $1,900. Shore Co. issued a credit memo for...
-
1. The following data (assume a 365-day year) is in relation to Warehouse Ltd: Sales = $3,650,000 Total asset turnover = 4 Current ratio = 3:1 Quick ratio = 2:1 Current liabilities to net worth = 30%...
-
Derive the gradient descent training rule assuming for the target function od = Wo + WIXI + ... + Wnxn. Define explicitly the squared cost/error function E, assuming that a set of training examples D...
-
What will be the output of this code? int a = 7 + 2; int b = a - 2; a = b* 3; int a * x = b; System.out.print(x);
-
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...
-
Although the basic principles of personal finance are the same for men and women, what are the social and demographic factors that make these decisions especially important for women?
-
Define net asset value. When is the net asset value of a mutual fund calculated?
-
List the five most common itemized deductions, and describe the limits set on each.
Study smarter with the SolutionInn App