Make capital budgeting decisions utilizing various capital budgeting models.
Muscatel, Inc. is evaluating whether to build a bridge that will take two years to construct, or use a ferry to transport ore across a river. The cost of each alternative is a follows:
Investment year 0 $4,000,000 $1,000,000
Year 1 0 $750,000
Year 2 0 $750,000
Years 3-10 $1,500,000 $750,000
Annual operating cost $250,000 $100,000
Cost of capital 10% 10%
Using the payback method, net present value method, and internal rate of return method, this solution is computed in Excel and makes capital budgeting decisions based on the data.