The Potential for Multiple IRRs A proposed investment has the following projected after-taxcash flows over its 3-year life:Initial outlay (time 0) = ($1,000)End of year 1 = $2,000End of year 2 = $2,000End of year 3 = ($3,700) Required 1. In a capital budgeting context, explain the difference between a normal and a non-normal cash flowpattern. What is the importance of this distinction for estimating the internal rate of return (IRR) of aproposed investment? 2. For the proposed investment project just described, how many IRRs will there be? Why?3. Use Excel to prepare a graph of the net present value (NPV) profile of the proposed investment describedherein. On the X-axis, show discount rates from 0% to 120%, in increments of 5%. On the Y-axis, showthe estimated NPV of the project for each of the specified discount rates. (Use the built-in NPV functionin Excel to estimate the NPVs.) Based on a visual examination of the graph, what are the two estimatedIRRs for the proposed investment? 4. Use the built-in IRR function in Excel to estimate each of the two IRRs for the proposed investment. Youwill have to do this twice, once for each solution. In using the IRR function, choose a “guess” (initial estimate) percentage close to the X-intercepts depicted in the graph prepared in requirement 3. (If you omitthe initial estimate, the default value used by Excel is 10%.) Round your answers to 2 decimal places. 5. What are the primary implications of the preceding analyses, in terms of the capital budgeting process?

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter19: Capital Investment
Section: Chapter Questions
Problem 13E: Buena Vision Clinic is considering an investment that requires an outlay of 600,000 and promises a...
icon
Related questions
Question

The Potential for Multiple IRRs A proposed investment has the following projected after-tax
cash flows over its 3-year life:
Initial outlay (time 0) = ($1,000)
End of year 1 = $2,000
End of year 2 = $2,000
End of year 3 = ($3,700)
Required
1. In a capital budgeting context, explain the difference between a normal and a non-normal cash flow
pattern. What is the importance of this distinction for estimating the internal rate of return (IRR) of a
proposed investment?
2. For the proposed investment project just described, how many IRRs will there be? Why?
3. Use Excel to prepare a graph of the net present value (NPV) profile of the proposed investment described
herein. On the X-axis, show discount rates from 0% to 120%, in increments of 5%. On the Y-axis, show
the estimated NPV of the project for each of the specified discount rates. (Use the built-in NPV function
in Excel to estimate the NPVs.) Based on a visual examination of the graph, what are the two estimated
IRRs for the proposed investment?
4. Use the built-in IRR function in Excel to estimate each of the two IRRs for the proposed investment. You
will have to do this twice, once for each solution. In using the IRR function, choose a “guess” (initial estimate) percentage close to the X-intercepts depicted in the graph prepared in requirement 3. (If you omit
the initial estimate, the default value used by Excel is 10%.) Round your answers to 2 decimal places.
5. What are the primary implications of the preceding analyses, in terms of the capital budgeting process?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 5 images

Blurred answer
Knowledge Booster
Financial Policy and Growth
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT