Explore BrainMass

Capital Budget

See the attached file.

A project requires an initial investment of $300,000 to purchase a processing equipment. This equipment will be depreciated on a straight line schedule over 5 years.

The sales revenue is $400,000 each year for three years and the cost is $200,000 each year for three years. At the end of the third year, the equipment will be sold at its book value.

The working capital required is $100,000 at t=0, $120,000 at t=1, $120,000 at t=2, and 0 at t=3.

The tax rate is 40%, and the cost of capital 15%.

Calculate NPV, IRR, payback period, and profitability index of the project.

As part of the solution, please view the attached excel spreadsheet. To fully understand the solution the empty fields in the table should be filled out.


Solution Summary

The solution does a superb job of laying out step by step explanation to the problem. The solution is very well explained and uses detailed steps to explain the answer. The solution can be followed by anyone with a basic understanding of the concepts. Overall, an excellent response.