Stock Analysis on Net

Moderna Inc. (NASDAQ:MRNA)

Return on Capital (ROC)

Microsoft Excel

Return on Invested Capital (ROIC)

Moderna Inc., ROIC 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 operating profit after taxes (NOPAT)1 (5,414) 3,520 14,737 3,091 (605)
Invested capital2 5,263 7,126 10,693 4,183 481
Performance Ratio
ROIC3 -102.87% 49.40% 137.82% 73.88% -125.87%
Benchmarks
ROIC, Competitors4
AbbVie Inc. 4.83% 14.05% 12.89% 4.30% 14.74%
Amgen Inc. 11.15% 16.11% 15.93% 20.35% 22.74%
Bristol-Myers Squibb Co. 8.69% 6.37% 8.29% -7.57% 3.06%
Danaher Corp. 3.94% 8.76% 9.01% 7.43% 3.57%
Eli Lilly & Co. 10.52% 17.77% 19.28% 25.89% 22.93%
Gilead Sciences Inc. 11.75% 8.28% 14.43% 1.26% 12.92%
Johnson & Johnson 8.98% 14.12% 19.20% 13.91% 12.94%
Merck & Co. Inc. -1.02% 19.14% 18.87% 11.66% 18.52%
Pfizer Inc. -0.82% 28.01% 20.98% 5.87% 14.19%
Regeneron Pharmaceuticals Inc. 26.80% 29.90% 72.83% 44.66% 34.05%
Thermo Fisher Scientific Inc. 5.98% 7.76% 9.32% 10.70% 6.69%

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 NOPAT. See details »

2 Invested capital. See details »

3 2023 Calculation
ROIC = 100 × NOPAT ÷ Invested capital
= 100 × -5,414 ÷ 5,263 = -102.87%

4 Click competitor name to see calculations.

Performance ratio Description The company
ROIC A measure of the periodic, after tax, cash-on-cash yield earned in the business. Moderna Inc. ROIC deteriorated from 2021 to 2022 and from 2022 to 2023.

Decomposition of ROIC

Moderna Inc., decomposition of ROIC

Microsoft Excel
ROIC = OPM1 × TO2 × 1 – CTR3
Dec 31, 2023 -102.87% = -121.55% × 0.88 × 100.00%
Dec 31, 2022 49.40% = 37.00% × 2.00 × 66.63%
Dec 31, 2021 137.82% = 78.63% × 1.92 × 91.43%
Dec 31, 2020 73.88% = 76.50% × 0.97 × 99.95%
Dec 31, 2019 -125.87% = × -0.15 × 100.00%

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 Operating profit margin (OPM). See calculations »

2 Turnover of capital (TO). See calculations »

3 Effective cash tax rate (CTR). See calculations »

The primary reason for the decrease in return on invested capital (ROIC) over 2023 year is the decrease in profitability measured by operating profit margin (OPM) ratio.


Operating Profit Margin (OPM)

Moderna Inc., OPM 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 operating profit after taxes (NOPAT)1 (5,414) 3,520 14,737 3,091 (605)
Add: Cash operating taxes2 (191) 1,763 1,381 1 (4)
Net operating profit before taxes (NOPBT) (5,605) 5,283 16,118 3,092 (610)
 
Net product sales 6,671 18,435 17,675 200
Add: Increase (decrease) in deferred revenue (2,060) (4,157) 2,824 3,842 (72)
Adjusted net product sales 4,611 14,278 20,499 4,042 (72)
Profitability Ratio
OPM3 -121.55% 37.00% 78.63% 76.50%
Benchmarks
OPM, Competitors4
AbbVie Inc. 14.58% 26.77% 27.06% 13.19% 30.02%
Amgen Inc. 40.00% 35.35% 32.55% 38.71% 46.69%
Bristol-Myers Squibb Co. 21.81% 19.38% 20.31% -12.65% 21.63%
Danaher Corp. 21.44% 27.12% 27.65% 23.43% 18.74%
Eli Lilly & Co. 20.00% 24.98% 22.91% 30.98% 24.91%
Gilead Sciences Inc. 29.07% 25.11% 34.43% 10.83% 27.94%
Johnson & Johnson 17.15% 22.65% 24.38% 20.16% 21.00%
Merck & Co. Inc. 4.63% 30.22% 30.60% 19.13% 26.21%
Pfizer Inc. 1.43% 38.86% 30.18% 19.53% 35.42%
Regeneron Pharmaceuticals Inc. 32.80% 40.59% 58.09% 46.15% 33.80%
Thermo Fisher Scientific Inc. 15.91% 18.33% 23.79% 24.12% 17.61%

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 NOPAT. See details »

2 Cash operating taxes. See details »

3 2023 Calculation
OPM = 100 × NOPBT ÷ Adjusted net product sales
= 100 × -5,605 ÷ 4,611 = -121.55%

4 Click competitor name to see calculations.

Profitability ratio Description The company
OPM The operating profit margin (OPM) is the ratio of pretax economic earnings, or NOPBT, to sales. Moderna Inc. OPM deteriorated from 2021 to 2022 and from 2022 to 2023.

Turnover of Capital (TO)

Moderna Inc., TO 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
Add: Increase (decrease) in deferred revenue (2,060) (4,157) 2,824 3,842 (72)
Adjusted net product sales 4,611 14,278 20,499 4,042 (72)
 
Invested capital1 5,263 7,126 10,693 4,183 481
Efficiency Ratio
TO2 0.88 2.00 1.92 0.97 -0.15
Benchmarks
TO, Competitors3
AbbVie Inc. 0.80 0.71 0.59 0.44 0.53
Amgen Inc. 0.38 0.62 0.60 0.63 0.59
Bristol-Myers Squibb Co. 0.67 0.64 0.58 0.47 0.26
Danaher Corp. 0.30 0.40 0.40 0.34 0.31
Eli Lilly & Co. 1.16 1.17 1.08 1.00 1.04
Gilead Sciences Inc. 0.59 0.59 0.57 0.48 0.70
Johnson & Johnson 0.86 0.83 0.95 0.84 0.85
Merck & Co. Inc. 0.86 0.80 0.69 0.84 0.87
Pfizer Inc. 0.38 0.91 0.93 0.40 0.43
Regeneron Pharmaceuticals Inc. 1.10 0.99 1.48 1.03 1.20
Thermo Fisher Scientific Inc. 0.50 0.54 0.49 0.53 0.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 Invested capital. See details »

2 2023 Calculation
TO = Adjusted net product sales ÷ Invested capital
= 4,611 ÷ 5,263 = 0.88

3 Click competitor name to see calculations.

Efficiency ratio Description The company
TO The turnover of capital (TO) is the ratio of sales to invested capital. Capital turnover is a function of the efficiency of working capital management and of net fixed assets. Moderna Inc. TO improved from 2021 to 2022 but then deteriorated significantly from 2022 to 2023.

Effective Cash Tax Rate (CTR)

Moderna Inc., CTR 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 operating profit after taxes (NOPAT)1 (5,414) 3,520 14,737 3,091 (605)
Add: Cash operating taxes2 (191) 1,763 1,381 1 (4)
Net operating profit before taxes (NOPBT) (5,605) 5,283 16,118 3,092 (610)
Tax Rate
CTR3 33.37% 8.57% 0.05%
Benchmarks
CTR, Competitors4
AbbVie Inc. 58.42% 25.72% 18.70% 26.24% 7.42%
Amgen Inc. 27.52% 27.01% 18.93% 15.91% 17.97%
Bristol-Myers Squibb Co. 40.21% 48.91% 29.34% 45.70%
Danaher Corp. 39.60% 19.69% 18.58% 7.07% 38.19%
Eli Lilly & Co. 54.68% 39.42% 22.30% 16.37% 11.34%
Gilead Sciences Inc. 31.23% 44.33% 25.84% 76.01% 34.29%
Johnson & Johnson 39.03% 25.17% 17.54% 17.72% 27.17%
Merck & Co. Inc. 125.66% 20.99% 10.42% 27.35% 19.04%
Pfizer Inc. 252.75% 20.44% 25.02% 25.53% 6.34%
Regeneron Pharmaceuticals Inc. 25.49% 25.84% 15.22% 5.72% 16.36%
Thermo Fisher Scientific Inc. 24.94% 21.94% 19.99% 15.79% 21.66%

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 NOPAT. See details »

2 Cash operating taxes. See details »

3 2023 Calculation
CTR = 100 × Cash operating taxes ÷ NOPBT
= 100 × -191 ÷ -5,605 =

4 Click competitor name to see calculations.