Please solve A. and B. using the information given in problem 3. It would be greatly appreciated if the solution was in excel format

3) You are considering an investment project with the following financial information: Required investment = $500,000 Project life = 5 years Salvage value = $50,000 Depreciation method = straight-line deprecation (no half-year convention) Unit price = $40 Unit variable cost = $18 Fixed annual cost = $230,000 Annual sales volume = 100,000 units Tax rate = 35% MARR = 15% a) The company is concerned about the price estimate they have used to calculate the rate of return. Using sensitivity analysis, how much can the price vary to still break-even? (20 points) 3) You are considering an investment project with the following financial information: Required investment = $500,000 Project life = 5 years Salvage value = $50,000 Depreciation method = straight-line deprecation (no half-year convention) Unit price = $40 Unit variable cost = $18 Fixed annual cost = $230,000 Annual sales volume = 100,000 units Tax rate = 35% MARR = 15% a) The company is concerned about the price estimate they have used to calculate the rate of return. Using sensitivity analysis, how much can the price vary to still break-even? (20 points)