capital budgeting problem. bravo company is considering a plan to construct a new manufacturing plant to expand its operation. an attractive piece of land is available which could be purchase immediately for $100,000. bravo would build a plant on the land at a cost of $200,000 and outfitted facility could be ready for use in only two months. the plant has an estimated 20 year life and would be depreciated over that life on a straight line basis to an estimated $100,000 salvage value. the equipment has an estimated 10 year life and would also be depreciated on a staight line basis to its salvage value of $10,000. forecasts of production levels and future sales indicate that the product of the plant could be sold for cash income before taxes of $150,000 per year for each of the 10 years the plant would be operated.at the end of 10 years, bravo would sell the entire facility. Bravo anticipates receiving $225,000 for the land, $130,000 for the building and $10,000 for the equiipment. An investment of $30,000 in working capital would be necessary immediately. this amount would remain unchanged over the life of the facility and could be retrieved in full at the end of the 10 year period. Bravo has a 12% cost of capital and pays taxes atthe rate of 34%

1)determine the cash flows from this project.

2) calculate this investment's

a. payback period

b. net present value(NPV).

c. internal rate of return (IRR)

3. what decision (accept or reject) should bravo make? why?

4. obtain the terminal value, fully invested NPV(NPV*) and fully invested IRR(IRR*) for reinvestment rates of 0%, 5%, 10%, 12% and 15%. Interpret these figures.

HOW TO SOLVE THIS PROBLEM IN EXCEL?