Please help as my project is due next Friday; steps/formulas would help immensely!

Project 2: The bicycle manufacturer has another opportunity presented to expand their current factory space to increase production and ultimately be able to reach new markets with their expanded manufacturing capacity. The company has determined the following information and assumptions for this new expansion idea: 1) The capital investment for this project will cost the company $300,000. Depreciation will be calculated over a 6 year life with no salvage value. 2) The projected annual net income for each of the six years are as follows: Year 1: 9,000 Year 2: 10,000 Year 3: 14,000 Year 4: 18,000 Year 5: 25,000 Year 6: 40,000 Total 116,000 compute the annual rate of return. prepare a table of the net annual cash flow and cumulative net cash flow. compute the payback period. compute the NPV using the determined 11% discount rate. Should the proposable be accepted using this discount rate? compare the results from Project 1 to determine which project is more appealing. Instructions: Using the template below, a) b) e) Compute the annual rate of return. 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 M11 Excel Example!) Net Annual Cash Flow Cumulative Net Cash Flow Year c) Compute the payback period. (Again, refer to M11 Excel Examplel) d) Compute the NPV using the discount rate of 11% and the NPV Excel formula. You should list out your inputs in the provided spaces. Present value of cash inflows: Present value of cash outflows: Net present value Is this proposal acceptable using this discount rate? Respond Yes or No. e) 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 11% discount rate, letter (c) Annual Rate of Return Net Present Value Cash Payback Project 1 Project 2 1 1 Based on the above, which project should the company select? Enter Project 1 or 2 a) Project 2: The bicycle manufacturer has another opportunity presented to expand their current factory space to increase production and ultimately be able to reach new markets with their expanded manufacturing capacity. The company has determined the following information and assumptions for this new expansion idea: 1) The capital investment for this project will cost the company $300,000. Depreciation will be calculated over a 6 year life with no salvage value. 2) The projected annual net income for each of the six years are as follows: Year 1: 9,000 Year 2: 10,000 Year 3: 14,000 Year 4: 18,000 Year 5: 25,000 Year 6: 40,000 Total 116,000 compute the annual rate of return. prepare a table of the net annual cash flow and cumulative net cash flow. compute the payback period. compute the NPV using the determined 11% discount rate. Should the proposable be accepted using this discount rate? compare the results from Project 1 to determine which project is more appealing. Instructions: Using the template below, a) b) e) Compute the annual rate of return. 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 M11 Excel Example!) Net Annual Cash Flow Cumulative Net Cash Flow Year c) Compute the payback period. (Again, refer to M11 Excel Examplel) d) Compute the NPV using the discount rate of 11% and the NPV Excel formula. You should list out your inputs in the provided spaces. Present value of cash inflows: Present value of cash outflows: Net present value Is this proposal acceptable using this discount rate? Respond Yes or No. e) 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 11% discount rate, letter (c) Annual Rate of Return Net Present Value Cash Payback Project 1 Project 2 1 1 Based on the above, which project should the company select? Enter Project 1 or 2 a)