Question

Quad Enterprises is considering a new three-year expansion project that requires an initial fixed asset investment of $2.67 million. The fixed asset falls into the three-year MACRS class. The project is estimated to generate $2,070,000 in annual sales, with costs of $767,000. The project requires an initial investment in net working capital of $290,000, and the fixed asset will have a market value of $265,000 at the end of the project.

  

If the tax rate is 34 percent, what is the project’s Year 0 net cash flow? Year 1? Year 2? Year 3? (MACRS schedule) (Enter your answers in dollars, not millions of dollars, e.g. 1,234,567. Negative amounts should be indicated by a minus sign. Do not round intermediate calculations and round your final answers to 2 decimal places, e.g., 32.16.)

Years	Cash Flow
Year 0	$
Year 1	$
Year 2	$
Year 3	$

If the required return is 13 percent, what is the project's NPV? (Enter your answer in dollars, not millions of dollars, e.g. 1,234,567. Do not round intermediate calculations and round your final answer to 2 decimal places, e.g., 32.16.)

NPV

$

Answer 1

Ref	Particulars		Year 1	Year 2	Year 3
a	Operating cash flow		$ 1,303,000.00	$         1,303,000.00	$ 1,303,000.00
	Gain on sale of asset				$      67,153.00
b	Depreciation		$   (889,911.00)	$        (1,186,815.00)	$   (395,427.00)
c=a-b	Profit before tax		$     413,089.00	$            116,185.00	$    974,726.00
	Less: taxes		$     140,450.26	$               39,502.90	$    331,406.84
	Profit after tax		$     272,638.74	$               76,682.10	$    643,319.16
	Add: depreciation		$     889,911.00	$         1,186,815.00	$    395,427.00
	Cash flow after tax		$ 1,162,549.74	$         1,263,497.10	$ 1,038,746.16
d	Present value factor@ 13.0%		0.884955752	0.783146683	0.693050162
e=c*d	Present value of annual cashflows		$ 1,028,805.08	$            989,503.56	$    719,903.19
	Total present value of annual cash inflows		$ 2,738,211.84
	Less: investment		$ 2,670,000.00
	NPV		$       68,211.84

Cash flow
Year 0	-2,670,000.00
Year 1	1,162,549.74
Year 2	1,263,497.10
Year 3	1,038,746.16
NPV	$      68,211.84

Gain
Particulars	Amount
Cost	$ 2,670,000.00
Depreciation	$ (2,472,153.00)
Adjusted basis	$     197,847.00
Sale price	$     265,000.00
Less: adjusted basis	$    (197,847.00)
Gain on sale	$        67,153.00

Please rate.