Sample Name
Sample Code
Sample Name
Sample Code
Sample Name
Sample Code
4
SPDR S&P Oil & Gas Exploration & Production ETF
XOP
5
United Sts 12 Month Oil Fd Lp Unit Ben Int
USL
| (Q1)Mar 31, 2023 | (FY)Dec 31, 2022 | (Q4)Dec 31, 2022 | (Q3)Sep 30, 2022 | (Q2)Jun 30, 2022 | (Q1)Mar 31, 2022 | (FY)Dec 31, 2021 | (Q4)Dec 31, 2021 | (Q3)Sep 30, 2021 | (Q2)Jun 30, 2021 | |
|---|---|---|---|---|---|---|---|---|---|---|
| Assets | ||||||||||
| Cash cash equivalents and federal funds sold | 69.66%13.16B | -66.92%4.28B | -66.92%4.28B | -54.95%5.53B | -20.82%6.24B | -12.75%7.76B | 154.11%12.95B | 154.11%12.95B | 232.67%12.28B | 154.16%7.88B |
| -Cash and cash equivalents | 69.66%13.16B | -66.92%4.28B | -66.92%4.28B | -54.95%5.53B | -20.82%6.24B | -12.75%7.76B | 154.11%12.95B | 154.11%12.95B | 232.67%12.28B | 154.16%7.88B |
| Receivables | ---- | 41.32%708M | 41.32%708M | ---- | ---- | 7.96%482M | 16.24%501M | 16.24%501M | 9.96%472.89M | 13.63%486.21M |
| -Accounts receivable | ---- | 41.32%708M | 41.32%708M | ---- | ---- | 9.64%331M | 16.24%501M | 16.24%501M | 0.59%309.23M | 11.41%300.07M |
| -Other receivables | ---- | ---- | ---- | ---- | ---- | 4.46%151M | ---- | ---- | 33.43%163.65M | 17.40%186.15M |
| Net loan | 22.68%172.51B | 23.70%166.08B | 23.70%166.08B | 23.72%158.01B | 23.11%150.79B | 19.71%140.61B | 19.93%134.26B | 19.93%134.26B | 22.57%127.71B | 22.80%122.48B |
| -Gross loan | 22.64%173.31B | 23.65%166.87B | 23.65%166.87B | 23.67%158.77B | 23.07%151.52B | 19.67%141.31B | 19.87%134.96B | 19.87%134.96B | 22.50%128.38B | 22.72%123.12B |
| -Allowance for loans and lease losses | 14.41%802M | 12.97%784M | 12.97%784M | 13.74%760M | 14.46%729M | 12.91%701M | 9.29%694M | 9.29%694M | 10.49%668.19M | 9.06%636.91M |
| Securities and investments | 14.85%36.22B | 22.96%33.1B | 22.96%33.1B | 29.71%32.9B | 34.61%32.48B | 38.24%31.53B | 36.92%26.92B | 36.92%26.92B | 28.40%25.37B | 19.36%24.12B |
| -Available for sale securities | 2.64%4.83B | 2.70%4.75B | 2.70%4.75B | 11.55%4.66B | 22.54%4.77B | 31.43%4.7B | 51.32%4.63B | 51.32%4.63B | 47.38%4.17B | 43.82%3.89B |
| -Held to maturity securities | 17.93%31.39B | 27.14%28.01B | 27.14%28.01B | 31.74%27.92B | 35.71%27.46B | 38.40%26.62B | 34.59%22.03B | 34.59%22.03B | 25.22%21.19B | 15.58%20.24B |
| -Short term investments | ---- | 29.77%340M | 29.77%340M | --328M | --247M | --214M | 11.49%262M | 11.49%262M | ---- | ---- |
| Federal home loan bank stock | ---- | 229.57%379M | 229.57%379M | ---- | ---- | -64.77%115M | -67.51%115M | -67.51%115M | -42.95%239.3M | -41.55%279.66M |
| Derivative assets | ---- | 156.76%95M | 156.76%95M | ---- | ---- | 14.56%62M | -54.32%37M | -54.32%37M | 2.90%34.52M | 90.11%40.77M |
| Bank owned life insurance | 50.60%4.04B | 29.62%3.44B | 29.62%3.44B | 29.72%3.41B | 28.58%3.34B | 15.16%2.68B | 28.58%2.65B | 28.58%2.65B | 34.81%2.63B | 76.86%2.6B |
| Net PPE | -74.07%488M | 7.67%1.92B | 7.67%1.92B | -73.10%483M | -73.31%474M | 6.79%1.88B | 31.81%1.79B | 31.81%1.79B | 36.10%1.8B | 37.08%1.78B |
| -Gross PPE | ---- | 11.58%2.79B | 11.58%2.79B | ---- | ---- | 6.79%1.88B | 28.81%2.5B | 28.81%2.5B | 36.10%1.8B | 37.08%1.78B |
| -Accumulated depreciation | ---- | -21.31%-871M | -21.31%-871M | ---- | ---- | ---- | -21.90%-718M | -21.90%-718M | ---- | ---- |
| Goodwill and other intangible assets | -18.22%193M | -3.78%229M | -3.78%229M | -9.21%219M | -10.31%220M | -5.38%236M | -6.30%238M | -6.30%238M | -6.34%241.23M | -6.62%245.3M |
| -Goodwill | ---- | 0.00%172M | 0.00%172M | 0.22%172M | 0.22%172M | 0.22%172M | 0.00%172M | 0.00%172M | 0.00%171.62M | 0.00%171.62M |
| -Other intangible assets | ---- | -13.64%57M | -13.64%57M | -32.48%47M | -34.86%48M | -17.73%64M | -19.51%66M | -19.51%66M | -19.01%69.61M | -19.10%73.68M |
| Other assets | 260.08%6.34B | 62.30%1.74B | 62.30%1.74B | 152.65%4.56B | 151.90%4.37B | 20.03%1.76B | 33.96%1.07B | 33.96%1.07B | 52.88%1.8B | 34.33%1.74B |
| Total assets | 24.49%232.94B | 17.42%212.64B | 17.42%212.64B | 18.86%205.11B | 22.43%197.91B | 20.10%187.12B | 27.08%181.09B | 27.08%181.09B | 29.53%172.57B | 25.99%161.65B |
| Liabilities | ||||||||||
| Total deposits | -35.53%104.47B | 12.87%176.44B | 12.87%176.44B | 18.62%172.38B | 23.01%165.65B | 26.70%162.06B | 36.02%156.32B | 36.02%156.32B | 39.20%145.33B | 36.66%134.66B |
| Federal funds purchased and securities sold under agreement to repurchase | --446M | ---- | ---- | ---- | ---- | ---- | ---- | ---- | ---- | ---- |
| Current debt and capital lease obligation | --2.58B | --6.7B | --6.7B | --5.1B | --6.3B | ---- | --0 | --0 | ---- | ---- |
| -Current debt | --2.58B | --6.7B | --6.7B | --5.1B | --6.3B | ---- | --0 | --0 | ---- | ---- |
| Long term debt and capital lease obligation | 380.18%26.3B | 56.64%8.58B | 56.64%8.58B | -24.24%7.18B | -44.52%5.98B | -55.39%5.48B | -59.52%5.48B | -59.52%5.48B | -37.98%9.48B | -37.27%10.78B |
| -Long term debt | 380.18%26.3B | 56.64%8.58B | 56.64%8.58B | -24.24%7.18B | -44.52%5.98B | -55.39%5.48B | -59.52%5.48B | -59.52%5.48B | -37.98%9.48B | -37.27%10.78B |
| Other liabilities | 2,266.72%81.16B | 2.54%3.48B | 2.54%3.48B | 12.24%3.33B | 21.01%3.56B | 28.47%3.43B | 47.88%3.39B | 47.88%3.39B | 35.19%2.97B | 46.18%2.94B |
| Total liabilities | 25.73%214.95B | 18.16%195.19B | 18.16%195.19B | 19.16%187.99B | 22.32%181.48B | 19.68%170.97B | 26.34%165.19B | 26.34%165.19B | 29.44%157.77B | 26.03%148.37B |
| Shareholders'equity | ||||||||||
| Share capital | 0.00%3.64B | 0.00%3.64B | 0.00%3.64B | 25.59%3.64B | 69.52%3.64B | 69.52%3.64B | 134.97%3.64B | 134.97%3.64B | 75.76%2.89B | 86.99%2.14B |
| -common stock | 0.00%2M | 0.00%2M | 0.00%2M | 11.54%2M | 13.19%2M | 13.44%2M | 0.00%2M | 0.00%2M | 4.12%1.79M | 2.67%1.77M |
| -Preferred stock | 0.00%3.63B | 0.00%3.63B | 0.00%3.63B | 25.60%3.63B | 69.57%3.63B | 69.57%3.63B | 135.15%3.63B | 135.15%3.63B | 75.84%2.89B | 87.12%2.14B |
| Paid-in capital | 14.26%6.59B | 9.28%6.26B | 9.28%6.26B | 9.58%6.23B | 11.10%5.78B | 11.00%5.76B | 18.41%5.73B | 18.41%5.73B | 24.37%5.69B | 14.55%5.2B |
| Retained earnings | 17.00%8.07B | 20.05%7.89B | 20.05%7.89B | 21.61%7.59B | 21.89%7.24B | 22.50%6.89B | 22.88%6.57B | 22.88%6.57B | 22.34%6.24B | 22.18%5.94B |
| Gains losses not affecting retained earnings | -115.33%-295M | -967.74%-331M | -967.74%-331M | -1,598.08%-337M | -2,087.95%-227M | -539.50%-137M | -234.78%-31M | -234.78%-31M | -182.15%-19.85M | -138.16%-10.38M |
| Total stockholders'equity | 11.37%17.99B | 9.74%17.45B | 9.74%17.45B | 15.65%17.12B | 23.74%16.43B | 24.82%16.15B | 35.29%15.9B | 35.29%15.9B | 30.47%14.8B | 25.52%13.27B |
| Total equity | 11.37%17.99B | 9.74%17.45B | 9.74%17.45B | 15.65%17.12B | 23.74%16.43B | 24.82%16.15B | 35.29%15.9B | 35.29%15.9B | 30.47%14.8B | 25.52%13.27B |
| Currency Unit | USD | USD | USD | USD | USD | USD | USD | USD | USD | USD |
| Accounting Standards | US-GAAP | US-GAAP | US-GAAP | US-GAAP | US-GAAP | US-GAAP | US-GAAP | US-GAAP | US-GAAP | US-GAAP |
| Audit Opinions | -- | Unqualified Opinion | -- | -- | -- | -- | Unqualified Opinion with Explanatory Notes | -- | -- | -- |