Purchase Solution

Computing NPV and IRR and Comparing Them

Not what you're looking for?

Ask Custom Question

Sophia Sweeny, the president of Sweeny Enterprises, is considering two investment opportunities. Because of limited resources, she will be able to invest in only one of them. Project A is to purchase a machine that will enable factory automation; the machine is expected to have a useful life of four years and no salvage value. Project B supports a training program that will improve the skills of employees operating the current equipment. Initial cash expenditures for Project A are $300,000 and for Project B are $120,000. The annual expected cash inflows are $94,641 for Project A and $39,507 for Project B. Both investments are expected to provide cash flow benefits for the next four years. Sweeny Enterprise's cost of captial is 8%.

A. Compute the net present value of each project. Which project should be adopted based on the net present value approach?

B. Compute the approximate internal rate of return of each project. Which one should be adopted based on the internal rate of return approach?

C. Compare the net present value approach with the internal rate of return approach. Which method is better in the given circumstances? Why?

Any help would be appreciated. Thank you

Purchase this Solution
Solution Summary

Given two mutually exclusive investments, this solution uses an Excel 97-2003 spreadsheet to compute the net present value of each project, compute the approximate internal rate of return of each project, and compare the net present value approach with the internal rate of return approach.

Solution Preview

Please see the attached Excel 97-2003 spreadsheet.

A. Based upon the net present value approach, Project A should be chosen.

B. Based upon the internal rate of return approach, Project B should be chosen.

C. ...

Purchase this Solution
Free BrainMass Quizzes
Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

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.

Motivation

This tests some key elements of major motivation theories.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

IPOs

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

View More Free Quizzes
Related BrainMass Solutions

  • Finding NPV and IRR for a Project

    I answered the questions using the NPV and IRR formulas. I also demonstrated how you can check your answers or calculate NPV and/or IRR using a financial calculator. I hope everything makes sense. Thanks for using BrainMass.

  • Computing NPV, IRR and Payback Period

    40574 Definition and formulas for NPV, IRR, Payback Period How do I compute NPV, IRR and Payback period when comparing two organizations for acquisition?

  • NPV versus IRR: Cost-plus pricing vs. target costing

    Further, in IRR only single discount rate is being considered and under NPV different discount rates can be applied to see the viability of the projects. This solution answers a question regarding NPV and IRR.

  • NPV, IRR, Profitability Index, and MIRR

    www.exinfm.com/training/capitalbudgeting.doc Please see the attached excel file too Solution helps in computing NPV, IRR, Profitability Index, and MIRR

  • Profitability Index versus NPV and Comparing Investment Criteria

    Profitability index versus NPV and comparing investment criteria are examined.

  • IRR vs. NPV

    125478 Finance: IRR vs. NPV Please see the attachment on a problem comparing the internal rate of return (IRR) to the net present value method (NPV). Please see the attached file. Below is some background information on NPV and IRR.

  • Capital Budgeting NPV IRR

    485900 Capital Budgeting NPV IRR Explain the concepts of net present value and internal rate of return analysis. What do the results of net present value and internal rate of return analysis tell senior managers of an organization?

  • Explain Net Present Value (NPV) method

    Comparing the NPV and other Methods The Net Present Value (NPV) and Internal Rate of Return (IRR) methods both involve compound interest, and the mathematics of discounting requires an assumption about reinvestment rates.

  • IRR NPV of two projects

    Which of the two projects should be chosen and which criteria should be used to aid the decision? Project B should be chosen because of its shorter payback period and better NPV, IRR, and PI result.

  • NPV and IRR Analysis

    118551 NPV and IRR Analysis Derek's Donuts is considering two mutually exclusive investments.

View More Related Solutions