Question

In: Finance

Using a WACC of 15%, apply four capital budgeting techniques to evaluate the project, assuming the...

Using a WACC of 15%, apply four capital budgeting techniques to evaluate the project, assuming the Free Cash Flows are as follows: Years Free Cash Flows 0 $ (252,000.00) 1 $ 118,625.00 2 $ 127,125.00 3 $ 181,000.00 The four techniques are NPV, IRR, MIRR, and discounted Payback. Assume the reinvestment rate to be 8% for the MIRR. Also, assume that the business will only accept projects with a payback period of two and half years or less.

Solutions

Expert Solution

NPV is the Net present value of all cashflows associated with the project at time t=0, discounted at WACC or required rate of return.

IRR is the rate of return at which NPV is equal to 0.

Modified internal rate of return (MIRR) assumes that positive cash flows are reinvested at the firm's cos of capital, and the initial outlays are financed at the firm's financing cost. By contrast, the IRR assumes the cash flows from a project are reinvested at the IRR.

A discounted payback period gives the number of years it takes to break even from undertaking the initial expenditure, bydiscounting future cash flows and recognizing the time value of money.

NPV and Discounted payback could be calculated manually. However, we would need Excel for calculating MIRR and IRR.

Year

Cashflows

Discounted Cashflow

0

$ (252,000.00)

= -252000/(1 + 0.15)^0 = $ (252,000.00)

1

$    118,625.00

= 118625/(1 + 0.15)^1 = $ 103,152.17

2

$    127,125.00

= 127125/(1 + 0.15)^2 = $ 96,124.76

3

$    181,000.00

= 181000/(1 + 0.15)^3 = $ 119,010.44

NPV = - $252,000 + $103,152.17 + $96,124.76 + $119,010.44 = $66,287.38

Positive NPV means the project will add value to the firm and hence should be selected.

Discounted Payback

For discounted payback, we need to calculate the time taken by the discounted cashflows to re-earn invested amount.

In 2 years, amount earned = $103,152.17 + $96,124.76 = $199,276.94. $52,723.06 more is required to re-earn the invested amount of $252,000. But last year discounted cashflow is $119,010.44, which is more than what we require.

So, it takes 1 year to earn $119,010.44

Fraction of year it would take to earn $52,723.06 = $52,723.06/$119,010.44 = 0.44

Hence discounted payback = 2 years + 0.44 year = 2.44 years

This is less than 2.5 threshold of payback period (given in question). Hence the project is selectable based on discounted payback period as well.

IRR and MIRR calculation in Excel are shown below. NPV calculations are also shown

Now, the rule for both IRR and MIRR remain the same. Since both are higher than WACC (return generated higher than cost incurred on capital), hence the project is selectable by both IRR and MIRR approach as well.


Related Solutions

“Can we apply capital budgeting techniques within the public sector? Explain using current event examples or...
“Can we apply capital budgeting techniques within the public sector? Explain using current event examples or examples from the text”.
The WACC is used as the discount rate to evaluate various capital budgeting projects. However, it...
The WACC is used as the discount rate to evaluate various capital budgeting projects. However, it is important to realize that the WACC is an appropriate discount rate only for a project of average risk. Analyze the cost of capital situations of the following company cases, and answer the specific questions that finance professionals need to address. Consider the case of Turnbull Co. Turnbull Co. has a target capital structure of 58% debt, 6% preferred stock, and 36% common equity....
Evaluate the capital budgeting project using the traditional Net Present Value (NPV) approach and the Internal...
Evaluate the capital budgeting project using the traditional Net Present Value (NPV) approach and the Internal Rate of Return (IRR) criterion and present findings. Find if this new proposal will turn out to be a good investment for his company. Capital budgeting and investment proposal – a new product line of branded shirts that the committee was considering for launch. What would be the basis for calculating the after-tax operating cash flows for the capital project? How would you arrive...
You are assigned to estimate the firm’s Weighted-Average-Cost-of-Capital (WACC) in order to evaluate capital budgeting opportunities....
You are assigned to estimate the firm’s Weighted-Average-Cost-of-Capital (WACC) in order to evaluate capital budgeting opportunities. The company operates in the 20% marginal tax bracket. There are three classes of long-term liabilities and equity outstanding. (1) First, the firm has 127,500 shares of common stock outstanding, which are currently trading at $88.91 per share. You will use the Gordon Growth Model to estimate a required return for the equity holders. The most recent earnings per share was $6.72.You estimate that...
Describe the problems with using the IRR statistic to evaluate capital budgeting projects. What is the...
Describe the problems with using the IRR statistic to evaluate capital budgeting projects. What is the solution to these problems?
A firm is considering investing in a 15-year capital budgeting project with a net investment of...
A firm is considering investing in a 15-year capital budgeting project with a net investment of $14 million. The project is expected to generate annual net cash flows each year of $2 million and a terminal value at the end of the project of $10 million. The firm’s cost of capital is 9 percent and marginal tax rate is 40%. What is the profitability index of this investment?
Capital Budgeting Techniques: An Overview of Pros and Cons There are three types of techniques most...
Capital Budgeting Techniques: An Overview of Pros and Cons There are three types of techniques most common in capital budgeting projects. These techniques include the Payback Method, Internal Rate of Return, and Net Present Value. Compare and contrast all three of these techniques and report the challenges and benefits of using each. Then, from these three recommend the one you feel is most beneficial for companies to use in their budgeting processes and support your decision with at least three...
Using capital budgeting, recommend a capital investment project and discuss what value will it add to...
Using capital budgeting, recommend a capital investment project and discuss what value will it add to the firm and should the organisation take up the project or not? the firm can be an educational institue or pharmaceutical company or any defined business.
XYZ, Inc. is considering a 5 year, 12% WACC capital budgeting project under three scenarios. If...
XYZ, Inc. is considering a 5 year, 12% WACC capital budgeting project under three scenarios. If conditions are excellent, the cash flows from this project are expected to be $4,000 per year; under fair conditions, cash flows are projected at $2,500 per year; and under unfavorable conditions, cash flows are projected at ($600) per year. The initial investment outlay is $3,000 and the probabilities of these three conditions are 30%, 50% and 20%, respectively. Assume that XYZ has the option...
Capital Budgeting and Risk Analysis Define the most important capital budgeting techniques. name at least two...
Capital Budgeting and Risk Analysis Define the most important capital budgeting techniques. name at least two (2) capital budgeting techniques (e.g., NPV, IRR, Payback Period, etc.) that you used to arrive investment decision.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT