QUESTION 2 [59 Marks] Jack Devaro, the CEO of Angela Designer Bags, has requested that you assist with completing the Replacement Analysis that the Finance Manager, who abruptly resigned a week ago, was busy completing. Devaro has provided you with a snapshot of what he could salvage from the previous Finance Manager's computer and has requested that you calculate the rest of the amounts indicated in the snapshot below. 7 HPFM440-1-Jul-Dec2023-SA1-LM-V6-06062023 2.2. Determine how long it will take to recoup the initial investment. [27 Marks] CEO instructions: - Make use of the following snapshot to determine the payback period using Excel. - Make use of IF statement, COUNT and ABS functions in column C to determine the payback period. - Make use of cell referencing in Column B to figures calculated in question 2.1. - Fill the cell in column A in yellow to highlight the payback period. - Include the normal view and formula view in separate sheets before converting your assignment to PDF as per the assessment instructions. Mark allocation: Normal view - 14 Marks Formula view- 13 Marks Required: 2.1 Complete the question marks in the CEO's snapshot by calculating the relevant cashflows. [32 Marks] CEOinstructions: - Enter the data provided by the CEO as per the snapshot in Excel. Take note of the cells and rows where information is placed. Merge and center row 1, column A-D and bold the words. - Make use of formulas, cell reference and absolute cell referencing when calculating the amounts in the cell. - Include the normal view and formula view in separate sheets before converting your assignment to PDF as per the assessment instructions. Mark Allocation: QUESTION 2 [59 Marks] Jack Devaro, the CEO of Angela Designer Bags, has requested that you assist with completing the Replacement Analysis that the Finance Manager, who abruptly resigned a week ago, was busy completing. Devaro has provided you with a snapshot of what he could salvage from the previous Finance Manager's computer and has requested that you calculate the rest of the amounts indicated in the snapshot below. 7 HPFM440-1-Jul-Dec2023-SA1-LM-V6-06062023 2.2. Determine how long it will take to recoup the initial investment. [27 Marks] CEO instructions: - Make use of the following snapshot to determine the payback period using Excel. - Make use of IF statement, COUNT and ABS functions in column C to determine the payback period. - Make use of cell referencing in Column B to figures calculated in question 2.1. - Fill the cell in column A in yellow to highlight the payback period. - Include the normal view and formula view in separate sheets before converting your assignment to PDF as per the assessment instructions. Mark allocation: Normal view - 14 Marks Formula view- 13 Marks Required: 2.1 Complete the question marks in the CEO's snapshot by calculating the relevant cashflows. [32 Marks] CEOinstructions: - Enter the data provided by the CEO as per the snapshot in Excel. Take note of the cells and rows where information is placed. Merge and center row 1, column A-D and bold the words. - Make use of formulas, cell reference and absolute cell referencing when calculating the amounts in the cell. - Include the normal view and formula view in separate sheets before converting your assignment to PDF as per the assessment instructions. Mark Allocation