Consider a project that involves the purchase of a $100,000 machine. The machine will last for three years. It is expected to produce 20,000 units per year. The sales price for each unit will be $32, and variable costs will be $25 per unit. The project will also incur fixed labor costs of $45,000 per year. It will require no additional investment in net working capital and is expected to have a salvage value of $5,000 in three years. The machine will be depreciated using the MACRS schedule below (note that this schedule has 4 years of depreciation, but the machine will be sold after 3 years). The tax rate is 40%, and the discount rate is 10%. You may want do this problem in Excel, and then copy the numbers into your Word document.
(a) Construct a table of the relevant cash flows for this project, and compute the NPV and IRR of the project.
(b) What is the minimum unit price (to the nearest cent) that would justify investment?