NGL Energy Partners LP (NGL) quarterly balance sheet — complete assets, liabilities & equity history
| Metric | Q4'26 | Q3'26 | Q2'26 | 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 |
|---|
| Total Current Assets | 773.95M | 721.39M | 717.9M | 585.58M | 962.05M | 1.02B | 1B | 990.26M | 1.18B | 1.34B | 1.56B | 1.18B | 1.29B | 1.52B | 1.64B | 1.75B | 1.55B | 1.52B | 1.34B | 1.21B |
| Cash & Short-Term Investments | 8.51M | 6.48M | 8.66M | 5.44M | 13.55M | 5.68M | 4.5M | 5.27M | 38.91M | 738K | 2.68M | 7.79M | 5.43M | 4.53M | 4.54M | 816K | 3.82M | 5.46M | 5.53M | 2.47M |
| Cash Only | 8.51M | 6.48M | 8.66M | 5.44M | 5.65M | 5.68M | 4.5M | 5.27M | 38.91M | 738K | 2.68M | 7.79M | 5.43M | 4.53M | 4.54M | 816K | 3.82M | 5.46M | 5.53M | 2.47M |
| Short-Term Investments | 0 | 0 | 0 | 0 | 7.9M | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Accounts Receivable | 669.97M | 597.58M | 558.61M | 470.14M | 583.71M | 785.99M | 729.09M | 753.89M | 721.22M | 1.01B | 1.17B | 905.1M | 1.05B | 1.13B | 1.13B | 1.31B | 1.13B | 1.04B | 863.43M | 844.58M |
| Days Sales Outstanding | 60.07 | 58.46 | 70.14 | 77.07 | 63.47 | 44.99 | 50.43 | 88.4 | 51 | 74.4 | 125.89 | 54.94 | 47.8 | 48.62 | 55.77 | 44.4 | 38.63 | 40.38 | 44.79 | 48.04 |
| Inventory | 67.35M | 78.81M | 118M | 81.48M | 69.92M | 134.07M | 193.89M | 158.71M | 106.6M | 201.57M | 250.57M | 185.64M | 142.61M | 238.07M | 344.72M | 301.3M | 251.28M | 333.92M | 319.89M | 246.18M |
| Days Inventory Outstanding | 8.66 | 12.66 | 18.92 | 15.33 | 11.88 | 10.96 | 13.71 | 20.07 | 10.19 | 17.58 | 33.36 | 10.31 | 9.31 | 13.89 | 16.22 | 10.83 | 10.95 | 14.9 | 16.32 | 13.07 |
| Other Current Assets | 28.12M | 38.53M | 146K | 1.02M | 294.88M | 21.21M | 75.99M | 72.39M | 313.92M | 67.84M | 137.59M | 84.34M | 98.09M | 97.78M | 121.85M | 70.46M | 83.47M | 100.25M | 133.47M | 112.74M |
| Total Non-Current Assets | 3.4B | 3.66B | 3.58B | 3.6B | 3.65B | 3.83B | 3.89B | 3.85B | 3.84B | 4.02B | 4.06B | 4.12B | 4.16B | 4.4B | 4.47B | 4.49B | 4.52B | 4.57B | 4.64B | 4.7B |
| Property, Plant & Equipment | 2.21B | 2.22B | 2.14B | 2.15B | 2.18B | 2.25B | 2.26B | 2.22B | 2.19B | 2.24B | 2.26B | 2.29B | 2.31B | 2.49B | 2.54B | 2.56B | 2.58B | 2.61B | 2.66B | 2.69B |
| Fixed Asset Turnover | 0.43x | 0.42x | 0.31x | 0.29x | 0.44x | 0.69x | 0.60x | 0.34x | 0.70x | 0.60x | 0.33x | 0.70x | 0.85x | 0.85x | 0.79x | 0.97x | 0.98x | 0.83x | 0.66x | 0.54x |
| Goodwill | 351.51M | 599.35M | 599.35M | 599.35M | 599.35M | 634.28M | 634.28M | 634.28M | 617.23M | 707.58M | 707.58M | 712.36M | 712.36M | 744.44M | 744.44M | 744.44M | 744.44M | 744.44M | 744.44M | 744.44M |
| Intangible Assets | 805.11M | 820M | 824.51M | 822.24M | 834.25M | 886.96M | 915.87M | 928.69M | 914.85M | 986.86M | 1B | 1.02B | 1.04B | 1.06B | 1.08B | 1.1B | 1.12B | 1.13B | 1.15B | 1.18B |
| Long-Term Investments | 0 | 0 | 0 | 0 | 3.09M | 19.31M | 20.14M | 19.22M | 25.08M | 19.54M | 29.18M | 32.63M | 29.68M | 22.77M | 21.56M | 22.57M | 21.9M | 21.26M | 21.03M | 21.43M |
| Other Non-Current Assets | 39.9M | 19.59M | 15.49M | 31.86M | 33.98M | 42.49M | 52.9M | 50.17M | 91.41M | 69M | 63.3M | 59.52M | 65.06M | 78.89M | 80.74M | 59.18M | 62.95M | 65.29M | 67.13M | 65.49M |
| Total Assets | 4.18B | 4.38B | 4.3B | 4.19B | 4.61B | 4.85B | 4.89B | 4.84B | 5.02B | 5.36B | 5.63B | 5.31B | 5.46B | 5.91B | 6.11B | 6.24B | 6.07B | 6.09B | 5.98B | 5.91B |
| Asset Turnover | 0.22x | 0.21x | 0.16x | 0.14x | 0.21x | 0.32x | 0.28x | 0.15x | 0.30x | 0.25x | 0.14x | 0.30x | 0.36x | 0.36x | 0.33x | 0.41x | 0.42x | 0.36x | 0.30x | 0.25x |
| Asset Growth % | -9.41% | -9.61% | -12.04% | -13.46% | -8.18% | -9.59% | -13.11% | -8.78% | -7.99% | -9.33% | -7.95% | -14.94% | -10.12% | -2.96% | 2.21% | 5.59% | 2.07% | 2.4% | -4.85% | -6.62% |
| Total Current Liabilities | 739.48M | 646.78M | 570.25M | 468.75M | 739.23M | 846.45M | 828.99M | 864.55M | 977.35M | 1.09B | 1.31B | 986.87M | 1.11B | 1.48B | 1.21B | 1.39B | 1.28B | 1.2B | 1.05B | 1.01B |
| Accounts Payable | 495.18M | 451.66M | 391.29M | 312.81M | 462.08M | 645.36M | 594.62M | 627.72M | 638.8M | 832.02M | 1.08B | 773.73M | 927.66M | 952.57M | 993.82M | 1.15B | 1.08B | 973.73M | 819.19M | 763.32M |
| Days Payables Outstanding | 56.1 | 54.23 | 66.78 | 78.45 | 64.47 | 41.45 | 47.52 | 95.81 | 48.63 | 74.37 | 141.83 | 53.45 | 45.98 | 46.4 | 53.83 | 43.81 | 38.52 | 40.85 | 45.64 | 46.61 |
| Short-Term Debt | 44.92M | 44.85M | 8.88M | 8.84M | 36.82M | 8.77M | 7.87M | 7.85M | 36.39M | 0 | 33.38M | 34.7M | 34.17M | 303.79M | 2.48M | 2.43M | 2.38M | 2.33M | 2.28M | 2.23M |
| Deferred Revenue (Current) | 15.2M | 13.69M | 0 | 0 | 10.35M | 0 | 25.16M | 25.44M | 17.31M | 0 | 29.24M | 19.03M | 14.7M | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Other Current Liabilities | 165.43M | 136.57M | 14.22M | 30.1M | 156.99M | 64.87M | 145.15M | 145.3M | 251.79M | 99.45M | 143.98M | 144.74M | 106.6M | 69.19M | 94.85M | 88.93M | 63.68M | 71.66M | 88.52M | 79.88M |
| Current Ratio | 1.05x | 1.12x | 1.26x | 1.25x | 1.30x | 1.20x | 1.21x | 1.15x | 1.21x | 1.23x | 1.20x | 1.20x | 1.16x | 1.02x | 1.36x | 1.26x | 1.21x | 1.27x | 1.27x | 1.20x |
| Quick Ratio | 0.96x | 0.99x | 1.05x | 1.08x | 1.21x | 1.04x | 0.98x | 0.96x | 1.10x | 1.05x | 1.00x | 1.01x | 1.04x | 0.86x | 1.07x | 1.04x | 1.01x | 0.99x | 0.97x | 0.95x |
| Cash Conversion Cycle | 12.63 | 16.89 | 22.28 | 13.94 | 10.88 | 14.51 | 16.62 | 12.66 | 12.56 | 17.61 | 17.43 | 11.8 | 11.13 | 16.12 | 18.16 | 11.42 | 11.07 | 14.42 | 15.48 | 14.5 |
| Total Non-Current Liabilities | 3.44B | 3.15B | 3.12B | 3.09B | 3.17B | 3.29B | 3.32B | 3.21B | 3.04B | 2.86B | 2.95B | 2.98B | 3.03B | 3.08B | 3.61B | 3.56B | 3.53B | 3.6B | 3.62B | 3.58B |
| Long-Term Debt | 3.22B | 3.01B | 2.9B | 2.87B | 2.96B | 3.08B | 3.12B | 3.02B | 2.84B | 2.68B | 2.78B | 2.8B | 2.86B | 2.92B | 3.45B | 3.38B | 3.35B | 3.41B | 3.42B | 3.37B |
| Capital Lease Obligations | 86.67M | 93.4M | 84.94M | 88.45M | 85.34M | 87.09M | 74.12M | 67.27M | 70.57M | 70.93M | 63.98M | 65M | 58.45M | 53.62M | 62.19M | 68.96M | 72.78M | 78.63M | 87.39M | 96.91M |
| Deferred Tax Liabilities | 28.5M | 28.8M | 0 | 0 | 29.9M | 0 | 0 | 0 | 38M | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Other Non-Current Liabilities | 103.94M | 10.7M | 131.49M | 130.71M | 95.9M | 121.89M | 128.67M | 124.07M | 91.19M | 107.71M | 107.94M | 111.98M | 111.23M | 103.28M | 104.03M | 103.52M | 104.35M | 108.42M | 110.91M | 115.44M |
| Total Liabilities | 4.18B | 3.79B | 3.69B | 3.56B | 3.91B | 4.13B | 4.15B | 4.07B | 4.02B | 3.95B | 4.26B | 3.97B | 4.14B | 4.56B | 4.82B | 4.95B | 4.8B | 4.8B | 4.67B | 4.59B |
| Total Debt | 3.36B | 3.15B | 3.03B | 3B | 3.11B | 3.2B | 3.23B | 3.12B | 2.95B | 2.79B | 2.88B | 2.9B | 2.95B | 3.31B | 3.55B | 3.49B | 3.47B | 3.54B | 3.55B | 3.52B |
| Net Debt | 3.35B | 3.14B | 3.02B | 2.99B | 3.11B | 3.2B | 3.23B | 3.12B | 2.91B | 2.79B | 2.88B | 2.9B | 2.94B | 3.31B | 3.54B | 3.49B | 3.46B | 3.53B | 3.55B | 3.51B |
| Debt / Equity | - | 5.34x | 4.95x | 4.76x | 4.46x | 4.49x | 4.39x | 4.08x | 2.95x | 1.97x | 2.11x | 2.17x | 2.24x | 2.45x | 2.75x | 2.71x | 2.74x | 2.73x | 2.71x | 2.68x |
| Debt / EBITDA | 22.24x | 18.25x | 19.13x | 18.28x | 17.93x | 22.57x | 23.10x | 21.64x | 20.79x | 19.93x | 19.96x | 20.58x | 25.21x | 19.25x | 25.91x | 22.69x | 31.72x | 30.06x | 27.21x | 188.55x |
| Net Debt / EBITDA | 22.18x | 18.22x | 19.07x | 18.25x | 17.90x | 22.53x | 23.07x | 21.60x | 20.51x | 19.92x | 19.95x | 20.53x | 25.16x | 19.22x | 25.88x | 22.69x | 31.68x | 30.01x | 27.16x | 188.42x |
| Interest Coverage | 1.43x | 1.76x | 1.43x | 1.43x | 1.27x | 1.21x | 1.05x | 1.19x | 0.86x | 1.26x | 1.37x | 1.26x | 0.30x | 1.72x | 1.00x | 1.28x | 0.34x | 0.66x | 0.91x | -1.07x |
| Total Equity | -6.18M | 589.85M | 611.16M | 629.74M | 697.37M | 714.06M | 736.61M | 765.26M | 999.17M | 1.41B | 1.37B | 1.34B | 1.32B | 1.35B | 1.29B | 1.29B | 1.27B | 1.29B | 1.31B | 1.31B |
| Equity Growth % | -100.89% | -17.39% | -17.03% | -17.71% | -30.2% | -49.43% | -46.09% | -42.81% | -24.22% | 4.48% | 5.76% | 3.89% | 4.19% | 4.37% | -1.64% | -1.98% | -15.59% | -25.74% | -39.21% | -40.13% |
| Book Value per Share | -0.05 | 4.71 | 4.80 | 4.77 | 5.28 | 5.41 | 5.57 | 5.78 | 7.54 | 10.66 | 10.36 | 10.14 | 9.93 | 10.05 | 9.88 | 9.86 | 9.71 | 9.97 | 10.14 | 10.14 |
| Total Shareholders' Equity | 25.91M | 623.54M | 644.32M | 662.17M | 676.7M | 745.32M | 714.94M | 797.84M | 1.03B | 1.45B | 1.4B | 1.37B | 1.35B | 1.39B | 1.33B | 1.32B | 1.3B | 1.33B | 1.35B | 1.35B |
| Common Stock | -612.28M | -194.66M | -190.88M | -173.03M | -170.28M | -154.15M | -131.71M | -101.09M | 134.81M | 549.6M | 503.8M | 475.35M | 455.56M | 488.22M | 428.87M | 424.85M | 401.49M | 430.36M | 448.5M | 448.96M |
| Retained Earnings | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Treasury Stock | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Accumulated OCI | 0 | 0 | 0 | 0 | 9K | 10K | -99K | -523K | -499K | -457K | -473K | -434K | -450K | -439K | -440K | -358K | -308K | -314K | -310K | -258K |
| Minority Interest | -32.09M | -33.7M | -33.16M | -32.44M | 20.67M | -31.26M | 21.67M | -32.57M | -34.6M | -36.68M | -36.49M | -36.17M | -36.04M | -35.82M | -36.02M | -35.82M | -35.08M | -34.69M | -34.19M | -33.98M |