Attached files
| file | filename |
|---|---|
| 8-K - BORDERS GROUP 8-K 5-20-2011 - BORDERS GROUP INC | form8k.htm |
Exhibit 99.1
|
United States Bankruptcy Court
|
||
|
Southern District of New York
|
||
|
X
|
||
|
In re:
|
:
|
Chapter 11
|
|
:
|
||
|
Borders Group, Inc. et al.
|
:
|
Case No. 11-10614
|
|
:
|
||
|
Debtors
|
:
|
|
|
X
|
Monthly Operating Report for the Period
From March 27, 2011 to April 30, 2011
|
Debtors' Address:
|
100 Phoenix Drive
|
|
|
Ann Arbor, MI 48108-2202
|
|
|
Telephone: 734-477-1100
|
|
Debtors' Attorneys:
|
David M. Friedman
|
|
|
1633 Broadway
|
|
|
New York, New York 10019
|
|
|
Telephone: (212) 506-1700
|
This Monthly Operating Report ("MOR") has been prepared solely for the purposes of complying with the monthly reporting requirements applicable in these Chapter 11 cases and is in a format that the Debtors believe is acceptable to the United States Trustee. The financial information contained herein is limited in scope and covers a limited time period. Moreover, such information is preliminary and unaudited, and is not prepared in accordance with accounting principles generally accepted in the United States ("GAAP").
I declare under penalty of perjury that this report and the attached documents are true and correct to the best of my knowledge and belief.
| /s/Glen Tomaszewski |
5/20/2011
|
|
|
Glen Tomaszewski
|
||
|
Vice President, Chief Accounting Officer and Controller
|
||
|
Borders Group, Inc.
|
||
UNITED STATES BANKRUPTCY COURT
SOUTHERN DISTRICT OF NEW YORK
|
In re
|
BORDERS GROUP INC., et al.
|
Case No.
|
11-10614
|
|
|
Debtor
|
Reporting Period:
|
3/27/11 - 4/30/11
|
||
|
Federal Tax I.D. #
|
38-3294588
|
CORPORATE MONTHLY OPERATING REPORT
|
REQUIRED
DOCUMENTS
|
FORM NO.
|
DOCUMENT
ATTACHED
|
EXPLANATION
ATTACHED
|
|||
|
Schedule of Cash Receipts and Disbursements
|
MOR-1
|
x
|
||||
|
Bank Reconciliation (or copies of debtor's bank reconciliations)
|
MOR-1
|
x
|
||||
|
Copies of bank statements
|
x
|
|||||
|
Cash disbursements journals
|
x
|
|||||
|
Statement of Operations
|
MOR-2
|
x
|
||||
|
Balance Sheet
|
MOR-3
|
x
|
||||
|
Status of Post-Petition Taxes
|
MOR-4
|
x
|
||||
|
Copies of IRS Form 6123 or payment receipt
|
x
|
|||||
|
Copies of tax returns filed during reporting period
|
x
|
|||||
|
Summary of Unpaid Post-Petition Debts
|
MOR-4
|
x
|
||||
|
Listing of Aged Accounts Payable
|
MOR-4
|
x
|
||||
|
Accounts Receivable Reconciliation and Aging
|
MOR-5
|
x
|
||||
|
Taxes Reconciliation and Aging (See MOR-7)
|
x
|
|||||
|
Payments to Insiders and Professionals
|
MOR-6
|
x
|
||||
|
Post-Petition Status of Secured Notes, Leases Payable
|
MOR-6
|
x
|
||||
|
Debtor Questionnaire
|
MOR-7
|
x
|
|
In re
|
BORDERS GROUP INC., et al.
|
Case No.
|
11-10614
|
|
|
Debtor
|
Reporting Period:
|
3/27/11 - 4/30/11
|
NOTES TO MONTHLY OPERATING REPORT
The Monthly Operating Report includes activity from the following Debtors:
|
Debtor
|
Case Number
|
|
Borders Group, Inc.
|
11-10614
|
|
Borders, Inc.
|
11-10615
|
|
Borders International Services, Inc.
|
11-10616
|
|
Borders Direct, LLC
|
11-10617
|
|
Borders Properties, Inc.
|
11-10618
|
|
Borders Online, Inc.
|
11-10619
|
|
Borders Online, LLC
|
11-10620
|
|
BGP (UK) Limited
|
11-10621
|
General Notes:
The financial statements and supplemental information contained herein are preliminary, unaudited, and may not comply in all material respects with accounting principles generally accepted in the United States ("GAAP"). In addition, the financial statements and supplemental information contained herein represent condensed combined information.
The unaudited consolidated financial statements have been derived from the books and records of the Debtors and include the results of operations for non-Debtor affiliates, which amounts are immaterial. This information has not been subject to certain procedures that would typically be applied to financial information in accordance with GAAP, and upon application of such procedures the financial information could be subject to material change.
The financial information contained herein is presented on a preliminary and unaudited basis and remains subject to future adjustment.
The results of operations contained herein are not necessarily indicative of results which may be expected for any other period or for the full year and may not necessarily reflect the consolidated results of operations and financial position of the Debtors in the future.
|
In re
|
BORDERS GROUP INC., et al.
|
Case No.
|
11-10614
|
|
|
Debtor
|
Reporting Period:
|
3/27/11 - 4/30/11
|
NOTES TO MONTHLY OPERATING REPORT
MOR-1
Cash is received as described in the Debtors' motion to approve their cash management system and is consistent with the Debtors' cash management practices. Cash receipts and disbursements related to intercompany transfers among the Debtor entities have also been excluded from the analysis.
MOR - 4
The Debtors believe they are paying all undisputed taxes and preparing and filing all tax returns when due or obtaining extensions where necessary.
MOR-6
The Debtors have not included any payments of normal course wages, benefits or the payment of board fees to insiders. The Debtors have also not reported payments to professionals utilized in the ordinary course of business.
MOR-7
The Debtors have paid certain pre-petition liabilities in accordance with orders approved by the Bankruptcy Court authorizing such payments. The Debtors believe that all undisputed post-petition accounts payable have been and are being paid according to agreed upon terms specific to each vendor and/or service provider. Any aged amounts represent items subject to valid disputes, and certain items which have been paid subsequent to the end of the reporting period.
|
In re
|
BORDERS GROUP INC., et al.
|
Case No.
|
11-10614
|
|
|
Debtor
|
Reporting Period:
|
3/27/11 - 4/30/11
|
SCHEDULE OF CASH RECEIPTS AND DISBURSEMENTS 1
($000s)
|
Debtor
|
Cash Receipts
|
|||
|
Combined Debtors
|
$ | 401,869 | ||
| Total Cash Receipts | $ | 401,869 | ||
|
Debtor
|
Case Number
|
Cash Disbursements
|
||||||
|
Borders Group, Inc.
|
11-10614 | $ | (8,856 | ) | ||||
|
Borders, Inc.
|
11-10615 | (389,337 | ) | |||||
|
Borders International Services, Inc.
|
11-10616 | - | ||||||
|
Borders Direct, LLC
|
11-10617 | (6,763 | ) | |||||
|
Borders Properties, Inc.
|
11-10618 | (15 | ) | |||||
|
Borders Online, Inc.
|
11-10619 | - | ||||||
|
Borders Online, LLC
|
11-10620 | - | ||||||
|
BGP (UK) Limited
|
11-10621 | - | ||||||
| Total Cash Disbursements | $ | (404,971 | ) | |||||
Notes
1 - Amounts exclude receipts/disbursements made on behalf of the Debtors that did not flow through a Debtor bank account.
|
In re
|
BORDERS GROUP INC., et al.
|
Case No.
|
11-10614
|
|
|
Debtor
|
Reporting Period:
|
3/27/11 - 4/30/11
|
BANK RECONCILIATIONS 1, 2, 3
($000s)
|
Debtor
|
Case Number
|
Bank and Account Description
|
Bank Account No.
|
Bank Balance
|
||||||||
|
Borders Group, Inc.
|
11-10614 |
BGI Concentration Account
|
1001738167 | $ | 150 | |||||||
|
Borders, Inc.
|
11-10615 |
Bank of America Corporate Depository
|
4427082445 | 2,248 | ||||||||
|
Borders, Inc.
|
11-10615 |
Borders Inc. Concentration Acct
|
1001744196 | 47 | ||||||||
|
Borders, Inc.
|
11-10615 |
Waldenbooks Concentration Acct
|
66724060 | 498 | ||||||||
|
Borders, Inc.
|
11-10615 |
Waldenbooks A/R
|
66724126 | 7 | ||||||||
| $ | 2,950 | |||||||||||
Notes
1 - The Debtors have not included copies of bank statements or cash disbursement journals due to the voluminous nature of these reports.
2 - The Debtors reconcile their bank accounts on a monthly basis.
3 - The Debtors have excluded accounts with no balance as of the end of the reporting period and have also excluded accounts that receive cash deposits from local stores and corporate/institutional customers, which amounts are regularly swept either to the Debtors' primary accounts listed above or directly to its secured lenders to repay borrowings under the DIP credit facility.
4 - Account was not included in March MOR because the Debtors had no control over funds. Account is now included as the Debtors have subsequently gained access to this account.
|
In re
|
BORDERS GROUP INC., et al.
|
Case No.
|
11-10614
|
|
|
Debtor
|
Reporting Period:
|
3/27/11 - 4/30/11
|
STATEMENT OF OPERATIONS
($MM)
|
Apr-11
|
||||
|
Sales
|
$ | 101.0 | ||
|
Other revenue
|
72.1 | |||
|
Total revenue
|
173.1 | |||
|
Cost of merchandise sold (includes occupancy)
|
165.6 | |||
|
Gross margin
|
7.5 | |||
|
Selling, general and administrative expenses
|
37.2 | |||
|
Operating income (loss)
|
(29.7 | ) | ||
|
Interest expense (income)
|
2.4 | |||
|
Income (loss) from continuing operations before reorganization items and income taxes
|
(32.1 | ) | ||
|
Reorganization items, net 1
|
98.4 | |||
|
Income (loss) from continuing operations before income taxes
|
(130.5 | ) | ||
|
Income tax provision (benefit)
|
1.0 | |||
|
Income (loss) from continuing operations
|
(131.5 | ) | ||
|
Income (loss) from discontinued operations, net of income tax
|
(0.7 | ) | ||
|
Net income (loss)
|
$ | (132.2 | ) | |
Notes
1 - Reorganization items for the reported period include amounts related to estimated claims arising from the closure of certain stores and the rejection of related leases.
|
In re
|
BORDERS GROUP INC., et al.
|
Case No.
|
11-10614
|
|
|
Debtor
|
Reporting Period:
|
3/27/11 - 4/30/11
|
BALANCE SHEET
($MM)
|
Apr-11
|
||||
|
Assets
|
||||
|
Current assets:
|
||||
|
Cash and cash equivalents
|
$ | 16.9 | ||
|
Merchandise inventories
|
452.5 | |||
|
Accounts receivable and other current assets
|
65.5 | |||
|
Total current assets
|
534.9 | |||
|
Property and equipment, net of accumulated depreciation
|
171.4 | |||
|
Other assets
|
30.4 | |||
|
Total assets
|
$ | 736.7 | ||
|
Liabilities and Stockholders' Equity (Deficit)
|
||||
|
Current liabilities:
|
||||
|
Short term debt-credit facility
|
$ | 103.2 | ||
|
Capital lease liability
|
1.2 | |||
|
Trade accounts payable
|
9.9 | |||
|
Accrued payroll and other liabilities
|
188.1 | |||
|
Taxes, including income taxes
|
29.9 | |||
|
Total current liabilities
|
332.3 | |||
|
Long-term debt
|
1.0 | |||
|
Other long-term liabilities
|
162.3 | |||
|
Liabilities subject to compromise
|
579.5 | |||
|
Total liabilities
|
1,075.1 | |||
|
Stockholders' equity (deficit):
|
||||
|
Common stock
|
188.7 | |||
|
Retained deficit
|
(527.1 | ) | ||
|
Total stockholders' equity (deficit)
|
(338.4 | ) | ||
|
Total liabilities and stockholders' equity (deficit)
|
$ | 736.7 | ||
|
In re
|
BORDERS GROUP INC., et al.
|
Case No.
|
11-10614
|
|
|
Debtor
|
Reporting Period:
|
3/27/11 - 4/30/11
|
STATUS OF POST-PETITION TAXES 1, 3, 4
($000s)
|
Federal
|
Beginning
Tax
|
Amount Withheld
and/or Accrued
|
Amount
Paid
|
Ending
Tax
|
||||||||||||
|
Withholding
|
$ | - | $ | 1,698 | $ | 1,698 | $ | - | ||||||||
|
FICA-Employee
|
- | 1,031 | 1,031 | - | ||||||||||||
|
FICA-Employer
|
- | 1,396 | 1,396 | - | ||||||||||||
|
Unemployment
|
167 | 85 | 167 | 85 | ||||||||||||
|
Total Federal Taxes
|
$ | 167 | $ | 4,210 | $ | 4,292 | $ | 85 | ||||||||
|
State and Local
|
||||||||||||||||
|
Withholding
|
$ | 143 | $ | 563 | $ | 663 | $ | 43 | ||||||||
|
Sales
|
- | 11,072 | 11,072 | - | ||||||||||||
|
Unemployment
|
867 | 459 | 866 | 460 | ||||||||||||
|
Business Licenses
|
- | - | - | - | ||||||||||||
|
Real Property 2
|
- | - | - | - | ||||||||||||
|
Personal Property
|
- | 997 | 997 | - | ||||||||||||
|
Income/Franchise
|
- | 102 | 102 | - | ||||||||||||
|
Total State and Local Taxes
|
$ | 1,010 | $ | 13,193 | $ | 13,700 | $ | 503 | ||||||||
|
Total Taxes
|
$ | 1,177 | $ | 17,403 | $ | 17,992 | $ | 588 | ||||||||
Notes
1 - The Debtors have not included copies of Form 6123 and tax returns filed during this period due to the voluminous nature of these reports.
2 - The Debtors do not own any real property. Real estate taxes paid by the Debtors are paid as part of an underlying lease obligation and the failure to pay such lease payments would not result in claims by the taxing authority against the Debtors.
3 - The Debtors believe they are paying all undisputed taxes and preparing and filing all tax returns when due or obtaining extensions where necessary.
4 - Summary of post-petition tax payments reflects the period from April 1, 2011 - April 30, 2011.
STATUS OF POST-PETITION DEBTS 1
($000s)
|
Aged by Due Date
|
||||||||||||||||||||||||||||
|
Description
|
Current
|
0-30 | 31-60 | 61-90 | 91-120 |
Over 120
|
Total
|
|||||||||||||||||||||
|
AP Merchandising 2, 3
|
$ | (13,588 | ) | $ | 11,956 | $ | (3,624 | ) | $ | (2,379 | ) | $ | - | $ | - | $ | (7,635 | ) | ||||||||||
|
AP Other 4
|
(10,376 | ) | 227 | 59 | (1 | ) | - | - | (10,091 | ) | ||||||||||||||||||
|
Total Post-Petition Debts
|
$ | (23,964 | ) | $ | 12,183 | $ | (3,565 | ) | $ | (2,380 | ) | $ | - | $ | - | $ | (17,726 | ) | ||||||||||
Explain how and when Debtor intends to pay any past due post-petition debts.
Notes
1 - The Debtors believe they are paying all undisputed post-petition obligations according to terms. Aged amounts represent items subject to valid disputes, and certain items which have been paid subsequent to the end of the reporting period.
2 - The amounts in this table include payments made to vendors in advance of our receipt of goods. Because such payments are classified as “Accounts receivable and other current assets” in the accompanying Balance Sheet under Form MOR-3, the amounts reported under this table will differ from those reported as “Trade accounts payable” on the Balance Sheet. In addition, the “Trade accounts payable” amount includes accruals made for merchandise received prior to the Balance Sheet date, but for which no invoice had been received. Certain of these accruals are not included in the amounts shown under this Form MOR-4.
3 - The Debtors' net debit accounts payable balance for AP Merchandising is primarily due to prepayments made to publishers for post-petition orders.
4 - The Debtors' net debit accounts payable balance for AP Other is primarily due to prepaid rents.
|
In re
|
BORDERS GROUP INC., et al.
|
Case No.
|
11-10614
|
|
|
Debtor
|
Reporting Period:
|
3/27/11 - 4/30/11
|
ACCOUNTS RECEIVABLE RECONCILIATION AND AGING 1
($000s)
|
Accounts Receivable Reconciliation
|
Amount
|
|||
|
Total Accounts Receivable at the beginning of the reporting period
|
$ | 6,382 | ||
|
Plus: Amounts billed during the period
|
1,698 | |||
|
Less: Amounts collected during the period
|
(2,437 | ) | ||
|
Less: Amounts written off or returned during the period
|
(649 | ) | ||
|
Less: Bad Debt Estimate
|
(285 | ) | ||
|
Change in store accounts receivable, net
|
(1,673 | ) | ||
|
Total Accounts Receivable at the end of the reporting period
|
$ | 4,709 | ||
|
Accounts Receivable Aging
|
Amount
|
|||
|
0-30 days old
|
$ | 2,543 | ||
|
31-60 days old
|
1,281 | |||
|
61-90 days old
|
367 | |||
|
91-120 days old
|
237 | |||
|
121+ days old
|
566 | |||
|
Total Aged Accounts Receivable
|
4,994 | |||
|
Less: Bad Debts (Amounts considered uncollectible)
|
(285 | ) | ||
|
Net Accounts Receivable
|
$ | 4,709 | ||
Notes
1 - "Accounts receivable and other current assets” in the accompanying Balance Sheet under Form MOR-3 includes certain items not included in this table, including various prepaid asset amounts (including prepaid debt issuance costs relating to our debtor-in-possession financing facility, prepaid merchandise inventories, and prepaid supplies).
|
In re
|
BORDERS GROUP INC., et al.
|
Case No.
|
11-10614
|
|
|
Debtor
|
Reporting Period:
|
3/27/11 - 4/30/11
|
PAYMENTS TO INSIDERS 1
|
Name
|
Type of Payment
|
Amount Paid
|
Total Paid to Date
|
||||||
|
None
|
$ | - | $ | - | |||||
|
Total Payments to Insiders
|
$ | - | $ | - | |||||
Notes
1 - Payments to insiders excludes ordinary wages, board fees, benefits and expense reimbursements that occurred during the reporting period.
PAYMENTS TO PROFESSIONALS
|
Name
|
Date of
Court Order
Authorizing Payment
|
Amount
Approved
|
Amount
Paid
|
Total Paid
To Date
|
Total Incurred
& Unpaid
|
||||||||||||
|
AP Services, LLC
|
March 16, 2011
|
$ | 863,741 | $ | 863,741 | $ | 863,741 | $ | - | ||||||||
|
Mercer (US) Inc. 1
|
March 7, 2011
|
23,815 | 23,815 | 23,815 | - | ||||||||||||
|
Total Payments to Professionals
|
$ | 887,556 | $ | 887,556 | $ | 887,556 | $ | - | |||||||||
Notes
1 - The payment to Mercer (US) Inc. was for consulting services related to formulation of the employee incentive program approved by the Bankruptcy Court on April 22, 2011. These services were included in the Mercer (US) Inc. fee application filed with the Bankruptcy Court on April 20, 2011. The above amount has been deducted from undisputed amounts paid to Mercer (US) Inc. for such application.
POST-PETITION STATUS OF SECURED NOTES, LEASES PAYABLE
AND ADEQUATE PROTECTION PAYMENTS
($000s)
|
Name of Creditor
|
Scheduled Monthly
Payment Due
|
Amount Paid
During Reporting Period
|
||||||
|
DIP Principal - Term Loan 1
|
N/A | $ | 4,572 | |||||
|
DIP Principal - Revolver 2
|
N/A | - | ||||||
|
DIP Interest - Term Loan
|
$ | 580 | 580 | |||||
|
DIP Interest - Revolver
|
$ | 50 | 50 | |||||
|
Leases Payable 3
|
$ | 18,782 | 22,161 | |||||
|
Adequate Assurance Payments - Utilities
|
N/A | 993 | ||||||
|
Total Payments
|
$ | 28,356 | ||||||
Notes
1 - Principal payments on the DIP term loan are made based on proceeds from FF&E sales, net of fees.
2 - Principal repayments are based on daily sweeps activity. Revolver balance increased by approximately $11 million during the reporting period.
3 - Lease payments reflect certain payments made in late April 2011 for rent due in early May 2011.
|
In re
|
BORDERS GROUP INC., et al.
|
Case No.
|
11-10614
|
||
|
Debtor
|
Reporting Period:
|
3/27/11 - 4/30/11
|
DEBTOR QUESTIONNAIRE
| Must be completed each month. If the answer to any of the questions is "Yes", provide a detailed explanation of each item. Attach additional sheets if necessary. |
Yes
|
No
|
||
|
1
|
Have any assets been sold or transferred outside the normal course of business this reporting period?
|
X
|
||
|
2
|
Have any funds been disbursed from any account other than a debtor in possession account this reporting period?
|
X
|
||
|
3
|
Is the Debtor delinquent in the timely filing of any post-petition tax returns?
|
X
|
||
|
4
|
Are workers compensation, general liability or other necessary insurance coverages expired or cancelled, or has the debtor received notice of expiration or cancellation of such policies?
|
X
|
||
|
5
|
Is the Debtor delinquent in paying any insurance premium payment?
|
X
|
||
|
6
|
Have any payments been made on pre-petition liabilities this reporting period?
|
X
|
||
|
7
|
Are any post-petition receivables (accounts, notes or loans) due from related parties?
|
X
|
||
|
8
|
Are any post-petition payroll taxes past due?
|
X
|
||
|
9
|
Are any post-petition State or Federal income taxes past due?
|
X
|
||
|
10
|
Are any post-petition real estate taxes past due?
|
X
|
||
|
11
|
Are any other post-petition taxes past due?
|
X
|
||
|
12
|
Have any pre-petition taxes been paid during this reporting period?
|
X
|
||
|
13
|
Are any amounts owed to post-petition creditors delinquent?
|
X
|
||
|
14
|
Are any wages payments past due?
|
X
|
||
|
15
|
Have any post-petition loans been received by the Debtor from any party?
|
X
|
||
|
16
|
Is the Debtor delinquent in paying any US Trustee fees?
|
X
|
||
|
17
|
Is the Debtor delinquent with any court ordered payments to attorneys or other professionals?
|
X
|
||
|
18
|
Have the owners or shareholders received any compensation outside of the normal course of business?
|
X
|
||
Explanations
|
1
|
The Debtors have sold assets pursuant to the Order Approving Agency Agreement, Store Closing Sales and Related Relief entered under Docket #91 on February 18, 2011.
|
|
6
|
The Debtors have made payments on account of pre-petition liabilities in accordance with Orders of the Bankruptcy Court specifically authorizing payment of such liabilities.
|
|
10
|
The Debtors do not own real property.
|
|
12
|
The Debtors have paid certain pre-petition taxes as permitted under the Final Order Pursuant to 11 U.S.C. Section 105(a), 363(b), 507(a)(8) and 541 and Fed. R. Bankr. P. 6003 and 6004 Authorizing Debtors to Pay Prepetition Taxes and Assessments entered under Docket #388 on March 15, 2011.
|