Deliver Credibility, Accuracy, Practical Value
Building the Business Case
Solution Matrix Ltd®

Cash Flow Management, Measurement, and Analysis
Definitions, Meaning Explained, Example Calculations

 

In business, the series of cash flow events that follow an action or investment is called a cash flow stream. Decision makers use cash flow metrics such as NPV, ROI, IRR and Payback to evaluate cash flow streams and potential actions.

Business firms must learn to manage revenues and expenses, on the one hand, and cash inflows and outflows on the other.

What Are Cash Flow and Cash Flow Management?

The term cash flow (CF) refers literally to the flow, or movement of cash funds into or out of a business. This article defines and explains cash flow analysis and measurement terms such as cash flow stream, net cash flow, and Cumulative cash flow. The purpose is to illustrate the role of these terms in financial accounting, investment analysis, and business case decision support.

Cash flow is distinguished from accounting terms such as income, revenue, expense, and cost, all of which may result in CF, but which are not that themselves.

  • Consider a person paying a restaurant bill with a credit card (a charge card, not a bank debit card). As a result, dinner is an expense event, but not cash flow. Cash flow occurs later when the cardholder pays the credit card bill.
  • A company may purchase goods or services on credit and register a charge (liability) in its own accounts as an account payable. The firm removes the liability later with a different event, later, cash actually flows from buyer to seller. 
  • A company may sell goods or services, send the customer an invoice requesting payment, and recognize revenue earnings with a transaction in its own accounts as an account receivable. Cash flow associated with the sale may come later when the customer actually sends payment.  

Cash Flow Management

Individuals and companies in business must manage revenues, and expenses, on the one hand, and cash inflows and outflows on the other. The majority of businesses worldwide use accrual accounting, by which they report revenues in the period they are earned along with the expenses incurred in earning the same revenues. The resulting cash inflows and outflows may or may not actually occur in the same period.

The Accrual Accounting Challenge

For firms using accrual accounting …

The timing and management of revenues, costs, and expenses is critical for reporting earnings, determining taxes, and declaring dividends.

The timing and management of cash flow is critical for meeting obligations and needs. These include, for instance, paying employee salaries and wages, and paying interest on loans or bonds. Cash flow needs also includ investing in new product development or infrastructure upgrades.

Tax authorities also allow businesses to report some non cash expenses on the Income statement. The best known non cash expense is depreciation expense, while others include amortization and writing off bad debts. These are charges against earnings solely for the purpose of lowering reported income (thereby lowering taxes). They do not represent actual CF.

Cash Flow Reporting

Firms report actual CF gains and losses for the period directly on another reporting instrument, the Statement of changes in financial position (SCFP, or Cash flow statement, or Funds flow statement). "Non cash" expenses do not appear on the cash flow statement.

Note, incidentally, that for the few firms that use cash basis accounting(instead of accrual accounting), the distinction between cash flow on the one hand and accounting terms (income, revenue, expense, and cost) on the other hand, largely disappears. Cash basis accounting is "all about" CF and little else.

Business Analysis of Cash Flow

Cash flow and Net CF are center stage in two kinds of business analyses: 

  • Financial statement analysis.
    Cash assets and cash flows contribute to metrics for evaluating a firm's financial position—especially its ability to meet current obligations and take action on short notice.
  • Business case and investment analysis.
    Cash flows are the basic input and output of proposed investments or actions. CF estimates enable analysis with cash flow metrics such as Net present value (NPV), Internal rate of return (IRR), Return on investment (ROI), and Payback period.

Explaining Cash Flow in Context

Sections below further explain cash flow concepts. Examples appear in context with related terms from the fields of business analysis, accounting, and cash management. Contextual terms below include:

Net Cash Flow
Cash Flow Stream
Cumulative Cash Flow
Discounted Cash Flow DCF
Net Present Value NPV
Return on Investment ROI
Payback Period
Internal Rate of Return IRR
Business Risk
Income Statement
Cash Flow Statement
Liquidity Metrics
Current Assets
Working Capital
Quick Ratio
Forecasting Cash Flow
Modeling Cash Flow
Cash Problems
Cash Position
Business Case
Business Case

 

Contents

Related Topics


 

Cash Flow in Financial Statement Analysis

Business Firms Must Learn to Manage Revenues and Expenses, on the One Hand, and Cash Inflows and Outflows On the Other.

Public companies everywhere publish financial reports at the close of each accounting period. For obvious reasons, the firm's owners, officers, managers, and employees all take a keen interest in the latest figures on the firm's financial performance and financial position. And, industry analysts, competitors, and government regulators also watch the same figures closely. Everyone with an interest in the company wants to know if the company is operating profitably now and if it is likely to do so in the future.

To address these concerns, most business people turn first to the Income statement and Balance sheet, where they extract metrics on financial performance (such as Net profit margin) and financial position (such as the Debt to equity ratio).T

There is. however, another important issue that also concerns the firm's ability to operate now—and either thrive or die in the future. This is the firm's ability to generate and manage cash flow effectively. To address cash flow questions, investors and analysts must also turn to the firm's cash flow statement.

Firms report their cash flows for a reporting period on a cash flow statement (or Statement of changes in financial position SCFP). The SCFP is one of four primary reporting instruments that publicly traded companies publish quarterly and annually. The other three are the Income statement, Statement of retained earnings, and the Balance sheet (or Statement of financial position).

Statement of Changes in Financial Position: The Cash Flow Statement

The financial Cash flow statement (or SCFP) reports actual cash inflows during the period as Sources of Cash and actual cash outflows as Uses of Cash. Net Cash flow for the period is the difference between total Sources of Cash and total Uses of Cash.

The financial accounting cash flow statement shows management, owners, analysts and authorities the cash holdings available to work with, as well as cash gains and losses during the period just ended. By contrast, the Income statement (or Profit & loss statement, P&L) tells everyone what the company reports for earnings during a period.

The cash flow statement also helps explain the differences between the current Balance sheet and the previous period's Balance sheet. Note especially that some companies (e.g., IBM) call their Balance sheet a "Statement of Financial Position." This helps explain why the financial accounting CF statement is also known as the "Statement of Changes in Financial Position." 

For example cash flow statements and more in-depth coverage of SCFP relationship with other financial statements, see Statement of Changes in Financial Position.

Cash As An Asset

The firm's end-of-period cash holdings also appear as an asset accounton the Balance sheet called Cash on hand or something similar. On the Balance sheet, Cash on hand appears under Current assets, along with other relatively liquid assets such as inventories, accounts receivable, short-term notes due, and marketable securities, and short-term investments due. When addressing concerns about the firm's liquidity, analysts focus on all current asset categories.

Three Metrics for Liquidity

The term liquidity refers to a firm's ability to meet short-term spending needs. These typically include cash payments for employee salaries and wages, utilities bills, and financing charges due. "Cash on hand" is by definition the most liquid of assets, but the other current assets such as inventories and accounts payable are also considered relatively liquid because they should transform into cash in the near term.

Note that the Balance sheet "Cash on hand" account contributes to financial statement liquidity metrics such as Working capital, Current ratio, and Quick ratio. All three examples of these metrics below calculate from the same Balance sheet figures.

Consider for these examples a company whose end-of-year Balance sheet reports:

     Current Assets: $9,609,000
     Current Liabilities: $3,464,000
     Inventories: $5,986,000

Liquidity Metric 1: Working Capital

Working capital is simply the firm's Current Assets balance less its Current Liabilities balance. Both appear on the Balance sheet. Working capital is expressed in currency units (for example, dollars or euro). For the example firm:

Working capital
    = Current assets – Current liabilities
    =  $9,609,000 – $5,986,000 = $3,623,000

Liquidity Metric 2: Current Ratio

The Current ratio uses the same Balance sheet input figures as working capital, except that it makes a ratio of them. As a result, Current ratio is the ratio of Current Assets to Current Liabilities.  For this example:

Current ratio
    = Current assets / Current liabilities
    = $9,609,000 / $5,986,000
    = 1.61      

Liquidity Metric 3: Quick Ratio

A more severe variation on the Current ratio is the Quick ratio metric (or Acid-test ratio). Analysts calculate Quick ratio in the same way they calculate current ratio, except that the Quick ratio numerator essentially uses only the most liquid of the Current assets: Cash, Accounts Receivable, short-term notes due, marketable securities and short-term investments due. The Quick ratio numerator does not include current assets that many consider to be relatively illiquid, namely Inventories. For the example firm:

Quick ratio (Acid-test ratio)
    = (Current assets–Inventories) / Current Liabilities
    = ($9,609,000 –  $3,464,000)  /  $5,986,000
    = 1.03

Quick ratio vs. Current Ratio: What's the Difference?

Which metric is the better measure of a firm's liquidity: Quick ratio or Current ratio? The best answer to that question may differ between firms. This is because the answer depends on the true liquidity or illiquidity of the firm's inventories. And, the answer also depends on the relative magnitude of Inventories in the firm's asset structure.

The Current assets figure input for both metrics includes Cash on hand, as well as other assets that could—in principle—turn quickly into cash (primarily Inventories and Accounts receivable, but also short term notes receivable, marketable securities, and short term investments due.

Liquidity Metrics and Cash Position

Management normally takes an especially keen interest in knowing the current working capital figure when budgeting and planning projects, programs, and products. And, the current Working capital status is especially important when budgeting for expensive for infrastructure improvement or research and development. Working capital must be sufficient for these plans, as well as covering financial expenses (e.g., paying interest on bonds) and operational expenses (such as paying employee salaries).

Metrics results such as the following signal a very poor cash position:

  • Negative working capital,
  • A Current ratio less than 1.2
  • A Quick ratio less than 1.0.

In such cases, the firm is clearly going to have trouble meeting payroll or other short term obligations. By contrast, an abundance of working capital, a high Current ratio, or a  high Quick ratio indicate the opposite. With abundant cash on hand, the firm can pursue investments—such as entering new markets, product research and development, or upgrading corporate infrastructure. And, it can take these actions without borrowing or putting other critical operating needs at risk.

Can a Firm Have Too Much Cash?

Finally, regarding Cash on hand, some financial analysts believe it is possible for a firm to have too much liquidity. Several highly successful technology firms, for instance, are frequently accused of poor financial judgment because they hold very large sums of extra cash, essentially sitting idle in bank accounts. As a result, these firms have Current ratios and Quick ratios of 5.0 or even higher.

Such criticism is especially likely when a firm holds far more Working capital than it will need or use in the near future. The firm's officers are expected to make the best possible use of the firm's assets, after all. Idle cash is, arguably, not serving a good purpose.

For more on the meaning of these metrics, see the Liquidity Metrics. For more examples and templates, see the Excel-based ebook Financial Metrics Pro.

Cash Flow in Business Case and Investment Analysis

What is the TCO Cost Model?
The TCO Cost Model is the Heart of the TCO Analysis

The simplest kind of investment analysis has only two cash flow events: Firstly, the original investment (a single cash outflow) and secondly, the receipt of returns (a single cash inflow). That scenario describes an investor who buys a non-coupon paying bond, such as a US Government savings bond, and holds it to maturity. The two-event CF scenario also describes an investor who makes a winning bet on a racehorse. Investment metrics such as simple ROI, yield, and NPV. all help evaluate two-event investments like these.

The Investment As a Cash Flow Stream

In business, however, investments and actions typically bring a series of cash inflows and outflows over time. The resulting cash flow stream for a large business may look something like Figure 1 below:

 

Figure 1. A cash flow stream for analysis such as the one above typically results from many kinds of business investment actions.

This kind of cash flow stream may result, for instance, from actions such as …

  • Business investments of many kinds.
    For example, buying bonds or investing in real estate properties.
  • Acquiring capital assets.
    Such as acquiring production machinery, vehicles, or computer systems.
  • A decision to fund and launch a project or program.
    For instance, a marketing program or an employee training program.
  • A decision to add a line of business.
    For example, adding an after-sales customer service business.
  • A large set of activities and investments that are the focus of a single business case analysis scenario.

What is the TCO Cost Model?
TCO Cost Model is Heart of TCO Analysis

After forecasting a cash flow stream of this kind, management takes the analysis further with financial metrics and graphics to address questions like these:

  • Does this investment represent a good business decision?
  • How do returns compare to investment costs?
  • How does this investment or action compare to other potential uses of the same funds?
  • Which possible course of action is the better business decision?

In this way, projected CF and its analysis lie at the heart of the financial business case. The next sections show how analysts address such questions:

  • Firstly through cash flow graphics.
  • Secondly, with cash flow metrics.

Note especially that metrics for this purpose take an investment view of the cash flow stream. This means, essentially, that these metrics compare investment costs to investment returns, each in its own way. And, each of metric sends a unique message about the body of cash flow data. The primary metrics for cash flow analysis include:

  • Net cash flow Net CF
  • Cumulative cash flow
  • Net present value NPV
  • Simple return on investment ROI
  • Payback period
  • Internal Rate of Return IRR

Cash Flow Metrics: Graphical Analysis vs. Numerical Analysis

The following two sections show best practice approaches for graphing Net cash flow and Cumulative net cash flow. Both sections derive data for graphic from Table 1, immediately below. And, other sections further below show how to calculate and interpret these metrics.

Example: Cash Flow Stream for Graphical Analysis

Consider an action or "Proposed Investment." Data for plotting the cash flow consequences of making the Investment begin with the estimated cash inflow and cash outflows in Table 1.

Proposed
Investment

Cash
In
Flows
Cash
Out
Flows
Net
Cash
Flow
Now
0
-100
-100
Year 1
40
-20
20
Year 2
50
-30
20
Year 3
75
-35
40
Year 4
90
-30
60
Year 5
100
-40
60
Total
355
-255
100

Table 1. A cash flow stream for analysis such as the one above typically results from many kinds of investments and actions.

The data table alone shows clearly the cash flow forecast of $100 over five years. With these data in hand, the challenge now is deciding how best to:

  • Summarize and describe the cash flow data forecast.
  • Further analyze and evaluate the cash flow stream.

Graphing Net Cash Flow

Reports and presentations on cash flow analysis are clearer, and easier to understand, when authors present both graphics and figure tables to describe cash flow events.

  • Cash flow graphs, such as Figure 2 below, add visual appeal. They grab reader attention and the relieve the monotony of pure text. Beyond this, however, graphics communicate a "feel" for the overall flow pattern across time. Such a "feel" is not so easy to grasp solely from reading numbers. As a result, many analysts make it a rule always to include cash flow graphs in the report Executive Summary.
  • It is good practice also to include tables of cash flow numbers in reports, such as Table 1. Figures enable readers to check the author's calculations for themselves. They also help those who will calculate still other metrics, or combine data sets from different reports.

A cash flow stream, such as the figures in Column 3 of Table 1, normally appears as a series of vertical bars, as in Figures 2 and 3 below. Note especially that these bar charts show both the timing and the magnitudes of cash flow events. The complete chart also shows the profile of the entire cash flow stream.

 

Figure 2. The vertical bar chart provides the simplest and clearest image of a Net cash flow stream. This figure charts the Net CF figures in column 3 of Table 1.

 

Figure 3. When it is important to see both the inflows and outflows that contribute to Net CF, the analyst can show inflows, outflows, and Net CF all In one graph using a combination chart. Figure 3 charts CF data in Columns 1, 2, and 3 of Table 1.

Graphing Cumluative Net Cash Flow and Present Value PV

It is often helpful to present Net cash flow figures and graphs along with other metrics that result from these figures. Readers may want to see Cumulative CF, and CF Present Values (PVs) as well as the Net CF figures. For this, the analyst finds each period's cumulative CF and Present value (PV), as Table 2 shows, below. Here, each year's cumulative CF and PV derive from the Net CF figures.

Proposed
Investment

Net
Cash
Flow
Cumul
Cash
Flow
PV
@8%

Now
–100
- 100
–100
Year 1
20
-80
18.52
Year 2
20
-60
17.15
Year 3
40
-20
31.75
Year 4
60
40
44.10
Year 5
60
100
40.83
Total
100
52.36



Table 2
. Graphing data for Cumulative cash flow and cash flow present values. The present value calculation appears below in the section Calculating NPV.

Graphing Cumulative Cash Flow

Cumulative figures show the total net cash flow through the end of each period. The cumulative value for Year 3, for instance, is the sum of the Year 3 Net cash flow plus the net figures for Year 2, Year 1, and the initial outflow:

Yr 3 Cumulative Cash flow = $40 + $20 + 20 – $100
     = $80 – $100
     = –$20.

Analysts typically present Cumulative cash flow for the entire cash flow stream with a vertical bar chart, such as Figure 4 below.

 

Figure 4. When Cumulative cash flow appears alongside Net cash flow (as in Figure 2, above), the clearest approach is to use simple vertical bar charts for both.

Finding Payback Period From Cumulative Cash Flow

Analysts sometimes instead present Cumulative cash flow for the cash flow stream with a line chart, as in Figure 5 below.

  • The line chart is appropriate when the rate of cash flow is more or less constant during each period.
  • The vertical bar chart is more appropriate when cash flow during the period fluctuates, or appears only at period end.
  • The line chart also reveals investment payback time more precisely than the bar chart. Payback period is the time required for an investment to "pay for itself," or break even. This is the point in time (horizontal axis) where the Cumulative cash flow reaches 0 (vertical axis). Here, payback appears at 3.33 years.
 

Figure 5. The line chart also shows the Cumulative cash flow profile. And, the line chart reveals investment payback period more precisely than the bar chart.

For more on computing and using payback period as a financial metric, see the section on the Payback Peiod Metric, below or the article Payback Period.

Graphing Note: Exhibit 5 above appears as a line chart, as intended. When creating this graph as an MS Excel chart, be sure to create the Line chart using Excel's X-Y Scatter Plot Chart, not Excel's Line chart. Only the scatter plot places data points appropriately at each year end on the horizontal axis. As a result, the payback event appears at the correct point in time.

Graphing Net Cash Flow and Discounted Cash Flow Together

When the net cash flow figures also serve as input for discounting analysis, the analyst can graph each net figure alongside its present value, as figure 6 shows.

 

Figure 6. Net cash flow and discounting results can appear together on the same vertical bar chart.

In Figure 6, each present value is the future net figure (here, called future value), divided by (1+ i )n, where i is an interest rate (discount rate) and n is the number of interest periods (here, years). Using an 8% discount rate, the Year 3 present value is $31.75 when the future net figure,$40, is divided by (1 + 0.08)3 (That is, $40 divided by 1.26). See the next section of this article.

For more on cash flow discounting calculations, see the section below on the Net Present Value metric, or see the article Discounted Cash Flow.

Six Cash Flow Metrics for Comparing Investment Proposals

Cash flow projections often serve as the starting point for comparing different investment possibilities or different business case scenarios.

Which possible investment should the investor choose? Sections below show how analysts use cash flow metrics to address this question.

Comparing Example Cash Flow Streams

Consider, for example, two competing investment proposals, Investment Alpha and Investment Beta. The forecast cash flow streams that should follow for each investment appear in Table 3 and Figure 7 below:

Cash
Flow
Cash In
Flow Alpha
Cash Out
Flow Alpha
Net
Cash
 Flow
Alpha
 
Cash In
Flow Beta
Cash Out
Flow Beta
Net
Cash
Flow
Beta
Now
 
0
-100
-100
0
-110
-110
Y1
 
240
-220
20
100
-40
60
Y2
 
250
-230
20
80
-30
50
Y3
 
260
-220
40
75
-40
35
Y4
 
260
-200
60
85
-35
30
Y5
 
180
-120
60
100
-80
20
Total
 
1,190
-1,090
100
445
-335
85

Table 3. Expected cash flow streams for Investment Alpha and Investment Beta. The analyst will address the question: "Which investment is the better business decision?

Figure 7. Bar chart comparison comparing Alpha and Beta Cash Flow streams.

Which Investment, Alpha or Beta, is the Better Business Decision?

Analysts will try to answer this question by evaluating the forecast cash flow streams for each alternative. Such analyses typically center on six financial metrics:

  1. Net Cash flow.
  2. Cumulative cash flow.
  3. Net present value (NPV).
  4. Simple return on investment (ROI).
  5. Payback period.
  6. Internal rate of return (IRR).

It is rarely advisable to base important business decisions on a single financial metric. When comparing different cash flow streams, different metrics can in fact "disagree" as to which stream represents the better business decision. Decision makers will usually want to see how each action alternative scores on several or all of the above metrics before recommending one action over another.  

Cash Flow Metric 1
Net Cash Flow

The simplest and clearest cash flow metric for comparing investment streams is Net cash flow. Table 3 above shows that Net CF for each investment is simply the sum—the net—of the investment's inflows and outflows across the entire investment period. For these investments, Table 3 above and Table 4 below, show that Alpha's net cash flow of $100 exceeds Beta's net cash flow of $85.

Based on the Net CF difference alone, a few analysts may recommend Alpha as the better business decision. However, prudent analysts know that each financial metric has it's strengths and each financial metric—including Net CF—is blind to other aspects of the data. For that reason, most analysts caution against making investment decisions on the basis of a single financial metric.

Calculating Net CF - More to the Story Than Higher Net CF

There is another story lying beneath the net cash flow figures, however. Individual cash inflows and outflows for Beta are much larger than corresponding inflows and outflows for Alpha.

  • While Investment Alpha has the higher five-year Net CF, Investment Beta has larger total inflows and outflows.
  • Total inflows for Investment Alpha are $1,190 while total inflows for Beta are $440.
  • Total outflows for Alpha are $1,090, whereas total outflows for Beta are $355.

Setting aside investment returns and focusing only on investment costs, Investment Beta is 307% more costly than Investment Alpha. Regardless of return rates for Alpha and Beta, the investor may simply be unwilling or unable to budget and pay Beta's larger costs. Before committing to Investment Beta, the investor will consider whether the extra funds for Investment Beta might instead serve better use elsewhere.

Cash Flow Metric 2
Cumulative Cash Flow

Analysts will probably have questions about period-to-period Cumulative cash flow for each investment. Note that Cumulative cash flow through the final period, of course, simply equals total Net Cash flow for all periods. However, it may be important ask Cumulative cash flow questions about individual periods such as these:

  • During which period does Cumulative cash flow first exceed $50?
  • In which period does Investment Alpha pay for itself? This is the same as asking "When does payback occur for Investment Alpha?

Cumulative CF for Two Cash Flow Streams

To address such question, the analyst prepares a table showing Cumulative cash flow for each investment. Such a table appears as Table 4, below:

Cash
Flow
Net
Cash Flow Alpha
Cum. Cash
Flow Alpha
 
Net
Cash Flow Beta
Cum. Cash
Flow Beta
Now
 
-100
-100
-110
-110
Y1
 
20
-80
60
-50
Y2
 
20
-60
50
0
Y3
 
40
-20
35
35
Y4
 
60
40
30
65
Y5
 
60
100
20
85
Total
 
100
65

Table 4. Period-by-period Net and Cumulative cashflow for investments Alpha and Beta. Each period's cumulative cash flow is the current period's Net CF plus the sum of all previous period Net CF figures.

  • The table shows, for instance, that Beta's Cumulative cash flow first exceeds $50 in year 4, while Alpha's cumulative does not exceed $50 until the final period, year 5.
  • Regarding payback for Alpha, the analyst can see from Table 4, that Alpha's payback must occur in year 4 because year 3's end-of-period cumulative total is negative (-20) while year 4's is positive (40). At some time during year 4, therefor, cumulative payback crosses from negative to positive.

The section below on Metric 4, Payback period, shows how the analyst calculates Alpha's payback more precisely as 3.33 years.

Cash Flow Metric 3
Net Present Value NPV

The analyst found with cash flow metric 1 above that Alpha's Net Cash flow exceeds Beta's by $15. The question now is whether or not Alpha will retain the same kind of advantage when considering the time value of money. Discounted cash flow calculations for Net present value will address this question.

Of the five metrics appearing here, only NPV measures the time value of money directly. Calculating NPVs with an 85 discount rate, Investment Beta has an NPV of $51.87 while Alpha's NPV is $52.36. As a result, the Net present value results favor Investment Alpha—very slightly.

Calculating NPV

The analyst finds Net present value (NPV) for Investment Alpha as follows:

NPV = ∑ FVj / (1+ i )n  for j = 0 to n

FVj for each yearly period j = Net cash flow for the period.
Discount rate i =  8.0% ( 0.08) for example  period.
j = 0 (now) through 5 (Year 5).

NPVAlpha =  –100/(1+.08)0 + 20/(1+.08)1
               
+ 20/(1+.08)2 + 40/(1+.08)3
                + 60/(1+.08)4 + 60/(1+.08)5

                =  –100 + 18.52 + 17.15 + 31.75
                       + 44.10 + 40.83
             
             
  =  $52.36

Using the same approach with Investment Beta's net cash flow figures for FVs, NPVBeta$51.87. The conclusion is that in terms of NPV alone, Alpha has a better NPV. Nevertheless, Alpha's NPV advantage is very small.

Some will ask why the NPV difference is so small, given that these investments showed a much larger difference in Net CF. The reason has to do with the difference in shapes, or profiles, of the two cash flow streams.

With Table 3 and Figure 7 above, it is easy to see that that Beta has the "early returns" while Alpha shows its larger returns later in the five-year period. Alpha's cash flow profile is back loaded, in other words, while Beta's profile is front loaded. Because Alpha's large gains are more distant in the future, discounting impacts Alpha's large gains more severely than it impacts Beta's.

For more in-depth coverage of cash flow discounting and example calculations, see the article Discounted Cash Flow

Cash Flow Metric 4
Simple Return on Investment ROI (Profitability)

The Simple ROI metric is sometimes said to measure investment "efficiency." In this case, investment, and in this case Investment Beta easily wins the efficiency contest. To grasp the importance of Beta's ROI superiority, it is helpful to think of ROI in terms of it's other alternate definition: "Profitability."

ROI Profitability = (Net gains–Net Costs) / (Net Costs)

  • For these investments, Alpha shows greater profits: Alpha's profits are $100 while Beta's profits are $85.
  • Profitability ratios for these investments are quite different. Alpha's Simple ROI (profitability) is 92%, while Beta's ROI (profitability) is 239%.

The difference in profitabilities is not surprising. A simple review of Table 4 shows immediately that both investments have similar "returns" (Net CF) but Investment Alpha has much larger "net costs" (Cash outflows flows). Of the cash flow metrics appearing here, only ROI is sensitive to the magnitude of individual costs (cash outflows). Other metrics such as NPV, payback Period, and IRR are blind to cash outflows themselves because they derive entirely from Net CF figures.

Calculating Simple ROI

Simple return on investment (ROI) for this analysis is as follows:

ROI = (Net gains – Net Costs) / (Net Costs)

For Investment Alpha:

ROIAlpha = ((0+240+250+260+260+180)
              – (100+220+230+220+200+120))
                      / (100+220+230+220+200+120) 

       = (1,190 – 1,090) / 1090

       =  9.2%

Using the same approach, simple ROI for Investment Beta is 23.9%.

For more in-depth coverage on simple ROI as a cash flow metric, and more example calculations, see the article Return on Investment.

Cash Flow Metric 5
Payback Period

Financial officers usually prefer a shorter payback period over a longer payback. There are two reasons for this preference:

  • Firstly, with a shorter payback period, returns are considered less risky.
  • Secondly, the shorter payback period means that investment funds are recovered sooner and available for further productive use.

On the payback period metric, Investment Alpha "pays for itself" in 4.33 years, while Investment Beta takes only 2.00 years to cover costs. Payback period is therefore a strong point in favor of Investment Beta.

Calculating Payback Period

Finding Payback period for Investment Alpha requires the Net CF and Cumulative CF data from Table 2 above.

  • First, notice that Cumulative CF goes from negative to positive between the end of Year 3 and the end of Year 4. Alpha's payback therefore must occur during Year 4.
  • Note also that at the end of Year 3, Alpha's Cumulative cash flow is – $20 and that Net CF during Year 4 is $60. This information is sufficient to locate the payback point in Year 4 by interpolation.
    • At the start of Year 4, $20 more must be "paid back" in order for returns to exactly cover costs.
    • The analyst assumes this occurs at 20/60 of Year 4, i.e., after 0.33 years.
    • Payback period for Investment Alpha is thus 4 + 033 = 4.33 Years.
  •  It is clear immediately from Table 4 that payback for Beta occurs exactly at the end of year 2, the point in time when Cumulative cash flow becomes 0. No further calculations are necessary. Payback period for Investment Beta is 2.0 years.

Note that this approach works only when Cumulative cash flow increases monotonically across time (in other words, cumulative CF always increases from period to period).

For more on the mathematics and meaning of cash flow payback, see the article Payback period.

Cash Flow Metric 6
Internal Rate of Return IRR

When comparing investment cash flow streams, analysts usually find also the internal rate of return (IRR) for each stream. This is because IRR in fact is a popular metric with many financial officers and financial analysts. Some organizations, in fact, use an IRR figure as a hurdle rate. This means that incoming funding requests must project results with an IRR greater than the hurdle rate if they are to receive further consideration. (For more on IRR as a hurdle rate, see the article Hurdle Rate).

IRR is popular and used widely, but it is also the most difficult of the 6 metrics appearing here to interpret. Many businesspeople begin to sense the difficulty when the first encounter the textbook IRR definition:

The internal rate of return (IRR) for a cash flow stream is the interest rate (discount rate) that produces a net present value of 0 for the cash flow stream.

Other things being equal, the investment with the higher IRR is considered the better choice. Interpreting IRR meaning beyond this, however, requires substantial explanation. For a complete introduction to the meaning and interpretation of IRR, see the article Internal Rate of Return.

Also no surprise, the heavier "early returns" with Investment Beta compared to Alpha, result in an IRR advantage for Beta. Beta's cash flow stream produces an IRR of 28.6%, while Alpha's IRR is 22.4%.

Both IRR's are certainly much higher than the investor's cost of capital, and for that reason, financial officers will no doubt agree that both investments promise a net gain. However, the higher IRR with Beta is a strong point in favor of Beta. Using the IRR criterion alone, absent other complications, the analyst will recommend investment Beta over Alpha.

Calculating IRR

Analysts calculate cash flow metrics such as NPV, ROI, and even payback period, directly from formulas. By contrast, the IRR Definition above does not readily lend itself to expression as a formula.

However, the IRR definition above refers to another metric that does calculate from a formula: Net present value NPV. The panel below shows the formula for calculating NPV for a cash flow stream using end-of-period discounting.

 

"Calculating" IRR is essentially a matter of setting NPV equal to 0, on the left side of the NPV formula, and then "solving" for the value of i on the right side. In reality, software actually finds i with a series of approximation trials.

Here, the FVs in the formula are net cash flow figures for each period, i is the discount rate, while n is the number of periods. For Case Alpha and Case Beta, = 5. That is, each cash flow stream covers 5 periods where each period is one year.

For more on finding the IRR for a cash flow stream and the meaning of IRR, see Internal Rate of Return.

Cash Flow Metrics: Conclusions

Which investment, Alpha or Beta, is the better business decision? The financial metrics above provide a mixed "scorecard" on the potential investments.

Which Investment Should the Analyst Recommend?

Part of the information needed for an informed judgment comes from the financial metrics listed above calculated for each cash flow stream. The results for five ot these appear in Table 4, below:

Financial
Metrics
Invest Alpha
Invest
Beta
Net CF
100.00
85.00
IRR
22.4%
28.6%
52.36
51.87
Simple ROI
9.2%
23.9%
Payback
4.33 Yrs
2.0 Yrs
 = The better metric result in each row

Table 4. Cash flow financial metrics for two investment cash flow streams. The results for all metrics except ROI are based entirely on net cash flow figures from Table 3. ROI alone is sensitive to the magnitudes of individual cash inflows and outflows each year.

However, by this scorecard—and absent any information on investment risks—financial specialists and analysts will probably vote in favor of Investment Beta. In conclusion, Beta is the alternative with the higher NPV, higher IRR, and shorter payback period. For many, this will outweigh Alpha's $15 advantage in Net CF and very tiny advantage in NPV.

Looking Beyond Cash Flow

When comparing and choosing investments, the prudent investor also considers two other factors before making a choice:

  •  Firstly, Risk.
    The financial metrics above say nothing about the likelihood these cash flow projections actually appear. Decision makers also try to measure the probabilities that forecast results arrive, as well as the probabilities that other, different results appear.

    The wise investor, in other words, considers potential rewards (measured by financial metrics) and then weighs them against risks.
  • Secondly, other business benefits.
    For investments or actions where all benefits and costs are directly measurable in cash flow terms, the metrics above (and a risk analysis) may be sufficient for the decision maker. However, cash flow metrics are "blind" to business benefits from outcomes that contribute to non financial business objectives.

    Many actions and investments are undertaken for the purpose of reaching business objectives that are defined first in non financial terms. Such objectives may include improvements in customer satisfaction, reduced risk, and company image, for instance. Such benefits may be made tangible and measured in terms of key performance indicators, but not initially in terms of cash flow.

    For more on measuring and valuing non financial business benefits, see Business Benefits.