Shopify Inc. (SHOP) quarterly balance sheet — complete assets, liabilities & equity history
| Metric | Q1'26 | Q4'25 | Q3'25 | Q2'25 | Q1'25 | Q4'24 | Q3'24 | Q2'24 | Q1'24 | Q4'23 | Q3'23 | Q2'23 | Q1'23 | Q4'22 | Q3'22 | Q2'22 | Q1'22 | Q4'21 | Q3'21 | Q2'21 |
|---|
| Total Current Assets | 6.19B | 8.3B | 8.7B | 8.02B | 7.45B | 7.25B | 6.54B | 6.4B | 6.44B | 6.28B | 6.16B | 5.91B | 5.93B | 6.05B | 6.01B | 7.86B | 8.07B | 8.54B | 8.33B | 8.46B |
| Cash & Short-Term Investments | 5.74B | 5.77B | 6.34B | 5.83B | 5.51B | 5.48B | 4.89B | 5.02B | 5.18B | 5.01B | 4.92B | 4.78B | 4.86B | 5.05B | 4.94B | 6.95B | 7.25B | 7.77B | 7.52B | 7.76B |
| Cash Only | 1.85B | 1.53B | 2.41B | 1.55B | 1.31B | 1.5B | 1.51B | 1.54B | 1.62B | 1.41B | 1.29B | 1.61B | 1.74B | 1.65B | 1.38B | 3.35B | 2.45B | 2.5B | 2.19B | 2.36B |
| Short-Term Investments | 3.9B | 4.23B | 3.93B | 4.29B | 4.21B | 3.98B | 3.39B | 3.48B | 3.55B | 3.6B | 3.63B | 3.17B | 3.13B | 3.4B | 3.56B | 3.6B | 4.8B | 5.27B | 5.33B | 5.39B |
| Accounts Receivable | 449M | 2.37B | 2.13B | 1.95B | 1.69B | 1.66B | 1.44B | 1.19B | 1.08B | 1.16B | 1.08B | 981M | 905M | 857.48M | 912.69M | 789.73M | 713.87M | 667.05M | 733.16M | 625.7M |
| Days Sales Outstanding | 40.02 | 56.33 | 65.96 | 61.8 | 63.76 | 50.55 | 55.91 | 50.57 | 54.64 | 47.97 | 55.34 | 50.66 | 52.59 | 46.93 | 57.33 | 52.83 | 51.61 | 46.67 | 55.62 | 47.09 |
| Inventory | 0 | 21M | 0 | 0 | 0 | 26M | 0 | 0 | 0 | 19M | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Days Inventory Outstanding | - | 0.98 | - | - | - | 1.64 | - | - | - | 1.62 | - | - | - | - | - | - | - | - | - | - |
| Other Current Assets | 0 | 14M | 226.78M | 234.52M | 242M | 0 | 211M | 188M | 183M | 7M | 162M | 148M | 159M | 30M | 152.32M | 113.25M | 113.06M | 12.5M | 80.89M | 79.08M |
| Total Non-Current Assets | 1.48B | 6.89B | 6.33B | 6.57B | 5.96B | 6.67B | 5.79B | 4.94B | 4.67B | 5.02B | 4.3B | 3.79B | 5.04B | 4.71B | 5.19B | 2.89B | 3.76B | 4.8B | 5.2B | 3.5B |
| Property, Plant & Equipment | 138M | 141M | 144.86M | 143.32M | 151M | 140M | 143M | 144M | 148M | 147M | 124M | 170M | 482M | 486M | 478.2M | 338.76M | 329.77M | 301.91M | 215.2M | 211.01M |
| Fixed Asset Turnover | 22.72x | 25.69x | 19.74x | 18.21x | 16.22x | 19.87x | 15.07x | 14.01x | 12.62x | 15.82x | 11.66x | 5.20x | 3.12x | 3.60x | 3.34x | 3.87x | 3.81x | 5.34x | 5.27x | 5.25x |
| Goodwill | 491M | 491M | 490.52M | 492.09M | 491M | 452M | 452M | 449M | 427M | 427M | 427M | 427M | 1.86B | 1.84B | 1.84B | 379.35M | 356.53M | 356.53M | 349.43M | 311.87M |
| Intangible Assets | 28M | 30M | 32.97M | 36.08M | 39M | 22M | 24M | 26M | 25M | 29M | 33M | 26M | 372M | 390M | 410.82M | 133.13M | 131.61M | 138.5M | 141.93M | 124.2M |
| Long-Term Investments | 708M | 6.16B | 5.61B | 5.84B | 5.15B | 6B | 5.13B | 4.28B | 4.03B | 4.38B | 3.68B | 3.13B | 2.28B | 1.95B | 2.42B | 1.99B | 2.69B | 3.96B | 4.45B | 2.8B |
| Other Non-Current Assets | 0 | 39M | 22.98M | 28.06M | 23M | 21M | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 199.6M | 0 | 0 | 0 |
| Total Assets | 14.12B | 15.19B | 15.02B | 14.59B | 13.4B | 13.92B | 12.33B | 11.35B | 11.11B | 11.3B | 10.46B | 9.7B | 10.96B | 10.76B | 11.2B | 10.75B | 11.83B | 13.34B | 13.54B | 11.96B |
| Asset Turnover | 0.22x | 0.24x | 0.19x | 0.19x | 0.17x | 0.21x | 0.18x | 0.18x | 0.17x | 0.20x | 0.17x | 0.16x | 0.14x | 0.16x | 0.12x | 0.11x | 0.10x | 0.10x | 0.09x | 0.10x |
| Asset Growth % | 5.38% | 9.09% | 21.86% | 28.62% | 20.59% | 23.23% | 17.82% | 16.93% | 1.35% | 5.04% | -6.6% | -9.72% | -7.36% | -19.36% | -17.24% | -10.1% | 9.33% | 71.85% | 81.41% | 134.5% |
| Total Current Liabilities | 500M | 1.39B | 2.21B | 2.08B | 2.01B | 1.96B | 921M | 874M | 902M | 898M | 852M | 880M | 883M | 856M | 905.22M | 703.21M | 681.93M | 702.73M | 596.56M | 511.08M |
| Accounts Payable | 1.03B | 570M | 969.05M | 840.87M | 776M | 360M | 612M | 0 | 0 | 364M | 0 | 554M | 535M | 364M | 596.11M | 419.41M | 406.65M | 284.01M | 350.59M | 289.54M |
| Days Payables Outstanding | 44.37 | 35.77 | 57.3 | 53.39 | 42.92 | 30.62 | 53.93 | - | - | 30.95 | - | 57.68 | 51.14 | 47.16 | 66.36 | 58.82 | 54.91 | 42.47 | 57.2 | 57.35 |
| Short-Term Debt | 179M | 0 | 920M | 919M | 919M | 918M | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Deferred Revenue (Current) | 321M | 300M | 299.71M | 298.66M | 295M | 283M | 290M | 298M | 296M | 302M | 304M | 310M | 324M | 296M | 287.63M | 254.01M | 247.65M | 216.79M | 203.85M | 183.16M |
| Other Current Liabilities | 0 | 169M | 3.08M | 2M | 0 | 112M | 998.42K | 559M | 589M | 58M | 533M | 0 | 0 | 84M | 0 | 0 | 0 | 77.83M | 0 | 0 |
| Current Ratio | 12.38x | 5.96x | 3.93x | 3.85x | 3.71x | 3.71x | 7.10x | 7.32x | 7.14x | 6.99x | 7.23x | 6.71x | 6.71x | 7.07x | 6.64x | 11.17x | 11.84x | 12.15x | 13.97x | 16.55x |
| Quick Ratio | 12.38x | 5.94x | 3.93x | 3.85x | 3.71x | 3.70x | 7.10x | 7.32x | 7.14x | 6.97x | 7.23x | 6.71x | 6.71x | 7.07x | 6.64x | 11.17x | 11.84x | 12.15x | 13.97x | 16.55x |
| Cash Conversion Cycle | - | 21.54 | - | - | - | 21.56 | - | - | - | 18.64 | - | - | - | - | - | - | - | - | - | - |
| Total Non-Current Liabilities | 1.12B | 324M | 314.69M | 359.8M | 340M | 410M | 1.29B | 1.3B | 1.32B | 1.33B | 1.33B | 1.36B | 1.62B | 1.66B | 1.61B | 1.33B | 1.36B | 1.5B | 1.57B | 1.32B |
| Long-Term Debt | 0 | 0 | 0 | 0 | 0 | 0 | 917M | 917M | 916M | 916M | 915M | 914M | 914M | 913M | 912.72M | 912.14M | 911.55M | 910.96M | 910.38M | 909.79M |
| Capital Lease Obligations | 163.54M | 171M | 176M | 200.45M | 200M | 190M | 206M | 203M | 212M | 217M | 192M | 204M | 461M | 465M | 369.13M | 254.42M | 264.53M | 246.78M | 174.19M | 151.16M |
| Deferred Tax Liabilities | 0 | 55M | 29M | 36.08M | 5M | 73M | 8M | 10M | 6M | 6M | 5M | 6M | 17M | 16M | 23.58M | 1.33M | 211K | 183.43M | 310.63M | 127.78M |
| Other Non-Current Liabilities | 1.12B | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Total Liabilities | 1.62B | 1.72B | 2.53B | 2.44B | 2.35B | 2.37B | 2.21B | 2.17B | 2.22B | 2.23B | 2.18B | 2.24B | 2.51B | 2.52B | 2.51B | 2.03B | 2.04B | 2.21B | 2.17B | 1.84B |
| Total Debt | 179M | 188M | 1.11B | 1.14B | 1.14B | 1.13B | 1.14B | 1.14B | 1.15B | 1.15B | 1.12B | 1.13B | 1.4B | 1.4B | 1.3B | 1.19B | 1.2B | 1.17B | 1.1B | 1.08B |
| Net Debt | -1.67B | -1.35B | -1.3B | -403.9M | -171M | -372M | -366M | -404M | -478M | -263M | -165M | -477M | -339M | -253M | -79.37M | -2.16B | -1.26B | -1.33B | -1.09B | -1.29B |
| Debt / Equity | 0.01x | 0.01x | 0.09x | 0.09x | 0.10x | 0.10x | 0.11x | 0.12x | 0.13x | 0.13x | 0.14x | 0.15x | 0.17x | 0.17x | 0.15x | 0.14x | 0.12x | 0.11x | 0.10x | 0.11x |
| Debt / EBITDA | 0.47x | 0.29x | 3.18x | 3.82x | 5.39x | 2.38x | 3.92x | 4.53x | 11.93x | 3.85x | 8.31x | - | - | - | - | - | - | 32.02x | 115.77x | 6.99x |
| Net Debt / EBITDA | -4.37x | -2.11x | -3.70x | -1.35x | -0.81x | -0.79x | -1.26x | -1.61x | -4.98x | -0.88x | -1.22x | - | - | - | - | - | - | -36.28x | -114.64x | -8.36x |
| Interest Coverage | - | - | - | - | - | - | - | - | - | - | - | - | - | -697.83x | -418.01x | -220.52x | -110.77x | -560.18x | 1537.54x | 1066.05x |
| Total Equity | 12.5B | 13.47B | 12.5B | 12.15B | 11.05B | 11.56B | 10.12B | 9.17B | 8.89B | 9.07B | 8.28B | 7.46B | 8.46B | 8.24B | 8.69B | 8.72B | 9.79B | 11.13B | 11.37B | 10.12B |
| Equity Growth % | 13.12% | 16.57% | 23.53% | 32.48% | 24.27% | 27.49% | 22.14% | 22.9% | 5.16% | 10.04% | -4.71% | -14.39% | -13.61% | -26% | -23.55% | -13.87% | 7.09% | 73.94% | 84.08% | 118.64% |
| Book Value per Share | 9.59 | 10.32 | 9.52 | 9.28 | 8.53 | 8.93 | 7.77 | 7.06 | 6.91 | 6.99 | 6.39 | 5.83 | 6.55 | 6.47 | 6.85 | 6.91 | 7.77 | 8.85 | 8.91 | 7.94 |
| Total Shareholders' Equity | 12.5B | 13.47B | 12.5B | 12.15B | 11.05B | 11.56B | 10.12B | 9.17B | 8.89B | 9.07B | 8.28B | 7.46B | 8.46B | 8.24B | 8.69B | 8.72B | 9.79B | 11.13B | 11.37B | 10.12B |
| Common Stock | 9.97B | 10.38B | 10.11B | 10.01B | 9.83B | 9.63B | 9.47B | 9.37B | 9.28B | 9.2B | 9.1B | 9.02B | 8.89B | 8.75B | 8.65B | 8.24B | 8.15B | 8.04B | 7.93B | 7.84B |
| Retained Earnings | 2.29B | 2.86B | 2.11B | 1.86B | 947M | 1.63B | 336M | -492M | -663M | -390M | -1.05B | -1.76B | -454M | -522M | 101.42M | 259.83M | 1.46B | 2.94B | 3.31B | 2.16B |
| Treasury Stock | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Accumulated OCI | -4M | 1M | -999.02K | 5.01M | -6M | -10M | -1M | -5M | -4M | 4M | -6M | 4M | -7M | -16M | -38.01M | -9.12M | 413K | -5.97M | -5.89M | 3.3M |
| Minority Interest | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |