Comparing Cash Flows with Net Present Value (NPV)

1. Defining Net Present Value (NPV)

At its heart, Net Present Value is a method for determining the profitability of an investment by considering all its associated cash flows over time. The "net" in NPV signifies that we are looking at the sum of all cash flows, both inflows (money received) and outflows (money spent). The most significant outflow is typically the initial investment required to start the project.

The core idea is to translate all these future cash flows into today's terms and sum them up. The result is a single number that represents the total value the project is expected to add or subtract from the firm, measured in today's currency.

The formal definition and the underlying principle of the time value of money are summarized well in the following article from Wall Street Prep.

The general formula for NPV is the sum of all discounted cash flows:

Where:

• $C{F}_t$ is the cash flow in period $t$.
• $i$ is the discount rate per period.
• $n$ is the total number of periods.
• $C{F}_0$ is the cash flow at time 0, which is almost always the initial investment and thus a negative value.

2. The NPV Decision Rule

Once the NPV is calculated, it provides a clear criterion for making an investment decision. This rule is fundamental to capital budgeting.

• If NPV > 0: The project is expected to generate returns that exceed its costs, including the required rate of return (the discount rate). It creates value for the company. You should accept the project.
• If NPV < 0: The project is expected to generate returns that are less than its costs. It destroys value. You should reject the project.
• If NPV = 0: The project is expected to earn a return exactly equal to the discount rate. It neither creates nor destroys value. The company is indifferent, though in practice, such projects are often rejected as they offer no additional value for the risk taken.

Essentially, a positive NPV signifies that the investment is more profitable than the next best alternative with similar risk (which is represented by the discount rate).

3. Calculating and Comparing NPV: A Worked Example

The most effective way to understand NPV is to work through a numerical example. The following video provides a detailed, step-by-step walkthrough of how to calculate the NPV for two separate projects and then use those results to make a decision. This aligns perfectly with your preference for practical, calculation-based learning.

As you saw in the video, the calculation is methodical. For each project, you:

1. List the cash flows for each year, starting with the initial investment at Year 0 (as a negative number).
2. Determine the discount factor for each year using the formula $1/(1+i{)}^t$.
3. Calculate the present value of each cash flow by multiplying the cash flow by its corresponding discount factor.
4. Sum all the present values to get the final Net Present Value.

The image below illustrates this standard tabular format for an NPV calculation.

Comparing Mutually Exclusive Projects

The video example also highlights a critical application of NPV: choosing between mutually exclusive projects. These are projects where you can only choose one, not both (e.g., building one of two different types of factory on the same piece of land).

The rule is simple: if both projects have a positive NPV, choose the one with the higher NPV.

In the video's example:

• NPV of Project X = 8,454
• NPV of Project Y = 9,456

Both projects are profitable (NPV > 0). However, since Project Y has a higher NPV, it is the superior investment because it is expected to add more value to the firm.

4. NPV for Irregular Cash Flows and Calculator Use

In the previous lesson and in the ACTEX manual, we touched upon using a financial calculator's cash flow worksheet. This function is essentially a dedicated NPV calculator and is the most efficient way to tackle these problems in an exam setting, especially when cash flows are not a simple annuity.

Let's revisit this practical skill, drawing on the ACTEX study manual.

To perform an NPV calculation on a BA II Plus calculator, you would:

1. Press the CF key to enter the Cash Flow worksheet.
2. Enter the initial investment as CF0. Remember to make it negative. Press ENTER.
3. Scroll down and enter the cash flow for the first period, C01. Press ENTER.
4. Scroll down to F01. This is the frequency of that cash flow. If it's a single payment, leave it as 1 and scroll down.
5. Repeat steps 3 and 4 for all subsequent cash flows.
6. Press the NPV key. It will ask for the interest rate, I. Enter the discount rate as a percentage (e.g., 10 for 10%) and press ENTER.
7. Scroll down to NPV and press CPT (compute). The calculator will display the Net Present Value.

Mastering this calculator function is a key practical skill for the CB1 exam.

Conclusion

Today we've transformed a mechanical calculation—present value—into a powerful decision-making tool. Net Present Value provides a clear, quantitative basis for evaluating and comparing investment opportunities.

Key Takeaways:

• Net Present Value (NPV) is the sum of the present values of all cash flows (inflows and outflows) associated with a project.
• The NPV decision rule is to accept projects with a positive NPV and reject those with a negative NPV.
• When comparing mutually exclusive projects, the one with the highest positive NPV should be chosen.
• While NPV can be calculated manually in a table, using a financial calculator's cash flow worksheet is the most efficient method for exam purposes.

Your background in statistics gives you an appreciation for the fact that the cash flows we used today are forecasts, or expected values, subject to uncertainty. So far, we've focused only on the expected return of a project via its NPV. In our next lesson, we will start to formally address the other side of the coin: risk. We'll learn how to quantify the risk of an investment using standard deviation, laying the foundation for understanding the fundamental risk-return tradeoff in finance.