IceNine Inc. is considering the manufacture of a new widget. Equipment necessary for production will cost $16 million and it will be depreciated on a straight-line basis over the eight-year life. After the equipment is fully depreciated, the company will be abe to sell the equimpment for $3 million.The widget will retail for $250. The company expects to sell 190,000 widgets per year. Fixed costs will be $1,100,000 per year and variable costs are $20 per widget. Production will require an investment in net working capital of $1,500,000 at the start of the project. no additional working capital is needed during the project. The tax rate is 30 percent.

a) Perform a scenario analysis using 10 percent, 15 percent, and 20 percent cost of capital. Calculate IRR and NPV for each case.

b) Conduct sensitivity analysis using sales price and variable costs. (Show how NPVs are changing when you change the sales numbers and variable cost)

Please show steps in excel.