Excel Online Structured Activity: Uquidation 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 Teco Online below the correctly in fim, dedded that the anly recourse was limidation Sale of the fixed assets, which were pledged as collateral to the mortgage bondholders, brought in 3440,000, while the current world for the total proceeds from the liquidation sale were $70,000. The trust's costs amounted to $35.000 no single work was due more than $2,000 in Wager and there were no funded the databas collected in the Microsoft Excel Online file below. Open the spreadsheet and serform the required analysis to answer the questions below Open spreadsheet ni How much will McDaniel's shareholders receive from the liquidation. If your answer is zero, eritro. Round your answer to the nearest dollar. 5 b. How much will the mortgage bondholders receive? if your answer is zero, enter Found your answer to the nearest dolor 3 500000 c. How much will the priority calmants receive from the liquidation? Do not round Intermediate calculation Round your answers to the nearest dostar Claimant Amount 35000 3 3 30000 40000 105000 Toul d. How the remaining general creditors receive from the distribution before subordination adjustment? if your awer is zem, enterer. Do not under AL Amount Received 50000 160000 200000 300000 + 100003 Account Amount Received Accounts payable $ 50000 Notes payable 180000 Second mortgage bonds $ 200000 Debentures S 200000 3 Subordinated $ 200000 debentures Total $ 830000 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 dallar Amount Received after Account subordination adjustment Notes payable $ 0X Subordinated 0 debentures Check My Work Reset Problem you want to do Liquidation Proceeds from sale of faced assets Proceeds from sale of current assets Trustee's costs Any single worker due more than $2,000 in WOgos? Any unfunded pension plan liabillies $140,000 $200 000 $35 000 No No Balance Sheat Current assets 5400 000 550 000 40.000 30.000 Net fixed assets 600.000 Accounts payable Accrued aces Accrued wages Notes payable Total current abilities First mortgage bonda Second mortgage bonds Debentures Subordinated debentures Common stock Retained earnings Total claims 180,000 $300,000 300,000 200,000 200.000 100 000 50.000 150,000 $1,000,000 Total assets $1,000,000 Notes 24 Allfixed assets are pledged as collateral to the mortgage bond 25 Subordinated to notes payable only Formas ANIA 3440,000 27. Dlatribution to Common Shareholders 28 Amount debuted to common shareholders 20 30 Distribution to Mortgage Bondhold 31 Proceeds from softues assets Less Fust mortgage paid tom se oted assets) Second mortgage came off assets) Total tunds distributed to mortgage bondholders INIA WNIA 50 $400 000 Funds available from teda proceeds after distribution to bondholders Diabution to Priority Clint 10 Proceeds from sale of aer distribution to manuage bondholders FIA Fees and entes of bankruptcy 11 Wages due to woners within 3 months of bankuptcy Taues due to deal state and local governments Total Tunds distributed to priority cama Funds available for distribution to generare 45 Pro Rata Deutian Defore subordination Adjusi E HUA 10 Proceeds from sale of assets after distribution to mortgage bondholders 41 Less 4 Fees and expenses of bankruptcy 43 Wages due to workers within 3 months of bankruptcy 11 Taxes due to federal, state, and local governments 45 Total funds distributed to priority claimants NA NA MNIA HNIA 47 Funds available for distribution to general creditors PNJA 10 Pro Rata Distribution Before Subordination Adjustment 50 51 Distribution to General Creditors. NA Pro Rata Distribution Before Subordination Adjustment Original Claim Received Amount of Claim Total Amount Reserved Distribution after Subardination Adjustment 50 0 50,000 180,000 D 0 General Creditors Claims 51 Unsatisfied portion of first mortgage 54 Accounts payable 55 Notes payable (to banis) 56 Second mortgage 57 Debentures 58 Subordinated debentures 53 Total claims 60 Formulas 0 200,000 100 000 $530,000 0 0 50 of Original Clain Hoceived Distribution after Subordination Adjustment Total Amount Received NA Amount of Claim #NIA Pro Rata Distribution Before Subordination Adjustment ANIA ANIA #NIA NA ONIA #NIA WNIA ANIA 62 General Creditors' Claims Unsatisfied portion of first mortgage Accounts payable 65 Notes payable (to banks 66 Second mortgage 67 Debentures 60 Subordinated debentures Total claims 70 ANA #NIA WNIA TA 70 29 31 ht Excel Online Structured Activity: Uquidation 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 Teco Online below the correctly in fim, dedded that the anly recourse was limidation Sale of the fixed assets, which were pledged as collateral to the mortgage bondholders, brought in 3440,000, while the current world for the total proceeds from the liquidation sale were $70,000. The trust's costs amounted to $35.000 no single work was due more than $2,000 in Wager and there were no funded the databas collected in the Microsoft Excel Online file below. Open the spreadsheet and serform the required analysis to answer the questions below Open spreadsheet ni How much will McDaniel's shareholders receive from the liquidation. If your answer is zero, eritro. Round your answer to the nearest dollar. 5 b. How much will the mortgage bondholders receive? if your answer is zero, enter Found your answer to the nearest dolor 3 500000 c. How much will the priority calmants receive from the liquidation? Do not round Intermediate calculation Round your answers to the nearest dostar Claimant Amount 35000 3 3 30000 40000 105000 Toul d. How the remaining general creditors receive from the distribution before subordination adjustment? if your awer is zem, enterer. Do not under AL Amount Received 50000 160000 200000 300000 + 100003 Account Amount Received Accounts payable $ 50000 Notes payable 180000 Second mortgage bonds $ 200000 Debentures S 200000 3 Subordinated $ 200000 debentures Total $ 830000 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 dallar Amount Received after Account subordination adjustment Notes payable $ 0X Subordinated 0 debentures Check My Work Reset Problem you want to do Liquidation Proceeds from sale of faced assets Proceeds from sale of current assets Trustee's costs Any single worker due more than $2,000 in WOgos? Any unfunded pension plan liabillies $140,000 $200 000 $35 000 No No Balance Sheat Current assets 5400 000 550 000 40.000 30.000 Net fixed assets 600.000 Accounts payable Accrued aces Accrued wages Notes payable Total current abilities First mortgage bonda Second mortgage bonds Debentures Subordinated debentures Common stock Retained earnings Total claims 180,000 $300,000 300,000 200,000 200.000 100 000 50.000 150,000 $1,000,000 Total assets $1,000,000 Notes 24 Allfixed assets are pledged as collateral to the mortgage bond 25 Subordinated to notes payable only Formas ANIA 3440,000 27. Dlatribution to Common Shareholders 28 Amount debuted to common shareholders 20 30 Distribution to Mortgage Bondhold 31 Proceeds from softues assets Less Fust mortgage paid tom se oted assets) Second mortgage came off assets) Total tunds distributed to mortgage bondholders INIA WNIA 50 $400 000 Funds available from teda proceeds after distribution to bondholders Diabution to Priority Clint 10 Proceeds from sale of aer distribution to manuage bondholders FIA Fees and entes of bankruptcy 11 Wages due to woners within 3 months of bankuptcy Taues due to deal state and local governments Total Tunds distributed to priority cama Funds available for distribution to generare 45 Pro Rata Deutian Defore subordination Adjusi E HUA 10 Proceeds from sale of assets after distribution to mortgage bondholders 41 Less 4 Fees and expenses of bankruptcy 43 Wages due to workers within 3 months of bankruptcy 11 Taxes due to federal, state, and local governments 45 Total funds distributed to priority claimants NA NA MNIA HNIA 47 Funds available for distribution to general creditors PNJA 10 Pro Rata Distribution Before Subordination Adjustment 50 51 Distribution to General Creditors. NA Pro Rata Distribution Before Subordination Adjustment Original Claim Received Amount of Claim Total Amount Reserved Distribution after Subardination Adjustment 50 0 50,000 180,000 D 0 General Creditors Claims 51 Unsatisfied portion of first mortgage 54 Accounts payable 55 Notes payable (to banis) 56 Second mortgage 57 Debentures 58 Subordinated debentures 53 Total claims 60 Formulas 0 200,000 100 000 $530,000 0 0 50 of Original Clain Hoceived Distribution after Subordination Adjustment Total Amount Received NA Amount of Claim #NIA Pro Rata Distribution Before Subordination Adjustment ANIA ANIA #NIA NA ONIA #NIA WNIA ANIA 62 General Creditors' Claims Unsatisfied portion of first mortgage Accounts payable 65 Notes payable (to banks 66 Second mortgage 67 Debentures 60 Subordinated debentures Total claims 70 ANA #NIA WNIA TA 70 29 31 ht