TransCanada PipeLines Limited 6 (TCPA) quarterly balance sheet — complete assets, liabilities & equity history
| Metric | Q3'21 | Q2'21 | Q1'21 | Q3'20 | Q2'20 | Q1'20 | Q4'19 | Q3'19 | Q2'19 | Q1'19 | Q4'18 | Q3'18 | Q2'18 | Q1'18 | Q4'17 | Q3'17 | Q2'17 | Q1'17 | Q4'16 | Q3'16 |
|---|
| Total Current Assets | 6.87B | 6.74B | 5.78B | 3.84B | 4.19B | 6.3B | 5.9B | 6.25B | 4.34B | 3.67B | 3.76B | 3.89B | 4.03B | 3.43B | 3.74B | 4.61B | 3.74B | 5.97B | 6B | 5.87B |
| Cash & Short-Term Investments | 2.25B | 2.33B | 1.8B | 892.38M | 1.48B | 1.33B | 1.08B | 1.7B | 509.66M | 652.72M | 366.82M | 789.88M | 1.09B | 864.85M | 948.16M | 1.11B | 1.12B | 633.6M | 1.23B | 1.68B |
| Cash Only | 2.25B | 2.33B | 1.8B | 892.38M | 1.48B | 1.33B | 1.08B | 1.7B | 509.66M | 652.72M | 366.82M | 789.88M | 1.09B | 864.85M | 948.16M | 1.11B | 1.12B | 633.6M | 954.48M | 1.68B |
| Short-Term Investments | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 264.98M | 0 | 0 | 0 | 280.38M | 0 |
| Accounts Receivable | 2.34B | 2.44B | 2.34B | 1.77B | 1.64B | 1.84B | 1.99B | 1.71B | 1.79B | 1.84B | 1.97B | 1.9B | 1.61B | 1.71B | 2.01B | 2.26B | 1.63B | 1.59B | 1.56B | 3.17B |
| Days Sales Outstanding | 86.03 | 87.1 | 71.25 | 66.84 | 69.79 | 74.76 | 68.66 | 69.25 | 66.65 | 66.04 | 66.02 | 66.81 | 64.51 | 63.04 | 72.39 | 69.22 | 57.01 | 53.95 | 81.85 | 405.56 |
| Inventory | 585.63M | 612.13M | 530.69M | 375.07M | 351.69M | 302.1M | 348.56M | 354.23M | 338.24M | 304.65M | 315.57M | 294.75M | 306.36M | 297.85M | 301.69M | 311.84M | 302.61M | 287.93M | 274.41M | 322.62M |
| Days Inventory Outstanding | 39.49 | 40.45 | 33.93 | 27.08 | 25.84 | 27.19 | 24.39 | 26.49 | 23.28 | 20.84 | 19.75 | 20.24 | 21.07 | 17.34 | 16.59 | 17.19 | 16.7 | 16.34 | 16.67 | 62.23 |
| Other Current Assets | 1.7B | 1.35B | 1.12B | 803.29M | 718.8M | 2.83B | 2.44B | 2.49B | 1.71B | 870.54M | 1.07B | 905.92M | 1.02B | 556.92M | 385.49M | 938.71M | 692.23M | 3.45B | 2.84B | 705.35M |
| Total Non-Current Assets | 75.51B | 74.99B | 73.74B | 72.42B | 70.55B | 69.44B | 70.66B | 68.99B | 70.98B | 70.69B | 68.67B | 68.87B | 66.22B | 65.45B | 64.98B | 64.4B | 62.63B | 60.41B | 59.57B | 62.25B |
| Property, Plant & Equipment | 54.61B | 54.26B | 53.46B | 52.81B | 51.31B | 50.78B | 50.5B | 49.06B | 51.03B | 50.54B | 48.69B | 48.9B | 46.71B | 46.01B | 45.71B | 44.65B | 43.08B | 41.5B | 40.62B | 42.76B |
| Fixed Asset Turnover | 0.05x | 0.05x | 0.05x | 0.04x | 0.04x | 0.05x | 0.05x | 0.05x | 0.05x | 0.05x | 0.06x | 0.05x | 0.05x | 0.06x | 0.06x | 0.06x | 0.06x | 0.06x | 0.06x | 0.07x |
| Goodwill | 9.93B | 9.96B | 9.94B | 9.92B | 9.94B | 9.86B | 9.94B | 9.94B | 9.96B | 10.39B | 10.38B | 10.45B | 10.44B | 10.46B | 10.44B | 10.46B | 10.45B | 10.38B | 10.41B | 10.38B |
| Intangible Assets | 0 | 0 | 0 | 0 | 0 | 0 | 1.32B | 0 | 0 | 0 | 769.51M | 0 | 0 | 0 | 475.68M | 0 | 0 | 0 | 1.56B | 0 |
| Long-Term Investments | 8.77B | 8.54B | 8.41B | 7.86B | 7.52B | 6.98B | 7.33B | 7.32B | 7.34B | 7.23B | 7.1B | 7.05B | 6.74B | 6.65B | 6.6B | 5.72B | 5.47B | 5.22B | 5.46B | 5.41B |
| Other Non-Current Assets | 2.2B | 2.22B | 1.94B | 1.83B | 1.79B | 1.82B | 1.54B | 2.66B | 2.65B | 2.53B | 1.49B | 2.47B | 2.33B | 2.33B | 1.5B | 3.57B | 3.64B | 3.3B | 1.29B | 3.7B |
| Total Assets | 82.39B | 81.73B | 79.52B | 76.26B | 74.74B | 75.74B | 76.56B | 75.23B | 75.32B | 74.36B | 72.43B | 72.76B | 70.24B | 68.88B | 68.72B | 69.01B | 66.38B | 66.38B | 65.58B | 68.12B |
| Asset Turnover | 0.03x | 0.03x | 0.03x | 0.03x | 0.03x | 0.03x | 0.03x | 0.03x | 0.03x | 0.04x | 0.04x | 0.03x | 0.03x | 0.04x | 0.04x | 0.04x | 0.04x | 0.04x | 0.04x | 0.04x |
| Asset Growth % | 8.03% | 9.35% | 4.99% | 1.36% | -0.77% | 1.86% | 5.71% | 3.4% | 7.23% | 7.96% | 5.4% | 5.44% | 5.82% | 3.77% | 4.79% | 1.3% | - | - | - | - |
| Total Current Liabilities | 13.38B | 11.08B | 7.14B | 7.54B | 7.18B | 12.3B | 9.95B | 8.33B | 9.92B | 10B | 9.48B | 11.27B | 10.37B | 11.4B | 7.88B | 10.97B | 9.55B | 8.61B | 7.47B | 6.44B |
| Accounts Payable | 3.66B | 3.52B | 3.27B | 2.89B | 2.7B | 2.77B | 2.56B | 3.42B | 3.05B | 3.15B | 2.36B | 2.96B | 3.03B | 2.87B | 2.27B | 3.26B | 3.12B | 2.85B | 1.82B | 2.86B |
| Days Payables Outstanding | 236.63 | 240.03 | 230.4 | 208.11 | 216.07 | 222.44 | 207.36 | 247.35 | 224.4 | 185.22 | 172.34 | 201.76 | 205.6 | 148.6 | 149.75 | 178.68 | 168.86 | 135.75 | 130.85 | 552.42 |
| Short-Term Debt | 8.31B | 6.22B | 2.57B | 3.31B | 3.06B | 7.77B | 5.45B | 3.71B | 5.66B | 5.5B | 4.56B | 6.99B | 6.38B | 7.62B | 3.69B | 6.81B | 5.53B | 4.89B | 3.71B | 3.16B |
| Deferred Revenue (Current) | 58.33M | 71.06M | 91.5M | 62.89M | 72.69M | 28.8M | 0 | 42.3M | 39.79M | 29.19M | 8.05M | 31.72M | 0 | 0 | 13.57M | 0 | 0 | 0 | 0 | 0 |
| Other Current Liabilities | 1.35B | 1.27B | 1.21B | 1.28B | 1.35B | 1.73B | 1.95B | 1.16B | 1.17B | 1.32B | 2.55B | 1.29B | 962.41M | 910.61M | 1.9B | 887.54M | 890.89M | 866.79M | 1.94B | 420.01M |
| Current Ratio | 0.51x | 0.61x | 0.81x | 0.51x | 0.58x | 0.51x | 0.59x | 0.75x | 0.44x | 0.37x | 0.40x | 0.35x | 0.39x | 0.30x | 0.47x | 0.42x | 0.39x | 0.69x | 0.80x | 0.91x |
| Quick Ratio | 0.47x | 0.55x | 0.73x | 0.46x | 0.53x | 0.49x | 0.56x | 0.71x | 0.40x | 0.34x | 0.36x | 0.32x | 0.36x | 0.28x | 0.44x | 0.39x | 0.36x | 0.66x | 0.77x | 0.86x |
| Cash Conversion Cycle | -111.1 | -112.49 | -125.22 | -114.19 | -120.44 | -120.49 | -114.31 | -151.61 | -134.47 | -98.34 | -86.57 | -114.71 | -120.02 | -68.23 | -60.77 | -92.26 | -95.15 | -65.46 | -32.33 | -84.63 |
| Total Non-Current Liabilities | 43.37B | 44.7B | 46.9B | 42.78B | 42.2B | 39.45B | 41.63B | 42.59B | 41.19B | 40.94B | 40.26B | 41.22B | 40.17B | 37.92B | 39.37B | 38.97B | 38.43B | 39.88B | 39.68B | 43.99B |
| Long-Term Debt | 34.72B | 36.01B | 38.61B | 34.21B | 34.04B | 30.96B | 33.08B | 34.11B | 32.43B | 32.36B | 32.23B | 32.66B | 31.83B | 29.61B | 31.03B | 29.92B | 29.64B | 31.52B | 31.5B | 35.85B |
| Capital Lease Obligations | 0 | 0 | 0 | 0 | 0 | 0 | 367.07M | 370.09M | 379.57M | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Deferred Tax Liabilities | 4.27B | 4.24B | 3.92B | 4.34B | 4.19B | 4.09B | 4.4B | 4.3B | 4.56B | 4.49B | 4.41B | 4.51B | 4.33B | 4.29B | 4.31B | 6.45B | 6.2B | 5.81B | 5.71B | 5.59B |
| Other Non-Current Liabilities | 4.22B | 4.29B | 4.22B | 4.06B | 3.81B | 4.18B | 3.61B | 3.67B | 3.71B | 4B | 3.53B | 4.03B | 4.01B | 4.02B | 4.03B | 2.6B | 2.58B | 2.54B | 2.46B | 2.55B |
| Total Liabilities | 56.76B | 55.78B | 54.05B | 50.32B | 49.38B | 51.75B | 51.58B | 50.91B | 51.12B | 50.94B | 49.73B | 52.49B | 50.53B | 49.32B | 47.26B | 49.94B | 47.97B | 48.49B | 47.15B | 50.43B |
| Total Debt | 43.03B | 42.23B | 41.18B | 37.52B | 37.1B | 38.74B | 38.89B | 38.18B | 38.47B | 37.86B | 36.79B | 39.64B | 38.2B | 37.23B | 34.73B | 36.73B | 35.17B | 36.41B | 35.21B | 39.01B |
| Net Debt | 40.78B | 39.9B | 39.39B | 36.63B | 35.62B | 37.41B | 37.81B | 36.49B | 37.96B | 37.21B | 36.42B | 38.86B | 37.11B | 36.37B | 33.78B | 35.63B | 34.06B | 35.78B | 34.25B | 37.33B |
| Debt / Equity | 1.68x | 1.63x | 1.62x | 1.45x | 1.46x | 1.62x | 1.56x | 1.57x | 1.59x | 1.62x | 1.62x | 1.96x | 1.94x | 1.90x | 1.62x | 1.93x | 1.91x | 2.04x | 2.01x | 2.22x |
| Debt / EBITDA | 28.87x | 27.00x | 23.32x | 25.36x | 25.82x | 24.83x | 26.09x | 26.44x | 24.69x | 24.02x | 21.95x | 28.55x | 28.19x | 26.54x | 26.26x | 29.54x | 28.23x | 26.99x | 27.50x | 31.11x |
| Net Debt / EBITDA | 27.36x | 25.51x | 22.30x | 24.76x | 24.79x | 23.97x | 25.37x | 25.27x | 24.36x | 23.60x | 21.73x | 27.98x | 27.38x | 25.92x | 25.54x | 28.65x | 27.34x | 26.52x | 26.75x | 29.77x |
| Interest Coverage | 2.10x | 2.73x | -2.63x | 2.86x | 3.47x | 1.98x | 2.22x | 2.39x | 3.60x | 3.49x | 2.18x | 2.77x | 2.89x | 2.83x | 0.75x | 2.35x | 3.15x | 2.51x | 1.01x | 0.39x |
| Total Equity | 25.63B | 25.95B | 25.47B | 25.94B | 25.36B | 23.92B | 24.98B | 24.32B | 24.21B | 23.43B | 22.69B | 20.28B | 19.71B | 19.56B | 21.46B | 19.07B | 18.41B | 17.83B | 17.55B | 17.61B |
| Equity Growth % | -1.2% | 2.33% | 6.5% | 6.66% | 4.75% | 2.11% | 10.1% | 19.95% | 22.81% | 19.76% | 5.73% | 6.34% | 7.09% | 9.72% | 22.29% | 8.28% | - | - | - | - |
| Book Value per Share | 26.18 | 26.50 | 26.73 | 27.60 | 26.98 | 25.45 | 26.62 | 26.07 | 26.08 | 25.41 | - | 22.35 | 22.00 | 22.08 | - | - | - | - | - | - |
| Total Shareholders' Equity | 25.53B | 25.85B | 25.06B | 24.11B | 23.83B | 22.65B | 23.72B | 23.08B | 22.97B | 22.18B | 21.48B | 18.71B | 18.15B | 18.02B | 19.98B | 17.61B | 16.96B | 16.46B | 16.26B | 15.56B |
| Common Stock | 20.98B | 21.5B | 21.16B | 18.33B | 17.97B | 17.2B | 18.81B | 18.22B | 18.21B | 17.57B | 16.97B | 17.32B | 16.87B | 17.03B | 16.89B | 17.25B | 16.46B | 15.87B | 15.65B | 14.3B |
| Retained Earnings | 2.78B | 2.9B | 2.45B | 3.76B | 3.58B | 3.06B | 3.05B | 2.7B | 2.7B | 2.32B | 2.03B | 2.42B | 2.14B | 2.04B | 1.3B | 1.63B | 1.49B | 1.29B | 1.18B | 1.82B |
| Treasury Stock | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Accumulated OCI | -1.56B | -1.96B | -1.71B | -962.75M | -647.58M | -405.38M | -1.2B | -845.17M | -994.84M | -693.14M | -443.7M | -1.04B | -862.06M | -1.05B | -1.38B | -1.26B | -992.53M | -743.82M | -715.86M | -712.19M |
| Minority Interest | 97.74M | 98.52M | 412.94M | 1.83B | 1.53B | 1.27B | 1.26B | 1.24B | 1.24B | 1.24B | 1.21B | 1.57B | 1.56B | 1.54B | 1.48B | 1.45B | 1.44B | 1.37B | 1.29B | 2.05B |