Spreadsheet Data included in photos

d. 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. 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. Funds avallable for distribution to general credicoes Pro Rasa Distribution Belore Subordination Adjustmert Distibution to General Creditor: Proceeds from sale of foxed assets Proceods from sale of current assets Trustee's costs Any single worker due more than $2,000 in wapos? Any unfunded pension plan liablities? Balance Sheet: Current assete Net foced assets Total assets Noles - Ail fixed assets are pledged as collateral to the motgoge bonds "Subordinated to notes payable only $480,000$290,000$35,000NoNo Accounts payable Accrued taves Acerued wages Noles parabie Total current fiabilices 600,000 First-mortgage bonds" Second-mortgage bonds" Debentures Subordinated debentures * Common stock Retained eamings Total clams 23 Notes: 24 - All fixed assets are pledged as collateral to the mortgage bonds. 25 "Subordinated to noles payable cnly. 27 Distribution to Common Shareholders: 28 |Amount distributed to common shareholders 30 Distrbution to Mortgoge Bandhalders: 31 Proceeds from sale of fored assets 32 Less: 33 First mortgage (paid from sale of fixed assets) 34 Second morigage (paid from sale of fixed assets) 35 Total funds distributed to morlgsge boodhoiders 37 Funds avalable from foxed assets proceeds after distribution to bondhoiders $480,000 $460,000 Formulas IN/A $460,000 Distroution to Prionity Claimants: Proceeds trom sale of assets after distribution to mortgape bondholders Less: Fees and expenses of bankruptcy Wages due to workers within 3 months of barkiupley Taxes due to federal, state, and local povernments Tolal funds distributed to prenty claimants Funds avolable for datribution to general creditors 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 $480,000, while the current assets were sold for another $290,000. Thus, the total proceeds from the liquidation sale were $770,000. The trustee's costs amounted to $35,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. Open spreadsheet a. How much will McDaniel's shareholders receive from the liquidation? If your answer is zero, enter " 0 ". Round your answer to the nearest dollar: $ b. How much will the mortgage bondholders recelve? if your answer is zero, enter " 0 *. Round your answer to the nearest dollar: $ c. How much will other priority claimants receive from the liquidation? Do not round intermediate calculations. Round your answers to the nearest dollar. 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 flle 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 $480,000, while the current assets were sold for another $290,000. Thus, the total proceeds from the liquidation sale were $770,000. The trustee's costs amounted to $35,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. Open spreadsheet a. How much will McDaniel's shareholders recelve from the liquidation? If your answer is zero, enter "0". Round your answer to the nearest dollar. b. How much will the mortgage bondholders receive? If your answer is zero, enter "0", Round your answer to the nearest dollar. c. How much will other priority claimants recelve from the liquidation? Do not round intermediate calculations. Round your answers to the nearest dollar. d. 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. 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. Funds avallable for distribution to general credicoes Pro Rasa Distribution Belore Subordination Adjustmert Distibution to General Creditor: Proceeds from sale of foxed assets Proceods from sale of current assets Trustee's costs Any single worker due more than $2,000 in wapos? Any unfunded pension plan liablities? Balance Sheet: Current assete Net foced assets Total assets Noles - Ail fixed assets are pledged as collateral to the motgoge bonds "Subordinated to notes payable only $480,000$290,000$35,000NoNo Accounts payable Accrued taves Acerued wages Noles parabie Total current fiabilices 600,000 First-mortgage bonds" Second-mortgage bonds" Debentures Subordinated debentures * Common stock Retained eamings Total clams 23 Notes: 24 - All fixed assets are pledged as collateral to the mortgage bonds. 25 "Subordinated to noles payable cnly. 27 Distribution to Common Shareholders: 28 |Amount distributed to common shareholders 30 Distrbution to Mortgoge Bandhalders: 31 Proceeds from sale of fored assets 32 Less: 33 First mortgage (paid from sale of fixed assets) 34 Second morigage (paid from sale of fixed assets) 35 Total funds distributed to morlgsge boodhoiders 37 Funds avalable from foxed assets proceeds after distribution to bondhoiders $480,000 $460,000 Formulas IN/A $460,000 Distroution to Prionity Claimants: Proceeds trom sale of assets after distribution to mortgape bondholders Less: Fees and expenses of bankruptcy Wages due to workers within 3 months of barkiupley Taxes due to federal, state, and local povernments Tolal funds distributed to prenty claimants Funds avolable for datribution to general creditors 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 $480,000, while the current assets were sold for another $290,000. Thus, the total proceeds from the liquidation sale were $770,000. The trustee's costs amounted to $35,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. Open spreadsheet a. How much will McDaniel's shareholders receive from the liquidation? If your answer is zero, enter " 0 ". Round your answer to the nearest dollar: $ b. How much will the mortgage bondholders recelve? if your answer is zero, enter " 0 *. Round your answer to the nearest dollar: $ c. How much will other priority claimants receive from the liquidation? Do not round intermediate calculations. Round your answers to the nearest dollar. 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 flle 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 $480,000, while the current assets were sold for another $290,000. Thus, the total proceeds from the liquidation sale were $770,000. The trustee's costs amounted to $35,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. Open spreadsheet a. How much will McDaniel's shareholders recelve from the liquidation? If your answer is zero, enter "0". Round your answer to the nearest dollar. b. How much will the mortgage bondholders receive? If your answer is zero, enter "0", Round your answer to the nearest dollar. c. How much will other priority claimants recelve from the liquidation? Do not round intermediate calculations. Round your answers to the nearest dollar