Stock Analysis on Net

Synopsys Inc. (NASDAQ:SNPS)

Analysis of Short-term (Operating) Activity Ratios 
Quarterly Data

Microsoft Excel

Short-term Activity Ratios (Summary)

Synopsys Inc., short-term (operating) activity ratios (quarterly data)

Microsoft Excel
Jul 31, 2024 Apr 30, 2024 Jan 31, 2024 Oct 31, 2023 Jul 31, 2023 Apr 30, 2023 Jan 31, 2023 Oct 31, 2022 Jul 31, 2022 Apr 30, 2022 Jan 31, 2022 Oct 31, 2021 Jul 31, 2021 Apr 30, 2021 Jan 31, 2021 Oct 31, 2020 Jul 31, 2020 Apr 30, 2020 Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018
Turnover Ratios
Inventory turnover 3.24 3.36 3.31 3.75 4.15 4.43 4.94 5.02 4.62 4.45 4.28 3.76 3.53 3.65 3.51 4.13 4.71 4.49 5.09 5.32 4.90 4.57 5.44 6.01
Receivables turnover 7.74 7.41 5.76 6.17 8.29 6.78 5.00 6.38 7.25 6.58 4.34 7.40 7.06 6.51 4.84 4.72 5.50 5.36 4.22 6.07 7.23 6.14 4.16 5.63
Working capital turnover 2.40 2.89 8.03 13.12 10.27 12.83 17.05 21.34 14.02 7.78 9.47 10.65 9.50 9.18 16.88 9.00 27.06
Average No. Days
Average inventory processing period 112 109 110 97 88 82 74 73 79 82 85 97 103 100 104 88 77 81 72 69 74 80 67 61
Add: Average receivable collection period 47 49 63 59 44 54 73 57 50 55 84 49 52 56 75 77 66 68 86 60 51 59 88 65
Operating cycle 159 158 173 156 132 136 147 130 129 137 169 146 155 156 179 165 143 149 158 129 125 139 155 126

Based on: 10-Q (reporting date: 2024-07-31), 10-Q (reporting date: 2024-04-30), 10-Q (reporting date: 2024-01-31), 10-K (reporting date: 2023-10-31), 10-Q (reporting date: 2023-07-31), 10-Q (reporting date: 2023-04-30), 10-Q (reporting date: 2023-01-31), 10-K (reporting date: 2022-10-31), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-04-30), 10-Q (reporting date: 2022-01-31), 10-K (reporting date: 2021-10-31), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-Q (reporting date: 2021-01-31), 10-K (reporting date: 2020-10-31), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-Q (reporting date: 2020-01-31), 10-K (reporting date: 2019-10-31), 10-Q (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-Q (reporting date: 2019-01-31), 10-K (reporting date: 2018-10-31), 10-Q (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30), 10-Q (reporting date: 2018-01-31).

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Synopsys Inc. inventory turnover ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.
Receivables turnover An activity ratio equal to revenue divided by receivables. Synopsys Inc. receivables turnover ratio improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Working capital turnover An activity ratio calculated as revenue divided by working capital. Synopsys Inc. working capital turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Synopsys Inc. number of days of inventory outstanding improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Synopsys Inc. number of days of receivables outstanding improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.
Operating cycle Equal to average inventory processing period plus average receivables collection period. Synopsys Inc. operating cycle improved from Q1 2024 to Q2 2024 but then slightly deteriorated from Q2 2024 to Q3 2024.

Inventory Turnover

Synopsys Inc., inventory turnover calculation (quarterly data)

Microsoft Excel
Jul 31, 2024 Apr 30, 2024 Jan 31, 2024 Oct 31, 2023 Jul 31, 2023 Apr 30, 2023 Jan 31, 2023 Oct 31, 2022 Jul 31, 2022 Apr 30, 2022 Jan 31, 2022 Oct 31, 2021 Jul 31, 2021 Apr 30, 2021 Jan 31, 2021 Oct 31, 2020 Jul 31, 2020 Apr 30, 2020 Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018
Selected Financial Data (US$ in thousands)
Cost of revenue 290,676 300,397 329,175 332,343 307,482 298,014 284,354 282,721 271,181 252,811 256,984 234,726 205,066 213,986 207,999 224,549 193,008 184,265 192,868 182,743 186,632 190,679 192,892 190,582 185,381 178,779 181,156
Inventories 386,009 377,875 382,727 325,590 282,791 256,426 220,881 211,927 219,736 213,532 212,919 229,023 241,103 230,068 230,907 192,333 159,813 166,437 148,057 141,518 155,108 166,329 137,559 122,407
Short-term Activity Ratio
Inventory turnover1 3.24 3.36 3.31 3.75 4.15 4.43 4.94 5.02 4.62 4.45 4.28 3.76 3.53 3.65 3.51 4.13 4.71 4.49 5.09 5.32 4.90 4.57 5.44 6.01
Benchmarks
Inventory Turnover, Competitors2
Cadence Design Systems Inc. 1.81 2.79 2.35 2.39 2.59 2.88 3.12 2.90 3.04 3.17 2.91 2.65 3.06 3.50 4.11 4.02 6.36 6.47 4.46 4.77
International Business Machines Corp. 19.90 22.19 22.72 23.74 19.66 18.29 17.30 17.94 15.59 16.30 14.96 15.68 15.08 17.43 18.90 20.69 19.95 21.10 22.49 25.11
Microsoft Corp. 54.62 42.63 22.24 26.35 22.77 21.81 15.10 16.74 18.27 19.09 16.09 19.81 22.53 25.21 17.25 24.32 26.86 23.78 16.56 20.80

Based on: 10-Q (reporting date: 2024-07-31), 10-Q (reporting date: 2024-04-30), 10-Q (reporting date: 2024-01-31), 10-K (reporting date: 2023-10-31), 10-Q (reporting date: 2023-07-31), 10-Q (reporting date: 2023-04-30), 10-Q (reporting date: 2023-01-31), 10-K (reporting date: 2022-10-31), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-04-30), 10-Q (reporting date: 2022-01-31), 10-K (reporting date: 2021-10-31), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-Q (reporting date: 2021-01-31), 10-K (reporting date: 2020-10-31), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-Q (reporting date: 2020-01-31), 10-K (reporting date: 2019-10-31), 10-Q (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-Q (reporting date: 2019-01-31), 10-K (reporting date: 2018-10-31), 10-Q (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30), 10-Q (reporting date: 2018-01-31).

1 Q3 2024 Calculation
Inventory turnover = (Cost of revenueQ3 2024 + Cost of revenueQ2 2024 + Cost of revenueQ1 2024 + Cost of revenueQ4 2023) ÷ Inventories
= (290,676 + 300,397 + 329,175 + 332,343) ÷ 386,009 = 3.24

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Synopsys Inc. inventory turnover ratio improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.

Receivables Turnover

Synopsys Inc., receivables turnover calculation (quarterly data)

Microsoft Excel
Jul 31, 2024 Apr 30, 2024 Jan 31, 2024 Oct 31, 2023 Jul 31, 2023 Apr 30, 2023 Jan 31, 2023 Oct 31, 2022 Jul 31, 2022 Apr 30, 2022 Jan 31, 2022 Oct 31, 2021 Jul 31, 2021 Apr 30, 2021 Jan 31, 2021 Oct 31, 2020 Jul 31, 2020 Apr 30, 2020 Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018
Selected Financial Data (US$ in thousands)
Revenue 1,525,749 1,454,712 1,649,230 1,599,128 1,487,288 1,394,863 1,361,340 1,284,292 1,247,766 1,279,229 1,270,255 1,152,419 1,057,130 1,024,323 970,321 1,025,439 964,134 861,327 834,381 851,081 852,970 836,242 820,401 795,082 779,714 776,836 769,426
Accounts receivable, net 805,198 834,918 1,064,135 946,967 666,577 779,892 1,035,323 796,091 682,647 722,992 1,038,749 568,501 577,845 612,285 789,320 780,709 638,489 634,807 799,078 553,895 457,390 526,691 762,292 554,217 501,331 568,434 499,373
Short-term Activity Ratio
Receivables turnover1 7.74 7.41 5.76 6.17 8.29 6.78 5.00 6.38 7.25 6.58 4.34 7.40 7.06 6.51 4.84 4.72 5.50 5.36 4.22 6.07 7.23 6.14 4.16 5.63
Benchmarks
Receivables Turnover, Competitors2
Adobe Inc. 11.62 12.67 9.69 8.73 10.20 10.94 9.99 8.53 9.98 10.51 9.58 8.41 9.77 9.74 9.00 9.20 9.44 8.82 8.40 7.28 7.76 7.94 7.12 6.86
Autodesk Inc. 9.23 12.97 15.42 5.21 7.63 10.93 11.89 6.13 7.26 11.29 11.94 5.89 6.76 7.22 9.61 5.02 5.98 8.44 10.24 5.42
Cadence Design Systems Inc. 7.76 7.37 10.46 8.36 9.19 8.62 7.54 7.32 8.78 8.38 8.72 8.85 9.09 7.41 7.21 7.93 8.40 7.79 8.37 7.67
CrowdStrike Holdings Inc. 5.07 4.90 5.30 3.58 4.19 4.38 4.43 3.94 4.54 4.27 4.73 3.66 4.41 4.38 3.91 2.92
International Business Machines Corp. 11.61 10.81 10.27 8.57 11.48 10.67 10.52 9.25 10.95 10.17 9.79 8.49 9.23 9.57 10.72 10.32 12.30 11.54 11.05 9.80
Intuit Inc. 20.02 16.27 39.65 35.48 19.62 15.15 34.68 28.53 17.44 12.84 25.10 24.64 16.04 16.60 79.16 51.54 31.31 11.82 66.66 77.98
Microsoft Corp. 5.37 5.31 5.91 4.35 5.55 5.70 6.49 4.48 5.90 5.52 6.44 4.42 6.08 5.61 6.44 4.47 6.11 5.71 6.80 4.26
Oracle Corp. 7.20 7.59 7.82 7.22 7.72 7.43 7.44 7.13 9.12 9.28 9.11 7.48 8.56 8.91 8.57 7.04 9.55 9.77 10.35 7.69
Palo Alto Networks Inc. 4.54 3.97 5.10 2.80 4.50 4.82 4.70 2.57 4.17 5.10 5.61 3.43 5.20 5.65 5.30 3.29 4.88 5.78 6.04 4.98
Salesforce Inc. 7.00 6.12 6.95 2.92 7.09 6.18 7.07 2.72 6.22 5.78 7.04 2.73 6.12 5.63 5.93 2.77 6.16 6.32 6.51 2.70
ServiceNow Inc. 8.00 6.56 7.26 4.41 7.26 7.33 6.87 4.20 7.71 7.74 7.59 4.24 7.13 6.62 7.49 4.48 6.69 6.26 6.04 4.14

Based on: 10-Q (reporting date: 2024-07-31), 10-Q (reporting date: 2024-04-30), 10-Q (reporting date: 2024-01-31), 10-K (reporting date: 2023-10-31), 10-Q (reporting date: 2023-07-31), 10-Q (reporting date: 2023-04-30), 10-Q (reporting date: 2023-01-31), 10-K (reporting date: 2022-10-31), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-04-30), 10-Q (reporting date: 2022-01-31), 10-K (reporting date: 2021-10-31), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-Q (reporting date: 2021-01-31), 10-K (reporting date: 2020-10-31), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-Q (reporting date: 2020-01-31), 10-K (reporting date: 2019-10-31), 10-Q (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-Q (reporting date: 2019-01-31), 10-K (reporting date: 2018-10-31), 10-Q (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30), 10-Q (reporting date: 2018-01-31).

1 Q3 2024 Calculation
Receivables turnover = (RevenueQ3 2024 + RevenueQ2 2024 + RevenueQ1 2024 + RevenueQ4 2023) ÷ Accounts receivable, net
= (1,525,749 + 1,454,712 + 1,649,230 + 1,599,128) ÷ 805,198 = 7.74

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Synopsys Inc. receivables turnover ratio improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Working Capital Turnover

Synopsys Inc., working capital turnover calculation (quarterly data)

Microsoft Excel
Jul 31, 2024 Apr 30, 2024 Jan 31, 2024 Oct 31, 2023 Jul 31, 2023 Apr 30, 2023 Jan 31, 2023 Oct 31, 2022 Jul 31, 2022 Apr 30, 2022 Jan 31, 2022 Oct 31, 2021 Jul 31, 2021 Apr 30, 2021 Jan 31, 2021 Oct 31, 2020 Jul 31, 2020 Apr 30, 2020 Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018
Selected Financial Data (US$ in thousands)
Current assets 5,127,753 4,653,120 3,407,928 3,430,624 3,268,312 3,160,935 3,028,399 3,012,669 2,899,028 3,074,246 2,947,497 2,808,341 2,763,976 2,689,800 2,397,724 2,549,217 2,186,015 1,960,755 1,951,429 1,738,917 1,617,645 1,643,883 1,797,630 1,543,797 1,465,583 1,370,186 1,332,346
Less: Current liabilities 2,534,950 2,508,350 2,644,507 2,985,451 2,729,982 2,748,680 2,724,997 2,774,499 2,545,863 2,462,658 2,471,656 2,413,484 2,334,636 2,255,700 2,171,383 2,139,922 2,056,277 2,054,197 2,055,738 1,752,453 1,630,450 1,732,927 2,025,638 2,102,415 2,083,405 1,881,922 1,950,414
Working capital 2,592,803 2,144,770 763,421 445,173 538,330 412,255 303,402 238,170 353,165 611,588 475,841 394,857 429,340 434,100 226,341 409,295 129,738 (93,442) (104,309) (13,536) (12,805) (89,044) (228,008) (558,618) (617,822) (511,736) (618,068)
 
Revenue 1,525,749 1,454,712 1,649,230 1,599,128 1,487,288 1,394,863 1,361,340 1,284,292 1,247,766 1,279,229 1,270,255 1,152,419 1,057,130 1,024,323 970,321 1,025,439 964,134 861,327 834,381 851,081 852,970 836,242 820,401 795,082 779,714 776,836 769,426
Short-term Activity Ratio
Working capital turnover1 2.40 2.89 8.03 13.12 10.27 12.83 17.05 21.34 14.02 7.78 9.47 10.65 9.50 9.18 16.88 9.00 27.06
Benchmarks
Working Capital Turnover, Competitors2
Accenture PLC 22.48 15.40 11.18 11.93 10.11 13.40 14.81 15.07 13.41 15.55 15.85 12.77 7.71 8.35 7.70 8.71 10.32 10.56 9.98 9.85
Adobe Inc. 19.54 13.19 42.33 6.85 9.10 14.68 19.89 20.28 16.36 31.92 57.86 9.09 6.22 7.44 8.67 4.89 5.51 8.11 9.50 16.24
Autodesk Inc.
Cadence Design Systems Inc. 1.80 6.28 8.78 10.61 7.00 8.51 7.12 9.92 8.31 5.34 4.07 4.01 4.68 5.45 5.03 3.94 4.08 4.99 6.14 4.70
CrowdStrike Holdings Inc. 1.65 1.45 1.50 1.46 1.47 1.38 1.32 1.25 1.15 1.02 0.95 0.61 1.19 0.92 0.81 0.71
International Business Machines Corp. 37.03 17.08 14.55 31.12 12.14 40.51 49.97 107.30
Intuit Inc. 5.15 13.92 11.94 8.13 6.30 15.31 10.83 8.98 5.68 21.87 4.39 3.85 3.40 5.45 1.74 1.73 3.19 4.80 4.93 4.17
Microsoft Corp. 8.26 8.63 2.64 2.65 2.65 2.68 2.77 2.66 2.52 1.91 1.88 1.76 1.71 1.44 1.37 1.30 1.24 1.25 1.20 1.19
Oracle Corp. 3.50 3.86 3.39 1.70 1.29 1.69 1.58 1.26 1.12 2.25 1.98 1.68 1.42
Palo Alto Networks Inc. 3.52 2.15 1.40 4.81 1.80 1.89 1.80
Salesforce Inc. 42.02 99.31 90.67 62.21 30.85 25.15 54.57 24.95 27.10 4.36 5.11 7.48 10.29 9.75 15.29 28.71
ServiceNow Inc. 11.50 11.73 27.96 21.77 19.04 9.59 7.83 11.16 6.63 11.21 10.61 21.76 11.15 16.31 5.62 5.76 3.73 8.10 43.84 46.69

Based on: 10-Q (reporting date: 2024-07-31), 10-Q (reporting date: 2024-04-30), 10-Q (reporting date: 2024-01-31), 10-K (reporting date: 2023-10-31), 10-Q (reporting date: 2023-07-31), 10-Q (reporting date: 2023-04-30), 10-Q (reporting date: 2023-01-31), 10-K (reporting date: 2022-10-31), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-04-30), 10-Q (reporting date: 2022-01-31), 10-K (reporting date: 2021-10-31), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-Q (reporting date: 2021-01-31), 10-K (reporting date: 2020-10-31), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-Q (reporting date: 2020-01-31), 10-K (reporting date: 2019-10-31), 10-Q (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-Q (reporting date: 2019-01-31), 10-K (reporting date: 2018-10-31), 10-Q (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30), 10-Q (reporting date: 2018-01-31).

1 Q3 2024 Calculation
Working capital turnover = (RevenueQ3 2024 + RevenueQ2 2024 + RevenueQ1 2024 + RevenueQ4 2023) ÷ Working capital
= (1,525,749 + 1,454,712 + 1,649,230 + 1,599,128) ÷ 2,592,803 = 2.40

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Working capital turnover An activity ratio calculated as revenue divided by working capital. Synopsys Inc. working capital turnover ratio deteriorated from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Average Inventory Processing Period

Synopsys Inc., average inventory processing period calculation (quarterly data)

Microsoft Excel
Jul 31, 2024 Apr 30, 2024 Jan 31, 2024 Oct 31, 2023 Jul 31, 2023 Apr 30, 2023 Jan 31, 2023 Oct 31, 2022 Jul 31, 2022 Apr 30, 2022 Jan 31, 2022 Oct 31, 2021 Jul 31, 2021 Apr 30, 2021 Jan 31, 2021 Oct 31, 2020 Jul 31, 2020 Apr 30, 2020 Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018
Selected Financial Data
Inventory turnover 3.24 3.36 3.31 3.75 4.15 4.43 4.94 5.02 4.62 4.45 4.28 3.76 3.53 3.65 3.51 4.13 4.71 4.49 5.09 5.32 4.90 4.57 5.44 6.01
Short-term Activity Ratio (no. days)
Average inventory processing period1 112 109 110 97 88 82 74 73 79 82 85 97 103 100 104 88 77 81 72 69 74 80 67 61
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Cadence Design Systems Inc. 201 131 156 152 141 127 117 126 120 115 125 138 119 104 89 91 57 56 82 76
International Business Machines Corp. 18 16 16 15 19 20 21 20 23 22 24 23 24 21 19 18 18 17 16 15
Microsoft Corp. 7 9 16 14 16 17 24 22 20 19 23 18 16 14 21 15 14 15 22 18

Based on: 10-Q (reporting date: 2024-07-31), 10-Q (reporting date: 2024-04-30), 10-Q (reporting date: 2024-01-31), 10-K (reporting date: 2023-10-31), 10-Q (reporting date: 2023-07-31), 10-Q (reporting date: 2023-04-30), 10-Q (reporting date: 2023-01-31), 10-K (reporting date: 2022-10-31), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-04-30), 10-Q (reporting date: 2022-01-31), 10-K (reporting date: 2021-10-31), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-Q (reporting date: 2021-01-31), 10-K (reporting date: 2020-10-31), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-Q (reporting date: 2020-01-31), 10-K (reporting date: 2019-10-31), 10-Q (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-Q (reporting date: 2019-01-31), 10-K (reporting date: 2018-10-31), 10-Q (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30), 10-Q (reporting date: 2018-01-31).

1 Q3 2024 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 3.24 = 112

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Synopsys Inc. number of days of inventory outstanding improved from Q1 2024 to Q2 2024 but then deteriorated significantly from Q2 2024 to Q3 2024.

Average Receivable Collection Period

Synopsys Inc., average receivable collection period calculation (quarterly data)

Microsoft Excel
Jul 31, 2024 Apr 30, 2024 Jan 31, 2024 Oct 31, 2023 Jul 31, 2023 Apr 30, 2023 Jan 31, 2023 Oct 31, 2022 Jul 31, 2022 Apr 30, 2022 Jan 31, 2022 Oct 31, 2021 Jul 31, 2021 Apr 30, 2021 Jan 31, 2021 Oct 31, 2020 Jul 31, 2020 Apr 30, 2020 Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018
Selected Financial Data
Receivables turnover 7.74 7.41 5.76 6.17 8.29 6.78 5.00 6.38 7.25 6.58 4.34 7.40 7.06 6.51 4.84 4.72 5.50 5.36 4.22 6.07 7.23 6.14 4.16 5.63
Short-term Activity Ratio (no. days)
Average receivable collection period1 47 49 63 59 44 54 73 57 50 55 84 49 52 56 75 77 66 68 86 60 51 59 88 65
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Adobe Inc. 31 29 38 42 36 33 37 43 37 35 38 43 37 37 41 40 39 41 43 50 47 46 51 53
Autodesk Inc. 40 28 24 70 48 33 31 60 50 32 31 62 54 51 38 73 61 43 36 67
Cadence Design Systems Inc. 47 50 35 44 40 42 48 50 42 44 42 41 40 49 51 46 43 47 44 48
CrowdStrike Holdings Inc. 72 75 69 102 87 83 82 93 80 85 77 100 83 83 93 125
International Business Machines Corp. 31 34 36 43 32 34 35 39 33 36 37 43 40 38 34 35 30 32 33 37
Intuit Inc. 18 22 9 10 19 24 11 13 21 28 15 15 23 22 5 7 12 31 5 5
Microsoft Corp. 68 69 62 84 66 64 56 81 62 66 57 83 60 65 57 82 60 64 54 86
Oracle Corp. 51 48 47 51 47 49 49 51 40 39 40 49 43 41 43 52 38 37 35 47
Palo Alto Networks Inc. 80 92 72 130 81 76 78 142 88 72 65 106 70 65 69 111 75 63 60 73
Salesforce Inc. 52 60 53 125 52 59 52 134 59 63 52 134 60 65 62 132 59 58 56 135
ServiceNow Inc. 46 56 50 83 50 50 53 87 47 47 48 86 51 55 49 82 55 58 60 88

Based on: 10-Q (reporting date: 2024-07-31), 10-Q (reporting date: 2024-04-30), 10-Q (reporting date: 2024-01-31), 10-K (reporting date: 2023-10-31), 10-Q (reporting date: 2023-07-31), 10-Q (reporting date: 2023-04-30), 10-Q (reporting date: 2023-01-31), 10-K (reporting date: 2022-10-31), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-04-30), 10-Q (reporting date: 2022-01-31), 10-K (reporting date: 2021-10-31), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-Q (reporting date: 2021-01-31), 10-K (reporting date: 2020-10-31), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-Q (reporting date: 2020-01-31), 10-K (reporting date: 2019-10-31), 10-Q (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-Q (reporting date: 2019-01-31), 10-K (reporting date: 2018-10-31), 10-Q (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30), 10-Q (reporting date: 2018-01-31).

1 Q3 2024 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 7.74 = 47

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover. Synopsys Inc. number of days of receivables outstanding improved from Q1 2024 to Q2 2024 and from Q2 2024 to Q3 2024.

Operating Cycle

Synopsys Inc., operating cycle calculation (quarterly data)

No. days

Microsoft Excel
Jul 31, 2024 Apr 30, 2024 Jan 31, 2024 Oct 31, 2023 Jul 31, 2023 Apr 30, 2023 Jan 31, 2023 Oct 31, 2022 Jul 31, 2022 Apr 30, 2022 Jan 31, 2022 Oct 31, 2021 Jul 31, 2021 Apr 30, 2021 Jan 31, 2021 Oct 31, 2020 Jul 31, 2020 Apr 30, 2020 Jan 31, 2020 Oct 31, 2019 Jul 31, 2019 Apr 30, 2019 Jan 31, 2019 Oct 31, 2018 Jul 31, 2018 Apr 30, 2018 Jan 31, 2018
Selected Financial Data
Average inventory processing period 112 109 110 97 88 82 74 73 79 82 85 97 103 100 104 88 77 81 72 69 74 80 67 61
Average receivable collection period 47 49 63 59 44 54 73 57 50 55 84 49 52 56 75 77 66 68 86 60 51 59 88 65
Short-term Activity Ratio
Operating cycle1 159 158 173 156 132 136 147 130 129 137 169 146 155 156 179 165 143 149 158 129 125 139 155 126
Benchmarks
Operating Cycle, Competitors2
Cadence Design Systems Inc. 248 181 191 196 181 169 165 176 162 159 167 179 159 153 140 137 100 103 126 124
International Business Machines Corp. 49 50 52 58 51 54 56 59 56 58 61 66 64 59 53 53 48 49 49 52
Microsoft Corp. 75 78 78 98 82 81 80 103 82 85 80 101 76 79 78 97 74 79 76 104

Based on: 10-Q (reporting date: 2024-07-31), 10-Q (reporting date: 2024-04-30), 10-Q (reporting date: 2024-01-31), 10-K (reporting date: 2023-10-31), 10-Q (reporting date: 2023-07-31), 10-Q (reporting date: 2023-04-30), 10-Q (reporting date: 2023-01-31), 10-K (reporting date: 2022-10-31), 10-Q (reporting date: 2022-07-31), 10-Q (reporting date: 2022-04-30), 10-Q (reporting date: 2022-01-31), 10-K (reporting date: 2021-10-31), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-04-30), 10-Q (reporting date: 2021-01-31), 10-K (reporting date: 2020-10-31), 10-Q (reporting date: 2020-07-31), 10-Q (reporting date: 2020-04-30), 10-Q (reporting date: 2020-01-31), 10-K (reporting date: 2019-10-31), 10-Q (reporting date: 2019-07-31), 10-Q (reporting date: 2019-04-30), 10-Q (reporting date: 2019-01-31), 10-K (reporting date: 2018-10-31), 10-Q (reporting date: 2018-07-31), 10-Q (reporting date: 2018-04-30), 10-Q (reporting date: 2018-01-31).

1 Q3 2024 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 112 + 47 = 159

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Operating cycle Equal to average inventory processing period plus average receivables collection period. Synopsys Inc. operating cycle improved from Q1 2024 to Q2 2024 but then slightly deteriorated from Q2 2024 to Q3 2024.