Project Evaluation Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: Year 1 Unit Sales 71,000 2 84,000 3 103,000 4 5 95,000 64,000 Production of the implants will require $2.3 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.9 million per year, variable production costs are $285 per unit, and the units are priced at $410 each. The equipment needed to begin production has an installed cost of $14.8 million. Because the implants are intended for professional singers, this equipment is considered industrial 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 21 percent and the required return is 18 percent. Based on these preliminary project estimates, what is the NPV of the project? What is the IRR?

EBK CONTEMPORARY FINANCIAL MANAGEMENT
14th Edition
ISBN:9781337514835
Author:MOYER
Publisher:MOYER
Chapter11: Capital Budgeting And Risk
Section: Chapter Questions
Problem 15P
icon
Related questions
Question

Can you answer these in Excel (and show any calculation formulas). See the attached image for the information. 

1. What is the payack period, NPV, IRR?

2. What happens to the NPV and IRR if initial capital goes up 30%?

3. How much would the selling price have to increase to compensate for 30% in capital costs to the original level in 1.?

4. What is your recomendation?

Project Evaluation Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant
as follows:
Year
1
Unit Sales
71,000
2
84,000
3
103,000
4 5
95,000
64,000
Production of the implants will require $2.3 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.9 million per year, variable production costs are $285 per unit, and the units are priced at $410 each. The
equipment needed to begin production has an installed cost of $14.8 million. Because the implants are intended for
professional singers, this equipment is considered industrial 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 21
percent and the required return is 18 percent. Based on these preliminary project estimates, what is the NPV of the
project? What is the IRR?
Transcribed Image Text:Project Evaluation Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: Year 1 Unit Sales 71,000 2 84,000 3 103,000 4 5 95,000 64,000 Production of the implants will require $2.3 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.9 million per year, variable production costs are $285 per unit, and the units are priced at $410 each. The equipment needed to begin production has an installed cost of $14.8 million. Because the implants are intended for professional singers, this equipment is considered industrial 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 21 percent and the required return is 18 percent. Based on these preliminary project estimates, what is the NPV of the project? What is the IRR?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning