Question: Please check my work if doing it right. I need to complete a Vertical and Horizontal Analysis but stuck not sure if doing it right?

Please check my work if doing it right. I need to complete a Vertical and Horizontal Analysis but stuck not sure if doing it right?

PAYCHEX, INC.
CONSOLIDATED STATEMENTS OF INCOME (Unaudited)
(In millions, except per share amounts)
For the twelve months
ended
May 31,
2023 2022 2021
Revenue:
Management Solutions 3,730.5 3,442.7 3,023.4
PEO and Insurance Solutions 1,176.8 1,111.3 974.1
Total service revenue 4,907.3 4,554.0 3,997.5
Interest on funds held for clients(1) 99.8 57.7 59.3
Total revenue 5,007.1 4,611.7 4,056.8
Expenses:
Cost of service revenue 1,453.0 1,356.3 1,271.2
Selling, general and admin. expenses 1,521.0 1,415.4 1,324.9
Total expenses 2,974.0 2,771.7 2,596.1
Operating income 2,033.1 1,840.0 1,460.7
Other income/(expense), net(1) 15.1 -15.4 -26.5
Income before income taxes 2,048.2 1,824.6 1,434.2
Income taxes 490.9 431.8 336.7
Net income 1,557.3 1,392.8 1,097.5
Formula: (Line Item / Base Item) * 100
Vertical Analysis % - Income Statement 2023 2022 2021
Management Solutions Revenue 76.02 75.60 75.63
PEO and Insurance Solutions Revenue 23.98 24.40 24.37
Cost of Service Revenue 29.61 29.78 31.80
SG&A Expenses 30.99 31.08 33.14
Total expenses 60.60 60.86 64.94
Operating Income 41.43 40.40 36.54
Income before income taxes 41.74 40.07 35.88
Income taxes 10.00 9.48 8.42
Net Income 31.73 30.58 27.45
Formula: Current Year AmountBase Year Amount / Base Year Amount *100
Horizontal Analysis - Income Statement 2023 2022 2021
Management Solutions Revenue 2.04
PEO and Insurance Solutions Revenue -1.67
Total service revenue
Cost of Service Revenue
SG&A Expenses
Total expenses
Operating Income
Income before income taxes
Income taxes
Net Income

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!