Question

In: Finance

Explain how to calculate the capital budgeting criterion (in excel) : NPV, IRR, MIRR, Payback, Discounted...

Explain how to calculate the capital budgeting criterion (in excel) : NPV, IRR, MIRR, Payback, Discounted Payback, Crossover Rate, and decide between mutually exclusive and/or independent projects

Solutions

Expert Solution

Capital budgeting criterion is calculated by using the formulas always available in excel.

1) Net Present Value

Use the following formula in excel:

Here, rate is the discount rate used, and value 1, value 2 and so forth are the cash flows recieved during the period, i.e. value 1 = cash flow of period 1

Do the same for both the projects and compare their values.

2) Internal Rate of Return

Here, the values are that of the cash flows, assuming equal size payment periods. The guess value asks the user to input a potential value. The formula works even if you leave this value blank as it is an optional value.

IRR is the rate for which, the discounted values of all the cash flows amount to 0, i.e. NPV is 0

Higher the IRR, better the project in most cases. When the cash flows of the project are not consistent a project can have multiple IRRs. In that case, NPV is a better measure to find out which project is better.

3) Modified Internal Rate of Return

MIRR function works similarly to the IRR function, except that it also considers the cost of borrowing the initial investment funds as well as compounded interest earned by reinvesting each cash flow. It is flexible enough to accommodate separate interest rates for borrowing and investing cash.

This function eliminates the downfalls of IRR function because it generates only one solution. The higher the MIRR, the better the project

4) Payback period

Payback period can be calculated by using cumulative cash flow. Eg :

Initial investment = $1000

Project life = 5 years

Cash flow for all 5 years = $300

Cumulative cash flow for first 3 years = $900

Remaining investment is $100

Cash flow for year 4 = $300

Therefore the payback period 3 + 100/300 = 3.33

5) Discounted payback period is the same as payback period but it uses cumulative discounted cash flow in place of cumulative cash flow.

Discounted cash flow is the present value of the cash flows of each year.

Present value is calculated as :

( Cash flow / ( 1 + Discount rate ) ) ^ number of periods

5) Crossover rate

Crossover rate is the rate at which the Net Present Values of both the projects are equal. It represents the rate of return at which the net present value profile of one project intersects the net present value profile of another project.

Crossover is calculated by calculating the IRR of the difference between the cash flows of the two projects.


Related Solutions

Calculate the five different criteria for evaluating projects (regular payback, discounted payback, NPV, IRR, and MIRR)...
Calculate the five different criteria for evaluating projects (regular payback, discounted payback, NPV, IRR, and MIRR) for the two projects listed below. The firm’s WACC is 9.90%. If the projects are mutually exclusive and the firm has sufficient budget available, which project (if any) would you choose to proceed with, and why? (Hint: you may want to create the full cash flow table for each project to fully show your work.) periods 0 1 2 3 4 project Hay cash...
SHOW YOUR WORK AND EXPLAIN PLEASE! Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback...
SHOW YOUR WORK AND EXPLAIN PLEASE! Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial cost of $60,000, expected net cash inflows of $10,000 per year for 8 years, and a cost of capital of 12%. Show your work. a. What is the project’s NPV? (Hint: Begin by constructing a timeline). b. What is the project’s IRR? c. What is the project’s MIRR? d. What is the project’s PI? e. What is the project’s...
. Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial...
. Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial cost of $60,000, expected net cash inflows of $10,000 per year for 8 years, and a cost of capital of 12%. Show your work. a. What is the project’s NPV? (Hint: Begin by constructing a timeline). b. What is the project’s IRR? c. What is the project’s MIRR? d. What is the project’s PI? e. What is the project’s payback period? f. What is...
23. Does the Payback Period, Discounted Payback Period, NPV, IRR, PI ratio and MIRR given you...
23. Does the Payback Period, Discounted Payback Period, NPV, IRR, PI ratio and MIRR given you the same accept/reject decision. Discuss the limitations of the methods that give you a decision different than that of the NPV.
Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial...
Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial Investment: -100,000 Annual project cash flow 22,000 for 6 years Cost of capital is 6%
What are the pros and cons of the various capital budgeting decision methods (NPV, IRR, MIRR,...
What are the pros and cons of the various capital budgeting decision methods (NPV, IRR, MIRR, PB, DPB)? If you had to pick one method to use for all project valuation situations, which one would you pick, and why? Please explain your answer! I am trying to understand the concept.
Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive...
Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive projects. The required rate of return is 15% and the target payback is 4 years. Explain which project is preferable under each of the four capital budgeting methods mentioned above: Table 1 Cash flows for two mutually exclusive projects Year Investment A Investment B 0 -$5,000,000 -5,000,000 1 $1,500,000 $1,250,000 2 $1,500,000 $1,250,000 3 $1,500,000 $1,250,000 4 $1,500,000 $1,250,000 5 $1,500,000 $1,250,000 6 $1,500,000...
Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive...
Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive projects. The required rate of return is 15% and the target payback is 4 years. Explain which project is preferable under each of the four capital budgeting methods mentioned above: Table 1 Cash flows for two mutually exclusive projects Year Investment A Investment B 0 -$5,000,000 -5,000,000 1 $1,500,000 $1,250,000 2 $1,500,000 $1,250,000 3 $1,500,000 $1,250,000 4 $1,500,000 $1,250,000 5 $1,500,000 $1,250,000 6 $1,500,000...
If these two projects are mutually exclusive, which project should the company accept based on the NPV, IRR, MIRR, payback, and discounted payback period for each project?
Considering the following projects.ProjectYear01234ACash flows-$100$35$35$35$35BCash flows-$100$60$50$40$30Project A has WACC = 6.00% while project B has WACC = 8.50%.If these two projects are mutually exclusive, which project should the company accept based on the NPV, IRR, MIRR, payback, and discounted payback period for each project?Would your decision (Your answer from part A) change if these two projects were independent?
Are the capital budgeting rules discussed in Chapter 5 (namely NPV, IRR, Payback Period and Profitability...
Are the capital budgeting rules discussed in Chapter 5 (namely NPV, IRR, Payback Period and Profitability Index) applicable to not-for-profit corporations? How should such entities make capital budgeting decisions? Defend your recommendation.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT