Purchase Solution

NPV and IRR

Not what you're looking for?

Ask Custom Question

How do I use EXCEl to calculate the NPV and IRR of the following scenario:

- Cost (Year o): $10,000.
- Year 1 Return: 3,000
- Year 2 Return: 3000
- Year 3 Return: 5,000

Discount Rate:10%

Purchase this Solution
Solution Summary

The solution explains how to calculate the NPV and IRR using excel

Purchase this Solution
Free BrainMass Quizzes
IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

View More Free Quizzes
Related BrainMass Solutions

  • IRR method and NPV method

    494820 IRR method and NPV method Whats the difference between the internal rate of return in (IRR) method and the net present value (NPV) method? What is the IRR method and NPV method?

  • 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%.

  • NPV and IRR Example

    109658 NPV and IRR Example NPV Example ? Pharmaceutical plant costs $50MM today ? Net cash flows: (no benefit until year 2) - Year 2: $9MM - Year 3: $10MM - Year 4: $11MM ? Assume a no-growth perpetuity after Year 4 ?

  • NPV IRR conflict

    (a) When can the NPV and the IRR methods of evaluating investment projects provide contradictory results? Both NPV and IRR are investment appraisal methods and at times these methods can provide contradictory results.

  • ABC Widgets

    This solution is comprised of a detailed explanation to find NPV and IRR for two projects.

  • NPV

    for IRR is a trial and error procedure.

  • 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%:

  • Calculating Net Present Value

    the theory and the above equation, if NPV>0, then, IRR>K Conclusion: It is true.

  • Ranking conflicts between NPV and IRR,

    178254 Ranking conflicts between NPV and IRR, What is the underlying cause of ranking conflicts between NPV and IRR? Why do you get a conflict in rankings with IRR and NPV?

  • NPV and IRR

    ) 0.877625 -27,382 =-31200*0.877625 2 ($49,100) 0.770226 -37,818 =-49100*0.770226 IRR= 13.94% NPV= 0 Answer IRR = 13.94% IRR can also be calculated through interpolation Find NPV at two rates and interpolate

View More Related Solutions