Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: Year Unit Sales 1 79,000 2 92,000 3 106,000

Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: Year Unit Sales 1 79,000 2 92,000 3 106,000 4 101,000 5 82,000 Production of the implants will require $1,580,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,480,000 per year, variable production costs are $255 per unit, and the units are priced at $370 each. The equipment needed to begin production has an installed cost of $20,800,000. 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. AAI is in the 35 percent marginal tax bracket and has a required return on all its projects of 18 percent. Table 8.3. What is the NPV of the project? (Do not round intermediate calculations and round your final answer to 2 decimal places (e.g., 32.16).) NPV $ Please put into Excel format. I keep getting an impairment on my asset sale and I don't know if I've messed something up or how to handle it if it is indeed an impairment. Pasting my work below.

Year 0 1 2 3 4 5
Equipment Cost (20,800,000)
NWC (1,580,000)
Sales 29,230,000 34,040,000 39,220,000 37,370,000 30,340,000
Variable Costs (20,145,000) (23,460,000) (27,030,000) (25,755,000) (20,910,000)
Fixed Costs (1,480,000) (1,480,000) (1,480,000) (1,480,000) (1,480,000)
Depreciation (2,972,320.00) (5,093,920.00) (3,637,920.00) (2,597,920.00) (1,857,440.00)
EBT 4,632,680 4,006,080 7,072,080 7,537,080 6,092,560
Tax (1,621,438.00) (1,402,128.00) (2,475,228.00) (2,637,978.00) (2,132,396.00)
Net Income 3,011,242 2,603,952 4,596,852 4,899,102 3,960,164 After tax salvage value
Depreciation 2,972,320 5,093,920 3,637,920 2,597,920 1,857,440 Cost 20,800,000
OCF 5,983,562 7,697,872 8,234,772 7,497,022 5,817,604 Depreciation (16,159,520.00)
Change in Sales 13,000 14,000 (5,000) (19,000) Book value 4,640,480.00
Change in NWC 1,950.00 2,100.00 (750.00) (2,850.00) 0 Salvage value 4,160,000
Recovery of Working Capital 1,579,550 Impairment (480,480.00)
After tax salvage value (312,312.00) Tax 168,168.00
Net Cash Flows (22,380,000.00) 5,985,512.00 7,699,972.00 8,234,022.00 7,494,172.00 7,084,842 After tax salvage value (312,312.00)
Year Cash Flows
0 (22,380,000.00)
1 5,985,512.00
2 7,699,972.00
3 8,234,022.00
4 7,494,172.00
5 7,084,842
NPV $196,208.07

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Handbook Of Quantitative Finance And Risk Management

Authors: Cheng-Few Lee, John Lee

2010th Edition

0387771166, 978-0387771168

More Books

Students also viewed these Finance questions