Purchase Solution

Computing NPV, IRR and MIRR

Not what you're looking for?

Ask Custom Question

Project S has a cost of $10,000 and is expected to produce benefits (cash flow) of $3,000 per year for 5 years.
Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years.

Calculate the two projects' NPVs, IRRs, MIRRs, and PIs assuming a cost of capital of 12%. Which project would be selected, assuming they are mutually exclusive using each ranking method? Which should actually be selected?

Purchase this Solution

Solution Summary

For two projects, this solution illustrates how to compute the Net Present Value, Internal Rate of Return, and Modifed Internal Rate of Return. It then discusses which project should be selected.

Solution Preview

Please see the attached Excel 97-2003 worksheet.

The Net Present Value discounts the cash flows and deducts the initial investment to determine whether, at the discount rate, the project adds to the investor's wealth and by how much. Project L adds $1,675.34 and Project S adds $814.33. Based upon NPV, I would choose Project L.

The Internal Rate of Return computes the rate of return at which the project's net present value is $0. Project L's IRR is 14.67 percent and Project S's is ...

Purchase this Solution


Free BrainMass Quizzes
Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Introduction to Finance

This quiz test introductory finance topics.

Motivation

This tests some key elements of major motivation theories.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

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.