Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Forecast ADPs 2 0 2 0 income statement assuming the following income statement relations. All percentages ( other than total revenue growth and provision for

Forecast ADPs 2020 income statement assuming the following income statement relations. All percentages (other than total revenue growth and provision for income taxes) are based on historic percent of total revenues. Dollar figures are in millionsAssumptionsTotal revenues growth13.00%Depreciation and amortization$460.5Interest expenseNo changeOther (income) expense, netNo changeIncome tax rate25.00%Note: Complete the entire question in Excel using the following template: Excel Template. Format each answer to two decimal places. Then enter the answers into the provided spaces below with two decimal places.AUTOMATIC DATA PROCESSING INC.Statement of Consolidated EarningsFor Year Ended June 30,2020, $ millionsTotal revenuesAnswer16,017Operating expensesAnswer8,074Systems development and programming costsAnswer718.68Depreciation and amortizationAnswer460.5Total cost of revenuesAnswer9,253.18Selling, general, and administrative expensesAnswer3,462.32Interest expenseAnswer130Total expensesAnswer12,845.5Other (income) expense, netAnswer(111)
Calculate 1. Earnings before income taxes 2. Provision for income taxes 3. Net earnings

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Susan V. Crosson, Belverd E. Needles

8th Edition

9780618777174, 618777180, 618777172, 978-0618777181

More Books

Students also viewed these Accounting questions

Question

Describe the use of tests in the selection process.

Answered: 1 week ago

Question

Explain pre-employment screening and background checks.

Answered: 1 week ago