Question

IDE Company X projects numbers of unit sales for a new project as follows: 81,000 (year 1), 89,000 (year 2), 97,000 (year 3),

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Tax 35% Year 0 1 2 3 4 5
Required rate of return 18% Initital Investment $19,500,000
Salvage 35% Working Capital $1,500,000
Working Capital 15% MACR 14.29% 24.49% 17.49% 12.49% 8.93%
Sales unit 81000 89000 97000 92000 77000
Sales price per unit $345 $345 $345 $345 $345
Sales $ $27,945,000 $30,705,000 $33,465,000 $31,740,000 $26,565,000
Variable Price per unit $190 $190 $190 $190 $190
Variable price $ $15,390,000 $16,910,000 $18,430,000 $17,480,000 $14,630,000
Fixed Cost $1,850,000 $1,850,000 $1,850,000 $1,850,000 $1,850,000
Depreciation $2,786,550 $4,775,550 $3,410,550 $2,435,550 $1,741,350
EBIT $7,918,450 $7,169,450 $9,774,450 $9,974,450 $8,343,650
Taxes $2,771,458 $2,509,308 $3,421,058 $3,491,058 $2,920,278
Net Income $5,146,993 $4,660,143 $6,353,393 $6,483,393 $5,423,373
NWC $4,191,750 $4,605,750 $5,019,750 $4,761,000 $3,984,750
Change in NWC -$414,000 -$414,000 $258,750 $776,250 $1,293,000
BV $16,713,450 $11,937,900 $8,527,350 $6,091,800 $4,350,450
Salvage $6,825,000
Net Salvage $5,958,908
Net CF $5,560,993 $5,074,143 $6,094,643 $5,707,143 $10,089,280

After Tax Salvage Value = Salvage Value - (Salvage Value-Book Value)*Tax

1 2 3 4 1 Tax 2 Required rate of return 3 Salvage 4 Working Capital 0 $19,500,000 $1,500,000 8.93% 77000 $345 $26,565,000 $191 1 Tax 0.35 2 Required rate of return 0.18 3 Salvage 0.35 4 Working Capital 0.15 19500000 1500000 89000 Year Initital InvestB) NPV = -$1,579,938.89, IRR= 14.92%

c)

Rate NPV
6.00% $5,939,255.81
8.00% $4,398,964.74
10.00% $2,990,653.25
12.00% $1,700,214.02
14.00% $515,303.97
16.00% -$574,905.48
18.00% -$1,579,938.89
20.00% -$2,508,194.89
22.00% -$3,367,097.28
24.00% -$4,163,223.53
26.00% -$4,902,414.56
28.00% -$5,589,868.59
30.00% -$6,230,221.73
32.00% -$6,827,617.30
34.00% -$7,385,765.63
36.00% -$7,907,995.76
38.00% -$8,397,300.24
40.00% -$8,856,374.09

K 1 2 А 1 Tax 2 Required rate of return 3 Salvage 4 Working Capital 5 NPV IRR -$1,579,938.89 14.92% 35% Year 18% Initital Invм IRR 345 345 1 0.35 Year lo 1 2 0.18 Initital Investment 19500000 3 0.35 Working Capital 1500000 4 0.15 MACR 0.1429 0.2449 0d)

SP VC NPV
300 160 -$4,262,440
320 170 -$2,479,346
340 180 -$696,253
360 190 $1,086,841
380 200 $2,869,934
400 210 $4,653,028
Add a comment
Know the answer?
Add Answer to:
IDE Company X projects numbers of unit sales for a new project as follows: 81,000 (year...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Aday Acoustics, Inc., projects unit sales for a new 7-octave voice emulation implant as follows: Year...

    Aday Acoustics, Inc., projects unit sales for a new 7-octave voice emulation implant as follows: Year Unit Sales 78,000 83,400 90,200 86,300 74,300 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 $4,400,000 per year, variable production costs are $155 per unit, and the units are priced at $337 each. The...

  • Aylmer-in-You (AIY) Inc. projects unit sales for a new opera tenor emulation implant as follows: Year...

    Aylmer-in-You (AIY) Inc. projects unit sales for a new opera tenor emulation implant as follows: Year Unit Sales 1 98,000 2 112,000 3 122,000 4 142,000 5 87,000 Production of the implants will require $729,000 in net working capital to start and additional net working capital investments each year equal to 25% of the projected sales increase for the following year. (Because sales are expected to fall in Year 5, there is no NWC cash flow occurring for Year 4.)...

  • Aday Acoustics, Inc., projects unit sales for a new 7-octave voice emulation implant as follows: Year...

    Aday Acoustics, Inc., projects unit sales for a new 7-octave voice emulation implant as follows: Year nmt Unit Sales 77,100 82,500 89,000 85,400 73,100 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 15 percent of the projected sales increase for the following year. Total fixed costs are $4,250,000 per year, variable production costs are $152 per unit, and the units are priced at $334 each....

  • Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows:...

    Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: Year Unit Sales 74,600 87,600 107.000 99,400 68,100 Production of the implants will require $1,900,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 $4,000,000 per year, variable production costs are $263 per unit, and the units are priced at $399 each....

  • Project Evaluation. Aguilera Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant...

    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...

  • Project Evaluation. Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant...

    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...

  • Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows:...

    Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows: Year Unit Sales 73,000 86,000 105,000 97,000 67,000 mo 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 $3,200,000 per year, variable production costs are $255 per unit, and the units are priced at $375 each....

  • We project unit sales for a new household-use laser-guided cockroach search and destroy system as follows:...

    We project unit sales for a new household-use laser-guided cockroach search and destroy system as follows: Unit Sales Year 100,500 112,500 135,500 141,500 94,500 1 2. 3 4 5 The new system will be priced to sell at $470 each. The cockroach eradicator project will require $2,100,000 in net working capital to start, and total net working capital will rise to 15% of the change in sales. The variable cost per unit is $340, and total fixed costs are $2,400,000...

  • A company with name XYZ starts a new project with life 4 years. The company will...

    A company with name XYZ starts a new project with life 4 years. The company will put 20.000.000 USD in the project. The estimated sales per year is 1200 units a)Selling price for first year is 45.000USD/unit b)Variable cost for first yaer is 35.000USD/unit c)Fixed cost for first year is 2.000.000 USD d)Depreciation rates per year:20% , 32%,19.20%, 11.52% e)Net working capital requirements for the project are 20% of the projected annual sales at the beggining of each yea.r f)...

  • Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows...

    Aria Acoustics, Inc. (AAI), projects unit sales for a new seven-octave voice emulation implant as follows Year 2 4 Unit Sales 73,000 86,000 105,000 97,000 67,000 5 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 $3,200,000 per year, variable production costs are $255 per unit, and the units are priced...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT