Saturday 2 November 2013

Mastering valuation , Nov 2013

A work still in progress ;



Intrinsic valuation, relates the value of an asset to its intrinsic 
characteristics: its capacity to generate cash flows and the risk in the 
cash flows. In it’s most common form, intrinsic value is computed 
with a discounted cash flow valuation, with the value of an asset being 
the present value of expected future cashflows on that asset.
  Relative valuation, estimates the value of an asset by looking at the 
pricing of 'comparable' assets relative to a common variable like 
earnings, cashflows, book value or sales.
  Contingent claim valuation, uses option pricing models to measure 
the value of assets that share option characteristics.

Discount cash flow valuation 
-----------------------------------
What is it: In discounted cash flow valuation, the value of an asset is 
the present value of the expected cash flows on the asset.
  Philosophical Basis: Every asset has an intrinsic value that can be 
estimated, based upon its characteristics in terms of cash flows, growth 
and risk.
  Information Needed: To use discounted cash flow valuation, you 
need
•  to estimate the life of the asset
•  to estimate the cash flows during the life of the asset
•  to estimate the discount rate to apply to these cash flows to get present value
  Market Inefficiency: Markets are assumed to make mistakes in 
pricing assets across time, and are assumed to correct themselves over 
time, as new information comes out about assets



Relative valuation
----------------------------

What is it?: The value of any asset can be estimated by looking at 
how the market prices “similar”
 or ‘comparable” assets.
  Philosophical Basis: The intrinsic value of an asset is impossible (or 
close to impossible) to estimate. The value of an asset is whatever the 
market is willing to pay for it (based upon its characteristics)
  Information Needed: To do a relative valuation, you need
•  an identical asset, or a group of comparable or similar assets
•  a standardized measure of value (in equity, this is obtained by dividing the price by 
a common variable, such as earnings or book value)
•  and if the assets are not perfectly comparable, variables to control for the 
differences
  Market Inefficiency: Pricing errors made across similar or 
comparable assets are easier to spot, easier to exploit and are much 
more quickly corrected.



Contingent Claim / Option valuation
------------------------------
Options have several features
•  They derive their value from an underlying asset, which has value
•  The payoff on a call (put) option occurs only if the value of the underlying asset is 
greater (lesser) than an exercise price that is specified at the time the option is 
created. If this contingency does not occur, the option is worthless.
•  They have a fixed life
  Any security that shares these features can be valued as an option


  Summary   : chose your model carefully ; every company is different 
-----------------------------

While there are hundreds of valuation models and metrics around, 
there are only three valuation approaches:
•  Intrinsic valuation (usually, but not always a DCF valuation)
•  Relative valuation
•  Contingent claim valuation
  The three approaches can yield different estimates of value for the 
same asset at the same point in time.
  To truly grasp valuation, you have to be able to understand and use all 
three approaches. There is a time and a place for each approach, and 
knowing when to use each one is a key part of mastering valuation.


Useful Resources ;

------------------------------------------------------------------------------------------------------


Local currency goverment bond rates Jan 2013





Jan-13



Jan-12



Country



Jan-13



Jan-12
13.50%
NA
3.62%
5.96%
12.01%
15.27%
3.60%
3.44%
11.50%
13.01%
3.54%
3.81%
11.47%
37.09%
3.54%
3.29%
10.05%
12.24%
3.50%
3.69%
9.84%
NA
3.43%
5.22%
9.18%
11.39%
3.39%
6.50%
8.00%
8.36%
3.28%
3.93%
6.98%
13.46%
3.15%
3.80%
6.88%
NA
2.68%
NA
6.85%
6.00%
2.12%
2.29%
6.80%
NA
2.05%
4.37%
6.76%
6.76%
1.99%
3.32%
6.55%
NA
1.87%
3.61%
6.39%
8.20%
1.82%
2.05%
6.23%
10.73%
1.81%
2.01%
5.55%
7.56%
1.76%
1.99%
5.51%
5.58%
1.74%
3.24%
5.29%
6.51%
1.54%
1.71%
5.26%
5.43%
1.51%
2.40%
5.17%
6.08%
1.50%
2.31%
5.03%
NA
1.38%
1.72%
4.95%
7.41%
1.31%
1.92%
4.53%
8.21%
1.30%
1.60%
4.50%
6.92%
1.26%
NA
4.40%
NA
1.17%
NA
4.31%
4.31%
0.79%
0.99%
4.09%
6.35%
0.65%
1.57%
3.91%
4.54%
0.46%
0.71%



----------------------------------------------------------



The values ​​are as of 05/08/2011. The rank in brackets is by 08.07.2011.The percentage in brackets after the premium is the corresponding increase in the period. With "L" marked countries have low market liquidity, which can possibly lead to incorrect or erratic results. All data are to  be removed and updated monthly, if possible.



Country Risk Premiums ;




RankCountryRisk PremiumPDNoteRating
1 (1)Greece1644 (-22%)98%U, R, I, E, SCCC
2 (2)Venezuela956 (3%)88%BB
3 (4)Pakistan883 (5%)86%5yB
4 (3)Portugal855 (5%)85%BBB
5 (12)Cyprus809 (118%)83%A
6 (5)Ireland716 (5%)79%U, R, I, E, S, KBBB +
7 (6)Argentina691 (7%)77%RB
8 (7)Jamaica581 (5%)71%B
9 (8)Ukraine494 (3%)65%I, UB +
10 (20)Spain414 (40%)58%AA
11 (18)Hungary406 (30%)57%I, U, K, E, SBBB
12 (11)Lebanon398 (7%)56%B
13 (9)Dominican Republic391 (3%)56%B +
14 (10)Dubai387 (3%)55%
15 (15)Croatia378 (19%)54%BBB
16 (29)Italy373 (66%)54%A +
17 (14)Vietnam354 (4%)52%BB
18 (13)Serbia349 (1%)51%IBB
19 (17)Egypt344 (9%)51%5yBB
20 (16)El Salvador318 (0%)48%BB
21 (19)Iraq299 (0%)46%
22 (23)Romania287 (14%)45%K, IBB +
23 (25)Malta287 (19%)45%A
24 (24)Bulgaria285 (13%)44%U, KBBB
25 (26)Latvia269 ​​(15%)42%I, U, R, K, E, SBB +
26 (27)Lithuania262 (12%)42%U, KBBB
27 (22)Bahrain261 (1%)41%BBB
28 (21)Iceland256 (-8%)41%I, U, RBBB
29 (28)Turkey254 (11%)41%BB
30 (40)Belgium240 (40%)39%AA +
31 (32)Poland230 (19%)38%EA
32 (35)Kazakhstan224 (19%)37%BBB
33 (30)Algeria220 (0%)36%
34 (34)Morocco206 (8%)34%BB +
35 (31)Costa Rica203 (2%)34%BB
36 (33)Guatemala200 (4%)33%BB
37 (37)Russia197 (8%)33%KBBB
38 (36)Uruguay189 (1%)32%BB
39 (38)Philipines182 (0%)31%BB
40 (39)Indonesia182 (1%)31%BB +
41 (41)Israel168 (3%)29%A
42 (49)Slovenia167 (26%)29%AA
43 (43)Peru167 (5%)29%BBB
44 (42)Thailand164 (0%)28%BBB +
45 (45)Brazil161 (11%)28%BBB
46 (44)South Africa159 (8%)28%BBB +
47 (58)France159 (46%)28%UAAA
48 (46)Mexico157 (11%)27%BBB
49 (47)Colombia156 (10%)27%BBB
50 (54)Slovakia155 (23%)27%A +
51 (52)Panama145 (12%)25%BB +
52 (48)Korea137 (3%)24%A
53 (51)Malaysia135 (4%)24%A
54 (53)China130 (3%)23%UAA
55 (59)Estonia129 (22%)23%A
56 (57)Czech Republic128 (13%)23%RA +
57 (50)Qatar127 (3%)23%AA
58 (55)Abu Dhabi123 (-1%)22%AA
59 (56)Japan122 (0%)22%AA
60 (63)Austria117 (39%)21%AAA
61 (69)Denmark101 (63%)19%AAA
62 (60)Saudi Arabia96 (1%)18%5yAA
63 (62)United Kingdom95 (12%)17%UAAA
64 (61)Chile95 (1%)17%A +
65 (67)Germany89 (38%)17%AAA
66 (70)Netherlands78 (40%)15%AAA
67 (71)Finland75 (41%)14%SAAA
68 (66)Hong Kong73 (9%)14%AAA
69 (65)Singapore73 (6%)14%AAA
70 (64)New Zealand70 (0%)13%AA +
71 (68)USA65 (2%)12%UAA +
72 (73)Sweden61 (50%)12%AAA
73 (72)Switzerland48 (-2%)9%AAA
74 (75)Norway48 (49%)9%AAA
75 (74)Australia37 (0%)7%AAA

Annual Returns on Stock, T.Bonds and T.Bills: 1928 - Current



Annual Returns on Investments inCompounded Value of $ 100
YearStocksT.BillsT.BondsStocksT.BillsT.Bonds
192843.81%3.08%0.84%$143.81$103.08 $100.84        
1929-8.30%3.16%4.20%$131.88$106.34      $105.07
1930-25.12%4.55%4.54%$98.75$111.18 $109.85
1931-43.84%2.31%-2.56%$55.46$113.74$107.03
1932-8.64%1.07%8.79%$50.66$114.96$116.44
193349.98%0.96%1.86%$75.99$116.06$118.60
1934-1.19%0.32%7.96%$75.09$116.44$128.05
193546.74%0.18%4.47%$110.18$116.64$133.78
193631.94%0.17%5.02%$145.38$116.84$140.49
1937-35.34%0.30%1.38%$94.00$117.19$142.43
193829.28%0.08%4.21%$121.53$117.29$148.43
1939-1.10%0.04%4.41%$120.20$117.33$154.98
1940-10.67%0.03%5.40%$107.37$117.36$163.35
1941-12.77%0.08%-2.02%$93.66$117.46$160.04
194219.17%0.34%2.29%$111.61$117.85$163.72
194325.06%0.38%2.49%$139.59$118.30$167.79
194419.03%0.38%2.58%$166.15$118.75$172.12
194535.82%0.38%3.80%$225.67$119.20$178.67
1946-8.43%0.38%3.13%$206.65$119.65$184.26
19475.20%0.57%0.92%$217.39$120.33$185.95
19485.70%1.02%1.95%$229.79$121.56$189.58
194918.30%1.10%4.66%$271.85$122.90$198.42
195030.81%1.17%0.43%$355.60$124.34$199.27
195123.68%1.48%-0.30%$439.80$126.18$198.68
195218.15%1.67%2.27%$519.62$128.29$203.19
1953-1.21%1.89%4.14%$513.35$130.72$211.61
195452.56%0.96%3.29%$783.18$131.98$218.57
195532.60%1.66%-1.34%$1,038.47$134.17$215.65
19567.44%2.56%-2.26%$1,115.73$137.60$210.79
1957-10.46%3.23%6.80%$999.05$142.04$225.11
195843.72%1.78%-2.10%$1,435.84$144.57$220.39
195912.06%3.26%-2.65%$1,608.95$149.27$214.56
19600.34%3.05%11.64%$1,614.37$153.82$239.53
196126.64%2.27%2.06%$2,044.40$157.30$244.46
1962-8.81%2.78%5.69%$1,864.26$161.67$258.38
196322.61%3.11%1.68%$2,285.80$166.70$262.74
196416.42%3.51%3.73%$2,661.02$172.54$272.53
196512.40%3.90%0.72%$2,990.97$179.28$274.49
1966-9.97%4.84%2.91%$2,692.74$187.95$282.47
196723.80%4.33%-1.58%$3,333.69$196.10$278.01
196810.81%5.26%3.27%$3,694.23$206.41$287.11
1969-8.24%6.56%-5.01%$3,389.77$219.96$272.71
19703.56%6.69%16.75%$3,510.49$234.66$318.41
197114.22%4.54%9.79%$4,009.72$245.32$349.57
197218.76%3.95%2.82%$4,761.76$255.01$359.42
1973-14.31%6.73%3.66%$4,080.44$272.16$372.57
1974-25.90%7.78%1.99%$3,023.54$293.33$379.98
197537.00%5.99%3.61%$4,142.10$310.90$393.68
197623.83%4.97%15.98%$5,129.20$326.35$456.61
1977-6.98%5.13%1.29%$4,771.20$343.09$462.50
19786.51%6.93%-0.78%$5,081.77$366.87$458.90
197918.52%9.94%0.67%$6,022.89$403.33$461.98
198031.74%11.22%-2.99%$7,934.26$448.58$448.17
1981-4.70%14.30%8.20%$7,561.16$512.73$484.91
198220.42%11.01%32.81%$9,105.08$569.18$644.04
198322.34%8.45%3.20%$11,138.90$617.26$664.65
19846.15%9.61%13.73%$11,823.51$676.60$755.92
198531.24%7.49%25.71%$15,516.60$727.26$950.29
198618.49%6.04%24.28%$18,386.33$771.15$1,181.06
19875.81%5.72%-4.96%$19,455.08$815.27$1,122.47
198816.54%6.45%8.22%$22,672.40$867.86$1,214.78
198931.48%8.11%17.69%$29,808.58$938.24$1,429.72
1990-3.06%7.55%6.24%$28,895.11$1,009.08$1,518.87
199130.23%5.61%15.00%$37,631.51$1,065.69$1,746.77
19927.49%3.41%9.36%$40,451.51$1,101.98$1,910.30
19939.97%2.98%14.21%$44,483.33$1,134.84$2,181.77
19941.33%3.99%-8.04%$45,073.14$1,180.07$2,006.43
199537.20%5.52%23.48%$61,838.19$1,245.15$2,477.55
199623.82%5.02%1.43%$76,566.48$1,307.68$2,512.94
199731.86%5.05%9.94%$100,958.71$1,373.76$2,762.71
199828.34%4.73%14.92%$129,568.35$1,438.70$3,174.95
199920.89%4.51%-8.25%$156,629.15$1,503.58$2,912.88
2000-9.03%5.76%16.66%$142,482.69$1,590.23$3,398.03
2001-11.85%3.67%5.57%$125,598.83$1,648.63$3,587.37
2002-21.97%1.66%15.12%$98,009.73$1,675.96$4,129.65
200328.36%1.03%0.38%$125,801.18$1,693.22$4,145.15
200410.74%1.23%4.49%$139,315.72$1,714.00$4,331.30
20054.83%3.01%2.87%$146,050.90$1,765.59$4,455.50
200615.61%4.68%1.96%$168,853.19$1,848.18$4,542.87
20075.48%4.64%10.21%$178,114.34$1,933.98$5,006.69
2008-36.55%1.59%20.10%$113,009.37$1,964.64$6,013.10
200925.94%0.14%-11.12%$142,318.62$1,967.29$5,344.65
201014.82%0.13%8.46%$163,411.79$1,969.84$5,796.96
20112.07%0.03%16.04%$166,787.51$1,970.44$6,726.52
Risk Premium
Arithmetic AverageStocks - T.BillsStocks - T.Bonds
1928-201111.20%3.66%5.41%7.55%5.79%
1962-201110.60%5.22%7.24%5.38%3.36%
2002-20114.93%1.81%6.85%3.12%-1.92%
Risk Premium
Geometric AverageStocks - T.BillsStocks - T.Bonds
1928-20119.23%3.61%5.14%5.62%4.10%
1962-20119.20%5.19%6.85%4.02%2.35%
2002-20112.88%1.80%6.49%1.08%-3.61%




Table 1: Survival of new establishments founded in 1998
Proportion of firms that were started in 1998 that survived through
                           Year 1     Year 2      Year 3     Year 4      Year 5    Year 6       Year 7
Natural resources 82.33%   69.54%   59.41%    49.56%    43.43%   39.96%    36.68%
Construction         80.69%   65.73%   53.56%    42.59%    36.96%   33.36%    29.96%
Manufacturing       84.19%   68.67%   56.98%    47.41%    40.88%   37.03%    33.91%
Transportation      82.58%   66.82%    54.70%    44.68%    38.21%   34.12%    31.02%
Information           80.75%   62.85%    49.49%    37.70%   31.24%   28.29%     24.78%
Financial activities  84.09%   69.57%    58.56%    49.24%   43.93%   40.34%    36.90%
Business services   82.32%   66.82%    55.13%   44.28%   38.11%   34.46%     31.08%
Health services      85.59%   72.83%    63.73%    55.37%   50.09%   46.47%    43.71%
Leisure                  81.15%   64.99%    53.61%    43.76%   38.11%   34.54%    31.40%
Other services       80.72%   64.81%    53.32%    43.88%    37.05%   32.33%    28.77%
All firms                81.24%   65.77%    54.29%    44.36%    38.29%   34.44%    31.18%


------------------------------------------------------------------------------------------------

Multiples by Market Cap Class (US)

Data Used: Value Line
Date of Analysis: Data used is as of January 2012
Critieria for inclusion: All publicly traded firms in the United States

Market Cap ClassNumber of firmsAverage PEAverage PBVAggregate P/SAverage EV/EBITDAAverage EV/ Invested CapitalAggregate EV/Sales
<5 mil875NA0.210.03NA0.870.86
5-17.5 mil5603.860.210.060.110.861.52
17.5-405183.520.670.53NA0.710.64
40-100 mil619NA0.880.503.400.930.84
100-250 mil662NA2.570.581.911.075.36
250 - 500 mil50348.091.520.574.221.350.76
500-1000 mil52622.121.630.854.811.461.05
1000-2500 mil62019.411.921.075.031.621.34
2500-10000 mil62415.781.911.114.551.601.41
>10000 mil38414.242.061.414.571.701.77
Grand Total589115.382.001.284.551.621.67

No comments:

Post a Comment