Terra Property Trust, Inc. (TPTS)

Import this data to Google Sheets with:

=jivedata("TPTS","financials")

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

Terra Property Trust, Inc.

TPTS • CIK 0001674356

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Interest and Dividend Income, Operating	$56,140.437	$38,250.784	$28,296.872	$16,884.52
Other Revenue (Expense) from Real Estate Operations	$11,050.716	$10,740.17	$6,802.853	$4,772.783
Prepayment Fees on Advances, Net	$0	$435.677	$0	$0
Operating Income (Loss)	$-24,484.25	$3,937.94	$-1,316.846	$-16,771.043
Other Operating Income	$722.881	$262.863	$339.295	$510.874
Revenues	$67,914.034	$49,689.494	$35,439.02	$22,168.177
Income (Loss) from Continuing Operations before Income Taxes, Noncontrolling Interest	—	—	$-27,393.244	$-35,161.808
Income Tax Expense (Benefit)	—	—	$432.602	$1,197.268
Net Income (Loss) Attributable to Parent	$-56,886.039	$-37,159.955	$-27,825.846	$-36,359.076
Comprehensive Income (Loss), Net of Tax, Attributable to Parent	—	$-37,345.43	$-27,640.371	$-36,401.722
Weighted Average Number of Shares Outstanding, Basic	24,335,545	24,336,834	24,338,825	24,340,343
Other General Expense	$9,234.357	$7,468.132	$4,035.222	$2,865.454
Management Fee Expense	$7,807.198	$6,207.231	$4,786.64	$3,824.748
Financing Receivable, Credit Loss, Expense (Reversal)	$45,548.803	$16,627.739	$12,767.592	$21,060.536
Other Expense from Real Estate Partnership Operations	$4,586.245	$2,673.913	$3,113.673	$1,754.465
Depreciation, Amortization and Accretion, Net	$6,968.985	$7,357.295	$3,841.661	$2,756.754
Professional Fees	$3,741.72	$3,012.046	$2,812.876	$4,334.241
Asset Impairment Charges	$11,765.54	$0	$3,399.684	$595.984
Noninterest Expense Directors Fees	$347.714	$356.886	$303.022	$275
Other Cost and Expense, Operating	$539.957	$558.638	$551.713	$571.556
Costs and Expenses	$92,398.284	$45,751.554	$36,755.866	$38,939.22
Interest Expense, Debt	$28,113.245	$25,052.058	$13,505.701	$9,386.491
Interest Expense, Other Long-term Debt	$9,643.974	$9,836.953	$9,913.012	$8,431.055
Income (Loss) from Equity Method Investments	$-2,383.938	$2,738.41	$3,283.274	$4,532.615
Gain (Loss) on Extinguishment of Debt	—	$0	$548.625	$668.243
Gains (Losses) on Sales of Other Real Estate	$-4,211.153	$0	$-2,880.545	$-1,409.669
Unrealized Gain (Loss) on Investments	$-316.573	$100.149	$39.29	$39.365
Realized Investment Gains (Losses)	$-459.279	$-446.009	$0	$0
Other Nonoperating Income (Expense)	$-32,401.789	$-41,097.895	$-26,076.398	$-18,390.765
Other Comprehensive Income (Loss), Available-for-sale Securities Adjustment, Net of Tax, Portion Attributable to Parent	—	$-185.475	$185.475	$-42.646

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Liabilities and Equity	$670,740.151	$542,819.059	$351,540.758	$249,606.385
Cash and Cash Equivalents, at Carrying Value	$10,674.475	$8,578.456	$33,172.814	$9,673.979
Restricted Cash and Cash Equivalents	$3,954.986	$2,937.959	$1,202.134	$730.885
Escrow Deposit	$4,907.316	$7,448.611	$3,519.393	$521.451
Marketable Securities	$4,961.879	$963.178	$0	$0
FinancingReceivableExcludingAccruedInterestAfterAllowanceForCreditLoss	$456,472.258	$274,649.145	$153,387.413	$87,285.342
Equity Method Investments	$37,171.326	$106,816.146	$94,218.842	$90,966.203
Interest Receivable	$6,537.368	$5,440.62	$8,252.234	$7,601.631
Other Assets	$9,466.846	$5,886.858	$7,130.874	$4,798.452
Preferred Stock, Value, Issued	—	$0	$0	$0
Additional Paid in Capital	$444,458.206	$444,478.936	$444,496.228	$444,497.891
Retained Earnings (Accumulated Deficit)	$-203,047.758	$-258,810.775	$-298,275.399	$-318,234.516
Accumulated Other Comprehensive Income (Loss), Net of Tax	—	$-185.475	$0	$0
Stockholders' Equity Attributable to Parent	$241,653.808	$185,726.066	$146,464.228	$126,506.776
Real Estate Investment Property, Net	$126,724.333	$123,597.789	$47,062.934	$46,330.324
Intangible Assets, Net (Excluding Goodwill)	$9,869.364	$5,641.03	$1,850.543	$283.334
Unsecured Debt	$118,380.897	$120,424.1	$117,949.074	$0
Secured Debt	$290,525.313	$205,718.782	$60,908.096	$111,420.891
Participating Mortgage Loans, Mortgage Obligations, Amount	$0	$18,177.106	$18,197.981	$0
Interest Payable	$1,575.463	$1,350.384	$654.465	$478.329
Accounts Payable and Accrued Liabilities, Current	$2,405.749	$2,189.486	$2,964.488	$6,507.128
Deferred Credits and Other Liabilities, Current	$314.26	$127.485	$151.622	$68.079
Liabilities	$429,086.343	$357,092.993	$205,076.53	$123,099.609
FinancingReceivableAllowanceForCreditLossExcludingAccruedInterest	$56,976.025	$46,141.455	$59,023.096	$848.67
Preferred Stock, Shares Authorized	50,000,000	50,000,000	50,000,000	50,000,000
Preferred Stock, Shares Issued	—	0	0	0
Common Stock, Shares Authorized	950,000,000	950,000,000	950,000,000	0
Common Stock, Shares, Issued	4,574,470.35	4,574,470.35	4,574,470.35	0

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$-16,932.815	$-571.751	$18,929.315	$-21,817.807
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$19,536.777	$18,965.026	$37,894.341	$26,548.226
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$-56,886.039	$-37,159.955	$-27,825.846	$-36,359.076
Net Cash Provided by (Used in) Operating Activities	$8,609.998	$-3,258.119	$1,913.799	$-1,203.19
Proceeds from Loan and Lease Originations and Principal Collections	$126,142.565	$215,137.53	$136,445.087	$73,251.196
Payments to Acquire Loans Held-for-investment	$78,883.295	$57,163.87	$29,632.403	$17,046.343
Proceeds from Sale of Real Estate Held-for-investment	—	—	$69,123.333	$85,680.757
Payments to Develop Real Estate Assets	—	—	$118.189	$118.189
Payments to Acquire Equity Method Investments	$7,307.806	$65,617.196	$1,914.977	$3,935.806
Proceeds from Equity Method Investment, Distribution, Return of Capital	$0	$3,076.908	$5,503.845	$14,336.285
Proceeds from Collection of Notes Receivable	$0	$9,624.408	$1,182.759	$0
Payments to Acquire Notes Receivable	—	$4,962.369	$0	$0
Payments to Acquire Other Investments	—	$2,002.353	$0	$0
ProceedsFromSaleOfEquitySecuritiesFvNi	—	—	$0	$0
Net Cash Provided by (Used in) Investing Activities	$-10,041.784	$101,644.156	$180,589.455	$152,167.9
Repayments of Secured Debt	$205,265.764	$177,525.167	$170,854.544	$114,245.354
Proceeds from (Repayments of) Secured Debt	$211,017.859	$81,284.441	$24,805.321	$38,672.064
Proceeds from Related Party Debt	$1,494.422	$18,000	$2,611.678	$1,004.874
Repayments of Related Party Debt	$0	—	$2,591.102	$20,611.678
Repayments of Unsecured Debt	—	—	$4,188	$70,097.507
Payments of Ordinary Dividends, Common Stock	$18,597.604	$18,582.312	$11,621.467	$5,617.584
Payments of Financing Costs	$3,346.724	$1,117.723	$0	$1,379.486
Increase (Decrease) in Other Deposits	$-678.218	$-1,017.027	$-1,735.825	$-507.846
Net Cash Provided by (Used in) Financing Activities	$-15,501.029	$-98,957.788	$-163,573.939	$-172,782.517
Interest Paid, Excluding Capitalized Interest, Operating Activities	$34,435.541	$33,610.601	$24,069.122	$19,468.656
Stock Issued During Period, Value, Dividend Reinvestment Plan	$8.399	$20.75	$17.311	$9.688
Cost, Depreciation and Amortization	$6,968.985	$7,357.295	$3,841.661	$2,756.754
Financing Receivable, Credit Loss, Expense (Reversal)	$45,548.803	$16,627.739	$12,767.592	$21,060.536
Asset Impairment Charges	$11,765.54	$0	$3,399.684	$595.984
Gains (Losses) on Sales of Other Real Estate	$-4,211.153	$0	$-2,880.545	$-1,409.669
Gain (Loss) on Extinguishment of Debt	—	$0	$548.625	$668.243
Investment Income, Net, Amortization of Discount and Premium	$-1,124.157	$-155.727	$-6.913	$0
Straight Line Rent Adjustments	$-63.974	$-200.926	$-81.819	$-5.301
Amortization of Debt Issuance Costs	$2,485.026	—	—	$2,928.03
Amortization of Debt Discount (Premium)	$1,672.197	$1,850.642	$2,052.078	$1,756.033
Amortization of above and below Market Leases	$-2,135.162	$-2,936.459	$-1,150.39	$-698.28
Accretion (Amortization) of Discounts and Premiums, Investments	$896.615	$578.756	$-532.517	$-1,411.671
Realized Investment Gains (Losses)	$-459.279	$-446.009	$0	$0
Unrealized Gain (Loss) on Investments	$-316.573	$100.149	$39.29	$39.365
Proceeds from Equity Method Investment, Distribution	$7,008.461	$5,633.878	$12,291.711	$10,286.216
Increase (Decrease) in Accrued Interest Receivable, Net	$2,893.517	$-1,096.748	$2,811.614	$781.554
Increase (Decrease) in Due from Related Parties	$0	$204.004	$884.31	$229.78
Increase (Decrease) in Other Operating Assets	$6,860.178	$-1,379.815	$1,157.017	$-1,567.755
Increase (Decrease) in Due to Related Parties	$1,509.673	$-1,474.903	$-34.771	$578.668
Increase (Decrease) in Deferred Revenue	$-63.758	$-186.775	$24.137	$-209.627
Increase (Decrease) in Interest Payable, Net	$517.462	$-225.079	$-695.919	$-823.5
Increase (Decrease) in Accounts Payable and Accrued Liabilities	$1,121.931	$-216.263	$775.002	$-1,889.199
Increase (Decrease) in Other Operating Liabilities	$-548.471	$-62.894	$213.073	$1,789.934
Debt Instrument, Face Amount	$416,913.757	$349,093.942	—	—

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("TPTS","financials")

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