Attached files

file filename
8-K - BORDERS GROUP INC 8-K 8-22-2011 - BORDERS GROUP INCform8k.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 June 26, 2011 to July 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
 
8/22/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:
6/26/11 - 7/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
   

 
FORM MOR

 
 
         
In re
BORDERS GROUP INC., et al.
 
Case No.
11-10614
 
Debtor
 
Reporting Period:
6/26/11 - 7/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 accompanying unaudited consolidated financial statements have been prepared on the basis of accounting principles applicable to a going concern, which contemplates the realization of assets and extinguishment of liabilities in the normal course of business. These financial statements do not include any adjustments that might result from the Company’s anticipated adoption of the liquidation basis of accounting. The Company intends to adopt the liquidation basis of accounting in its next Monthly Operating Report.

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:
6/26/11 - 7/30/11
 
NOTES TO MONTHLY OPERATING REPORT
General Notes (continued):
On July 13, 2011, the Company entered into an Agency Agreement (the “Agency Agreement”) with Hilco Merchant Resources, LLC, Gordon Brothers Retail Partners, LLC, SB Capital Group, LLC, Tiger Capital Group, LLC and Great American Group, LLC ("JV Parties").   The Agency Agreement provides for the sale in liquidation of the inventory, fixtures and other assets of all or substantially all of the Company’s retail book stores as well as certain other assets of the Company and its subsidiaries. On July 21, 2011, the Bankruptcy Court approved the Agency Agreement and authorized the Company to commence its sale in liquidation pursuant to the Agency Agreement.

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:
6/26/11 - 7/30/11

SCHEDULE OF CASH RECEIPTS AND DISBURSEMENTS 1
($000s)

Debtor
       
Cash Receipts
 
Combined Debtors
        $ 381,260  
 
Total Cash Receipts
    $ 381,260  
               
               
Debtor
 
Case Number
   
Cash Disbursements
 
Borders Group, Inc.
    11-10614     $ (6,853 )
Borders, Inc.
    11-10615       (322,543 )
Borders International Services, Inc.
    11-10616       -  
Borders Direct, LLC
    11-10617       (6,658 )
Borders Properties, Inc.
    11-10618       (23 )
Borders Online, Inc.
    11-10619       -  
Borders Online, LLC
    11-10620       -  
BGP (UK) Limited
    11-10621       -  
Total Cash Disbursements     $ (336,077 )
 
Notes
1 - Amounts exclude receipts/disbursements made on behalf of the Debtors that did not flow through a Debtor bank account.
 
 
FORM MOR - 1

 

In re
BORDERS GROUP INC., et al.
 
Case No.
11-10614
 
Debtor
 
Reporting Period:
6/26/11 - 7/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     $ 142  
Borders, Inc.
    11-10615  
Bank of America Corporate Depository
    4427082445       7,685  
Borders, Inc.
    11-10615  
Borders Inc. Concentration Acct
    1001744196       40,197  
Borders, Inc.
    11-10615  
Waldenbooks Concentration Acct
    66724060       199  
Borders, Inc.
    11-10615  
Waldenbooks A/R
    66724126       24  
Borders, Inc.
    11-10615  
PNC Lockbox
    4600091098       18  
                      $ 48,265  

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.
 
 
FORM MOR - 1 (CONT'D)

 

In re
BORDERS GROUP INC., et al.
 
Case No.
11-10614
 
Debtor
 
Reporting Period:
6/26/11 - 7/30/11
         

STATEMENT OF OPERATIONS
($MM)

   
Jul-11
 
       
Sales
  $ 94.7  
Other revenue
    57.5  
Total revenue
    152.2  
         
Cost of merchandise sold (includes occupancy) 1
    284.7  
Gross margin
    (132.5 )
Selling, general and administrative expenses
    38.2  
Asset impairments and other writedowns 2
    135.2  
Operating income (loss)
    (305.9 )
         
Interest expense (income)
    2.4  
Loss on extinguishment of debt
    10.1  
Total interest expense
    12.5  
         
Income (loss) from continuing operations before reorganization items and income taxes
    (318.4 )
         
Reorganization items, net
    9.4  
Income (loss) from continuing operations before income taxes
    (327.8 )
         
Income tax provision (benefit)
    0.4  
Net income (loss)
  $ (328.2 )

Notes
1 - Includes a charge to reduce the value of inventory to reflect an anticipated recovery value less than cost, as a result of the Agency Agreement.
2 - During the period it was determined that long-lived assets met the criteria for classification as held for sale, and the Company recorded impairment charges to adjust all long-lived assets to the lower of their carrying value or their fair value less costs to sell.
 
 
FORM MOR - 2

 

In re
BORDERS GROUP INC., et al.
 
Case No.
11-10614
 
Debtor
 
Reporting Period:
6/26/11 - 7/30/11

BALANCE SHEET
($MM)

   
Jul-11
 
       
Assets
 
Current assets:
     
Cash and cash equivalents
  $ 114.5  
Merchandise inventories
    208.5  
Accounts receivable and other current assets
    62.8  
Total current assets
    385.8  
         
Property and equipment, held for sale
    10.1  
Other assets
    22.3  
Total assets
  $ 418.2  
         
Liabilities and Stockholders' Equity (Deficit)
 
Current liabilities:
       
Short-term capital lease liability
    1.1  
Trade accounts payable
    7.5  
Accrued payroll and other liabilities
    338.7  
Taxes, including income taxes
    33.0  
Total current liabilities
    380.3  
         
Long-term capital lease liability
    0.8  
Other long-term liabilities
    134.4  
Liabilities subject to compromise
    607.5  
Total liabilities
    1,123.0  
         
Stockholders' equity (deficit):
       
Common stock
    187.4  
Retained deficit
    (892.2 )
Total stockholders' equity (deficit)
    (704.8 )
         
Total liabilities and stockholders' equity (deficit)
  $ 418.2  

 
FORM MOR - 3

 

In re
BORDERS GROUP INC., et al.
 
Case No.
 
11-10614
 
Debtor
 
Reporting Period:
 
6/26/11 - 7/30/11

STATUS OF POST-PETITION TAXES 1, 3
($000s)

Federal
 
Beginning
Tax
   
Amount Withheld
and/or Accrued
   
Amount
Paid
   
Ending
Tax
 
Withholding
  $ -     $ 1,877     $ 1,877     $ -  
FICA-Employee
    -       1,043       1,043       -  
FICA-Employer
    -       1,410       1,410       -  
Unemployment
    178       (50 )     178       (50 )
Total Federal Taxes
  $ 178     $ 4,280     $ 4,508     $ (50 )
                                 
State and Local
                               
Withholding
  $ 54     $ 566     $ 544     $ 76  
Sales
    -       5,237       5,237       -  
Unemployment
    987       275       987       275  
Business Licenses
    -       25       25       -  
Real Property 2
    -       -       -       -  
Personal Property
    -       23       23       -  
Income/Franchise
    -       17       17       -  
Total State and Local Taxes
  $ 1,041     $ 6,143     $ 6,833     $ 351  
                                 
Total Taxes
  $ 1,219     $ 10,423     $ 11,341     $ 301  

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.
 
STATUS OF POST-PETITION DEBTS1
($000s)

   
Aged by Due Date
 
Description
 
Current
      0-30       31-60       61-90       91-120    
Over 120
   
Total
 
AP Merchandising 2, 3
  $ 14,758     $ 14,700     $ (31,512 )   $ (1,461 )   $ (1,874 )   $ -     $ (5,389 )
AP Other
    2,169       588       (358 )     (54 )     30       -       2,375  
Total Post-Petition Debts
  $ 16,927     $ 15,288     $ (31,870 )   $ (1,515 )   $ (1,844 )   $ -     $ (3,014 )
 
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.
 
 
FORM MOR - 4

 
 
In re
BORDERS GROUP INC., et al.
 
Case No.
11-10614
 
Debtor
 
Reporting Period:
6/26/11 - 7/30/11

ACCOUNTS RECEIVABLE RECONCILIATION AND AGING 1
($000s)

Accounts Receivable Reconciliation
 
Amount
 
Total Accounts Receivable at the beginning of the reporting period
  $ 4,375  
Plus:  Amounts billed during the period
    716  
Less:  Amounts collected during the period
    (1,197 )
Less:  Amounts written off or returned during the period
    (809 )
Less:  Bad Debt Estimate
    (276 )
Change in store accounts receivable, net
    (1,566 )
Total Accounts Receivable at the end of the reporting period
  $ 2,809  

Accounts Receivable Aging
 
Amount
 
0-30 days old
  $ 1,710  
31-60 days old
    124  
61-90 days old
    378  
91-120 days old
    408  
121+ days old
    465  
Total Aged Accounts Receivable
    3,085  
Less:  Bad Debts (Amounts considered uncollectible)
    (276 )
Net Accounts Receivable
  $ 2,809  
 
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).
 
 
FORM MOR - 5

 

In re
BORDERS GROUP INC., et al.
 
Case No.
11-10614
 
Debtor
 
Reporting Period:
6/26/11 - 7/30/11

PAYMENTS TO INSIDERS 1

Name
Type of Payment
 
Amount Paid 2
   
Total Paid to Date
 
Scott Henry
 Employment Agreement Signing Incentive
  $ 50,000     $ 100,000  
Glen Tomaszewski
 Employment Agreement Transition Incentive
    50,000       100,000  
Michele Cloutier
 Employment Agreement Signing Incentive
    -       50,000  
Total Payments to Insiders
  $ 100,000     $ 250,000  

Notes
1 - Payments to insiders excludes ordinary wages, board fees, benefits and expense reimbursements that occurred during the reporting period.
2 - Represents payments made from June 26, 2011 - July 30, 2011.
 
PAYMENTS TO PROFESSIONALS
 
Name
Date of
Court Order
Authorizing Payment
 
Amount
Approved 1
   
Amount
Paid 2
   
Total Paid
To Date 1
   
Total Incurred
& Unpaid
 
AP Services, LLC
March 16, 2011
  $ 7,871,099     $ 3,350,983     $ 7,871,099     $ -  
Baker & McKenzie
March 15, 2011
    261,802       25,396       210,195       51,607  
BDO USA, LLP
April 7, 2011
    1,497,800       214,407       1,204,934       292,866  
Deloitte Tax LLP
April 7, 2011
    355,372       40,768       284,079       71,293  
Deloitte Consulting LLP
April 7, 2011
    458,305       78,770       378,542       79,763  
Deloitte Consulting LLP
April 7, 2011
    694,334       42,957       559,845       134,489  
Dickinson Wright PLLC
March 15, 2011
    392,327       98,611       315,141       77,186  
DJM Realty Services, LLC
March 16, 2011
    279,562       91,971       226,659       52,903  
Ernst & Young LLP
April 7, 2011
    284,964       21,793       194,755       90,209  
The Garden City Group, Inc.
February 17, 2011
    817,718       19,401       793,690       24,028  
Jefferies & Company, Inc.
March 16, 2011
    655,617       163,001       525,617       130,000  
Kasowitz, Benson, Torres & Friedman LLP
March 15, 2011
    2,510,020       545,138       1,978,633       531,387  
Lowenstein Sandler PC
April 7, 2011
    1,046,466       244,106       818,897       227,569  
Mercer (US) Inc.
April 7, 2011
    82,791       -       36,536       46,255  
Total Payments to Professionals
  $ 17,208,177     $ 4,937,302     $ 15,398,622     $ 1,809,555  

Notes
1 - Represents amounts approved and payments made from the date of each firm's retention through July 30, 2011.
2 - Represents payments made from June 26, 2011 - July 30, 2011.
 
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     $ 36,615  
DIP Principal - Revolver 1
    N/A       117,981  
DIP Interest - Term Loan
  $ 39       39  
DIP Interest - Revolver
  $ 441       441  
Leases Payable 2
  $ 11,550       22,559  
Adequate Assurance Payments - Utilities
    N/A       -  
Total Payments
    $ 177,635  

Notes
1 - Principal payments on the DIP Term Loan and Revolver include payoff of entire outstanding balances.  Per the Agency Agreement, these payments were made directly from the JV Parties to the DIP Lenders.
2 - Lease payments reflect certain payments made in late July 2011 for rent due in early August 2011.
 
 
FORM MOR - 6

 

In re
BORDERS GROUP INC., et al.
 
Case No.
11-10614
 
Debtor
 
Reporting Period:
6/26/11 - 7/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 Pre-petition Taxes and Assessments entered under Docket #388
   
on March 15, 2011.
   
 
 
FORM MOR - 7