I need help with C-E

The following table contains financial information for A Corp. A Corporation Balance Sheet ($ millions) Dec-20 Dec-19 Dec-13 Dec-17 Dec-16 Assets Cash & ShortTerm Investments 17099 25313 14054 20037 13152 Short-Tenn Receivables 5074 5530 4427 3547 4699 Inventories 5553 5157 4273 4172 4734 Other Current Assets 7732 4345 4976 4178 3753 Total Current Assets ? ? ? ? ? Net Fixed Assets 22319 52209 54225 50224 52993 Tbtal Assets '3' ? ? 1' ? Liabilities 81 Shareholders' Equity ST Debt 3: Curr. Portion LT Debt 4534 2534 1504 231 312 Accounts Payable 2425 2053 2748 29-59 3023 Income Tax Payable 329 272 443 542 711 Other Current Liabilities 12354 10593 11224 9775 3352 Ibtal Current Liabilities ? ? ? ? ? Long-Term Debt 20549 20035 12107 13155 13135 Deferred 'be Liabilities 1730 2539 3775 4397 3412 Other Liabilities 3533 2341 3273 2922 3702 Tina] Liabilities ? ? ? ? ? Preferred Stock (Carrying Value) 332 397 912 0 0 Common Equity 55225 51035 55355 53255 51203 Ibtal Shabolders' Equity 57103 51932 55777 53255 51203 Ibtal Liabilities 8r Shareholders' Equity ? ? '1' ? ? a) Create a formula to calculate the missing values in the table denoted by a question mark using the b) d) SUM function, and format the results to match the other numbers. Use a formula to calculate total debt as a percentage of total assets, and a similar formula showing total shareholder's equity as a percentage of total assets as of the end of 2020 (Identify and Access Needed Information 4pts). Create a pie chart showing the proportion of total debt and total equity that A used to finance its assets at the end of 2020. Make sure to title the chart and add data labels. Create a chart showing how debt and equity as a percentage of total assets have changed over time. Be sure to title the chart, label the axes, and reverse the x-axis so that time flows from left to right (Analysis 4 pts). Copy the balance sheet and express each item as a percentage of total assets. Create a chart showing current assets, fixed assets, current liabilities, and long-tenn liabilities for 20162020. Be sure to add a title and axis labels, and reverse the xaxis so that time flows from left to right (Use Information Effectively to Accomplish a Specific Purpose 4 pts). Interpretation: Please describe your process of analyzing the given information, and interpret the results. Please include your written description in the \"interpretation\" tab. If you do not complete this section with your words or leave the interpretation tab as a blank, you receive 0 point in this HW (Use Information Effectively to Accomplish a Specific Purpose 4 pts)