Cash Flow Analysis

Cash flow is a concept in accounting that refers to the spending or receiving of cash by an organization. For a given period, cash flow is calculated by ending cash balance less starting cash balance. It is important not to confuse cash flow with earnings, as cash flow is related to solvency (or how well a business can pay its immediate debts) and not necessarily profitability. For example, a firm may have millions in revenue, but if accounts receivable are not collected, it is not realized as a cash inflow. Good management and financial modeling are crucial to a firm having healthy cash flows and remaining solvent.

Cash Flow in Financial Statements

There are different types of cash flow concepts, used for different purposes. Cash flow items are laid out in the Income Statement and Cash Flow Statements.

Income Statement

In an income statement, Operating Cash Flow (OCF) is similar to Earnings Before Interest and Taxes (EBIT). Both show how much cash a business can generate from normal operations. It excludes other major items in an income statement that impact net income (interest and taxes). These items are excluded because they are not operational expenses.

OCF provides perspective when analyzing a business by stripping away non-operational activities. By only incorporating costs closely associated with the selling of product or services, such as inventory expense, manufacturing expense, or selling expense one can evaluate how potentially profitable a business can be. For example, if the firm has a huge debt load, it may be wiser to focus on something like OCF to determine future profitability instead of looking at current net income. The limitations of OCF is that the number does include non-cash items such as accounts receivable and deprecation.

Sample Income Statement
Revenue 100,000
Cost of Goods Sold 25,000
Gross Profit 75,000
Operating Expenses
Advertising 8,000
Administrative 10,000
Commissions 10,000
Rent 15,000
Utilities 5,000
Operating Cash Flow 27,000

Cash Flow Statement

The Cash Flow Statement digs deeper into incoming and outgoing cash, and when used with the income statement and balance sheet gives a more complete picture of a company.

There are three main elements to this statement: cash flow from operations, from investing and from financing.

This statement begins with the last item from the income statement, net income. Each line adds back or subtracts the change in non-cash items that impacted net income. The rule for non-cash items on the income statement is: add if initially subtracted, and subtract if initially added.

For example, in the cash flow from operations portion, if the change in accounts receivable (ending AR – beginning AR) is positive, it means that net income was positively impacted, but no cash was received. Thus, you subtract the increase. Likewise, if accounts payable increase in the reporting period, you add the increase to net income because it positively impacted cash. Think of the Cash Flow Statement as a mirror of the income statement – including only non-cash items.

Sample Statement of Cash Flows
Net Income 10,000
Cash Flow from Operating Activities
Add: depreciation expense 3000
Increase in accounts receivable -400
Increase in inventory 2000
Increase in accounts payable 350
    Cash used in operating activities 4,950
Cash Flow from Investing Activities
Capital expenditures -10,000
    Cash used in investing activities -10,000
Cash Flow from Financing Activities
Borrowing of short-term debt 2500
Dividends -450
    Cash used in financing activities 2050
Net change in cash 7,000
Beginning cash 2,000
Ending cash 9,000

In this sample, we can see that the firm reports a net income of 10,000 but only receives 7,000 in cash for the period. This is why a single financial statement cannot capture the activities or status of a firm. If the case were such that net income was healthy but cash flows were negative, before looking at cash flow from financing (the firm is borrowing to stay solvent), that could potentially raise some red flags or call for a decrease in value due to increased risk.

Cash Flow and Valuation

Free Cash Flow (FCF) is another important metric, and better yet for determining the value of a firm based on cash flow. FCF is calculated by taking EBIT and subtracting taxes. After that, subtract capital expenditures, add back depreciation (a non-cash item subtracted while getting EBIT), and then lastly add or subtract the change in working capital.

EBIT

Less: Taxes

Less: Capital Expenditures

Plus: Depreciation

+/- Change in Net Working Capital

Free Cash Flow

Free cash flow is useful because it is the amount of cash that a firm can use to pay dividends, reduce debt, reinvest, or use for acquisitions. In other words, this number shows a more fundamental earning potential for a firm. Unlike net income, free cash flow is not skewed by tax deferments, adjustments or other uncertain factors, such as risk of collecting receivables. Free cash flow is often used in a discounted cash flow analysis to find the net present value of all cash flows which theoretically represents enterprise value (Equity + debt – cash), helping determine the value of equity.

Cash Flow and Decision Making

Cash flow is extensively used in financial decision making. To see how, start by looking at Terminal Value, Net Present Value, Internal Rate of Return, and Payback.

Terminal Value

Terminal value is the present value of all future cash flows beyond the projection period. It can be calculated with the simple Gordon Growth Model:

CF0 = CF1 / (r – g)

Where r is the discount rate, g is the growth rate and CF1 = CF0 * (1 + g). In other words, multiply the last cash flow by (1 + g), and then divide it by the discount rate less the growth rate. This is just like the present value of a perpetuity.

Net Present Value

Net present value (NPV) is a crucial concept in finance. To calculate NPV, you simply sum the present value of all positive and negative cash flows for a given investment. If NPV is positive, that means that an investment is worthwhile, and if it is negative, it is not worthwhile. The NPV incorporates the appropriate discount rate to determine if returns are high enough.

You can use our Net Present Value calculator to find the NPV of a stream of income.

Internal Rate of Return

Internal rate of return (IRR) is a metric closely related to NPV and the discount rate. Internal rate of return is defined as the discount rate required to make NPV equal to 0. For example, in this project if IRR were 10% due to lower cash flows, the NPV would equal 0. IRR must be calculated by trial and error, or with a software program like excel. All else being equal, you want to choose to invest in higher IRR projects, but if deciding between a 20% IRR and 10% IRR project, the 10% one may have a higher NPV due to greater scale, thus being the better investment choice.

You can use our Internal Rate of Return calculator to calculate the IRR for a company.

Payback

Payback is the simplest metric and is expressed as the number of years required to recoup the initial investment in nominal terms, not accounting for time value of money or financing costs.

Example: Capital Expenditure

In this example, a firm is deciding what to do with an unused plot of land. They do not want to sell it, but they are unsure whether it’s more profitable to rent the land or expand production. For simplicity we are examining this decision over a 5-year projection period.

Option 1 – Invest in New Facility

  • The firm’s cost of capital is 10%.
  • The facility will cost $1,000,000 to build
  • Yearly expenses of $40,000 increasing by 3% each year.
  • The revenue generated by this facility is $150,000 the first year, increasing by 3% each year

Breakdown:

The current year is 0 and that is when the million-dollar capital expenditure is incurred.  After year 1, cash flows are calculated by subtracting operating expenses from revenue.  These cash flows are multiplied by discount factors: 1 / (1+ discount factor).

Here the NPV is $209,024, indicating that it is a worthwhile investment, given no other options.  The IRR easily surpasses the discount rate of 10%, indicating a potentially lucrative project.

Invest in New Facility
Discount Rate – 10%
Year 0 1 2 3 4 5
Revenue    150,000    154,500    159,135    163,909       168,826
Plant Cost   (1,000,000)
Operating Expenses      40,000      41,200      42,436      43,709          45,020
Cash Flow   (1,000,000)    110,000    113,300    116,699    120,200       123,806
Terminal Value    1,238,060
Discount Factor

0.91

    0.83

0.75

0.68

 0.62

PV of Cash Flow   (1,000,000)    100,000      93,636      87,678      82,098          76,874
PV of Terminal Value

768,738

NPV

209,024

IRR

19.25%

Payback (years)

  6.18

Option 2 – Rent the Land

  • Discount rate 10%
  • 15,000 cash inflow each year, rising by 3%

In this scenario, the firm opts to rent the property for 15,000, keeping up with the historical inflation rate of 3%.  Similar, but more simple analysis results in an NPV of $332,709.

Rent the Land
Discount Rate – 10%
Year 0 1 2 3 4 5
Revenue 15,000 15,450 15,914 16,391 16,883 17,389
Discount Factor                      1           0.91           0.83           0.75           0.68         0.62
PV of Cash Flows           15,000      14,045      13,152      12,315      11,531     10,797
PV Terminal Value 255868
NPV         332,709

Final considerations

Sometimes it’s difficult to know exactly which cash flows are relevant. Relevant cash flows are characterized by occurring in the future and being incremental.

Incremental cash flows are ones that are incurred by making a decision. Cash flows that occur in the future, but would have been made regardless of the decision are excluded. In this example, items such as depreciation, a non-cash expense, and taxes (cancel out) are not included because they are irrelevant. Furthermore it’s important not to include the value of the land because it does not represent a cash flow. At one point it was paid for, representing a sunk cost, which is defined by occurring in the past and no longer relevant for future decision making.

Faced with these two options, the decision makers in the firm should choose to rent the land instead of expanding production. As a general rule, choosing the option with the highest NPV will increase the firms value the greatest.

Schedule a call

Get PersonalFinanceLab

This lesson is part of the PersonalFinanceLab curriculum library. Schools with a PersonalFinanceLab.com site license can get this lesson, plus our full library of 300 others, along with our budgeting game, stock game, and automatically-graded assessments for their classroom - complete with LMS integration and rostering support!

Learn More

[qsm quiz=143]

Comments are closed.