please show how to fill in the exact tables

4 5 Project 2: 6 The same gym equipment manufacturer has another opportunity presented to expand their current factory 7 space to increase production and ultimately be able to reach new markets with their expanded 8 manufacturing capacity. The company has determined the following information and assumptions for this 9 new expansion idea: 1) The capital investment for this project will cost the company $485,000:- Depreciation will be calculated over a 5 year life with no salvage value. 2) The projected annual net income for each of the five years are as follows: 10 11 12 13 14 20 15 Year 1: 15,000 16 Year 2: 19,000 17 Year 3: 25,000 18 Year 4: 50,000 19 Year 5: 60,000 Total 169,000 21 22 Instructions: 23. Using the template below, 24 compute the annual rate of return 25 b) prepare a table of the net annual cash flow and cumulative net cash flow. 26 c) compute the payback period. 27 d) compute the NPV using the determined 13% discount rate 28 Should the proposable be accepted using this discount rate? 29 e) compare the results from Project 1 to determine which project is more appealing 30 ) Compute the annual rate of return. 33,800 485,000 6.97% 2 b) Prepare a table of the net annual cash flow and cumulative net cash flow. (Hint: Don't forget about depreciation's impact on cash flow. Refer to M10 Excel Example!) Net Annual Cash Flow Cumulative Net Cash Flow Year 1 2 3 4 2 c) Compute the payback period. (Again, refer to M10 Excel Example!) 2 60 161 d) Compute the NPV using the discount rate of 13% and the NPV Excel formula. You should list out your inputs in the provided spaces. 62 63 Present value of cash inflows: 64 65 66 67 68 69 70 2 71 72 Present value of cash outflows: 73 74 75 Net present value 1 76 77 Is this proposal acceptable using this discount rate? Respond Yes or No. 2 78 79 e) 80 81 Compare results from Project 2 above to those of Project 1 by marking an "X" in the box of the Project that is more appealing for each item below. Note: for the NPV comparison, use the results from Project 1 using the 13% discount rate, letter 82 83 84 Annual Rate of Return 85 Cash Payback Net Present Value 86 Project 1 Project 2 87 88 89 Based on the above, which project should the company select? 90 91 Enter Project 1 or 2 1 Template