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

    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
  • 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
  • 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
  • Good Essays

    Running Simulation Paper
    • 3567 Words
    • 15 Pages

    Running Simulation Paper

    The Warehouse Facility Consolidation project is aim to improve the NH’s warehouse facilities and can save the company’s operating costs as well as increase the shipping speed. This project is in retail division with an NPV of 2.29, an IRR of 13.56%, and a payback period of 8.23 years and a payback index of 0.31. Also, this project was considered as a medium risk project with 9.25% discount rate. Expansion of Mail-order Catalog Business to Asia is a retail division project, it is considering expanding its mail-order to the Asian market. Although there two possibilities that might happen, succeed or fail, it viewed as a low risk project with very low lifetime project costs which is only 2.73 million. It had an IRR of 19.77%, a discount rate of 8.46%, and a payback period is more than 10 years and the profitability index of this project is 2.85. I choose this project is because the Asian market is a very big market, since the project is low risk and the cost of this project is very low, we think it is worth to try, because if this project is succeed, the company will earn more profit. The last project we selected for this year is Retail Store Expansion in Northeast. The NPV of this project is 5.34 and it had an IRR of 37.45%, a discount rate of 10.04% and a payback period is 5.33 years. We suggested…

    • 3567 Words
    • 15 Pages
    Good 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
  • Satisfactory Essays

    Mat 540 Week 3
    • 589 Words
    • 3 Pages

    Mat 540 Week 3

    c) Calculate the project’s Net Present Value (in MMK) and explain if the project should…

    • 589 Words
    • 3 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
  • 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
  • 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
  • Satisfactory Essays

    Case Analysis of Euroland Foods S.A. Plus a New Implement Strategy
    • 340 Words
    • 2 Pages

    Case Analysis of Euroland Foods S.A. Plus a New Implement Strategy

    I consider IRR as independent variable, NPV at minimum ROR and Equivalent Annuity as functions (just like Polynomials function in Math) for each 10 projects because project 6 (Effluent – water treatment at four plants) definitely should be done.…

    • 340 Words
    • 2 Pages
    Satisfactory 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