Purchase Solution

Financial Management: IRR, Crossover Rates, NPV

Not what you're looking for?

Ask Custom Question

Consider the following two mutually exclusive projects:

Year Cash Flow (X) Cash Flow (Y)
0 -$ 19,300 -$ 19,300
1 8,675 9,750
2 8,750 7,625
3 8,625 8,525

Calculate the IRR for each project. (Round your answers to 2 decimal places. (e.g., 32.16)).

IRR
Project X %
Project Y %

What is the crossover rate for these two projects? (Round your answer to 2 decimal places. (e.g., 32.16)).

Crossover rate %

What is the NPV of Projects X and Y at discount rates of 0%, 15%, and 25%? (Negative amount should be indicated by a minus sign. Round your answers to 2 decimal places. (e.g., 32.16))

Discount rate Project X Project Y
0% $ $
15% $ $
25% $ $

Purchase this Solution
Solution Summary

The solution gives detailed steps on solving 3 financial questions such as ,finding IRR, Crossover Rates, NPV. All formula and calculations are shown and explained.

Solution Preview

Hello, I will appreciate if you can award more credits only for this posting as it is time consuming.

IRR of A, 19300= (8675/(1+r))+(8750/(1+r)^2)+(8625/(1+r)^3), so r= 16.65%

IRR of B, 19300= ...

Purchase this Solution
Free BrainMass Quizzes
Basics of corporate finance

These questions will test you on your knowledge of finance.

Introduction to Finance

This quiz test introductory finance topics.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

View More Free Quizzes
Related BrainMass Solutions

  • Identifying the crossover rate in the given case

    By knowing the crossover rate, when analyzing mutually exclusive projects, we can identify the discount rates that will result in conflict in rankings between NPV and IRR.

  • Crossover rate: cost of capital two projects have the same NPV

    4 5,000 IRR= 13.03% =IRR(C25:C29) IRR can also be calculated through interpolation Find NPV at two rates and interpolate Year Cash flow Discount factor @ Discounted

  • Gardial Fisheries: Net Cash Flows, NPV, IRR & Crossover Rate

    322844 Gardial Fisheries: Net Cash Flows, NPV, IRR & Crossover Rate Please see the attached file that contains the problem. Please see attached file. This solution assists with calculating net cash flows, NPV, IRR and crossover rates.

  • Mutually Exclusive Projects

    This is calculated at discounting rates of 0% to 30% and then plotted as a graph. We find the NPV at different discounting rates (this is done using the TABLE function in excel) and then plot these NPV. c. what is each projects IRR?

  • NPV: Which of the statements are correct?

    Both projects have IRR> WACC and hence both have a positive NPV Statement E: is incorrect. When the WACC (10%) is greater then the crossover rate (8%) the project with the higher IRR has the higher NPV.

  • NPV, IRR

    Below the crossover point (8%) , the project with the higher IRR has a lower NPV. Thus at discount rate of 8% and below, Project A has a higher NPV but above 8%, Project B has a higher NPV.

  • Understanding Capital Budgeting Practice Problems

    Your tutorial is attached in excel and includes using NPV and MIRR formulas in Excel to get needed amounts, two graphs with crossover points circled, discussion about the graphs and an analysis of finding NPV from profitability index.

  • Capital budgeting

    By using the difference in the cash flows and finding the IRR, the crossover point comes at 8.68% The solution explains how to calculate NPV, IRR, PI and MIRR

  • Capital Budgeting - Payback, NPV, PI, IRR

     For unconventional cash flows (large outflow during or at the end of its life) IRR calculations can give two or more rates. (Thus IRR is ambiguous- which of the two rates should be used?)

View More Related Solutions