Wheeler | Pro Forma | Pro Forma | ||||||||||||||||
REIT | Offering | Adjustments | Consolidated | |||||||||||||||
(A) | (B) | (C) | ||||||||||||||||
ASSETS: | ||||||||||||||||||
Investment properties, net | $ | 383,861,007 | $ | — | $ | 75,237,973 | $ | 459,098,980 | ||||||||||
Cash and cash equivalents | 5,662,621 | 26,697,405 | (26,697,410 | ) | 5,662,616 | |||||||||||||
Restricted cash | 9,624,663 | — | 2,500,000 | 12,124,663 | ||||||||||||||
Rents and other tenant receivables, net | 5,107,978 | — | — | 5,107,978 | ||||||||||||||
Related party receivables | 2,321,679 | — | — | 2,321,679 | ||||||||||||||
Notes receivable | 12,000,000 | — | — | 12,000,000 | ||||||||||||||
Goodwill | 5,485,823 | — | — | 5,485,823 | ||||||||||||||
Above market lease intangible, net | 9,521,904 | — | 1,892,007 | 11,413,911 | ||||||||||||||
Deferred costs and other assets, net | 37,477,396 | — | 11,068,974 | 48,546,370 | ||||||||||||||
Total Assets | $ | 471,063,071 | $ | 26,697,405 | $ | 64,001,544 | $ | 561,762,020 | ||||||||||
LIABILITIES: | ||||||||||||||||||
Loans payable, net | $ | 306,961,715 | $ | — | $ | 58,952,590 | $ | 365,914,305 | ||||||||||
Below market lease intangibles, net | 10,355,592 | — | 5,048,954 | 15,404,546 | ||||||||||||||
Accounts payable, accrued expenses and other liabilities | 10,306,909 | — | — | 10,306,909 | ||||||||||||||
Dividend payable | 5,478,043 | — | — | 5,478,043 | ||||||||||||||
Total Liabilities | 333,102,259 | — | 64,001,544 | 397,103,803 | ||||||||||||||
Commitments and contingencies | — | — | — | — | ||||||||||||||
Series D cumulative convertible preferred stock | 53,052,193 | 26,697,405 | — | 79,749,598 | ||||||||||||||
EQUITY: | ||||||||||||||||||
Series A preferred stock | 452,971 | — | — | 452,971 | ||||||||||||||
Series B convertible preferred stock | 40,893,444 | — | — | 40,893,444 | ||||||||||||||
Common stock | 87,309 | — | — | 87,309 | ||||||||||||||
Additional paid-in capital | 226,864,258 | — | — | 226,864,258 | ||||||||||||||
Accumulated deficit | (191,256,281 | ) | — | — | (191,256,281 | ) | ||||||||||||
Noncontrolling interest | 7,866,918 | — | — | 7,866,918 | ||||||||||||||
Total Equity | 84,908,619 | — | — | 84,908,619 | ||||||||||||||
Total Liabilities and Equity | $ | 471,063,071 | $ | 26,697,405 | $ | 64,001,544 | $ | 561,762,020 |
Wheeler REIT | Properties | Pro Forma Adjustments | Pro Forma Consolidated | |||||||||||||||
(A) | (B) | (C) | ||||||||||||||||
REVENUES: | ||||||||||||||||||
Rental revenues | $ | 33,265,265 | $ | 5,958,242 | $ | 526,185 | (1) | $ | 39,749,692 | |||||||||
Asset management fees | 806,692 | — | — | 806,692 | ||||||||||||||
Commissions | 757,530 | — | — | 757,530 | ||||||||||||||
Tenant reimbursements | 8,127,410 | 2,232,171 | — | 10,359,581 | ||||||||||||||
Development and other revenues | 1,281,831 | — | — | 1,281,831 | ||||||||||||||
Total Revenues | 44,238,728 | 8,190,413 | 526,185 | 52,955,326 | ||||||||||||||
OPERATING EXPENSES AND CERTAIN | ||||||||||||||||||
OPERATING EXPENSES OF THE ACQUIRED PROPERTY: | ||||||||||||||||||
Property operations | 11,467,076 | 3,160,074 | — | 14,627,150 | ||||||||||||||
Non-REIT management and leasing services | 1,524,780 | — | — | 1,524,780 | ||||||||||||||
Depreciation and amortization | 20,454,694 | — | 3,174,924 | (2) | 23,629,618 | |||||||||||||
Provision for credit losses | 443,243 | — | — | 443,243 | ||||||||||||||
Corporate general & administrative | 4,856,448 | 218,268 | — | 5,074,716 | ||||||||||||||
Total Operating Expenses and Certain Operating | ||||||||||||||||||
Expenses of the Acquired Property | 38,746,241 | 3,378,342 | 3,174,924 | 45,299,507 | ||||||||||||||
Operating Income (Loss) and Excess of Acquired | ||||||||||||||||||
Revenues Over Certain Operating Expenses | 5,492,487 | 4,812,071 | (2,648,739 | ) | 7,655,819 | |||||||||||||
Gain on disposal of property | 1,021,112 | — | — | 1,021,112 | ||||||||||||||
Interest income | 1,079,572 | — | — | 1,079,572 | ||||||||||||||
Interest expense | (12,997,435 | ) | — | (2,021,905 | ) | (3) | (15,019,340 | ) | ||||||||||
Net Income (Loss) from Continuing Operations Before Income Taxes | (5,404,264 | ) | 4,812,071 | (4,670,644 | ) | (5,262,837 | ) | |||||||||||
Income Tax Expense | (174,622 | ) | — | — | (174,622 | ) | ||||||||||||
Net Income (Loss) from Continuing Operations after Income Taxes | (5,578,886 | ) | 4,812,071 | (4,670,644 | ) | (5,437,459 | ) | |||||||||||
Less: Net income (loss) from continuing operations attributable to noncontrolling interests | (227,836 | ) | — | 5,776 | (4) | (222,060 | ) | |||||||||||
Net Income (Loss) from Continuing Operations Attributable to Wheeler REIT | $ | (5,351,050 | ) | $ | 4,812,071 | $ | (4,676,420 | ) | $ | (5,215,399 | ) | |||||||
Net (loss) from continuing operations per share: | ||||||||||||||||||
Basic and diluted | $ | (0.62 | ) | $ | (0.60 | ) | ||||||||||||
Net (loss) from continuing operations per unit: | ||||||||||||||||||
Basic and diluted | $ | (0.32 | ) | $ | (0.31 | ) | ||||||||||||
Weighted-average outstanding: | ||||||||||||||||||
Common shares | 8,625,523 | 8,625,523 | ||||||||||||||||
Common units | 723,269 | 723,269 | ||||||||||||||||
Basic and diluted | 9,348,792 | 9,348,792 | ||||||||||||||||
Wheeler REIT | Properties | Pro Forma Adjustments | Pro Forma Consolidated | |||||||||||||||
(D) | (E) | (C) | ||||||||||||||||
REVENUES: | ||||||||||||||||||
Rental revenues | $ | 33,164,924 | $ | 7,701,467 | $ | 601,652 | (1) | $ | 41,468,043 | |||||||||
Asset management fees | 854,857 | — | — | 854,857 | ||||||||||||||
Commissions | 963,936 | — | — | 963,936 | ||||||||||||||
Tenant reimbursement | 9,176,691 | 3,144,021 | — | 12,320,712 | ||||||||||||||
Total Revenues | 44,160,408 | 10,845,488 | 601,652 | 55,607,548 | ||||||||||||||
OPERATING EXPENSES AND CERTAIN | ||||||||||||||||||
OPERATING EXPENSES OF THE ACQUIRED PROPERTY: | ||||||||||||||||||
Property operations | 11,898,190 | 3,996,560 | — | 15,894,750 | ||||||||||||||
Non-REIT management and leasing services | 1,567,128 | — | — | 1,567,128 | ||||||||||||||
Depreciation and amortization | 20,636,940 | — | 5,238,674 | (2) | 25,875,614 | |||||||||||||
Provision for credit losses | 424,925 | — | — | 424,925 | ||||||||||||||
Corporate general & administrative | 9,924,361 | 322,325 | — | 10,246,686 | ||||||||||||||
Total Operating Expenses and Certain Operating | ||||||||||||||||||
Expenses of the Acquired Property | 44,451,544 | 4,318,885 | 5,238,674 | 54,009,103 | ||||||||||||||
Operating Income (Loss) and Excess of Acquired | ||||||||||||||||||
Revenues Over Certain Operating Expenses | (291,136 | ) | 6,526,603 | (4,637,022 | ) | 1,598,445 | ||||||||||||
Interest Income | 691,937 | — | — | 691,937 | ||||||||||||||
Interest expense | (13,356,111 | ) | — | (2,760,102 | ) | (3) | (16,116,213 | ) | ||||||||||
Net Income (Loss) from Continuing Operations Before Income Taxes | (12,955,310 | ) | 6,526,603 | (7,397,124 | ) | (13,825,831 | ) | |||||||||||
Income Tax Expense | (107,464 | ) | — | — | (107,464 | ) | ||||||||||||
Net Income (Loss) from Continuing Operations after Income Taxes | (13,062,774 | ) | 6,526,603 | (7,397,124 | ) | (13,933,295 | ) | |||||||||||
Less: Net income (loss) from continuing operations attributable to noncontrolling interests | (1,105,238 | ) | — | (73,655 | ) | (4) | (1,178,893 | ) | ||||||||||
Net Income (Loss) from Continuing Operations Attributable to Wheeler REIT | $ | (11,957,536 | ) | $ | 6,526,603 | $ | (7,323,469 | ) | $ | (12,754,402 | ) | |||||||
Net (loss) from continuing operations per share: | ||||||||||||||||||
Basic and diluted | $ | (1.42 | ) | $ | (1.51 | ) | ||||||||||||
Net (loss) from continuing operations per unit: | ||||||||||||||||||
Basic and diluted | $ | (1.60 | ) | $ | (1.71 | ) | ||||||||||||
Weighted-average outstanding: | ||||||||||||||||||
Common shares | 8,420,374 | 8,420,374 | ||||||||||||||||
Common units | 689,162 | 689,162 | ||||||||||||||||
Basic and diluted | 9,109,536 | 9,109,536 | ||||||||||||||||
A. | Reflects the unaudited consolidated balance sheet of the Company as of September 30, 2017 included in the Company’s Form 10-Q filed on November 9, 2017. |
B. | Represents the estimated net cash proceeds from the issuance of 1,454,107 shares of Series D cumulative convertible preferred stock ("Series D preferred stock") in connection with a proposed follow-on offering of Series D preferred stock, at a price to public of $18.36 per share, equal to the closing price of the Series D preferred stock on January 8, 2018, after deducting the underwriting discounts and commissions and other estimated expenses of the offering and assuming that the underwriters do not exercise any of their option to purchase additional shares of Series D preferred stock. |
C. | Represents the estimated pro forma effect of the Company’s $85.65 million acquisition of the Property, assuming it occurred on September 30, 2017. The Company has initially allocated the purchase price of the acquired Property to land, building and improvements, identifiable intangible assets, acquired liabilities, ground lease sandwich interest and restricted cash based on their preliminary estimated fair values. Identifiable intangibles include amounts allocated to above/below market leases, the value of in-place leases and ground lease sandwich interest, if any. The Company estimated fair value based on estimated cash flow projections that utilize appropriate discount and capitalization rates and available market information. Estimates of future cash flows are based on a number of factors including the historical operating results of the Property, known trends and specific market and economic conditions that may affect the Property. Factors considered by management in its analysis of estimating the as-if-vacant property value include an estimate of carrying costs during the expected lease-up periods considering market conditions and costs to execute similar leases. In estimating carrying costs, management includes real estate taxes, insurance and estimates of lost rentals at market rates during the expected lease-up periods, tenant demand and other economic conditions. Management also estimates costs to execute similar leases including tenant improvements and ground lease sandwich interest. Intangibles related to above/below market leases, in-place lease value and ground lease sandwich interest are recorded as acquired lease intangibles and are amortized as an adjustment to rental revenue or amortization expense, as appropriate, over the remaining terms of the underlying leases. |
A. | Reflects the unaudited consolidated statement of operations of the Company for the nine months ended September 30, 2017 included in the Company's Form 10-Q filed on November 9, 2017, excluding discontinued operations. |
B. | Amounts reflect the unaudited historical operations of the Property for the nine months ended September 30, 2017, unless otherwise noted. |
C. | Represents the estimated unaudited pro forma adjustments related to the acquisition for the period presented. |
(1) | Represents estimated amortization of above/below market leases which are being amortized on a straight-line basis over the remaining terms of the related leases. |
(2) | Represents the estimated depreciation and amortization of the buildings and related improvements, ground lease sandwich interest and in place leases and resulting from the preliminary estimated purchase price allocation in accordance with accounting principles generally accepted in the United States of America. The buildings and site improvements are being depreciated on a straight-line basis over their estimated useful lives up to 40 years. The tenant improvements, ground lease sandwich interest, and in place leases are being amortized on a straight-line basis over the remaining terms of the related leases. |
(3) | Represents expected interest expense on debt assumed at time of acquisition, which is expected to accrue interest at a rate of 4.95% per annum on $5.17 million and 4.49% per annum on $53.78 million maturing January 2026 and July 2023, respectively. |
(4) | Represents the estimated additional income (loss) attributed to the acquisition of the Property for noncontrolling interest ownership. |
D. | Reflects the consolidated statement of operations of the Company for the year ended December 31, 2016 included in the Company's Form 10-K filed on February 28, 2017 with the exception of net loss from continuing operations per share and unit and the weighted average outstanding which have been adjusted for the 1 for 8 reverse stock split effective March 31, 2017. |