某咨询财务分析工具课件

1、 author: collins qiancontributor: chris nelson bccash flowmarch 1998copyright 1998 bain & company, inc. 1bcbos copyright 1998 bain & company, inc. cash flowagenda the importance of cash flowtypes of cash flowapplicationscash flow stepsexercisekey takeaways2bcbos copyright 1998 bain & com

2、pany, inc. cash flowagenda the importance of cash flowtypes of cash flowapplicationscash flow stepsexercisekey takeaways3bcbos copyright 1998 bain & company, inc. cash flowwhat is cash flow? cash flow describes the movement of cash into (sources) and out of (uses) a company.sources of cashcompan

3、yuses of cash$4bcbos copyright 1998 bain & company, inc. cash flowwhy do we care about cash? the market value of a company is equal to the present value of its expected future cash flowsvarious stakeholders demand cashinvestors demand cash returnssuppliers and employees require cash compensation

4、debtholders demand cash paymentsaccounting methods can be used to “manage” earnings; cash is harder to manipulatecash is king!cash flow is the measure of a companys strategic value.5bcbos copyright 1998 bain & company, inc. cash flowearnings vs. cash flow* some accounting decisions impact earnin

5、gs, but not cashin 1988, general motors made at least four decisions that impacted earnings but not cashearnings do not equal cash flow.*earnings are also called after tax profits or net incomesuccessful high growth companies tend to have high earnings, but low cash flow; successful low growth compa

6、nies tend to have low earnings, but high cash flowaccounting decisionextended useful plant life from 35 to 45 year schedulechanged the way it accounted for its pension planadjusted its inventory valuation policychanged the residual value assumption for cars it leasedearnings impact$790mm$480mm$217mm

7、$270mmcash impactnonenonenonenonetotal:$1,757mmnone6bcbos copyright 1998 bain & company, inc. cash flowagenda the importance of cash flowtypes of cash flowapplicationscash flow stepsexercisekey takeaways7bcbos copyright 1998 bain & company, inc. cash flowtypes of cash flow net cash flow is e

8、qual to the sum of the cash flows from operating, investing, and financing activities.operating cash flowinvesting cash flowfinancing cash flowability of a companys recurring operations to generate cashability of a companys investment decisions to generate cashhow a company funds its operationsopera

9、ting profitsdecrease in working capitalsale of fixed assetslong-term issuance of shares examples of sources:operating losses increase in working capitalpurchase of fixed assetsrepayment of loans payment of dividends examples of uses:8bcbos copyright 1998 bain & company, inc. cash flowoperating c

10、ash flow*investing activities not related to ongoing operations (such as the purchase or sale of divisions or companies, or investments in unrelated businesses) are not included in investing cash flow. they are included in financing cash flow.operating cash flow excludes all cash flows related to a

11、firms capital structurecash generation ability is independent of how a firm is financedit excludes one-time eventsthese are not related to a firms recurring operationsoperating cash flow is used to measure the strategic value of a businessfor company valuations, operating and investing cash flows ar

12、e used, not financing cash flowbain is usually more interested in operating and investing* cash flow than in financing cash flowoperating cash flow measures the ability of a businesss recurring operations to generate cash.9bcbos copyright 1998 bain & company, inc. cash flowinvesting cash flowinv

13、estments in ongoing operations - property, plant and equipment - are included in investing cash flowcash is used to replace assets as they wear outif a business is to grow, additional assets must be acquiredin some cases, the cash used to acquire these assets is generated from the sale of existing n

14、oncurrent assetssuch cash inflows, however, seldom cover the entire cost of asset acquisitions. often times cash flow from operations is used to finance acquisitions, or, failing a positive operating cash flow, external financing is usedpure financing activities are not included in investing cash fl

15、ow. they are included in financing cash flowpurchase or sale of divisions or companiesinvestments in unrelated businessesinvesting cash flows relating to ongoing operations are used as a measure of the strategic value of a business. those that are purely financing/investment mechanisms are used to e

16、valuate the financial strategy of the businessinvesting cash flow measures the use of a businesss cash for the acquisition of non-current assets.10bcbos copyright 1998 bain & company, inc. cash flowfinancing cash flowmajor types of financing cash flow include: debt-related transactions8changes i

17、n long-term debt8interest income and expenseequity-related transactions8changes in common and preferred stock8dividends8short-term investmentslong-term asset and liability transactions8purchase or sale of a division or company8changes in long-term liabilitiesfinancing cash flow captures all the non-

18、operating cash changes experienced during the year, and it provides information on how a company is funding its operations.11bcbos copyright 1998 bain & company, inc. cash flowstatement of cash flowsthe scf is divided into three sections: operating, investing, and financingeach section shows sou

19、rces and uses of funds for the accounting periodthe scf shows the amounts fordepreciation and amortizationcapital expenditurestaxes paiddividends paidit does not show sources and uses by business unitit does not provide much detail for example, it does not show capital expenditures by project, nor i

20、ndividual equipment purchasesthe scf is not a substitute for cash flow analysisthe statement of cash flows (scf) found in annual reports is a good source of data for constructing cash flows, but sometimes it does not have the detail required for the analysis being done.12bcbos copyright 1998 bain &a

21、mp; company, inc. cash flowagenda the importance of cash flowtypes of cash flowapplicationscash flow stepsexercisekey takeaways13bcbos copyright 1998 bain & company, inc. cash flowapplications bain case teams use cash flow (cf) analysis to value investments/acquisitions, to improve the health of

22、 business units, and to help companies manage their portfolios.valuation (mergers, acquisitions)business unit analysisportfolio managementwhat is the cash generation potential of an investment/ acquisition?what are we willing to pay (in cash) for that investment/acquisition?how healthy is a business

23、 unit?what factors have effected the business units ability to generate cash/value over time?how can the business units cash management be improved?what is the overall balance of cash users/cash generators in a clients portfolio of businesses?how does this effect the clients overall cash position/ou

24、tlook?what restructuring can be done to improve this profile?cf = common denominatorcf = measuring stickcf = portfolio tool14bcbos copyright 1998 bain & company, inc. cash flowagenda the importance of cash flowtypes of cash flowapplicationscash flow stepsexercisekey takeaways15bcbos copyright 19

25、98 bain & company, inc. cash flowcash flow cookbook*cash is defined as cash plus marketable securities minus short-term notes*i/s = income statement, scf = statement of cash flows, b/s = balance sheet+/ - +/ - - +/ - =1.profit before interest and tax (pbit)2.depreciation3.other non-cash expenses

26、/income4.decrease/increase in working capital (excluding cash)5.taxes paid6.tax impact of interest income/expenseoperating cash flowbain case teams use the following cash flow cookbook: - =7.capital expendituresinvesting cash flow+/ - +/ - +/ - +/ - - +/ - =8.interest income/expense9.tax impact of i

27、nterest expense/income10. increase/decrease in long-term debt11. increase in outstanding stocks/shares12. dividends13. changes in other accountsfinancing cash flow14. reconcile with change in cash* from balance sheetnet cash flowsource*i/sscf, b/s and notesnotesb/si/s, b/si/sscf, b/s and notesi/si/s

28、b/sb/sscf, b/s, and notesb/s, i/sb/s16bcbos copyright 1998 bain & company, inc. cash flowagenda the importance of cash flowtypes of cash flowapplicationscash flow stepsexercisekey takeaways17bcbos copyright 1998 bain & company, inc. cash flowexercise - background (p. 1)*this exercise is base

29、d on the gillette companys financial statements in 1996. since several modifications have been made to the financial statements, the information provided hereafter should not be used to analyze gillettes financial performance.net salescost of salesgross profitsg&aprofit from operationsinterest e

30、xpenseincome before taxesincome taxesnet income1996$9,697.7mm($3,681.7mm)$6,016.0mm($4,379.7mm)$1,636.3mm($111.3mm)$1,525.0mm($576.3mm)$948.7mmincome statement: the new england razor company*use the following data to calculate the cash flow for the new england razor company:18bcbos copyright 1998 ba

31、in & company, inc. cash flow*deferred taxes can be a liability account, an asset account, or both (as is the case here).assetscurrent assetscashmarketable securitiesreceivablesinventoriesdeferred income taxes*prepaid expensestotal current assetsproperty, plant & equipmentliabilities and stoc

32、kholders equitycurrent liabilitiesloans payablecurrent portion of long-term debtaccounts payable and accrued expensesincome taxes payabletotal current liabilitieslong-term debtdeferred income taxes*other long-term liabilitiesdividends payablestockholders equitycommon stockadditional paid-in capitalr

33、etained earningstreasury stocktotal stockholders equity$76.9$7.0$2,724.6$1,358.2$359.3$227.2$4,753.2$5,192.0$9,945.2$656.7$14.5$1,964.9$298.6$2,934.7$1,490.4$298.9$630.2$100.1$671.4$707.0$4,168.7($1,056.2)$4,490.91995$81.6$1.6$2,290.8$1,267.6$246.8$199.3$4,087.7$4,456.6$8,544.3$634.7$26.5$1,609.8$31

34、9.4$2,590.4$1,048.4$303.4$635.1$66.7$667.1$574.8$3,704.2 ($1,045.8)$3,900.3$9,945.2$8,544.3balance sheetdecember 31, 1996 and 1995 (in $mm)1996exercise - background (p. 2)19bcbos copyright 1998 bain & company, inc. cash flow property, plant and equipmentless accumulated depreciationnet property,

35、 plant, and equipment1996 (in $mm)$7,820.4$2,628.4$5,192.01995 (in $mm)$6,885.0$2,428.4$4,456.6note 1: property, plant and equipmentnote 2: dividendsthe company declared dividends of $484.2mm in 1996note 3: sale of assetsa loss of $22mm was incurred on equipment sold during the yearthe equipment had

36、 an original cost of $244.0mm and was sold for $40.9mmexercise - background (p. 3)notes to the financial statements are a critical source of information.20bcbos copyright 1998 bain & company, inc. cash flowoperating cash flow*cash is defined as cash plus marketable securities minus short-term no

37、tes*i/s = income statement, scf = statement of cash flows, b/s = balance sheet+/ - +/ - - +/ - =1.profit before interest and tax (pbit)2.depreciation3.other non-cash expenses/income4.decrease/increase in working capital (excluding cash)5.taxes paid6.tax impact of interest income/expenseoperating cas

38、h flow - =7.capital expendituresinvesting cash flow+/ - +/ - +/ - +/ - - +/ - =8.interest income/expense9.tax impact of interest expense/income10.increase/decrease in long-term debt11.increase in outstanding stocks/shares12.dividends13.changes in other accountsfinancing cash flow14.reconcile with ch

39、ange in cash* from balance sheetnet cash flowsource*i/sscf, b/s and notesnotesb/si/s, b/si/si/si/sb/sb/sb/s, i/sb/sscf, b/s and notesscf, b/s and notes21bcbos copyright 1998 bain & company, inc. cash flowstep 1 - profit before interest and taxwhere to find:process:comments:income statementit can

40、 be labeled in many different ways, including profit before interest and tax, profit from operations, operating profit, and earnings before interest and taxif income statement is provided, pick number from income statementif income statement is not provided, calculate profit before interest and tax:

41、profit before taxes - interest income and other income (earned)+ interest expense and other expenses (incurred) - any one-time gains included in profit before taxes+ any one-time losses included in profit before taxes= profit before interest and tax (pbit)the goal is to get profit before interest pa

42、yments, tax payments, and extraordinary items22bcbos copyright 1998 bain & company, inc. cash flowstep 1 - profit before interest and tax - answerprofit before interest and tax*:$1,636.3mm1996operating cash flow begins with profit before interest and tax.*shown as profit from operations on the n

43、ew england razor companys income statement23bcbos copyright 1998 bain & company, inc. cash flowsteps 2 and 3 - depreciation and other non-cash income/expenseswhere to find:process:depreciation - statement of cash flows, or calculate from balance sheet and notesother non-cash income/expenses - no

44、tesreview assets and liabilities that are not taken into account in working capital (elements of working capital include current assets and liabilities with the exception of cash, tax items, and financing assets and liabilities (e.g., interest and dividends payable)ask two questions:was the item non

45、-cash?was the item included in profit before interest and tax?if the answer to both is yes, adjust profit before interest and taxe.g., depreciation - add back to profit before interest and taxe.g., loss on sale of asset - add back to profit before interest and taxif answer to either question is no,

46、make no adjustments 24bcbos copyright 1998 bain & company, inc. cash flowstep 2 - depreciationwhere to find:process:statement of cash flows, or calculate from balance sheet and notesif depreciation is provided in the statement of cash flows, pick number from thereif not, calculate depreciation:

47、accumulated depreciation at year end - accumulated depreciation at year beginning+ depreciation from sale of asset= depreciation expense for the yeardepreciation from sale of asset: original cost of asset- proceeds from sale of asset- losses incurred= depreciation from sale of asset25bcbos copyright

48、 1998 bain & company, inc. step 2 - depreciation - answer (p. 1) depreciation from sale of asset= the original cost of asset - proceeds from sale of asset - losses incurred = $244.0mm - $40.9mm - $22.0mm = $181.1mmdepreciation expense for 1996 = accumulated depreciation at year end - accumulated

49、 depreciation at year beginning + depreciation from sale of asset= $2,628.4mm - $2,428.4mm + $181.1mm = $381.1mmcash flowdepreciation is a non-cash expense. therefore, it is added to profit before interest and tax in the operating cash flow.26bcbos copyright 1998 bain & company, inc. cash flowst

50、ep 2 - depreciation - answer (p. 2)accumulateddepreciation (year end)accumulateddepreciation(year beginning)depreciation fromsale of assetsdepreciation expense$2,628.4mm($2,428.4mm)$181.1mm$381.1mm$0$500$1,000$1,500$2,000$2,500$3,000 millions of dollarsthe depreciation expense for the year can be ca

51、lculated from the balance sheet and notes. - +=27bcbos copyright 1998 bain & company, inc. cash flowstep 3 - other non-cash expenses - answerloss on equipment sold during the year:$22.0mm (from note 3)1996other non-cash expenses are added to profit before interest and tax in the operating cash f

52、low.28bcbos copyright 1998 bain & company, inc. cash flowstep 4 - change in working capital (excluding cash)where to find:process:balance sheetworking capital = current assets - current liabilitiesreview each current asset and current liabilityinclude:exclude:cash and cash equivalentstax itemsin

53、clude in taxes paid calculation (step 5)financing assets and liabilities, such as:interest payabledividends payablecurrent portion of long-term debtoperating assets and liabilities29bcbos copyright 1998 bain & company, inc. cash flowworking capital current assets and liabilitiesincluded in chang

54、e in working capital calculationcurrent assetscashmarketable securitiesinventoryaccounts receivablepre-paid expensesdeferred income taxes current liabilitiesaccounts payableaccrued expensesloans payableincome taxes payablecurrent portion of long-term debtinterest payabledividends payableincluded in

55、cash, not working capitalincluded in cash, not working capitalincluded in operating cash flow, but not in working capitalincluded in financing cash flownot all current assets and liabilities are included in working capital.included in operating cash flow, but not in working capitalincluded in financ

56、ing cash flowincluded in financing cash flow30bcbos copyright 1998 bain & company, inc. cash flowcurrent assets changes in working capital asset items have cash flow impacts.means cash is being used to fund the businessmeans cash is being generated by the businessincrease in non-cash working cap

57、italdecrease in non-cash working capitaldecreases in current assets.increases in current assets.increase in inventoriescash spent to buy inventoriesincrease in pre-paid expenses cash used to pre-pay billsreduction in inventoriescash generated by selling inventoriesreduction in accounts receivablecas

58、h received from customers31bcbos copyright 1998 bain & company, inc. cash flowcurrent liabilitieschanges in working capital liability items have cash flow impacts.means cash is being retained by the businessmeans cash is being used to fund the businessdecrease in non-cash working capitalincrease

59、 in non-cash working capitaldecrease in current liabilities.increases in current liabilities.increase in accounts payablecash saved by delaying payment to suppliersincrease in deferred tax liabilitycash saved by delaying payment of taxesdecrease in accounts payablecash paid to suppliersdecrease in a

60、ccrued expensescash used to reduce accrued expenses32bcbos copyright 1998 bain & company, inc. cash flowstep 4 - change in working capital - answerloans payable:receivables:inventories:prepaid expenses:1995 ($mm)$2,290.8$1,267.6$199.3$1,609.8$634.71996 ($mm)$2,724.6$1,358.2$227.2$1,964.9$656.7asset or liabilityassetassetassetliabilityliabilitychangeincreaseincreaseincreaseincreaseincreaseimpact on working capitalincreaseincreaseincre