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 1) Instructions: 2) 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 The projected revenues, costs, and results for each of the 7 years of this project are as follows: Sales $394,000 Less: Manufacturing costs $255,000 Depreciation 50,000 Shipping costs 27,600 Administrative costs 14,400 347,000 Income before income taxes 47,000 Income tax expense 11,750 Net income $35,250 Using the template below, a) compute the annual rate of return. b) compute the payback period. c) compute the NPV using the determined 11% discount rate. d) Is this proposal acceptable using this discount rate? compute the NPV using a 14% discount rate so that Management has a comparison for analysis. Is this proposal acceptable using this discount rate? 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: Rate 0.11 NPER 7 PMT FV PV 2 Rate 0.11 INPER 7 PMT 85,250 FV PV 2 Present value of cash outflows: Net present value Is this proposal acceptable using this discount rate? YES 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 Present value of cash inflows: 2 2 Present value of cash outflows: Net present value Is this proposal acceptable using this discount rate? Respond 2