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 Ended June 30, 2019, $ millions
Total revenues$14,175.2
Operating expenses7,145.9
Systems development and programming costs636.3
Depreciation and amortization304.4
Total cost of revenues8,086.6
Selling, general, and administrative expenses3,064.2
Interest expense129.9
Total expenses11,280.7
Other (income) expense, net(111.1)
Earnings before income taxes3,005.6
Provision for income taxes712.8
Net earnings$2,292.8



DATA PROCESSING INC.
Balance Sheet
$ millionsJune 30,2020
Forecast
Current assets
Cash and cash equivalents$1,949.2
Accounts receivable, net2,439.3
Other current assets519.6
Total current assets before funds held for clients4,908.1
Funds half for clients29,434.2
Total current assets34,342.3
Long-term receivables, net23.8
Property, plant and equipment, net764.2
Capitalized contract cost, net2,428.5
Other assets934.4
Goodwill2,323.0
Intangible assets, net1,071.5
Total assets$41,887.7
Current liabilities
Accounts payable$125.5
Accrued expenses and other current liabilities1,759.0
Accrued payroll and payroll-related expenses721.1
Dividends payable340.1
Short-term deferred revenues220.7
Obligations under reverse repurchase agreements262.0
Income taxes payable54.8
Total current liabilities before client funds obligations3,483.2
Client funds obligations29,144.5
Total current liabilities32,627.7
Long-term debt2,002.2
Other liabilities798.7
Deferred income taxes659.9
Long-term deferred revenues399.3
Total liabilities36,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 shares63.9
Capital in excess of par value1,183.2
Retained earnings17,500.6
Treasury stock, at cost: 204.5 shares(13,090.5)
Accumulated other comprehensive loss(257.3)
Total stockholders' equity5,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.


Note: When you are required to compute the percentage used for your forecasting assumptions, round the percentage to one decimal place and use that rounded figure to compute the forecasted amount. For example,  assume that Actual Accounts receivable, net divided Actual Total revenues equals 0.1720824. This factor should be rounded to 17.2% before computing your forecasted amount for Accounts receivable, net. 
Note: Round your forecasted answers to one decimal place (for example, enter 14.6 for 14.55555). Use rounded amounts to compute any subtotals and totals.

DATA PROCESSING, INC.
Forecasted Income Statement
For Year Ended June 30, 2020
$ millionsForecast
Total Revenues


Operating expenses


Systems development & programming costs


Depreciation and Amortization


Total cost of revenues


Selling, general, and administrative expenses


Interest expense


Total Expenses


Other (income)/expense, net


Earnings before income taxes


Provision for income taxes


Net Earnings




DATA PROCESSING, INC.
Forecasted Balance Sheet
$ millionsJune 30, 2020
Forecast
Current assets
Cash and cash equivalents


Accounts receivable, net


Other current assets


Total current assets before funds held for clients


Funds held for clients


Total current assets


Long-term receivables, net


Property, plant and equipment, net


Capitalized Contract Cost, Net


Other assets


Goodwill


Intangible assets, net


Total assets


Current liabilities
Accounts payable


Accrued expenses and other current liabilities


Accrued payroll and payroll-related expenses


Dividends payable


Short-term deferred revenues


Obligations under reverse repo agreements


Income taxes payable


Total current liabilities before client funds obligations


Client funds obligations


Total current liabilities


Long-term debt


Other liabilities


Deferred income taxes


Long-term deferred revenues


Total liabilities


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


Capital in excess of par value


Retained earnings


Treasury stock, at cost: 204.5 shares


Accumulated other comprehensive loss


Total stockholders’ equity


Total liabilities and stockholders’ equity



0 0
Add a comment Improve this question Transcribed image text
Request Professional Answer

Request Answer!

We need at least 8 more requests to produce the answer.

2 / 10 have requested this problem solution

The more requests, the faster the answer.

Request! (Login Required)


All students who have requested the answer will be notified once they are available.
Know the answer?
Add Answer to:
Analyze, Forecast, and Interpret Income Statement and Balance Sheet
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • Analyzing, Forecasting, and Interpreting Income Statement and Balance Sheet Following are the income statement and balance...

    Analyzing, Forecasting, and Interpreting Income Statement and Balance Sheet Following are the income statement and balance sheet of Whole Foods Market, Inc. Income Statement, For Years Ended (in $ 000s) 2010 2009 Sales $ 9,005,794 $ 8,031,620 Cost of goods sold and occupancy costs 5,870,393 5,277,310 Gross profit 3,135,401 2,754,310 Direct store expenses 2,375,716 2,145,809 General administrative expenses 272,449 243,749 Pre-opening expenses 38,044 49,218 Relocation, store closures and lease termination costs 11,217 31,185 Operating income 437,975 284,349 Interest expense (33,048)...

  • Analyzing. Forecasting, and Interpreting Income Statement and Balance Sheet Following are the income statement and balance...

    Analyzing. Forecasting, and Interpreting Income Statement and Balance Sheet Following are the income statement and balance sheet of General Mills, Inc. Income Statement, Fiscal Years Ended (in s millions) May 26, 2013 May 27, 2012 May 29, 2011 Net Sales $16.657.9 $14.380 2 Cost of Sales 11.350.2 10.613.2 892 Selling general and administrative expenses 3.5523 3.380.7 2. 1920 Divestitures (gain) Restructuring impairment, and other exit costs 101.6 Operating profit 2851.8 2562.4 27745 net 351.9 Earnings before income taxes and after...

  • Refine Assumptions for Dividend and Retained Earnings Forecast Following are the income statement and balance sheet...

    Refine Assumptions for Dividend and Retained Earnings Forecast Following are the income statement and balance sheet for Medtronic PLC. Consolidated Statement of Income $ millions) For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expenses 2,330 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 198 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit (loss) 6,268 Other nonoperating income,...

  • Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic...

    Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. April 26, 2019 $30,557 9,155 2,330 10,418 1,764 Consolidated Statement of Income, 12 Months Ended ($ millions) Net Sales Costs and expenses Cost of products sold Research and development expense Selling, general, and administrative expense Amortization of intangible assets Restructuring charges, net Certain litigation charges Other operating expense, net Operating profit Other nonoperating income, net Interest expense Income before income taxes Income tax...

  • Analyzing, Forecasting, and Interpreting Income Statement and Balance Sheet Following are the income statement and balance...

    Analyzing, Forecasting, and Interpreting Income Statement and Balance Sheet Following are the income statement and balance sheet of General Mills, Inc. Income Statement, Fiscal Years Ended (in $ millions) May 26, 2013 May 27, 2012 May 29, 2011 Net Sales $ 17,774. 1 5 16.657.9 5 14,880.2 Cost of Sales 11.350.2 10.613.2 8,926.7 Selling, general and administrative expenses 3.552.3 3.380.7 3.192.0 Divestitures (gain) (17.4) Restructuring, impairment and other exit costs 19.8 101.6 Operating profit 2.851.8 2.562.4 2.774.5 Interest, net 316.9...

  • Operating Section of Statement of Cash Flows (Indirect Method) Following are the income statement and balance...

    Operating Section of Statement of Cash Flows (Indirect Method) Following are the income statement and balance sheet for Nike Inc. for the year ended May 31, 2019, and a forecasted income statement and balance sheet for 2020. Nike Inc. Income Statement For Year Ended May 31 $ millions 2019 actual 2020 Est. Revenues $ 39,117 $ 42,246 Cost of sales 21,643 23,362 Gross profit 17,474 18,884 Demand creation expense 3,753 4,056 Operating overhead expense 8,949 9,674 Total selling and administrative...

  • please complete the balance sheet. Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following...

    please complete the balance sheet. Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of General Mills, Inc. Income Statement, Fiscal Years Ended ($ millions) May 29, 2011 May 30, 2010 Net Sales $ 14,880.2 $ 14,635.6 Cost of sales 8,926.7 8,835,4 Selling general and administrative expenses 3.192.0 3,162.7 Divestitures (gain), net (17.4) Restructuring, impairment, and other exit costs 4.4 31.4 Operating income 2.606.1 Interest, net 401.6 Earnings before income tax...

  • Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and...

    Analyzing, Forecasting, and Interpreting Both Income Statement and Balance Sheet Following are the income statements and balance sheets of General Mills, Inc. Income Statement, Fiscal Years Ended ($ millions) May 29, 2011 May 30, 2010 Net Sales $ 14,880.2 $ 14,635.6 Cost of sales 8,926.7 8,835,4 Selling general and administrative expenses 3.192.0 3,162.7 Divestitures (gain), net (17.4) Restructuring, impairment, and other exit costs 4.4 31.4 Operating income 2.606.1 Interest, net 401.6 Earnings before income tax expense and equity in income...

  • Complete a vertical and horizontal analysis on the tabs labeled "Balance Sheet" and "Income Statement," use total assets on the balance sheet and net sales on the income statement for...

    Complete a vertical and horizontal analysis on the tabs labeled "Balance Sheet" and "Income Statement," use total assets on the balance sheet and net sales on the income statement for your vertical analysis. Consolidated Balance Sheets (USD $) In Millions, unless o Feb. 01,2015 Vertical AnalysisFeb. 01,2014Vertical AnalysisHorizontal Analysis therwises fied Current Assets: Cash and Cash Equivalents Receivables, net Merchandise Inventories Other Current Assets Total Current Assets $1.723 1484 11079 1016 15302 38.513 $1929 1.398 11,057 895 15,279 39,064 at...

  • Compute and interpret the Z-score Information from the balance sheet, income statement, and statement of cash...

    Compute and interpret the Z-score Information from the balance sheet, income statement, and statement of cash flows for Nike follows. Refer to thes NIKE, INC. Consolidated Statements of Income Year Ended December 31 (In millions) 2019 2018 Revenues $39,117 $36,397 Cost of sales 21,643 20,441 Gross profit 17,474 15.956 Demand creation expense 3,753 3,577 Operating overhead expense 8,949 7.934 Total selling and administrative expense 12,702 11,511 Interest expense (income), net 49 54 Other (income) expense, net (78) 66 Income before...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT