thats all my lecture give

Please give your answers in excel with a formula. So it's easy for me to refer.

example like this can ah:

1. Using the data presented below: Square Corp. Square Corp. Income Statement Balance Sheet For the Year Ended Dec 31, 2017 (5 in 000's) As of Dec. 31, 2017 ($ in 000's) 2017 2016 Assets 2017 2016 Sales 7,250,000 6,750,000 Cash 149,970 100,000 5,400,000 5,330,000 Accounts Receivable 370,000 347,000 ? ? Inventory 870,000 515,000 Cost of Goods Sold Gross Profit Selling and G&A Expenses Depreciation 965,000 632,000 Total Current Assets ? ? ? 550,000 6,570,000 5,010,000 Plant & Equipment Accumulated Depreciation EBIT 335,000 ? 1,930,000 1,380,000 Interest Expense ? 110,000 Net Fixed Assets ? ? ? ? ? ? ? ? ? ? Earnings Before Taxes 205,000 Total Assets Taxes 2 ? Liabilities and Owners' Equity Net Income 133,250 79,100 Accounts Payable 420,000 321,440 Notes Payable 166,625 22,960 Notes: Total Current Liabilities Tax Rate Long-term Debt 1,350,000 918,400 Shares Outstanding 75,000 65,000 Total Liabilities ? Earnings per Share ? ? Common Stock 2,520,000 2,043,440 Dividends per Share Additional Paid-in-Capital 772,000 551,040 Addition to RE per Share Retained Earnings 734,720 734,720 Dividend Payout Ratio 60% Total Shareholder's Equity ? Total Liab. and Owners' Equity a) Recreate the income statement and balance sheet by filling in the question marks with formulas. Each statement should be on a separate worksheet. Try to duplicate the formatting exactly. Note that in 2016, 60% of earnings were paid to shareholders as dividends. b) On another worksheet, create a statement of cash flows for 2017. Use formulas linked directly to the source on previous worksheets instead of numbers. c) Create a common-size income statement and balance sheet for 2017 and 2016. These statements should be created on a separate worksheet with all formulas linked directly to the income statement and balance sheet. ? ? ? ? ? ? 09 25 Gross income 26 SG & A Expenses 27 EBIT(Operating income) 28 Non operating income 29 Interest expenses 30 Unusual expenses 31 Pretax income 32 Income taxes 33 Net income 60.56% 35.61% 24.94% 0.90% 1.23% 2.82% 21.78% 4.41% 17.37% 62.69% 35.83% 26.86% -0.09% 0.61% 0.49% 25.67% 5.04% 20.63% 63.27% 35.25% 28.02% 0.40% 0.34% -0.20% 28.28% 7.33% 20.95% 59.36% 35.53% 23.83% 1.13% 0.46% 0.57% 23.93% 5.67% 18.25% 38.45% 61.55% 33.96% 27.59% 0.87% 0.17% 0.41% 27.88% 7.25% 20.63% Formulas: C D Intel Corporation Income statement Dec 15 Dec 14 Dec 13 55355 55870 52708 20651 20522 21418 =C4-CS =D4 D5 =E4-E5 19693 18729 1-C6-07 -D6-D7 E6-E7 -51 224 595 337 192 244 269 301 =C8+C9-C10-C11 =D8+D9-010-11-E8 E9-E10-E11 -C12-C14 -D12-D14 -E12-E14 11420 11704 9620 19835 Dec 12 53341 20507 =F4-F5 18117 -F6-F7 463 190 217 F8+F9-F10-F11 -F12 F14 114 11005 B 1 2 Dec 16 4 Sales 59387 5 Cost of goods sold 23425 6 Gross income -B4-B5 7 SG & A Expenses 21149 8 EBIT(Operating income) -36-87 9 Non operating income 533 10 Interest expenses 733 11 Unusual expenses 1677 12 Pretax income -B8+89-310-811 13 Income taxes -812-814 14 Net income 10316 15 16 Average tax rate -B13/812 17 Gross profit margin -B6/B4 18 Net profit margin -B14/14 19 d 20 21 22 Dec 16 23 Sales -B4/$B$4 24 Cost of goods sold -B5/SB$4 25 Gross income -B6/SBS4 26 SG & A Expenses -B7/SBS 4 27 EBIT(Operating income) -B8/SB$4 28 Non operating income -B9/5B$4 29 Interest expenses -810/SB$4 30 Unusual expenses -811/$B$4 31 Pretax income -B12/SB$4 32 Income taxes -B13/SB$4 33 Net income -B14/SB$4 =C13/012 -C6/04 =C14/04 -D13/012 -D6/04 b14/04 -E13/12 -E6/E4 -E14/E4 =F13/12 -F6/4 -F14/54 Intel Corporation Income statement Dec 15 Dec 14 -CA/SC$4 -D4/SD$4 =CS/SCS4 =D5/SD$4 -C6/SCS4 -D6/SD$4 -C7/SCS4 07/SDS4 -C8/SCS4 -D8/SD$4 =09/SCS4 =D9/$D$4 -C10/SCS4 -D10/SD$4 =C11/SCS4 =D11/S054 -C12/SC54 -D12/SDS4 =C13/SCS4 =D13/$D$ -C14/SC$4 -D14/SD$4 Dec 13 -E4/SES4 =ES/SE$4 -E6/SE$4 E7/SE$4 -E8/SES4 E9/SE$4 -E10/SES4 -E11/SES4 -E12/SES4 -E13/SES4 -E14/SES4 Dec 12 -F4/SFS4 -F5/$E$4 -F6/SFS4 -F7/$FS4 -F8/$F$4 =F9/$F54 --F10/$FS4 =F11/SF$4 -F12/SFS4 -F13/SFSG -F14/SFS4 Comment >