Purchase Solution

IRR calculations and NPV

Not what you're looking for?

Ask Custom Question

Make a spreadsheet document that contains the IRR calculations.

Clearly label each diagram to identify the investment name and type of asset
Show the original equation you are using
Clearly identify a value for each variable in the equation

Then, in a Microsoft Word document, prepare a summary report (300 words or less) that includes the following:

The NPVs of the four potential investments, ranked from most profitable to least profitable. I have the NPV's done ...please see excel spreadsheet.

The IRRs of the four potential investments, ranked from most profitable to least profitable
Your recommendation for the single most profitable investment and a justification of that choice

Attachments
Purchase this Solution
Solution Summary

IRR calculations and NPV are examined.

Solution Preview

BLUE MESA SUMMARY REPORT

The four projects Sagebrush, Longhorn, Big Crick and Dusty Basin are ranked based on NPV as below:
Rank 1: Big Crick-NPV=$125 million
Rank2: Longhorn-NPV=$51.88 million
Rank3: Sagebrush - NPV=$26.63 million
Rank 4: Dusty Basin - NPV=$20.34 million
The higher the value of the NPV the better the project is.

The ranking of the four projects based on IRR is as below:
Rank 1: Longhorn - IRR=22.15%
Rank2: Big Crick ...

Purchase this Solution
Free BrainMass Quizzes
Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Basic Social Media Concepts

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

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Operations Management

This quiz tests a student's knowledge about Operations Management

View More Free Quizzes
Related BrainMass Solutions

  • NPV, IRR and Profitability Index

    217545 Calculate the NPV, IRR and Profitability Index for the cash flows listed below using a discount rate of 10%: (show your calculations) Calculate the NPV, IRR and Profitability Index for the cash flows listed below using a discount rate of 10%:

  • NPV, IRR, and MIRR

    The solution includes a word file and an excel file that show a step by step calculations of NPV, IRR, and MIRR

  • IRR Calculations Using NPV and EAA

    This solution shows step-by-step calculations to determine the Internal Rate of Return (IRR) using the Net Present Value (NPV) and EAA.

  • NPV & Payback & IRR

    The solution determines NPV and Payback and IRR.

  • NPV and IRR of the Project

    Compute the NPV and IRR of the project. For your NPV calculations, assume a cost of capital of 15 percent.

  • Capital Budgeting

    82514 5 questions: IRR,NPV, discount payback - by 11:30 PM 5 questions: IRR,NPV, discount payback - file attached Please see the attached file The solution has five problems relating to payback, IRR and NPV calculations.

  • Reinvestment under IRR

    157636 Reinvestment under IRR When two mutually exclusive projects are considered, the NPV calculations and the IRR calculations may, under certain circumstances, give conflicting recommendations as to which project to accept.

  • Finance: Net present value,payback and IRR

    The solution is clear and concise with explanatory calculations. Thank you. The solution deals with issues in finance: Internal rate of return, Net present value and payback period calculations.

  • NPV, IRR, Profitability Index, and MIRR

    407811 NPV IRR Calculations Please view attachment for question. a. Calculate the NPV, IRR, Profitability Index, and MIRR for this project with a cost of capital of 12%.

View More Related Solutions