Please show all work in an Excel spreadsheet, showing all calculations in each cell.

Please show all work in an Excel spreadsheet, showing all calculations in each cell. 4. Mini...
Project Evaluation. Aguilera Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: 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 projected sales increase for the following year. Total fixed costs are $1,450,000 per year, variable production costs are $230 per unit, and the units are priced at $355 each. The equipment needed to begin production...
Question 3. (25 marks) Aguilera Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: Year Unit Sales 91,000 106,000 1 2 111,000 3 104,500 4 5 81,000 Production of the implants will require $1,600,000 in net working capital to start and additional net working capital investments each year equal to 15 percent of the projected sales increase for the following year. Total fixed costs are $1,500,000 per year, variable production costs are $265 per...
Aguilera Acoustics, Inc., (AAI) projects unit sales for a new seven-octave voice emulation implant as follows: Year Unit Sales 1 87,500 2 105,000 3 119,000 4 108,000 5 92,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 projected sales increase for the following year. Total fixed costs are $1,450,000 per year, variable production costs are...
Project Evaluation. Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: 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 networking capital investments each year equal to 15 percent 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 units are priced at $355...
Please show steps in excel for
practice
Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: Unit Sales 87,000 100,000 114,000 109,000 90,000 Year 4 Production of the implants will require $1,660,000 in net working capital to start and additional net working capital investments each year equal to 15 percent of the projected sales increase for the following year. Total fixed costs are $1,560,000 per year, variable production costs are $295 per unit,...
Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: Year Unit Sales 1 72,000 2 85,000 3 99,000 4 94,000 5 75,000 Production of the implants will require $1,510,000 in net working capital to start and additional net working capital investments each year equal to 10 percent of the projected sales increase for the following year. Total fixed costs are $1,410,000 per year, variable production costs are $220 per unit, and the units...
Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: Year WN Unit Sales 71,500 87.800 104,300 89,200 75,300 Production of the implants will require $1.5 million in net working capital to start and additional net working capital investments each year equal to 15 percent of the projected sales increase for the following year. Total fixed costs are $2.15 million per year, variable production costs are $230 per unit, and the units are priced...
Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: Year AM Unit Sales 78,000 91,000 105,000 100,000 81,000 Production of the implants will require $1,570,000 in net working capital to start and additional net working capital investments each year equal to 10 percent of the projected sales increase for the following year. Total fixed costs are $1,470,000 per year, variable production costs are $250 per unit, and the units are priced at $365...
Aria Acoustics, Inc., (AAI) projects unit sales for a new seven-octave voice emulation implant as follows: YearUnit Sales1109,5002128,5003116,500499,500585,500 Production of the implants will require $1,530,000 in net working capital to start and additional net-working capital investments each year equal to 10 percent of the projected sales increase for the following year. Total fixed costs are $1,380,000 per year, variable production costs are $228 per unit, and the units are priced at $348 each. The equipment needed to begin production has an...
Aria Acoustics, Inc., (AAI) projects unit sales for a new seven-octave voice emulation implant as follows: Year Unit Sales 1 114,500 2 133,500 3 121,500 4 104,500 5 90,500 Production of the implants will require $1,840,000 in net working capital to start and additional net working capital investments each year equal to 20 percent of the projected sales increase for the following year. Total fixed costs are $1,480,000 per year, variable production costs are $238 per unit, and the units...