Geoenergetix
Geoenergetix
  • Home
  • ENERGY Prices
  • SPY
  • DTREE
  • DRISK
  • Masterclass
  • Internship
  • Resources
  • More
    • Home
    • ENERGY Prices
    • SPY
    • DTREE
    • DRISK
    • Masterclass
    • Internship
    • Resources

  • Home
  • ENERGY Prices
  • SPY
  • DTREE
  • DRISK
  • Masterclass
  • Internship
  • Resources

Capital Budgeting

Consider six proposed investment plans, as illustrated in the table below. We have already calculated the net present value (NPV) and payback period for each of these plans. Your task, as an analyst, is to conduct an investment analysis to evaluate the implications of selecting or comparing these projects based solely on the payback period. Carefully examine the cash flow patterns, payback periods, and associated NPVs, as well as the profitability index of each project.

A table showing cash flows, payback periods, and NPVs for six projects over six years.

Project L: Among all the projects, Project L features the shortest payback period, yet it presents a negative net present value (NPV). Therefore, choosing this project based solely on its quick payback period would be misleading, as it fails to generate value for the company or its shareholders, which is a crucial aspect of effective investment analysis.


Comparing Project M with N: Both Project M and Project N exhibit identical payback periods and net cash flows (NCF) after the payback period. At first glance, either project could be selected based on the payback criteria. However, this would not be a sound recommendation. Project N boasts a higher NPV than Project M, as its cash flows are more front-loaded, resulting in greater value generation in the early years. Thus, despite their similar payback periods, Project N proves to be the superior choice when evaluating long-term value creation.


Comparing Project O with P: Project O offers a shorter payback period compared to Project P, yet Project P provides a higher NPV. Here, the payback period rule might suggest Project O as the better option, while the NPV rule would advocate for Project P. The ultimate decision hinges on the company’s primary objectives. If the emphasis is placed on rapid investment recovery, Project O may be preferred. Conversely, if maximizing value is the priority, Project P emerges as the better choice. Furthermore, the company’s financial capacity and funding availability could play a significant role in this decision, as capital constraints may render the quicker payback of Project O more appealing.


Comparing Project O with Q: This comparison underscores a notable flaw in the payback period selection method. Although both projects share the same payback period, Project Q produces significantly higher NCFs after the third year. Unfortunately, the payback period does not factor in these additional future cash flows, which are vital for assessing a project's long-term value. This limitation illustrates that relying solely on the payback period can lead to suboptimal decision-making, as it overlooks critical value generated beyond the payback period.


Armed with insights into the limitations of the payback period, you are now tasked with presenting your investment analysis to your boss. After reviewing your analysis, he requests an additional evaluation of a new investment proposal.


New Proposal: Your company has identified a small oil field near the coast of Namibia, requiring an estimated investment of $1,000 million. The associated cash flows (after tax) for this project are detailed in the table below. Your boss seeks to understand what the maximum exposure for this project will be, particularly in terms of its profitability index.

Table showing yearly investments and cash flows from year 0 to 7.

Maximum Capital Exposure:

In most projects, the entire investment is not required upfront in a single lump sum. Instead, capital is typically invested over time. In large-scale oil and gas projects, capital spending occurs over several years before cash flows are generated. A key advantage for investors is that the project often begins generating cash even while the spending program is ongoing. This means the project can be initiated without the need for the entire capital investment upfront. Eventually, the project becomes self-funding, as the cash generated from the project is reinvested into its development, eliminating the need for additional external capital, which is crucial for investment analysis.


If we plot a cumulative net cash flow (NCF) curve, the initial phase will show negative cash flows, represented by the line below the x-axis. As the project starts to generate cash, the negative cumulative cash balance will gradually decrease, moving toward zero, and eventually turning positive.


The point where the cumulative NCF line crosses the x-axis represents the payback period, which we have already discussed. The point where the cumulative cash balance reaches its most negative value during the project is known as the Maximum Capital Exposure.


This figure indicates the maximum amount of cash that needs to be supplied by the investor throughout the life of the project. Although the investor may not need to supply the entire capital upfront, they must be prepared to cover the maximum capital exposure. This criterion is also crucial for assessing the risk and financial viability of the project, as it represents the maximum potential downside and feeds into the profitability index.


Understanding the maximum capital exposure is vital for proper scheduling and funding of the project. It is important to avoid situations where multiple projects reach their maximum exposure at the same time, as this could place significant strain on the company’s financial resources, particularly in terms of funding or debt management. Additionally, performing a thorough investment analysis helps ensure that the net present value of the projects remains favorable.

Graph showing cumulative NCF over 7 years with a notable dip and rise.

To address your boss's inquiry regarding capital exposure, we need to perform an investment analysis by calculating the net cash flow (NCF) for each period, followed by computing the cumulative NCF. By identifying the maximum negative cumulative NCF over the life of the project, we find it to be -$450 million. Therefore, the maximum capital exposure for the project is $450 million. This result can also be visually confirmed on the cumulative NCF graph. You share this finding with your boss, and he appears satisfied with the analysis. 


The next indicator we will discuss is the Profitability Index (PI). This profitability index is particularly useful in investment analysis when there are multiple projects to choose from, but only a limited number can be selected due to capital constraints or insufficient available capital.

Profitability Index (PI)

The profitability index is an essential metric in investment analysis, representing the ratio of the net present value (PV) of all future cash inflows to the initial investment.

Profitability Index (PI) formula showing ratio of present value of future cash inflows to initial investments.

It is evident that when the net present value (NPV) is positive, the profitability index (PI) will exceed 1. Conversely, if the NPV is negative, the PI will be less than 1.


The Decision Rule:


Accept the project if: PI > 1.

Reject the project if: PI < 1.


The Profitability Index (PI) serves as a critical tool in investment analysis, providing insight into the profitability of an investment. By examining the formula for PI, it can be interpreted as a "unit" indicator, illustrating how much NPV is generated for every unit of initial capital invested.


For example, consider two hypothetical projects, HC and LC. Both projects have an NPV of $100 million. However, project HC requires an initial investment of $200 million, while project LC only needs $100 million.


If only one project can be selected, project LC emerges as the better choice. Why? Project HC has a PI of 1.5 (calculated as 1 + 100/200), whereas project LC boasts a PI of 2 (calculated as 1 + 100/100). This indicates that for every $1 invested in project LC, $2 is generated in cash flow, compared to $1.50 for every $1 invested in project HC. Clearly, it is more sensible to invest where the return on each unit of investment is higher.

Present Value Ratio (PVR)

The Present Value Ratio is intricately linked to the Profitability Index, as it reflects the relationship between net present value (NPV) and the maximum capital exposure in investment analysis.

Formula for PVR: NPV divided by Maximum Capital Exposure.

Since a positive net present value (NPV) signifies the acceptability of a project, the decision rule for the Present Value Ratio (PVR) is as follows: 


The Decision Rule: 


Accept the project if: PVR > 0. 

Reject the project if: PVR < 0. 


So far, we have focused on the theoretical background of investment analysis criteria. Having studied these concepts, we will now explore their applications in scenarios where conflicts may arise. 


Whether using the profitability index (PI) or PVR, these indicators are generally employed as 'screening' tools. Instead of ranking projects, they help decision-makers exclude projects that fail to meet a certain threshold value for PI or PVR. For instance, if corporate policy dictates that projects with a PI of less than 1.2 should not be considered, all projects with a PI below this value will be excluded from consideration. 


The advantage of using PI or PVR over metrics like Payout or Maximum Exposure is that they account for the time value of money. However, a significant drawback is their inability to reflect the size of a project. A smaller project (with low investment and low NPV) may have a better PI or PVR than a larger project (with high investment and high NPV). Since these are ratio-based indicators, they do not capture the absolute size of a project, potentially leading to suboptimal investment decisions.

NPV vs. IRR Ranking Conflicts

Generally, there is no conflict in decisions based on net present value (NPV) or internal rate of return (IRR). Both indicators typically align in guiding investment analysis towards the same decision. Recall that the NPV criterion for accepting a proposed investment is straightforward: accept the project if the NPV is positive. When comparing multiple projects, the one with the highest NPV should be preferred. Similarly, the IRR rule states that the project with the highest IRR is the better choice. 


However, conflicts may arise when choosing between mutually exclusive projects (where selecting one project means the other cannot be pursued). In such cases, one project may have the highest NPV, while the other has the highest IRR. 


Conflict Due to Cash Flow Patterns: 


Consider the following example (assume the discount rate for the project is 10%, and all figures are in million $).

Table comparing cash flows over 6 years for Project Alpha and Project Omega.

Which project is superior in terms of net present value (NPV) and internal rate of return (IRR)? If we can select only one of the two options based on our investment analysis, which one should we choose? 


First, let us compute the Net Cash Flows (NCF), NPV, and IRR for both options. Additionally, we will consider the profitability index to aid our decision-making process. The table below summarizes the results of our calculations:

Table comparing NCF, NPV, and IRR for Project Alpha and Project Omega.

This illustrates a situation where the net present value (NPV) of Project Alpha is lower than the NPV of Project Omega, yet the internal rate of return (IRR) of Project Alpha is higher than that of Project Omega. Such scenarios can occur in investment analysis and may be challenging for many managers.


The focus is not on which project generates the highest net cash flow (NCF), as the management's decision criteria are based on NPV and IRR rather than NCF, due to the implications of the time value of money.


In such situations, it is advisable to select the project based solely on NPV criteria, as NPV is considered the standard of investment criteria. When in doubt, go for NPV.


The rationale behind the preference for NPV is as follows. Each time a cash flow series is discounted, it is assumed that those cash flows can be re-invested at that rate. This is why they are discounted at that assumed rate. For any acceptable project, the NPV is positive, which also means that the discount rate used for discounting is less than the IRR. If not, then the NPV will be zero or negative, indicating that the assumption of reinvestment is more conservative than what the IRR suggests.


In the given example, the discount rate used is 10%, and the IRRs of the projects are 31% and 21%. The lower rate of 10% appears to be the most likely rate for reinvesting the cash flow. Therefore, decisions should be based on NPV if conflicting results are presented, especially when considering the profitability index.


There is an additional aspect in this example.


If the NPV profile (NPV vs. discount rate) of the two projects is plotted, a 'cross-over' point can be observed. There exists a discount rate below which project Omega has a higher NPV than project Alpha. At a discount rate above this 'cross-over' discount rate, the NPV of project Alpha is higher than that of project Omega.

NPV vs Discount Rate for Project Alpha and Project Omega with labeled values.

When the cost of capital is 10% (discount rate = 10%), Project Omega is preferred based on investment analysis. Project Omega's net present value (NPV) remains advantageous over Project Alpha as long as the discount rate does not exceed 14.5%. Beyond this threshold, Project Alpha’s NPV surpasses that of Project Omega.  


From this analysis, we can deduce that if the cost of capital for these two projects is below 14.5%, Project Omega should be selected. Conversely, if the cost of capital exceeds 14.5%, Project Alpha becomes the preferable option based on its profitability index.  


Consider another scenario often encountered with conflicting NPV versus IRR results.  


Conflict due to project scales:  


In the prior example, the two projects had the same initial investment (or scale). Now consider a third project, Beta, whose initial outlay is double that of Project Alpha (i.e., the two projects differ in scale). The cash flows, net cash flows (NCF), NPV, and IRR for Projects Alpha and Beta are presented in the tables below.

Table showing cash flows for Project Alpha and Project Omega over 5 years.
Table showing NCF, NPV, and IRR for Project Alpha and Project Omega.

If these projects were not mutually exclusive, both would be acceptable in the realm of investment analysis. However, since these are mutually exclusive projects, only one can be accepted. The decision lies between undertaking a larger project with a higher net present value (NPV) but lower internal rate of return (IRR), or a smaller project with a lower NPV but higher IRR.


As in previous scenarios, the decision should be based on NPV, disregarding IRR. Therefore, project Beta should be selected over project Alpha based on its profitability index. The same rationale applies as before. This example aims to illustrate situations where NPV and IRR may yield different project rankings. In this case, the primary cause of conflicting results can be attributed to the initial investment size, as subsequent cash flow patterns are similar.

Next Page

Copyright © 2026 Geoenergetix - All Rights Reserved.

This website uses cookies.

We use cookies to analyze website traffic and optimize your website experience. By accepting our use of cookies, your data will be aggregated with all other user data.

DeclineAccept