Provide excel formula for calculations.

The following table contains financial information for A Corp. A Corp oration Balance Sheet (S millions) Cash & Short-Term Imestments Shon-Term Recelvable s Inventories Offer Current Assets T otal Current Assets Net Fixed Assets T otal Assets Liabilities & Shareholders' Equity sr Debt & cum Debt Accounts Payable Income Tax Payable Offer Current L iabilities Total Current Liabilities Lang-Term Debt Deferred Tax Liabilities Offer Liabilities T otal L iabilities Stock (Carrying Value) Common Equity Total Shareholders' Equity T otal Liabilities & Shareholders' Equity Dec-22 27,099 5,074 5,553 77.819 4,634 2,475 12864 20,649 1,730 3,538 66.226 67,108 Dec-21 35,313 5,530 5,167 4,346 62.709 2,634 10 698 20,036 2,539 2,841 61.085 61,982 Dec-20 1404 4,427 4,273 4,976 64.226 2,748 11224 12,107 3,775 3,278 Dec-19 30,087 3,647 4,172 4,178 60.274 9 776 13,165 4397 58.26 58,256 Dec-18 38,162 4,734 3,763 52.993 13,136 3,412 3,702 221.203 51,203 a) b) c) 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 shareholder' s equity as a percentage of total assets as of the end of 2022 Create a chart m another worksheet 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. Copy the balance sheet and express each item as a percentage of total assets. Create a chart m worksheet "d" showing current assets, fixed assets, current liabilities, and long-term liabilities for 20182022. Be sure to add a title and axis reverse the x-axis so that time flows from left to right.