Pioneer Enterprises is bankrupt and being liquidated. The note payable was called after the company missed a large balloon payment. The lending institution petitioned for
Pioneer Enterprises is bankrupt and being liquidated. The note payable was called after the company missed a large balloon payment. The lending institution petitioned for bankruptcy.
The liabilities and equity portion of Pioneers balance sheet are given below.
| Current Liabilities | |
| Accounts Payable | $6,600,000 |
| Accrued Wages | 300,000 |
| Payroll Remittances Payable | 100,000 |
| Notes Payable | 19,250,000 |
| Total Current Liabilities | $26,250,000 |
| | |
| Long-term Liabilities | |
| Bonds | $14,000,000 |
| Subordinate Debentures | 8,500,000 |
| Total Long-term Liabilities | $22,500,000 |
| | |
| Shareholders Equity | |
| Preferred Shares | $2,250,000 |
| Common Shares | 9,000,000 |
| Total Equity | $11,250,000 |
| | |
| Total Liabilities and Equity | $60,000,000 |
The book value of the assets was $60 million, but the realized value when liquidated was only $39.96 million, of which $7.88 million was from the sale of the firms office building.
No single wage claim exceeds $2,000. The bonds are secured by the office building. The debentures are subordinate to the notes payable. Inventory of $1,000,000 has been purchased in the last 30 days and the suppliers intend to reclaim it the inventory had been partially processed. The Receiver General is owed $100,000 in unpaid EI, CPP and income tax remittances.
Administration expenses associated with the liquidation were $4.8 million. The typical debt ratio in this industry is 35 percent.
REQUIRED: Complete the Excel Worksheet. Note that I have left some hints in the form of notes in the spreadsheet, so make sure you check them out.
- Determine the distribution of the proceeds in liquidation.
- How would the answer to Part 1 change if the notes payable were only $7,000,000?
- How would the answer to Part 1 change if the funds available to the unsecured creditors were $45,000,000?
- Suggest a proposal for reorganization for this company.
Note that you must modify the included spreadsheet so that if any numbers in Column B change, the rest of the spreadsheet will automatically recalculate and provide the correct numbers given this change.
0 Balance Sheet Current Liabilities Accounts Payable Accrued Wages Payroll Remittances Payable Notes Payable Total Current Liabilities $6,600,000 300,000 100,000 19,250,000 $26,250,000 Bankruptcy Worksheet, Question 1 Priority of Claims 1 Unpaid suppliers 1 2 Trust Claims - EI, CPP, Tax 3 Secured Creditors (office building) 4 Unsecured Creditors Bankruptcy Costs Wages Payable total Long-term Liabilities Bonds Subordinate Debentures Total Long-term Liabilities $14,000,000 8.500.000 $22,500,000 Assets: cash from liquidation Priority claims Available to subordinated claims Subordinated Claims (pro rated) total Shareholders' Equity Preferred Shares Common Shares Total Equity $2,250,000 9,000,000 $11,250,000 claim after pro rated claim subordination Total Liabilities and Equity $60.000.000 Jaccounts payable notes payable Secured Creditors (subordinated claims) Subordinate Debentures Total Other inputs: % of subordinated claims to be paid #DIV/0! notes payable must be paid in full before any subordinate debentures are paid Realized liquidation value of all assets (including office building): $ ( 39,960,000 Part 2: notes payable 7,000,000 Realized liquidation value of office building: $ 7,880,000 Subordinated Claims (pro rated) total claim after pro rated claim subordination Maximum individual wage claim: $ 2,000 Inventory to be reclaimed: : $ 1,000,000 accounts payable notes payable Secured Creditors (subordinated claims) Subordinate Debentures Total Unpaid EI, CPP, Tax (payroll remittances) ) $ 100,000 Liquidation expense (bankruptcy costs) % of subordinated claims to be paid #DIV/01 notes payable must be paid in full before any subordinate debentures are paid $ 4,800,000 45,000,000 typical debt ratio 35% Part 3: Available to subordinated claims Total subordinated claims: Available to shareholders 45,000,000 Preferred Shares Common Shares Total Equity Bankruptcy Worksheet, Question 1, Page 2 Part 4: possible reorganzation if debt holders believe the company has going concern value Step 1: pay off wages and turst claims liquidation value wages payable trust claims balance Step 2: allocate value of office building to secured creditors balance office building remainder Step 3: allocation to unsecured creditors total claim after subordination pro rated claim accounts payable notes payable Secured Creditors (subordinated claims) Subordinate Debentures Total % of subordinated claims to be paid * notes payable must be paid in full before any subordinate debentures are paid Step 4. calculate total claim including value of office building to secured creditors accounts payable notes Secured Creditors (subordinated claims) =0.000 -0,000 Subordinate Debentures Total Step 5: determine the new capital structure using the industry debt ratio debt equity total Step 6: determine relative claims of original note and bond holders for proration dollars percentage notes bonds total Bankruptcy Worksheet, Question 1, Page 3 Step 7: determine debt available to unsecured creditors debt from step 5 to accounts payable to secured creditors (by office blde) available to unsecured creditors Step 8: prorate unsecured debt to original note and bond holders notes bonds total Step 9: prorate equity to original note and bond holders notes bonds total Step 10: Balance sheet after restructuring Balance Sheet Current Liabilities Accounts Payable Accrued Wages Payroll Remittances Payable Notes Payable Total Current Liabilities Long-term Liabilities Bonds (secured by office building) Subordinate Debentures to original note holders to original bond holders Total long-term Liabilities Shareholders' Equity to original note holders to original bond holders Total Equity Total Liabilities and Equity Note: bonds could be convertible so holders can participate in the success of the reorganization 0 Balance Sheet Current Liabilities Accounts Payable Accrued Wages Payroll Remittances Payable Notes Payable Total Current Liabilities $6,600,000 300,000 100,000 19,250,000 $26,250,000 Bankruptcy Worksheet, Question 1 Priority of Claims 1 Unpaid suppliers 1 2 Trust Claims - EI, CPP, Tax 3 Secured Creditors (office building) 4 Unsecured Creditors Bankruptcy Costs Wages Payable total Long-term Liabilities Bonds Subordinate Debentures Total Long-term Liabilities $14,000,000 8.500.000 $22,500,000 Assets: cash from liquidation Priority claims Available to subordinated claims Subordinated Claims (pro rated) total Shareholders' Equity Preferred Shares Common Shares Total Equity $2,250,000 9,000,000 $11,250,000 claim after pro rated claim subordination Total Liabilities and Equity $60.000.000 Jaccounts payable notes payable Secured Creditors (subordinated claims) Subordinate Debentures Total Other inputs: % of subordinated claims to be paid #DIV/0! notes payable must be paid in full before any subordinate debentures are paid Realized liquidation value of all assets (including office building): $ ( 39,960,000 Part 2: notes payable 7,000,000 Realized liquidation value of office building: $ 7,880,000 Subordinated Claims (pro rated) total claim after pro rated claim subordination Maximum individual wage claim: $ 2,000 Inventory to be reclaimed: : $ 1,000,000 accounts payable notes payable Secured Creditors (subordinated claims) Subordinate Debentures Total Unpaid EI, CPP, Tax (payroll remittances) ) $ 100,000 Liquidation expense (bankruptcy costs) % of subordinated claims to be paid #DIV/01 notes payable must be paid in full before any subordinate debentures are paid $ 4,800,000 45,000,000 typical debt ratio 35% Part 3: Available to subordinated claims Total subordinated claims: Available to shareholders 45,000,000 Preferred Shares Common Shares Total Equity Bankruptcy Worksheet, Question 1, Page 2 Part 4: possible reorganzation if debt holders believe the company has going concern value Step 1: pay off wages and turst claims liquidation value wages payable trust claims balance Step 2: allocate value of office building to secured creditors balance office building remainder Step 3: allocation to unsecured creditors total claim after subordination pro rated claim accounts payable notes payable Secured Creditors (subordinated claims) Subordinate Debentures Total % of subordinated claims to be paid * notes payable must be paid in full before any subordinate debentures are paid Step 4. calculate total claim including value of office building to secured creditors accounts payable notes Secured Creditors (subordinated claims) =0.000 -0,000 Subordinate Debentures Total Step 5: determine the new capital structure using the industry debt ratio debt equity total Step 6: determine relative claims of original note and bond holders for proration dollars percentage notes bonds total Bankruptcy Worksheet, Question 1, Page 3 Step 7: determine debt available to unsecured creditors debt from step 5 to accounts payable to secured creditors (by office blde) available to unsecured creditors Step 8: prorate unsecured debt to original note and bond holders notes bonds total Step 9: prorate equity to original note and bond holders notes bonds total Step 10: Balance sheet after restructuring Balance Sheet Current Liabilities Accounts Payable Accrued Wages Payroll Remittances Payable Notes Payable Total Current Liabilities Long-term Liabilities Bonds (secured by office building) Subordinate Debentures to original note holders to original bond holders Total long-term Liabilities Shareholders' Equity to original note holders to original bond holders Total Equity Total Liabilities and Equity Note: bonds could be convertible so holders can participate in the success of the reorganization
