1. The following table contains financial information for Intel Corp.

Intel Corporation
Balance Sheet ($ millions)
	Dec-16	Dec-15	Dec-14	Dec-13	Dec-12
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. Enter the data into a worksheet and format the table as shown. Format the cells as accounting numbers with no decimal places.
2. 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.
3. 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 2016.
4. Create a pie chart showing the proportion of total debt and total equity that Intel used to finance its assets at the end of 2016. Make sure to title the chart and add data labels.
5. 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.
6. Copy the balance sheet and express each item as a percentage of total assets.
7. Create a chart showing current assets, fixed assets, current liabilities, and long term liabilities for 20122016. Be sure to add a title and axis labels, and reverse the x-axis so that time flows from left to right.

2. Using the data from the previous problem:

1. Calculate the growth rate of each balance sheet item for Intel for each year from 2012 to 2016.
2. Calculate the compound annual growth rate during 20122016 and the average annual growth rate during the same period using the AVERAGE function of each item using the results you calculated in part a.
3. Calculate the ratio of each years data to the previous year for each of the above items. Also, calculate the average annual growth rate using the GEOMEAN and the standard deviation using the STDEV.S function for each item.

NOTE: I NEED HELP WITH QUESTION #2 BUT EXERCISE #1 I POSTED JUST TO SHOW THE PREVIOUS PROBLEM THAT IS MENTIONED IN QUESTION 2.