Purchase Solution

Calculating IRR and NPV using excel

Not what you're looking for?

Ask Custom Question

1) What is the internal rate of return (IRR) for a project whose intitial after tax cost is $5,000,000 and it is expected to provide after tax operating cash flows of ($1,800,000) in year 1, $2,900,000 in year 2, $2,700,000 in year 3, and $2,300,000 in year 4 ?

2) A firm is evaluating a proposal that has an initial investment of $50,000 and has cash flows of $15,000 per year for 5 years. If the firms required return or cost is 15%, should it accept the project using the internal rate of return (IRR) as a decision criteria ?

3) What is the net present value (NPV) for a project whose cost of capital is 12% and its initial after tax cost is $5,000,000 and it is expected to provide after tax operating cash flows of $1,800,000 in year 1, $1,900,000 in year 2, $1,700,000 in year 3, and ($1,300,000) in year 4 ?

Purchase this Solution
Solution Summary

The solutions explains about IRR and NPV calculations and shows how to calculate NPV and IRR using excel

Solution Preview

1) The IRR is the rate at which the present value of cash inflows = present value of cash outflows and so the NPV is zero. The IRR denotes the return that the project gives on the initial investment. We calculate IRR manually using trial and error or using the IRR ...

Purchase this Solution
Free BrainMass Quizzes
Economic Issues and Concepts

This quiz provides a review of the basic microeconomic concepts. Students can test their understanding of major economic issues.

Economics, Basic Concepts, Demand-Supply-Equilibrium

The quiz tests the basic concepts of demand, supply, and equilibrium in a free market.

Elementary Microeconomics

This quiz reviews the basic concept of supply and demand analysis.

Pricing Strategies

Discussion about various pricing techniques of profit-seeking firms.

Basics of Economics

Quiz will help you to review some basics of microeconomics and macroeconomics which are often not understood.

View More Free Quizzes
Related BrainMass Solutions

  • Calculating NPV and IRR parameters in the given case

    564341 Calculating NPV and IRR parameters in the given case Using a spreadsheet program like Excel, calculate the NPV and IRR of the following scenario: Cost (Year 0): 10,000. Year 1 Return: 3,000. Year 2 Return: 3,000. Year 3 Return: 5,000.

  • NPV, Payback Period, IRR, Profitibility Index & Project NPV

    The solution provides an example each on how to compute NPV, Payback Period, IRR, Profitibility Index, Project NPV for projects and whether to chose or reject.

  • Internal rate of return

    Project's IRR can be calculated through Excel. Remember the manual way to get IRR is very tedious and is a trial and error process. However, Excel is very good at calculating IRR quickly.

  • Calculating the IRR Value

    NPV = -1,000 + 450 + 450 + 450 = 0 (1+IRR)^1 (1+IRR)^2 (1+IRR)^3 Calculating for IRR is a trial and error procedure.

  • NPV & IRR

    $11,773.35 (Through excel function) IRR= 21.11% (Through excel function) We will accept the project as NPV is positive and IRR is more than cost of capital.

  • NPV and IRR for two mutually exclusive projects

    Year 0 1 2 3 4 NPV IRR (%) Project A -100 50 50 50 50 Project B -400 170 170 170 170 The solution helps in calculating NPV and IRR for two mutually exclusive projects.

  • Capital Budgeting-IRR

    use the excel function IRR Year Cash flow 0 -$100,000 1 $15,000 2 $15,000 3 $15,000 4 $15,000 5 $15,000 6 $15,000 7 $15,000 8 $15,000 9 $15,000 10 $15,000 IRR= 8.14% Using excel function IRR

  • IRR Rate - The budget committee has received the following

    20,000 + 30,000 = 0 (1+IRR)1 (1+IRR)2 (1+IRR)3 (1+IRR)4 (1+IRR)5 IRR = 12.48% Calculating for IRR is a trial and error procedure.

  • New equipment purchase

    The solution explains how to evaluate new equipment purchase by calculating cash flow, payback, NPV, IRR and MIRR

  • Calculating NPV and IRR for a Replacement

    Please see the Excel file for calculations. a. What are the NPV and IRR of the decision to replace the old machine? The NPV comes to -5,103,892 and the IRR is 7.87% b.

View More Related Solutions