Question

quad enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of 2.38 million.The fixed asset qualifies for 100 percent bonus depreciation in the first year. The project is estimated to generate 1,805,000 in annual sales, with costs of 696,000. The project requires an initial investment in net working capital of 440,000, and the fixed asset will have a market value of 465,000 at the end of the project. a. If the tax rate is 24 percent, what is the project's Year 0 net cash flow? Year 1? Year 2? Year 3? b. If the required return is 11 percent, what is the project's NPV?

Answer 1

Calculation of Year 0 Net cash flow
	Year 0
Initial fixed asset investment	-$2,380,000.00
Initial investment in net working capital	-$440,000.00
Year 0 Net Cash flow	-$2,820,000.00
Calculation of Year 1 Net cash flow			Calculation of Year 2 Net cash flow			Calculation of Year 3 Net cash flow
	Year 1			Year 2			Year 3
Sales	$1,805,000.00		Sales	$1,805,000.00		Sales	$1,805,000.00
Costs	-$696,000.00		Costs	-$696,000.00		Costs	-$696,000.00
Depreciation	-$2,380,000.00		Depreciation	$0.00		Depreciation	$0.00
Profit before Tax	-$1,271,000.00		Profit before Tax	$1,109,000.00		Profit before Tax	$1,109,000.00
Tax Savings @ 24%	$305,040.00		Tax @ 24%	-$266,160.00		Tax @ 24%	-$266,160.00
Depreciation	$2,380,000.00					After tax market value of project	$353,400.00
Year 1 Net Cash flow	$1,414,040.00		Year 2 Net Cash flow	$842,840.00		Year 2 Net Cash flow	$1,196,240.00
Calculation of Project's NPV
Year	Cash flow	Discount factor @ 11%	Present Values
0	-$2,820,000.00	1	-$2,820,000.00
1	$1,414,040.00	0.900900901	$1,273,909.91
2	$842,840.00	0.811622433	$684,067.85
3	$1,196,240.00	0.731191381	$874,680.38
Project's NPV			$12,658.14