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
Get step-by-step solutions from verified subject matter experts
