I need help with creating annual balance sheet, annual cash flow, annual income statement with the information provided, please show work for the answers for ???? so I can understand how you got the answers and excel formulas used, I need to understand the formulas used in an excel. I hope this clarifies the question. Thank you

Millions of $	Dec. 31	Dec. 31
Item	Year2	Year1
Accounts Payable	723	822
Accrued Expenses	400	321
Accumulated Depreciation	1188	1081
Bond Price, 6% Coupon	971	N/A
Capital Surplus	397	397
Cash & Short-Term Investments	1180	677
Common Stock	1214	996
Common Stock price per share	26	N/A
Common Stock shares in millions	120	100
Cost of Capital	????	N/A
Cost of Goods Sold	6016	5021
Depreciation,Depletion,&Amortization	107	98
Dividends	218	195
Gross Plant, Property & Equipment	4060	3970
Gross Profit	2355	2966
Interest Expense	176	204
Inventories	1126	1460
Long Term Debt (1 m units, 1000 par)	1176	1359
Net Income, Adjusted		????
Net Receivables	1410	1125
Operating Profit	????	????
Pretax Income	????	????
Retained Earnings	????	996
Sales	8371	7987
Sales Units	100	88
Selling, General, & Administrative Exp.	1022	979
Total Assets	????	????
Total Income Taxes	410	657
Total Liabilities and Equity	????	????