is the ROIC correct? and the invested capital? Am I missing something?
1 2 3 4 5 6 A 27 28 29 30 31 B Rev 2% of Rev Year OP Cash & Equivalents Excess Cash Calculations FIN Short-Term Investments 7 OP Receivables 8 OP Inventory 9 10 11 12 FIN Long-Term Investments 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Other Current Assets Total Current Assets Property, Plant & Equipment Goodwill and Intangibles Other Long-Term Assets Total Long-Term Assets Total Assets Accounts Payable Deferred Revenue Other Current Liabilities Total Current Liabilities Long Term Debt Other Long-Term Liabilities Total Long-Term Liabilities Total Liabilities Common Stock Retained Earnings Non-controlling Interest Comprehensive Income Total Shareholders' Equity Total Liabilities and Equity C D E F G 3,138.20 3,724.20 4,478.50 4,358.40 5,710.10 63 74 90 87 114 2017 2018 2019 2020 2021 648.2 857.9 1,167.60 1,622.60 1,290.90 585 783 1078 1535 1177 1,312.40 2,205.20 2,054.10 3,488.80 2,913.10 507.9 682.3 645.2 645.5 782.7 241.2 409 595.5 601.5 587.1 99.2 178.8 200.2 267.5 271.1 2,808.90 4,333.20 4,662.60 6,625.90 5,844.90 613.1 812 1,272.90 1,577.30 1,876.40 1,885.90 1,771.30 2,623.50 1,757.70 4,415.50 396.9 501.6 748.6 840.3 976.8 72 428.6 425.6 367.7 441.4 2,967.90 3,513.50 5,070.60 4.543 7,710.10 5,776.80 7,846.70 9,733.20 11,168.90 13,555 82.5 100.7 123.5 81.6 121.2 243.8 294.3 337.8 350.3 377.2 336.5 425.6 568.9 533.3 651.4 662.8 820.6 1,030.20 965.2 1,149.80 0 0 0 0 0 333.6 338.6 418.3 444.6 453.7 333.6 338.6 418.3 444.6 453.7 996.4 1,159.20 1,448.50 1,409.80 1,603.50 4,679.30 5,170.40 5,756.90 6,445.30 7,164.40 115 1,521.70 2,494.50 3,261.30 4,760.90 1.6 8.70 20.90 27.60 50.40 -15.5 -13.3 12.4 24.9 -24.2 4,780.40 6,687.50 8,284.70 9,759.10 11,951.50 5,776.80 7,846.70 9,733.20 11,168.90 13,555.00 H Revenue Cash and cash equivalents/Revenue Receivables, net/Rev Inventories/Rev Other Current Assets Total current assets I Accounts payable/Rev Deferred Revenue Other Current Liabilities Total current Liabilities Working Capital increase (decrease) in working capital Calculation of Invested Capital Plant, Property, & Equipment, net/Revenue Other Long-term Assets, net of other non-current liabilities/Revenue Invested Capital (Without Goodwill) ROIC (NOPAT/Invested Capital Without Goodwill) Goodwill and Other Intangible Assets/Revenue Invested Capital (With Goodwill) ROIC (NOPAT/Invested Capital) J K 2017 2018 2% 16% 8% 2% 18% 11% 3% 3% 8% 8% 11% 11% 20% 22% 2.29% 11.51% 13% 13% L 2019 2% 14% 13% 3% 8% 13% M 17% 2020 2% 15% 14% 2% 8% 12% 28% 36% 9.50% 8.44% 19% N 2021 Average 2% 14% 10% 2% 7% 11% 33% 7.73% 0 17% 2% 15% 11% P Revenue 16% Historical 2021 1291 783 587 2661 Q 6,670 2022 133 1033 748 1914 R 7,792 780 1447 2023 156 1207 873 2236 S 912 1690 9,102 2024 182 1410 1020 2612 T U 10,632 12,420 2025 213 1646 1192 3051 220 257 300 2% 121 161 188 8% 377.0000 505.0000 590.0000 689.0000 805.0000 940.0000 12% 651 1150 1065 1974 1244 2306 1453 2694 2026 248 1923 1392 839 3564 1511.0000 467.0000 546.0000 638.0000 745.0000 870.0000 -1044.0000 79.0000 92.0000 107.0000 125.0000 28% 1585.0000 1852.0000 2163.0000 2527.0000 2952.0000 3448.0000 7.89% 3046 39% 441 527 615 719 516 1911 2232 2608 311% 101% 89% 39% 977.0000 1057.0000 1235.0000 1442.0000 1684.0000 1968.0000 2968 4731 1493 107% 3467 24% 4050 24% 5526 24% 56% 24% 981 3558 39%
