Capital Investment Evaluation Metrics

A capital investment is any spending whose economic benefit extends beyond one year — opening a new factory, entering a new market, acquiring another company, or even spending on research and development. Any of these increases a company’s assets, and requires financing (as we’ll see in upcoming lessons).

Quick recap: NPV and IRR

In the Excel Fundamentals course, you learned NPV and IRR in detail — the two most widely used metrics in investment decisions. This lesson builds on them with additional tools companies use to sharpen the decision.

Payback Period

Measures how long a project takes to recover the initial investment. For example, if you invest EGP 500,000 and earn EGP 125,000 a year, the payback period is 4 years.

The core weakness: payback period doesn’t account for anything that happens after you recover your money — two projects with the same payback period could have wildly different outcomes afterward (one hugely profitable, the other flat), and this metric can’t tell them apart.

Discounted Payback Period: the same idea, but it accounts for the time value of money (discounting cash flows first). More accurate, but the core weakness still applies.

Profitability Index

Improves on NPV by comparing it to the size of the investment required — very useful when you have several projects competing for limited capital:

Profitability Index = (NPV + Initial Investment) ÷ Initial Investment

Decision rule: if the index is greater than 1, the project adds value. If less than 1, it destroys value. The higher the index, the more value each invested pound returns — useful for ranking competing projects under a capital constraint.

The XNPV and XIRR functions

The standard NPV and IRR functions in Excel assume cash flows occur at perfectly regular intervals (every year, every month…). But in reality, cash flows often land on irregular dates. That’s where these come in:

• XNPV: just like NPV, but it takes actual dates for each cash flow instead of assuming regular periods.
• XIRR: the same idea for IRR.

These two are far more accurate when dealing with real-world cash flows on irregular dates — which is the common case in practice.

Types of capital investment deals

Not every capital investment is building a factory from scratch — sometimes it’s acquiring an existing company (M&A). Buyers fall into two categories:

Type	Description	Example
Strategic Buyers	Operating businesses buying to capture operating synergies — horizontal or vertical expansion	A manufacturer acquiring its supplier
Financial Buyers	Private equity funds investing purely for financial return, often with heavy leverage	Leveraged buyout (LBO) deals

In the next lesson, we’ll cover another essential distinction: the difference between Enterprise Value and Equity Value.