How do you do in excel form?

5. Project Evaluation. Aria Acoustics, Inc. (AAl), projec new seven-octave voice emulation implant as follows: unit sales for a Year Unit Sales 67,500 83,900 98,700 86,000 72,000 Production of the implants will require $1,500,000 in net working capital to start and additional net working capital investments each year equal to 15 per cent of the projected sales increase for the following year. Total fixed costs are $1,950,000 per year, variable production costs are $230 per unit, and the unis are priced at $355 each. The equipment needed to begin production has an in stalled cost of $18,500,000. Because the implants are intended for professional singers, this equipment is considered industrial machinery and thus qualifes as seven-year MACRS property. In five years, this equipment can be so ld for about 20 percent of its acquisition cost. AAI is in the 35 percent ma bracket and has a required return on all its projects of 15 percent.as o IRR preliminary project estimates, what is the NPV of the projc percent. Based on these What is the IRR all its projects of 15