Preview only show first 10 pages with watermark. For full document please download

Sex12

   EMBED


Share

Transcript

CHAPTER TWELVE The Analysis of Growth and Sustainable Earnings Concept Questions C12.1 A growth firm is one that is expected to grow residual earnings. As changes in residual earnings are equal to abnormal earnings growth, a growth firm can also  be defined as one that can generate abnormal earnings growth, that is, earnings growth growth (cum-d (cum-divi ividend dend)) at a rate rate greate greaterr than than the requir required ed rate. rate. As residu residual al earnings is driven by return on common equity (ROCE) and growth in equity, a growth growth firm is one that can increa increase se ROCE ROCE and/or and/or grow grow invest investmen mentt that that is expected to earn at an ROCE that is greater than the equity cost of capital. C12.2 Abnormal earnings growth is the same as growth in residual earnings, so it doesn’t matter. Abnormal growth in earnings – growth above the required rate of growth  – is a simpler concept, but residual earnings growth helps to lead the analyst into the drivers of growth – investment and the profitability of investment. C12.3 A no-growth firm has zero or negative residual earnings growth or, equivalently, has growth in cum-dividend earnings at a rate equal or less than the required return. C12.4 A growth company would have the following features: • An ROCE greater than the cost of capital The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 41 41 • Increasing residual earnings (that amounts to abnormal earnings growth) due to • Sales growth (with positive profit p rofit margins) • Increasing profit margins • Increasing asset turnover  • Growing net investment (earning a ROCE greater than the cost of capital) A growth company is one that is expected to have these attributes in the future. It is possible that a firm may have had these attributes attributes in the past but is not expected to have them in the future. And it is possible that a firm firm may not have these features currently ( a start-up, for example), but is expected to have them in the future. C12.5 The analyst is interested in the future because value is based on future earnings (or strictly strictly,, on future residual residual earnings). earnings). So she analyzes current current earnings for  indications of what future earnings might might be. To the extent that that current earnings is not sustainable (that is, will not be a part of future earnings), the analyst wants to identify those earnings. C12.6 Transitory earnings are aspects of current earnings that have no bearing on future earnin earnings. gs. Exampl Examples es are earnin earnings gs from a one-ti one-time me contract contract,, a writewrite-off off on unusua unu sually lly large large bad debt, debt, a writewrite-down down of obs obsole olesce scent nt invent inventory ory,, a one-tim one-timee uninsured loss of property, a restructuring charge, and profit from an asset sale or  a discontinued line of business.  p. 42 Solutions Manual to to accompany Financial Financial Statement Statement Analysis and Security Security Valuation • Increasing residual earnings (that amounts to abnormal earnings growth) due to • Sales growth (with positive profit p rofit margins) • Increasing profit margins • Increasing asset turnover  • Growing net investment (earning a ROCE greater than the cost of capital) A growth company is one that is expected to have these attributes in the future. It is possible that a firm may have had these attributes attributes in the past but is not expected to have them in the future. And it is possible that a firm firm may not have these features currently ( a start-up, for example), but is expected to have them in the future. C12.5 The analyst is interested in the future because value is based on future earnings (or strictly strictly,, on future residual residual earnings). earnings). So she analyzes current current earnings for  indications of what future earnings might might be. To the extent that that current earnings is not sustainable (that is, will not be a part of future earnings), the analyst wants to identify those earnings. C12.6 Transitory earnings are aspects of current earnings that have no bearing on future earnin earnings. gs. Exampl Examples es are earnin earnings gs from a one-ti one-time me contract contract,, a writewrite-off off on unusua unu sually lly large large bad debt, debt, a writewrite-down down of obs obsole olesce scent nt invent inventory ory,, a one-tim one-timee uninsured loss of property, a restructuring charge, and profit from an asset sale or  a discontinued line of business.  p. 42 Solutions Manual to to accompany Financial Financial Statement Statement Analysis and Security Security Valuation  Note that write-offs and restructurings do have an effect on future income in a technical, accounting sense because, if the charge is not taken now, it will have to be taken in the future. future. But, provided provided the charge charge is a "fair" one that does does not over or underestimate the restructuring cost, its effect on earnings will be completed in the current period. C12.7 In one sense, these gains and losses are persistent because they occur every  period. But a gain or loss in the current period gives no indication of whether  there will be a gain or loss in the future. That is, the expected future future gain or loss is zero, irrespect irrespective ive of the current gain gain or loss. So these gains and losses losses are treated as transitory. C12.8 Operating leverage is the proportion of fixed and variable costs in a firm's cost structure; it is an income statement concept. Operat Operating ing liabil liability ity levera leverage ge is the propor proportio tion n of operat operating ing liabil liabilit ities ies in net operating assets; it is a balance sheet concept. Both create create leverage. leverage. from from sales. sales. Operating Operating leverage leverage levers levers the operating operating income Operat Operating ing liabilit liability y levera leverage ge levers levers operatin operating g income income from net operating assets (RNOA). is correct. correct. A higher higher contribut contribution ion margin margin means means lower variable variable costs. costs. So C12.9 This is more of each dollar of sales "goes to the bottom line." Profit it marg margin inss in reta retail ilin ing g tend tend to be low low beca becaus usee the the bus busin ines esss is very very C12.10 Prof competitive competitive.. See Table 11.3 in Chapter Chapter 11 where the median profit margin margin for  The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 43 43 food stores is 1.7%. If a firm were reporting a 6.0% profit margin, we'd guess that it is temporary: Competition will probably erode this margin. C12.11 Common equity grows through earnings and new share issues, and declines through stock repurchases and dividends. But more fundamental factors underlie this growth. Equity grows because of increases in sales (revenues) that require more net operating assets (to service the sales). The amount of net operating 1 assets to service additional sales depends on ATO , that is, on the NOA required for each dollar of sales. The amount of equity growth to finance the NOA growth depends on the extent of net debt financing used. If firms issue debt to finance the growth or liquidate financial assets, no growth in equity occurs. C12.12 Almost none of the drop in common shareholders' equity was due to operations. Three factors drive changes in equity: 1. Changes in sales 2. Changes in asset turnover  3. Changes in net debt Reebok's sales remained "flat" from 1995 to 1996 and the asset runover (ATO) changed little. So almost all of the change in equity was due to the change in  p. 44 Solutions Manual to accompany Financial Statement Analysis and Security Valuation financial leverage as a result of the stock repurchase that was financed by new debt. C12.13 Yes, this is correct. A trailing P/E can be high because current earnings are temporarily low, even though expected future growth would indicate that the P/E should otherwise be low. C12.14 This is correct. A normal P/E implies that residual earnings are expected to continue at the current level (and, equivalently, earnings are expected to grow, cum-dividend, at the required rate of return). See the Whirlpool example on the chapter. C12.15 Yes. See the cell analysis of the chapter. A firm with a high P/E and a low P/B is one where residual earnings are expected to increase from their current level but are expected to be lower than zero (a cell C firm). C12.16 Yes, correct. Temporarily high earnings are expected to decline, so should have a low P/E ratio. The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 45  Exercises E12.1 Calculating Core Profit Margin The reformulated statement that distinguishes core and unusual items is as follows (in millions of dollars): Sales Core operating expenses Core operating income before tax Tax as reported Tax benefit of net debt Tax on operations Tax allocated to unusual items: Core operatimg inome after tax Unusual items Start-up costs Merger charge Gain on asset disposals 667.3 580.1 (73.4 +13.8) 87.2 18.3 (0.39 × 20.5) 8.0 26.3 5.4 31.7 55.5 (4.3) (13.4) 3.9 (13.8) Tax effect (0.39) 5.4 (8.4) Translation gain 8.9 Comprehensive operating income 0.5 56.0 Note: 1. The currency translation gain is transitory; it does not affect core income. 2. Translation gains, like all items reported in other  comprehensive income are after-tax. 3. The gain on disposal of plant may attract a higher tax rate than 39% due to depreciation recapture.  p. 46 Solutions Manual to accompany Financial Statement Analysis and Security Valuation Core operating income (after tax) = 55.5 Core operating income (after tax) Core profit margin = Sales 55.5 = 667.3 = 8.32% The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 47  E12.2 E12.2 Explai Explaining ning a Change Change in Profit Profitabil ability ity Reformulate balance sheets and income statements Balance Sheets 1998 Cash  A/R  A/R Inventory PPE  Acc  Accrr. Liab.  A/P  A/P Def. Taxes NOA 100 900 2,000 8,200 (600) (900) (490) S/T investments Bank loan Bonds payable Preferred stock Leverage (NFO/CSE)  Av  Average lev leverage NFO NOA 100 1,00 ,000 1,900 9,000 (500) (1,00 ,000) (500) (300) 9,210 9,210 CSE 1999 4,300 1,000 5,000 5,000 4,210 9,210 9,210 1.188 2000 NFO NOA 120 1,25 ,250 1,850 10,500 (550) (1,10 ,100) (600) (300) 10,000 4,300 1,000 5,000 5,000 10,000 1.000 1.08 .086  p. 48 Solutions Manual to to accompany Financial Financial Statement Statement Analysis and Security Security Valuation 11,470 NFO (330) 3,210 1,000 1,000 4,880 6,590 11,470 11,470 .741 .85 .853 Income Statements 1999 Sales CGS S&A Core OI b/4 tax Tax on OI Core OI after tax Restructuring charge Tax Benefit Operating income Net Financial expenses Net interest expenses Tax Benefit 2000 22,000 13,000 8,000 190 65 Gain on retirement (after tax) Preferred divs. NI available for common 406 (138) 268 0 268 80 21,000 1,000 337 663 24,000 13,100 8,250 21,350 2,650 812 1,838 (125) 538 (348) 190 405 (137) 268 100 168 80 (248) 1,590 Tax on Core OI (1999) = 134 + 138 + 65 = 337 Tax on Core Core OI (2000) (2000) = 675 + 137 = 812  Net borrowing cost (NBC): Net fin. exp/average NFO 1999 1999:: 2000 2000:: 348/ 348/5, 5,00 000 0 = 6.9 6.96% 6% 248/ 248/4, 4,94 940 0 = 5.0 5.02% 2% Return on net operating assets (RNOA): OI/average NOA 1999: 2000 2000:: 538/9,605 = 5.60% 1,83 1,838/ 8/10 10,7 ,735 35 = 17. 17.12 12% % Core profit margin (PM): Core OI/Sales 1999: 663/22,000 = 3.01% 200 2000: 1,838/ 38/24,00 ,000 = 7. 7.66% Asset turnover (ATO): Sales/average NOA 199 1999: 22,000 000/9,60 ,605 = 2. 2.290 The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 49 49 2,000 2,000:: 24,00 24,000/ 0/10, 10,73 735 5 = 2.236 2.236 Unusual items to to net operating assets: assets: UI/average NOA 1999: -125/9,605 2 000 Spread: = -1.30% =0 RNOA - NBC 1999: -1.36% 2000: 12.10% Explaining ∆ ROCE: ROCE (1999) = NI avail for common/aver common/average age CSE = 190/4,605 190/4,605 = 4.13% ROCE (2000) = 1,590/5,795 = 27.44% = 23.31% ∆ ROCE (2000) ∆ R OC E (2000)] = ∆ RNOA + [∆ Spread × FLEV (1999)] + [∆ FLEV × Spread = 0.1152 + (0.1346 × 1.086) + (-0.233 × 0.1210) = 0.2331 Explaining the ∆ RONA component: ∆ RN O A = [∆ core profit margin × turnover (1999)] + [∆ turnover × core  profit margin (2000)] + ∆ unusual items/NOA = [0.0465 × 2.290] + [-0.054 × 0.0766] + 0.0130 = 0.1152 In words, the ∆ ROCE is explained by an increase in profit margin (despite a small reduction in sales turnover) that was levered up by an increase in the spread (the effect of  which was reduced by a decrease decrease in leverage). In addition there were no unusual changes in 2000 that reduced operating profitability.  p. 50 Solutions Manual to to accompany Financial Financial Statement Statement Analysis and Security Security Valuation E12.3 Explaining a Change in operating Profitability: Quantum Corporation Refer to the solution to exercise E10.9 in Chapter 10 for calculations of RNOA,  profit margins, turnovers and related measures used below. The change in RNOA is explained by the change in its components: RNOA ∆ RNOA Core PM ∆ Core PM ATO (based on ave. NOA) ∆ 1994 0.0244 1995 0.1872 0.1628 1996 -0.0836 -0.2708 0.0112 0.0432 0.0320 6.784 0.0181 -0.0251 5.260 -0.1830 -1.5240 -0.1058 -0.1791 -0.0522 -0.0733 6.967 ATO UI/Average NOA ∆ [UI/average NOA] ∆ RNOA1995 -0.0536 = [∆ Core PM1995 x ATO1994] + [∆ ATO1995 x Core PM1995 ]+ ∆ [UI/NOA] = 0.223 - 0.008 - 0.052 = 0.163 Quantum increased RNOA in 1995 by 16.28%. This was due to an increase in core profit margins of 3.2%. Indeed, turnover decreased slightly to reduce RNOA, and an increase in unusual charges also decreased the operating profitability. A similar calculation can be done for 1996: ∆ RNOA 1996 = -0.170 – 0.028 – 0.073 = -0.271 The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 51 RNOA in 1996 was damaged by a decrease in profit margins, a deterioration of turnovers and an increase in unusual charges. Students can dig further by finding the components of the profit margins and turnovers that produced these changes. E12.4 Raising Questions Regarding a Change in Income: Boeing Questions are prompted (and partially answered) by comparative reformulated statements. First reformulate. Then analyze as far as you can go, then list unanswered questions for investigation. Reformulated income statements Operating income, as reported Unusual items (special charges) Core operating income before tax Tax, as reported Tax on net interest (38%) Tax on operating income Tax on unusual items (38%) Tax on core operating income Core operating income after tax Unusual charges Tax on unusual items Unusual charges after tax  Net interest expense Tax on net interest  Net interest after tax Net income 1998 1997 1996 1,567 0 1,567 (256) 1,400 1,144 2,485 0 2,485 277 65 342 0 342 (163) 32 (131) 532 401 662 3 665 0 665 1,225 743 1,820 0 0 0 1,400 532 868 170 65 105 85 32 53 5 2 3 1,120 (178) 1,818 0  p. 52 Solutions Manual to accompany Financial Statement Analysis and Security Valuation Analysis Sales growth Core operating income growth (after tax) Operating cost ratio General and administrative expenditures R & D expense ratio Core income profit margin 1998 22.60% 64.90% 90.00% 3.50% 3.40% 2.20% 1997 29.20% -59.20% 88.70% 4.80% 4.20% 1.60% 1996 82.90% 5.10% 4.60% 5.10% Questions Raised 1. Will sales growth continue to decline? 2. Why did core operating income grow at 64.9% in 1998 while sales grew at only 22.6%. a) Was the growth in core operating income in 1998 due to unusually low income (before special change) in 1997? Why was 1997 lower than 1996?  b) Why did the general administrative expense ratio decline in 1998? Is this temporary or does it indicate permanent cost (efficiencies?). c) Why did the R&D expense ratio decline in 1998? Is the firm cutting back  on R&D in detriment to future sales? 3. The operating cost ratio is increasing. Will this continue (and damage  profitability?) Questions Answered The increase in core operating profit margins in 1998 over 1997 was due to reduction in general and administrative expenses and R&D costs as a percentage of sales. With the growth in sales, core operating income increased by 64.9%. The reduction in core operating margins in 1998 over 1996 was due to a large increase in the operating The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 53 cost ratio. Even with much higher sales in 1998, operating costs yielded a lower core operating income. Clearly we need more detail to get at the reasons for the changes in expenses. With the limited information in the statement, significant questions arise about future profitability. Critical Questions • Can Boeing get its operating costs down? • Can Boeing maintain the lower 1998 ratios for other costs? • What is Boeing's R&D strategy? • What is the sales outlook?  p. 54 Solutions Manual to accompany Financial Statement Analysis and Security Valuation E12.5 Explaining Changes in Income: US Airways First prepare the reformulated income statements to distinguish core operating income from sales, other core income, unusual items and net financial expenses: 1998 1997 Core o perating revenues 8,688 8,514 Core operating expenses Pers onnel cos ts A viation fuel Commis s ions A ircraft rent Other rent and landing fees A ircraft maintenance Other s elling expens es Depreciation and amortization Other 3,101 623 519 440 417 448 342 318 1,466 3,179 805 595 475 420 451 346 401 1,258 Total operating expens es 7,674 7,930 Core operating income before tax Tax as reported 1,014 584 1 Tax ben efit o f deb t (38%) Tax on unus ual items Core ope rating income from sales Other core income: equity income in affiliates Core operating inco me Unus ual items Other income Gain on s ale of interests in affiliates 2 Less tax (38%) 364 (353) 43 1 56 (73) 408 606 1 607 (4) 0 (4) 1 Operating inco me 13 180 193 (3) (73) 604  Net finan cial expens es  Net in te res t 1 Tax effect (38%) Preferred dividends 3  Net in co me, ad jus te d (370) 954 30 984 1,104 112 148 43 69 6 56 92 64 75 529 120 156 948  Notes: 1. 2. 3. (a) Marginal tax rate is assumed to be 38%. Gains on sale of securities may be taxed at a lower capital gains tax rate. Net income and net interest are before capitalized interest. ($3million in 1998 and $13 million in 1997). Explaining increase in before-tax operating income from $584 million to $1,014 The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 55 million; standardizing for the increase in sales: 1998 1997 35.7 7.2 6.0 5.1 4.8 5.2 3.9 3.7 16.9 88.5 11.7 100.2 37.3 9.5 7.0 5.6 4.9 5.3 4.1 4.7 14.8 93.2 6.9 100.1 As a percentage of sales: Personnel costs Fuel Commissions Aircraft rent Other rent and landing fees Aircraft maintenance Other selling expenses Depreciation and amortization Other expenses Total core operating expenses Core PM before tax Operating expenses as a percentage of sales declined in 1998; the largest declines were in personnel costs, commissions and depreciation and amortization. But "other expenses" (for which there is limited information) increased.  Note that operating income, as reported, does not include all components of operating income. Gains on sale of shares in operating affiliates are also operating income. But reported operating income does identify core income (before tax). While core operating income increased before tax, it decreased after tax. The after-tax decrease was due to negative taxes in 1997 (see below). One could classify the negative taxes in 1997 as an unusual item. (b) The decline in net income (on an increase in before-tax operating income) can be explained as follows: 1. Transitory effect of negative taxes in 1997 2. Transitory gain on sale of shares of affiliates in 1997  p. 56 Solutions Manual to accompany Financial Statement Analysis and Security Valuation 3. Change in interest capitalization 4. Decrease in "other income" 5. Change in net financial expenses: a decrease in both after-tax net interest and  preferred dividends. (c) The negative taxes with positive income seems strange. This could be due to either: 1. Tax credits in 1997 from features of operations that are given credits; this is unlikely for an airline. 2. Changes in deferred taxes. The second reason was indeed the case. US Airways had accumulated tax  benefits from operating losses in the year prior to 1997. In 1997 it determined that it was "more likely than not" that it would be able to utilize these tax  benefits in the future. So it reduced its previous valuation allowance on deferred tax assets substantially. The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 57  The calculation of 1997 tax expense, relative to 1996, was as follows (in thousands): 1997 1996 Current provision: Federal State Total current provision $ 100,879 7,680 108,559 $ 6,423 3,000 9,423 Deferred provision: Federal State Total deferred provision (406,571) (54,651) (461,222) 2,686 2,686 Provision (credit) for income taxes $(352,663) $12,109 You see that taxes were assessed but the change in the deferred tax provision yielded negative taxes. The accounting for the deferred tax asset in the exercise shows the change in the valuation allowance. The change of $642 million should be treated as a transitory item. Accordingly, the tax on core operating income would be calculated as follows: (d) Tax on core operating income before unusual component (370) Change in valuation allowance 642 Core tax on operating income 272 1998 income is more indicative of future income: 1. It is the more recent income year. 2. It has fewer transitory items.  p. 58 Solutions Manual to accompany Financial Statement Analysis and Security Valuation E12.6 Analysis of Pension Expense: Boeing Co. Focus on the components of net periodic benefit cost (pension expense). The service cost is the implicit wage expense for pensions benefits for workers during 1998. The amortization of the transition asset of $86 million (from when pension accounting was first adopted) is transitory: the amortization will be complete by 2000. The amortization of prior service cost at $101 million can be accepted as a permanent feature. The actuarial loss of $5 million is transitory--it's due to changes in actuarial assumptions. Interest of $1,793 million on the pension liability is a recurring item. The expected return on plan assets is the suspect element. These are expected returns, not actual returns, so do not directly reflect the gains on plan assets. But, if the value of the plan assets has increased (due to appreciation of stocks in the plan's  portfolio) the expected dollar return on the assets has also increased. These returns (that reflect the success of the pension fund) are clearly affecting pension expense --enough, in this case, to yield a negative expense, that is, income. This does not reflect the cost of  employing people in operations: If the fund had been less successful--or the stock market drops in the future--this expense would be (considerably) higher. Here's a thought: What-if Boeing's pension fund had invested only in Boeing's shares? Then the income statement which the analyst is using to value Boeing's shares (to see if Boeing's shares are reasonably priced), would reflect the price of Boeing's shares. The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 59 There is another consideration lurking here. If actual gains of a fund exceed a certain level, the firm is required to bring actual gains into the pension expense (as well as expected returns), and that would affect pension expense further. There are some other firms where the gains on pension fund assets have had a significant effect on income: USX-US Steel, Lucent Technologies, Northroop Grumman, General Electric, and Westvaco.  p. 60 Solutions Manual to accompany Financial Statement Analysis and Security Valuation E12.7 Transitory Taxes: Kimberly-Clark Corporation (a) The tax expense is greater than before-tax income largely because the restructuring charges included in income do not receive a tax benefit at the statutory rate of 37.2% (see below). (There are some operating losses that reduced the effective tax rate below the statutory rate of 37.2% also.) From the tax footnote, the tax benefit of the restructuring charge is $360 million, so the tax rate for the benefit of the $1,440 million charges is 360/1,440 = 25%. In dollar  terms, that is a $176 million difference from receiving a tax deduction at a 35% rate. The firm may not receive the full benefit of the restructuring change at the statutory rate, for one or more of the following reasons. 1. Some restructuring costs may not be deductible. 2. Restructuring may occur in countries where the tax rate is lower than in the U.S. or where the tax rules for loss carry forwards affect the deferred tax valuation allowance (the likelihood that there will not be a benefit from the loss carry forward). 3. The firm may have recapture taxes for depreciation overcharged on the restructured operations and may have capital gains taxes. The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 61 (b) The reformulated statement: Net sales Cost of products sold $13,788.6 8,828.1 Gross profit  Advertising, promotion and selling expenses Research expense General expense Sustainables operating income from sales before tax Tax as reported Tas benefits of debt (37.2%) 1 Tax benefit of restructuring 2 Sustainable operating income after tax  Notes: 1. 4,960.5 2,496.5 207.2 603.8 1,653.0 153.5 91.3 360.0 604.8 1,048.2 The tax rate is calculated as follows: U.S. statutory rate State rate (from footnote) 35.0% 34.2/1,554.4 2.2 37.2% 2. (c) From tax footnote Effective tax rate on core operating income = = 604.8 1653.0 36.6% (d) There are two frustrations here: 1. There is a large "other income" of $136.9 million. Is this recurring or a one-time item? What is it? 2. Equity income of $113.3 can't be analyzed without the accounts of the subsidiary firms.  p. 62 Solutions Manual to accompany Financial Statement Analysis and Security Valuation E12.8 Analysis of Effects of Operating Leverage: US Airways (a) The fixed and variable operating cost breakdown is: Variable cost (VC) Fixed cost (FC) $3,636 million 4,038 $7,674 million One measure of operating leverage is FC = 1.11 VC Another measure is OLEV = = = = (b) Contribution Margin Operating Income Sales - Variable Cost Operating Income 8,688 − 3,636 1,014 4.98 % change in core operating income = = = OLEV × (% change in sales) 4.98 × 1% 4.98% That is, operating income will increase 4.98% for an increase in sales by 1%. This can be proofed: 1% increase in sales Variable cost (at 41.9%) Contribution Margin $86.88 million 36.40 50.48 Additional contribution as a % of operating income = 50.48 = 4.98% 1,014 (c) Breakeven occurs at the point where sales = fixed costs + variable costs, or where contribution margin equals fixed costs. As fixed costs are $4,038 million, that point is Breakeven = 4,038/0.581 = $6,950 million of sales where 0.581 is the contribution margin ratio (contribution margin/sales). The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 63 E12.9 Analysis of Growth in Common Equity for a Firm with Constant Asset Turnover The ingredients:  Average CSE Growth in average CSE Growth in average NFO Growth in sales  Asset turnover (Sales/Average NOA) 2,000 4,560 301 0 902 3 1,999 4,259 3 As asset turnover is constant and average net financial obligations did not change from 1999 to 2000, the growth in CSE is explained solely by the growth in sales: Growth in CSE = Growth in sales × = = 1 ATO 902 3 301  p. 64 Solutions Manual to accompany Financial Statement Analysis and Security Valuation E12.10 Analysis of Growth in Residual Earnings: Kmart Corporation First calculate the growth in residual earnings to be analyzed. Residual earnings (RE) = Comprehensive Income - (0.10 + Ave. CSE) = 751 - (0.10 × RE1991 5,178) = 233.2 = 291 - (0.10 × 4,972) RE1990 = - 206.2 Change in RE1991 = 439.4 Residual earnings is driven by return on common equity (ROCE) and change in equity (assuming cost of capital remains unchanged). So analyze the change in ROCE and the change in common equity. A. Analyze change in ROCE 1. Calculate ROCE for each year: ROCE (comprehensive income/average CSE) 2. Calculate financial leverage (ave. NFO/ave. CSE) 1991 1990 14.50% 5.83% 0.733 0.725 3. Calculate RNOA and its components RNOA (OI/ave NOA) Core RNOA Unusual OI/NOA PM (OI/Sales) Core PM (core OI/Sales) Ass et turnover (ATO) 11.21% 11.21% 0% 3.10% 3.10% 3.62 6.05% 10.83% -4.78% 1.74% 3.11% 3.49 4. Explain change in RNOA of 5.16%. ∆ RNOA1991 = [∆ CorePM1991xATO1990] + [∆ ATO1991 × Core PM1991] + ∆ [UI/NOA] The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 65 = [-0.01 × 3.49] + [0.13 × 3.10] + 4.78 (allow for rounding error) 5.16% The increase of 5.16% in the RNOA for 1996 was largely due to the absence of  unusual charges, but an increase in the asset turnover also added 0.4% to RNOA. Core operating profit margins had little effect on the RNOA. Further detail in the balance sheet and income statement would explain how components in the core PM and ATO changed. 5. Calculate net borrowing cost and SPREAD  Net borrowing cost (NBC=NFE/av.NFO) 1991 6.72% 1990 6.32% SPREAD (RNOA - NBC) 4.49% -0.27% 6. Explain change in ROCE ROCE = RNOA + [FLEV × SPREAD] ROCE, 1991 = 11.21% + [0.733 × 4.49%] = 11.21% + 3.29% = 14.50% ROCE, 1990 = 6.05% + [0.725 × (-0.27%)] = 5.85% ∆ = ROCE1991 ∆ RNOA1991 + [∆ SPREAD1991 × FLEV1990] + [∆ FLEV1991 × SPREAD1991] = 5.16 + [4.76% × 0.725] + [0.008 × 4.49%] = 8.65% As financial leverage (FLEV) did not change much, the change in ROCE can be explained approximately by ∆ ROCE1991 = ∆ RNOA1991 × [1+ Average FLEV1991] ∆ ROCE1991 = 5.16% × [1+0.733]  p. 66 Solutions Manual to accompany Financial Statement Analysis and Security Valuation = B. 8.94% Analyze change in Equity Change in average common equity (CSE) is $206 million ∆ 1  = ∆ Sales× − ∆ NFO  ATO   CSE = 32,452 3.62 − 29,898 3.49 − 188 = 210 (allow for rounding error)  OR, ∆CSE 1991 = ∆Sales1991 ×     1 1 + ∆ × Sales   1991  − ∆ NFO ATO 1990   ATO 1991  = 2,254 − [ 0.0103 × 32,452] − 188 3.49 = 210 Sales increased by $2,554 million requiring additional investment, in net operating assets of $394 million, allowing for a change in the asset turnover from 3.49 to 3.62. But $188 million in NOA was financed by debt, leaving $206 million to be financed with growth in common equity. C. Bringing change in ROCE and change in CSE together to explain the change in residual earnings ∆ RE1991= [(∆ ROCE - 0.10) × CSE1990] + {∆ CSE1991 × (ROCE1991 - 0.10)] = (8.67% × 4,972) × (209 × 4.50%) = 440 The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 67  E12.11. P/E, P/B, and Return on Common Equity: Hilton Hotels (a) If ROCE is abnormally high, the P/E will be low. P/E is based on forecasts of future residual earnings (that are driven by future ROCE) relative to current residual earnings (that are driven by current ROCE). A decline in residual earnings is expected (and a low P/E results) if ROCE is temporarily higher than expected in the future. (b) For the same reason, if an ROCE of 4.8% for 1996 is considered low, P/E will be high. At a P/B ratio of 2.1, the market expects ROCE above the cost of capital in the future. For any reasonable guess at the cost of  capital, 4.8% is below it, and the market sees ROCE increasing. (c) 1994: cell A 1995: cell A 1996: cell A In all three years the market sees positive residual earnings in the future (ROCE above the cost of capital) and residual earnings increasing. (d) Over the three years, 1994-96, Hilton was earning an average ROCE of  under 10%. The market was pricing the equity at over two times book  value. So the market was (implicitly) expecting higher ROCE in the future. If the higher ROCE was not realized, the price should fall. An ROCE of 10% indicates that the firm should sell at about book   p. 68 Solutions Manual to accompany Financial Statement Analysis and Security Valuation  Minicases M12.1 A Study in Value Creation: Dell Computer Corporation Preliminaries Share price, March 25, 1999 Dividends Change in per-share value, 1993-1999 (6 years) Eps, February 1, 1999 fiscal year Bps (on 2,543 million shares) 38.00 0.00 693.70% 0.58 0.91 P/E (trailing) 65.50 P/B P/E for computer stocks 41.80 43.00 P/E for S&P 500 30.20 Beta 1.70 CAPM cost of capital (with equity risk premium of 6%) 15.60% Price chart: www.bigcharts.com These numbers indicate very high price appreciation to P/E and P/B levels that are also considered very high. The case seeks to understand, from the financial statements, the fundamentals that drove the value appreciation. How does value created show up in financial statements? The solution here benchmarks Dell against numbers for Compaq, Gateway 2000 and Hewlett Packard. Working the Case The case solution is under the following headings: I. II. III. IV. V. VI. VII. Reformulation of the Financial Statements Analysis of the Reformulated Statement of Shareholders’ Equity Analysis of the Reformulated Balance Sheet Analysis of Profit Margins Analysis of Turnovers Cash Flow Analysis Summary of the Value Creation The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 69 I. To set up for analysis, reformulate the financial statements Reformulated Statements of Common Stockholders’ Equity Common Stock (1) Balance, 1992 Net transactions with owners Net income Currency translation loss Balance, 1993 (2) Net transactions with owners Net income Currency translation loss Unrealized gain on financial items Preferred dividends Balance, 1994 (3) Net transactions with owners Net income Currency translation gain Unrealized loss on financial items Preferred dividends Balance, 1995 (4) Net transactions with owners Net income Unrealized gain on financial items Preferred dividends Balance, 1996 (5) Net transactions with owners Net income (6) Other income Balance, 1997 Net transactions with owners Net income (6) Other income Balance, 1998 (3) Net transactions with owners Net income Other income Balance, 1999 Comprehensive Income 166 108 Total 274 12 102 (19) 178 83 191 369 22 (36) (5) 3 (2) 200 (40) 151 351 38 149 9 (6) (9) 238 143 294 532 173 272 3 (13) 411 262 556 967 (696) 518 17 (285) 535 1,091 806 (443) 944 (14) (728) 930 2,021 1,293 (431) 1,460 (1 ) (1,159) 1,459 3,480 2,321 This reformulation is before identification of hidden dirty surplus items: see later   p. 70 Solutions Manual to accompany Financial Statement Analysis and Security Valuation  Notes: 1. Preferred stock is excluded from the statement and treated as a financial obligation in the reformulated balance sheet. 2. Many of the stock issuances from fiscal 1994 onwards are to employees under  employee compensation plans. The accounting does not recognize the implied compensation expense for stock option plans but does recognize the tax benefit (in common stock in excess of par). The tax benefits, like the implied compensation expense, is part of comprehensive income. See the discussion later  for estimates. 3. The charge in the “other” column against share issues in the published statements is deferred compensation from issuing shares at less than market value under an employee stock purchase plan. It is really a deferred charge (part of NOA) but, as it is small, it is netted against common stock, along with subsequent amortizations in the “other” column. 4. A loss (equal to the difference between the market price and conversion price) in the preferred stock conversions to common in 1996 and 1997 should be recognized as a financing expense in comprehensive income. The market price of  the common at the date of conversion is needed for this calculation. See discussion later. 5. Put option transactions are treated as equity transactions. See discussions later on the analysis of the statement of shareholders’ equity. The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 71 6. Other income is not identified in 1997-99. It is probably foreign currency translation gains and losses and unrealized gains on financial assets. marketable securities are financial items.  p. 72 Solutions Manual to accompany Financial Statement Analysis and Security Valuation All Reformulated Balance Sheets 1999 1998 1997 1996 1995 1994 1993 20 2,124 (30) 2,094 273 137 775 (252) 523 669 3,716 2,397 1,298 237 112 4,044 (328) 500 2,661 (512) 20 1,514 (28) 1,486 233 106 509 (167) 342 257 2,444 1,643 1,054 225 36 2,958 (514) 300 1,524 (17) 15 755 (29) 726 429 67 292 (113) 179 101 1,517 466 473 116 7 1,062 455 40 591 (113) 10 564 (26) 538 293 78 208 (91) 117 41 1,077 403 349 68 9 829 248 33 484 (113) 3 437 (26) 411 220 64 152 (65) 87 21 806 283 255 10 70 22 841 295 199 31 569 237 0 334 (100) 16 510 331 5 81 (48) Net Financial Assets ______ 2,649 _____ 1,807 15 934 (31) 903 251 133 374 (139) 235 119 1.656 1,040 618 219 13 1,890 (234) 100 1,237 (18) (279) _____ 1,040 (6) 512 (120) 284 (120) 114 Common Shareholders’ Equity $2,321 1,293 806 967 532 351 (1) Cash Accounts receivable (gross) Allowance for bad debts Accounts receivable (net) Inventories (FIFO) Deferred tax assets Property, plant and equipment (gross) Accumulated depreciation PPE, net Other assets Operating Assets Accounts payable Accrued and other liabilities Deferred warranty revenue Other liabilities Operating liabilities Net Operating Assets Cash equivalents (2) Marketable securities Debt Put options Preferred stock 374 303 62 ____   38 369  Notes: (1) Cash is allocated between operating and financing assets. (2) Marketable securities are all debt (footnotes) The Analysis of Growth and Sustainable Earnings – Chapter 12 p.  73 Reformulated Income Statements Cost of revenue 1999 $18,243 14,137 1998 $12,327 9,605 1997 $7,759 6,093 1996 $5,296 4,229 1995 $3,475 2,737 1994 $2,873 2,440 1993 $2,014 1,565 Gross margin 4,106 2,722 1,666 1,067 738 433 449 1,589 199 272 2,060 2,046 624 13 611 1,435 (1) 1,434 1,065 137 204 1,406 1,316 424 18 406 910 (14) 896 739 87 126 952 714 216 12 204 510 4 514 512 83 95 690 377 111 2 109 268 _____ 268 361 63 65 489 249 64 (13) 77 172 9 181 346 77 49 472 (39) (3) 0 (3) (36) (5) (41) 208 60 42 310 139 41 1 40 99 (19) 80 38 (13) 25 ______ 25 _ 52 (18) 34 ______ 34 _ 33 (12) 21 ______ 21 _ 6 (2) 4 (13) (9) 3 (36) 13 (23) (9) (32) (6) 0 0 0 (2) (2) 3 4 1 3 _____   3 0 Net revenue Core operating expenses: General and administrative (1) Advertising Research, development and engineering Total core operating expenses Core operating income before tax Tax as reported Tax on financial income Tax on operating income Core operating income after tax (2) Unusual items Operating income (3) Net interest income (4) Tax on interest income (.35) Preferred dividends Core net financial income (5) Unrealized financial gains Reformulated Income Statements Cost of revenue 1999 $18,243 14,137 1998 $12,327 9,605 1997 $7,759 6,093 1996 $5,296 4,229 1995 $3,475 2,737 1994 $2,873 2,440 1993 $2,014 1,565 Gross margin 4,106 2,722 1,666 1,067 738 433 449 1,589 199 272 2,060 2,046 624 13 611 1,435 (1) 1,434 1,065 137 204 1,406 1,316 424 18 406 910 (14) 896 739 87 126 952 714 216 12 204 510 4 514 512 83 95 690 377 111 2 109 268 _____ 268 361 63 65 489 249 64 (13) 77 172 9 181 346 77 49 472 (39) (3) 0 (3) (36) (5) (41) 208 60 42 310 139 41 1 40 99 (19) 80 38 (13) 25 ______ 25 _______ 25 1,459 52 (18) 34 ______ 34 ______ 34 930 33 (12) 21 ______ 21 ______ 21 535 6 (2) 4 (13) (9) 3 (6) 262 (36) 13 (23) (9) (32) (6) (38) 143 0 0 0 (2) (2) 3 1 (40) 4 1 3 _____   3 0 3 83 Net revenue Core operating expenses: General and administrative (1) Advertising Research, development and engineering Total core operating expenses Core operating income before tax Tax as reported Tax on financial income Tax on operating income Core operating income after tax (2) Unusual items Operating income (3) Net interest income (4) Tax on interest income (.35) Preferred dividends Core net financial income (5) Unrealized financial gains Net financial income Comprehensive income  Notes: (1) Given in Note 1 to 10-K  (2) Unusual items are foreign currency translation gains and losses plus an extraordinary charge of $13 million in 1997. All are reported after tax. Dirty-surplus income from 1997 to 1999 is assumed to be translation losses (but could also be unrealize d losses on securities) (3) Other income is included here and assumed to be financial income (4) Dells marginal tax rate is 35%. (5) Not identified for 1997-99.  p. 74 Solutions Manual to accompany Financial Statement Analysis and Security Valuation II. Analysis of Reformulated Statements of Stockholders’ Equity The reformulated statement gives an improved picture of the evolution of shareholders' equity. The cumulative net cash paid in by shareholders is negative by the end of fiscal 1999 (and the effective cash dividend relative to cash contributed is large). The reformulated statement also shows clearly the equity increase from business activities through comprehensive income. Balance, 1992 Value added in comprehensive income, 1992 - 99 274 3,372 3,646 II. Analysis of Reformulated Statements of Stockholders’ Equity The reformulated statement gives an improved picture of the evolution of shareholders' equity. The cumulative net cash paid in by shareholders is negative by the end of fiscal 1999 (and the effective cash dividend relative to cash contributed is large). The reformulated statement also shows clearly the equity increase from business activities through comprehensive income. Balance, 1992 Value added in comprehensive income, 1992 - 99  Net dividend (in net share repurchases) 274 3,372 3,646 (1,325) Balance, 1999 2,321 The reformulated statement also reveals the ROCE for each year (equal to comprehensive income dividend  by average common equity): 1993 25.8% ROCE 1994 −11.1% 1995 32.4% 1996 34.9% 1997 60.3% 1998 88.6% 1999 80.8% From 1997 to 1999 these ROCE might be sensitive to the timing of the (large) stock repurchases during the year. The 10-K indicates that the repurchases are part of an on-going stock  repurchase program. These ROCE are before any hidden dirty-surplus items. For Dell there are four areas of  concern. 1. Preferred stock conversions to common shares in 1996 and 1997. The amount in 1997 is small, so is ignored. In 1996, 1.19 million preferred shares were converted into 10 million common shares plus a cash premium of $10 million dollars. The cash premium was treated as a preferred dividend so is accounted for in net income available to common (1996 10-K, Note 7). The loss on conversion, not recognized, is estimated as follows: The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 75 Estimated market price of 10 million of common shares on conversion Carrying value of preferred converted Loss on conversion $240 million 114 million 126 million (The estimated market price is based on the average price of common shares over the conversion period). The loss reduces 1996 comprehensive income (an implicit financing expense). 2. Granting in-the-money stock or stock options to employees requires a recognition of  deferred compensation: the difference between grant price and market price is deemed to  be compensation that is amortized over a service period. The amount to be amortized -deferred compensation -- and the amortizations go through the equity statement. The appropriate treatment, in a reformulation, is to treat the deferred compensation (in the “other” column in Dell’s equity statement) as an operating asset (like other deferred charges) and amortize it from there. Dell’s amounts are small, so both the deferred amounts and the amortizations have been netted against common stock. (The amortizations will still appear in the income statement as expen ses). 3. Put options to sell stocks to the firm at a pre-set price were sold in 1996. The appropriate clean-surplus accounting is to treat these as liabilities (to buy stock back at less than market price), as with the reclassification to liabilities in the balance sheet for 1997. Lapse of the option is a gain to current shareholders (financing income) and exercise is a loss. The $279 million in put option liability at the end of 1997 was reclassified as additional paid-in-capital in 1998 when the option lapsed. This amount is really a gain (to be included in comprehensive income) rather than an increase in equity from share transactions. However, restatement to comprehensive income does not affect operating activities, so the restatement is not made in the reformulated statements here. 4. Stock compensation. The amount of stock issued to employees below market price is wages expense. But, if the shares are issued on exercise of options, GAAP does not recognize the expense. The implicit wages expense for 1996-99 is calculated approximately (from the 10-K stock compensation footnote) as follows (in millions). 1996 1997  p. 76 Solutions Manual to accompany Financial Statement Analysis and Security Valuation 1998 1999 Shares issued on exercise of options Estimated average market value of shares at exercise Weighted average exercise value Compensation expense Estimated tax effect (at 35%) After-tax compensation expense 80 67 79 110 $78 21 57 20 $ 37 $112 26 86 30 $ 56 $537 60 477 167 $310 2,193 142 2,051 718 $1,333 The weighted-average exercise price is given in the 10-K footnote on benefit plans. It was $1.29  per-share in 1999, $0.76 per-share in 1998. The market value of shares at exercise is based in the per-share weighted exercise price for option grants during the year. This was $19.94 for  1999 and $ 6.80 for 1998. As options are granted at the money, this is an indication of average  prices over the year. But options might well have been exercised at different prices over the range of $11 to $38 for the year. After fiscal 1996, Dell reported the value of options at grant date in its footnotes as required by FASB Statement No. 123. The effect on pro forma earnings was as follows (in millions): Shares under grant Effect on pro forma earnings after tax 1996 1997 128 $6 171 $16 1998 86 $ 69 1999 60 $136 These amounts are considerably less than the expenses calculated (above) at exercise rather than grant date. The implicit stock compensation expense affects comprehensive income as follows: 1996 Stock compensation expense (after tax) Percentage of reported comprehensive income Revised comprehensive income 37 14.1% 225 1997 56 10.5% 479 1998 315 33.9% 615 1999 1,333 91.4% 126 The calculation of wages expense on exercise follows exercise-date accounting. The FASB method is grant-date accounting. A full liability accrual accounting would recognize option The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 77  value for all options in the form of a contingent liability, with settlement at exercise date. A corresponding deferred charge would be recognized and amortized to wages expense over a service period (so to match to revenues). Tax benefits from stock compensation are included in capital in excess of par. So, if one were to formally modify the statement of shareholders’ equity for stock compensation expense, the after-tax compensation would be subtracted from comprehensive income, but also the paid-in capital would be reduced by the amount of the tax benefit. Besides the stock option plan, Dell has an employee stock purchase plan under which employees may purchase shares at 85% of market value. This discount off market value is also a compensation expense which, under GAAP, is recognized as deferred compensation in the equity statement (and subsequently amortized to the income statement). See point 2 above. The cash tax benefit from employee stock plans is given (for the first time) in the 1999 cash flow statement.1 The amount of $ 444 million is less than the $718 million calculated above which might suggest that the assumed market value on exercise above is too high There is a question, however, as to what plans are tax deductible. 1 Some firms report this benefit as cash from operations, and some report it as cash from financing activities.  p. 78 Solutions Manual to accompany Financial Statement Analysis and Security Valuation III. Analysis of the Balance Sheet Average CSE Average NOA Average NFA Average OA Average OL Financial Leverage  FLEV =  NFO      CSE     1999 1998 1997 1996 1995 1994 1,807 (421) 2,228 3,080 3,501 1,050 (374) 1,424 2,050 2,424 887 111 776 1,587 1,476 750 352 398 1,297 945 442 243 199 942 699 360 284 76 824 540 −1.141 −1.398 −1.290 −.529 −.534 −.325 Large Large 13.30 2.68 2.88 1.90 −0.26 -.84 −0.34 −0.29 −0.63 −0.25 1.07 7.36 1.13 1.61 3.01 0.94 Operating Liability Leverage  OLLEV = OL       NOA     Some Comparisons, 1998-99: Financial Leverage – Compaq −Gateway 2000 −Hewlett Packard Operating Liability − Compaq Leverage −Gateway 2000 −Hewlett Packard  Note: Compaq’s 1999 results reflect merger with Digital Equipment; Hewlett Packard’s business is 4 5 computers and printers. The results for the comparison firms are for their fiscal year nearest to Dell’s. Compaq and Gateway have a December 31 year, Hewlett Packard has an October 31 year. The Analysis of Growth and Sustainable Earnings – Chapter 12 p.  79 Discussion: All four firms have negative financial leverage, but Dell is extreme. Its large holding of  financial assets, even after using a considerable amount in stock purchases, is a result of its cash generating utility. The significant feature of Dell is, however, its negative net operating assets. By stretching its payables and other accrued liabilities, and by keeping inventories and receivables down, Dell has been able to finance the business with the credit of trade creditors. This has meant that shareholders have not had to have their funds tied up in the business, creating value Discussion: All four firms have negative financial leverage, but Dell is extreme. Its large holding of  financial assets, even after using a considerable amount in stock purchases, is a result of its cash generating utility. The significant feature of Dell is, however, its negative net operating assets. By stretching its payables and other accrued liabilities, and by keeping inventories and receivables down, Dell has been able to finance the business with the credit of trade creditors. This has meant that shareholders have not had to have their funds tied up in the business, creating value for them. Indeed, shareholders are taking cash out while operating assets grow, with no need for  debt financing. Value creation indeed! These features are a result of management practices for keeping inventory low and  putting the burden on suppliers to carry inventory and provide credit.  Note that operating liability leverage can’t be calculated for Dell ( as NOA is negative) But it is high! The comparison firms also have high OLLEV (the typical number is more like 0.4). Gateway has imitated Dell’s practices but still has positive NOA.  p. 80 Solutions Manual to accompany Financial Statement Analysis and Security Valuation IV. Analysis of Profit Margins 1999 1998 1997 1996 1995 1994 1993 22.5% 22.1% 21.5% 20.1% 21.2% 15.1% 22.3% 8.8 1.0 1.5 8.6 1.1 1.7 9.5 1.1 1.6 9.7 1.6 1.8 10.4 1.8 1.9 12.0 2.7 1.7 10.3 3.0 2.1 Taxes/Sales Taxes/OI before tax 3.3 29.9 3.3 30.9 2.6 28.6 2.1 28.9 2.2 30.9 (0.1) − 2.0 28.8 Core profit margin before tax Core profit margin after tax Profit margin 11.2 7.9 7.9 10.7 7.4 7.3 9.2 6.6 6.6 7.1 5.0 5.1 7.2 4.9 5.2 (1.4) (1.3) (1.4) 6.9 4.9 4.0 Sales growth rate Core OI growth rate 48.0 57.7 58.9 78.4 46.5 90.3 52.4 55.8 21.0 − Compaq − Gateway 2000 − Hewlett Packard 31,169 7,468 47,061 24,584 6,294 42,895 20,009 5,035 38,420 16,675 3,676 31,519 − Compaq − Gateway 2000 − Hewlett Packard 26.8% 18.7 9.7% 22.9% 25.0% 11.6% 20.0% 37.0% 21.9% 26.1% − Compaq − Gateway 2000 − Hewlett Packard 23.1% 20.7% 31.8% 27.5% 17.1% 34.0% 25.8% 18.6% 33.6% 26.3% 16.5% 36.5% Gross margin ratio Selling and admin. expense ratio Advertising expense ratio R&D ratio Some comparisons: Sales Sales growth rates Gross margin ratio 42.7 −36.4 The Analysis of Growth and Sustainable Earnings – Chapter 12 p.  81  p. 82 Solutions Manual to accompany Financial Statement Analysis and Security Valuation 1999 14.9% 14.5% 14.0% 1998 11.1% 12.5% 14.1% 1997 11.7% 11.5% 14.3% 1996 11.8% 9.7% 15.2% 1.3% S&G expense ratio − Compaq − Gateway 2000 − Hewlett Packard Advertising expense ratio − Compaq − Gateway 2000 − Hewlett Packard 1.1% 0.9% 0.9% − − − − 2.6% 2.6% 2.6% 2.6% − Compaq − Gateway 2000 − Hewlett Packard 4.3% 3.3% 7.1% 7.2% 7.1% 7.3% − Compaq − Gateway 2000 − Hewlett Packard 1.9% 4.6% 4.7% 7.8% 3.3% 7.1% 6.6% 4.6% 6.9% 6.3% 4.5% 7.4% R&D ratio Core PM after tax − 3.5% − 3.3% − 1995 1994 1993 1999 14.9% 14.5% 14.0% 1998 11.1% 12.5% 14.1% 1997 11.7% 11.5% 14.3% 1996 11.8% 9.7% 15.2% 1.3% S&G expense ratio − Compaq − Gateway 2000 − Hewlett Packard Advertising expense ratio − Compaq − Gateway 2000 − Hewlett Packard 1.1% 0.9% 0.9% − − − − 2.6% 2.6% 2.6% 2.6% − Compaq − Gateway 2000 − Hewlett Packard 4.3% 3.3% 7.1% 7.2% 7.1% 7.3% − Compaq − Gateway 2000 − Hewlett Packard 1.9% 4.6% 4.7% 7.8% 3.3% 7.1% 6.6% 4.6% 6.9% 6.3% 4.5% 7.4% R&D ratio Core PM after tax − 3.5% − 1995 1994 1993 3.3% − The Analysis of Growth and Sustainable Earnings – Chapter 12 p.  83 Discussion: Dell’s growth in operating income is driven by sales growth at rates considerably above the other firms (and they have high growth rates). Dell’s gross margin rate is not as high as Compaq and HP, but this is more than made up for by sales growth. In addition Dell maintains lower SG&A expenses per dollar of sales and manages sales growth with relatively low advertising and R&D expenditures. Accordingly core  profit margins are higher than the comparable firms. Discussion: Dell’s growth in operating income is driven by sales growth at rates considerably above the other firms (and they have high growth rates). Dell’s gross margin rate is not as high as Compaq and HP, but this is more than made up for by sales growth. In addition Dell maintains lower SG&A expenses per dollar of sales and manages sales growth with relatively low advertising and R&D expenditures. Accordingly core  profit margins are higher than the comparable firms.  p. 84 Solutions Manual to accompany Financial Statement Analysis and Security Valuation V: Analysis of Turnovers Asset turnover (ATO) Accounts receivable turnover Inventory turnover PPE turnover Operating asset turnover Operating liability turnover 1999 1998 1997 1996 1995 1994 Large Large 69.9 15.1 14.3 10.1 10.2 50.6 42.3 6.0 5.1 9.5 22.8 37.5 4.9 5.3 8.4 14.7 35.8 4.1 5.6 7.3 13.5 34.1 3.7 5.0 7.3 11.0 36.4 3.5 5.3 10.2 72.1 42.1 5.9 5.2 Some comparisons: ATO − Compaq − Gateway 2000 − Hewlett Packard 4.1 21.4 4.5 9.2 19.7 3.8 6.0 13.1 4.3 A/R turnover  − Compaq − Gateway 2000 − Hewlett Packard 17.5 12.9 7.6 7.4 13.1 5.6 6.3 11.8 6.1 Inventory turnover  − Compaq − Gateway 2000 − Hewlett Packard 28.4 32.9 17.3 23.9 6.5 12.1 19.6 8.0 PPE turnover  − Compaq − Gateway 2000 − Hewlett Packard 12.8 92.9 7.4 13.2 21.8 7.2 20.9 24.3 18.4 − Compaq − Gateway 2000 − Hewlett Packard 2.0 4.8 2.1 3.1 4.9 2.0 2.9 4.8 2.6 Operating liability turnover  − Compaq − Gateway 2000 − Hewlett Packard 3.8 5.6 3.8 4.9 6.5 4.1 5.7 7.3 6.5 Operating asset turnover  7.4 The Analysis of Growth and Sustainable Earnings – Chapter 12 p.  85 Discussion: ATO can’t be calculated for Dell because it is employing negative net operating assets. But individual turnovers are revealing. Compare those for inventory and PPE with the other  firms. And note the operating liability turnover. Dell keeps inventories low and creditors long. Again, Gateway’s imitation of Dell shows up in its ratios. Compaq was proceeding at the time to become more like Dell in its computer operations, although it was digesting its merger  with Digital equipment to become somewhat of a different company.  Note that a considerable portion of Dell’s value is being surrendered to employees in the exercise of stock options, particularly in 1999. Discussion: ATO can’t be calculated for Dell because it is employing negative net operating assets. But individual turnovers are revealing. Compare those for inventory and PPE with the other  firms. And note the operating liability turnover. Dell keeps inventories low and creditors long. Again, Gateway’s imitation of Dell shows up in its ratios. Compaq was proceeding at the time to become more like Dell in its computer operations, although it was digesting its merger  with Digital equipment to become somewhat of a different company.  Note that a considerable portion of Dell’s value is being surrendered to employees in the exercise of stock options, particularly in 1999.  p. 86 Solutions Manual to accompany Financial Statement Analysis and Security Valuation VI. Cash Flow Analysis 1999 1998 1997 1996 1995 1994 1,434 186 1,248 896 (280) 1,176 514 (689) 1,203 268 207 61 181 11 170 (41) (94) 53 (1) Receipts from net financial income (after tax) 25 1,273 34 1,210 21 1,224 (9) 52 (32) 138 (2) 51 (2) Net cash to shareholders 1,306 898 438 (48) (35) (22) (33) 312 786 100 173 73 Operating income ∆ Net operating assets Free cash flow Investment in net financial assets  _________________________________   Notes: (1) Accrual number from income statement (cash number not available) (2) From cash flow statement. The numbers do not agree with the net transactions with shareholders in the statement of shareholders’ equity  because of (presumed) receivables and payables with shareholders and points 2, 3 and 5 in the notes to the reformulated statement of shareholders’ equity. The Analysis of Growth and Sustainable Earnings – Chapter 12 p.  87  This format follows the treasurer’s rule: C − I + net cash interest received − net dividend = cash invested in financial assets. Working with the Statement of Cash Flows, free cash flow is calculated as follows: 1999 1998 1997 1996 1995 1994 Reported cash from operations  Net interest after tax 2, 436 25 2,411 1,592 34 1,558 1,362 21 1,341 175 4 171 243 (23) 266 113 0 113 Capital expenditures Free cash flow 296 2,115 187 1,371 114 1,227 101 70 64 202 48 65 These numbers are a little higher than those calculated above, more so in 1998 and 1999. In 1999 the GAAP Statement includes $444 million in tax benefits of employee share plans. These were not included in operating income in the reformulated income statement. Also there are the questions about the reporting of interest income raised earlier. There may also be receivables for share issues. The disclosure is frustrating. See the solutions to Minicase M.1 in Chapter 9. This format follows the treasurer’s rule: C − I + net cash interest received − net dividend = cash invested in financial assets. Working with the Statement of Cash Flows, free cash flow is calculated as follows: 1999 1998 1997 1996 1995 1994 Reported cash from operations  Net interest after tax 2, 436 25 2,411 1,592 34 1,558 1,362 21 1,341 175 4 171 243 (23) 266 113 0 113 Capital expenditures Free cash flow 296 2,115 187 1,371 114 1,227 101 70 64 202 48 65 These numbers are a little higher than those calculated above, more so in 1998 and 1999. In 1999 the GAAP Statement includes $444 million in tax benefits of employee share plans. These were not included in operating income in the reformulated income statement. Also there are the questions about the reporting of interest income raised earlier. There may also be receivables for share issues. The disclosure is frustrating. See the solutions to Minicase M.1 in Chapter 9.  p. 88 Solutions Manual to accompany Financial Statement Analysis and Security Valuation In any case, the picture is clear. Dell has generated considerable free cash flow from operations through its high profitability and low investment in net operating assets. This has  been used to repurchase shares with the remainder invested in financial assets. Dell has a “cash  problem” in the sense that it generates more cash than it can use in operations. But note that a considerable part of the value generated is going to employees. If  the implied compensation expense for 1999 had been treated as an as-if cash transaction (cash wages) the free cash flow would have been substantially different. In any case, the picture is clear. Dell has generated considerable free cash flow from operations through its high profitability and low investment in net operating assets. This has  been used to repurchase shares with the remainder invested in financial assets. Dell has a “cash  problem” in the sense that it generates more cash than it can use in operations. But note that a considerable part of the value generated is going to employees. If  the implied compensation expense for 1999 had been treated as an as-if cash transaction (cash wages) the free cash flow would have been substantially different. The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 89 VII. Summary of the Value Creation Value creation is evidenced by growth in residual earnings: 1999 1,459 1,807 1,178 54% Comprehensive income Average common equity RE (0.156) Growth in RE 1998 930 1,050 766 93% 1997 535 887 397 174% 1996 242 750 145 96% 1995 143 442 74 1994 (40) 360 (96) − − The growth in RE has been generated by the drivers identified in the analysis above. In Part III of the book you will see that value generation is best analyzed by focusing on operations (and residual operating income).  p. 90 Solutions Manual to accompany Financial Statement Analysis and Security Valuation Analysis for 2001 and 2002 Dell’s history can be continued with an analysis of the 2001 and 2002 statements, most of  which are available in Exhibit 2.1 in Chapter 2. Here are the reformulated statements for  those years. Cash flow computations are in the solution to case M10.1 in Chapter 10. Reformulated Statement of Stockholders’ Equity (in millions of dollars) $5,622 Balance, February 2, 2001 Transactions with shareholders: Sh i $ 853 Analysis for 2001 and 2002 Dell’s history can be continued with an analysis of the 2001 and 2002 statements, most of  which are available in Exhibit 2.1 in Chapter 2. Here are the reformulated statements for  those years. Cash flow computations are in the solution to case M10.1 in Chapter 10. Reformulated Statement of Stockholders’ Equity (in millions of dollars) $5,622 Balance, February 2, 2001 Transactions with shareholders: Share issues Share repurchases $ 853 3,003 (2,150) $1,246 (65) 2 39 1,222 Comprehensive income:  Net income Unrealized loss on investments Translation gain Unrealized gain on derivatives Balance, February 1,2002 4,694 The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 91 Reformulated Balance Sheets (in millions of dollars) 2002 2001 20 20 2,269 2,424 278 400 1,416 1,467 PPE 826 996 Other 459 530 5,268 5,837 Cash Accounts receivable Inventories Other current assets Operating assets Accounts payable 5,075 4,286 Accrued and other 2,444 2,492 Other long-term 802 8,321 761 7,539 Net operating assets (NOA) (3,053) (1,702) Net financial assets (NFA) 7,747 7,324 Common shareholders' equity (CSE) 4,694 5,622  p. 92 Solutions Manual to accompany Financial Statement Analysis and Security Valuation Reformulated Income Statement, 2002 Net revenue Cost of revenue Gross margin Core operating expenses: General and administrative Research, development and engineering Total core operating expenses Core operating income before tax Tax as reported Tax on unual items Tax on financial income Tax on operating income Core operating income after tax Unusual items Special charge Tax benefit of special charge Effect of change in accounting Translation gain Gain on derivative investments Operating income  Net investment income Tax on interest income (35%) Core net financial income Unrealized losses on debt investments Net financial expense Comprehensive income 2002 31,168 25,661 2001 31,888 25,445 5,507 6,443 2,784 452 3,236 2,271 485 169 20 674 1,597 3,193 482 3,675 2,768 958 37 (186) 809 1,959 (482) 169 (313) 2 39 (272) 1,325 (105) 37 (68) (59) 4 -- (123) 1,836 (58) 20 (38) (65) 531 (186) 345 (475) (103) 1,222 (130) 1,706 The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 93 M12.2. Analysis of Growth in Core Operating Income During the 1990s: International Business Machines This case completes the analysis of IBM’s operating income begun in the Chapter. Students will be surprised to see how different the growth picture looks once the unsustainable elements are stripped out. It appears that each year IBM found another way to give the appearance of growth and so perpetuate its reputation as a growth firm. Up to 1990, IBM was known for its non-aggressive accounting. During the 1990s, the firm developed a different reputation and became an (otherwise solid) firm whose accounting quality was called into question as the bubble burst in the early 2000s. As there is considerable material on IBM in Chapter 12, the instructor may wish to teach this chapter with this case as a centerpiece. The case solution comes in two parts. The first gives the complete answer to the case question. The second extends the discussion to other quality of earnings issues that  present themselves in the case material. The Restated Income Statements Here are the restated income statements that the case question asked for. Focus on the core operating income and compare it to the operating income reported by IBM.  p. 94 Solutions Manual to accompany Financial Statement Analysis and Security Valuation INTERNATIONAL BUSINESS MACHINES CORPORATION Identification of Core Income Before Tax 2000 1999 1998 1997 1996 Revenue Cost of revenue 88,396 55,972 87,548 55,619 81,667 50,795 78,508 47,899 75,947 45,408 Gross profit 32,424 31,929 30,872 30,609 30,539 Advertising Pension service expense Interest on pension liability General and administrative expense Research and development Core operating expenses 1,746 891 3,787 15,951 5,151 27,526 1,758 915 3,686 18,561 5,273 30,193 1,681 838 3,474 16,147 5,046 27,186 1,708 590 3,397 15,921 4,877 26,493 1,569 600 3,427 17,229 5,089 27,914 4,898 1,736 3,686 4,116 2,625 5,944 792 -6,736 5,400 4,791 -10,191 4,862 261 355 5,478 4,364 273 345 4,982 4,180 300 1,491 5,971 Operating income before tax 11,634 11,927 9,164 9,098 8,596 Percentage of revenue: Reported operating income Reformulated core operating income Advertising R&D General and Administrative Pension expense (incl. interest) 13.2% 5.5% 1.98% 5.83% 18.0% 5.3% 13.6% 2.0% 2.01% 6.02% 21.2% 5.3% 11.2% 4.5% 2.06% 6.18% 19.8% 5.3% 11.6% 5.2% 2.18% 6.21% 20.3% 5.1% 11.3% 3.5% 2.07% 6.70% 22.7% 5.3% Growth in reported operating income (before tax) -2.5% Growth in core operating income before tax 182.1% 30.2% -52.9% 0.7% -10.4% 5.8% 56.8% Core operating income  Non-core items: Pension gains Gains on asset sales Bleed back of restructuring charge --- The following adjustment have been made to develop this reformulated statement: 1. Added information. Advertising expense has been retrieved from the footnotes, given in the case for 1997-1999 and extracted from the 10-K for other years. These are worth investigating because firms can reduce advertising expenses to The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 95 increase income temporarily, with detrimental effects to future income. IBM’s advertising, as a percentage of sales, is fairly constant, however. 2. Treatment of net pension expense. Net pension expense goes into the income statement, but includes expected returns on running the pension fund (that are not income from core business). These must be stripped out. (See Box 12.5 in the chapter.) Information in the pension footnote W is broken out as follows: a. Pension service cost is a core operating expense, the equivalent of wages expense  b. Amortizations for past service costs, etc., given in footnote W are netted into pension service cost. There is an argument to classify them –   particularly the actuarial gains component (unidentified) due to changes in estimates -- as unusual income. However, the income and expenses are smoothed over many periods, making them repetitive and predictable. The net effect of the amortizations is positive, contributing between 93 million and 196 million to income each period. c. Interest expense on the pension liability looks as if it should be a financing expense; however, it is the interest on an operating liability that must be  paid to employees at retirement over and above service cost, to compensate them for the delay in payment. In this way, pension expense is like any other operating liability: the supplier charges more (in implicit interest) if payment is delayed.  p. 96 Solutions Manual to accompany Financial Statement Analysis and Security Valuation d. The gains on running the pension fund (expected returns on plan assets) are identified outside of core income. These gains are from running the  pension fund, not the core business. 3. Gains on assets sales are retrieved from the cash flow statement. See Box 12.7 on IBM’S asset sales. 4. Effects of restructuring charges are retrieved from the cash flow statement. See Box 12.6 on IBM’s restructuring charges. 5. The net amount of these adjustments has been added to SG&A expense. Some of  the pension costs may be in cost of revenue and R&D, as may some of the effects of restructuring charges, but there is no information for the b reakout of the numbers. 6. The R&D line is as reported. R&D expense needs to be investigated because firms can reduce R&D to increase reported income (and damage future income). IBM’s R&D as a percentage of sales is reasonably constant, though one might question the lower R&D in 2000; with a drop of 0.2 % of sales, this amounts to an added $177 million to income. Some observations: • Core operating income as a percentage of sales is considerably lower than reported operating income to sales. • We have an example of smoothing here. The reported income gives a picture of  relatively smooth growth. Not so the core numbers. In 1999, the large gain on assets sale of $4.791 billion (that was credited to SG&A expenses) covered up a large drop in core operating income. The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 97   Note: The reformulation above does not include the cost of employee stock options.  Extending the Quality of Earnings Analysis The presentation of the case can be completed at this point. However, there are additional earnings quality concerns that arise from inspection of the statements and the footnotes. These issues can be covered here or when looking at the quality of earnings material in Chapter 17. The following lays out a step-by-step approach to analyzing the quality of the reported earnings numbers. The analysis raises red flags for which explanations must be found. The reformulated statements above will supply some but not all of the explanations. For many flags, there are often legitimate explanations. Start with the income statement to see if there are any quality flags there that suggest that further investigation is required. Then analyze the accruals in the cash flow statement. Finally, dig into the footnotes for further detail (and some answers). The analysis below refers mainly to 1999 statements (and comparative 1998) statements for  which there are footnotes, but can be extended to the other years. Income Statement Analysis (i) Compare growth in operating income (before tax) with growth in sales 1999 1998 Growth in sales 7.2% 4.0% Growth in OI before tax 30.2% 0.7% Flag: There is a large growth in operating income in 1999 on only a 7.2% growth in sales. Compare with 1998. Is there something unusual in 1999 expenses? The reformulated statements above supply an answer (with the asset gains credited to SG&A a big item).  p. 98 Solutions Manual to accompany Financial Statement Analysis and Security Valuation (ii) Track margins and expense ratios 1999 1998 1997 Gross Margin Ratio 36.5% 37.8% 39.0% SG&A/sales 16.8% 20.4% 21.2% R&D/sales 6.0% 6.2% 6.2% Operating PM before tax 13.6% 11.2% 11.6% Flag: There is a higher profit margin in 1999 on a lower gross margin. SG&A is considerably lower as a percentage of sales. Why? Answer above. (iii) Look at effective tax rates Tax reported Tax on net interest expense (37%) Effective tax rate on OI 1999 1998 1997 4,045 2,712 2,934 63 46 26 4,108 2,758 2,960 34.4 30.1 32.5 Flag: Effective tax rates are low relative to statutory rate (35% for federal taxes  plus State taxes), especially in 1998 and 1997. Why? Will these rates revert towards the statutory rate (as they appear to be doing in 1999)? Cash Flow Statement Analysis (i) Compare cash flow from operations with net income. In all years, cash flow from operations is higher than net income, so there is not, on the face of it, a great concern. But, when one considers that depreciation is considerable, a considerable amount of income is coming from accruals other than depreciation. The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 99 (ii) Inspect accruals that explain the difference between net income and cash from operations: Flag: Why has amortization of software costs declined (by over 50%) over  the years while investment in software (in the investment section o f  the statement) increased? Flag: Operating income for 1996 to 1998 was boosted by reversals of earlier  restructuring changes (by $355 million in 1998, $445 million in 1997, and $1,491 million in 1996). This is "bleeding back" of previous overreserving. The restructurings were as far back as 1991 (see Footnote M) and the credits to income here have nothing to do with current operations. The core income statement separates out these effects. Flag: Why is depreciation higher (as a percentage of sales) in 1999? Unlike 1998 and 1997, depreciation is higher than capital expenditures (in the cash investment section of the statement). Why is depreciation lower  in 2000? Flag: Income increased by $713 million in 1999 and $606 million in 1998 from changes in deferred taxes. Why? Flag: Income includes gains on asset sales (within a particularly large one of  $4.8 billion in 1999). These did not appear separately on the income statement so must be aggregated there with other operating items. Operating income is thus not a good measure of income from current operations, as we have seen.  p. 100 Solutions Manual to accompany Financial Statement Analysis and Security Valuation Flag: There is a lower increase in net receivables in 1999 despite higher  sales growth than in 1998. There is also a higher increase in other  liabilities. Both reduce income. Flag: What is the large increase in other assets in 1997? Flag: Why the big increase in receivables (non-cash sales) in 2000. The increase is bigger than the increase in sales over 1997. Are receivables (and sales) of lower quality? The increase in receivables in 1997 is also bigger than the growth in sales for that year. The coincidence, in 1999, of higher depreciation, lower changes in receivables and higher growth in other liabilities (all of which reduce income) with higher   profits from gains on disposition of assets raises the question as to whether the firm was decreasing income against the benefit of the gain in order to bleed it  back in the future. The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 101 Footnote Analysis  Footnote D The disposal gain in 1999 comes largely from the sale of IBM's Global Network  to AT&T. Although not indicated in the annual report, this gain was credited to SG&A expenses (as indicated in a 10-Q report). That's partly why profit margins improved in 1999.  Footnote M  The post-retirement liability estimates should be investigated for changes in actuarial and discount rate assumptions. These liabilities are reserves that can be increased or liquidated by use of estimates. The restructuring reserve is in other liabilities. Note that the "bleed back" to income appears on the cash flow statement for 1997 and 1998, but the change in the estimate is included, less transparently, in the change in other liabilities in 1999.  Footnote P  Bad debt (and other) reserves increased in 1998 but declined in 1999 producing changes to deferred tax assets in a pattern that is not consistent with the steady growth in revenues. Is the firm estimating reserves in such a way as to shift income between  periods? The effects of restructuring changes (and their reversals) show up in an effect on deferred taxes. There is a large reduction in the deferred tax valuation allowance -- an estimate -in 1998. Is the $1.7 billion reduction justified by the explanation given? In any case this amount goes to after-tax income, so a significant portion of 1998 income is due to this change of estimate, not to current operations.  p. 102 Solutions Manual to accompany Financial Statement Analysis and Security Valuation Estimates of residual values on sales-type leases are always suspect. Note that the deferred tax effect is not trivial and a question arises whether these estimated residual values will ultimately be realized. This is of particular concern in an industry with rapidly changing technology (and likely obsolescence). The deferral of software costs is also a concern when technology is rapidly changing.  Footnote Q and S  There don't seem to be any concerns about marketing and R&D Costs. These are as a fairly consistent percentage of sales. But the practice of charging off acquired in process R&D immediately (which might otherwise be unamortized goodwill) is a concern. If possible, this component of R&D should be separated out so to give a clearer   picture of in-house R&D expenditures.  Footnote W  Go to Box 12.5 for an analysis of IBM's pension footnote. A considerable component of income comes from pension fund gains rather than core business.  Note that IBM was using an expected rate of return on pension plan assets of 10% in 2000, up from earlier (and up considerably from the rates used in the 1980s). Applied to the growing pension asset prices (bubble prices at the time?) this boosts the pension gain component of income. IBM subsequently lowered the rate, resulting in considerably lower earnings in the early 2000s.  Note also that IBM modified its discount rate for the pension liability calculation to 7.75% in 1999 from 6.5% in 1998, affecting the estimate and the pension expense. The Analysis of Growth and Sustainable Earnings – Chapter 12 p. 103