United States 12 Month Natural Gas Fund, LP (UNL)

Import this data to Google Sheets with:

=jivedata("UNL","financials")

Full statements spill as a table. For one cell: =jivedata("UNL","Revenue") or =jivedata("UNL","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.

United States 12 Month Natural Gas Fund, LP

UNL • CIK 0001405513

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Gain (Loss) on Sale of Derivatives	$-17,944.426	$-7,409.144	$1,855.894	$-2,841.764
Unrealized Gain (Loss) on Derivatives	$3,969.335	$5,565.625	$-3,186.175	$-1,989.366
Dividend Income, Operating	$723.226	$557.193	$334.568	$354.293
Interest Income, Operating	$122.232	$349.752	$251.803	$205.255
Revenue from Contract with Customer, Including Assessed Tax	$6.65	$11.2	$8.05	$7
Revenues	$-13,122.983	$-925.374	$-735.86	$-4,264.582
Net Income (Loss) Attributable to Parent	$-13,280.208	$-1,219.474	$-971.479	$-4,538.389
Weighted Average Limited Partnership Units Outstanding, Basic	1,542,877	2,316,940	1,669,726	2,465,582
Management Fee Expense	$131.022	$117.177	$85.928	$90.456
Professional Fees	$168.584	$235.573	$132.85	$164.579
Floor Brokerage, Exchange and Clearance Fees	$5.945	$8.179	$4.465	$4.933
Noninterest Expense Directors Fees	$17.277	$9.867	$7.144	$11.579
Operating Expenses	$325.448	$375.082	$235.619	$273.807

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$-13,280.208	$-1,219.474	$-971.479	$-4,538.389
Net Cash Provided by (Used in) Operating Activities	$-17,249.846	$-6,326.373	$1,951.548	$-2,554.46
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$-12,665.622	$-2,730.728	$2,961.435	$7,095.689
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$20,591.178	$17,860.45	$20,821.885	$22,984.619
Unrealized Gain (Loss) on Derivatives and Commodity Contracts	$3,969.335	$5,565.625	$-3,186.175	$-1,989.366
Proceeds from Partnership Contribution	$14,459.823	$21,720.123	$11,952.063	$16,060.328
Increase (Decrease) Due from Officers and Stockholders	$4.647	$-168.223	$-168.223	$-168.223
Increase (Decrease) in Dividends Receivable	$-40.062	$-11.949	$-16.592	$18.798
Net Cash Provided by (Used in) Financing Activities	$4,584.224	$3,595.645	$1,009.887	$9,650.149
Increase (Decrease) in Accrued Interest Receivable, Net	$10.229	$9.29	$8.483	$-10.323
Increase (Decrease) in Prepaid Insurance	$1.361	$-1.587	$2.437	$-2.938
Increase (Decrease) in Payables to Broker-Dealers and Clearing Organizations	—	$230.776	$-230.776	$-230.776
IncreaseDecreaseInProfessionalFeePayable	—	—	$-40.647	$-40.647
Cash and Cash Equivalents, at Carrying Value	$14,477.947	$17,860.45	$18,161.325	$17,586.401

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("UNL","financials")

Full statements spill as a table. For one cell: =jivedata("UNL","Revenue") or =jivedata("UNL","Revenue","TTM"). Install the Jive Data add-on, then paste into a cell.