Stock Analysis on Net

Moderna Inc. (NASDAQ:MRNA)

This company has been moved to the archive! The financial data has not been updated since November 7, 2024.

Analysis of Short-term (Operating) Activity Ratios 

Microsoft Excel

Short-term Activity Ratios (Summary)

Moderna Inc., short-term (operating) activity ratios

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Turnover Ratios
Inventory turnover 23.23 5.71 1.82 0.17
Receivables turnover 7.48 13.31 5.57 0.14 0.00
Payables turnover 9.03 11.12 8.67 0.43 0.00
Working capital turnover 0.91 2.17 2.55 0.10 0.00
Average No. Days
Average inventory processing period 16 64 201 2,141
Add: Average receivable collection period 49 27 66 2,539
Operating cycle 65 91 267 4,680
Less: Average payables payment period 40 33 42 845
Cash conversion cycle 25 58 225 3,835

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

Inventory Turnover
The inventory turnover ratio exhibits a significant upward trend from 0.17 in 2020 to 23.23 in 2023. This indicates an increasingly efficient management of inventory, with the company converting inventory into sales at a much faster rate over the years.
Receivables Turnover
Receivables turnover improved markedly from 0.14 in 2020 to 13.31 in 2022, followed by a decline to 7.48 in 2023. This suggests initially enhanced efficiency in collecting receivables, although the dip in the final year may indicate some challenges in credit collection or changes in credit policy.
Payables Turnover
The payables turnover ratio increased sharply from 0.43 in 2020 to a peak of 11.12 in 2022, then slightly declined to 9.03 in 2023. This pattern suggests the company accelerated payments to suppliers through 2022, with a modest slowdown in 2023, implying some adjustment in payment terms or cash flow management.
Working Capital Turnover
The working capital turnover ratio rose significantly from 0.10 in 2020 to 2.55 in 2021, though it declined to 0.91 by 2023. The initial rise indicates improved utilization of working capital to generate sales, but the subsequent decrease may reflect increasing working capital or slowing sales growth in later years.
Average Inventory Processing Period
The average number of days inventory is held fell dramatically from 2141 days in 2020 to just 16 days in 2023. This aligns with the high inventory turnover and demonstrates greatly improved inventory management, reducing holding times substantially.
Average Receivable Collection Period
The average collection period dropped from 2539 days in 2020 to 27 days in 2022, then increased to 49 days in 2023. The shorter periods through 2022 suggest enhanced efficiency in collecting receivables, while the increase in 2023 could point to slower collections or relaxed credit terms.
Operating Cycle
The operating cycle decreased significantly from 4680 days in 2020 to 65 days in 2023, reflecting faster inventory turnover and receivables collection. This improvement underlines more efficient operations and quicker conversion of inputs into cash over the period.
Average Payables Payment Period
The average payables payment period shortened sharply from 845 days in 2020 to around 33-40 days in the subsequent years, indicating the company began paying its suppliers more promptly after 2020, which may influence supplier relationships and credit terms.
Cash Conversion Cycle
The cash conversion cycle contracted markedly from 3835 days in 2020 to 25 days in 2023, highlighting substantially improved liquidity management through faster inventory turnover, quicker collection of receivables, and controlled payment of payables. This trend signals enhanced operational efficiency and cash flow management.

Turnover Ratios


Average No. Days


Inventory Turnover

Moderna Inc., inventory turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Cost of sales 4,693 5,416 2,617 8
Inventory 202 949 1,441 47
Short-term Activity Ratio
Inventory turnover1 23.23 5.71 1.82 0.17
Benchmarks
Inventory Turnover, Competitors2
AbbVie Inc. 4.98 4.87 5.58 4.65
Amgen Inc. 0.89 1.30 1.58 1.58
Bristol-Myers Squibb Co. 4.02 4.33 4.74 5.68
Danaher Corp. 3.80 4.03 4.16 4.28
Eli Lilly & Co. 1.23 1.54 1.88 1.38
Gilead Sciences Inc. 3.64 3.75 4.08 2.72
Johnson & Johnson 2.37 2.49 2.87 3.04
Merck & Co. Inc. 2.54 2.95 2.29 2.45
Pfizer Inc. 2.45 3.82 3.40 1.08
Regeneron Pharmaceuticals Inc. 0.70 0.65 1.25 0.58
Thermo Fisher Scientific Inc. 5.06 4.60 3.88 4.02
Vertex Pharmaceuticals Inc. 1.71 2.35 2.56 2.62
Inventory Turnover, Sector
Pharmaceuticals, Biotechnology & Life Sciences 2.55 3.06 3.11 2.63
Inventory Turnover, Industry
Health Care 9.18 9.22 9.17 8.17

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Inventory turnover = Cost of sales ÷ Inventory
= 4,693 ÷ 202 = 23.23

2 Click competitor name to see calculations.

Cost of Sales
The cost of sales experienced a substantial increase from 8 million US dollars in 2020 to 2,617 million in 2021, marking a significant expansion in operational scale or sales volume. This upward trend continued into 2022, doubling to 5,416 million, reflecting robust growth. However, in 2023, the cost of sales declined to 4,693 million, indicating a possible reduction in sales volume, improved cost efficiency, or changes in production processes.
Inventory
Inventory levels showed considerable variation over the observed period. There was a sharp rise from 47 million US dollars in 2020 to 1,441 million in 2021, signaling increased stockholding possibly to meet anticipated demand or production ramp-up. Inventory then decreased to 949 million in 2022 and further decreased to 202 million in 2023. This decline indicates effective inventory management or reduced stock requirements in response to demand or sales trends.
Inventory Turnover Ratio
The inventory turnover ratio reflected significant improvement in inventory management efficiency. Starting at 0.17 in 2020, it rose to 1.82 in 2021, suggesting an enhanced rate of inventory turnover. This upward trend accelerated markedly to 5.71 in 2022 and further to 23.23 in 2023, denoting a dramatic increase in the frequency of inventory renewal. Such growth points to efficient inventory utilization, reduced holding periods, or potentially higher sales velocity relative to inventory levels.

Receivables Turnover

Moderna Inc., receivables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Net product sales 6,671 18,435 17,675 200
Accounts receivable, net 892 1,385 3,175 1,391 5
Short-term Activity Ratio
Receivables turnover1 7.48 13.31 5.57 0.14 0.00
Benchmarks
Receivables Turnover, Competitors2
AbbVie Inc. 4.87 5.16 5.63 5.19
Amgen Inc. 3.70 4.46 4.96 5.36
Bristol-Myers Squibb Co. 4.93 5.48 5.65 5.72
Danaher Corp. 6.09 6.40 6.36 5.51
Eli Lilly & Co. 3.75 4.14 4.24 4.18
Gilead Sciences Inc. 5.78 5.65 6.01 4.98
Johnson & Johnson 5.73 5.88 6.14 6.08
Merck & Co. Inc. 5.81 6.27 5.28 6.11
Pfizer Inc. 5.33 9.24 7.16 5.38
Regeneron Pharmaceuticals Inc. 2.31 2.28 2.66 2.07
Thermo Fisher Scientific Inc. 5.21 5.53 4.92 5.61
Vertex Pharmaceuticals Inc. 6.31 6.19 6.66 7.01
Receivables Turnover, Sector
Pharmaceuticals, Biotechnology & Life Sciences 4.96 5.76 5.54 5.34
Receivables Turnover, Industry
Health Care 8.15 8.84 8.65 8.64

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Receivables turnover = Net product sales ÷ Accounts receivable, net
= 6,671 ÷ 892 = 7.48

2 Click competitor name to see calculations.

The financial data indicates significant variability in net product sales over the observed periods. Starting with no sales recorded in 2019, the figure rose markedly to 200 million US dollars in 2020, followed by a substantial surge in 2021 reaching 17,675 million US dollars. This upward trend continued with a slight increase to 18,435 million US dollars in 2022, before experiencing a noticeable decline to 6,671 million US dollars in 2023. This pattern reflects a peak in sales in 2022, with a sharp reduction the following year.

Accounts receivable, net, showed a parallel trajectory consistent with sales activity. Beginning at 5 million US dollars in 2019, there was a steep increase to 1,391 million in 2020, then further growth to 3,175 million in 2021. However, this was followed by a decline to 1,385 million in 2022 and further down to 892 million in 2023. This trend suggests the company's receivables rose significantly alongside sales growth but later decreased as sales diminished.

Receivables turnover ratio exhibits a notable fluctuation over the years. Starting at an unreported level in 2019, it was very low at 0.14 in 2020, indicating potentially slower collection of receivables relative to sales. Subsequently, the ratio increased substantially to 5.57 in 2021 and peaked at 13.31 in 2022, suggesting improved efficiency in collecting receivables. In 2023, the turnover ratio declined to 7.48, which, while lower than the previous year, still indicates relatively efficient receivables management compared to 2020.

Net Product Sales
Strong growth from 2020 through 2022, peaking in 2022, followed by a pronounced decline in 2023.
Accounts Receivable, Net
Significant increase tracking sales growth until 2021, then decreasing in the two subsequent years consistent with lower sales.
Receivables Turnover Ratio
Marked improvement from very low efficiency in 2020 to peak efficiency in 2022, with some deceleration in 2023 but maintaining higher efficiency than in the early years.

Overall, the data suggests the company experienced rapid growth in sales during 2020-2022 with corresponding increases in receivables, alongside improving collection efficiency. The sales decline in 2023 was mirrored by a reduction in receivables and a modest decrease in turnover ratio, indicating possible adjustments in sales volume and credit management strategies during the most recent period.


Payables Turnover

Moderna Inc., payables turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Cost of sales 4,693 5,416 2,617 8
Accounts payable 520 487 302 18 7
Short-term Activity Ratio
Payables turnover1 9.03 11.12 8.67 0.43 0.00
Benchmarks
Payables Turnover, Competitors2
AbbVie Inc. 5.54 5.94 6.05 6.76
Amgen Inc. 5.32 4.08 4.72 4.33
Bristol-Myers Squibb Co. 3.28 3.33 3.37 4.34
Danaher Corp. 5.58 5.45 4.48 4.79
Eli Lilly & Co. 2.73 3.43 4.38 3.41
Gilead Sciences Inc. 11.81 6.25 9.36 5.42
Johnson & Johnson 2.76 2.66 2.70 2.99
Merck & Co. Inc. 4.11 4.08 2.96 3.37
Pfizer Inc. 3.72 5.04 5.53 2.02
Regeneron Pharmaceuticals Inc. 2.99 2.65 4.32 2.36
Thermo Fisher Scientific Inc. 8.97 7.67 6.83 7.45
Vertex Pharmaceuticals Inc. 3.46 3.55 4.64 4.75
Payables Turnover, Sector
Pharmaceuticals, Biotechnology & Life Sciences 4.25 4.28 4.23 3.86
Payables Turnover, Industry
Health Care 7.96 7.50 7.61 7.48

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Payables turnover = Cost of sales ÷ Accounts payable
= 4,693 ÷ 520 = 9.03

2 Click competitor name to see calculations.

Cost of Sales
The cost of sales exhibited a significant increase from 2019 to 2021, escalating from a negligible or zero base to 2,617 million US dollars in 2021. The upward trend continued into 2022, reaching a peak of 5,416 million US dollars. However, in 2023, the cost of sales slightly decreased to 4,693 million US dollars, indicating a potential stabilization or reduction in production or operational expenses.
Accounts Payable
Accounts payable followed a steady increasing trend throughout the period. Starting at 7 million US dollars in 2019, it rose to 18 million in 2020, then dramatically increased to 302 million in 2021. The upward trajectory continued reaching 487 million in 2022 and slightly increased again to 520 million in 2023. This may imply extended credit terms from suppliers or increased procurement activities aligned with operational growth.
Payables Turnover Ratio
The payables turnover ratio displayed substantial volatility over the observed years. It began at 0.43 in 2020, which is relatively low and could indicate slower payments to suppliers. This ratio then sharply increased to 8.67 in 2021, further rising to 11.12 in 2022, and slightly declined to 9.03 in 2023. The initial increase suggests improved efficiency in managing payables or a change in payment practices, while the slight decline in 2023 could indicate a moderated pace of payments or changes in supplier terms.

Working Capital Turnover

Moderna Inc., working capital turnover calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data (US$ in millions)
Current assets 10,325 13,431 16,071 6,298 1,129
Less: Current liabilities 3,015 4,923 9,128 4,389 143
Working capital 7,310 8,508 6,943 1,909 986
 
Net product sales 6,671 18,435 17,675 200
Short-term Activity Ratio
Working capital turnover1 0.91 2.17 2.55 0.10 0.00
Benchmarks
Working Capital Turnover, Competitors2
AbbVie Inc.
Amgen Inc. 2.25 3.82 3.37 2.55
Bristol-Myers Squibb Co. 4.60 8.30 3.95 3.72
Danaher Corp. 4.22 4.20 8.40 3.48
Eli Lilly & Co. 31.84 8.33 4.93
Gilead Sciences Inc. 5.61 8.42 8.54 5.30
Johnson & Johnson 11.81 5.95 9.44
Merck & Co. Inc. 9.29 5.16 7.62 109.83
Pfizer Inc. 11.09 4.83 4.67
Regeneron Pharmaceuticals Inc. 0.82 0.96 1.59 1.20
Thermo Fisher Scientific Inc. 4.05 5.46 5.87 2.76
Vertex Pharmaceuticals Inc. 0.93 0.85 1.02 0.99
Working Capital Turnover, Sector
Pharmaceuticals, Biotechnology & Life Sciences 6.68 7.25 5.87 5.34
Working Capital Turnover, Industry
Health Care 16.59 15.34 11.93 11.78

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Working capital turnover = Net product sales ÷ Working capital
= 6,671 ÷ 7,310 = 0.91

2 Click competitor name to see calculations.

The analysis of the annual financial data reveals several notable trends over the five-year period.

Working Capital
Working capital exhibited a significant upward trajectory from 2019 through 2022, increasing from US$986 million to US$8,508 million. This represents very aggressive growth in the company's short-term financial strength during these years. However, in 2023, there was a decline to US$7,310 million, suggesting a slight contraction but still maintaining a relatively high level compared to the earlier years.
Net Product Sales
Net product sales experienced extraordinary growth starting from zero in 2019, reaching US$200 million in 2020 and then skyrocketing to US$17,675 million in 2021. Sales peaked slightly higher in 2022 at US$18,435 million, followed by a pronounced decline to US$6,671 million in 2023. This pattern indicates a rapid scaling of revenue followed by a substantial decrease in the most recent period.
Working Capital Turnover
Working capital turnover mirrored the sales trend to some extent. Starting from a low ratio of 0.1 in 2020, it increased sharply to 2.55 in 2021, suggesting improved efficiency in utilizing working capital to generate sales. It then slightly decreased to 2.17 in 2022 and dropped further to 0.91 in 2023. The latter decrease suggests reduced effectiveness in working capital use relative to sales during the latest year, likely influenced by the drop in product sales.

Overall, the data depicts rapid growth phases in working capital and product sales through 2021 and 2022, followed by a contraction in 2023. The declining working capital turnover in 2023 signals potential challenges in operational efficiency or demand during that year, despite still maintaining a substantial level of working capital.


Average Inventory Processing Period

Moderna Inc., average inventory processing period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data
Inventory turnover 23.23 5.71 1.82 0.17
Short-term Activity Ratio (no. days)
Average inventory processing period1 16 64 201 2,141
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
AbbVie Inc. 73 75 65 79
Amgen Inc. 411 281 231 231
Bristol-Myers Squibb Co. 91 84 77 64
Danaher Corp. 96 91 88 85
Eli Lilly & Co. 298 237 194 265
Gilead Sciences Inc. 100 97 89 134
Johnson & Johnson 154 147 127 120
Merck & Co. Inc. 144 124 159 149
Pfizer Inc. 149 95 107 338
Regeneron Pharmaceuticals Inc. 519 562 292 625
Thermo Fisher Scientific Inc. 72 79 94 91
Vertex Pharmaceuticals Inc. 214 156 143 139
Average Inventory Processing Period, Sector
Pharmaceuticals, Biotechnology & Life Sciences 143 119 117 139
Average Inventory Processing Period, Industry
Health Care 40 40 40 45

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 23.23 = 16

2 Click competitor name to see calculations.

Inventory Turnover
There is a pronounced upward trend in the inventory turnover ratio from 2019 to 2023. The ratio started at a very low level of 0.17 in 2020, indicating slow inventory movement initially. This figure increased substantially to 1.82 in 2021 and further accelerated to 5.71 in 2022. By 2023, the inventory turnover ratio reached 23.23, which reflects a significant improvement in the company's efficiency in managing and selling its inventory over the period analyzed.
Average Inventory Processing Period
The average inventory processing period exhibits a consistent and marked decline from 2020 to 2023, demonstrating enhanced inventory management practices. Initially, in 2020, the inventory was held for an average of 2141 days, indicating a slow turnover. This duration decreased sharply to 201 days in 2021 and continued to shorten significantly to 64 days in 2022. The most recent figure for 2023 stands at just 16 days, pointing to a highly efficient inventory processing system that allows the company to convert inventory into sales rapidly.
Overall Analysis
The data reveals a substantial improvement in inventory management over the five-year period. There is a clear inverse correlation between the inventory turnover ratio and the average inventory processing period, as expected. The company appears to have optimized its inventory flow, moving from prolonged holding times to rapid turnover. Such trends typically suggest positive operational changes, possibly including better demand forecasting, streamlined supply chain processes, or changes in product line strategy that enhance liquidity and reduce holding costs.

Average Receivable Collection Period

Moderna Inc., average receivable collection period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data
Receivables turnover 7.48 13.31 5.57 0.14 0.00
Short-term Activity Ratio (no. days)
Average receivable collection period1 49 27 66 2,539
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
AbbVie Inc. 75 71 65 70
Amgen Inc. 99 82 74 68
Bristol-Myers Squibb Co. 74 67 65 64
Danaher Corp. 60 57 57 66
Eli Lilly & Co. 97 88 86 87
Gilead Sciences Inc. 63 65 61 73
Johnson & Johnson 64 62 59 60
Merck & Co. Inc. 63 58 69 60
Pfizer Inc. 69 40 51 68
Regeneron Pharmaceuticals Inc. 158 160 137 177
Thermo Fisher Scientific Inc. 70 66 74 65
Vertex Pharmaceuticals Inc. 58 59 55 52
Average Receivable Collection Period, Sector
Pharmaceuticals, Biotechnology & Life Sciences 74 63 66 68
Average Receivable Collection Period, Industry
Health Care 45 41 42 42

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 7.48 = 49

2 Click competitor name to see calculations.

The data reflects notable fluctuations in the receivables turnover ratio and the average receivable collection period over the five-year span. Initially, the receivables turnover ratio was extremely low in 2020 at 0.14, indicating a very slow rate of collections relative to receivables. However, the ratio increased substantially in 2021 to 5.57, further accelerating to 13.31 in 2022, before decreasing to 7.48 in 2023.

Correspondingly, the average receivable collection period shows an inverse pattern. In 2020, it peaked at an exceptionally high level of 2,539 days, suggesting significant delays in collecting receivables during that period. This period shortened dramatically in 2021 to 66 days and further to 27 days in 2022, highlighting significant improvements in collection efficiency. However, in 2023, the collection period lengthened somewhat to 49 days, though it remained considerably lower than the 2020 level.

Overall, the trends illustrate a period of initially poor receivable management or collection difficulty in 2020 followed by substantial improvement in 2021 and 2022. The slight regression in 2023 indicates a potential area for closer monitoring, but overall the receivable turnover has markedly improved from 2020 levels.


Operating Cycle

Moderna Inc., operating cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data
Average inventory processing period 16 64 201 2,141
Average receivable collection period 49 27 66 2,539
Short-term Activity Ratio
Operating cycle1 65 91 267 4,680
Benchmarks
Operating Cycle, Competitors2
AbbVie Inc. 148 146 130 149
Amgen Inc. 510 363 305 299
Bristol-Myers Squibb Co. 165 151 142 128
Danaher Corp. 156 148 145 151
Eli Lilly & Co. 395 325 280 352
Gilead Sciences Inc. 163 162 150 207
Johnson & Johnson 218 209 186 180
Merck & Co. Inc. 207 182 228 209
Pfizer Inc. 218 135 158 406
Regeneron Pharmaceuticals Inc. 677 722 429 802
Thermo Fisher Scientific Inc. 142 145 168 156
Vertex Pharmaceuticals Inc. 272 215 198 191
Operating Cycle, Sector
Pharmaceuticals, Biotechnology & Life Sciences 217 182 183 207
Operating Cycle, Industry
Health Care 85 81 82 87

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 16 + 49 = 65

2 Click competitor name to see calculations.

Inventory Processing Period
The average inventory processing period shows a marked and consistent decrease over the observed years. Initially, there was no data for the year 2019, but from 2020 onwards, the period dramatically declined from 2141 days in 2020 to 16 days by 2023. This suggests a significant improvement in the efficiency of inventory turnover, indicating that inventory is held for a substantially shorter time before being processed or sold.
Receivable Collection Period
The average receivable collection period exhibits a significant fluctuation during the period analyzed. The collection period was extremely lengthy in 2020 at 2539 days, then sharply decreased to 66 days in 2021 and further decreased to 27 days in 2022. However, in 2023, there was a notable increase to 49 days. This pattern indicates efforts to improve accounts receivable collection efficiency were successful initially but saw a slight reversal in the final year.
Operating Cycle
The operating cycle declined steeply over the years for which data is available. It started at a very high 4680 days in 2020, then dropped significantly to 267 days in 2021, fell further to 91 days in 2022, and reached its lowest point at 65 days in 2023. This trend suggests an overall enhancement in the company's operational efficiency, with faster conversion of inventory and receivables into cash flow.
Summary
Collectively, the data reveals a strong trend of improvement in operational performance from 2020 through 2023. Inventory management has become substantially more efficient, and although receivable collection periods saw some volatility, the overall trend reduces the company's cash conversion cycle. The reduction in the operating cycle corroborates these gains, highlighting enhanced liquidity and potentially better working capital management. The company appears to be optimizing its operations to maintain a more agile financial posture.

Average Payables Payment Period

Moderna Inc., average payables payment period calculation, comparison to benchmarks

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data
Payables turnover 9.03 11.12 8.67 0.43 0.00
Short-term Activity Ratio (no. days)
Average payables payment period1 40 33 42 845
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
AbbVie Inc. 66 61 60 54
Amgen Inc. 69 90 77 84
Bristol-Myers Squibb Co. 111 109 108 84
Danaher Corp. 65 67 82 76
Eli Lilly & Co. 134 106 83 107
Gilead Sciences Inc. 31 58 39 67
Johnson & Johnson 132 137 135 122
Merck & Co. Inc. 89 89 123 108
Pfizer Inc. 98 72 66 181
Regeneron Pharmaceuticals Inc. 122 138 84 155
Thermo Fisher Scientific Inc. 41 48 53 49
Vertex Pharmaceuticals Inc. 106 103 79 77
Average Payables Payment Period, Sector
Pharmaceuticals, Biotechnology & Life Sciences 86 85 86 95
Average Payables Payment Period, Industry
Health Care 46 49 48 49

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 9.03 = 40

2 Click competitor name to see calculations.

The analysis of the company's payables-related financial metrics over the five-year period reveals significant changes and trends indicative of evolving operational and financial strategies.

Payables Turnover
The payables turnover ratio shows a marked increase from 0.43 in 2020 to a peak of 11.12 in 2022, followed by a slight decline to 9.03 in 2023. This trend suggests an improvement in the rate at which the company settles its supplier obligations up to 2022, indicating enhanced efficiency or possibly changing credit terms with vendors. The decrease in 2023, while still strong compared to 2020 and 2021, may reflect a stabilization or a strategic adjustment in payment practices.
Average Payables Payment Period
The average payables payment period, expressed in days, inversely mirrors the payables turnover trend. It dramatically decreased from 845 days in 2020 to 42 days in 2021, further shortening to 33 days in 2022, before lengthening marginally to 40 days in 2023. This reduction indicates a significant acceleration in payment timing, moving from a very extended period to a more standard, prompt payment cycle, which can strengthen supplier relationships and creditworthiness.

Collectively, these metrics illustrate a substantial shift from prolonged payment periods and low payables turnover toward more rapid payment cycles and higher turnover ratios. The substantial improvement from 2020 through 2022 may reflect operational changes, such as increased liquidity, revised credit policies, or a strategic emphasis on supplier management. The slight reversal in 2023 suggests a possible rebalancing of payment timing to optimize cash flow while maintaining supplier terms. This evolution indicates a company becoming more disciplined in managing its payables, likely contributing to improved financial stability and supplier confidence.


Cash Conversion Cycle

Moderna Inc., cash conversion cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Dec 31, 2023 Dec 31, 2022 Dec 31, 2021 Dec 31, 2020 Dec 31, 2019
Selected Financial Data
Average inventory processing period 16 64 201 2,141
Average receivable collection period 49 27 66 2,539
Average payables payment period 40 33 42 845
Short-term Activity Ratio
Cash conversion cycle1 25 58 225 3,835
Benchmarks
Cash Conversion Cycle, Competitors2
AbbVie Inc. 82 85 70 95
Amgen Inc. 441 273 228 215
Bristol-Myers Squibb Co. 54 42 34 44
Danaher Corp. 91 81 63 75
Eli Lilly & Co. 261 219 197 245
Gilead Sciences Inc. 132 104 111 140
Johnson & Johnson 86 72 51 58
Merck & Co. Inc. 118 93 105 101
Pfizer Inc. 120 63 92 225
Regeneron Pharmaceuticals Inc. 555 584 345 647
Thermo Fisher Scientific Inc. 101 97 115 107
Vertex Pharmaceuticals Inc. 166 112 119 114
Cash Conversion Cycle, Sector
Pharmaceuticals, Biotechnology & Life Sciences 131 97 97 112
Cash Conversion Cycle, Industry
Health Care 39 32 34 38

Based on: 10-K (reporting date: 2023-12-31), 10-K (reporting date: 2022-12-31), 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31).

1 2023 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 16 + 4940 = 25

2 Click competitor name to see calculations.

Average Inventory Processing Period
The average inventory processing period exhibits a significant and consistent decline over the reported years. Starting at an extremely high value of 2141 days in 2020, it sharply decreased to 201 days in 2021, then further reduced to 64 days in 2022, and finally settled at 16 days in 2023. This trend indicates a substantial improvement in inventory management and efficiency, resulting in faster turnover of inventory over time.
Average Receivable Collection Period
The average receivable collection period shows a similar pattern of improvement with some variability. Initially, it was exceptionally high at 2539 days in 2020, then markedly decreased to 66 days in 2021 and further to 27 days in 2022. However, it increased again to 49 days in 2023. Despite the uptick in 2023, the current level remains significantly lower than the initial value, suggesting an overall enhancement in the efficiency of receivables collection, but with some recent challenges or changes in credit terms.
Average Payables Payment Period
The average payables payment period also demonstrates a downward trend following the high of 845 days in 2020. It reduced dramatically to 42 days in 2021, slightly decreased to 33 days in 2022, and then slightly increased to 40 days in 2023. This pattern implies improved management of payment obligations and better cash flow control, although the minor increase in 2023 may warrant monitoring for potential shifts in supplier payment terms or liquidity.
Cash Conversion Cycle
The cash conversion cycle has improved remarkably throughout the period. From an excessively long cycle of 3835 days in 2020, it tightened significantly to 225 days in 2021, then further contracted to 58 days in 2022, and finally reached 25 days in 2023. This demonstrates enhanced operational efficiency and effective working capital management, with quicker conversion of investments in inventory and receivables back into cash.