60.1K

Verified Solution

Link Copied!

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 apen-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 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. se 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 stotements 4. Save your Excel workbook Proiect3-our last name (For example: Project3-Smith.xis). 5. Upload the completed assignment to BlackBoard 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 bock 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 2017 2018 Revenue Net sales 44,452 37,043 Cost of merchandise sold 24,969 20,807 Gross Profit 19,483 16,236 Operating Expenses Selling, general and administrative Depreciation 7,182 5,985 2,550 2,499 Amortization 45 45 9,706 7,707 Operating income Interest expense, net Gain/(Loss) on sale of property & equip 205 171 169 114 9,670 7,650 Income before income taxes 1,762 Provision for income taxes 2,031 7,639.3 5,888 Net income 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 apen-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 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. se 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 stotements 4. Save your Excel workbook Proiect3-our last name (For example: Project3-Smith.xis). 5. Upload the completed assignment to BlackBoard 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 bock 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 2017 2018 Revenue Net sales 44,452 37,043 Cost of merchandise sold 24,969 20,807 Gross Profit 19,483 16,236 Operating Expenses Selling, general and administrative Depreciation 7,182 5,985 2,550 2,499 Amortization 45 45 9,706 7,707 Operating income Interest expense, net Gain/(Loss) on sale of property & equip 205 171 169 114 9,670 7,650 Income before income taxes 1,762 Provision for income taxes 2,031 7,639.3 5,888 Net income

Answer & Explanation Solved by verified expert

See Answer