10QSB 1 q212-07.txt UNITED STATES SECURITIES AND EXCHANGE COMMISSION Washington, D.C. 20549 FORM 10-QSB Quarterly Report Under Section 13 or 15(d) of The Securities Exchange Act of 1934 For the Quarter Ended: June 30, 2007 Commission file number: 0-29274 AEI INCOME & GROWTH FUND XXI LIMITED PARTNERSHIP (Exact Name of Small Business Issuer as Specified in its Charter) State of Minnesota 41-1789725 (State or other Jurisdiction of (I.R.S. Employer Incorporation or Organization) Identification No.) 30 East 7th Street, Suite 1300, St. Paul, Minnesota 55101 (Address of Principal Executive Offices) (651) 227-7333 (Issuer's telephone number) Not Applicable (Former name, former address and former fiscal year, if changed since last report) Check whether the issuer (1) filed all reports required to be filed by Section 13 or 15(d) of the Exchange Act during the past 12 months (or for such shorter period that the registrant was required to file such reports), and (2) has been subject to such filing requirements for the past 90 days. Yes [X] No Indicate by check mark whether the registrant is a shell company (as defined in Rule 12b-2 of the Exchange Act). Yes No [X] Transitional Small Business Disclosure Format: Yes No [X] AEI INCOME & GROWTH FUND XXI LIMITED PARTNERSHIP INDEX PART I. Financial Information Item 1. Balance Sheet as of June 30, 2007 and December 31, 2006 Statements for the Periods ended June 30, 2007 and 2006: Income Cash Flows Changes in Partners' Capital Notes to Financial Statements Item 2. Management's Discussion and Analysis Item 3. Controls and Procedures PART II. Other Information Item 1. Legal Proceedings Item 2. Unregistered Sales of Equity Securities and Use of Proceeds Item 3. Defaults Upon Senior Securities Item 4. Submission of Matters to a Vote of Security Holders Item 5. Other Information Item 6. Exhibits Signatures AEI INCOME & GROWTH FUND XXI LIMITED PARTNERSHIP BALANCE SHEET JUNE 30, 2007 AND DECEMBER 31, 2006 (Unaudited) ASSETS 2007 2006 CURRENT ASSETS: Cash and Cash Equivalents $ 2,100,943 $ 1,588,082 INVESTMENTS IN REAL ESTATE: Land 5,886,362 5,886,362 Buildings and Equipment 11,693,838 11,693,838 Accumulated Depreciation (2,141,848) (1,910,192) ----------- ----------- 15,438,352 15,670,008 Real Estate Held for Sale 159,557 753,379 ----------- ----------- Net Investments in Real Estate 15,597,909 16,423,387 ----------- ----------- Total Assets $17,698,852 $18,011,469 =========== =========== LIABILITIES AND PARTNERS' CAPITAL CURRENT LIABILITIES: Payable to AEI Fund Management, Inc. $ 18,293 $ 62,127 Distributions Payable 477,190 524,665 Unearned Rent 44,398 24,772 ----------- ----------- Total Current Liabilities 539,881 611,564 ----------- ----------- PARTNERS' CAPITAL: General Partners 9,156 11,566 Limited Partners, $1,000 per Unit; 24,000 Units authorized and issued; 22,802 Units outstanding 17,149,815 17,388,339 ----------- ----------- Total Partners' Capital 17,158,971 17,399,905 ----------- ----------- Total Liabilities and Partners' Capital $17,698,852 $18,011,469 =========== =========== The accompanying Notes to Financial Statements are an integral part of this statement. AEI INCOME & GROWTH FUND XXI LIMITED PARTNERSHIP STATEMENT OF INCOME FOR THE PERIODS ENDED JUNE 30 (Unaudited) Three Months Ended Six Months Ended 6/30/07 6/30/06 6/30/07 6/30/06 RENTAL INCOME $ 401,658 $ 360,010 $ 803,307 $ 740,447 EXPENSES: Partnership Administration - Affiliates 56,611 56,530 110,227 112,002 Partnership Administration and Property Management - Unrelated Parties 12,136 15,853 25,814 26,539 Depreciation 115,828 103,321 231,656 206,642 --------- --------- --------- --------- Total Expenses 184,575 175,704 367,697 345,183 --------- --------- --------- --------- OPERATING INCOME 217,083 184,306 435,610 395,264 OTHER INCOME: Interest Income 24,014 14,356 42,457 19,933 --------- --------- --------- --------- INCOME FROM CONTINUING OPERATIONS 241,097 198,662 478,067 415,197 Income from Discontinued Operations 96,663 420,535 169,880 479,697 --------- --------- --------- --------- NET INCOME $ 337,760 $ 619,197 $ 647,947 $ 894,894 --------- --------- --------- --------- NET INCOME ALLOCATED: General Partners $ 3,377 $ 6,192 $ 6,479 $ 8,949 Limited Partners 334,383 613,005 641,468 885,945 --------- --------- --------- --------- $ 337,760 $ 619,197 $ 647,947 $ 894,894 ========= ========= ========= ========= INCOME PER LIMITED PARTNERSHIP UNIT: Continuing Operations $ 10.47 $ 8.63 $ 20.76 $ 18.03 Discontinued Operations 4.19 18.25 7.37 20.82 --------- --------- --------- --------- Total $ 14.66 $ 26.88 $ 28.13 $ 38.85 ========= ========= ========= ========= Weighted Average Units Outstanding 22,802 22,802 22,802 22,802 ========= ========= ========= ========= The accompanying Notes to Financial Statements are an integral part of this statement. AEI INCOME & GROWTH FUND XXI LIMITED PARTNERSHIP STATEMENT OF CASH FLOWS FOR THE SIX-MONTH PERIODS ENDED JUNE 30 (Unaudited) 2007 2006 CASH FLOWS FROM OPERATING ACTIVITIES: Net Income $ 647,947 $ 894,894 Adjustments to Reconcile Net Income to Net Cash Provided by Operating Activities: Depreciation 231,656 227,567 Gain on Sale of Real Estate (151,669) (374,027) Decrease in Receivables 0 1,001 Increase (Decrease) in Payable to AEI Fund Management, Inc. (43,834) 48,340 Increase in Unearned Rent 19,626 37,049 ----------- ----------- Total Adjustments 55,779 (60,070) ----------- ----------- Net Cash Provided By Operating Activities 703,726 834,824 ----------- ----------- CASH FLOWS FROM INVESTING ACTIVITIES: Proceeds from Sale of Real Estate 745,491 1,547,574 ----------- ----------- CASH FLOWS FROM FINANCING ACTIVITIES: Increase (Decrease) in Distributions Payable (47,475) 60,603 Distributions to Partners (888,881) (1,055,547) ----------- ----------- Net Cash Used For Financing Activities (936,356) (994,944) ----------- ----------- INCREASE IN CASH AND CASH EQUIVALENTS 512,861 1,387,454 CASH AND CASH EQUIVALENTS, beginning of period 1,588,082 862,160 ----------- ----------- CASH AND CASH EQUIVALENTS, end of period $ 2,100,943 $ 2,249,614 =========== =========== The accompanying Notes to Financial Statements are an integral part of this statement. AEI INCOME & GROWTH FUND XXI LIMITED PARTNERSHIP STATEMENT OF CHANGES IN PARTNERS' CAPITAL FOR THE PERIODS ENDED JUNE 30 (Unaudited) Limited Partnership General Limited Units Partners Partners Total Outstanding BALANCE, December 31, 2005 $ 14,148 $17,643,943 $17,658,091 22,802.45 Distributions (10,555) (1,044,992) (1,055,547) Net Income 8,949 885,945 894,894 -------- ----------- ----------- ----------- BALANCE, June 30, 2006 $ 12,542 $17,484,896 $17,497,438 22,802.45 ======== =========== =========== =========== BALANCE, December 31, 2006 $ 11,566 $17,388,339 $17,399,905 22,802.45 Distributions (8,889) (879,992) (888,881) Net Income 6,479 641,468 647,947 -------- ----------- ----------- ----------- BALANCE, June 30, 2007 $ 9,156 $17,149,815 $17,158,971 22,802.45 ======== =========== =========== =========== The accompanying Notes to Financial Statements are an integral part of this statement. AEI INCOME & GROWTH FUND XXI LIMITED PARTNERSHIP NOTES TO FINANCIAL STATEMENTS JUNE 30, 2007 (Unaudited) (1) The condensed statements included herein have been prepared by the Partnership, 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 generally accepted accounting principles have been condensed or omitted pursuant to such rules and regulations, although the Partnership 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 Partnership's latest annual report on Form 10-KSB. (2) Organization - AEI Income & Growth Fund XXI Limited Partnership (Partnership) was formed to acquire and lease commercial properties to operating tenants. The Partnership's operations are managed by AEI Fund Management XXI, Inc. (AFM), the Managing General Partner. Robert P. Johnson, the President and sole director of AFM, serves as the Individual General Partner. AFM is a wholly owned subsidiary of AEI Capital Corporation of which Mr. Johnson is the majority shareholder. AEI Fund Management, Inc. (AEI), an affiliate of AFM, performs the administrative and operating functions for the Partnership. The terms of the Partnership offering called for a subscription price of $1,000 per Limited Partnership Unit, payable on acceptance of the offer. The Partnership commenced operations on April 14, 1995 when minimum subscriptions of 1,500 Limited Partnership Units ($1,500,000) were accepted. On January 31, 1997, the offering terminated when the maximum subscription limit of 24,000 Limited Partnership Units was reached. Under the terms of the Limited Partnership Agreement, the Limited Partners and General Partners contributed funds of $24,000,000 and $1,000, respectively. During operations, any Net Cash Flow, as defined, which the General Partners determine to distribute will be distributed 90% to the Limited Partners and 10% to the General Partners; provided, however, that such distributions to the General Partners will be subordinated to the Limited Partners first receiving an annual, noncumulative distribution of Net Cash Flow equal to 10% of their Adjusted Capital Contribution, as defined, and, provided further, that in no event will the General Partners receive less than 1% of such Net Cash Flow per annum. Distributions to Limited Partners will be made pro rata by Units. AEI INCOME & GROWTH FUND XXI LIMITED PARTNERSHIP NOTES TO FINANCIAL STATEMENTS (Continued) (2) Organization - (Continued) Any Net Proceeds of Sale, as defined, from the sale or financing of properties which the General Partners determine to distribute will, after provisions for debts and reserves, be paid in the following manner: (i) first, 99% to the Limited Partners and 1% to the General Partners until the Limited Partners receive an amount equal to: (a) their Adjusted Capital Contribution plus (b) an amount equal to 10% of their Adjusted Capital Contribution per annum, cumulative but not compounded, to the extent not previously distributed from Net Cash Flow; (ii) any remaining balance will be distributed 90% to the Limited Partners and 10% to the General Partners. Distributions to the Limited Partners will be made pro rata by Units. For tax purposes, profits from operations, other than profits attributable to the sale, exchange, financing, refinancing or other disposition of property, will be allocated first in the same ratio in which, and to the extent, Net Cash Flow is distributed to the Partners for such year. Any additional profits will be allocated in the same ratio as the last dollar of Net Cash Flow is distributed. Net losses from operations will be allocated 99% to the Limited Partners and 1% to the General Partners. For tax purposes, profits arising from the sale, financing, or other disposition of property will be allocated in accordance with the Partnership Agreement as follows: (i) first, to those partners with deficit balances in their capital accounts in an amount equal to the sum of such deficit balances; (ii) second, 99% to the Limited Partners and 1% to the General Partners until the aggregate balance in the Limited Partners' capital accounts equals the sum of the Limited Partners' Adjusted Capital Contributions plus an amount equal to 10% of their Adjusted Capital Contributions per annum, cumulative but not compounded, to the extent not previously allocated; (iii) third, the balance of any remaining gain will then be allocated 90% to the Limited Partners and 10% to the General Partners. Losses will be allocated 98% to the Limited Partners and 2% to the General Partners. The General Partners are not required to currently fund a deficit capital balance. Upon liquidation of the Partnership or withdrawal by a General Partner, the General Partners will contribute to the Partnership an amount equal to the lesser of the deficit balances in their capital accounts or 1% of total Limited Partners' and General Partners' capital contributions. AEI INCOME & GROWTH FUND XXI LIMITED PARTNERSHIP NOTES TO FINANCIAL STATEMENTS (Continued) (3) Investments in Real Estate - In February 2005, Winn-Dixie Montgomery, Inc., the tenant of the Winn-Dixie store in Panama City, Florida, and its parent company, Winn-Dixie, Inc., filed for Chapter 11 bankruptcy reorganization. On June 29, 2006, Winn-Dixie issued a press release announcing that it filed its proposed Plan of Reorganization with the bankruptcy court. In November 2006, the bankruptcy court approved Winn-Dixie's Plan of Reorganization and the Plan became effective. Under the Plan, Winn-Dixie assumed the Lease for this store under its original terms without any rent concessions. As of the date of this report, Winn-Dixie has complied with all Lease terms. On September 21, 2006, the Partnership purchased a 62% interest in an Applebee's restaurant in Johnstown, Pennsylvania for $1,682,887. The property is leased to B.T. Woodlipp, Inc. under a Lease Agreement with a primary term of 20 years and initial annual rent of $121,340. The remaining interest in the property was purchased by AEI Income & Growth Fund XXII Limited Partnership, an affiliate of the Partnership. (4) Payable to AEI Fund Management, Inc. - AEI Fund Management, Inc. performs the administrative and operating functions for the Partnership. 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. (5) Discontinued Operations - During 2006, the Partnership sold 29.9758% of the Eckerd drug store in Utica, New York, in six separate transactions, to unrelated third parties. The Partnership received total net sale proceeds of $1,635,645, which resulted in a net gain of $290,312. The cost and related accumulated depreciation of the interests sold was $1,384,963 and $39,630, respectively. For the six months ended June 30, 2006, the net gain was $212,006. During the first three months of 2007, the Partnership sold its remaining 10.0242% interest in the Eckerd drug store in Utica, New York, in two separate transactions, to unrelated third parties. The Partnership received total net sale proceeds of $509,303, which resulted in a net gain of $59,412. The cost and related accumulated depreciation of the interests sold was $463,144 and $13,253, respectively. At December 31, 2006, the property was classified as Real Estate Held for Sale with a book value of $449,891. During 2006, the Partnership sold 74.4774% of the Children's World daycare center in Kimberly, Wisconsin, in four separate transactions, to unrelated third parties. The Partnership received total net sale proceeds of $1,414,328, which resulted in a net gain of $528,717. The cost and related accumulated depreciation of the interests sold was $1,011,582 and $125,971, respectively. For the six months ended June 30, 2006, the net gain was $162,021. AEI INCOME & GROWTH FUND XXI LIMITED PARTNERSHIP NOTES TO FINANCIAL STATEMENTS (Continued) (5) Discontinued Operations - (Continued) On April 12, 2007, the Partnership sold an additional 12.1042% of the Children's World daycare center in Kimberly, Wisconsin to an unrelated third party. The Partnership received net sale proceeds of $236,188, which resulted in a net gain of $92,257. The cost and related accumulated depreciation of the interest sold was $164,404 and $20,473, respectively. The Partnership is attempting to sell its remaining 13.4184% interest in the property. At June 30, 2007 and December 31, 2006, the property was classified as Real Estate Held for Sale with a book value of $159,557 and $303,488, respectively. During the first six months of 2007 and 2006, the Partnership distributed $160,946 and $307,113 of net sale proceeds to the Limited and General Partners as part of their quarterly distributions, which represented a return of capital of $6.98 and $13.34 per Limited Partnership Unit, respectively. The Partnership anticipates the remaining net sale proceeds will either be reinvested in additional property or distributed to the Partners in the future. The financial results for these properties are reflected as Discontinued Operations in the accompanying financial statements. The following are the results of discontinued operations for the periods ended June 30: Three Months Ended Six Months Ended 6/30/07 6/30/06 6/30/07 6/30/06 Rental Income $ 4,807 $ 57,846 $ 18,612 $ 127,535 Property Management Expenses (401) (875) (401) (940) Depreciation 0 (10,463) 0 (20,925) Gain on Disposal of Real Estate 92,257 374,027 151,669 374,027 ------ -------- ------- -------- Income from Discontinued Operations $96,663 $ 420,535 $169,880 $ 479,697 ====== ======== ======= ======== ITEM 2.MANAGEMENT'S DISCUSSION AND ANALYSIS The Management's Discussion and Analysis contains various "forward looking statements" within the meaning of federal securities laws which represent management's expectations or beliefs concerning future events, including statements regarding anticipated application of cash, expected returns from rental income, growth in revenue, the sufficiency of cash to meet operating expenses, rates of distribution, and other matters. These, and other forward looking statements made by the Partnership, must be evaluated in the context of a number of factors that may affect the Partnership's financial condition and results of operations, including the following: Market and economic conditions which affect the value of the properties the Partnership owns and the cash from rental income such properties generate; the federal income tax consequences of rental income, deductions, gain on sales and other items and the effects of these consequences for the Partners; resolution by the General Partners of conflicts with which they may be confronted; the success of the General Partners of locating properties with favorable risk return characteristics; the effect of tenant defaults; and the condition of the industries in which the tenants of properties owned by the Partnership operate. The Application of Critical Accounting Policies The preparation of the Partnership's financial statements requires management to make estimates and assumptions that may affect the reported amounts of assets, liabilities, revenues and expenses, and related disclosure of contingent assets and liabilities. Management evaluates these estimates on an ongoing basis, including those related to the carrying value of real estate and the allocation by AEI Fund Management, Inc. of expenses to the Partnership as opposed to other funds they manage. The Partnership purchases properties and records them in the financial statements at the lower of cost or estimated realizable value. The Partnership initially records the properties at cost (including capitalized acquisition expenses). The Partnership is required to periodically evaluate the carrying value of properties to determine whether their realizable value has declined. For properties the Partnership will hold and operate, management determines whether impairment has occurred by comparing the property's probability-weighted cash flows to its current carrying value. For properties held for sale, management determines whether impairment has occurred by comparing the property's estimated fair value less cost to sell to its current carrying value. If the carrying value is greater than the realizable value, an impairment loss is recorded to reduce the carrying value of the property to its realizable value. A change in these assumptions or analysis could cause material changes in the carrying value of the properties. ITEM 2.MANAGEMENT'S DISCUSSION AND ANALYSIS. (Continued) AEI Fund Management, Inc. allocates expenses to each of the funds they manage primarily on the basis of the number of hours devoted by their employees to each fund's affairs. They also allocate expenses at the end of each month that are not directly related to a fund's operations based upon the number of investors in the fund and the fund's capitalization relative to other funds they manage. The Partnership reimburses these expenses subject to detailed limitations contained in the Partnership Agreement. Management of the Partnership has discussed the development and selection of the above accounting estimates and the management discussion and analysis disclosures regarding them with the managing partner of the Partnership. Results of Operations For the six months ended June 30, 2007 and 2006, the Partnership recognized rental income from continuing operations of $803,307 and $740,447, respectively. In 2007, rental income increased due to additional rent received from one property acquisition in 2006 and rent increases on four properties. In 2006, rental income included $20,430 received from a permanent easement on one property. For the six months ended June 30, 2007 and 2006, the Partnership incurred Partnership administration expenses from affiliated parties of $110,227 and $112,002, respectively. These administration expenses include costs associated with the management of the properties, processing distributions, reporting requirements and correspondence to the Limited Partners. During the same periods, the Partnership incurred Partnership administration and property management expenses from unrelated parties of $25,814 and $26,539, respectively. These expenses represent direct payments to third parties for legal and filing fees, direct administrative costs, outside audit costs, taxes, insurance and other property costs. In February 2005, Winn-Dixie Montgomery, Inc., the tenant of the Winn-Dixie store in Panama City, Florida, and its parent company, Winn-Dixie, Inc., filed for Chapter 11 bankruptcy reorganization. On June 29, 2006, Winn-Dixie issued a press release announcing that it filed its proposed Plan of Reorganization with the bankruptcy court. In November 2006, the bankruptcy court approved Winn-Dixie's Plan of Reorganization and the Plan became effective. Under the Plan, Winn-Dixie assumed the Lease for this store under its original terms without any rent concessions. As of the date of this report, Winn-Dixie has complied with all Lease terms. For the six months ended June 30, 2007 and 2006, the Partnership recognized interest income of $42,457 and $19,933, respectively. In 2007, interest income increased due to the Partnership having more money invested in a money market account due to property sales. ITEM 2.MANAGEMENT'S DISCUSSION AND ANALYSIS. (Continued) In accordance with Statement of Financial Accounting Standards No. 144, Accounting for the Impairment or Disposal of Long-Lived Assets, upon complete disposal of a property or classification of a property as Real Estate Held for Sale, the Partnership includes the operating results and sale of the property in discontinued operations. In addition, the Partnership reclassifies the prior periods operating results and any partial sales of the property to discontinued operations. For the six months ended June 30, 2007, the Partnership recognized income from discontinued operations of $169,880, representing rental income less property management expenses of $18,211 and gain on disposal of real estate of $151,669. For the six months ended June 30, 2006, the Partnership recognized income from discontinued operations of $479,697, representing rental income less property management expenses and depreciation of $105,670 and gain on disposal of real estate of $374,027. During 2006, the Partnership sold 29.9758% of the Eckerd drug store in Utica, New York, in six separate transactions, to unrelated third parties. The Partnership received total net sale proceeds of $1,635,645, which resulted in a net gain of $290,312. The cost and related accumulated depreciation of the interests sold was $1,384,963 and $39,630, respectively. For the six months ended June 30, 2006, the net gain was $212,006. During the first three months of 2007, the Partnership sold its remaining 10.0242% interest in the Eckerd drug store in Utica, New York, in two separate transactions, to unrelated third parties. The Partnership received total net sale proceeds of $509,303, which resulted in a net gain of $59,412. The cost and related accumulated depreciation of the interests sold was $463,144 and $13,253, respectively. At December 31, 2006, the property was classified as Real Estate Held for Sale with a book value of $449,891. During 2006, the Partnership sold 74.4774% of the Children's World daycare center in Kimberly, Wisconsin, in four separate transactions, to unrelated third parties. The Partnership received total net sale proceeds of $1,414,328, which resulted in a net gain of $528,717. The cost and related accumulated depreciation of the interests sold was $1,011,582 and $125,971, respectively. For the six months ended June 30, 2006, the net gain was $162,021. On April 12, 2007, the Partnership sold an additional 12.1042% of the Children's World daycare center in Kimberly, Wisconsin to an unrelated third party. The Partnership received net sale proceeds of $236,188, which resulted in a net gain of $92,257. The cost and related accumulated depreciation of the interest sold was $164,404 and $20,473, respectively. The Partnership is attempting to sell its remaining 13.4184% interest in the property. At June 30, 2007 and December 31, 2006, the property was classified as Real Estate Held for Sale with a book value of $159,557 and $303,488, respectively. ITEM 2.MANAGEMENT'S DISCUSSION AND ANALYSIS. (Continued) Inflation has had a minimal effect on income from operations. Leases may contain rent increases, based on the increase in the Consumer Price Index over a specified period, which will result in an increase in rental income over the term of the leases. In addition, leases may contain rent clauses which entitle the Partnership to receive additional rent in future years if gross receipts for the property exceed certain specified amounts. Increases in sales volumes of the tenants, due to inflation and real sales growth, may result in an increase in rental income over the term of the leases. Inflation also may cause the real estate to appreciate in value. However, inflation and changing prices may have an adverse impact on the operating margins of the properties' tenants, which could impair their ability to pay rent and subsequently reduce the Net Cash Flow available for distributions. Liquidity and Capital Resources During the six months ended June 30, 2007, the Partnership's cash balances increased $512,861 as a result of cash generated from the sale of property, which was partially offset by distributions paid to the Partners in excess of cash generated from operating activities. During the six months ended June 30, 2006, the Partnership's cash balances increased $1,387,454 as a result of cash generated from the sale of property, which was partially offset by distributions paid to the Partners in excess of cash generated from operating activities. Net cash provided by operating activities decreased from $834,824 in 2006 to $703,726 in 2007 as a result of a decrease in total rental and interest income in 2007 and net timing differences in the collection of payments from the tenants and the payment of expenses, which were partially offset by a decrease in Partnership administration and property management expenses in 2007. The major components of the Partnership's cash flow from investing activities are investments in real estate and proceeds from the sale of real estate. During the six months ended June 30, 2007 and 2006, the Partnership generated cash flow from the sale of real estate of $745,491 and $1,547,574, respectively. On September 21, 2006, the Partnership purchased a 62% interest in an Applebee's restaurant in Johnstown, Pennsylvania for $1,682,887. The property is leased to B.T. Woodlipp, Inc. under a Lease Agreement with a primary term of 20 years and initial annual rent of $121,340. The remaining interest in the property was purchased by AEI Income & Growth Fund XXII Limited Partnership, an affiliate of the Partnership. The Partnership's primary use of cash flow, other than investment in real estate, is distribution and redemption payments to Partners. The Partnership declares its regular quarterly distributions before the end of each quarter and pays the distribution in the first ten days after the end of each quarter. The Partnership attempts to maintain a stable distribution rate from quarter to quarter. Redemption payments are paid to redeeming Partners in the fourth quarter of each year. ITEM 2.MANAGEMENT'S DISCUSSION AND ANALYSIS. (Continued) For the six months ended June 30, 2007 and 2006, the Partnership declared distributions of $888,881 and $1,055,547, respectively, which were distributed 99% to the Limited Partners and 1% to the General Partners. The Limited Partners received distributions of $879,992 and $1,044,992 and the General Partners received distributions of $8,889 and $10,555 for the periods, respectively. In June 2007, the Partnership declared a special distribution of net sale proceeds of $70,707. In June, September and December 2006, the Partnership declared special distributions of net sale proceeds of $237,374, $118,182 and $118,182, respectively, which resulted in higher distributions in 2006 and a higher distribution payable at December 31, 2006. During the first six months of 2007 and 2006, the Partnership distributed $160,946 and $307,113 of net sale proceeds to the Limited and General Partners as part of their quarterly distributions, which represented a return of capital of $6.98 and $13.34 per Limited Partnership Unit, respectively. The Partnership anticipates the remaining net sale proceeds will either be reinvested in additional property or distributed to the Partners in the future. The Partnership may acquire Units from Limited Partners who have tendered their Units to the Partnership. Such Units may be acquired at a discount. The Partnership will not be obligated to purchase in any year any number of Units that, when aggregated with all other transfers of Units that have occurred since the beginning of the same calendar year (excluding Permitted Transfers as defined in the Partnership Agreement), would exceed 5% of the total number of Units outstanding on January 1 of such year. In no event shall the Partnership be obligated to purchase Units if, in the sole discretion of the Managing General Partner, such purchase would impair the capital or operation of the Partnership. During 2006, the Partnership did not redeem any Units from the Limited Partners. In prior years, a total of 58 Limited Partners redeemed 1,197.55 Partnership Units for $949,024. The redemptions increase the remaining Limited Partners' ownership interest in the Partnership. The continuing rent payments from the properties, together with cash generated from property sales, should be adequate to fund continuing distributions and meet other Partnership obligations on both a short-term and long-term basis. ITEM 3. CONTROLS AND PROCEDURES. (a) Evaluation of disclosure controls and procedures Under the supervision and with the participation of management, including its President and Chief Financial Officer, the Managing General Partner of the Partnership evaluated the effectiveness of the design and operation of its disclosure controls and procedures (as defined in Rule 13a-14(c) under the Exchange Act). Based upon that evaluation, the President and Chief Financial Officer of the Managing General Partner concluded that, as of the end of the period covered by this report, the disclosure controls and procedures of the Partnership are adequately designed to ensure that information required to be disclosed by us in the reports we file or submit under the Exchange Act is recorded, processed, summarized and reported, within the time periods specified in applicable rules and forms and that such information is accumulated and communicated to management, including the President and Chief Financial Officer of the Managing General Partner, in a manner that allows timely decisions regarding required disclosure. (b) Changes in internal controls There were no significant changes made in the Partnership's internal controls during the most recent period covered by this report that have materially affected, or are reasonably likely to materially affect, the Partnership's internal control over financial reporting. PART II - OTHER INFORMATION ITEM 1.LEGAL PROCEEDINGS There are no material pending legal proceedings to which the Partnership is a party or of which the Partnership's property is subject. ITEM 2.UNREGISTERED SALES OF EQUITY SECURITIES AND USE OF PROCEEDS (a) During the period covered by this report, the Partnership did not sell any equity securities that are not registered under the Securities Act of 1933. (b) Not applicable. (c) Pursuant to Section 7.7 of the Partnership Agreement, each Limited Partner has the right to present Units to the Partnership for purchase by submitting notice to the Managing General Partner during September of each year. The purchase price of the Units is based on a formula specified in the Partnership Agreement. Units tendered to the Partnership are redeemed on October 1st of each year subject to the following limitations. The Partnership will not be obligated to purchase in any year any number of Units that, when aggregated with all other transfers of Units that have occurred since the beginning of the same calendar year (excluding Permitted Transfers as defined in the Partnership Agreement), would exceed 5% of the total number of Units outstanding on January 1 of such year. In no event shall the Partnership be obligated to purchase Units if, in the sole discretion of the Managing General Partner, such purchase would impair the capital or operation of the Partnership. During the period covered by this report, the Partnership did not purchase any Units. PART II - OTHER INFORMATION (Continued) ITEM 3.DEFAULTS UPON SENIOR SECURITIES None. ITEM 4.SUBMISSION OF MATTERS TO A VOTE OF SECURITY HOLDERS None ITEM 5.OTHER INFORMATION None. ITEM 6.EXHIBITS 31.1 Certification of Chief Executive Officer of General Partner pursuant to Rule 15d-14(a)(17 CFR 240.15d-14(a)) and Section 302 of the Sarbanes-Oxley Act of 2002. 31.2 Certification of Chief Financial Officer of General Partner pursuant to Rule 15d-14(a)(17 CFR 240.15d-14(a)) and Section 302 of the Sarbanes-Oxley Act of 2002. 32 Certification of Chief Executive Officer and Chief Financial Officer of General Partner pursuant to Section 906 of the Sarbanes-Oxley Act of 2002. SIGNATURES In accordance with the requirements of the Exchange Act, the registrant caused this report to be signed on its behalf by the undersigned, thereunto duly authorized. Dated: August 6, 2007 AEI Income & Growth Fund XXI Limited Partnership By: AEI Fund Management XXI, Inc. Its: Managing General Partner By:/s/ Robert P Johnson Robert P. Johnson President (Principal Executive Officer) By:/s/ Patrick W Keene Patrick W. Keene Chief Financial Officer (Principal Accounting Officer)