Task $3$

To illustrate and further support our strategic financial planning systems we need to show the CFO and management team an example of the application of the previously constructed WACC. The CFO thinks that showing management how we can validate and choose projects based on expected returns developed from the WACC will help reduce the risk of our investor$$s capital thus lowering the required rate of return we would have to provide to those investors. If we lower our expected return we can then do more projects and grow at a faster rate.

He has asked your team to evaluate the following project:

Capital investment: BEB is planning the construction of a new loading ramp for its single mill. The initial cost of the investment is $$600,000,$ followed by an investment of $$200,00010$ years later and another investment of $$200,00020$ years later and finally an investment of $$1,000,000$ for environmental cleanup at the end of the project $30$ years from now. Efficiencies from the new ramp are expected to reduce costs by $$50,000$ per year $($at the end of every year$)$ for the life of the plant, which is currently estimated at $30$ years $($savings of $$50,000$ a year from $30$ years$).$ These savings can be assumed to be reinvested at a rate of $9\%$ pa$.$ What is the NPV of the project if BEB has a required rate of return of $7\%?$ What is the MIRR of the project if the investing return rates $($with the loading ramp used as collateral$)$ for a period of $10$ years is $6\%$ pa and the term structure of investing return rates for Y years $($Y $>15)$ is $6\%+0\mathrm{.}0183*(1-(1/($Y$-9))$ pa$?$ You should use these investing return rates to discount back $($to the present$)$ the future investments that the loading ramp needs.

Concept Check: We need to adjust cash flows to account for things like inflation, our cost of capital, and opportunity costs. Simply looking at cash flow not adjusted for some of these costs will lead to taking on projects which are not adding to the value of the organization.

Helpful Hint: The first step in conducting an NPV analysis is to include all the relevant cash flows. This includes savings from taxes and any expenses directly related to the venture. We reject any project with a negative NPV$.($any part that can be done in excel is appreciated$)$