Please solve (d) and (e). Thank you!

The following table contains financial information for A Corp. a) Create a formula to calculate the missing values in the table denoted by a question mark using the 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 ghowing total shareholder's equity as a percentage of total asgets as of the end of 2020 (Identify and Access Needed Information 4pts). b) 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. c) Create a chart showing how debt and equity as a percentage of total assets have changed over time. Be gure to title the chart, label the axes, and reverse the x-axis so that time flows from left to right (Analysis 4pts). d) Copy the balance gheet and express each item as a percentage of total assets. Create a chart ghowing current a5sets, fixed asgets, current liabilities, and long-term liabilities for 2016-2020. Be sure to add a title and axis labels, and reverse the x-axis so that time flows from left to right (Use Information Effectively to Accomplish a Specific Purpose 4 pts). e) 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