ACCT 211 – FALL 2021 INDIVIDUAL LEARNING PROJECT 3 INSTRUCTIONS H&K INC Important: This assignment should be completed alone. Students should treat this assignment similar to the requirements of an in-class open-book exam. That is, the only resources allowed are the textbook and the professor. Assignment instructions are as follows: 1. Use the information in the provided Income Statement and Balance Sheet to create the 2020 Statement of Cash Flows for H&K Inc. This should be created on the appropriate Tab of the Excel Workbook Template provided on Canvas. 2. Formulas: a. Use Excel to setup the Statement of Cash Flows by linking the values from the Income Statement and the Balance Sheet. b. Use Excel formulas to calculate all totals and sub-totals. 3. Complete the ratio calculations for 2020 on the appropriate tab using the Income Statement and Balance Sheet. All ratios should be linked back to your financial statements. 4. Save your Excel workbook Project3-your last name. (For example: Project3-Smith.xls). 5. Upload the completed assignment to Canvas using the link provided.
