please show all work in Excel with formulas

View AutoSave OFF A svu Home Insert Draw Page Layout Formulas Calibri (Body) 11 A A Paste BI U O A 631 x & fx Data = Review = Wrap Text Merge & Cent 5 Question 5. (20 points) Pontrain Imports will be liquidated. Its current balance sheet is shown below. Current assets are sold for $2,100,000 and fixed assets are sold for $5,000,000. All fixed assets are pledged as collateral for all mortgage bonds. Subordinated debentures are subordinate only to notes payable Trustee costs are $500,000 1 Sale of current assets 2 Sale of fixed assets 3 Trustee costs 2,100,000 5,000,000 500,000 Before Before Default Balance Sheet Default Accounts payable 7 Current Assets 8 Net fixed assets 3,000,000 7,600,000 Accrued taxes Accrued wages Notes payable Total current liabilities NM First-mortgage bonds Second-mortgage bonds Subordinated debentures Common stock Retained earnings Total claims 465,000 80,000 95,000 60,000 700,000 2,000,000 3,500,000 500,000 200,000 300,000) 10,600,000 27 Total assets 10,600,000 29 a. How much will SHs receive? 31 b. How much will mortgage bondholders receive? 33 c. How much will priority creditors receive? 35 d. Identify the remaining general creditors. How much will each receive before subordination adjustment and 2 after adjustment