CS代考计算机代写 finance Excel ACCT6101 – Session #1: Introduction to Valuation
ACCT6101 – Session #1: Introduction to Valuation
PART 1 – Background
1
ACCT7106 – Session #11: Forecasting & Valuation
overarching objective:
to conduct the fundamental valuation exercise for the purpose of estimating the ‘intrinsic value’ of a firm’s common shares
requires an understanding of the firm’s ‘value drivers’
need to accumulate a ‘tool kit’ as the basis for developing the pro forma Financial Statements
1
2
projected over the forecast horizon
core inputs into the valuation model x g
Balance Sheet (B/S)
Income Statement (I/S)
Statement of Cash Flows (SCF)
2
3
STEP 1
Understanding the past
Information collection
Understanding the business
Accounting analysis
Financial ratio analysis
Cash flow analysis
STEP 2
Forecasting the future
Structured forecasting
Income Statement forecasts
Balance sheet forecasts
Cash flow forecasts
STEP 3
Valuation
Cost of capital
Valuation models – AE, FCF, D
Valuation ratios
Complications
Negative values
Value creation and destruction
Figure 1.1 Lundholm & Sloan, Framework for Equity Valuation
Sessions #3 #10
Sessions #10 #11
Sessions #1 #3; #11 – #13
4
beginning stock
Beginning Balance Sheet
Cash
+ Other assets
= Total Assets
– Liabilities
= Shareholders’ Equity (BVt-1)
Statement of Changes in S/E
Cash from operations
+ Net Income & OCI
= Net Change in S/E
Cash Flow Statement
Cash from operations
+ Cash from investing
+ Cash from financing
= Net change in cash
Income Statement
Revenue
– Expenses
= Net Income (NPAT)
Ending Balance Sheet
Cash
+ Other assets
= Total Assets
– Liabilities
= Shareholders’ Equity (BVt)
flows
ending stock
‘articulation’ Financial Statements constitute an ‘integrated system’
5
Forecasting & Valuation
Objective of the forecasting exercise
to develop objective and realistic expectations of future value-relevant payoffs
How?
develop pro forma F/S containing unbiased predictions of the firm’s future operating, investing, and financing activities should be neither conservative nor optimistic
pro forma F/S should be comprehensive need to consider the growth rate for each item, not just assume items will grow at a constant rate with sales
need to make consistent assumptions and maintain the relation between items in the pro forma F/S (i.e., the F/S represent an integrated system, both reported and pro forma)
use external information to ensure that assumptions are realistic
6
Steps comprising the Forecasting Exercise
Income Statement:
Step 1: Forecast Sales
Step 2: Forecast Core OI from Sales (before tax)
Step 3: Forecast Core Other OI (before tax)
Step 4: Calculate OI (before tax)
Step 5: Forecast Income Tax Expense attributable to OI
Step 6: Calculate OI (after tax)
Balance Sheet:
Step 7: Forecast OA and OL to obtain a forecast of NOA
7
Unlevered Valuation valuing the firm
Step 8: Calculate RNOA, FCF and residual operating income (ReOI)
Step 9: Estimate the DCF and ReOI models with assumed terminal growth rate and firm’s weighted average cost of capital (WACC ) overall value of the firm
Step 10: Forecast Leverage and NFE (after tax)
Step 11: Calculate CI = OI (after tax) – NFE (after tax) & CSE = NOA – NFO
Step 12: Forecast Dividends (div = CI – S/E NCC)
Levered Valuation valuing common equity (value of common shares)
Step 13: Calculate RI (residual income or abnormal earnings)
Step 14: Estimate the DDM and RI models with assumed terminal growth rate (g) and cost of equity capital (k) value of the firm to the common shareholder
8
PART 2 – Foundation for Forecasting
central focus – estimation of intrinsic value
selected approach to ‘valuation’ – fundamental analysis
core valuation model – residual income (abnormal earnings) based on the ‘reformulated F/S’
+
where now residual earnings = (ROCE – cost of equity capital BVt-1)
= (ROCEt – COEC) BVt-1 (dividing both terms by S/E and then multiplying by S/E)
value driven by growth in ‘abnormal’ earnings = AEt – AEt-1
9
residual earnings = (ROCEt – COEC) BVt-1
support growth in abnormal earnings arises from
growth in ROCE (i.e., profitability)
growth in S/E
beginning with ROCE (profitability) i.e., ROCE =
informed by the ‘financial leverage equation’ and the ‘DuPont System’ i.e.,
ROCE = RNOA + FLEV x ( RNOA – NBC) = {profit margin asset turnover} + {FLEV spread}
drivers
operating profit margin
asset turnover
leverage
spread
10
further, in terms of the ‘income’ measures
Comprehensive Income (CI) = Operating Income (OI) – Net Financing Expenses (NFE)
where further
core operating income from sales
OI = + core other operating income
+ unusual operating income
sustainable (core) earning earnings that can repeat in the future and grow
form the basis for growth
transitory earnings (unusual items) earnings based on temporary factors
have no bearing on future earnings or earnings growth
11
central focus on ‘sustainable (core) earning’ as the basis for growth
core operating income & core net borrowing costs
need to identify items that will have no bearing on the future so that they can be removed and the focus returned to the ‘core items’
12
Identifying sustainable earnings: Items to consider
Deferred revenue – timing of recognition can be ‘manipulated’ and hence apparent growth may not be sustainable
Restructuring charges, asset impairments & special charges – typically ‘unusual’ but effects can be ongoing (e.g., impairments lower future expenses, needing adjustment)
R&D – reductions increase current income but impact future earnings
Advertising – reductions increase current income but impact future earnings
Pension expense – each of the components represents an opportunity for ‘manipulation’, especially expected returns which are not really a part of core earnings
Changes in estimates – ‘poor’ estimates will be adjusted in future earnings
Realised gains & losses – timing and details
Unrealised gain & losses on equity investments – timing and details; ‘transitory’
Unrealised gains & losses from applying fair value accounting – typically ‘transitory’
Income taxes – one-time items; special incentives
Other income – confirm whether it includes interest income
Deferred Revenue: Microsoft
firms may defer revenue into a “cookie jar” and then dip into the cookie jar later, often to “smooth” earnings
2010 2009 2008
Unearned revenue $29,374 $24,409 $24,532
Recognition of unearned revenue (28,813) (25,426) (21,944)
Merger & Restructuring Charges: IBM
Does this provide the scope for ‘false’ earning growth in the future?
note: core OI from sales
Year
1991
1992
1993
1994
1995
1996
1997
1998 Restructuring Charges ($B)
3.7
11.6
8.9
(2.8)
(2.1)
(1.5)
(0.5)
(0.4)
Does this provide the scope for ‘false’ earning growth in the future?
note: unusual items
13
R&D Expenditures: Merck & Co
Is the drop temporary?
Will it affect future sales?
note: core OI from sales
Advertising Expenditures: Coca-Cola
Will the increase in R&D result in future sales?
note: core OI from sales
14
Pension Costs: IBM
Net pension expense comprised of 6 components
notes:
net pension expense can be negative due to higher expected return on plan assets need to consider the assumed rate of return; core other OI, not core OI from sales
evaluate gains on pension fund assets
Gains & losses on sale of shares
gains often recorded to operating income but Statement of Cash Flows reveals true nature (unusual item)
timing e.g., realise ‘winners’; hold ‘loosers’
15
16
PART 3 – Growth in Residual Income (Abnormal Earnings)
residual earnings = (ROCEt – cost of equity capital) BVt-1
support growth in abnormal earnings arises from
growth in ROCE (i.e., profitability)
growth in S/E
growth in ROCE
ROCE = = {profit margin asset turnover} + {FLEV spread}
NOA
17
RNOA = =
=
=
where Core Sales Profit Margin =
profit margin ‘unaffected’ by Other Income or Unusual Items
captures the firm’s ability to generate profits from sales
18
19
RNOA =
= (core sales PM) @ previous ATO + ATO @ new core sales PM
To illustrate –
General Mills
RNOA Profit Margin Asset Turnover
2010 10.1% 7.95% 1.27
2009 4.1% 3.41% 1.19
6.0% 4.54% 0.08
Can we gain any ‘deeper’ insights that might assist with forecasting?
20
from Penman Exhibit 13.2 re: General Mills
2010 2009
Core Operating Revenues 14,797 14,691
Core Operating Income from Sales (after tax) 1,435 1,174
Core Other Operating Income (after tax) 370 352
Unusual Items (after tax) (628) (1,025)
Operating Income (after tax) 1,177 501
Net Financing Expenses (after tax) (251) (239)
Noncontrolling Interest (5) (9)
Comprehensive Income 921 253
Core sales PM = 1.71% 0.0970 0.0799
also given = 2.85%
21
RNOA = (1.71% 1.19) + (0.08 9.70%) + 0.33% + 2.85%
= {2.04% + 0.78%} + 0.33% + 2.85%
2.82% increase related to core income from sales
increase in RNOA due to 0.33% increase related to other core income (outside of sales)
2.85% increase related to unusual (one-time) items
for General Mills, slightly less then ½ of the increase in RNOA is related to ‘core operating income from sales’ (2.82% out of 6%)
(core sales PM)
ATO
22
critical ‘drivers’ of growth (increases) in ROCE
core sales PM; asset turnover; financial leverage (FLEV); and spread (i.e., NBC)
for core sales PM:
changes in the ‘core sales PM’ are determined by how costs change as sales change
notions of variable & fixed costs
Operating leverage (OLEV) – the extent to which the firm’s operating costs are fixed
OLEV = % core OI = % core sales OLEV
** operating leverage should not be confused with operating liability leverage (OLLEV) that appears in the ‘operating leverage equation relating ROOA to RNOA
23
re: growth in S/E
S/E = NOA – NFO
where NOA = sales recall: ATO =
S/E = (sales – NFO
drivers of the change (growth) in S/E
growth in sales
change in NOA (through sales & ATO)
change in FLEV (amount of net debt used to finance the change in NOA, as opposed to equity)
CSE = NOA – NFO
NOA
NFO
Sales
Changes in Sales for
Business Segments
Or Product Lines
Changes in Individual
Asset Turnovers
Changes in NFO
Components
NOA = Sales
Change in S/E
=
Change due to change in sales at previous level of asset turnover
Change in financial leverage
Change due to change in asset turnover
+
+
24
25
In summary
what is a ‘growth firm’ a firm that can increase its ‘residual earnings’
a ‘growth firm’ features:
sustainable, growing sales
high or increasing core profit margins
high or improving asset turnovers
note: sustaining high ‘core profit margins’ indicates the presence of ‘competitive advantage’
without a ‘durable’ competitive advantage, the firm’s residual earnings (abnormal earnings) will ultimately decline
26
PART 4 – Valuation Exercise applied to Coles
caveats !!!
largely an ‘art’ rather than a science
involves considerable interpretation and use of judgement (subjective)
you would each most likely arrive at slightly different interpretations and thereby different estimates that the ones I am about to propose
– this doesn’t make any particular set of estimates either ‘more correct’ or ‘more incorrect’; just different!
(although clearly some estimates appear more plausible than others, at least on the surface, until explained or justified)
27
PART 4 – Step 1: Forecast Sales
sales ‘drive’ the system !!
a consideration of historical sales growth rates can be a starting point BUT …. need to develop a thorough understanding of the business and its environment to make meaningful sales forecasts
the firm’s business strategy
the market for the firm’s products
the firm’s marketing plan
how the broader economic factors and the industry dynamics affect the business
‘constraints’ – regression to mean; sustainable growth rate; plausible terminal growth rate
28
re: Coles ***IBISWorld https://my.ibisworld.com/au/en/industry/g4111
Industry Outlook
Price competition in the Supermarkets and Grocery Stores industry is forecast to remain strong over the next five years.
Profit
Industry profitability is projected to increase over the next five years, despite weak household incomes and high unemployment.
Competition
Internal industry competition is forecast to remain high over the next five years
Investing in technology
Major supermarkets will likely become more innovative and use new technologies to attract customers to increase their market share over the next five years.
29
Industry Life Cycle
The life cycle stage of this industry is Growth
LIFE CYCLE REASONS
The industry is growing slightly faster than the overall economy
Fierce competition is restricting the entry of new players, but established players are expanding store networks
Technological change in the industry is moderate and increasing
30
Industry Performance Data Historical & Prospective
31
32
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
Revenues 54,505.7 55,492.2 58,921.7 61,155.0 60,868.4 58,276.0 55,669.0 56,726.0 59,984.0 63,675.0
ave = 1.82% 1.81% 6.18% 3.79% -0.47% -4.26% -4.47% 1.90% 5.74% 6.15%
EBIT 3,329.90 3,919.60 3,733.70 3,783.10 3,748.40 2,564.00 2,326.00 2,548.00 2,724.00 3,219.00
ave = 0.79% 17.71% -4.74% 1.32% -0.92% -31.60% -9.28% 9.54% 6.91% 18.17%
CFO 2,991.10 2,873.80 2,719.90 3,472.70 3,345.10 2,358.00 3,122.00 2,930.00 2,948.00 4,561.00
ave = 7.42% -3.92% -5.36% 27.68% -3.67% -29.51% 32.40% -6.15% 0.61% 54.72%
Op Margin 7.70 8.70 8.00 7.80 8.00 6.20 6.00 6.40 6.60 8.90
NPAT (%) 4.00 4.90 4.00 4.00 4.00 4.70 2.50 2.80 2.90 2.50
dividends 1.22 1.26 1.33 1.37 1.39 0.77 0.84 1.03 1.02 0.94
Payout ratio 69.00 56.00 70.00 70.00 71.00 36.00 76.00 84.00 77.00 74.00
Woolworths
Industry
2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
ave = 3.14% 2.89% 4.68% 3.97% 5.87% 3.99% -0.88% 1.08% 1.15% 5.48%
33
34
35
36
Year Revenue
(%) IVA
(%) Establishments
(%) Enterprises
(%) Employment
(%) Exports
(%) Imports
(%) Wages
(%) Domestic
Demand
(%)
2020–21 0.51 -0.11 -0.84 -0.55 -1.12 N/A N/A -0.67 N/A
2021–22 2.64 2.64 0.13 -0.60 -0.01 N/A N/A 1.50 N/A
2022–23 1.76 3.00 -0.37 -1.40 0.01 N/A N/A 1.12 N/A
2023–24 2.31 2.30 0.09 -0.82 -0.26 N/A N/A 1.08 N/A
2024–25 2.37 2.37 0.41 -0.72 -0.15 N/A N/A 1.25 N/A
2025–26 1.49 1.50 0.98 1.23 0.01 N/A N/A 1.40 N/A
Industry Performance Data Outlook (from IBISWorld)
37
caveats moving from industry forecasts to firm-level forecasts
historical industry patterns can be a good ‘starting’ point, especially if the future is likely to be similar to the past … however, also need to recognise broad indicators to the contrary
gov’t or trade statistics that forecast change in global economy, or the specific industry
forecasts of a recession or slowdown in GDP
shifts in industry-wide demand with changing demographics and/ consumer tastes
need to have a knowledge of industry trends and of the susceptibility of the industry to macroeconomic changes
need to tailor the industry projections to fit with the specific firm features
firms have idiosyncratic features that yield ‘drivers’ that are predictably different from industry patterns
need to consider how the firm’s future drivers may or will be different from the typical pattern in the industry (arguably the main factor relates to competition and the firm’s reaction to it)
focus on the drivers that are key to understanding the firm’s profitability
start with industry ‘drivers’ (e.g., Table 16.3) and then
adjust for firm-specific features
38
39
Sales forecasts – Coles
2019 A 2020 A 2021 E 2022 E 2023 E 2024 E 2025 E
Revenues 38,176 37,408 38,343 39,110 39,990 40,890 41,708
-2.01% 2.50% 2.00% 2.25% 2.25% 2.00%
Based on the macroeconomic outlook, the industry outlook, and Coles historical performance and prospects to “exploit” growth opportunities:
growth rates in ‘core sales revenue’ will range between 2.0% and 2.5% over the next 5 years, with the pattern largely following predicted industry growth pattern
ultimately Coles’ sales growth will stabilise at 3% (terminal growth rate)
40
Step 1: Forecast Sales
Step 2: Forecast Core OI from Sales (before tax)
next steps:
2a forecast ATO and calculate NOA implied by sales forecasts and forecasted ATO
2b revise sales forecasts (if necessary) in recognition of ‘asset constraints’
Explain changes in ATO by looking at individual asset turnovers
A/R; inventory; property, plant & equipment
A/P; operating liability turnover
Also consider
operating asset composition ratios
operating liabilities composition ratios
OLLEV
41
ATO forecast – Coles
2020 ATO = 3.065
2019 ATO = 38,176/13,102 = 2.914 (based on the adjusted 2019 NOA)
is there any reason to believe that the ATO might or could change?
which accounts are sufficiently material to influence the ATO, and can they be changed? see the third level break down of ROCE (next slide)
‘material’ accounts: inventory; property, plant & equipment; intangible assets
accounts payable; provisions
examine related NOTES to the F/S to understand the roles of each account and the likelihood that they can be changed
is the level of NOA implied by the estimated ATO and the sales forecasts supportable?
42
Asset Turnover Drivers turnover = sales / item inverse = item / sales
Operating Assets
cash & cash equivalents 187 200.043 0.0050
receivables 434 86.194 0.0116
inventories 2,166 17.271 0.0579
assets held for resale 75 498.773 0.0020
other assets 190 196.884 0.0051
property, plant & equipment 4,127 9.064 0.1103
right-of-use assets 7,660 4.884 0.2048
intangible assets 1,597 23.424 0.0427
deferred tax assets 849 44.061 0.0227
equity accounted investments 217 172.387 0.0058
Total Operating Assets (OA) 17,502 2.137 0.4679
Operating Liabilities
trade payables 3,737 10.010 0.0999
provisions 1,333 28.063 0.0356
other 227 164.793 0.0061
Total Operating Liabilities (OL) 5,297 7.062 0.1416
Net Operating Assets (NOA) 12,205 3.065 0.3263
43
2019 A 2020 A 2021 E 2022 E 2023 E 2024 E 2025 E
Revenues 38,176 37,408 38,343 39,110 39,990 40,890 41,708
NOA = sales / ATO of 3 13,102 12,205 12,781 13,037 13,330 13,630 13,903
% NOA 4.72% 2.00% 2.25% 2.25% 2.25%
2020 ATO = 3.065
2019 ATO = 38,176/13,102 = 2.914 (based on the adjusted 2019 NOA)
is there any reason to believe that the ATO might or could change?
not obvious that any of the ‘material’ accounts can or will change
set ATO = 3.00
(also sensitivity under the assumption that ATO could increase slightly over time)
is the level of NOA implied by the estimated ATO and the sales forecasts supportable? YES sustainable growth rate for 2020 g* = 3.4%
44
2c gross profit margin = (core sales revenue – COGS) / sales
2020 (37,408 – 28,043) / 37,408 = 0.2504
2019 (38,176 – 29,253) / 38,176 = 0.2337
slight improvement but is there any reason to believe that it could improve further?
no NOTE to help understand
Woolworth’s gross profit margins: 2020 – 0.2916 2019 – 0.2908
(but no reason to believe that the 2 companies aggregate expenses the same way e.g., branch and admin expenses)
set gross profit margin at 0.260 (and conduct sensitivity between 0.25 and 0.275)
2021 E 2022 E 2023 E 2024 E 2025 E
Revenues 38,343 39,110 39,990 40,890 41,708
Gross Margin (@ 0.260) 9,969 10,169 10,397 10,631 10,844
2 factors
price
cost
45
2d core operating expenses administrative expenses
2020: (8,081 – 41) / 37,408 = 0.2149 2019: (8,031 + 42) / 38,176 = 0.2115
administrative expense ratio up slightly when sales down
consistent with a ‘fixed cost’ component
2021 E 2022 E 2023 E 2024 E 2025 E
Revenues 38,343 39,110 39,990 40,890 41,708
Administrative Expense (%) 0.210 0.2095 0.209 0.2085 0.208
= Admin Expense (8,052) (8,194) (8,358) (8,526) (8,675)
assume a modest decline over the 5-year horizon 6 from 0.21 to 0.208 as sales increase, and then stabilise at 0.208
46
2f tax expense
current effective tax rate on PBT (i.e., after int) 2020: 25.85% 2019: 23.65%
assume 30% tax rate on ‘core OI’
2g other operating revenue; equity accounted investments
no NOTE to explain; assume constant at 2020 level of $500 million
2h unusual OI
given definition as ‘non-recurring’, assume 0
47
2021 E 2022 E 2023 E 2024 E 2025 E
Revenues 38,343 39,110 39,990 40,890 41,708
Gross Margin (0.26) 9,969 10,169 10,397 10,631 10,844
Administrative Expense (8,052) (8,194) (8,358) (8,526) (8,675)
Tax Expense (30%) (575) (593) (612) (632) (651)
Core OI from Sales (after tax) 1,342 1,382 1,427 1,473 1,518
Core Other OI 500@ (1 – 0.3) 350 350 350 350 350
Unusual Items 0 0 0 0 0
Total OI (after tax) 1,692 1,732 1,777 1,823 1,868
48
Step 1: Forecast Sales
Steps 2 – 6: Forecast components of OI after tax
Step 7: Forecast OA and OL to obtain NOA
** given the previous arguments surrounding the stability of asset turnover (ATO) and the inability to alter the ‘material’ accounts, will assume that the turnovers for the OA and OL items remain unchanged
49
Asset Turnover Drivers Current turnover Assumed turnover 2021 2022 2023 2024 2025
(38,343) (39,110) (39,990) (40,890) (41,708)
Operating Assets
cash & cash equivalents 200.043 200 192 196 200 204 209
receivables 86.194 86 446 455 465 475 485
inventories 17.271 17.25 2,223 2,267 2,318 2,370 2,418
assets held for resale 498.773 500 77 78 80 82 83
other assets 196.884 200 192 196 200 204 209
property, plant & equipment 9.064 9 4,260 4,346 4,443 4,543 4,634
right-of-use assets 4.884 4.75 8,072 8,234 8,419 8,608 8,781
intangible assets 23.424 23 1,667 1,700 1,739 1,778 1,813
deferred tax assets 44.061 44 871 889 909 929 948
equity accounted investments 172.387 175 219 223 229 234 238
Total Operating Assets (OA) 2.137 2.105 18,219 18,583 19,001 19,429 19,818
Operating Liabilities
trade payables 10.010 10 3,834 3,911 3,999 4,089 4,171
provisions 28.063 28 1,369 1,397 1,428 1,460 1,490
other 164.793 165 232 237 242 248 253
Total Operating Liabilities (OL) 7.062 7.053 5,436 5,545 5,670 5,798 5,914
Net Operating Assets (NOA) 3.065 3.000 12,782 13,038 13,331 13,631 13,904
50
Step 1: Forecast Sales
Steps 2 – 4: Forecast components of OI after tax
Step 5: Forecast NOA
Step 8: Calculate RNOA, FCF, and ReOI
RNOA = FCF = OI – NOA
ReOI (to firm) = OIt – kF*NOAt-1
WACC = (NBC) + (kE) = (3.36%) +(7.40%) = 6.25%
Session #3
Session #10
51
2021 E 2022 E 2023 E 2024 E 2025 E
Revenues 38,343 39,110 39,990 40,890 41,708
Core OI from Sales (after tax) 1,342 1,382 1,427 1,473 1,518
% 2.98% 3.26% 3.22% 3.06%
Total OI (after tax) 1,692 1,732 1,777 1,823 1,868
% 2.36% 2.60% 2.59% 2.47%
NOA 12,782 13,038 13,331 13,631 13,904
RNOA 0.1324 0.1328 0.1333 0.1337 0.1344
%RNOA 0.0269 0.0004 0.0005 0.0004 0.0007
FCF 1,115 1,476 1,484 1,523 1,595
%FCF 0.0500 0.0446 0.005 2.63% 4.73%
ReOI (k = 6.25%) (to firm) 929 933 962 990 1,016
%ReOI 0.43% 3.11% 2.91% 2.63%
Step 9: ‘unlevered valuation’ overall value of the firm
52
Illustrative Calculations
Free Cash Flow (FCF) = OI – NOA
2021: 1,692 – (12,782 – 12,205) = 1,115
2022: 1,732 – (13,038 – 12,782) = 1,476
2023: 1,777 – (13,331 – 13,038) = 1,484
2024: 1,823 – (13,631 – 13,331) = 1,523
2025: 1,868 – (13,904 – 13,631) = 1,595
Residual Income (ReOI) = OI – ke* NOAt-1
2021: 1,692 – 0.0625 * 12,205 = 929
2022: 1,732 – 0.0625 * 13,038 = 933
2023: 1,777 – 0.0625 * 13,331 = 962
2024: 1,823 – 0.0625 * 13,631 = 990
2025: 1,868 – 0.0625 * 13,904 = 1,016
53
Abnormal Earnings (Residual Income) valuation model
+
= 12,205 + + + + +
= $40,015 million
FCF valuation model
= + + + +
= $43,298 million
54
Step 10 leverage (FLEV) and financing costs (NFE)
interest expense on long-term debt and lease liabilities
2020: FLEV = 3.6673
2020: NFE = 322
assume property, plant & equipment (both purchased & leased) grow at 1.5%
assume capital structure remains largely unchanged FLEV = 3.67
assume interest rates ̴ 0.5-0.6% current NBC = 3.36% NBC = 4%
2020 A 2021 E 2022 E 2023 E 2024 E 2025 E
NFO (@ 1.5%) 9,590 9,734 9880 10,028 10,179 10,331
NFE (after tax) 322 389 394 401 407 413
what happens to FLEV when S/E is calculated
55
2021 E 2022 E 2023 E 2024 E 2025 E
Revenues 38,343 39,110 39,990 40,890 41,708
Gross Margin (0.26) 9,969 10,169 10,397 10,631 10,844
Administrative Expense (8,052) (8,194) (8,358) (8,526) (8,675)
Tax Expense (30%) (575) (593) (612) (632) (651)
Core OI from Sales (after tax) 1,342 1,382 1,427 1,473 1,518
Core Other OI 500@ (1 – 0.3) 350 350 350 350 350
Unusual Items 0 0 0 0 0
Total OI (after tax) 1,692 1,732 1,777 1,823 1,868
Core NFE (389) (395) (401) (407) (413)
Comprehensive Income 1,303 1,337 1,376 1,416 1,455
** assumes OCI = 0
Steps 11 , 12 & 13 CI, S/E, dividends, ReCI
56
2021 E 2022 E 2023 E 2024 E 2025 E
Revenues 38,343 39,110 39,990 40,890 41,708
Comprehensive Income 1,303 1,337 1,376 1,416 1,455
%CI 2.61% 2.92% 2.91% 2.75%
NOA 12,782 13,038 13,331 13,631 13,904
NFO 9,734 9,880 10,028 10,179 10,331
S/E = NOA – NFO 3,048 3,158 3,303 3,452 3,573
%S/E 3.61% 4.59% 4.51% 3.51%
Dividends 870 1,227 1,231 1,267 1,336
%Div 3.26% 2.92% 5.29%
ReCI (k = 7.4%) (to S/E) 1,109 1,111 1,142 1,172 1,200
%ReOI 0.20% 2.79% 2.63% 2.39%
57
Illustrative Calculations
Dividends (Div) = CI – S/E NCC assume NCC = 0 (on average)
2021: 1,303 – (3,048 – 2,615) = 870
2022: 1,337 – (3,158 – 3,048) = 1,227
2023: 1,376 – (3,303 – 3,158) = 1,231
2024: 1,416 – (3,452 – 3,303) = 1,267
2025: 1,455 – (3,571 – 3,452) = 1,336
Residual Income (ReCI) = CI – ke* BVt-1
2021: 1,303 – 0.074 * 2,615 = 1,109
2022: 1,337 – 0.074 * 3,048 = 1,111
2023: 1,376 – 0.074 * 3,158 = 1,142
2024: 1,416 – 0.074 * 3,303 = 1,172
2025: 1,455 – 0.074 * 3,452 = 1,200
58
Abnormal Earnings (Residual Income) valuation model
+
= 2,615 + + + + +
= $26,911.5 million (** possible rounding errors – if all calculations carried through an Excel spreadsheet with no rounding, this figure becomes 26,905.0)
DDM valuation model
= + + + +
= $26,606.7 million
context
current share price (20 January 2021) = $17.94
market capitalisation $18 * 1,334 million shares = $24,012 million
Abnormal Earnings (Residual Income) valuation model
market capitalisation = $26,911.5 million
DDM valuation model
market capitalisation = $26,606.7 million
Sensitivity – assume g = 2.5% (instead of 3%)
AE $24,819.8 million
DDM $24,281.5 million
59
‘gap’ suggests not quite to ‘steady state’
increased ‘gap’ perhaps a bit ‘extra’ g left in DIV, or a a bit less in AE before reach ‘steady state’
Summary of significant assumptions
Sales growth 2.5% 2.0% 2.25% 2.25% 2.0%
ATO constant @ 3.00 (had increased from 2.914 to 3.065) if higher ROCE
Gross profit margin @ 0.26 (had increased from 0.234 to 0.250)
Admin expenses assumed to decline from 0.21 to 0.208 (had increased from 0.212 to 0.215)
Financing costs assumed growth in PPE of 1.5%, NBC up 0.6%
Unchanged capital structure
Terminal growth (g) = 3%
60
61
overarching objective:
to conduct fundamental value for the purpose of estimating the ‘intrinsic value’ of a firm’s common shares
requires an understanding of the firm’s ‘value drivers’
need to accumulate a ‘tool kit’ as the basis for developing the pro forma Financial Statements
STEP 1
Understanding the past
Information collection
Understanding the business
Accounting analysis
Financial ratio analysis
Cash flow analysis
STEP 2
Forecasting the future
Structured forecasting
Income Statement forecasts
Balance sheet forecasts
Cash flow forecasts
STEP 3
Valuation
Cost of capital
Valuation models – AE, FCF, D
Valuation ratios
Complications
Negative values
Value creation and destruction
PART 5 – Summary
62
external environment
economic prospects
macroeconomic factors
socio-cultural forces
political / regulatory
Industry dynamics
Porter’s five forces
(suppliers, buyers, new entrants, substitutes, rivalry)
Analysis of Financial Statements
understanding current F/S
re-formulating the F/S
accounting quality
ratio analysis
analysts’ reports
management forecasts
financial press
???
0V =
tx
( 1+ tk
t)t =1
∞
∑ =
E( tx )
t
(1+k)t=1
n
∑ +
E( nx ) (1+ g)
k − g
1
n
(1+k)
0
V
=
t
x
(
1+
t
k
t
)
t=1
¥
å
=
E(
t
x
)
t
(1+k)
t=1
n
å
+
E(
n
x
)
(1+g)
k-g
1
n
(1+k)
(In billions of dollars)
2010 2009 2008
Revenues 35.1 31.0 31.9
Cost of goods sold 12.7 11.1 11.4
Gross profit 22.4 19.9 20.5
Selling, administrative and general 14.0 11.7 12.1
Operating income (before tax) 8.4 8.2 8.4
Advertising expenses 2.9 2.8 3.0
Advertising expenses/Sales 8.3% 9.0% 9.4%
(In billions of dollars)
2010 2009 2008
Sales 46.0 27.4 23.8
R&D 11.0 5.8 4.8
R&D-to-Sales 23.9% 21.2% 20.2%
(In millions of dollars)
(In billions of dollars)
2010
2009
2008
Revenues
35.1
31.0
31.9
Cost of goods sold
12.7
11.1
11.4
Gross profit
22.4
19.9
20.5
Selling, administrative and general
14.0
11.7
12.1
Operating income (before tax)
8.4
8.2
8.4
Advertising expenses
2.9
2.8
3.0
Advertising expenses/Sales
8.3%
9.0%
9.4%
(In millions of dollars)
(In billions of dollars)
2010
2009
2008
Sales
46.0
27.4
23.8
R&D
11.0
5.8
4.8
R&D-to-Sales
23.9%
21.2%
20.2%
_____________________________________________________________________
International Business Machines (IBM)
Components of pension expense, 2001-2004
(In millions of dollars)
2004 2003 2002 2001
Service cost 1,263 1,113 1,155 1,076
Interest cost 4,071 3,995 3,861 3,774
Expected return on plan assets (5,987) (5,931) (6,253) (6,264)
Amortization of transition asset (82) (159) (156) (153)
Amortization of prior service
cost
66 78 89 80
Actuarial losses (gains) 764 101 105 (24)
Net pension expense 95 (803) (1,199) (1,511)
_____________________________________________________________________
_____________________________________________________________________
International Business Machines (IBM)
Components of pension expense, 2001-2004
(In millions of dollars)
2004
2003
2002
2001
Service cost
1,263
1,113
1,155
1,076
Interest cost
4,071
3,995
3,861
3,774
Expected return on plan assets
(5,987)
(5,931)
(6,253)
(6,264)
Amortization of transition asset
(82)
(159)
(156)
(153)
Amortization of prior service cost
66
78
89
80
Actuarial losses (gains)
764
101
105
(24)
Net pension expense
95
(803)
(1,199)
(1,511)
ATO
1
D
/docProps/thumbnail.jpeg