Provide all answers in a single workbook that is easy to read/navigate. You can use multiple worksheets This homework is individual, any evidence of copying constitutes an Honor Code violation and will be reported The Canvas is restricted to allow you to submit the homework only once! Make sure that the file you upload and submit is the correct one. Assignment Use the following two worksheets to complete the following tasks 1 Create complete income statements and balance sheets by filling in the yellow blank cells with formulas. Note that the Addition to RE per share stands for addition to retained earnings per one share and can be calculated as earnings per share minus dividend per share OR (Net Income - Dividends)/Shares Outstanding). (20 points for each statement) 2 On another worksheet, create a statement of cash flows for 2021. Use formulas linked directly to the source on the previous two worksheets instead of type numbers. (30 points for correct Statement of Cash Flow) 3 On separate worksheets, create a common-size income statement and a common-size balance sheet. You should be able to do these statements fairly quickly. For each common size statement, calculate just one formula and use copy-paste-special to copy and paste the formula into all accounts. The formatting on common size statements should be identical to that in the original worksheets (only numbers format will differ). (10 points for each Common Size statement) 4 Using the Excel outliner, create an outline on the cash flow statement and the balance sheet such that, when collapsed, the statements show only the subtotal for each section. (10 points for correct use of outliner)