Please show Excel Formula

A D E $2,000,000 $1,850,000 B Macross Island Nautical Company Liabilities and Stockholders' Equity Current Liabilities $1,350,000 Debt due for repayment $950,000 Accounts Payable $3,500,000 Total Current Liabilities $7,500,000 Long-Term Debt Shareholders' Equity $55,500,000 Common Stock and paid-in capital $3,500,000 Retained Earnings $5,200,000 Less: Treasury Stock Total Shareholders' Equity Total Liabilities and Shareholders' Equity Assets Current Assets Cash Marketable Securities Receivables Inventories Fixed Assets Property, Plant, and Equipment Other Long-Term Assets Goodwill Total Fixed Assets Total Assets $47,500,000 $3,000,000 $25,000,000 $26,150,000 A 17 Using the information in the tables above, please calculate the following balance sheet and co 18 19 (Use cells A4 to D14 from the given information to complete this question.) 20 21 Macross Island Nautical Company Measure 22 Total Current Assets 23 Total Tangible Fixed Assets 24 Total Assets 25 Total Current Liabilities 26 Total Liabilities 27 Treasury Stock (Solve as Positive Number) 28 Common-Size Goodwill 29 Common-Size Accounts Payable 30 31