Question: M. Project Evaluation [LOL] Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: Year 1 2 AWN Unit

 M. Project Evaluation [LOL] Aria Acoustics, Inc. (AAI), projects unit sales

M. Project Evaluation [LOL] Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: Year 1 2 AWN Unit Sales 73.000 86,000 105,000 97.000 67,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 percent of the pro- Jected sales increase for the following year. Total fixed costs are $3,200,000 per year, Variable production costs are $255 per unit , and the units are priced at $375 each. The equipment needed to begin production has an installed cost of $16,500,000. Because the implants are intended for professional singers, this equipment is considered in- destrial machinery and thus qualifies as seven-year MACRS property. In five years, this equipment can be sold for about 20 percent of its acquisition cost . The tax rate is 1 percent and the required return is 18 percent. Based on these preliminary project mates, what is the NPV of the project? What is the IRR? A couple of things please 1) This needs to be done in Microsoft Office Excel 2)Instead of putting the answers I need the equations to the answers also. See this link for an example: https://www.chegg.com/homework-help/questions- and-answers/couple-things-person-answers-1-needs- done-msfs-excel-2-one-question-3-parts-question- per-c-976090663?trackid=7qyFcD5Q. I need the equations otherwise this will not work. Thanks

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!