Question

V. Rahr and Sons is a Fort Worth brewery founded by Fritz Rahr, a Neeley undergraduate and MBA. Currently the company makes Rahr Blonde Lager, Rahr’s Red, and Ugly Pug brews. They are considering a new beer, Frog Princess, with which to celebrate their ties to TCU. The project includes an initial outlay of $750,000 for the purchase of capital equipment that will be depreciated straight line to zero over six years.

Sales are expected to be $400,000 in years 1-3 and $600,000 in years 4-6. Production costs during years 1-6 are as follows: fixed costs (not including depreciation) are expected to be $150,000 per year; variable costs per year will be 40% of sales. The project will require an initial investment in NWC of 200,000 in year 0.

Beyond year six, the company expects that sales and unlevered net income in year seven will be 4% higher than that in year 6, and will continue growing at 4% per year infinitely. Additionally, in year 7 and beyond, new capital expenditures net of depreciation, and increases in NWC, combined, will be 6% of sales. Assume the marginal tax rate is 21%. The appropriate discount rate is 8%.

What is the NPV of the project? What is the IRR? Should the project be undertaken?

I've asked this question three times now and gotten three different answers so I want to see if this will confirm the right one. Thanks

Answer 1

SEE EXCEL SHEET IMAGE

GO THROUGH. ANY DOUBTS, FEEL FREE TO ASK. GIVE POSITIVE FEEDBACK

PERPETUAL CFAT = CFAT/ (i-g)