You will evaluate a five-year project with the following information using excel.

cost of machine $720000, Tax rate 30%, sales of 210000 units @ $2.95/unit, fixed costs are $65000, sales are expected to grow @ 5% annually, increase in account receivable $35000, inventory increase $25000, shipping expense $40000, expected salvage value $25000, cost of capital is .11, cash expense (variable cost) 0.43 of sales, cannibalization of $22000, beta=1.3, fully depreciate via straight-line over life of project

compute IRR

compute MIRR

compute NPV

Fine break-even unit sales