12The following cash flow pattern has two IRRs. Use Excel to draw a graph of the NPV ofthese cash flows as a function of the discount rate. Then use the IRR function to identifythe two IRRS. Would you invest in this project if the opportunity cost were 30%?3 Discount rate10.00%-34.96Data table4NPVSYearCash flow670-3008130092200103150114122125133136-8001415 IRR 116 IRR2171819+??

Analyzing a Project with Two IRRs in ExcelThis project's cash flow pattern has two IRRs due to the…

Answered: 1 2 The following cash flow pattern has…

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 16EB: Project Y cost $8,000 and will generate net cash inflows of $1,500 in year one, $2,000 in year two,...

See similar textbooks

Similar questions

Start with the partial model in the file Ch07 P25 Build a Model.xlsx on the textbook’s Web site. Selected data for the Derby Corporation are shown here. Use the data to answer the following questions. Calculate the estimated horizon value (i.e., the value of operations at the end of the forecast period immediately after the Year-4 free cash flow). Assume growth becomes constant after Year 3. Calculate the present value of the horizon value, the present value of the free cash flows, and the estimated Year-0 value of operations. Calculate the estimated Year-0 price per share of common equity.
Start with the partial model in the file Ch10 P23 Build a Model.xlsx on the textbooks Web site. Gardial Fisheries is considering two mutually exclusive investments. The projects expected net cash flows are as follows: a. If each projects cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what project is the proper choice? b. Construct NPV profiles for Projects A and B. c. What is each projects IRR? d. What is the crossover rate, and what is its significance? e. What is each projects MIRR at a cost of capital of 12%? At r = 18%? (Hint: Consider Period 7 as the end of Project Bs life.) f. What is the regular payback period for these two projects? g. At a cost of capital of 12%, what is the discounted payback period for these two projects? h. What is the profitability index for each project if the cost of capital is 12%?
Project Y cost $8,000 and will generate net cash inflows of $1,500 in year one, $2,000 in year two, $2,500 in year three, $3,000 in year four and $2,000 in year five. What is the NPV using 8% as the discount rate?
Buena Vision Clinic is considering an investment that requires an outlay of 600,000 and promises a net cash inflow one year from now of 810,000. Assume the cost of capital is 10 percent. Required: 1. Break the 810,000 future cash inflow into three components: a. The return of the original investment b. The cost of capital c. The profit earned on the investment 2. Now, compute the present value of the profit earned on the investment. 3. Compute the NPV of the investment. Compare this with the present value of the profit computed in Requirement 2. What does this tell you about the meaning of NPV?
This problem is useful for testing the ability of financial calculators or excel. Consider the following cash flows. How many different IRRs are there (Hint: search between 20 percent and 70 percent)? When should we take this project?( u can use Excel) Year Cash Flow 0 -$3,024 1 17,172 2 -36,420 3 34,200 4 -12,000
Project Y has following cash flows: C0 = -800, C1 = +6,000, and C2 = -6,000. Calculate the IRRs for the project: For what range of discount rates does the project have positive NPV (Plot a graph with NPV on the vertical axis and discount rate on the horizontal axis).
Calculate/estimate the IRR(s) for a 6-year project with the following cash flows: CF0 = -50, CF1 =28 = CF2 = CF3 = CF4 = CF5, and CF6 = -93. In Excel, plot the NPV (= Y axis) against r (= discountrate), using r = 0%, 2%, and so on until you find all IRRs in the chart. Identify/estimate all IRRs.
You identify an investment project with the following cash flows. If the discount rate is 10%, what is the present value of these cash flows? Y1- $500 Y2- $550 Y3- $800 Y4- $450. Please type answer no write by hend.
Net Cash Flows and NPVs for different discount rate for projects S and L are given below Net Cash Flows ($) Discount Rate (%) NPVS NPVL Year (t) Project S Project L 0% $800 $1100 0 $(3000) $(3000) 5 554.32 1 1500 400 10 161.33 2 1200 900 15 (90.74) (259.24) 3 800 1300 20 (309.03) (565.97) 4 300 1500 ii) NPVS at 10%: d) What is the IRR for S? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR Equation: Answer:
A project has the following cash flows set out below. What is the profitability index of this project if the relevant discount rate is 2 percent? Enter your final answer to two decimal places. Year Cash flow 0 -1,745 1 537 2 2,066 3 3,912
Net Cash Flows and NPVs for different discount rate for projects S and L are given below Net Cash Flows ($) Discount Rate (%) NPVS NPVL Year (t) Project S Project L 0% $800 $1100 0 $(3000) $(3000) 5 554.32 1 1500 400 10 161.33 2 1200 900 15 (90.74) (259.24) 3 800 1300 20 (309.03) (565.97) 4 300 1500 e) What is the IRR for L? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR Equation: Answer: f) What is the cross-over rate? (Write down the equation for IRR and then Use an excel worksheet to calculate IRR Equation: ANSMER:
Vital Silence, Inc., has a project with the following cash flows: Year Cash Flow 0 –$ 27,800 1 11,800 2 14,800 3 10,800 The appropriate discount rate is 18 percent. What is the IRR for this project? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)

Recommended textbooks for you

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Intermediate Financial Management (MindTap Course…

Finance

ISBN:

9781337395083

Author:

Eugene F. Brigham, Phillip R. Daves

Publisher:

Cengage Learning

International Financial Management

Finance

ISBN:

9780357130698

Author:

Madura

Publisher:

Cengage

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Intermediate Financial Management (MindTap Course…

Finance

ISBN:

9781337395083

Author:

Eugene F. Brigham, Phillip R. Daves

Publisher:

Cengage Learning

International Financial Management

Finance

ISBN:

9780357130698

Author:

Madura

Publisher:

Cengage

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Entrepreneurial Finance

Finance

ISBN:

9781337635653

Author:

Leach

Publisher:

Cengage

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

SEE MORE TEXTBOOKS