SUN COMMUNITIES, INC (SUI)

Import this data to Google Sheets with:

=jivedata("SUI","financials")

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

SUN COMMUNITIES, INC

SUI • CIK 0000912593

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Lease Income	$2,059,800	$2,163,400	$1,765,800	$1,798,600
Interest Income, Operating	$45,400	$20,700	$48,500	$51,500
Equity Securities, FV-NI, Realized Gain (Loss)	$-16,000	$0	$0	$0
Foreign Currency Transaction Gain (Loss), before Tax	$-300	$-25,800	$26,700	$-6,500
Revenues	$3,224,600	$3,221,100	$2,306,100	$2,343,800
Gain (Loss) on Sale of Properties	$11,000	$202,900	$5,100	$6,400
Other Nonoperating Income (Expense)	$-7,500	$3,200	$133,900	$124,400
Income (Loss) from Equity Method Investments	$16,000	$9,500	$16,400	$19,500
Current Income Tax Expense (Benefit)	$14,500	$4,300	$10,800	$10,600
Deferred Income Tax Expense (Benefit)	$-22,900	$-39,600	$-60,000	$-48,400
Income (Loss) from Continuing Operations, Net of Tax, Including Portion Attributable to Noncontrolling Interest	—	—	$600	$17,400
Income (Loss) from Discontinued Operations, Net of Tax, Including Portion Attributable to Noncontrolling Interest	—	—	$1,429,600	$1,429,600
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$-209,100	$107,100	$1,430,200	$1,465,500
Preferred Stock Dividends, Income Statement Impact	$12,300	$12,800	$12,600	$12,200
Net Income (Loss) Attributable to Noncontrolling Interest	$-8,100	$5,300	$56,400	$58,000
Net Income (Loss) Available to Common Stockholders, Basic	$-213,300	$89,000	$1,361,200	$1,395,300
Cost of Other Property Operating Expense	$690,500	$732,300	$595,900	$605,400
Real Estate Tax Expense	$117,400	$125,700	$111,100	$113,900
Other Cost of Operating Revenue	$585,000	$570,700	$106,000	$107,300
General and Administrative Expense	$270,200	$295,300	$236,700	$249,200
Business Combination, Integration Related Costs	$3,000	$400	$0	$0
Depreciation, Depletion and Amortization	$660,000	$680,700	$507,900	$516,700
Other Asset Impairment Charges	$10,100	$71,400	$386,700	$363,000
Goodwill, Impairment Loss	$369,900	$180,800	$0	$0
Gain (Loss) on Extinguishment of Debt	$0	$-1,400	$-104,000	$-104,000
Interest Expense, Debt	$325,800	$350,400	$221,000	$177,300
Interest Expense, Other	$3,300	$0	$0	$0
Costs and Expenses	$3,334,400	$3,309,300	$2,534,300	$2,506,000
Weighted Average Number of Shares Outstanding, Basic	123,400,000	124,500,000	124,900,000	120,900,000
Weighted Average Number of Shares Outstanding, Diluted	123,800,000	127,200,000	124,900,000	120,600,000
Net Income (Loss) from Continuing Operations Available to Common Shareholders, Basic	—	—	$-68,400	$-52,800
Net Income (Loss) Available to Common Stockholders, Diluted	$-213,300	$89,800	$1,353,500	$1,388,600
Incremental Common Shares Attributable to Dilutive Effect of Share-based Payment Arrangements	400,000	0	0	0

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Land	$4,278,200	$4,511,000	$3,503,200	$3,489,200
Rental Properties	$744,400	$834,100	$940,200	$967,200
Furniture and Fixtures, Gross	$1,011,700	$1,108,400	$769,800	$763,400
Temporary Equity, Carrying Amount, Including Portion Attributable to Noncontrolling Interests	$260,900	$259,800	$255,700	$196,800
Real Estate Investment Property, at Cost	$17,716,500	$17,914,100	$14,500,000	$14,564,800
Real Estate Investment Property, Accumulated Depreciation	$3,272,900	$3,741,000	$3,598,300	$3,693,300
Liabilities and Equity	$16,940,700	$16,549,400	$12,522,900	$12,358,800
Real Estate Investment Property, Net	$14,443,600	$14,173,100	$10,901,700	$10,871,500
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$42,700	$63,900	$636,100	$497,000
Inventory, Finished Homes	$205,600	$129,800	$142,900	$132,800
Transfers Accounted for as Secured Borrowings, Assets, Carrying Amount	$56,200	$51,200	$43,200	$41,600
Goodwill	$733,000	$551,200	$9,500	$9,500
Intangible Assets, Net (Excluding Goodwill)	$369,500	$338,900	$101,500	$97,800
Other Assets	$668,500	$757,300	$355,900	$375,500
Disposal Group, Including Discontinued Operation, Assets	—	—	$0	$0
Loans Payable	$3,478,900	$3,212,200	$2,429,000	$2,417,500
Transfers Accounted for as Secured Borrowings, Associated Liabilities, Carrying Amount	$55,800	$51,200	$43,200	$41,600
Dividends Payable	$118,200	$122,600	$131,100	$140,900
Contract with Customer, Liability	$344,500	$331,000	$255,900	$327,000
Accounts Payable and Accrued Liabilities	$313,700	$310,100	$228,100	$256,900
Other Liabilities	$953,100	$980,300	$320,600	$328,100
Liabilities	$9,506,800	$9,096,800	$5,194,400	$5,299,100
Common Stock, Value, Issued	$1,200	$1,300	$1,200	$1,200
Additional Paid in Capital	$9,466,900	$9,864,200	$9,563,100	$9,543,100
Accumulated Other Comprehensive Income (Loss), Net of Tax	$12,200	$-7,900	$26,500	$11,800
Accumulated Distributions in Excess of Net Income	$2,397,500	$2,775,900	$2,634,700	$2,802,600
Stockholders' Equity Attributable to Parent	$7,082,800	$7,081,700	$6,956,100	$6,753,500
Stockholders' Equity, Including Portion Attributable to Noncontrolling Interest	$7,173,000	$7,192,800	$7,072,800	$6,862,900
Noncontrolling Interest in Operating Partnerships	$90,200	$110,400	$116,300	$109,100
Noncontrolling Interest in Variable Interest Entity	—	$700	$400	$400
Stockholders' Equity Attributable to Noncontrolling Interest	$90,200	$111,100	$116,700	$109,400
Notes Receivable, Fair Value Disclosure	$305,200	—	—	$305,200
Common Stock, Shares Authorized	360,000,000	360,000,000	360,000,000	360,000,000
Common Stock, Shares, Issued	124,436,432	127,436,693	123,486,747	123,254,249

(in thousands, except per share data)	FY 2023	FY 2024	FY 2025	TTM
Effect of Exchange Rate on Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$1,000	$-800	$1,600	$1,600
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Period Increase (Decrease), Including Exchange Rate Effect	$-47,700	$21,200	$572,200	$386,900
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Including Disposal Group and Discontinued Operations	—	—	$636,100	$1,023,000
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents, Disposal Group, Including Discontinued Operations	—	—	$0	$-12,700
Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents	$42,700	$63,900	$636,100	$1,035,700
Income (Loss) from Continuing Operations, Net of Tax, Including Portion Attributable to Noncontrolling Interest	—	—	$600	$17,400
Income (Loss) from Discontinued Operations, Net of Tax, Including Portion Attributable to Noncontrolling Interest	—	—	$1,429,600	$1,429,600
Net Income (Loss), Including Portion Attributable to Noncontrolling Interest	$-209,100	$107,100	$1,430,200	$1,465,500
Payments to Acquire Businesses, Net of Cash Acquired	$53,300	$68,800	$461,700	$499,700
Proceeds from Insurance Settlement, Investing Activities	$10,800	$6,600	$43,700	$43,700
Proceeds from Sale of Property, Plant, and Equipment	$62,300	$21,700	$16,900	$16,900
Proceeds from Sale of Real Estate Held-for-investment	$9,900	$421,800	$161,900	$78,200
ProceedsFromSaleOfEquitySecuritiesFvNi	$103,600	$0	$0	$0
Payments to Acquire Interest in Subsidiaries and Affiliates	$39,500	$22,400	$900	$900
Payments for (Proceeds from) Other Investing Activities	—	—	$-11,500	$-9,900
Net Cash Provided by (Used in) Investing Activities, Continuing Operations	—	—	$-602,900	$-762,700
Cash Provided by (Used in) Investing Activities, Discontinued Operations	—	—	$5,528,700	$5,575,700
Net Cash Provided by (Used in) Investing Activities	$-919,500	$-267,400	$4,925,800	$4,813,000
Payment, Tax Withholding, Share-based Payment Arrangement	$12,800	$9,800	$12,100	$12,300
Payments for Repurchase of Common Stock	—	—	$539,100	$599,200
Proceeds from Lines of Credit	$1,635,000	$2,630,700	$624,500	$268,200
Repayments of Lines of Credit	$1,775,600	$3,286,300	$2,106,500	$1,778,700
Proceeds from Issuance of Secured Debt	$53,400	$0	$0	$0
Proceeds from Issuance of Other Long-term Debt	$835,700	$499,800	$0	$0
Repayments of Long-term Debt	$174,300	$269,200	$2,093,300	$2,043,700
Payments of Ordinary Dividends	$476,400	$492,700	$1,044,300	$1,052,900
Proceeds from (Payments for) Other Financing Activities	—	$0	$-15,300	$-15,300
Net Cash Provided by (Used in) Financing Activities, Continuing Operations	—	—	$372,200	$223,900
Cash Provided by (Used in) Financing Activities, Discontinued Operations	—	—	$-5,591,600	$-5,539,900
Net Cash Provided by (Used in) Financing Activities	$80,300	$-571,600	$-5,219,400	$-5,316,000
Interest Paid, Excluding Capitalized Interest, Operating Activities	$326,700	$342,200	$245,900	$189,100
Increase (Decrease) in Notes Receivables	$7,900	$47,700	$33,900	$33,900
Noncash or Part Noncash Acquisition, Fixed Assets Acquired	$159,200	$0	$0	$0
Noncash or Part Noncash Acquisition, Other Assets Acquired	$27,500	$0	$0	$0
Temporary Equity, Stock Issued During Period, Value, New Issues	—	—	$3,400	$3,400
Gain (Loss) on Disposition of Assets	$9,100	$10,700	$14,900	$14,900
Gain (Loss) on Sale of Properties	$11,000	$202,900	$5,100	$6,400
ForeignCurrencyTransactionGainLossAfterTax	$-300	$-25,800	$26,700	$26,700
Other Asset Impairment Charges	$10,100	$71,400	$386,700	$363,000
Impairment of Real Estate	$-700	$5,100	$1,200	$1,200
Goodwill, Impairment Loss	$369,900	$180,800	$0	$0
Share-based Payment Arrangement, Noncash Expense	$42,900	$41,600	$37,400	$37,400
Depreciation, Amortization and Accretion, Net	$642,000	$667,100	$507,900	$507,900
Deferred Income Tax Expense (Benefit)	$-22,900	$-39,600	$-60,000	$-48,400
Gain (Loss) on Extinguishment of Debt	$0	$-1,400	$-104,000	$-104,000
Insured Event, Gain (Loss)	—	—	$30,800	$30,800
Other Operating Activities, Cash Flow Statement	—	$-2,700	$-29,900	$-29,900
Increase (Decrease) in Other Operating Assets	$110,300	$-31,700	$-146,300	$-146,300
Increase (Decrease) in Other Operating Liabilities	$-26,200	$26,500	$-124,600	$-124,600
Net Cash Provided by (Used in) Operating Activities, Continuing Operations	—	—	$808,000	$938,000
Cash Provided by (Used in) Operating Activities, Discontinued Operations	—	—	$56,200	$-48,400
Net Cash Provided by (Used in) Operating Activities	$790,500	$861,000	$864,200	$889,600
Interest Paid, Capitalized, Investing Activities	$12,900	$8,600	$3,500	$2,300

Loading financial statements…

Import this data to Google Sheets with:

=jivedata("SUI","financials")

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