At the time it defaulted on its interest payments and filed for bankruptcy, the McDaniel Mining Company had the balance sheet shown below (in thousands of dollars). The court, after trying unsuccessfully to reorganize the firm, decided that the only recourse was liquidation under Chapter 7. Sale of the fixed assets, which were pledged as collateral to the mortgage bondholders, brought in $400,000, while the current assets were sold for another $200,000. Thus, the total proceeds from the liquidation sale were $600,000. The trustees costs amounted to $50,000; no single worker was due more than $2,000 in wages; and there were no unfunded pension plan liabilities. Current assets $ 400 Accounts payable $ 50 Net fixed assets 600 Accrued taxes 40 Accrued wages 30 Notes payable 180 Total current liabilities $ 300 First-mortgage bonds(a) 300 Second-mortgage bonds(a) 200 Debentures 200 Subordinated debentures(b)100 Common stock 50 Retained earnings (150) Total assets $1,000 Total claims $1,000 (a)All fixed assets are pledged as collateral to the mortgage bonds. (b) Subordinated to notes payable only. SHOW ALL WORK IN EXCEL PLEASE a. How much will McDaniels shareholders receive from the liquidation? (Answer $0) b. How much will the mortgage bondholders receive? (Answer - First mortgage holders, $300,000; Second mortgage holders, $100,000 plus $12,700 as a general claimant.) c. Who are the other priority claimants (in addition to the mortgage bondholders)? How much will they receive from the liquidation? ( Answer - Trustees expenses, $50,000; Wages due, $30,000; Taxes due, $40,000.) d. Who are the remaining general creditors? How much will each receive from the distribution before subordination adjustment? What is the effect of adjusting for subordination? (Answer - Before subordination Accounts payable = $6,350; Notes payable = $22,860; Second mortgage = $12,700 + $100,000; Debentures = $25,400; Sub. debentures = $12,700. After subordination Notes payable = $35,560; Sub. debentures = $0.) Brigham, Eugene F.; Ehrhardt, Michael C. (2013-01-28). Financial Management: Theory & Practice (Finance Titles in the Brigham Family) (Page 971). Cengage Textbook. Kindle Edition