Please provide an excel sheet for the calculations.

1. Perform a sensitivity analysis with data provided Assume that your selected company is considering a potential project with a new product that is expected to sell for an average price of $22 per unit and the company expects it can sell 400 000 units per year at this price for a period of 4 years. Launching this project will require purchase of a $2 450 000 equipment that has residual value in four years of $250 000 and adding $ 500 000 in working capital which is expected to be fully retrieved at the end of the project. Other information is available below: Depreciation method: straight line Variable cost per unit: $12 Cash fixed costs per year $250 000 Discount rate: 10% Tax Rate: 30% Do an analysis with cash flows of the project to determine the sensitivity of the project NPV with the following changes in the value drivers and provide your results in (a) relevant tables: Unit sales decrease by 10% Price per unit decreases by 10% Variable cost per unit increases 10% Cash fixed cost per year increases by 10%

2. Perform an NPV break even analysis for the case where price per unit decreases by 10 % to identify the number of unit sales that is needed for the project to get break-even Trial and error method is to be used with excel spread sheet.