Question

1 Approved Answer

Posted on Jul 25, 2024

ACCT 211 - FALL 2019 INDIVIDUAL LEARNING PROJECT 3 INSTRUCTIONS H&K INC Important: This assignment should be completed alone. Students should treat this assignment similar

ACCT 211 - FALL 2019 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 exom. 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 2018 Statement of Cash Flows for H&K Inc. This should be created on the appropriate Tab of the Excel Workbook Template provided on BlackBoard. 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 2018 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 Proiect3.your last name (For example: Project 3-Smith.xls). 5. Upload the completed assignment to Black Board using the link provided GRADING RUBRIC: FORMATTING (15%) Statement of Cash Flow should be formatted and easy to read/follow. This includes: Properly underlined subtotals and grand totals. Consistency in formatting i.e. if decimals are used, they should be consistent. Are dollar signs used consistently?) ACCURACY/COMPLETENESS (25%) The Statement of cash flows and ratios were completed by linking the cells back to the financial statements STATEMENT OF CASH FLOWS (30%) All sub-totals and totals are accurately calculated using Excel formulas). All sections of the statement are included and correctly subtotaled. The Statement matches the change in cash from the Balance Sheet. RATIOS (30%) All ratios are accurately calculated (using Excel formulas) Income Statement Balance Sheet Cash Flow Statement Ratios H&K INC. Income Statement For the Years Ended December 31, 2018 and 2017 Sin millions 2018 2017 Revenue Net sales Cost of merchandise sold Gross Profit 44.452 24,969 19,483 37,043 20,807 16.236 Operating Expenses Selling, general and administrative Depreciation Amortization Operating income 7.182 2,550 5.985 2.499 451 7,707 45 9,706 Interest expense, net Gain/(Loss) on sale of property & equip Income before income taxes 205 169 9,670 171 114 7,650 Provision for income taxes 2,031 1.762 Net income 7,639.3 5,888 ACCT 211 - FALL 2019 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 exom. 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 2018 Statement of Cash Flows for H&K Inc. This should be created on the appropriate Tab of the Excel Workbook Template provided on BlackBoard. 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 2018 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 Proiect3.your last name (For example: Project 3-Smith.xls). 5. Upload the completed assignment to Black Board using the link provided GRADING RUBRIC: FORMATTING (15%) Statement of Cash Flow should be formatted and easy to read/follow. This includes: Properly underlined subtotals and grand totals. Consistency in formatting i.e. if decimals are used, they should be consistent. Are dollar signs used consistently?) ACCURACY/COMPLETENESS (25%) The Statement of cash flows and ratios were completed by linking the cells back to the financial statements STATEMENT OF CASH FLOWS (30%) All sub-totals and totals are accurately calculated using Excel formulas). All sections of the statement are included and correctly subtotaled. The Statement matches the change in cash from the Balance Sheet. RATIOS (30%) All ratios are accurately calculated (using Excel formulas) Income Statement Balance Sheet Cash Flow Statement Ratios H&K INC. Income Statement For the Years Ended December 31, 2018 and 2017 Sin millions 2018 2017 Revenue Net sales Cost of merchandise sold Gross Profit 44.452 24,969 19,483 37,043 20,807 16.236 Operating Expenses Selling, general and administrative Depreciation Amortization Operating income 7.182 2,550 5.985 2.499 451 7,707 45 9,706 Interest expense, net Gain/(Loss) on sale of property & equip Income before income taxes 205 169 9,670 171 114 7,650 Provision for income taxes 2,031 1.762 Net income 7,639.3 5,888