All questions, please. with Format

B D E F G H I J 1 Using the income statement and balance sheet data presented below do the following 2 1 60pts Fill in the yellow cells in the balance sheet and the statement of cash flows USING FORMULAS 3 2 20pts Create common-size income statement for 2019 and 2020 with formulas linked directly to the income statement presented. 4 Place the common-size income statement right next to the income statement presented (place it in columns G, H, and I, in the shaded area) 5 Make sure to use the same formatting as in the original income statement, except for numbers, which should be percentages with one decimal. 6 80pts 7 8. 9 10 11 12 Square Corp. Square Corp. 13 Income Statement Common Size Income Statement 14 For the Year Ended Dec. 31 For the Year Ended Dec. 31 15 2020 2019 2020 2019 16 Sales 22,236,775 18,620,680 17 Cost of Goods Sold 17,403,962 14,620,823 18 Gross Profit 4,832,812 3,999,857 19 Selling and G&A Expenses 2,064,912 1,717,314 20 Depreciation 1,666,285 1,408,2 21 EBIT 1,101,616 874,284 22 Interest Expense 428,990 391,902 23 Earnings Before Taxes (EBT) 672,626 482,383 24 Taxes 202,085 147,099 25 Net Income 470,541 335,283 26 27 Notes: 28 Shares Outstanding 75,000 65,000 29 Dividends per Share $1.88 $1.76 31 32 33 Square Corp. Balance Sheet As of Dec. 31, 34 Assets 2020 2019 35 Cash 36 37 38 39 40 41 Accounts Receivable Inventory Total Current Assets Gross Fixed Assets Accumulated Depreciation Net Fixed Assets Total Assets 275,931 813,014 1,919,895 3,008,840 14,428,289 220,272 762,162 1,131,586 2,114,020 11,003,450 3,030,919 2020 2019 42 43 44 45 46 47 48 49 50 51 52 53 54 Liabilities and Owners' Equity Accounts Payable Notes Payable Total Current Liabilities Long-term Debt Total Liabilities Common Stock Additional Paid-in-Capital Retained Earnings Total Shareholder's Equity Total Liabilities and Owners' Equity 938,539 46,870 985,409 3,148,204 4,133,613 5,535,662 1,128,032 705,882 50,468 756,350 2,016,806 2,773,156 4,487,486 1,212,463 1,613,445 55 A B D 56 57 58 Square Corp. Statement of Cash Flows For the Year Ended Dec. 31, 59 2,016 60 61 62 63 Cash Flows from Operations Net Income Depreciation Change in Accounts Receivable Change in Inventory Change in Accounts Payable Total Cash Flows from Operations 64 65 66 67 68 Cash Flows from Investing Change in Fixed Assets Total Cash Flows from Investing 69 70 71 72 73 74 75 76 77 78 Cash Flows from Financing Change in Notes Payable Change in Long-Term Debt Change in Common Stock Change in Additional Paid-in Capital Dividend Paid to Stockholders Total Cash Flows from Financing 79 80 Net Change in Cash Balance 81 no