Preview

Npv Calculation

Satisfactory Essays
Open Document
Open Document
356 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Npv Calculation
-3000000 1100000 1450000 1300000 950000 Using this online NPV Calculation Tool http://finance.thinkanddone.com/online-n… we get the following NPV at 15% Net Cash Flows CF0 = -3000000 CF1 = 1100000 CF2 = 1450000 CF3 = 1300000 CF4 = 950000 Discounted Net Cash Flows DCF1 = 1100000/(1+0.15)^1 = 1100000/1.15 = 956521.74 DCF2 = 1450000/(1+0.15)^2 = 1450000/1.3225 = 1096408.32 DCF3 = 1300000/(1+0.15)^3 = 1300000/1.52087 = 854771.1 DCF4 = 950000/(1+0.15)^4 = 950000/1.74901 = 543165.58 NPV Calculation NPV = 956521.74 + 1096408.32 + 854771.1 + 543165.58 -3000000 NPV = 3450866.74 -3000000 NPV = $450,866.74 Using this online IRR Calculation Tool http://finance.thinkanddone.com/online-i… we get the following IRR Discounted Net Cash Flows at 19% DCF1 = 1100000/(1+19%)^1 = 1100000/1.19 = 924369.75 DCF2 = 1450000/(1+19%)^2 = 1450000/1.4161 = 1023938.99 DCF3 = 1300000/(1+19%)^3 = 1300000/1.68516 = 771440.56 DCF4 = 950000/(1+19%)^4 = 950000/2.00534 = 473735.31 NPV Calculation at 19% NPV = 924369.75 + 1023938.99 + 771440.56 + 473735.31 -3000000 NPV = 3193484.61 -3000000 NPV at 19% = 193484.61 Discounted Net Cash Flows at 24% DCF1 = 1100000/(1+24%)^1 = 1100000/1.24 = 887096.77 DCF2 = 1450000/(1+24%)^2 = 1450000/1.5376 = 943028.1 DCF3 = 1300000/(1+24%)^3 = 1300000/1.90662 = 681833.44 DCF4 = 950000/(1+24%)^4 = 950000/2.36421 = 401824.92 NPV Calculation at 24% NPV = 887096.77 + 943028.1 + 681833.44 + 401824.92 -3000000 NPV = 2913783.23 -3000000 NPV at 24% = -86216.77 IRR with Linear Interpolation iL = 19% iU = 24% npvL = 193484.61 npvU = -86216.77 irr = iL + [(iU-iL)(npvL)] / [npvL-npvU] irr = 0.19 + [(0.24-0.19)(193484.61)] / [193484.61--86216.77] irr = 0.19 + [(0.05)(193484.61)] / [279701.38] irr = 0.19 + 9674.2305 / 279701.38 irr = 0.19 + 0.0346 irr = 0.2246 irr = 22.46% The company should accept this project since its IRR is higher than the required rate of return
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Mat 540 Quiz 4
    • 644 Words
    • 3 Pages

    Mat 540 Quiz 4

    and the IRR is lower than the rate of return. On the other hand, project B has a positive NPV and…

    • 644 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    Super Project

    • 462 Words
    • 2 Pages

    Super Project

    For Super Project, I calculated a positive NPV of $70M, an IRR of 12% (with WACC=10%) and a payback recovery of 6.7 years against a 10 year required payback. Those three factors tell me to accept the project. A positive NPV will result in profitability over the 10 year period, a positive EVA, & positive MVA. A positive IRR indicates we will be earning more than we are paying for the project and it will increase shareholder’s wealth. However, sensitivity analysis showed me that our NPV and IRR have steep slopes (extremely sensitive) which could change my decision. If WACC increased, the NPV could become negative meaning outflows exceed inflows (not profitable). If IRR falls below the WACC, they will be paying more than what will be earned back. It will also…

    • 462 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    week five for ops 571
    • 639 Words
    • 2 Pages

    week five for ops 571

    According to the project descriptions, $450,000 has been spent on the product and they average a total of $575,000 being spent in order to bring the product to the market. Even though the dollar amount spent in this project is high, the return on investment for this project is high; by the third year the product is forecasted to have a return of investments of $750,000. The product life of this project is forecasted to be 7 years. Because this product has not been used we would be the first company to launch the product to the market which would create an innovative style allowing our company to be the leader in the industry.…

    • 639 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Case95QuestionsPalmer1
    • 2198 Words
    • 9 Pages

    Case95QuestionsPalmer1

    The higher the rate, the better. IRR is a good indicator of whether a company should accept a long term investment. Ideally, you want the IRR to be greater than the…

    • 2198 Words
    • 9 Pages
    Good Essays
    Read More
  • Powerful Essays

    2012 Final Exam CMS2 500 Spring
    • 1218 Words
    • 6 Pages

    2012 Final Exam CMS2 500 Spring

    (8 points) Our company expects a rate of return of 12% on all projects it undertakes. We must…

    • 1218 Words
    • 6 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    boeing guideline
    • 305 Words
    • 2 Pages

    boeing guideline

    of Return (IRR) from this project is around 15.66%. Given the projected cash flow information…

    • 305 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    Piedmond Case
    • 662 Words
    • 2 Pages

    Piedmond Case

    If management stipulates that the internal rate of return must be equal to or greater than the discount rate, the project will still be justifiable at all discount rates. At all discount rates (8, 10, 12, 14, and 16 percent), the internal rate of return remains at 17.05 percent.…

    • 662 Words
    • 2 Pages
    Good Essays
    Read More
  • Good Essays

    Boeing Case
    • 789 Words
    • 3 Pages

    Boeing Case

    When it comes to investing in the 7E7 project the investors have three major options. The first of these options is to invest in the project with a short term gain in mind. Secondly the shareholder can invest expecting the project to pay off in the long-term. And lastly the prospective shareholder can choose to not invest in the project as a whole. In order to evaluate the profitability of the 7E7 project we are going to calculate the WACC of the project and then compare it to the stated IRR of 15.7%. While this calculation of IRR is subject to other risks such as the amount of units sold expected, we are going to assume 2,500 units will be sold annually over the first 20 years. It is also assumed that over the next 20 years world economies will grow by 3.2% annually and the relationship between air travel and GDP will continue which is growing at 5.1% annually. The calculation of the WACC is determined by using the following equation.…

    • 789 Words
    • 3 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Finance Work
    • 424 Words
    • 2 Pages

    Finance Work

    For the following projects, compute NPV, IRR, MIRR, profitability index, and payback. If these projects are mutually exclusive, which one(s) should be done? If they are independent, which one(s) should be undertaken?…

    • 424 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Paper
    • 1169 Words
    • 5 Pages

    Paper

    3.) In my opinion the company should accept the project based on the financial gain of the project.…

    • 1169 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Good Essays

    SW Airline
    • 550 Words
    • 1 Page

    SW Airline

    The IRR is 15% using the discount rate of 10% and fuel price of $0.8 per gallon, and 42.78%…

    • 550 Words
    • 1 Page
    Good Essays
    Read More
  • Better Essays

    Victoria Chemicals
    • 788 Words
    • 4 Pages

    Victoria Chemicals

    The results of the analysis and modifications are a positive NPV of GBP 13.5 million and an IRR of 25.97%. The Merseyside project should be accepted as long as the cost of capital is lower than 25.97%.…

    • 788 Words
    • 4 Pages
    Better Essays
    Read More
  • Better Essays

    Road King Trucks Case Analysis
    • 1113 Words
    • 5 Pages

    Road King Trucks Case Analysis

    We should accept the project because of the positive NPV and high IRR. We will gain $532 million in wealth which is a big money on the scale like this. The company has a bond rating of AA that makes the risk relatively low. So we should definitely say yes.…

    • 1113 Words
    • 5 Pages
    Better Essays
    Read More
  • Powerful Essays

    PFF Outcome2
    • 780 Words
    • 5 Pages

    PFF Outcome2

    I have been advised that any projects chosen should have an accounting rate of return at least 15% and company’s cost of capital is 10%. The cost of investment should be recovered within four years.…

    • 780 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Powerful Essays

    Voodoo Love Case
    • 1241 Words
    • 5 Pages

    Voodoo Love Case

    $1,400,000 $1,200,000 $1,000,000 Net Present Value ($) $800,000 $600,000 $400,000 $200,000 $0 -$200,000 -$400,000 0.0% 2.0% 4.0% 6.0% 8.0% 10.0% 12.0% 14.0% 16.0% 18.0% 20.0% IRR = 13.8%…

    • 1241 Words
    • 5 Pages
    Powerful Essays
    Read More

Related Topics