I'm extremely lost, please use the same layout as shown in excel for C and D with the formulas if possible. Thank you :)

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) $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: a) Compute the annual rate of return. Average Net Income Average Investment Annual Rate of Return $35,250 350,000 10.07% 2 b) Compute the payback period. Note that you will need to arrive at the net annual cash flow FIRST. Average Net Income Depreciation Net Annual Cash Flow $35,250 50,000 85,250 1 Cost of Investment Net Annual Cash Flow Payback Period in Years 350,000 85,250 4.11 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: 2 2 1 Present value of cash outflows: 1 Net present value 1 Is this proposal acceptable using this discount rate? Respond Yes or No. 2 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: 2. 2 1 Present value of cash outflows: 1 Net present value 1 Is this proposal acceptable using this discount rate? Respond Yes or No. 2