• Skip to primary navigation
  • Skip to main content
  • Skip to footer
WallStreetMojo

Wallstreet Mojo

Wallstreet Mojo

MENUMENU
  • Resources
        • Financial Modeling

          • What is Financial Modeling
          • Financial Modeling Excel
          • Financial Model Types
        • Excel Modeling

          • Financial Functions Excel
          • Sensitivity Analysis in Excel
          • Time Value of Money
        • Excel-Modeling
        • Valuation

          • Discounted Cash Flow
          • Dividend Discount Model
          • Terminal Value
        • Valuation
        • Investment Banking Guides

          • Investment Banking
          • What is LBO?
          • What is Pitch Book?
        • Investment-Banking-Guides
        • Excel

          • Excel Functions
          • Excel Charts
          • Excel Tips
        • Excel
        • Others

          • Resources (A to Z)
          • Accounting
          • Financial Statement Analysis
          • Equity Research
          • Private Equity
          • Corporate Finance
  • Free Courses
  • All Courses
        • Certification Courses

          Certificate
        • All in One Financial Analyst Bundle

          Financial-Analyst-Bundle
        • Financial Modeling Course

          Financial-Modeling-Course
        • Investment Banking Course

          Investment-Banking-Training
        • Others

          • M&A Modeling Course
          • LBO Modeling Course
          • Valuation Modeling Course


          • PE Modeling Course
          • VC Modeling Course
          • View All
  • 250+ Courses All in One Bundle
  • Login

Mutually Exclusive Projects

Home » Financial Modeling » Excel Modeling » Mutually Exclusive Projects

By Harshada Khot Leave a Comment

Mutually Exclusive Projects

What are Mutually Exclusive Projects?

Mutually Exclusive Projects are usually referred to projects undertaken as a part of capital budgeting activities wherein companies choose project/investments using certain parameters/criteria to find out its viability. These mutually exclusive projects are such that acceptance of project A will lead to rejection of project B. The projects, in this case, happen to compete with each other directly.

Methods used by Companies to Evaluate Mutually Exclusive Projects

There are various methods adopted by companies to evaluate mutually exclusive projects and they serve as the criterion on which the acceptance or rejection decision shall be made.

Following are methods of mutually exclusive projects.

#1 – NPV (Net Present Value)

NPV refers to the present value of the future cash flows arising out of the project which then deducts the initial outlay or investment.

 NPV

The decision criteria stand as follows:

  • Accept if NPV > 0
  • Reject if NPV < 0

#2 – IRR (Internal Rate of Return)

It is nothing but the discount rate that would make all of the present values of cash flows equal to the initial outlay. IRR is the discount rate at which the NPV of the project equals zero. Companies often have a hurdle rate or a required rate of return that serve as the benchmark.

 IRR

The decision criteria therefore are :

  • Accept if IRR > r (Required rate of return/hurdle rate).
  • Reject if IRR < r (Required rate of return/hurdle rate).

#3 – Payback Period

Payback Period method takes into consideration the tenure or rather the number of years required to recover the initial investment based on the cash flows of the project.

#4 – Discounted Payback Period

One drawback of the payback period is that the cash flows do not consider the impact of the time value of money. Hence discounted payback period, therefore, considers the cash flows by discounting them to their present values and then calculating the payback.

#5 – Profitability Index (PI)

Profitability Index refers to the present values of the future cash flows arising out of the project which is then divided by the initial investment.

Popular Course in this category
Cyber Monday Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) 250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
4.9 (1,067 ratings)
Course Price

View Course

Related Courses
M&A Modeling CourseLBO Modeling CourseValuation Modeling Course

Mutually Exclusive Projects PI

The investment criteria are :

  • Invest if PI > 1
  • Reject if PI < 1

Examples of Mutually Exclusive Projects

Let’s see examples of mutually exclusive projects to understand it better.

You can download this Mutually Exclusive Projects Excel Template here – Mutually Exclusive Projects Excel Template

Example #1

Consider the following cash flows of project A and project B.

Mutually Exclusive Projects Example 0.1.1

Solution:

Calculation of NPV for Project A will be –

Example 1

Calculation of NPV for Project B will be –

Mutually Exclusive Projects Example 1.1

The NPV and IRR calculation using an excel workbook are demonstrated asunder. Assuming a discount rate of 13%(future cash flows are discounted at 13% to arrive at their present value), using NPV function we are able to arrive at the required NPV after deducting the initial outlay. (Year zero in this case).

Calculation of IRR for Project A will be –

Similarly, IRR can now be also arrived at using the IRR function in excel as demonstrated below.

Example 1.2

Calculation of IRR for Project B will be –

Mutually Exclusive Projects Example 1.3

NPV is positive in case of both projects and IRR is greater than the discount rate of 13%.

Since the projects are mutually exclusive we can’t choose simultaneously all the projects. However since both the NPV and IRR are greater in the case of project A, we would choose project A since these are mutually exclusive projects.

So have you come across scenarios wherein the NPV and IRR conflict against each other while evaluating mutually exclusive projects.

Yes, certainly there are situations where we counter conflict between NPV and IRR while evaluating mutually exclusive projects.

Example #2

Consider the following cash flows of 2 projects.

Example 2

Solution:

The NPV and IRR assuming a discount rate of 10% are displayed below as follows.

Calculation of NPV for Project A will be –

Mutually Exclusive Projects Example 2.1

Calculation of NPV for Project B will be –

Example 2.2

Calculation of IRR for Project A will be –

Mutually Exclusive Projects Example 2.3

Calculation of IRR for Project B will be –

Example 2.4

If you happen to notice, NPV of project B is greater than A whereas IRR of project A is greater than project B.

Please refer given excel template above for detail calculation of mutually exclusive projects examples.

Does One Method Have an Advantage Over the Other?

  • In instances where the initial cash flows are higher, it is noticed that the IRR shows a higher number, in contrast to the project where the project has cash flows coming in later. Hence IRR will tend to skew towards a higher range when there are higher cash flows initially.
  • Usually, the discount rates change over the life of the company. An unrealistic assumption that IRR makes is that all cash flows in the future are invested at the IRR rate.
  • There may also be instances wherein there are multiple IRRs or no IRR for a project.

Does NPV Seem Like a Better Option then IRR?

Well yes. An important assumption that NPV makes is that all future cash flows are reinvested at the most realistic discount rate-opportunity cost of funds. NPV too has its disadvantages as it does not consider the scale of a project.

Nevertheless, when faced with a conflict between IRR and NPV in the case of mutually exclusive projects it is suggested to go ahead with the NPV method as this happens to show the amount of real wealth gain for the company.

Advantages and Disadvantages of Mutually Exclusive Projects?

Advantages

  • Company will be able to optimally select the best project/investment that gives in the best returns.
  • Company will be able to commit their capital only to the optimal project considering the limited resources.

Disadvantages

  • Though both projects generate positive NPVs, companies will have to select the winner and leave out the rest.

Are There any Changes Off Late in Mutually Exclusive Projects?

  • Well yes, there is something called incremental analysis that is being undertaken when both projects seem feasible.
  • It refers to an analysis of differential cash flows of the 2 projects (Smaller cash flows are deducted from the cash flows of the larger project).
  • However, fret not as this analysis is not predominantly used and companies do majorly rely on NPV and IRR analysis.

Conclusion

Well, I think to gauge on the feasibility or viability of the investments these methods serve as a great decision-making tool for corporates, as when they invest in positive NPV generating mutually exclusive projects, they tend to add to the wealth of the shareholders which no doubt gets reflected in the increasing share prices.

Recommended Articles

This has been a guide to What are Mutually Exclusive Projects and its definition. Here we discuss the examples of mutually exclusive projects and the best methods for evaluation. You can learn more about financial modeling from the following articles –

  • Fisher-Price Index Definition
  • Feasibility Study Examples
  • Paasche Price Index | Limitations
  • Net Present Value | Advantages
  • Definition of Modified Dietz
  • Profile of NPV
  • PV vs NPV – Compare
  • NPV vs XNPV – Compare
  • Calculate Incremental IRR
0 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Filed Under: Excel Modeling, Financial Modeling

Reader Interactions
Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer
COMPANY
About
Reviews
Blog
Contact
Privacy
Terms of Service
FREE COURSES
Free Finance Online Course
Free Accounting Online Course
Free Online Excel Course
Free VBA Course
Free Investment Banking Course
Free Financial Modeling Course
Free Ratio Analysis Course

CERTIFICATION COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Business Valuation Course
Equity Research Course
CFA Level 1 Course
CFA Level 2 Course
Venture Capital Course
Microsoft Excel Course
VBA Macros Course
Accounting Course
Advanced Excel Course
Fixed Income Course
RESOURCES
Investment Banking
Financial Modeling
Equity Research
Private Equity
Excel
Books
Certifications
Accounting
Asset Management
Risk Management

Copyright © 2019. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

Download Colgate's Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.

WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.

* Please provide your correct email id. Login details for this Free course will be emailed to you

WallStreetMojo

Download Mutually Exclusive Projects Excel Template

By continuing above step, you agree to our Terms of Use and Privacy Policy.

CYBER WEEK OFFER - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More