HW1-3 (20 points)

The following table contains financial information for A Corp.

A Corporation
Balance Sheet ($ millions)
	Dec-20	Dec-19	Dec-18	Dec-17	Dec-16
Assets
Cash & Short-Term Investments	17099	25313	14054	20087	18162
Short-Term Receivables	5074	5530	4427	3647	4699
Inventories	5553	5167	4273	4172	4734
Other Current Assets	7782	4346	4976	4178	3763
Total Current Assets	?	?	?	?	?
Net Fixed Assets	77819	62709	64226	60274	52993
Total Assets	?	?	?	?	?
Liabilities & Shareholders' Equity
ST Debt & Curr. Portion LT Debt	4634	2634	1604	281	312
Accounts Payable	2475	2063	2748	2969	3023
Income Tax Payable	329	272	443	542	711
Other Current Liabilities	12864	10698	11224	9776	8852
Total Current Liabilities	?	?	?	?	?
Long-Term Debt	20649	20036	12107	13165	13136
Deferred Tax Liabilities	1730	2539	3775	4397	3412
Other Liabilities	3538	2841	3278	2972	3702
Total Liabilities	?	?	?	?	?
Preferred Stock (Carrying Value)	882	897	912	0	0
Common Equity	66226	61085	55865	58256	51203
Total Shareholders' Equity	67108	61982	56777	58256	51203
Total Liabilities & Shareholders' Equity	?	?	?	?	?

1. 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 showing total shareholders equity as a percentage of total assets as of the end of 2020 (Identify and Access Needed Information 4pts).
2. 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.
3. 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).
4. 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-term liabilities for 20162020. 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).

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