Laura, Inc. is being liquidated under Chapter 7 of the Bankruptcy Act. Its current balance sheet is shown below. Fixed assets are sold for $30,000,000 and current assets are sold for $10,000,000. All fixed assets are pledged as collateral for all mortgage bonds. Subordinated debentures are subordinate only to notes payable. Trustee costs are $1,000,000. No employee is owed over $2,000. IN EXCEL PLEASE WITH STEPS SHOWN.
a. How much will SHs receive?
b. How much will mortgage bondholders receive?
c. How much will priority creditors receive?
d. Identify the remaining general creditors. How much will each receive before subordination adjustment?
e. How much will each of the general creditors receive after subordination adjustment?