Question

Aday Acoustics, Inc., projects unit sales for a new 7-octave voice emulation implant as follows: Year Unit Sales 1 75,900 2 81,300 3 87,400 4 84,200 5 71,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 $4,050,000 per year, variable production costs are $148 per unit, and the units are priced at $330 each. The equipment needed to begin production has an installed cost of $19,000,000. Because the implants are intended for professional singers, this equipment is considered industrial machinery and thus qualifies as 7-year MACRS property. In five years, this equipment can be sold for about 15 percent of its acquisition cost. The company is in the 23 percent marginal tax bracket and has a required return on all its projects of 17 percent. MACRS schedule. What is the NPV of the project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) What is the IRR of the project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

Answer 1

AAI	0	1	2	3	4	5
MACRS		14.29%	24.49%	17.49%	12.49%	8.93%	22.31%
Unit Sales		75900	81300	87400	84200	71500	$ 4,238,900
Investment	-$    19,000,000
NWC	-$       1,530,000	-$      178,200	-$      201,300	$       105,600	$       419,100	$   1,384,800
Salvage						$   2,850,000
Sales		$ 25,047,000	$ 26,829,000	$ 28,842,000	$ 27,786,000	$ 23,595,000
VC		-$ 11,233,200	-$ 12,032,400	-$ 12,935,200	-$ 12,461,600	-$ 10,582,000
FC		-$   4,050,000	-$   4,050,000	-$   4,050,000	-$   4,050,000	-$   4,050,000
Depreciation		-$   2,715,100	-$   4,653,100	-$   3,323,100	-$   2,373,100	-$   1,696,700
EBT		$   7,048,700	$   6,093,500	$   8,533,700	$   8,901,300	$   7,266,300
Taxes (23%)		-$   1,621,201	-$   1,401,505	-$   1,962,751	-$   2,047,299	-$   1,671,249
Net Income		$   5,427,499	$   4,691,995	$   6,570,949	$   6,854,001	$   5,595,051
Cash Flows	-$    20,530,000	$   7,964,399	$   9,143,795	$   9,999,649	$   9,646,201	$ 11,845,998
NPV	$ 9,751,118.63
IRR	34.99%

Sales = Unit Sales x Price

Variable Cost (VC) = Unit Sales x cost per unit

Depreciation = Investment x MACRS %

Cash Flows = Investment + NWC + (Salvage - Book Value) x (-tax rate) + Salvage + Net Income + Depreciation

NPV and IRR can be calculated using the same function in excel with 17% discount rate.