Document And Entity Information
Document And Entity Information | 3 Months Ended |
Mar. 31, 2023 shares | |
Document Information Line Items | |
Entity Registrant Name | AEI INCOME & GROWTH FUND 26 LLC |
Document Type | 10-Q |
Current Fiscal Year End Date | --12-31 |
Entity Common Stock, Shares Outstanding | 1,667,943.47 |
Amendment Flag | false |
Entity Central Index Key | 0001326321 |
Entity Current Reporting Status | Yes |
Entity Filer Category | Non-accelerated Filer |
Document Period End Date | Mar. 31, 2023 |
Document Fiscal Year Focus | 2023 |
Document Fiscal Period Focus | Q1 |
Entity Small Business | true |
Entity Emerging Growth Company | false |
Entity Shell Company | false |
Document Quarterly Report | true |
Entity File Number | 000-51823 |
Entity Incorporation, State or Country Code | DE |
Entity Tax Identification Number | 41-2173048 |
Entity Address, Address Line One | 30 East 7th Street, Suite 1300 |
Entity Address, City or Town | St. Paul |
Entity Address, State or Province | MN |
Entity Address, Postal Zip Code | 55101 |
City Area Code | 651 |
Local Phone Number | 227-7333 |
Entity Information, Former Legal or Registered Name | Not Applicable |
No Trading Symbol Flag | true |
Security Exchange Name | NONE |
Title of 12(g) Security | Limited Liability Company Units |
Entity Interactive Data Current | Yes |
Document Transition Report | false |
Balance Sheet
Balance Sheet - USD ($) | Mar. 31, 2023 | Dec. 31, 2022 |
Current Assets: | ||
Cash | $ 2,248,419 | $ 1,368,226 |
Rent Receivable | 1,281 | 0 |
Total Current Assets | 2,249,700 | 1,368,226 |
Real Estate Investments: | ||
Land | 305,728 | 344,008 |
Buildings | 742,388 | 836,108 |
Real Estate Held for Investment, at Cost | 1,048,116 | 1,180,116 |
Accumulated Depreciation and Amortization | (533,821) | (524,396) |
Real Estate Held for Investment, Net | 514,295 | 655,720 |
Real Estate Held for Sale | 970,536 | 1,894,393 |
Total Real Estate Investments | 1,484,831 | 2,550,113 |
Total Assets | 3,734,531 | 3,918,339 |
Current Liabilities: | ||
Payable to AEI Fund Management, Inc. | 81,590 | 82,012 |
Distributions Payable | 59,175 | 59,176 |
Unearned Rent | 8,856 | 11,946 |
Total Current Liabilities | 149,621 | 153,134 |
Members’ Equity: | ||
Managing Members | 17,521 | 20,789 |
Limited Members – 10,000,000 Units authorized; 1,669,943.5 Units issued and outstanding as of 3/31/2023 and 12/31/2022 | 3,567,389 | 3,744,416 |
Total Members’ Equity | 3,584,910 | 3,765,205 |
Total Liabilities and Members’ Equity | $ 3,734,531 | $ 3,918,339 |
Balance Sheet (Parentheticals)
Balance Sheet (Parentheticals) - Limited Partner [Member] - shares | Mar. 31, 2023 | Dec. 31, 2022 |
Limited Members, units authorized | 10,000,000 | 10,000,000 |
Limited Members, units issued | 1,669,943.5 | 1,669,943.5 |
Limited Members, units outstanding | 1,669,943.5 | 1,669,943.5 |
Statement of Operations
Statement of Operations - USD ($) | 3 Months Ended | |
Mar. 31, 2023 | Mar. 31, 2022 | |
Income Statement [Abstract] | ||
Rental Income | $ 40,811 | $ 132,647 |
Expenses: | ||
LLC Administration – Affiliates | 22,487 | 28,099 |
LLC Administration and Property Management – Unrelated Parties | 29,686 | 26,436 |
Depreciation and Amortization | 12,741 | 72,092 |
Real Estate Impairment | 132,000 | 0 |
Total Expenses | 196,914 | 126,627 |
Operating Income (Loss) | (156,103) | 6,020 |
Other Income: | ||
Gain on Sale of Real Estate | 24,945 | 0 |
Interest Income | 10,038 | 198 |
Total Other Income | 34,983 | 198 |
Net Income (Loss) | (121,120) | 6,218 |
Net Income (Loss) Allocated: | ||
Managing Members | (1,493) | 187 |
Limited Members | (119,627) | 6,031 |
Net Income | $ (121,120) | $ 6,218 |
Net Income (Loss) per LLC Unit (in Dollars per share) | $ (0.07) | $ 0 |
Weighted Average Units Outstanding – Basic and Diluted (in Shares) | 1,669,943 | 1,678,443 |
Statement of Cash Flows
Statement of Cash Flows - USD ($) | 3 Months Ended | |
Mar. 31, 2023 | Mar. 31, 2022 | |
Cash Flows from Operating Activities: | ||
Net Income (Loss) | $ (121,120) | $ 6,218 |
Adjustments to Reconcile Net Income To Net Cash Provided by Operating Activities: | ||
Depreciation and Amortization | 12,741 | 73,986 |
Real Estate Impairment | 132,000 | 0 |
Gain on Sale of Real Estate | (24,945) | 0 |
(Increase) Decrease in Rent Receivable | (1,281) | 1,613 |
Increase (Decrease) in Payable to AEI Fund Management, Inc. | (422) | (1,584) |
Increase (Decrease) in Unearned Rent | (3,090) | 0 |
Total Adjustments | 115,003 | 74,015 |
Net Cash Provided By (Used For) Operating Activities | (6,117) | 80,233 |
Cash Flows from Investing Activities: | ||
Proceeds from Sale of Real Estate | 945,486 | 0 |
Cash Flows from Financing Activities: | ||
Distributions Paid to Members | (59,176) | (2,113,089) |
Net Increase (Decrease) in Cash | 880,193 | (2,032,856) |
Cash, beginning of period | 1,368,226 | 2,790,915 |
Cash, end of period | $ 2,248,419 | $ 758,059 |
Statement of Changes in Members
Statement of Changes in Members' Equity - USD ($) | General Partner [Member] | Limited Partner [Member] | Total |
Balance at Dec. 31, 2021 | $ 0 | $ 6,539,037 | $ 6,539,037 |
Balance (in Shares) at Dec. 31, 2021 | 1,678,443.2 | ||
Distributions Declared | (2,787) | $ (90,100) | (92,887) |
Net Income | 187 | 6,031 | 6,218 |
Balance at Mar. 31, 2022 | (2,600) | $ 6,454,968 | 6,452,368 |
Balance (in Shares) at Mar. 31, 2022 | 1,678,443.2 | ||
Balance at Dec. 31, 2022 | 3,765,205 | ||
Balance (in Shares) at Dec. 31, 2022 | 1,669,943.5 | ||
Distributions Declared | (1,775) | $ (57,400) | (59,175) |
Net Income | (1,493) | (119,627) | (121,120) |
Balance at Mar. 31, 2023 | $ 17,521 | $ 3,567,389 | $ 3,584,910 |
Balance (in Shares) at Mar. 31, 2023 | 1,669,943.5 |
Basis of Accounting
Basis of Accounting | 3 Months Ended |
Mar. 31, 2023 | |
Accounting Policies [Abstract] | |
Basis of Accounting [Text Block] | (1) The condensed statements included herein have been prepared by the registrant, without audit, pursuant to the rules and regulations of the Securities and Exchange Commission, and reflect all adjustments which are, in the opinion of management, necessary to a fair statement of the results of operations for the interim period, on a basis consistent with the annual audited statements. The adjustments made to these condensed statements consist only of normal recurring adjustments. Certain information, accounting policies, and footnote disclosures normally included in financial statements prepared in accordance with United States Generally Accepted Accounting Principles (US GAAP) have been condensed or omitted pursuant to such rules and regulations, although the registrant believes that the disclosures are adequate to make the information presented not misleading. It is suggested that these condensed financial statements be read in conjunction with the financial statements and the summary of significant accounting policies and notes thereto included in the registrant’s latest annual report on Form 10‑K. |
Organization
Organization | 3 Months Ended |
Mar. 31, 2023 | |
Accounting Policies [Abstract] | |
Organization, Consolidation, Basis of Presentation, Business Description and Accounting Policies [Text Block] | (2) Organization – AEI Income & Growth Fund 26 LLC (“Company”), a Limited Liability Company, was formed on March 14, 2005 to acquire and lease commercial properties to operating tenants. The Company's operations are managed by AEI Fund Management XXI, Inc. (“AFM”), the Managing Member. Robert P. Johnson, the previous Chief Executive Officer and sole director of AFM, served as the Special Managing Member until his withdrawal date effective March 31, 2020. AFM is a wholly owned subsidiary of AEI Capital Corporation of which the Robert P. Johnson Trust and Patricia Johnson own a majority interest. AEI Fund Management, Inc. (“AEI”), an affiliate of AFM, performs the administrative and operating functions for the Company. In August 2021, the Managing Member mailed a Consent Statement (Proxy) seeking the consent of the Limited Members, as required by Section 6.1 of the Operating Agreement, to initiate the final disposition, liquidation and distribution of all of the Company’s properties and assets within the next 12 to 24 months. On October 12, 2021, the proposal was approved with a majority of Units voting in favor of the proposal. As a result, the Managing Member is proceeding with the planned liquidation of the Company. |
Recently Issued Accounting Pron
Recently Issued Accounting Pronouncements | 3 Months Ended |
Mar. 31, 2023 | |
Accounting Policies [Abstract] | |
New Accounting Pronouncements, Policy [Policy Text Block] | (3) Recently Adopted Accounting Pronouncements – Effective January 1, 2023, the Company adopted the Financial Accounting Standards Board (FASB) Accounting Standards Update (ASU) No. 2016-13, Financial Instruments - Credit Losses (Topic 326). This guidance changes the methodology to be used to measure credit losses for certain financial instruments and financial assets, including receivables. The new methodology requires the recognition of an allowance that reflects the current estimate of credit losses expected to be incurred over the life of the financial assets. The adoption of the guidance did not have a material impact on the Company's financial statements. Other accounting standards that have been issued or proposed by the FASB are currently not applicable to the Company or are expected to have a significant impact on the Company's financial position, results of operations, and cash flows. |
Real Estate Investments
Real Estate Investments | 3 Months Ended |
Mar. 31, 2023 | |
Real Estate [Abstract] | |
Real Estate Disclosure [Text Block] | (4) Real Estate Investments – The Company owned a 40% interest in a former Sports Authority store in Wichita, Kansas. On March 2, 2016, the tenant, TSA Stores, Inc., and its parent company, The Sports Authority, Inc., the guarantor of the lease, filed for Chapter 11 bankruptcy reorganization. In June 2016, the tenant filed a motion with the bankruptcy court to reject the lease for this store effective June 30, 2016, at which time the tenant returned possession of the property to the owners. As of December 31, 2020, the tenant owed $19,366 of past due rent, which was not recorded for financial reporting purposes. On March 23, 2021, a motion to dismiss the bankruptcy case was issued by a federal judge to The Sports Authority, Inc., the Company will therefore not be receiving any of the past due rent. The owners listed the property for lease with a real estate broker in the Wichita area. While the property was vacant, the Company was responsible for its 40% share of real estate taxes and other costs associated with maintaining the property. On September 21, 2017, the Company entered into a lease agreement with a primary term of 10 years with Biomat USA, Inc. (“Biomat”) as a replacement tenant for 28% of the square footage of the property. The tenant operates a Biomat USA Plasma Center in the space. The Company’s 40% share of annual rent, which commenced on June 18, 2018, is $37,071. Biomat agreed to pay for the costs to divide the building into two separate spaces, the costs of tenant improvements to remodel the Biomat space and 28% of the cost to replace the roof. On August 27, 2019, the Company entered into a lease agreement with a primary term of 10 years with BigTime Fun Center, LLC as a replacement tenant for 57% of the square footage of the property. The tenant was to operate an indoor sports entertainment center in the space. The Company’s 40% share of annual rent, which was to commence on February 23, 2020, was $78,000. As part of the agreement, the Company would pay a tenant improvement allowance of $64,000 when certain conditions were met by the tenant. Due to ongoing difficulties due to the COVID-19 Pandemic the Company was negotiating a rent commencement date of April 1, 2021. As a part of the negotiations the tenant improvement allowance was to be replaced with a ten month rent abatement starting April 1, 2021. Additionally, this agreement would forebear rent and additional charges for the period from February 23, 2020 to March 31, 2021. In September 2019, the Company paid $32,760 to a real estate broker for its 40% share of the lease commission due as part of the lease transaction. This amount was capitalized and was to be amortized over the term of the lease. On January 22, 2021 the owner of Big Time Fund Center, LLC informed the Company that it did not intend to open the Wichita property. As a result of the tenant informing the Company of their intention not to open, the full amount of the lease commission was amortized in the fourth quarter of 2020. In September 2022, the Company entered into an agreement to sell its 40% interest in the Biomat Clinic in Wichita, Kansas to an unrelated third party. The property was classified as real estate held for sale at December 31, 2022. On February 9, 2023, the sale closed with the Company receiving net proceeds of $945,486, which resulted in a gain of $24,945. At the time of the sale, the cost and related accumulated depreciation and amortization was $1,871,978 and $951,437, respectively. In January 2023, the Company entered into an agreement to sell its 54% interest in the Fresenius clinic in Chicago, Illinois to an unrelated third party. On May 8, 2023, the sale closed with the Company receiving net proceeds of approximately $1,677,402, which resulted in a net gain of approximately $707,000. At the time of the sale, the cost and related accumulated depreciation was $1,292,220 and $321,684, respectively. The property was classified as real estate held for sale on the balance sheet as of March 31, 2023. In April 2022, the Company entered into an agreement with the tenant of the Fresenius Medical Care in Chicago, Illinois to extend the lease term five years to end on April 30, 2032. As part of the agreement, the annual rent will continue to increase annually at 2.5%. In March 2023, the Company performed a long-lived asset valuation analysis and determined The Cellular Connection store in Bluffton, Indiana was impaired. As a result, in the first quarter of 2023, a charge to operations for real estate impairment of $132,000 was recognized, which was the difference between the carrying value at March 31, 2023 of approximately $640,000 and the estimated fair value of $508,000. The charge was recorded against the land and building in the amount of $38,280 and $93,720, respectively. In May 2023, the Company entered into an agreement to sell its interest in The Cellular Connection store in Bluffton, Indiana to an unrelated third party. The sale is subject to contingencies and may not be completed. If the sale is completed, the Company expects to receive net sale proceeds of approximately $508,000, which will result in no gain or loss. |
Payable to AEI Fund Management,
Payable to AEI Fund Management, Inc. | 3 Months Ended |
Mar. 31, 2023 | |
Payables and Accruals [Abstract] | |
Accounts Payable and Accrued Liabilities Disclosure [Text Block] | (5) Payable to AEI Fund Management, Inc. – AEI Fund Management, Inc. performs the administrative and operating functions for the Company. The payable to AEI Fund Management represents the balance due for those services. This balance is non-interest bearing and unsecured and is to be paid in the normal course of business. |
Members' Equity
Members' Equity | 3 Months Ended |
Mar. 31, 2023 | |
Disclosure Text Block Supplement [Abstract] | |
Members' Equity Notes Disclosure [Text Block] | (6) Members’ Equity – For the three months ended March 31, 2023 and 2022, the Company declared distributions of $59,175 and $92,887, respectively. The Limited Members were allocated distributions of $57,400 and $90,100 and the Managing Members were allocated distributions of $1,775 and $2,787 for the periods ended March 31, 2023 and 2022, respectively. The Limited Members' distributions represented $0.03 and $0.05 per LLC Unit outstanding using 1,669,943 and 1,678,443 weighted average Units in 2023 and 2022, respectively. The distributions represented $0.00 and $0.00 per Unit of Net Income and $0.00 and $0.05 per Unit of return of contributed capital in 2023 and 2022, respectively. |
Fair Value Measurements
Fair Value Measurements | 3 Months Ended |
Mar. 31, 2023 | |
Fair Value Disclosures [Abstract] | |
Fair Value Disclosures [Text Block] | (7) Fair Value Measurements – At March 31, 2023 and December 31, 2022, the Company had no financial assets or liabilities measured at fair value on a recurring basis or nonrecurring basis. During 2023, the Company impaired The Cellular Connection store in Bluffton, Indiana to its fair value of approximately $508,000. Fair value was determined using figures included in a purchase agreement entered into in May 2023 to sell the property, which is classified as level 2. An impairment of $132,000 was recognized during the first quarter of 2023. |
Accounting Policies, by Policy
Accounting Policies, by Policy (Policies) | 3 Months Ended |
Mar. 31, 2023 | |
Accounting Policies [Abstract] | |
New Accounting Pronouncement or Change in Accounting Principle, Description | 2023, the Company adopted the Financial Accounting Standards Board (FASB) Accounting Standards Update (ASU) No. 2016-13, Financial Instruments - Credit Losses (Topic 326). This guidance changes the methodology to be used to measure credit losses for certain financial instruments and financial assets, including receivables. The new methodology requires the recognition of an allowance that reflects the current estimate of credit losses expected to be incurred over the life of the financial assets. The adoption of the guidance did not have a material impact on the Company's financial statements. Other accounting standards that have been issued or proposed by the FASB are currently not applicable to the Company or are expected to have a significant impact on the Company's financial position, results of operations, and cash flows. |
Real Estate Investments (Detail
Real Estate Investments (Details) - USD ($) | 3 Months Ended | 12 Months Ended | |||||||||
May 08, 2023 | Mar. 31, 2023 | Feb. 09, 2023 | Apr. 01, 2022 | Sep. 01, 2019 | Aug. 27, 2019 | Sep. 21, 2017 | Mar. 31, 2023 | Mar. 31, 2022 | Feb. 22, 2021 | Jun. 17, 2019 | |
Real Estate Investments (Details) [Line Items] | |||||||||||
Average Lease Term | In April 2022, the Company entered into an agreement with the tenant of the Fresenius Medical Care in Chicago, Illinois to extend the lease term five years to end on April 30, 2032 | ||||||||||
Proceeds from Sale of Real Estate | $ 1,677,402 | $ 945,486 | |||||||||
Gain (Loss) on Disposition of Assets | 707,000 | 24,945 | $ 24,945 | $ 0 | |||||||
SEC Schedule, 12-28, Real Estate Companies, Investment in Real Estate, Cost of Investment in Real Estate Sold | 1,292,220 | 1,871,978 | |||||||||
SEC Schedule, 12-28, Real Estate Companies, Investment in Real Estate, Accumulated Depreciation | $ 321,684 | $ 951,437 | |||||||||
Impairment of Real Estate | 132,000 | $ 0 | |||||||||
Property, Plant and Equipment, Gross | $ 640,000 | 640,000 | |||||||||
Property, Plant, and Equipment, Fair Value Disclosure | 508,000 | $ 508,000 | |||||||||
Impairment of Real Estate - Land | 38,280 | ||||||||||
Impairment of Real Estate - Building | 93,720 | ||||||||||
BigTime Fun Wichita KS | |||||||||||
Real Estate Investments (Details) [Line Items] | |||||||||||
Disposal Date | Feb. 09, 2023 | ||||||||||
Fresenius Medical Care Holding, Inc. (Member) | |||||||||||
Real Estate Investments (Details) [Line Items] | |||||||||||
Disposal Date | May 08, 2023 | ||||||||||
Biomat USA Plasma Center Wichita KS | |||||||||||
Real Estate Investments (Details) [Line Items] | |||||||||||
Average Lease Term | On September 21, 2017, the Company entered into a lease agreement with a primary term of 10 years with Biomat USA, Inc. (“Biomat”) as a replacement tenant for 28% of the square footage of the property. | ||||||||||
Revenue from Contract with Customer, Excluding Assessed Tax | $ 37,071 | ||||||||||
BigTime Fun Wichita KS | |||||||||||
Real Estate Investments (Details) [Line Items] | |||||||||||
Average Lease Term | On August 27, 2019, the Company entered into a lease agreement with a primary term of 10 years with BigTime Fun Center, LLC as a replacement tenant for 57% of the square footage of the property. | ||||||||||
Revenue from Contract with Customer, Excluding Assessed Tax | $ 78,000 | ||||||||||
Payments for Tenant Improvements | $ 64,000 | ||||||||||
Payments for Lease Commissions | $ 32,760 | ||||||||||
The Cellular Connection LLC 'Member' | |||||||||||
Real Estate Investments (Details) [Line Items] | |||||||||||
Impairment of Real Estate | $ 132,000 |
Members' Equity (Details)
Members' Equity (Details) - USD ($) | 3 Months Ended | |
Mar. 31, 2023 | Mar. 31, 2022 | |
Members' Equity (Details) [Line Items] | ||
Distribution Made to Limited Partner, Cash Distributions Declared | $ 59,175 | $ 92,887 |
Distribution Made to Limited Partner, Distributions Declared, Per Unit | $ 0.05 | |
Limited Partner [Member] | ||
Members' Equity (Details) [Line Items] | ||
Distribution Made to Limited Partner, Cash Distributions Declared | $ 57,400 | $ 90,100 |
Distribution Made to Limited Partner, Distributions Declared, Per Unit | $ 0.03 | |
Weighted Average Limited Partnership Units Outstanding, Basic | 1,669,943 | 1,678,443 |
DistributionsPerUnitOfNetIncome | $ 0 | $ 0 |
DistributionsPerUnitOfReturnOfCapital | $ 0 | $ 0.05 |
General Partner [Member] | ||
Members' Equity (Details) [Line Items] | ||
Distribution Made to Limited Partner, Cash Distributions Declared | $ 1,775 | $ 2,787 |
Fair Value Measurements (Detail
Fair Value Measurements (Details) - USD ($) | 3 Months Ended | |
Mar. 31, 2023 | Mar. 31, 2022 | |
Fair Value Measurements (Details) [Line Items] | ||
Property, Plant, and Equipment, Fair Value Disclosure | $ 508,000 | |
Impairment of Real Estate | 132,000 | $ 0 |
Estimate of Fair Value Measurement [Member] | ||
Fair Value Measurements (Details) [Line Items] | ||
Property, Plant, and Equipment, Fair Value Disclosure | 508,000 | |
SEC Schedule, 12-09, Reserve, Impairment of Recognized Servicing Asset [Member] | ||
Fair Value Measurements (Details) [Line Items] | ||
Impairment of Real Estate | $ 132,000 |
Uncategorized Items - aei26-202
Label | Element | Value |
General Partner [Member] | ||
Partners' Capital | us-gaap_PartnersCapital | $ 20,789 |
Limited Partner [Member] | ||
Partners' Capital | us-gaap_PartnersCapital | $ 3,744,416 |