




已阅读5页,还剩55页未读, 继续免费阅读
版权说明:本文档由用户提供并上传,收益归属内容提供方,若内容存在侵权,请进行举报或认领
文档简介
A Tutorial on the Discounted Cash FlowModel for Valuation of CompaniesL. Peter JennergrenSixth revision, August 25, 2006SSE/EFI Working Paper Series in Business Administration No. 1998:1AbstractAll steps of the discounted cash flow model are outlined. Essential steps are:calculation of free cash flow, forecasting of future accounting data (income state-ments and balance sheets), and discounting of free cash flow. There is particularemphasis on forecasting those balance sheet items which relate to Property, Plant,and Equipment. There is an exemplifying valuation included (of a company calledMcKay), as an illustration. A number of other valuation models (abnormal earn-ings, adjusted present value, economic value added, and discounted dividends) arealso discussed. Earlier versions of this working paper were entitled “A Tutorial onthe McKinsey Model for Valuation of Companies”.Key words: Valuation, free cash flow, discounting, accounting dataJEL classification: G31, M41, C60Stockholm School of Economics, Box 6501, S - 11383 Stockholm, Sweden. The author is indebted toTomas Hjelstrom, Joakim Levin, Per Olsson, Kenth Skogsvik, and Ignacio Velez-Pareja for discussionsand comments.11 IntroductionThis tutorial explains all the steps of the discounted cash flow model, prominentlyfeatured in a book by an author team from McKinsey & Company (Tim Koller, MarcGoedhart, and David Wessels: Valuation: Measuring and Managing the Value of Compa-nies, Wiley, Hoboken, New Jersey; 4th ed. 2005). The purpose is to enable the reader toset up a complete valuation model of his/her own, at least for a company with a simplestructure. The discussion proceeds by means of an extended valuation example. Thecompany that is subject to the valuation exercise is the McKay company.1The McKay example in this tutorial is somewhat similar to the Preston example(concerning a trucking company) in the first two editions of Valuation: Measuring andManaging the Value of Companies (Copeland et al. 1990, Copeland et al. 1994). How-ever, certain simplifications have been made, for easier understanding of the model. Inparticular, the capital structure of McKay is composed only of equity and debt (i. e.,no convertible bonds, etc.). Also, McKay has no capital leases or capitalized pensionliabilities.2McKay is a single-division company and has no foreign operations (and con-sequently there are no translation dierences). There is no goodwill and no minorityinterest. The purpose of the McKay example is merely to present all essential aspectsof the discounted cash flow model as simply as possible. Some of the historical incomestatement and balance sheet data have been taken from the Preston example. However,the forecasted income statements and balance sheets are totally dierent from Prestons.All monetary units are unspecified in this tutorial (in the Preston example in Copelandet al. 1990, Copeland et al. 1994, they are millions of US dollars).This tutorial is intended as a guided tour through one particular implementation ofthe discounted cash flow model and should therefore be viewed only as exemplifying: Thisis one way to set up a valuation model. Some modelling choices that have been made willbe pointed out later on. However, it should be noted right away that the specificationgiven below of net Property, Plant, and Equipment (PPE) as driven by revenues agreeswith Koller et al. 2005. The first two editions of Valuation: Measuring and Managing theValue of Companies contain two alternative model specifications relating to investment1Previous versions of this tutorial were entitled “A Tutorial on the McKinsey Model for Valuationof Companies”, since they focused on the McKinsey implementation of the discounted cash flow model.However, after several revisions of the McKinsey book as well as of this tutorial, there are now somedierences in emphasis and approach between the two, motivating the title change. Otherwise, themost important changes in the sixth revision of this tutorial are as follows: The working capital itemsinventories and accounts payable are now driven by operating expenses, rather than by revenues. Section15 and Appendix 2 are new.2Pension contributions in McKay may hence may be thought of as paid out to an outside pensionfund concurrently with the salaries generating those contributions, so no pension debt remains on thecompanys books.2in PPE (cf. Levin and Olsson 1995).In the following respect, this tutorial is an extension of Koller et al. 2005: It containsa more detailed discussion of capital expenditures, i. e., the mechanism whereby cashis absorbed by investments in PPE. This mechanism centers on two particular forecastassumptions, this years net PPE/revenues and depreciation/last years net PPE.3It isexplained below how those assumptions can be specified consistently. On a related note,the treatment of deferred income taxes is somewhat dierent, and also more detailed,compared to Koller et al. 2005. In particular, deferred income taxes are related to aforecast ratio timing dierences/this years net PPE, and it is suggested how to set thatratio.There is also another extension in this tutorial: Alternative valuation models are alsodiscussed. In fact, in the end McKay is valued through five dierent models.The McKay valuation is set up as a spreadsheet file in Excel named MCK.XLS. Thatfile is an integral part of this tutorial. The model consists of the following parts (as canbe seen by downloading the file):Table 1. Historical income statements,Table 2. Historical balance sheets,Table 3. Historical free cash flow,Table 4. Historical ratios for forecast assumptions,Table 5. Forecasted income statements,Table 6. Forecasted balance sheets,Table 7. Forecasted free cash flow,Table 8. Forecast assumptions,Value calculations.Tables in the spreadsheet file and in the file printout that is included in this tutorial arehence indicated by numerals, like Table 1. Tables in the tutorial text are indicated bycapital letters, like Table A.The outline of this tutorial is as follows: Section 2 gives an overview of essentialmodel features. Section 3 summarizes the calculation of free cash flow. Section 4 is anintroduction to forecasting financial statements and also discusses forecast assumptionsrelating to operations and working capital. Sections 5, 6, and 7 deal with the specificationof the forecast ratios this years net PPE/revenues, depreciation/last years net PPE,and retirements/last years net PPE. Section 8 considers forecast assumptions abouttaxes. Further forecast assumptions, relating to discount rates and financing, are discussedin Section 9. Section 10 outlines the construction of forecasted financial statements andfree cash flow, given that all forecast assumptions have been fixed. Section 11 outlines a3Square brackets are used to indicate specific ratios that appear in tables in the spreadsheet files.3slightly dierent version of the McKay example, with another system for accounting fordeferred income taxes.4The discounting procedure is explained in Section 12. Section 13gives results from a sensitivity analysis, i. e., computed values of McKays equity whencertain forecast assumptions are revised. Section 14 discusses another valuation model,the abnormal earnings model, and indicates how McKays equity can be valued by thatmodel. Section 15 considers a dierent financing policy for McKay. Under that financingpolicy, McKay is valued by five dierent models (discounted cash flow, adjusted presentvalue, economic value added, discounted dividends, and abnormal earnings).5Section16 contains concluding remarks. Appendix 1 discusses how a data base from StatisticsSweden can be used as an aid in specifying parameters related to the forecast ratios thisyears net PPE/revenues, depreciation/last years net PPE and retirements/last yearsnet PPE. Appendix 2 is a note on the value driver formula that is recommended forcontinuing value by Koller et al. 2005.2 Model overviewEssential features of the discounted cash flow model are the following:1. The model uses published accounting data as input. Historical income statementsand balance sheets are used to derive certain critical financial ratios. Those historicalratios are used as a starting point in making predictions for the same ratios in futureyears.2. The object of the discounted cash flow model is to value the equity of a goingconcern. Even so, the asset side of the balance sheet is initially valued. The value of theinterest-bearing debt is then subtracted to get the value of the equity. Interest-bearingdebt does not include deferred income taxes and trade credit (accounts payable and othercurrent liabilities). Credit in the form of accounts payable is paid for not in interestbut in higher operating expenses (i. e., higher purchase prices of raw materials) and istherefore part of operations rather than financing. Deferred income taxes are viewed aspart of equity; cf. Sections 9 and 10. It may seem like an indirect approach to value theassets and deduct interest-bearing debt to arrive at the equity (i. e., it may seem morestraight-forward to value the equity directly, by discounting future expected dividends).However, this indirect approach is the recommended one, since it leads to greater clarityand fewer errors in the valuation process (cf. Koller et al. 2005, pp. 126-128).4This version of the McKay example is contained in the Excel file MCK B.XLS. A printout from thatfile is also included in this tutorial. The two versions of the McKay example are equivalent as regardscash flow and resulting value. In other words, it is only the procedure for computing free cash flow thatdiers (slightly) between them.5See the file MCK EXT.XLS. A printout from that file is also included here.43.Thevalueoftheassetsideisthevalueofoperationsplusexcess marketable secu-rities. The latter can usually be valued using book values or published market values.Excess marketable securities include cash that is not necessary for operations. For valu-ation purposes, the cash account may hence have to be divided into two parts, operatingcash (which is used for facilitating transactions relating to actual operations), and ex-cess cash. (In the case of McKay, excess marketable securities have been netted againstinterest-bearing debt at the date of valuation. Hence there are actually no excess mar-ketable securities in the McKay valuation. This is one of the modelling choices that werealluded to in the introduction.)4. The operations of the firm, i. e., the total asset side minus excess marketable secu-rities, are valued by the WACC method. In other words, free cash flow from operationsis discounted to a present value using the WACC. There is then a simultaneity problem(actually quite trivial) concerning the WACC. More precisely, the debt and equity valuesenter into the WACC weights. However, equity value is what the model aims to determine.5. The asset side valuation is done in two parts: Free cash flow from operations isforecasted for a number of individual years in the explicit forecast period.Afterthat,there is a continuing (post-horizon) value derived from free cash flow in the first year ofthe post-horizon period (and hence individual yearly forecasts must be made for each yearin the explicit forecast period and for one further year, the first one immediately followingthe explicit forecast period). The explicit forecast period should consist of at least 10 -15 years (cf. Koller et al. 2005, p. 230). The explicit forecast period can be thought ofas a transient phase during a turn-around or after a take-over. The post-horizon period,on the other hand, is characterized by steady-state development. This means that theexplicit forecast period should as a minimal requirement be suciently long to capturetransitory eects, e. g., during a turn-around operation. Actually, it is a requirement ofthe present implementation of the discounted cash flow model that the explicit forecastperiod should not be shorter than the economic life of the PPE.6. For any future year, free cash flow from operations is calculated from forecastedincome statements and balance sheets. This means that free cash flow is derived from aconsistent scenario, defined by forecasted financial statements. This is probably the mainstrength of the discounted cash flow model, since it is dicult to make reasonable forecastsof free cash flow in a direct fashion. Financial statements are forecasted in nominal terms(which implies that nominal free cash flow is discounted using a nominal discount rate).7. Continuing value is computed through an infinite discounting formula. In thistutorial, the Gordon formula is used (cf. Brealey et al. 2006, pp. 40, 65). In other words,free cash flow in the post-horizon period increases by some constant percentage fromyear to year, hence satisfying a necessary condition for infinite discounting. (The Gordonformula is another one of the modelling choices made in this tutorial.)5As can be inferred from this list of features, and as will be explained below, thediscounted cash flow model combines three rather dierent tasks: The first one is theproduction of forecasted financial statements. This is not trivial. In particular, it involvesissues relating to capital expenditures that are fairly complex. (The other valuationmodels use forecasted financial statements, just like the discounted cash flow model, sothe first task is the same for those models as well.)The second task is deriving free cash flow from operations from financial statements.At least in principle, this is rather trivial. In fairness, it is not always easy to calculate freecash flow from complicated historical income statements and balance sheets. However, allfinancial statements in this tutorial are very simple (and there is, in any case, no reasonto forecast accounting complexities if the purpose is one of valuation). The third task isdiscounting forecasted free cash flow to a present value. While not exactly trivial, this taskis nevertheless one that has been discussed extensively in the corporate finance literature,so there is guidance available. This tutorial will explain the mechanics of discounting inthe discounted cash flow model. However, issues relating to how the relevant discountrates are determined will largely be brushed aside. Instead, the reader is referred tostandard text books (for instance, Brealey et al. 2006, chapters 9, 17, and 19).3 Historical financial statements and the calculationof free cash flowThe valuation of McKay is as of Jan. 1 year 1. Historical input data are the incomestatements and balance sheets for the years 6 to 0, Tables 1 and 2. Table 1 also includesstatements of retained earnings. It may be noted in Table 1 that operating expenses donot include depreciation. In other words, the operating expenses are cash costs. At thebottom of Table 2, there are a couple of financial ratio calculations based on historicaldata for the given years. Short-term debt in the balance sheets (Table 2) is that portionof last years long-term debt which matures within a year. It is clear from Tables 1 and2 that McKays financial statements are very simple, and consequently the forecastedstatements will also have a simple structure. As already mentioned earlier, McKay hasno excess marketable securities in the last historical balance sheet, i. e., at the date ofvaluation.From the data in Tables 1 and 2, historical free cash flow for the years 5to0is computed in Table 3. Each annual free cash flow computation involves two balancesheets, that of the present year and the previous one, so no free cash flow can be obtainedfor year 6. Essentially the same operations are used to forecast free cash flow foryear 1 and later years (in Table 7). The free cash flow calculations assume that the cleansurplus relationship holds. This implies that the change in book equity (including retained6earnings) equals net income minus net dividends (the latter could be negative, if there is anissue of common equity). The clean surplus relationship does not hold, if PPE is writtendown (or up) directly against common equity (for instance). Such accounting operationsmay complicate the calculation of free cash flow from historical financial statements (andif so, that calculation may not be trivial). However, there is usually no reason to forecastdeviations from the clean surplus relationship in a valuation situation.EBIT in Table 3 means Earnings Before Interest and Taxes. NOPLAT means Net Op-erating Profits Less Adjusted Taxes. Taxes on EBIT consist of calculated taxes accordingto the income statement (from Table 1) plus this years tax rate(interest expense)minus this years tax rate(interest income). Interest income and interest expense aretaken from Table 1. The tax rate is given in Table 4. Calculated taxes according to theincome statement reflect depreciation of PPE over the economic life. Change in deferredincome taxes is this years deferred income taxes minus last years deferred income taxes.In the McKay valuation example, it is assumed that deferred income taxes come aboutfor one reason only, timing dierences in depreciation of PPE. That is, fiscal depreciationtakes place over a period shorter than the economic life.Working capital is defined net. Hence, working capital consists of the following balancesheet items: Operating cash plus trade receivables plus other receivables plus inventoriesplus prepaid expenses minus accounts payable minus other current liabilities. Accountspayable and other current liabilities are apparently considered to be part of the operationsof the firm, not part of the financing (they are not interest-bearing debt items). Changein working capital in Table 3 is hence this years working capital minus last years workingcapital. Capital expenditures arethisyearsnetPPEminus last years net PPE plus thisyears depreciation. Depreciation is taken from Table 1, net PPE from Table 2. It shouldbe emphasized that depreciation in Table 1 (and forecasted depreciation in Table 5) isaccording to plan, over the economic life of the PPE.Free cash flow in Table 3 is hence cash generated by the operations of the firm, afterpaying taxes on operations only, and after expenditures for additional working capital andafter capital expenditures. (“Additional working capital” could of course be negative. Ifso, free cash flow is generated rather than absorbed by working capital.) Hence, free cashflow represents cash that is available for distribution to the holders of debt and equity inthe firm, and for investment in additional excess marketable securities. Stated somewhatdierently, free cash flow is equal to financial cash flow, which is the utilization of freecash flow for financial purposes. Table 3 also includes a break-down of financial cash flow.By definition, free cash flow must be exactly equal to financial cash flow.We now return briefly to the financial ratios at the end of Table 2. Invested capi-tal is equal to working capital plus net PPE. Debt at the end of Table 2 in the ratiodebt/invested capital is interest-bearing (short-term and long-term). The financial ratio7NOPLAT/invested capital is also referred to as ROIC (Return on Invested Capital). Itis a better analytical tool for understanding the companys performance than other returnmeasures such as return on equity or return on assets, according to Koller et al. (2005, p.183). Invested capital in the ratio NOPLAT/invested capital is the average of last yearsand this years. It is seen that McKay has provided a decreasing rate of return in recentyears. It can also be seen from Table 3 that the free cash flow has been negative, andthat the company has handled this situation by increasing its debt. It is evident from thebottom of Table 2 that the ratio of interest-bearing debt to invested capital has increasedsubstantially from year 6toyear0.Table 4 contains a set of historical financial ratios. Those ratios are important, sinceforecasts of the same ratios will be used to produce forecasted income statements andbalance sheets. Most of the items in Table 4 are self-explanatory, but a few observationsare called for. Net PPE (which is taken from Table 2) enters into four ratios. In two ofthose cases, depreciation/net PPE and retirements/net PPE, the net PPE in questionis last years. In the other two cases, net PPE/revenues and timing dierences/netPPE, the net PPE in question is this years. Retirements are defined as depreciationminus change in accumulated depreciation between this year and last year (accumulateddepreciation is taken from Table 2). This must hold, since last years accumulated de-preciation plus this years depreciation minus this years retirements equals this yearsaccumulated depreciation.The timing dierences for a given year are measured between accumulated fiscal depre-ciation of PPE and accumulated depreciation according to PPE economic life. For a givenpiece of PPE that is about to be retired, accumulated fiscal depreciation and accumulateddepreciation according to economic life are both equal to the original acquisition value.Consequently, non-zero timing dierences are related to non-retired PPE only. The ratiotiming dierences/net PPE in Table 4 has been calculated by first dividing the deferredincome taxes for a given year by the same years corporate tax rate (also given in Table4). This gives that years timing dierences. After that, there is a second division by thatyears net PPE.4 Forecast assumptions relating to operations andworking capitalHaving recorded the historical performance of McKay in Tables 1 - 4, we now turnto the task of forecasting free cash flow for years 1 and later. Individual free cash flowforecasts are produced for each year 1 to 12. The free cash flow amounts for years 1 to 11are discounted individually to a present value. The free cash flow for year 12 and all lateryears is discounted through the Gordon formula, with the free cash flow in year 12 as a8starting value. Years 1 to 11 are therefore the explicit forecast period, and year 12 andall later years the post-horizon period. As required, the explicit forecast period is longerthan the economic life of the PPE (the latter is assumed to be 10 years in Section 7).Tables 5 - 8 have the same format as Tables 1 - 4. In fact, Table 5 may be seen asa continuation of Table 1, Table 6 as a continuation of Table 2, and so on. We startthe forecasting job by setting up Table 8, the forecast assumptions. Using assumptions(financial ratios and others) in that table, and using a couple of further direct forecastsof individual items, we can set up the forecasted income statements, Table 5, and theforecasted balance sheets, Table 6. From Tables 5 and 6, we can then in Table 7 derivethe forecasted free cash flow (just like we derived the historical free cash flow in Table 3,using information in Tables 1 and 2).Consider now the individual items in Table 8. It should be noted in Table 8 that allitems are the same for year 12, the first year of the post-horizon period, as for year 11, thelast year of the explicit forecast period. Since the first year in the post-horizon period isrepresentative of all subsequent post-horizon period years, all items are the same for everypost-horizon period year as for the last year of the explicit forecast period. This is actuallyan important condition (cf. Levin and Olsson 1995, p. 38; Lundholm and OKeefe 2001,pp. 321-322): If that condition holds, then free cash flow increases by the same percentage(the nominal revenue growth rate for year 12 in Table 8, cell T135) between all successiveyears in the post-horizon period. This means that a necessary condition for discountingby means of the Gordon formula in the post-horizon period is satisfied.The revenue growth in each future year is a combination of inflation and real growth.More precisely, nominal revenue growth is “one plus real growth multiplied by one plusexpected inflation minus one”. Actually, in years 10 and 11 there is no real growth, andthe same assumption holds for all later years as well (in the application of the Gordonformula). The underlying assumption in Table 8 is apparently that real operations willinitially expand but will eventually (in year 10) settle down to a steady state with nofurther real growth. Inflation, on the other hand, is assumed to be 3% in all comingyears (including after year 12). The ratio of operating expenses to revenues is assumedto improve immediately, e. g., as a consequence of a determined turn-around eort. Ap-parently, it is set to 90% year 1 and all later years. To avoid misunderstandings, thisforecast assumption and the other ones displayed in Table 8 are not necessarily intendedto be the most realistic ones that can be imagined. The purpose is merely to demonstratethe mechanics of the discounted cash flow model for one particular scenario. A table inLevin and Olsson 1995 (p. 124; based on accounting data from Statistics Sweden) containsinformation about typical values of the ratio between operating expenses and revenues invarious Swedish industries (cf. also Appendix 1 for a further discussion of the StatisticsSweden data base).9A number of items in the forecasted income statements and balance sheets are directlydriven by revenues. That is, those items are forecasted as percentages of revenues. Inparticular, this holds for most of the working capital items. It is thus assumed thatas revenues increase, the required amounts of working capital for these items increasecorrespondingly. It is not important whether revenues increase due to inflation or realgrowth, or a combination of both. Working capital turns over very quickly, and thereforeit is a reasonable assumption that these working capital items are simply proportionalto revenues. The ratios between the dierent working capital items and revenues forfuture years in Table 8 have been set equal to the average values of the correspondinghistorical percentages in Table 4. Again, this is only for illustrative purposes. Anothertable in Levin and Olsson 1995 (p. 125), again based on data from Statistics Sweden,reports average values of the ratio between (aggregate) working capital and revenues indierent Swedish industries. Two of the working capital items, inventories and accountspayable, are forecasted as percentages of operating expenses rather than as percentagesof revenues. This is actually not a very important distinction (i. e., one may perhaps justas well forecast all working capital items as percentages of revenues; cf. Koller et al. 2005,pp. 243-244). The ratios between these two working capital items and operating expensesfor future years are also set as average historical values.5 Forecast assumptions relating to property, plant,and equipmentThe forecast assumptions relating to PPE will be considered next (this section andthe following two). The equations that determine capital expenditures may be stated asfollows (subscripts denote years):(capital expenditures)t= (net PPE)t (net PPE)t1+ depreciationt,(net PPE)t= revenuest this years net PPE/revenues,depreciationt= (net PPE)t1 depreciation/last years net PPE.To this set of equations, we may add three more that are actually not necessary for themodel:retirementst= (net PPE)t1 retirements/last years net PPE,(accumulated depreciation)t= (accumulated depreciation)t1+ depreciationt retirementst,(gross PPE)t= (net PPE)t+ (accumulated depreciation)t.In particular, this second set of three equations is needed only if one wants to produceforecasted balance sheets showing how net PPE is related to gross PPE minus accumulateddepreciation. It should be noted that such detail is not necessary, since the first set of10three equations suces for determining net PPE, depreciation, and consequently alsocapital expenditures.6It is clear from the first three equations that forecasts have to be made for two partic-ular ratios, this years net PPE/revenues and depreciation/last years net PPE. Settingthose ratios in a consistent fashion involves somewhat technical considerations. In thissection and the following one, one way of proceeding, consistent with the idea of thecompany developing in a steady-state fashion in the post-horizon period, will be outlined.To begin with, the idea of the company developing in a steady-state fashion has to bemade more precise. As indicated in Section 4, the forecast assumptions should be specifiedin such a manner that nominal free cash flow increases by a constant percentage every yearin the post-horizon period. This is a necessary condition for infinite discounting by theGordon formula. But if so, capital expenditures must also increase by the same constantpercentage in every post-horizon period year. For this condition on capital expendituresto hold, there must be an even age distribution of nominal acquisition values of successivePPE cohorts. More precisely, it must hold that the acquisition value of each PPE cohortdevelops in line with the assumed constant growth percentage that is applicable to thepost-horizon period. As also mentioned in Section 4, that constant percentage is the sameas the assumed nominal revenue growth in the post-horizon period, 3% in the McKayexample.The general idea is now to set steady-state values of the two ratios this years netPPE/revenues and depreciation/last years net PPE for the last year of the explicitforecast period (year 11 in the McKay example). Those steady-state values will then alsohold for every year in the post-horizon period (since all forecast assumptions have to bethe same in the first year of the post-horizon period as in the last year of the explicitforecast period, as already explained in Section 4).During the preceding years of the explicit forecast period, steady-state values of thisyears net PPE/revenues and depreciation/last years net PPE are not assumed. Valuesfor these two ratios in the preceding explicit forecast period years are fixed in the followingheuristic fashion in the McKay example: For the first year of the explicit forecast period,they are set as averages of the corresponding values for the historical years.7Values for6If the historical financial statements do not show gross PPE and accumulated depreciation, only netPPE, then it seems pointless to try to include these items in the forecasted financial statements. If so,the second set of three equations is deleted. In the McKay case, the historical statements do indicategross PPE and accumulated depreciation. For that (aesthetic) reason, those items will also be includedin the forecasted statements.7The value for the last year of the explicit forecast period of retirements/last years net PPE is alsoset as a steady-state value. For the first year of the explicit forecast period, that ratio is set equal to thecorresponding value for the last historical year. An average of corresponding values for all historical yearsis not used in this case, since retirements/last years net PPE appears to have been unstable during11intermediate (between the first and last) years in the explicit forecast period are thendetermined by interpolation.6 The ratios this years net PPE/revenues and de-preciation/last years net PPE in the last year ofthe explicit forecast periodIt is helpful at this point to proceed more formally and introduce the following notation:g real growth rate in the last year of the explicit forecast period and in thepost-horizon period,i inflation rate in the last year of the explicit forecast period and in thepost-horizon period,c nominal (composite) growth rate = (1 + g)(1 + i) 1,n economic life of PPE (assumed to be integer),q life of PPE for fiscal depreciation; see Section 8 (assumed to be integer),K required real gross PPE divided by (real) revenues in the last year of theexplicit forecast period and in the post-horizon period,M ratio between this years nominal gross PPE and (nominal) revenues in thelast year of the explicit forecast period and in the post-horizon period,Fgbackwards summation factor expressing real gross PPE,Fcbackwards summation factor expressing nominal gross PPE,a acquisition value of last PPE cohort (nominal and real; real = nominal now),H steady-state accumulated depreciation as a fraction of gross PPE,J factor expressing timing dierences; see Section 8.It is assumed in this tutorial that g and i are non-negative. To assume negative inflationover an infinite number of years is simply not credible. Negative real growth of the firmover an infinite number of years is also not realistic in connection with the discountedcash flow model. If such a situation were really foreseen, then a break-up valuation wouldbe more relevant than a going concern valuation (as implied by the discounted cash flowmodel). Apparently, in the McKay example g =0.00, i =0.03, and consequently c =0.03in the last year of the explicit forecast period and from then on.The main task in this section is to set the steady-state value of the ratio this yearsnet PPE/revenues. As before, by steady state is meant that the acquisition values ofyears 5 to 0. The negative value of that ratio in year -2 could have come about through purchases ofused (second-hand) PPE. It is again noted that the ratio retirements/last years net PPE is actuallynot necessary for the valuation model.12successive PPE cohorts increase by c, the nominal growth rate of revenues. Also as notedbefore, steady-state values of all forecast ratios must be attained already in the last yearof the explicit forecast period.At this point, there is a need for some model of the relationship between revenuesand PPE, that is, a model of the firms production. It is assumed here that revenues arerelated to real gross PPE through a capital intensity factor K. In other words, in thelast year of the explicit forecast period and from then on, real gross PPE must be equalto revenues multiplied by K. Real means expressed in the value of money of the currentyear in question. Real revenues are equal to nominal revenues for the current year. Realgross PPE means nominal gross PPE adjusted for inflation. Such an adjustment impliesrevaluing each PPE cohort, through multiplication by a factor that expresses accumulatedinflation since that cohort was acquired. By relating revenues to real gross PPE, oneeliminates eects due to inflation. The assumption that revenues are related to grossrather than net PPE implies that each piece of PPE is 100% productive until the end ofits economic life. At that point in time, it suddenly ceases to function and is retired. Thisseems like a somewhat more intuitive hypothesis than the alternative, relating revenues tonet PPE, since that would mean that the productivity of each piece of PPE is proportionalto its remaining economic life.It is the steady-state value of the ratio this years net PPE/revenues that is the objecthere, but initially M will be derived, that is, the ratio between this years nominal grossPPE and (nominal) revenues in the last year of the explicit forecast period and in thepost-horizon period. After that, M is multiplied by a factor (1 H) expressing steady-state net PPE as a fraction of steady-state gross PPE, hence providing steady-state thisyears net PPE/revenues.Suppose now that a is the acquisition value of the last PPE cohort, which has justbeen purchased at the end of the current year. That acquisition value is the real one,expressed in current monetary units. Given the steady-state assumption, which impliesthat the acquisition values of previous cohorts have increased in real terms by the realgrowth rate g from year to year, the real value of gross PPE (in current monetary units13and at the end of the current year) is hence Fg a,where8Fg=n1summationdisplayv=0parenleftBigg11+gparenrightBiggv=1+g (1 + g)(n1)gif g0; Fg= n if g =0.The physical requirement for gross PPE then implies thatFg a = K revenues.Similarly, the nominal value of gross PPE at the end of the current year, under thesteady-state assumption, is Fc a,whereFc=n1summationdisplayv=0parenleftbigg11+cparenrightbiggv=1+c (1 + c)(n1)cif c0; Fc= n if c =0.Consequently,Fc a = M revenues.The formulas for Fgand Fcare contained in cells S152 and S153 in Table 8. It followsthat (cell S155)M =(Fc/Fg) K.Accumulated depreciation as a fraction of gross PPE in a steady state, H,canbewritten as (using (1) with = n 1; cf. also Levin and Olsson 1995, pp. 37, 51):H =summationtextn1v=0bracketleftBigparenleftBig11+cparenrightBigvvnbracketrightBigFc=n(1+c)(n1)(1(1+c)1)+(1(1+c)n)(1(1+c)1)211+c1nFc=1+c(nc+1)(1+c)(n1)c2nFc=1cn1(1 + c)n 1if c0; H =n 12nif c =0. (2)The formula for H is contained in cell S156. The desired steady-state ratio this yearsnet PPE/revenues is thenM(1 H). (3)This is the formula in cell S157 of Table 8.8The formulas for Fgand Fcuse the summationsummationdisplayv=0xv=1 x+11 x(x negationslash=1).The following summation formula is also used belowsummationdisplayv=0xvv =ddxparenleftBiggsummationdisplayv=0xvparenrightBigg x =( +1)x(1 x)+(1 x+1)(1 x)2 x (x negationslash=1). (1)14Assuming linear depreciation over the economic life of the PPE, the steady-state ratiodepreciation/last years net PPE is1n11 H.This is the formula in cell S158 of Table 8.9The steady-state ratios derived in this section apparently depend on four parameters,the real growth rate g, the inflation rate i (since c depends on g and i), the capital intensityfactor K, and the economic life n of the PPE.10Armed with the formulas derived here,one can perform sensitivity analyses of how calculated equity value varies due to changesin these four parameters.7 On the implementation of assumptions relating toPPEThe forecast for the ratio this years net PPE/revenues in the last year of the explicitforecast period can hence be obtained as equation (3) in the previous section, given thatn, g, i,andK have been specified. One parameter that may be dicult to specify is K.At least in principle, an estimate of K can be obtained from historical financial state-ments of the company being valued. For each one of the last n historical years, onedetermines the capital expenditures, like in Table 3. Apparently, this means that n +1sets of historical financial statements must be available. Each such amount except thelast one is then inflated to the price level that is valid for the last historical year. Thisis done using some suitable time series of historical inflation rates during the n 1pre-ceding historical years. After that, all n amounts are summed, and the sum is divided byrevenues in the last historical year. The result is an estimate of K at the end of the his-torical period. A forecast of K in the last year of the explicit forecast period can then beobtained by assuming, e. g., a slightly lower value, reflecting some improvement in capitalusage eciency. In the McKay example, this procedure is not immediately applicable,however, since n+1 = 11 sets of historical financial statements are not available (financialstatements are available only for 7 historical years).9The steady-state formula for retirements/last years net PPE is(1 + c)nFc(1 + c)111 H=1Fc(1 + c)(n1)11 H.This is the formula in cell S159 in Table 8.10Actually, steady-state depreciation/last years net PPE and steady-state retirements/last years netPPE depend on two parameters only, c and n. That is, they do not depend on g and i separately. Allthat matters for these two ratios is nominal growth c, not how that growth comes about due to dierentcombinations of real growth g and expected inflation i.15A more heuristic approach would be to set K so as to obtain a “reasonable” value ofthe ratio this years net PPE/revenues in the last year of the explicit forecast period,reasonable meaning in relation to what has actually been observed in historical years. Itis assumed here that g, i,andn have already been fixed. That is, K is set after theseother three. Under this more heuristic approach, there is no attempt to ascertain whatK has actually been in the historical period. One merely uses K as a free parameter toobtain a forecasted value of the ratio this years net PPE/revenues in the last year ofthe explicit forecast period that seems acceptable.Another approach to setting K is to take as a starting point the data base fromStatistics Sweden that was mentioned in Section 4. It is indicated in Appendix 1 howthat data base can be used to provide rough estimates of K. Table C in Appendix 1contains suggested K values for various industries. It has been noted in a number ofvaluation projects, though, that the K values in that table often appear rather high.For instance, K is seen to be equal to 0.81 for the land transportation industry (usingdata pertaining to 1994 - 1998). But that seems too high for the McKay example, eventhough it refers to a trucking company, and hence to the land transportation industry.One reason why it is too high could be that land transportation also includes railways, i.e., more capital intensive activities than trucking.Without further justification, it is simply assumed here that K is equal to 0.58 in theMcKay case. This is the value for K in year 11 that is shown in Table 8 (cell S154). Usingequation (3), the value of this years net PPE/revenues in the same year (cell S157) isthen found to be 29.3%.The McKay example considers only one homogeneous category of PPE with an as-sumed economic life of n = 10 years (cell S151). One can of course set up a valuationmodel with dierent categories of PPE, e. g., machinery and buildings. The economic lifeof each category is sometimes mentioned in company annual reports. To cite only oneexample, the 1996 annual report of the Swedish company Rorviksgruppen states economiclives between 5 and 10 years for dierent types of machinery, and between 20 and 25 yearsfor buildings and land improvements. The assumption that n is integer is not restrictive,if dierent categories of PPE are considered, since individual categories can be thoughtof as having dierent integer economic lives.To recapitulate, this section and the previous two have considered forecasts for threeparticular ratios, this years net PPE/revenues, depreciation/last years net PPE, andretirements/last years net PPE. Steady-state values of these ratios can be specifiedfor the last year of the explicit forecast period. Those steady-state values depend onreal growth g, inflation i, PPE economic life n, and required real gross PPE divided byrevenues K. They are consistent with the company developing in a steady-state fashionin the post-horizon period, and consequently with the general idea of dividing the future16into explicit forecast and post-horizon periods. However, there is not total consistency,for (at least) two reasons. In the first place, the steady-state assumption is obviouslyonly an approximation: Successive PPE cohorts when entering the post-horizon period,as resulting from capital expenditures in the explicit forecast period, cannot be expectedto satisfy precisely the even age distribution requirement. This inconsistency is usuallynot very important. In the second place, real gross PPE when entering the post-horizonperiod (again the result of forecasted capital expenditures in the explicit forecast period)does not automatically correspond exactly to what is needed according to the capitalintensity factor K (i. e., K revenues).For the earlier years in the explicit forecast period, this years net PPE/revenues,depreciation/last years net PPE and retirements/last years net PPE have been set ina heuristic fashion in the McKay example (see Table 8): Values for the first year of theexplicit forecast period have been set equal to the average of all corresponding historicalratios, or equal to the immediately preceding historical ratio. Values for intermediateyears of the ratio this years net PPE/revenues have been determined by non-linearinterpolation between the first and last years of the explicit forecast period, in such amanner that the real gross PPE when entering the post-horizon period is equal to whatis required according to the capital intensity factor K.11Hence, the second inconsis-tency in the previous paragraph is eliminated. Values for intermediate years of the ratiosdepreciation/last years net PPE and retirements/last years net PPE are determinedthrough linear interpolation. This is an easy way of making forecasts for the intermediateyears of the explicit forecast period. It is proposed here as a simple-minded alternativeto bottom-up forecasting of individual capital expenditures (new and replacement). Thelatter alternative may be more accurate but is also more complex, since it can usually onlybe done using information available inside a company, i. e., not on the basis of publishedaccounting data (cf. Koller et al. 2005, pp. 238-239).11See rows 160 - 166! Cell S163 calculates actual gross PPE at the end of the last explicit forecastperiod year, as resulting from capital expenditures that have been undertaken in that year and the n1previous explicit forecast period years. This calculation uses inflation factors in row 162. The amount ofreal gross PPE that is needed is given in cell S164. The dierence between cells S163 and S164, multipliedby 1,000,000, is contained in cell I165 (although as a hidden entry). This dierence can be driven to zeroby adjusting the interpolation curve parameter in cell S161. = 0 means no curvature, i. e., linearinterpolation. Finding that value of that gives a dierence of zero in cell I165 can conveniently be doneusing the Goal Seek procedure. This non-linear interpolation procedure obviously presupposes that theexplicit forecast period comprises at least n years, i. e., as many years as the economic life of the PPE.178 Forecast assumptions relating to taxesThe next set of forecast assumptions in Table 8 refers to taxes. The corporate taxrate has apparently been 39% in all historical years and is forecasted to remain at thatlevel in the future. The further tax assumption that must be fixed for future years isthe ratio timing dierences/this years net PPE. This ratio relates to the balance sheetitem deferred income taxes. That is, deferred income taxes are equal to (this years netPPE) timing dierences/this years net PPE this years tax rate. It may be notedthat deferred income taxes are revalued when the tax rate changes (the so-called liabilitymethod of accounting for deferred taxes). The precise steps of that revaluation will bementioned in Section 10 below. In the base case McKay scenario, there is actually no needfor such a revaluation, since the tax rate is the same in all historical and future years.However, in a sensitivity analysis one may wish to assume a dierent tax rate for futureyears, e. g., starting with year 1 (cf. Section 13 below). If so, there will be an error in thefree cash flow calculation, unless deferred income taxes are revalued.The ratio timing dierences/this years net PPE can be set in the same fashion asin the previous three sections. That is, a value for the first year of the explicit forecastperiod is set as an average of the corresponding historical values. A value for the lastyear of the explicit forecast period is specified through steady-state considerations, likethe values for the ratios relating to PPE. Values for intermediate years are then fixed bylinear interpolation. This procedure has been followed in the McKay example.As already indicated in Section 6, the life of the PPE for depreciation for tax purposesis denoted by q. It is obviously assumed that q0. The first term in J represents accumulated fiscal depreciation for PPE cohortsthat have not yet been written down to zero for tax purposes, the second term accumulatedfiscal depreciation for those PPE cohorts that have already been written down to zero fortax purposes but have not yet been retired, and the third term accumulated depreciationover the economic lives for PPE cohorts that have not yet been retired. (Cf. the remarkat the end of Section 3 to the eect that non-zero timing dierences are related to non-retired PPE cohorts only; cf. also equation (2) in Section 6 for part of the derivation.) Ifc =0,thenJ =0.5(q 1) + (n q) 0.5(n 1).The formula for J is contained in cell S171 in Table 8. Equation (4), the steady-state ratiotiming dierences/this years net PPE in the last year of the explicit forecast period, iscontained in cell S172.9 Forecast assumptions relating to discount rates andfinancingConsider now the interest rate items in Table 8. The nominal borrowing rate is“one plus the real rate multiplied by one plus expected inflation minus one”. McKaysreal borrowing rate is apparently forecasted to be 5.60% in all future years. Expectedinflation has already earlier been forecasted to remain at 3% in future years. The nominalborrowing rate is hence (1+0.0560)(1+0.03)1=8.77% (rounded).12Incidentally, theforecasted nominal borrowing rate is assumed to be the going market rate for companiesin McKays risk class. This means that the market value of the interest-bearing debt isequal to the book value. In the valuation of the equity as a residual, the book value ofthe interest-bearing debt is subtracted from the value of the firms assets. This procedureis correct only because of the equality between market and book debt values when thenominal borrowing rate is the same as the going market rate.For calculating the WACC, the cost of equity capital, also referred to as the requiredrate of return on equity, is also needed. The real cost of equity capital is apparentlyassumed to be 11.40%. The nominal cost of equity capital then becomes (1 + 0.1140) (1+0.03)1=14.74% (rounded). It should be emphasized that the cost of equity capital,12It is assumed that the before-tax real borrowing rate remains constant under varying inflation expec-tations. A dierent relationship between the nominal borrowing rate and expected inflation is obtained,ifoneassumesthatitistheafter-tax real borrowing rate that stays constant under varying inflationexpectations. See Howe 1992 for a discussion of this issue. The assumption made here, that the before-tax real borrowing rate remains constant as inflation expectations change, seems to agree with empiricalfindings (Howe 1992, p. 34).19as well as the borrowing rate, is not independent of the debt and equity weights that enterinto the WACC.13If those debt and equity weights are varied, then the borrowing rateand cost of equity capital should be varied as well. However, the precise relationshipbetween, on the one hand, the debt and equity weights entering into the WACC and,on the other hand, the borrowing rate and cost of equity capital that also enter into theWACC is left unspecified in this tutorial. Hence, there is not much explicit modelling ofthe borrowing rate and cost of equity capital in Table 8. It should be noted, though, thatboth of these interest rate items depend on assumed inflation. If inflation increases, thenso do the nominal borrowing rate and nominal cost of equity capital.The next-to-last item in Table 8 is book value target for financial strength. Financialstrength is defined as (invested capital minus interest-bearing debt) divided by investedcapital (it is recalled from Section 3 that invested capital equals working capital plus netPPE). This ratio apparently refers to McKays financing policy. The financing policy is themeans to guarantee that there will be an equality between the assets and liabilities sidesof the forecasted balance sheets. More precisely, total common equity or interest-bearingdebt must be determined as the residual.The following financing policy has been assumed for McKay: The companys recentperformance has been rather shaky, as evidenced by the fact that the ratio debt/investedcapital at the bottom of Table 2 has increased substantially. McKay should try to reducethat ratio and hence improve its financial strength over the coming years (as viewed fromthe date of valuation, Jan. 1 of year 1). For that purpose, no dividends will be paid at all,as long as financial strength is below the target in row 181 of Table 8. Otherwise, maximaldividends are paid out, while still keeping financial strength as required. Obviously, thisis only intended as one example of a financing policy that can be incorporated into thediscounted cash flow model. A book value target for financial strength can convenientlybe adjusted to provide a target capital structure in market value terms in the first yearof the post-horizon period.14Consequently, there is a book value target for financial strength. Borrowing as well asdividends are adjusted to reach that target (however, negative dividends are not allowed).Deferred income taxes are viewed as part of equity in the discounted cash flow model (cf.also Brealey et al. 2006, p. 513). Hence, deferred income taxes are not subtracted inthe calculation of equity value as a residual. McKays book value target for financialstrength in row 181 in Table 8 can therefore be restated as follows: The sum of the three13As will be seen below (Section 12), those weights are specified in terms of a target capital structurein market value terms in the first year of the post-horizon period. The same weights are then applied inall of the years of the explicit forecast period, and in all later years of the post-horizon period.14In fact, the book value target for financial strength 56.7% mentioned below has been selected so as toreach a target capital structure in market value terms in year 12 of 50% equity and 50% debt (cf. Section12).20items deferred income taxes, common stock, and retained earnings on the liabilities sideof the balance sheet should equal 56.7% of invested capital. Equivalently, interest-bearingdebt should be 43.3% of invested capital. Apparently, the assumption is that book valuefinancial strength should be the same each year.The financial structure of the firm, including the dividend policy, does not aect thecomputed free cash flow. The financial structure does aect the valuation of free cashflow, though, through the WACC computation.15The final item in Table 8 is this years short-term interest-bearing debt/last yearslong-term interest-bearing debt. This ratio only serves to divide total interest-bearingdebt in the forecasted balance sheets into short-term and long-term. It does not have anyeect on the valuation in the McKay example, since the nominal borrowing rate does notdepend on loan contract length.There are no further assumptions for forecasting income statements and balance sheetsin Table 8. However, two additional assumptions have been incorporated directly into theforecasted financial statements, i. e., not by way of ratios in Table 8. It is directly assumedthat there will be no new issue of equity (i. e., the item common stock in the balancesheets remains at the same level as in the last historical year). Also, the excess marketablesecurities are assumed to remain at zero in all forecasted balance sheets.10 Forecasted income statements, balance sheets, andfree cash flowWith the forecast assumptions in Table 8 and the additional assumptions that werenoted in the previous section, we can now construct the forecasted income statements inTable 5 and forecasted balance sheets in Table 6 for years 1 to 12. Revenues in Table 5 are(last years revenues)(1 plus revenue growth) (revenue growth is taken from Table 8).Operating expenses are revenues multiplied by operating expenses/revenues (also fromTable 8). Depreciation in Table 5 is last years net PPE multiplied by depreciation/lastyears net PPE (from Table 8). Interest income is equal to last years excess marketablesecurities multiplied by the nominal borrowing rate (i. e., McKay is assumed to earn theborrowing rate on its excess cash; however, in this case the result is zero since the excessmarketable securities are set to zero in the last historical year and in all future years).Interest expense is the assumed nominal borrowing rate (from Table 8) applied to thesum of last years short-term and long-term debt.The item revaluation of deferred income taxes in Table 5 is obtained by recomputing15Financial structure may aect computed free cash flow in more complex situations, for instance ifthe company has tax-loss carry-forwards.21last years deferred income taxes in accordance with this years tax rate and subtractingthe result from last years deferred income taxes as stated in last years balance sheet. Therecomputation part consists of dividing last years deferred income taxes by last yearstax rate (from Table 4 when the last year is year 0 and otherwise from Table 8) to obtainlast years timing dierences, and then multiplying those timing dierences by this yearstax rate (from Table 8). Income taxes in Table 5 are computed by applying this yearstax rate from Table 8 to earnings before taxes (i. e., not including revaluation of deferredincome taxes).The statement of retained earnings is completed by invoking the book value targetfor financial strength that was formulated in the previous section: The sum of deferredincome taxes, common stock, and retained earnings should be 56.7% (rounded) of investedcapital. However, negative dividends are not allowed (and by assumption a new issue ofequity has also been ruled out). This means that ending retained earnings are set as theminimum of the following two:(Beginning retained earnings) + (net income),0.567(invested capital) (deferred income taxes) (common stock).Consequently dividends are the residual item in a forecasted statement of retained earn-ings:Dividends = (beginning retained earnings) + (net income) (ending retained earnings).The items in the forecasted balance sheets, Table 6, are to a large extent directlydriven by revenues. That is, they are given by revenues multiplied by the relevant forecastassumptions in Table 8. This holds for the majority of the current assets items and forother current liabilities. Inventories and accounts payable are driven by operating expenses(and excess marketable securities are directly set to be zero; cf. Section 9).Net PPE is also driven by revenues. Accumulated depreciation is last years accu-mulated depreciation plus this years depreciation (from Table 5) minus this years re-tirements. This years retirements equal (last years net PPE)retirements/last yearsnet PPE (from Table 8). Gross PPE is then calculated as net PPE plus accumulateddepreciation. It is again pointed out that gross PPE and accumulated depreciation areactually not needed. That is, rows 46 and 47 in Table 6 could have been left blank.Short-term debt is specified as a fraction (from Table 8) of last years long-term debt.Deferred income taxes are specified as (this years net PPE) timing dierences/thisyears net PPE this years tax rate, as already mentioned in Section 8 above. Commonstock is set to be the same as in year 0, as already explained. Retained earnings arecopied from the same item in the statement of retained earnings in Table 5. Long-termdebt then becomes the residual item, to obtain equality between assets and liabilities in22each forecasted balance sheet. It is seen at the bottom of Table 6 that the 43.3% targetfor debt to invested capital that is implied by the book value target for financial strengthis reached in year 3, and that the ratio NOPLAT/invested capital is expected to besomewhat better on average than in recent historical years. All items in the forecastedincome statements and balance sheets should be interpreted as expected values undersome scenario.Finally, forecasted free cash flow for each year 1 to 12 is displayed in Table 7. Thattable is derived from Tables 5 and 6 in essentially the same fashion as Table 3 is derivedfrom Tables 1 and 2. The item revaluation of deferred income taxes was not commentedon in Section 3. By including that item in the free cash flow calculation, one obtains thecorrect result that the revaluation does not aect free cash flow.By depreciating PPE for tax purposes over a time period shorter than the economiclife, a company can decrease its eective tax rate below the nominal rate, as long asnominal revenues are increasing. At the bottom of Table 7, the eective rate of taxespaid on EBIT is exhibited. That rate is computed by dividing (taxes on EBIT) minus(change in deferred income taxes) minus (revaluation of deferred income taxes) by EBIT.In steady state, the eective tax rate is apparently 36.2%, i. e., not much lower than thenominal rate of 39%.11 Another system for tax accountingThe particular system for accounting for deferred income taxes that has been discussedin previous sections is a somewhat extended interpretation of the tax accounting systemin the original Preston example in Copeland et al. 1990 and Copeland et al. 1994. Afairly similar tax accounting system is often used by Swedish company groups. In thissection, a somewhat dierent tax accounting system is considered. Individual Swedishcompanies often use something like this alternative system. A print-out from the fileMCK B.XLS, containing the McKay example under the alternative tax accounting sys-tem, is also included at the end of this tutorial. It is seen that MCK B.XLS is very similarto MCK.XLS. That is, it consists of the same Tables 1 to 8, and with the same valuecalculation part at the end.Under the tax accounting system in MCK B.XLS, timing dierences appear as anuntaxed reserve on the liabilities sides of the balance sheets, replacing the item deferredincome taxes on the liabilities sides of the balance sheets in MCK.XLS. The forecastassumptions for timing dierences are exactly the same under the two tax accountingsystems. In particular, the ratio timing dierences/this years net PPE is exactly thesame in both cases.The increase or decrease in timing dierences appears as an item in the income state-23ments, before income taxes. As a consequence, the layout of the calculation of free cashflow changes slightly. It is seen that the resulting free cash flow is the same in both cases(compare row 111 of MCK B.XLS with row 107 of MCK.XLS). This is of course onlywhat one would expect, since the underlying tax rules (for instance, the life q for fiscaldepreciation) are the same. The free cash flow calculation in MCK B.XLS is actuallysomewhat simpler than the corresponding calculation in MCK.XLS, since in the formerthere is no need for a revaluation of deferred income taxes, if there is a change in the taxrate.In the forecasted statements of retained earnings in MCK B.XLS, ending retainedearnings are set as the minimum of the following two:(Beginning retained earnings) + (net income),0.567(invested capital) (timing dierences) (common stock).In all of the historical years 6 to 0, the sum of the two items timing dierences andretained earnings in the balance sheets of MCK B.XLS is equal to the sum of deferredincome taxes and retained earnings in the balance sheets of MCK.XLS. The same alsoholds for all forecasted balance sheets, as a consequence of the very similar conditionon ending retained earnings that is imposed under both tax accounting systems. It alsofollows that each years common dividends are the same in both cases, even though netincome is not. The financial cash flow computations give identically the same result, itemby item, in the two cases.It may be added that the treatment of taxes in this tutorial is somewhat simplistic inone respect. In deducting depreciation for tax purposes, one would normally have to checkthat such depreciation does not bring taxable income below zero. Also, taxes actuallypaid in a given year presumably cannot be negative. These conditions are satisfied in theMcKay forecasted income statements and balance sheets. However, explicit checks of theseconditions have not been included in MCK.XLS and MCK B.XLS. Indeed, looking at thehistorical income statements in the latter file, one notices that net income in year 1isactually negative (0.5). This indicates that the increase in timing dierences in that yearmay have been too big. This anomaly is not so clearly evident in the corresponding netincome for year 1 in MCK.XLS. The alternative tax accounting system in MCK B.XLSmay hence be somewhat more transparent in setting up forecasted income statements andbalance sheets in a valuation situation.12 Valuation of McKays equityWe now return to the file MCK.XLS. Having forecasted the free cash flow for eachyear of the explicit forecast period and the first year of the post-horizon period, it isnow possible to calculate the value of McKays equity. The value calculation part of the24spreadsheet file starts by repeating certain items that are necessary for that calculation,in particular: The book value of excess marketable securities at the beginning of eachforecast year, the book value of interest-bearing debt (short-term and long-term) also atthe beginning of each year, and the free cash flow. The latter is assumed to occur atthe end of each forecast year. As already mentioned in Section 9, the book value of theinterest-bearing debt is assumed equal to the market value. The same assumption is oftenalso imposed for excess marketable securities (however, that is not important here, sincethere are zero excess marketable securities in McKays balance sheets starting with year0).The general procedure is the following: To begin with, the value of the firms operationsis computed as of the beginning of the first year of the post-horizon period, i. e., at thehorizon. This value is obtained by the Gordon formula.16The free cash flow at the endof the first year in the post-horizon period (28.2) increases by a specified growth rateyear by year over an infinite number of years. (The specified growth rate in the McKayexample is 3%, due to inflation only, as already indicated earlier.) The WACC in the firstyear of the post-horizon period turns out to be 10.05% (rounded), so the result of theGordon formula is 28.2/(0.10050.03) = 400.2. How the WACC has been calculated willbe discussed in greater detail below. To the value of operations 400.2 is added the valueof excess marketable securities (0.0) at the same point in time, i. e., at the beginning ofthe first post-horizon period year. This gives the total value of the firms assets. Fromthat total asset value is deducted the value of interest-bearing debt (200.1). The resultingequity value (including deferred income taxes) is 200.1. The debt and equity values areapparently equal. This is no coincidence, since a target capital structure in market valueterms of 50% equity and 50% interest-bearing debt has, in fact, been assumed, as will beseen shortly.After that, a similar calculation is performed for the immediately preceding year, i.e., the last year of the explicit forecast period. The value 400.2 of the operating assetsat the beginning of the following year, which is also the end of the current year, plus thefree cash flow at the end of the current year (30.9) are discounted to the beginning of thecurrent year, using the current years WACC. Again, this provides the value of the firmsoperations (391.7) at the beginning of the current year. Adding the excess marketablesecurities at the same point in time (0.0) and subtracting the debt value (195.9), oneobtains the equity value at the beginning of the current year (195.8). The computationsproceed in this manner, by discounting backwards year by year, until one reaches the16Applying the Gordon formula to value the operations at the outset of the post-horizon period appar-ently assumes (among other things) an even age distribution of successive PPE cohorts. As mentionedin Section 7, that assumption cannot be expected to hold exactly. This inconsistency is usually notimportant. However, it is possible to set up a more complex infinite discounting formula that accountsfor the precise timing of capital expenditures, cf. Jennergren 2004.25beginning of the first year of the explicit forecast period which is also that moment intime when the valuation is done. Jumping to the conclusion, it is seen that McKaysequity (again including deferred income taxes) is valued in cell I203 at 93.8 as of Jan. 1year 1.17The computations apparently proceed backwards one year at a time. The value of thefirms operations at the beginning of any one year in the explicit forecast period is thepresent value of the sum of the value of the operations at the beginning of the followingyear plus this years free cash flow. It is not dicult to see that this way of steppingbackwards one year at a time gives the same result as directly discounting all yearly freecash flow amounts to a present value as of Jan. 1 year 1. However, the procedure suggestedhere is more general, since it permits the computation of equity value at the beginning ofeach year in the explicit forecast period, not only at the beginning of year 1. This maybe of interest; cf. row 203 of the value calculation part of the spreadsheet file.The specification of the WACC is the standard one, well known from corporate financetexts. It is again convenient to introduce some notation:E market value of equity,D market value of debt,rEnominal required rate of return on equity,rDnominal cost of debt (assumed equal to nominal borrowing rate), tax rate.The WACC formula is then18rEED + E+ rD(1 )DD + E. (5)Equation (5) is the WACC formula that is used for the first year of the post-horizonperiod, year 12. The parameters rD, rE,and are given for each year in the forecastassumptions, Table 8. D and E are market values.19D is, by assumption, equal to thebook value of the interest-bearing debt.17Cell I207 contains the cum-dividend value of the equity, i. e., the equity value at the beginning of year1 plus dividends at the end of year 0 (these two points in time are obviously the same). The cum-dividendvalue will be referred to in Section 15.18It is seen that the WACC is obtained in this tutorial as a weighted average of the nominal requiredrate of return on equity and the nominal after-tax cost of debt. An alternative procedure would beto take a weighted average of the real required rate of return on equity and the real after-tax cost ofdebt, and then adjust for expected inflation. The procedure in this tutorial actually follows from theassumption, mentioned in a footnote in Section 9, that the before-tax real borrowing rate remains constantunder varying inflation expectations. The resulting value of WACC is somewhat lower than under thealternative procedure. Cf. again Howe 1992.19A comment on the terminology is called for here. In connection with valuation, “market value” isoften used as a sloppy abbreviation for “computed market value” or “value as calculated by the valuation26It is now possible to be more precise about the discounting operation in each year ofthe value calculation. For the first post-horizon period year, a desired market value weightof equity E/(D + E) is specified in cell I209. The corresponding market value weight ofdebt is hence D/(D +E)=1E/(D +E). Apparently, it has been specified in this casethat the target capital structure in market value terms should be 50% equity and 50% debt.Using those weights for debt and equity, the WACC is calculated in cell T199. It turns outto be 10.05%. With that WACC value, the value of the operating assets is determined(cell T201), as indicated earlier. To that value is added excess marketable securities.Next, interest-bearing debt is subtracted, meaning that the equity value is obtained asa residual. At this point, the resulting market value weight of equity is determined incell T211. (In other words, the contents of cell T211 is =T203/(T197+T203).) Cell I210contains a copy of cell T211.The simultaneity problem that was mentioned in Section 2 above is now resolved, ifthe resulting E/(D + E) in cell I210 is the same as the desired E/(D + E) in cell I209.Cell I212 contains the dierence between cells I209 and I210 multiplied by 100,000 (ahidden entry). The contents in cell I212 can be driven to zero, through a suitable choice,more precisely 56.7% (rounded), of the book value target for financial strength for year1incellI181(Table8). Ifthattargetischangedforyear1,italsochangesforyears2through 12, since it is the same for all years in Table 8. Driving the contents of cell I212to zero by adjusting cell I181 is most easily done using the Goal Seek procedure.Equality between cells I209 and I210 implies a solution to the simultaneity problem.Resolving that problem actually does not aect the WACC for year 12, since that discountrate is, in any case, already determined by the desired weight E/(D +E)thatisspecifiedin cell I209. Resolving the simultaneity problem only means adjusting the liabilities sideof the balance sheet for year 12, so that the book value of interest-bearing debt becomesequal to its computed market value (being 50% of the market value of the company). Atthe same time the balance sheets for all previous years are also adjusted, since the bookvalue target for financial strength changes for all years in the explicit forecast period aswell.The WACC for each year in the explicit forecast period is calculated according toformula (5) as well, however using the desired capital structure in market value terms withweights E/(E+D) and D/(E+D) as specified for the first year of the post-horizon period.This is in line with a recommendation by Koller et al. (2005, p. 323): The estimatedWACC should be founded on a target capital structure for the firm.20In this tutorial,model”. The idea is that a valuation model is used to calculate what the market value of the equitywould be under some scenario. The equity value E that enters into the WACC formula (5) should hencebe understood as the computed equity value according to the model, not the stock market value of theequity (if such a value can be observed).20The target capital structure considered here is in terms of market values. It is not the same as the27that target capital structure is supposed to be attained at the outset of the post-horizonperiod, when the company develops in a steady-state fashion.To summarize, the target capital structure is set for the first year of the post-horizonperiod. The same capital structure is then imposed for the WACC in all preceding years(i. e., all years in the explicit forecast period), and also for the WACC in all subsequentyears in the post-horizon period (through the Gordon formula discounting).It is not excluded that the WACC can vary over the years in the explicit forecastperiod, even though each years WACC uses the capital structure value weights E/(E+D)and D/(E + D) from the first year in the post-horizon period. The reason is, the othervariables that enter into the WACC calculation can vary over individual years. Indeed,the relevant interest rate items as well as the tax rate are specified for each year separatelyin the forecast assumptions in Table 8.With the model implementation suggested here, it is actually not even necessary toresolve the simultaneity problem that was mentioned above. That is, the capital structurein market value terms that is defined by the desired weight E/(D + E) for the first yearof the post-horizon period is sucient to specify the WACC for every single year in theexplicit forecast and post-horizon periods (given the other assumptions, i. e., borrowingrate, cost of equity capital, and tax rate). Free cash flow does not depend on the capitalstructure, as has already been mentioned in Section 9. Hence, the actual breakdown intodebt and equity of the liabilities sides of the forecasted balance sheets does not matter.The breakdown into debt and equity at the valuation date does matter (since equity valueis calculated as a residual), but that breakdown is taken from the last historical balancesheet, not from some forecast.There are apparently two applications of the Goal Seek procedure, the first one to setthe curve parameter relating to the intermediate years of this years net PPE/revenues,and the second one to set book value target for financial strength. A macro has beenrecorded to perform both Goal Seeks. In the file MCK.XLS, that macro is called bypressing Ctrl + Shift + G. In the file MCK B.XLS, it is called by pressing Ctrl + Shift+H.book value target for financial strength (interest-bearing debt should be 43.3% of invested capital) thatwas assumed in Section 9. However, the former is obviously related to the latter, since the latter is variedin the Goal Seek procedure, so that the former is attained in the first year of the post-horizon period. Itmay be noted that both the book value target for financial strength and the target capital structure inmarket value terms are satisfied every year of the post-horizon period.28Table A. McKay valuations under dierent scenariosNo. Description of scenario (a) (b) (c)1 Base case 93.8 400.2 94.62 + 1% real growth from year 10 93.7 415.7 94.63 + 1% inflation from year 5 86.8 414.4 89.14 1% operating expenses/revenues from year 1 168.8 512.9 164.45 + 1% operating cash/revenues from year 1 82.5 394.8 85.56 Capital intensity factor K 0.53 rather than 0.58 136.3 459.7 135.87 Economic life n of PPE 9 rather than 10 years 35.2 323.5 50.28 Tax rate 42% rather than 39% from year 1 82.1 381.2 84.79 Tax life q of PPE 6 years rather than 5 years 85.0 394.7 87.510 + 1% interest rates (borrowing and equity) from year 1 65.2 358.0 70.7Explanations:(a) Discounted cash flow model, equity value Jan. 1 year 1(b) Discounted cash flow model, value of the firms operating assets Jan. 1 year 12(c) Abnormal earnings model, equity value Jan. 1 year 113 Sensitivity analysis: Valuation under dierent sce-nariosThe value of McKays equity, found to be 93.8 in the previous section, is valid underthat particular base case scenario that is defined by the forecast assumptions in Table 8and the further assumptions (noted in Section 9) that were directly incorporated into theforecasted balance sheets.21Valuation results for some alternative scenarios are given inTable A. Columns (a) and (b) show results for the discounted cash flow model that hasbeen presented so far in this tutorial. The value in column (b) is the value of the firmsoperations at the beginning of the first post-horizon period year. Column (c) refers to theabnormal earnings model that is discussed in the following section.Scenario 2 calls for a 1% increase in the real growth rate starting year 10, as comparedto the base case scenario with zero real growth from that year. In other words, there isa growth opportunity under Scenario 2. It is seen that this growth opportunity has novalue, since the computed equity value at the beginning of the first year remains almostunchanged (it goes down very slightly, from 93.8 to 93.7). (Incidentally, it is unrealisticto imagine that real growth of revenues in the post-horizon period could be higher thanthe expected long-term real growth of the surrounding economy as a whole.)21Koller et al. (2005, pp. 105, 333) recommend an adjustment to account for the fact that free cash flowon average occurs in the middle of each year, not at the end. This is accomplished by compounding onehalf year forward the computed value of the operating assets at the date of valuation. The compoundingrate should be the first years WACC. In the McKay case, that would result in a calculated value of theoperating assets of 209.3 1.05025, equal to 219.8. Deducting the value of interest-bearing debt 115.5,one obtains the computed equity value 104.3 rather than 93.8. This recommendation is not followedhere, since the meaning of such an adjustment seems less clear for the other valuation models that areconsidered in the following two sections.29Table B. Cash flow from new investmentCash flow element 10 11 12 13 14 15 16 17 18 19 20Investment in PPE -58.0Investment inworking capital -7.2 -0.2 -0.2 -0.2 -0.2 -0.2 -0.3 -0.3 -0.3 -0.3 9.4Revenues 100.0 103.0 106.1 109.3 112.6 115.9 119.4 123.0 126.7 130.5Operating expenses -90.0 -92.7 -95.5 -98.3 -101.3 -104.3 -107.5 -110.7 -114.0 -117.4Taxes on revenuesminus expenses -3.9 -4.0 -4.1 -4.3 -4.4 -4.5 -4.7 -4.8 -4.9 -5.1Tax savings onfiscal depreciation 4.5 4.5 4.5 4.5 4.5Cash flow frominvestment -59.1 10.6 10.8 11.0 11.2 11.4 7.0 7.2 7.5 7.7 9.4The conclusion that growth has no value can be checked by direct calculation, as inTable B. That table considers a growth project, an investment in year 10 that is supposedto support revenues of 100 (arbitrarily scaled) monetary units starting that year. Thenecessary investment in PPE is then 58.0. Revenues increase by 3% per year, due toassumed inflation. The revenue stream goes on for 10 years, since that is the assumedeconomic life of the PPE. Operating expenses (being cash costs) are 90% of revenues.There is also investment in working capital, since the working capital items are drivenby, i. e., proportional to, nominal revenues and operating expenses, as already explainedin Section 4 above.22The investment in working capital is recouped at the end of theproject. The tax consequences of the project are also listed in Table B. The last line ofthat table contains cash flow from the project starting year 10 and ending year 20. Itmay be noted that the amounts in Table B pertain to year ends and have been roundedto one decimal point.If one discounts the cash flow in Table B to a present value at the beginning of year10, at the WACC that is valid for year 10 and later years under the base case scenario,10.05% (somewhat rounded), then the net present value is positive but extremely small(0.24). In other words, a growth opportunity has almost zero value, for instance becausethe forecasted ratio operating expenses/revenues is rather high. This conclusion can alsobe reached by comparing the internal rate of return of the growth project in Table B to theWACC. The internal rate of return is 10.16%, which is very close to the WACC 10.05%.23There is hence a very slight contradiction between the direct calculation and the resultof Scenario 2 in Table A. The former indicates a very small positive eect, whereas thelatter indicates a very small negative eect. The very small negative eect in Scenario 222The initial investment in working capital is 100 (2.0% + 11.3% + 1.1% + 1.8%90.0% + 1.6% 4.4%90.0% 6.3%) = 7.2 As nominal sales increase due to inflation, additional investment in workingcapital is needed during the following years until year 19.23In connection with firm valuation, the internal rate of return of a growth project is sometimes referredto as the cash flow rate of return (Koller et al. 2005, pp. 211-213).30comes about because the change in real growth of revenues aects the ratio this yearsnet PPE/revenues in the last explicit forecast period year, and then also that ratio in thepreceding years, through the interpolation. (It may be noted that the abnormal earningsmodel actually indicates no change in computed equity value in Scenario 2.)Scenario 3 considers a 1% increase in expected inflation, from 3% to 4%, from year5. This leads to higher nominal cash flow but also to a higher WACC (since inflationenters into the nominal borrowing rate and the nominal cost of equity). However, highernominal cash flow is not completely cancelled by a higher discount rate: Higher inflationincreases the requirement for working capital. Also, tax savings due to depreciation ofPPE do not increase in line with inflation, since they are based on the original acquisitionprices. It is seen that the eect of a modest increase in expected inflation is negative, butrather small. This is not the end of the inflation story, however, since the increase in thenominal borrowing rate leads to a decrease in the value of already existing fixed-interestdebt. In the base case scenario, all of the interest-paying debt has a nominal borrowingrate of 8.77%, and this is the going market rate for a company in McKays risk class (thatis why the book value of the debt could be deducted to arrive at the value of the equityas a residual). Suppose all of McKays debt is fixed-interest. If so, the value of the debtfalls, as inflation increases from 3% to 4%, due to the increase in the nominal borrowingrate. The value of the equity, being the residual, goes up. Consequently, an increasein inflation implies a value transfer from interest-bearing debt to equity. No such valuetransfer has been considered in Scenario 3. For the result of Scenario 3 to be valid, onemust hence assume that all of McKays debt is floating-rate.Scenario 4 shows that a 1% change in operating expenses/revenues has a very largeimpact on equity value. In fact, this ratio would seem to be the most critical forecast itemin Table 8. A 1% increase in the ratio of required working capital to revenues (exemplifiedin Scenario 5 by operating cash/revenues) apparently has a much smaller impact.Scenarios 6 and 7 consider eects of changes in assumptions as regards productiv-ity of PPE. A change in the capital intensity factor K aects the ratio this years netPPE/revenues in year 11 and also in earlier years, because of interpolation. A change inassumed economic life of PPE induces changes in that ratio and also in depreciation/lastyears net PPE and timing dierences/this years net PPE. The resulting impact onequity value is seen to be quite important in both cases.A moderate tax rate increase (Scenario 8) has only a moderate eect on computedequity value. Free cash flow is reduced, as the tax rate is increased, but there is acounteracting force through deferred income taxes. A tax rate change also finds its wayinto the WACC calculation, through formula (5) in the previous section. An increase inthe assumed life of PPE for tax depreciation purposes from 5 to 6 years also results in afairly small decrease in value of McKays equity (Scenario 9).31Scenario 10 emphasizes the importance of a single percentage point in the discount rate(WACC) in connection with firm valuation. A 1% increase in the discount rate without anaccompanying increase in expected inflation could come about through similar increasesin the real borrowing rate and the real cost of equity capital. The previous caveat aboutall the debt being floating-rate applies here, as well.14 The abnormal earnings modelNow consider the abnormal earnings model. According to this model, computedequity value is equal to book equity value plus the present value of all abnormal earnings.Discounting is done using the required rate of return on equity. The second half of thevalue calculation part of the spreadsheet file lists information that is necessary for applyingthe abnormal earnings model, in particular the book equity value at the beginning ofeach forecast year and the net income, assumed to occur at the end of each forecast year.Interest-bearing debt at the beginning of each forecast year is also listed. These items arecopied from Tables 2, 5, and 6 above.The discounting procedure for abnormal earnings is actually fairly similar to the pro-cedure for free cash flow. The required rate of return on equity is 14.74% in the firstyear of the post-horizon period, taken from Table 8. Abnormal earnings are equal to theyears net income minus a capital charge, the latter being the product of the requiredrate of return on equity and the book equity value at the beginning of the year. Thatis, 0.0 in cell T225 equals 29.5 0.1474200.1 (after rounding; the value is actuallyvery slightly negative). Abnormal earnings in the first post-horizon period year are hence0.0. Abnormal earnings then increase exactly by the assumed nominal growth rate 3%in subsequent years of the post-horizon period. In other words, abnormal earnings inthe second post-horizon period year are 0.01.03, etc. The present value at the begin-ning of the first post-horizon period year of all subsequent abnormal earnings is therefore0.0/(0.14740.03) = 0.1 (cell T227). This is evidently another application of the Gor-don formula. Computed equity value at the beginning of the first post-horizon period yearis equal to the sum of book equity value at the beginning of that year and the presentvalue of all subsequent abnormal earnings. That is, 200.1 in cell T229 equals 200.1 +(0.0/(0.14740.03).After that, the present value of all subsequent abnormal earnings is computed forthe immediately preceding year, i. e., the last year of the explicit forecast period, as(0.8+(0.1)/(1+0.1474) = 0.8 in cell S227. The computed value of equity at thebeginning of the last explicit forecast period year in cell S229 equals book equity value atthe beginning of the same year plus the present value of all subsequent abnormal earnings(in cell S227). One proceeds in this fashion, one year at a time and backwards, until one32reaches the beginning of the first year of the explicit forecast period, which is also themoment in time when the valuation is done. Apparently, the equity value is found to be94.6 as of Jan. 1 year 1.As in the discounting of free cash flow in the discounted cash flow model, the com-putations proceed backwards one year at a time. Again, stepping backwards one yearat a time in the fashion outlined in the previous paragraph provides the same result asdirectly discounting all yearly abnormal earnings and adding to the book equity value atthe beginning of year 1.A target market value weight of equity E/(D + E) is specified in cell I231. As inSection 12, this means that a target capital structure in market value terms has beenspecified for the first year of the post-horizon period. With the required rate of return onequity as specified in Table 8 for the same year, equity value is computed in cell T229, asalready explained above.24At this point, the values of debt and equity in cells T220 andT229 are used to compute the resulting market value weight of equity, in cell T233. Fromthere, it is copied to cell I232. Cell I234 contains the dierence between cells I231 andI232 multiplied by 100,000 (a hidden entry). Just as in Section 12, that dierence can bedriven to zero by adjusting the book value target for financial strength for year 1 in cellI181 (Table 8). (Again, it is convenient to do this by the Goal Seek procedure.) In otherwords, the simultaneity problem that was mentioned in Sections 2 and 12 is resolved. InSection 12, it was actually not necessary to resolve that simultaneity problem. That isnot so here. In other words, in the abnormal earnings model it is necessary to adjustinterest-bearing debt so that the resulting market value weight of equity agrees with thedesired market value target capital structure.One can now compare the discounted cash flow model and the abnormal earningsmodel when applied to the McKay example. The underlying forecast assumptions andforecasted income statements and balance sheets are the same (assuming that the simul-taneity problem is actually resolved under the discounted cash flow model). The calcula-tion of free cash flow in Table 7 is evidently not needed for the abnormal earnings model.Apparently, the discounted cash flow and abnormal earnings models do not give exactlythe same computed value of McKays equity as of Jan. 1 year 1. However, the sum of debtand equity values at the beginning of the first post-horizon period year, as resulting fromthe abnormal earnings model, is precisely equal to the value of the firms operating assetsat the same point in time, as resulting from the discounted cash flow model.25Again, this24It is again pointed out that the required rate of return on equity capital is not independent of thetarget market value weight E/(D + E). However, the precise nature of that dependence is not specifiedin the model.25Strictly speaking, it is the firms operating assets plus excess marketable securities according tothe discounted cash flow model that have the same value as the sum of debt and equity according tothe abnormal earnings model, at the beginning of the first post-horizon period year. However, excess33follows since abnormal earnings increase exactly by the assumed nominal growth rate,starting in the second year of the post-horizon period. The dierences between columns(a) and (c) in Table A are hence entirely due to dierent treatments of the explicit forecastperiod.It may also be noted that the abnormal earnings model in file MCK B.XLS givesexactly the same result (computed equity value) as the corresponding model in fileMCK.XLS. In other words, even though each years net income changes with the changein tax accounting system (compare row 21 of MCK B.XLS with row 18 of MCK.XLS),there is no change in computed equity value. The significant observation is that forecasteddividends are the same under both tax accounting systems. Equity value can obviously bedetermined by discounting forecasted dividends by the required rate of return on equity, i.e., by the discounted dividends model. The forecasted dividends and the required rate ofreturn on equity are the same between MCK.XLS and MCK B.XLS, so the equity valuethat is obtained by that model must be the same under both tax accounting systems. Itis also known that the abnormal earnings model is equivalent to the discounted dividendsmodel. Hence, the abnormal earnings model clearly must provide the same computedequity value under both tax accounting systems.15 A new financing policy, and a family of valuationmodelsThe discussion in this section refers to the file MCK EXT.XLS. Compared to theMcKay valuation earlier in this tutorial, there are two new features (otherwise there areno changes from the file MCK.XLS).In the first place, the financing policy that is adopted now prescribes that the equityweight in the capital structure should be 50% in market value terms in every single year,including all years in the explicit forecast period. Consequently, the book value targetfor financial strength that is varied in MCK.XLS to attain the desired capital structurein market value terms at the beginning of the first post-horizon period year is deleted.Instead, each years long-term debt in row 62 is set so that the resulting market valueweight of equity is equal to the desired market value weight that is valid for that year(except in year 12; see below). The year by year desired market value weights for equityare specified in row 207. The resulting market value weights are computed in row 208.Row 209 contains the squared deviations between rows 207 and 208. In cell I210, all ofthe elements in row 209 are summed, and the sum is multiplied by 1,000,000 (a hiddenentry). The value of cell I210 is driven to zero through the Excel Solver, by adjustingmarketable securities are by asumption zero in the case of McKay.34each years long-term debt in cells H62 through S62. Total common equity (row 69) thenbecomes the balance sheet residual. This means that dividends (row 27) or new shareissue (row 28) are the residual items in the statements of common equity. Since thereis now the possibility of new share issues, the statements of retained earnings in Table1 of the file MCK.XLS have been expanded to statements of (total) common equity inMCK EXT.XLS.Apparently, this means that the long-term debt in the last historical year (in cell H62)is also adjusted, so that the capital structure in market value terms becomes 50% debtand 50% equity at the start of year 1 (which is equal to the end of the last historicalyear). Comparing the computed equityvalueatthestartofyear1inMCKEXT.XLS(cell I201) and in MCK.XLS (cell I203), it is seen that the former is 104.6 and the latter93.8. However, the long-term debt in MCK EXT.XLS in the last historical year is smallerthan that of MCK.XLS. In fact, comparing the dividends in the last historical year ofMCK EXT.XLS and MCK.XLS, it is seen that there is a dividend paid out in MCK.XLSof 2.9. In MCK EXT.XLS, there is a new share issue of 8.0, shown in cell H28. Thecum-dividend equity values at the start of year 1 in cell I205 of MCK EXT.XLS and incell I207 of MCK.XLS are exactly equal, 96.7. In a certain sense, the two financing policiesin MCK.XLS and MCK EXT.XLS are therefore equivalent.26When the long-term debt in the last historical year (in cell H62 of MCK EXT.XLS)is set to attain the target capital structure in market value terms, total common equityin the last historical year (in cell H69) becomes the balance sheet residual. The commondividends or the new share issue in year 0 are then determined through the statement ofcommon equity for that year. In other words, the computed value of the equity 104.6 atthe beginning of year 1 in MCK EXT.XLS pertains to a situation where the owners havealready contributed equity capital to reach the desired capital structure in market valueterms at the beginning of year 1.27The second new feature of MCK EXT.XLS is that it includes valuations by five dif-ferent models, the first one being free cash flow. The second one is adjusted present value(cf. Brealey et al. 2006, pp. 521-525; Ruback 2002). The opportunity cost of capital (i. e.,the cost of capital under the assumption of financing by equity capital only) is computedyear by year in row 220 asrEED + E+ rDDD + E.As in equation (5) above (Section 12), D and E are market values.28Note the dierence26The designation cum-dividend equity value is used by Penman (2007, p. 79), among others.27The long-term debt at the end of year 12 (the first year of the post-horizon period) is set by imposingthe same book value ratio between interest-bearing debt and invested capital in year 12 as in year 11(cell S75), since that ratio does not change in the post-horizon period.28On the meaning of market values, see again footnote 19 in Section 12.35compared to (5): The debt term is not multiplied by (1 ). The opportunity cost ofcapital is used to discount free cash flow. It is also used to discount the tax shields frompartial debt financing. Using the opportunity cost of capital rather than the borrowingrate for tax shield discounting is appropriate here, since it is an underlying assumptionthat the capital structure in market value terms will be rebalanced in every single year toconform to the equity weight of 50%. As in the free cash flow model, the equity value isobtained by deducting the value of the interest-bearing debt from the computed value ofthe operating assets including tax shields.The third model is economic value added. Economic value added in each year isNOPLAT minus a capital charge, given by WACC times the years starting investedcapital (cf. Koller et al. 2005, pp. 116, 184; these authors use the designation economicprofit). The value of the operating assets is then equal to the years starting investedcapital plus the present value of all (year by year) subsequent economic value added.Deducting the value of the interest-bearing debt, the equity value is obtained as a residual,like in the free cash flow model.The fourth model is discounted dividends. Dividends are obtained from rows 27 and28 (in the statements of common equity; new issues are considered as negative dividends)and are discounted to a present value using the required rate of return on equity. Thefifth model is abnormal earnings which is already familiar from Section 14.29It is noted that all five models give identical results. In other words, the computedequity value is equal to 104.6 in all five cases. It is well known that a variety of valuationmodels provide identical results, given that one is consistent (cf. Levin 1998, Young et al.1999). More precisely, the five models can be divided into three groups, (i) the discountedcash flow and the economic value added models; (ii) the adjusted present value model;and (iii) the discounted dividends and the abnormal earnings models. It is known thatthe economic value added model is equivalent to the free cash flow model. Hence, thesetwo models always give identical results. Also, the abnormal earnings model is equivalentto the discounted dividends model, as was already mentioned in the previous section.However, equivalence between the three groups of models holds only under some consis-tency condition. Consistency is satisfied in this case, since the desired capital structurein market value terms is imposed in every single year, in particular in every single year ofthe explicit forecast period. Consistency is not satisfied in MCK.XLS, and therefore thediscounted cash flow and abnormal earnings models do not lead to identical computedequity values in that file.In MCK EXT.XLS, there is apparently one application of the Goal Seek procedure toset the curve parameter for the non-linear interpolation of this years net PPE/revenuesin intermediate explicit forecast period years, and one application of the Solver to reach29Rows 249, 250, 270, and 271 are references to a companion tutorial, Skogsvik 2002.36the target capital structure in market value terms in every forecast year. A macro hasbeen recorded that executes both applications. That macro can be called by pressing Ctrl+ Shift + I.16 Concluding remarksIt is now clear that the discounted cash flow model cannot be viewed as a preciseprescription of how to proceed when valuing a company. A similar remark also holds forother valuation models, like the abnormal earnings model. On the contrary, a number ofmodelling choices must be made when implementing a valuation model. In conclusion,some of those choices will be commented on.McKays excess marketable securities were assumed to be sold o already during thelast historical year, i. e., they were set to zero in all forecast years. This is a convenientassumption for the purpose of valuation, at least for a company with only a moderateportfolio of such securities, and even if there is no actual intention on the part of thecompany to dispose of that portfolio. The financing policy that was initially assumed inthe McKay example, to use an adjustable book value target for financial strength to attaina target capital structure in market value terms in the first year of the post-horizon period,is only one of several possible choices. Section 15 illustrated another possible financingpolicy.It has been indicated above (Sections 5 - 8) how free cash flow in the post-horizonperiod can be forecasted in a consistent fashion, through particular settings of forecastratios relating to PPE and deferred income taxes in the last year of the explicit forecastperiod. It is not so easy to specify what are consistent forecast ratios in the earlier yearsof the explicit forecast period. This tutorial has suggested the heuristic device of settingthose ratios through interpolation starting from historical averages at the beginning ofthe explicit forecast period.For discounting in the post-horizon period, this tutorial has used the Gordon formula.Koller et al. (2005, pp. 110-111, 273-275) favor a dierent approach, the so-called valuedriver formula (discussed in Appendix 2). They admit that either formula is in a technicalsense equivalent to the other. However, applying the Gordon formula (referred to as thefree cash flow perpetuity formula by these authors) is tricky, leading to mistakes by manyanalysts. They say that “The typical error is to incorrectly estimate the level of free cashflow that is
温馨提示
- 1. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
- 2. 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
- 3. 本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
- 4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
- 5. 人人文库网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
- 6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
- 7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 瓷砖铺贴工岗位面试问题及答案
- 2025届河南天一大联考高一化学第二学期期末预测试题含解析
- 培养质量评价管理办法
- 医药产品登记管理办法
- 权力清单管理办法丽水
- 办公区域日常管理办法
- 民航安检道口管理办法
- 北京特殊班级管理办法
- 碳中和目标下锂离子电池健康状态评估体系构建研究
- 医疗器材资质管理办法
- (高级)数据安全管理员职业技能鉴定考试题库-实操题
- 初三化学上册第一单元测试题(含答案)
- 移动通信网络优化服务合同
- (正式版)SH∕T 3548-2024 石油化工涂料防腐蚀工程施工及验收规范
- JBT 14449-2024 起重机械焊接工艺评定(正式版)
- DL-T5017-2007水电水利工程压力钢管制造安装及验收规范
- 海上风电场选址与环境影响评估
- 《陆上风电场工程概算定额》(NB-T 31010-2019)
- 《早期教育概论》课程标准
- 药物分析年终述职报告
- 农发行信贷业务考试题库题库附答案
评论
0/150
提交评论