At the time it defaulted on its interest payments and filed for bankruptcy, the McDaniel Mining Company had the balance sheet provided in the Microsoft Excel Online file below. The court, after trying unsuccessfully to reorganize the firm, decided that the only recourse was liquidation. Sale of the fixed assets, which were pledged as collateral to the mortgage bondholders, brought in $390,000, while the current assets were sold for another $150,000. Thus, the total proceeds from the liquidation sale were $540,000. The trustee's costs amounted to $40,000; no single worker was due more than $2,000 in wages; and there were no unfunded pension plan liabilities. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

1. How much will McDaniel's shareholders receive from the liquidation? If your answer is zero, enter "0". Round your answer to the nearest dollar.

$ fill in the blank 2

2. How much will the mortgage bondholders receive? If your answer is zero, enter "0". Round your answer to the nearest dollar.

$ fill in the blank 3

3. How much will other priority claimants receive from the liquidation? Do not round intermediate calculations. Round your answers to the nearest dollar.

Claimant	Amount
Trustee's expenses	$ fill in the blank 4
Workers' wages due	$ fill in the blank 5
Governments' taxes due	$ fill in the blank 6
Total	$ fill in the blank 7

4. How much will the remaining general creditors receive from the distribution before subordination adjustment? If your answer is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest dollar.

Account	Amount Received
Accounts payable	$ fill in the blank 8
Notes payable	$ fill in the blank 9
Second mortgage bonds	$ fill in the blank 10
Debentures	$ fill in the blank 11
Subordinated debentures	$ fill in the blank 12
Total	$ fill in the blank 13

What is the effect of adjusting for subordination? If your answer is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest dollar.

Account	Amount Received after subordination adjustment
Notes payable	$ fill in the blank 14
Subordinated debentures	$ fill in the blank 15

Numbers provided on the Excel sheet:

Proceeds from sale of fixed assets			$390,000
Proceeds from sale of current assets			$150,000
Trustee's costs			$40,000
Any single worker due more than $2,000 in wages?			No
Any unfunded pension plan liabilities?			No

Current assets $400,000

Net Fixed assets $600,000

Total assets $1,000,000

Accounts Payable $50,000

Accrued Taxes 40,000

Accrued Wages 30,000

Notes Payable 180,000

Total Current Liabilities $300,000

First-Mortgage Bonds 300,000

Second-Mortgage Bonds 200,000

Debentures 200,000

Subordinated Debentures 100,000

Common Stock 50,000

Retained Earnings -150,000

Total Claims $1,000,000