18. In a situation such as Acron's, where a one-time costis followed by a sequence of cash flows, the internalrate of return (IRR) is the discount rate that makes theNPV equal to 0. The idea is that if the discount rate isgreater than the IRR, the company will not pursue theproject, but if the discount rate is less than the IRR, theproject is financially attractive.a. Use Excel's Goal Seek tool to find the IRR for theAcron model.b. Excel also has an IRR function. Look it up in onlinehelp to see how it works, and then use it on Acron'smodel. Of course, you should get the same IRR asin part a.c. Verify that the NPV is negative when the discountrate is slightly greater than the IRR, and that it ispositive when the discount rate is slightly less than

Using Excel for IRR: a. Goal Seek: Excel's Goal Seek is used to find the correct input when you know…

Answered: 18. In a situation such as Acron's,…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Which of the following statements is CORRECT? a. If a project with normal cash flows has an IRR greater than the cost of capital, the project must also have a positive NPV. b. If a project with normal cash flows has an IRR less than the cost of capital, the project must have a positive NPV. c. If the NPV is negative, the IRR must also be negative. d. A project's MIRR can never exceed its IRR. e. If Project A's IRR exceeds Project B's, then A must have the higher NPV.
4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project’s IRR. Consider the following situation: Grey Fox Aviation Company is analyzing a project that requires an initial investment of $450,000. The project’s expected cash flows are: Year Cash Flow Year 1 $300,000 Year 2 –175,000 Year 3 475,000 Year 4 450,000 Grey Fox Aviation Company’s WACC is 10%, and the project has the same risk as the firm’s average project. Calculate this project’s modified internal rate of return (MIRR): 26.73% 27.89% 20.92% 23.24% If Grey Fox Aviation Company’s managers select projects based on the MIRR criterion, they shouldreject this independent…
The internal rate of return (IRR) is defined as which of the following: A) IRR may produce multiple rates of return when cash flows are non-conventional.B) IRR is best used for comparing mutually exclusive projects.C) IRR is almost not used in the business world anymoreD) IRR is mainly used to evaluate small projects.
3. Which of the following statements is CORRECT? Assume that the project being considered has normal cash flows, with one outflow followed by a series of inflows. Answer One drawback of the regular payback for evaluating projects is that this method does not properly account for the time value of money. If a project's payback is positive, then the project should be rejected because it must have a negative NPV. The regular payback ignores cash flows beyond the payback pericod, but the discounted payback method overcomes this problem. If a company uses the same payback requirement to evaluate all projects, say it requires a payback of 4 years or less, then the company will tend to reject projects with relatively short lives and accept long-lived projects, and this will cause its risk to increase over time. The longer a project's payback period, the more desirable the project is normally considered to be by this criterion.
Which of the following statements are true? I At higher discount rate, a project is more likely to be rejected. II A project is acceptable if the IRR = 8% while the cost of capital = 5%. III IRR does not account for time value of money. Group of answer choices 1. All of the above. 2. I and II 3. I and III 4. II and III
The relationship between NPV and IRR is such thata. both approaches always provide the same ranking of alternative investment projects.b. the IRR of a project is equal to the firm's cost of capital if the NPV of a project is $0.c. if the NPV of a project is negative, the IRR must be greater than the cost of capital.d. none of the above
If the net present value of a proposed investment is negative, what is the discount rate used? O Less than the project's internal rate of return. Less than the minimum required rate of return. Greater than the project's internal rate of return. Greater than the minimum required rate of return.
12. Which of the following statements is CORRECT? Group of answer choices To find the MIRR, we discount the TV at the IRR. The discounted payback method eliminates all of the problems associated with the payback method. The IRR method appeals to some managers because it gives an estimate of the rate of return on projects rather than a dollar amount, which the NPV method provides. A project's NPV profile must intersect the X-axis at the project's WACC. When evaluating independent projects, the NPV and IRR methods often yield conflicting results regarding a project's acceptability.
2. Consider the model of Moral Hazard where firms choose between investing one unit of output in a less risky or more risky project. The safer project yields with probability and zero otherwise while the risky project yields 2 with probability and zero otherwise i.e. TG = G = TB B = 2. Suppose firms finance their investment by borrowing 1 unit from a the fiinancial market at interest rate R. The financial market is risk neutral and requires an expected rate of return equal to the risk free rate which is assumed to be zero. Will there be an equilibrium with lending to firms from the financial market A. Yes B. No C. Not enough information D. None of A-C
4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project's IRR Consider the following situation: Cold Goose Metal Works Inc. is analyzing a project that requires an initial investment of $600,000. The project's expected cash flows are: Year Year 1 Year 2 Year 3 Year 4 Cold Goose Metal Works Inc.'s WACC is 7%, and the project has the same risk as the firm's average project. Calculate this project's modified internal rate of return (MIRR): 17.50% 14.00% Cash Flow $350,000 -100,000 450,000 400,000 19.25%
18. Consider projects S and L. Both have normal cash flows and the projects have the same risk, hence both are evaluated with the same cost of capital, 10%. However, S has a higher IRR than L. Which of the following statements is CORRECT? A. If project S has a positive NPV, Project L must also have a positive NPV. B. If the cost of capital increases, each project's IRR will decrease. C. If the cost of capital fails, each project's IRR will increase. D. If Projects S and L have the same NPV at the current cost of capital, 10%, then Project L, the one with the lower IRR, would have a higher NPV if the cost of capital used to evaluate the projects decline.
Assume a project has normal cash flows. All else equal, which of the following statements is correct? A project's regular payback increases as the WACC declines. OA project's IRR increases as the WACC declines. A project's NPV declines as the WACC declines. 4 A project's discounted payback increases as the WACC declines. O A project's MIRR is unaffected by changes in the WACC. None of the above statement.

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS