PLEASE HELP, would love the steps and process it took to complete this, but answers work as well.

Project 1: A bicycle manufacturer has an opportunity to begin making a new higher-end model which has additional features from the models they currently make. To manufacture the required parts for the new model, the company will need new machinery. Because of the risk level involved in taking on a new product, management is trying to determine whether the returns will justify the risk. Members of management are evaluating the project and have determined a 11% discount rate is appropriate for evaluation purposes. To aid management in their decision-making process, your supervisor has asked you to prepare an analysis of the project giving the following information and assumptions: 1) The new equipment will have a cost of $385,000, a salvage value of $35,000 and a 7-year useful life. Straight line depreciation will be used. 2) The projected revenues, costs, and results for each of the 7 years of this project are as follows: $394,000 Sales Less: Manufacturing costs Depreciation Shipping costs Administrative costs Income before income taxes Income tax expense Net income $255,000 50,000 27,600 14,400 347,000 47,000 11,750 $35,250 Instructions: Using the template below, a) compute the annual rate of return. b) compute the payback period. compute the NPV using the determined 11% discount rate. Is this proposal acceptable using this discount rate? d) compute the NPV using a 14% discount rate so that Management has a comparison for analysis. Is this proposal acceptable using this discount rate? In order to get full points for this project: 15 Numerical values computed are accurate. 13 Excel formulas utilized are correct. 10 Responses to analysis questions are correct. 38 Total points available a) Compute the annual rate of return. b) Compute the payback period. Note that you will need to arrive at the net annual cash flow FIRST. 1 c) Compute the NPV using the discount rate of 11% and the PV 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. d) Compute the NPV using the discount rate of 14% and the PV Excel formula where required. 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. 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: Year 2: Year 3: Year 4: Year 5: 9,000 10,000 14,000 18,000 25,000 40,000 116,000 Year 6: Total Instructions: Using the template below, a) compute the annual rate of return. b) prepare a table of the net annual cash flow and cumulative net cash flow. c) compute the payback period. d) compute the NPV using the determined 11% discount rate. Should the proposable be accepted using this discount rate? e) compare the results from Project 1 to determine which project is more appealing. a) 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 Example) 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