7.6 Example: IBM
Valuation Tutor lets you immediately access current and past financial statements. For example, consider the following cash flow statement for IBM:
By entering the stock ticker for IBM and selecting the reporting date and statement you can access IBM's cash flow statement as follows:
Now suppose you want to estimate FCFF for 2009, you can verify the following information:
Depreciation and Amortization (DA) = 3,773 + 1,221 = 4,994
Other Non-Cash Items (ONCI) consists of Stock-based
Compensation, Deferred Taxes, Net Gain on Assets and
Liabilities, Retirement Related and Other Assets/Other
Liabilities.
Other Non-Cash Items = 558 + 1,773 - 395 - 2,465 + 319 =
-210
Change in Working Capital (DWC)
= Receivables, Inventories, Accounts payables
Change in Working Capital = 2,131 + 263 + 170 = 2,564
Accounting cash flow from operations (CFO) can now be
calculated as:
CFO = NI + DA + ONCI –
ΔWC
= 13,425 + 4,994 – 210 + 2,564 = 20,773
The next step requires getting additional information from IBM's
statements:
FCFF = CFO + Interest*(1-tc) – CAPEX = NI +
Interest*(1-tc) + DA + ONCI
-
ΔWC
- CAPEX = 20,773 – CAPEX
First, the supplementary data part of the Cash Flow Statement
usually provides the required additional information:
Here it is observed that:
Income Taxes Paid = 1567 in 2009
Interest Expense = 1240 in 2009.
The effective tax rate for IBM can be computed from taxes paid
divided by net income before taxes.
From the Income Statement this number for 2009 is 18138
(see below). As a
result, the effective tax rate for IBM in 2009 is:
Effective Tax Rate = 1567/18138 = 0.087.
Alternatively, you can check IBM’s provision for taxes which
4713 for 2009. From
this provision the effective tax rate is:
Effective Tax Rate (Using the Provision for Taxes from the
Income Statement below) = 4713/18138 = 0.259 or 26%.
The latter estimate seems to be more realistic for IBM’s
effective tax rate.
Interest net of tax 2009 = 1240*(1 – 0.26) = 917.60
Finally, we can get CAPEX directly from IBM’s Consolidated
Statement of Cash Flows and in particular the Investing
Activities section as follows:
CAPEX equals the purchases made for productive capacity for both
goods and services.
As a first pass we can compute this as follows:
CAPEX = Payments for Property, Plant and Equipment +
Investment in Software
CAPEX 2009 = -3447 – 630 = -4077 (purchases of capacity)
CAPEX comes from the Investing Activities part of the cash flow
statement.
Finally, IBM’s FCFF for 2009 collecting together the above is:
FCFF = CFO + Interest*(1-tc) – CAPEX = NI +
Interest*(1-tc) + DA + ONCI
-
ΔWC
- CAPEX = 20,773 – CAPEX
FCFF = 20,773 + 917.60 – 4,077 = 17,614
When using FCFF for valuation purposes analysts usually apply
additional adjustments to take into account that you are really
interested in projecting what future CAPEX is.