Question

In: Finance

Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment...

Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment of $3.7 million. The fixed asset falls into the 3-year MACRS class (MACRS Table) and will have a market value of $285,600 after 3 years. The project requires an initial investment in net working capital of $408,000. The project is estimated to generate $3,264,000 in annual sales, with costs of $1,305,600. The tax rate is 24 percent and the required return on the project is 17 percent.

What is the project's year 0 net cash flow?

What is the project's year 1 net cash flow?

What is the project's year 2 net cash flow?

What is the project's year 3 net cash flow?

What is the NPV?

Solutions

Expert Solution

Initial Investment = $3,700,000
Useful Life = 3 years

Depreciation Year 1 = 33.33% * $3,700,000
Depreciation Year 1 = $1,233,210

Depreciation Year 2 = 44.45% * $3,700,000
Depreciation Year 2 = $1,644,650

Depreciation Year 3 = 14.81% * $3,700,000
Depreciation Year 3 = $547,970

Book Value at the end of Year 3 = $3,700,000 - $1,233,210 - $1,644,650 - $547,970
Book Value at the end of Year 3 = $274,170

After-tax Salvage Value = Salvage Value - (Salvage Value - Book Value) * tax rate
After-tax Salvage Value = $285,600 - ($285,600 - $274,170) * 0.24
After-tax Salvage Value = $282,856.80

Initial Investment in NWC = $408,000

Year 0:

Net Cash Flows = Initial Investment + Initial Investment in NWC
Net Cash Flows = -$3,700,000 - $408,000
Net Cash Flows = -$4,108,000

Year 1:

Operating Cash Flow = (Sales - Costs) * (1 - tax) + tax * Depreciation
Operating Cash Flow = ($3,264,000 - $1,305,600) * (1 - 0.24) + 0.24 * $1,233,210
Operating Cash Flow = $1,784,354.40

Net Cash Flows = Operating Cash Flow
Net Cash Flows = $1,784,354.40

Year 2:

Operating Cash Flow = (Sales - Costs) * (1 - tax) + tax * Depreciation
Operating Cash Flow = ($3,264,000 - $1,305,600) * (1 - 0.24) + 0.24 * $1,644,650
Operating Cash Flow = $1,883,100

Net Cash Flows = Operating Cash Flow
Net Cash Flows = $1,883,100

Year 3:

Operating Cash Flow = (Sales - Costs) * (1 - tax) + tax * Depreciation
Operating Cash Flow = ($3,264,000 - $1,305,600) * (1 - 0.24) + 0.24 * $547,970
Operating Cash Flow = $1,619,896.80

Net Cash Flows = Operating Cash Flow + NWC recovered + After-tax Salvage Value
Net Cash Flows = $1,619,896.80 + $408,000 + $282,856.80
Net Cash Flows = $2,310,753.60

Required Return = 17%

NPV = -$4,108,000 + $1,784,354.40/1.17 + $1,883,100/1.17^2 + $2,310,753.60/1.17^3
NPV = $235,485.80


Related Solutions

Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment of $4.0 million. The fixed asset falls into the 3-year MACRS class (MACRS Table) and will have a market value of $310,800 after 3 years. The project requires an initial investment in net working capital of $444,000. The project is estimated to generate $3,552,000 in annual sales, with costs of $1,420,800. The tax rate is 22 percent and the required return on the project...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment of $1.944 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $151,200. The project requires an initial investment in net working capital of $216,000. The project is estimated to generate $1,728,000 in annual sales, with costs of $691,200. The tax rate is 22 percent and the required return...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment of $3.2 million. The fixed asset falls into the 3-year MACRS class (MACRS Table) and will have a market value of $247,800 after 3 years. The project requires an initial investment in net working capital of $354,000. The project is estimated to generate $2,832,000 in annual sales, with costs of $1,132,800. The tax rate is 22 percent and the required return on the project...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment of $4.59 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $357,000. The project requires an initial investment in net working capital of $510,000. The project is estimated to generate $4,080,000 in annual sales, with costs of $1,632,000. The tax rate is 22 percent and the required return...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment of $4.1 million. The fixed asset falls into the 3-year MACRS class (MACRS Table) and will have a market value of $315,000 after 3 years. The project requires an initial investment in net working capital of $450,000. The project is estimated to generate $3,600,000 in annual sales, with costs of $1,440,000. The tax rate is 22 percent and the required return on the project...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment of $5.13 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $399,000. The project requires an initial investment in net working capital of $570,000. The project is estimated to generate $4,560,000 in annual sales, with costs of $1,824,000. The tax rate is 25 percent and the required return...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment of $2.16 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $168,000. The project requires an initial investment in net working capital of $240,000. The project is estimated to generate $1,920,000 in annual sales, with costs of $768,000. The tax rate is 22 percent and the required return...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment of $4.536 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $352,800. The project requires an initial investment in net working capital of $504,000. The project is estimated to generate $4,032,000 in annual sales, with costs of $1,612,800. The tax rate is 22 percent and the required return...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment of $2.97 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $231,000. The project requires an initial investment in net working capital of $330,000. The project is estimated to generate $2,640,000 in annual sales, with costs of $1,056,000. The tax rate is 24 percent and the required return...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment...
Quad Enterprises is considering a new 3-year expansion project that requires an initial fixed asset investment of $3.564 million. The fixed asset will be depreciated straight-line to zero over its 3-year tax life, after which time it will have a market value of $277,200. The project requires an initial investment in net working capital of $396,000. The project is estimated to generate $3,168,000 in annual sales, with costs of $1,267,200. The tax rate is 24 percent and the required return...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT