At the time it defaulted on its interest payments and filed for bankruptcy, the McDaniel Mining...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 fle 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 martgage bondholders, brought in $440,000, while the current assets were sold for another $230,000. Thus, the total proceeds from the liquidation sale were $670,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 receive? If your answer is zero, enter "0". Round your answer to the nearest dollar. C. How much will other priority ciaimants receive 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 zerk enter "0". Do not round intermediate calculations. Round your answers to the nearest dollar. Dessiued Liquidation Proceeds from sale of fixed assets $440,000 $230,000 $35,000 No Proceeds from sale of current assets Trustee's costs Any single worker due more than $2,000 in wages? Any unfunded pension plan liabilities? No Balance Sheet: Current assets Accounts payable Accrued taxes Accrued wages Notes payable Total current liabilities S400,000 $50,000 40.000 30,000 180.000 $300,000 300,000 First-mortgage bonds Second-morigage bonds Debentures Net fixed assets 600,000 200,000 200,000 Subordinated debentures ** Common stock Retained earnings Total claims 100,000 50,000 -150,000 $1.000,000 Total assels $1.000.000 Notes: * All fixed assets are pledged as collateral to the mortgage bonds. **Subordinated to notes payable only. Distribution to Common Shareholders: Formulas Amount distributed to common shareholders #N/A Distribution to Mortgage Bondholders: Proceeds from sale of fixed assets $440,000 Less: First mortgage (paid from sale of fixed assets) Second mortgage (paid from sale of fixed assets) Total funds distributed to mortgage bondholders #N/A #N/A $0 Funds available from fixed assets proceeds after distribution to bondholders $440,000 Distribution to Priority Claimants: Proceeds from sale of assets after distribution to mortgage bondholders #N/A Less: Fees and expenses of bankruptcy Wages due to workers within 3 months of bankruptcy Taxes due to federal, state, and local governments Total funds distributed to priority claimants #N/A #N/A #N/A #N/A Funds available for distribution to general creditors #N/A Pro Rata Distribution Before Subordination Adjustment #N/A Distribution to General Creditors: Percentage of Original Claim Pro Rata Distribution Before Subordination Adjustment Total Amount Received General Creditors' Claims Amount of Claim Distribution after Subordination Adjustment Received Unsatisfied portion of first mortgage Accounts payable Notes payable (to banks) $0 50,000 180,000 Second mortgage Debentures 200,000 Subordinated debentures 100,000 Total claims $530,000 $0 Formulas Percentage of Original Claim Pro Rata Distribution Before Total Amount General Creditors' Claims Amount of Claim Subordination Adjustment Distribution after Subordination Adjustment Received Received #N/A Unsatisfied portion of first mortgage Accounts payable Notes payable (to banks) Second mortgage #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Debentures #N/A #N/A Subordinated debentures #N/A #N/A #N/A Total claims #N/A 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 fle 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 martgage bondholders, brought in $440,000, while the current assets were sold for another $230,000. Thus, the total proceeds from the liquidation sale were $670,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 receive? If your answer is zero, enter "0". Round your answer to the nearest dollar. C. How much will other priority ciaimants receive 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 zerk enter "0". Do not round intermediate calculations. Round your answers to the nearest dollar. Dessiued Liquidation Proceeds from sale of fixed assets $440,000 $230,000 $35,000 No Proceeds from sale of current assets Trustee's costs Any single worker due more than $2,000 in wages? Any unfunded pension plan liabilities? No Balance Sheet: Current assets Accounts payable Accrued taxes Accrued wages Notes payable Total current liabilities S400,000 $50,000 40.000 30,000 180.000 $300,000 300,000 First-mortgage bonds Second-morigage bonds Debentures Net fixed assets 600,000 200,000 200,000 Subordinated debentures ** Common stock Retained earnings Total claims 100,000 50,000 -150,000 $1.000,000 Total assels $1.000.000 Notes: * All fixed assets are pledged as collateral to the mortgage bonds. **Subordinated to notes payable only. Distribution to Common Shareholders: Formulas Amount distributed to common shareholders #N/A Distribution to Mortgage Bondholders: Proceeds from sale of fixed assets $440,000 Less: First mortgage (paid from sale of fixed assets) Second mortgage (paid from sale of fixed assets) Total funds distributed to mortgage bondholders #N/A #N/A $0 Funds available from fixed assets proceeds after distribution to bondholders $440,000 Distribution to Priority Claimants: Proceeds from sale of assets after distribution to mortgage bondholders #N/A Less: Fees and expenses of bankruptcy Wages due to workers within 3 months of bankruptcy Taxes due to federal, state, and local governments Total funds distributed to priority claimants #N/A #N/A #N/A #N/A Funds available for distribution to general creditors #N/A Pro Rata Distribution Before Subordination Adjustment #N/A Distribution to General Creditors: Percentage of Original Claim Pro Rata Distribution Before Subordination Adjustment Total Amount Received General Creditors' Claims Amount of Claim Distribution after Subordination Adjustment Received Unsatisfied portion of first mortgage Accounts payable Notes payable (to banks) $0 50,000 180,000 Second mortgage Debentures 200,000 Subordinated debentures 100,000 Total claims $530,000 $0 Formulas Percentage of Original Claim Pro Rata Distribution Before Total Amount General Creditors' Claims Amount of Claim Subordination Adjustment Distribution after Subordination Adjustment Received Received #N/A Unsatisfied portion of first mortgage Accounts payable Notes payable (to banks) Second mortgage #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A Debentures #N/A #N/A Subordinated debentures #N/A #N/A #N/A Total claims #N/A
Expert Answer:
Answer rating: 100% (QA)
Total Amount Received on Liquidation 780000 Total Creditors Claims Current Liabilities Amount Due on First Mortgage Amount Due on Second Mortgage Clai... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A Boeing 737-300 needs to take off from a runway. At t=0 the pilot is waiting for the signal from the control tower. Wheel friction is not taken into account. Check with known flight performance...
-
Current Assets 2000 2001 Cash 200 1 000 Accounts receivable 1 600 1 000 Inventory 2 200 2 600 TOTAL CURRENT ASSETS 4 000 4 600 Gross Fixed Assets 12 000 12 400 Less Accum Depreciation 6 000
-
Hindustan Ltd. issued 50,000, 6% debentures of Rs. 100 each on 1st January 2011. The debentures are redeemable by the creation of a sinking fund. The company had the right to call upon the trustees...
-
Discuss the primary sources of nonverbal communication.
-
Do you support a policy of random drug testing for all employees? Explain. Would you be less attracted to an organization that required random drug testing with no probable cause?
-
Find the equations of the ellipses satisfying the given conditions. The center of each is at the origin. Vertex (15, 0), focus (9, 0)
-
Find the number of different prime factors of 180 .
-
You have been given a file that contains fields relating to CD information. Using the steps of normalization, create a logical data model that represents this file in third normal form. The fields...
-
Machine B is expected to produce the following real cash flows: Cash Flows ($ thousands) Machine Co C7 C2 C3 B -120 +110 +121 +133 Machine C was purchased five years ago for $200,000 and produces an...
-
Automotive Interiors (AI) manufactures seats for automobiles, vans, trucks, and boats. The company has a number of plants, including the Woodstock Cover Plant, which makes seat covers. Bill Rice is...
-
The Taylor Family had an income after income taxes and FICA withholding of $45,000 in 2020. They have three kiddos 12,14, and 16. Spending in 2020 was: Food$6,000 Clothing $3,000 Auto payments $7.000...
-
The nominal interest rate is 12%, inflation is 3%, the marginal income tax rate is 10%. What is after-tax real rate of interest? Answer with one decimal place
-
Company XYZ.s stock prices and the market index for the past four years are given in the following table. The current risk free rate is 7%. Use the data answer the following questions (Of course, the...
-
A. Green Caterpillar Garden Supplies Inc. reported sales of $743,000 at the end of last year; but this year, sales are expected to grow by 8%. Green Caterpillar expects to maintain its current profit...
-
Company XYZ.s stock prices and the market index for the past four years are given in the following table. The current risk free rate is 7%. Stock Market price of 3 year ago is $23.13 with index of...
-
A plane wall 10 cm thick generates heat at the rate of 4x104 W/m3 when an electric current is passed through it. The convective H.T.C between each face of wall and ambient air is 50 W/m2k. Determine...
-
Electromagnetic energy travels in ____. Group of answer choices waves packets nodes modules chunks
-
According during to the IRS, individuals filing federal income tax returns prior to March 31 received an average refund of $1,088 in 2018. Consider the population of "last-minute" filers who mail...
-
From the following T-accounts, record the following: (a) The July 3 payment for FICA (OASDI and Medicare) and federal income taxes, (b) The July 30 payment of SUTA tax, (c) The July 30 deposit of any...
-
Several banks have offered loans to the Sanchez Computer Center for its expansion. However, Freedman wants to weigh each option to determine the best financial situation for the company. Currently,...
-
A machine that cost $9,060 with $3,980 of accumulated depreciation was traded in for a similar machine having a $5,820 cash price. An $840 trade-in was offered by the seller. a. Calculate the book...
-
A superball is dropped from a 2.00 m height. After it rebounds, it reaches a new height of 1.65 m. Assuming a constant coefficient of restitution, find the (ideal) total distance the ball will travel...
-
Here are some telescoping series problems: a. Verify that \[\sum_{n=1}^{\infty} \frac{1}{(n+2)(n+1)}=\sum_{n=1}^{\infty}\left(\frac{n+1}{n+2}-\frac{n}{n+1} ight)\] b. Find the \(n\)th partial sum of...
-
Determine the radius and interval of convergence of the following infinite series: a. \(\sum_{n=1}^{\infty}(-1)^{n} \frac{(x-1)^{n}}{n}\). b. \(\sum_{n=1}^{\infty} \frac{x^{n}}{2^{n} n!}\). c....
Study smarter with the SolutionInn App