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....
-
Analyze the planned production activities for your business to determine the operations processes for which total quality management will be important.
-
Assume that the volume of each solution in Figure 19-22 is 100.0 mL. The cell is operated as an electrolytic cell, using a current of 0.500 A. Electrolysis is stopped after 10.00 h, and the cell is...
-
Two businesses are considering how to raise \(\$ 5\) million. Buchanan Corporation is having its best year since it began operations in 1998 . For each of the past 10 years, earnings per share have...
-
Big Bath Emporium (BBE), a private company based in Toronto, is the city's largest manufacturer and vendor of bathtubs, showers, and sinks. The company sells products direct to consumers, and also...
-
Hillary & Trump Co. makes hilarious trumpets on an assembly line. Completing an order under a contract signed earlier with the Biden O'Barak Orchestra (BOO), Hillary & Trump Co. needs to produce 64...
-
The Tri-County Generation and Transmission Association is a nonprofit cooperative organization that provides electrical service to rural customers. Based on a faulty long-range demand forecast,...
-
Secured Party has a perfected security interest in Debtor's equipment, and the security agreement between Debtor and Secured Party contains a future advances clause. As of March 1, Debtor owed...
-
You have been offered a unique investment opportunity. If you invest $ 15000 today, you will receive $750 one year from? now, $2,250 two years from now, and $15,000 ten years from now. a. What is...
-
1. We are evaluating a project that costs $864,000, has an eight-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are...
-
1. Calculate the net present value (NPV?) for a 10?-year project with an initial investment of $25,000 and a cash inflow of $7,000 per year. Assume that the firm has an opportunity cost of 17?%.
-
Perry's Pizzeria issued 20-year annual coupon bonds one year ago at a coupon rate of 5.1 percent. If the YTM on these bonds is 8.99 percent, what is the current bond price?
-
Assume that a bank has a TDS requirement of 0.40. If heat costs $250/month, property taxes are at $190/month, and you have an outstanding car loan of $300/month, what is the maximum mortgage amount...
-
Stock daily returns have 'fat' tails ('extreme' daily returns are more likely than what the Normal distribution suggest). What were the largest daily percentage losses in the history of the US stock...
-
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...
-
a. Define illegal acts. b. What is the auditor's basic responsibility for such acts?
-
Jackson was a junior staff member of an accounting firm. He began the audit of the Bosco Corporation which manufactured and sold expensive watches. In the middle of the audit, he quit. The accounting...
-
Keen, a CPA and sole practitioner, was retained by Arthur \& Son, a partnership, to audit the company books and prepare a report on the financial statements for submission to several prospective...
Study smarter with the SolutionInn App