# Consider the following two mutually exclusive projects: Year Cash Flow (X) Cash Flow (Y) 0...

## Question:

Consider the following two mutually exclusive projects:

Year | Cash Flow (X) | Cash Flow (Y) |
---|---|---|

0 | -$20,200 | -$20,200 |

1 | $8,900 | $10,200 |

2 | $9,200 | $7,850 |

3 | $8,850 | $8,750 |

A. Calculate the IRR for each project.

B. What is the crossover rate for these two projects?

C. What is the NPV of Projects X and Y at discount rates of 0%, 15%, and 25%?

## Incremental Analysis:

In the capital budgeting process, both the internal rate of return (IRR) and the net present value (NPV) methods can be utilized to make an investment decision. The IRR enables us to figure out the discount rate at which the present value of future cash flows is equal to the initial cost. NPV on the other hand enables us to determine the current worth of a project after netting off the present value of future cash flows against the initial cost. Sometimes projects can have the same NPV amount and the discount rate at which this happens is referred to as the cross-over rate.

## Answer and Explanation: 1

Become a Study.com member to unlock this answer! Create your account

View this answer### Question A

One approach to calculating the IRR is to use excel.

Below are the steps applied:

Input the cash flows and corresponding years into...

See full answer below.

#### Ask a question

Our experts can answer your tough homework and study questions.

Ask a question Ask a question#### Search Answers

#### Learn more about this topic:

from

Chapter 9 / Lesson 7Learn about incremental analysis. Understand what incremental analysis is, learn the applications of incremental analysis, and see examples of incremental analysis.

#### Related to this Question

- Consider the following uneven cash flow stream: Year Cash Flow 0 $0 1 $575 2 $650 3 $750 4 $825 5 $850 a. What is the net present (Year 0) value if the opportunity cost (discount) rate is 8.5 percent? b. Add an outflow (or cost) of $1,450 at the outset. W
- Consider a project with the following cash flows: Time 0 1 2 Cash Flow -$110 $70 $120 What is its profitability index if the cost of capital is 0.08?
- Consider a project with cash flows: Year 0 1 2 3 4 5 P -$19 $10 $5 $3 $5 $10 Compute the profitability index based on a 10% cost of capital and compute the payback time.
- Suppose you are considering two projects, A and B, that each has a required rate of return of 10%. Both projects cost $5,000 and have a net present value of $150. Project A has an IRR of 16% and project B has an IRR of 15%. What is the crossover rate for
- Consider the following uneven cash flow stream: Year Cash flows 0 $0 1 $250 2 $400 3 $500 4 $600 5 $600 (a) What is the present (year 0) value if the opportunity cost (discount) rate is 10%? (b) Add an outflow (cost) of $1000 per year starti
- Consider the following three mutually exclusive cash flows. Using a MARR of 14% and a rate of return method, determine which option should be selected. Year Project A Project B Project C 0 -3000 -4000 -5000 1 1000 1600 1800 2 1000 1600 1800 3 1000 1500 2
- Two projects, Project A and Project B, are available, each costing $500,000. The discount rate is 10%. Considering the cash flows given below, which project would be more profitable using the undiscounted payback period method? | Year | Project A | Proje
- Project Y has an initial cost of $10,000, and the discount rate for each project is 12%. Expected cash flow is given below for the project: Year Project Y 1 6,500 3 5,000 4 3,000 Calculate NPV for this project.
- Calculate the project cash flow generated for Project A and Project B using the NPV method. . Which project would you select, and why? . Which project would you select under the payback method? The di
- Project A costs $10,000 and has annual cash flows of $2,900 for six years. The discount rate is 5%. Calculate the profitability index of the project. Should the firm accept the project?
- Projects A and B are mutually exclusive. Project A costs $10,000 and is expected to generate cash inflows of $4,000 for four years. Project B costs $10,000 and is expected to generate a single cash flow in year 4 of $20,000. The cost of capital is 12 perc
- A five-year project has a projected net cash flow of $15,000, $25,000, $30,000, $35,000, and $20,000 in the next five years. It will cost $80,000 to implement the project. If the required rate of return is 20%, determine the NPV and indicate if you would
- Consider the following uneven cash flow stream: |Year| $ Cash Flow |0| 0 |1| $250 |2| $400 |3| $500 |4| $600 |5| $600 a) What is the present (Year 0) value if the opportunity cost (discount) rate is 10%? b) Add an outflow (or cost) of $1,000 at Year 0. Wh
- Consider the project described in the table below. What Is the project's internal rate of return? The cost of capital rate is 13%. Time 0 1 2 3 4 Cash flows ($6,600) $2,400 $3,600 $2,000 $1,000 A. 15.81% B. 16.13% C. 16.29% D. 15.65%
- In comparing two projects, what is often used to evaluate the relative riskiness of the projects? a. net present value b. payback period c. discount rate d. internal rate of return
- You are considering the following two projects and can take only one. You cost of capital is 10.6%. The cash flows for the two projects are as follows ($ million): Project Year 0 Year 1 Year 2 Year 3
- Two projects, Project A and Project B, are available, each costing $500,000. The discount rate is 10%. Considering the cash flows given below, which project would be more profitable using the profitability index? | Year | Project A | Project B | 1 | 150,
- Coffer Co. is analyzing two projects for the future. Assume that only one project can be selected. Project X Project Y Cost of machine $77,000 $55,000 Net cash flow: Year 1 28,000 2,000 Year 2 28,000 25,000 Year 3 28,000 25,000 Year 4 0 20,000 If the comp
- A cash flow that arises solely from a project that is being evaluated and hence should be included in the project analysis is known as: a- Accounting Income b- Incremental Cash Flows c- Project Life d- Opportunity Cost e-Sunk Cost
- Symbiotic Accounting Products is considering launching a project with an initial cost of $7,800. What is the payback period for this project if the cash inflows are $1,100, $1,640, $3,800, and $4,500 a year over the next four years respectively? a. 3.21
- Determine the IRR on the following projects: a) An initial outlay of $10,000 resulting in a free cash flow of $1,993 at the end of each year for the next 10 years. b) An initial outlay of $10,000 r
- Compute the NPV statistic for Project Y if the appropriate cost of capital is 10 percent. Project Y Time: 0 1 2 3 4 Cash flow $8,500 $3,730 $4,560 $1,900 $680
- What method can be used to determine a project's valuation, other than discounted cash flow?
- Project L costs $44, 964.46, its expected cash flows are $10,000 per year for 9 years, and its WACC is 10%. What is the project's IRR?
- Compute the annual rate of return for each project. Rank the projects based on the computed value. Which project do you recommend?
- 1. Consider the following project's cash flows: Assume that the project's IRR is 10%. a) Find the value of X. b) Is this project acceptable at MARR = 8%? 2. You are considering a luxury apartment b
- Compute the NPV statistic for Project Y if the appropriate cost of capital is 13%. Should the project be accepted or rejected? Time: 0 1 2 3 4 Cash flow -$8,800 $3,510 $4,340 $1,680 $460
- Compute the IRR static for Project I. The appropriate cost of capital is 8 percent. Project l |Year |0 |1 | 2 | 3 | 4 |Cash flow |2,100 |920 |810 |850 | 520 Should the project be accepted or rejected?
- 1. Compute the NPV statistic for Project Y if the appropriate cost of capital is 13%. Time 0 1 2 3 4 Cash flow -$9,100 $3,570 $4,400 $1,740 $520 2. Should the project be accepted or rejected?
- Consider a project that costs $10,000 today. It will provide benefits of $4,000 at the end of Year 1, $3,500 at the end of Year 2, and $3,500 at the end of Year 3. If the discount rate is 6%, will this project be approved using cost-benefit analysis? Woul
- Waste Industries is evaluating a $55,500 project with the following cash flows. Years Cash Flows 1 $9,120 2 20,200 3 26,600 4 16,300 5 26,300 The coefficient of variation for the project is .475. Coefficient of Variation Discount Rate
- You estimate that a project will cost $27,700 and will provide cash inflows of $11,800 in year 1 and $24,600 in year 3. Based on the profitability index rule, should the project be accepted if the discount rate is 14 percent? Why or why not?
- The IRR of normal Project X is greater than the IRR of normal Project Y, and both IRRs are greater than zero. Also, the NPV of X is greater than the NPV of Y at the cost of capital. If the two projects are mutually exclusive, Project X should definitely b
- Project B Time (Years) 0 1 2 3 4 5 Cash Flow ($12,700) $3,520 $4,520 $1,860 $0 $1,340. Required: 1. Compute the payback statistic for Project B if the appropriate cost of capital is 11 percent and the
- Trinitron Inc. is considering two projects. Project A has uneven cash flows while Project B has even cash flows. What would happen to the payback period of each project if it was determined that costs
- Seether, Inc., has the following two mutually exclusive projects available. Requirement 1: What is the crossover rate for these two projects? (Do not round intermediate calculations. Enter your answe
- Compute the benefit-cost ratio and B-C criterion of the following project: Project cost P80,000 Gross income P25,000 per year Opening cost P6,000 per year Salvage value 0 Life of project 10 years Rate of interest 12%
- Jella Cosmetics is considering a project that costs $750,000 and is expected to last for 9 years and produce future cash flows of $180,000 per year. If the appropriate discount rate for this project is 17 percent, what is the project's IRR?
- The following chart plots the NPV of projects A and B at different discount rates. The projects have similar risks and mutually exclusive. a) What is the significance of the point on the graph where the two lines intersect? b) What is the significance of
- Tnatech is contemplating two different projects and decides to perform a financial analysis to determine which is more financially lucrative. Project A and B have cash flows as shown. Inatech uses a required rate of return of 10% and an inflation rate of
- Compute the MIRR static for Project I if the appropriate cost of capital is 12 percent. Project I: Time: 0 1 2 3 4 Cash flow -$11,000 $5,330 $4,180 $1,520 $2,000
- Which items are necessary in calculating the net present value of a project? I. Investment outlays II. Discount rate III. Incremental cash flow IV. Time period for the project a) I, II, and IV b) I, II, and III c) II, III, and IV d) All of the above
- A proposed project has fixed costs of $96,000 per year. The operating cash flow at 6,600 units is $96,200. Ignoring the effect of taxes, what is the degree of operating leverage?
- The financial manager is evaluating two new projects. The firm has a cost of capital of 8%. The two projects are expected to have the following cash flows: Year Project A (R) Project B (R) 1 -50,000 -80,000 2 20,000 40,000 3 30,000 30,000 4 10,000 30,000
- Compute the net present value for each project. Rank the projects based on the computed value. Which project do you recommend?
- A proposed project will cost $600,000 and will provide operating cash flows of $150,000 in Year 1, $300,000 in Year 2, $500,000 in Year 3. The company's hurdle rate is 15%. How much is the net present value of the project? A. $23,013 B. $66,373 C. $86,
- A project with an initial cost of $28,300 is expected to generate cash flows of $6,900, $9,000, $9,250, $8,150, and $7,700 over each of the next five years, respectively. What is the project's payback period?
- Consider a project that costs $10,000 today. It will provide benefits of $4,000 at the end of Year 1, $3,500 at the end of Year 2, and $3,500 at the end of Year 3. a) If the discount rate is 6%, will this project be approved using cost-benefit analysis? b
- Project X has a cost of $53,847 and its expected net cash flows are $12,000 p.a. for the next eight years. What is the project's internal rate of return?
- All of the following are advantages of using the Discounted Cash Flow Method of evaluating capital expenditures except: A. Simple to compute and explain. B. Results are easily understood. C. Considers project's cash flow over its life. D. Considers time v
- 1. Compute the PI static for your firm's new project if the appropriate cost of capital is 9 percent. Time 0 1 2 3 4 5 6 Cash Flow -680 80 560 760 760 360 760 2. Should the project be accepted or rejected?
- Suppose you have the following cash flows associated with a proposed project: Initial cost $500,000 Perpetual annual costs O&M costs $50,000 p.a. starting at the end of year 3 Expected perpetual annual revenues from project $150,000 p.a. starting at the e
- Suppose you have a project with projected discounted cash flows of $5,500,000, and the project cost was $4,000,000. Would you go through with the investment option? Why or why not?
- Compute the IRR for Project F. The appropriate cost of capital is 12 percent. (Do not round intermediate calculations and round your final answer to 2 decimal places.) Should the project be accepted or rejected?
- You have just completed the analysis of a capital budgeting proposal and have concluded that the NPV = -5000. (You used a 12% discount rate) Before you decide that the project is not worthwhile, you note that you assumed that all the $400000 in financing
- A.between 0 and 0.36 B.between 0.36 and 0.60 C. between 0.86 and 1.35 D, between 0.86 and 2.00 Calculate the B/C ratio for the following cash flow estimates at a discount rate of 6% per year. Ite
- When making screening decisions using the net present value method, a project is acceptable if: a. the NPV is greater than the hurdle rate. b. the NPV is greater than the IRR. c. the NPV is positive. d. the NPV is negative.
- Which of the following is not true regarding the appropriate discount rate to be used in conjunction with discounted cash flow (DCF) decision models? a. For projects of "above average" risk, the appropriate discount rate is the weighted-average cost of ca
- A project has a life of 10 years and no salvage value. Your firm uses a MARR of 8% to evaluate projects. The project has uncertain costs and revenue as shown in the table below: Initial Cost Probabil
- Discuss how various budgets interact with each other. Examples could be the cash budget and the sales and purchases budget or the capital budget and the cash budget and the budgeted balance sheet.
- A proposed project has fixed costs of $73,000 per year. The operating cash flow at 8,000 units is $87,500. Ignoring the effect of taxes, what is the degree of operating leverage? If units sold rise from 8,000 to 8,500 what will be the increase in operatin
- Select the incorrect statement concerning the internal rate of return (IRR) method of evaluating capital projects. (a) The higher the IRR, the better (b) A project whose IRR is less than the cost of capital should be rejected (c) If a project has a positi
- What is an opportunity cost rate? How is this rate used in discounted cash flow analysis, and where is it shown on a time line? Is the opportunity rate a single number that is used to evaluate all pot
- Help You have been asked to evaluate these three mutually exclusive alternatives each with a different project life. Your company's MARR is 15%. Project A ; B ; C ; Initial Cost $100,000 ; $140,000
- What are the differences between a flexible budget and a static budget? What's an example to discuss how to compute and use Net Present Value (NPV), Internal Rate of Return (IRR), and payback period to evaluate a project in capital budgeting?
- Consider three mutually exclusive alternatives. The MARR is 10%. Year X Y Z 0 -$100 -$50 -$50 1 25 16 21 2 25 16 21 3 25 16 21 4 25 16 21 (a) For Alt. X, compute the benefit-cost ratio. (b) Based on the payback period, which alternative should be select
- Net Present Value (NPV) analysis of a project reveals + $3,600 based on a discount rate of 12%. A) What does this tell us about the financial viability of the project? B) What does it not tell us? C) Why is the NPV method considered to be theoretically su
- Select the incorrect statement concerning the internal rate of return (IRR) method of evaluating capital projects. A. A project whose IRR is less than the cost of capital should be rejected. B. The higher the IRR the better. C. The internal rate of ret
- Identify two simplifying assumptions associated with discounted cash flow methods of making capital budgeting decisions.
- Based on the scenario below, compute the under- or overapplied overhead for the St. Falls plant for the year using the allocation rates, one rate for plantwide overhead and two separate department overhead rates, all based on machine-hours. (Round your in
- What 2 things can you do when you select an individual project from the Projects Dashboard? A. You can add transactions to the project. B. You can see time activity by products and services. C. You can see the cost of unpaid time in the profit margin b
- YearCash Flow 0?$18,200 110,500 29,400 35,900 What is the profitability index for the set of cash flows if the relevant discount rate is 9 percent? (Do not round intermediate calculations and round yo
- You are planning to create DCF analysis using Unlevered Free Cash Flow and the Multiples Method for Terminal Value. You also have a 5-year 3-statement projection model for the company you're analyzing. Aside from the appropriate discount rate, you have al
- Evaluate the advantages and disadvantages of the various decision-making tools listed (e.g., regular payback, discounted payback, net present value (NPV), internal rate of return (IRR), and modified internal rate of return). Describe a project scenario in
- Determine the term being described by the following statement: Project valuation method that does not consider the time value of money. Choose from the following terms: | Accounting rate of return | Time | Real option theory | Maintenance phase | NPV
- Answer the question (step by step) clearly. Reference: Contemporary Engineering Economics (6th Edition) Consider the independent investment projects in the following table: Compute the project worth
- Consider three mutually exclusive alternatives: A B C Initial Cost 770 1406 2563 Uniform annual benefit 420 420 420 Useful life 2 4 8 Rate of return 6.0% 7.5% 6.4% The analysis period is 8 years. At
- On day 51 a project has an earned value of $600, an actual cost of $650, and a planned cost of $560. Compute the SV, CV, and CPI for the project. What is your assessment of the project on day 51?
- Spin cycle Architecture uses three activity pools to apply overhead to its projects. Each activity has a cost driver used to allocate the overhead cost to the projects. The activities and related overhead costs are as follows: Initial concept formation $4
- Which of the following pairs of terms do not match? A. Participation budget, bottom-up approach B. Life-cycle budgeting, input/output approach C. Continuous budgeting, perpetual budgeting D. Budge
- Net present value is calculated by: A. (Present value of project's future cash inflows) - (Present value of the project's cost) B. (Present value of the project's cost) - (Present value of project's future cash inflows) C. (Present value of the project) -
- The following are the cash flows of two projects: |Year |Project A |Project B |0 |$350 |$350 |1 |180 |250 |2 |180 |250 |3 |180 |250 |4 |180 a. If the opportunity cost of capital is 11%, calcula
- Billabong Tech uses the internal rate of return (IRR) to select projects. Calculate the IRR for each of the following projects and recommend the best project based on this measure. Project T-Shirt req
- Two projects have an identical net present value of $9,000. Are both projects equal in desirability?
- Determine the term being defined by the following statement: The combination of both overhead spending variances (variable and fixed) and the variable overhead efficiency variance. Choose from the following words: | Fixed budget | Standard costs | Price
- Cost is often an important aspect of a project. 1. Calculate the net present value of a software update project which requires an initial investment of $250,000 and is expected to generate cash inflow of $75,000 each month for years 1-6. Assume that th
- Mr. Franklin asks us to comment on Statement 1 and Statement 2. Statement 1: The profitability Index approach may lead to incorrect decisions in comparisons of mutually exclusive projects. Statement 2: because the actual Net Present Value is unknown, fi
- Spin Cycle Architecture uses three activity pools to apply overhead to its projects. Each activity has a cost driver used to allocate the overhead costs to the projects. The activities and related ove
- A given project's expected duration along its critical path is 22.5 days. Management eventually wants to know the probability that the project will finish on or before 28 days. The project's standard deviation along its critical path is 2.03. The approxim
- Compare and contrast incremental budgeting, zero-based budgeting, and activity-based budgeting.
- What are the project's operating cash flows in Years 1, 2, and 3? You have been asked to evaluate the proposed acquisition of a new clinical laboratory test system. The system's price is $50,000, and it will cost another $10,000 for transportation and ins
- Using the following data, calculate the planned and actual monthly budgets through the end of June. Assume the project is planned for a 12-month duration and $250,000 budget. All costs are in $000. U
- Use the NPV method to determine whether Root Products should invest in the following projects: -Project A costs $290,000 and offers seven annual net cash inflows of $65,000. Root Products requires an
- Plans that identify costs and expenses under each manager's control prior to the reporting period, typically based on the flexible budget approach, are called: a. Cost accounting systems. b. Manageria
- Three mutually exclusive design alternatives are being considered. The estimated sales and cost data for each alternative are given below. The MARR is 20% per year. Annual revenues are based on the nu
- Determine the expected profit if bright day projects the following data for Delatine sales, 5000 bottles; fixed cost, $30,000; bottles variable cost per unit, $12. Bright day is considering new circu
- How are the following items used in the calculation of the net present value of a proposed project? (Ignore income tax considerations) Depreciation Expense Salvage Value A) Include Include B) Include Exclude C) Exclude Include D) Exclude Exclude a. Option
- Three revenue projects are under consideration for improving material flow in a production process. Assume a life of 10 years and a MARR of 16% per year to determine which alternative is best using a
- Discuss the problems associated with the use of a risk-adjusted discount rate in cash flow analysis.
- If the net present value of a project equals zero a. the project should be considered. b. the project should not be considered. c. then someone made an error in the calculation d. then a balanced scorecard should be adopted to compensate