[an error occurred while processing this directive]
Valuatum Oy

 
  Main > Support > Analyst Help > General Instructions for Valuation Models   

General Instructions for Analysis and Valuatum Excel Model

Index

Where to get information about companies?
What is important analyst should try to estimate?
How far should I estimate in quarter level (net sales and EBIT)?
Seasonal variation in estimates
Estimating long-term growth and profitability
How to set value for Tangible assets / net sales %?
Estimating Working capital
General info about providing comments in company forums
Commenting and providing arguments for the estimates of current year
Setting and arguing recommendation
Description of competitive situation and position in markets
The track-record and creditability of current management
WACC - Parameter guidance
Setting fair value and the meaning of DCF


Where to get information about companies?

You can find information to be used in the analysis from following sources:

1) Company stock exchange releases and news releases
2) Annual reports, Company www-pages
3) Newspapers, newsletters
4) From company directly (Investor Relations)
5) Company infos, CMD, other visits to company
6) Other sources like: company sales/cust service, customers, competitors

Some information and hints for all of these:

1) Company stock exchange releases and news releases
Company stock exchange releases can be found from company www-pages and always also from stock exchange www-pages. Stock exchange is of course the best place to get these as it is regulated as has to contain all of the releases and the releases have to be published there first. It is also practical that all the companies you follow have their releases in one place.

Some companies however, publish also news releases. These releases might contain some interesting information about their new products, received orders etc. even though the company has themselves characterized them as "not containing some essential information which might have direct stock price effect". If they would contain such information, then they should of course be published as stock exchange releases. E.g. Nokia publishes about one press release per day but only few stock exchange releases or "company disclosures" per month.

Often companies have also a service that as you have registered as a subscriber, then you get all the releases that the company publishes directly to your own e-mail address. There are also third party services which collect and distribute at least stock exchange releases. E.g. Hugin Online offers a free service where the subscribers can get releses directly to their e-mail from companies they want to follow (Notice however, that the service does not seem to work for every company: at least I did not receive any releases from such Finnish companies as Lassila&Tikanoja and Exel although the service seems to work for all the other companies I selected and although those two companies are still there listed so you are able to select them at the Hugin service... Also notice that sometimes the releseas are shortened versions of the original releases - however in those cases it is normally mentioned in the shortened release itself that the original version can be found at...)

2) Annual reports, Company www-pages
Annual reports and company www-pages offer of course a lot of such relevant information about the company that can not be found from any releases. By browsing these sources you can not only find information about products and services but also about almost all other things. Even customer orientation, company values and corporate culture can somewhat be sensed by browsing this material.

3) Newspapers, newsletters
Newspapers and vast amount of different www-sites offer also valuable information for the analysts. This information might discuss the company directly or about the products, markets, technologies or competitors it operates closely with. With newspaper supply a very good and real time source for the analysts are the newsletters that are delivered directly to e-mail and are normally free as they are financed with advertisements. In Finland many financial newspapers (like Taloussanomat, Talentum) have this kind of free service.

4) From company directly (Investor Relations)
Company Investor Relation -services are dedicated to offer investors information about the company. Of course they can not reveal anything that might have instant effect on stock price as that kind of information must be revealed to all investors simulataneously with stock exchange releases. So it is no use in asking investor relations about what kind of growth they estimate in their sales or ebit but you can ask them relevant background information about the published figures, products, competitors etc. Below is more about this under topic where to get information about competition.

5) Company infos, CMD, other visits to company
Companies normally arrange at least some public events per year where the management tells about published result (fiscal year or interim info) or their outlook and strategy in general (CMD = capital markets day). If you have informed company Investor relations - department that you are following the company and your analysis goes through customers through Valuatum Platform and thus through brokers X, Y and Z, then you will be invited to such events. Sometimes these events are also publicly convened. Analysts can also often meet management or CFO personally with meetings scheduled on their own. Especially smaller companies are eager to meet analysts as it is their way to increase their publicity and thus also share liquidity.

6) Other sources like: company sales/cust service, customers, competitors
The best sources of objective information are of course the crucial operating activities: company sales/customer service, customers, competitors... If you talk with the big customers of the company and they reveal that they are not satisfied and decreasing - or that they are very satisfied and increasing - the sales from the company, then that is of course the most powerful information that you can have supporting your analysis.


What is important in analysis to try to estimate?

Profit development one year ahead is crucial for share price

If you could estimate the results of companies one year ahead with an accuracy of about +/- 10%, then you could in many cases make a lot of money.

If you look at the shares that have appreciated 30-100% or even more last year, you will most likely find one common characteristic with them all: their sales and/or especially EBIT or EPS growth has been much bigger than investors had expected last year. In many cases, with smaller companies there were clear signs of that kind of potential to be seen but nobody brought these things forward to wide audience. Perhaps because nobody really followed those small companies carefully enough. This kind of opportunities are the ones that the analyst should try plot. And of course it is also important to find opposite cases with unexpected bad performance.

Difference to consensus is crucial - compare you estimates with consensus

The markets price each stock according to its own expectations. The best estimate of "the market estimate" are provided by the consensus estimates. Thus, if there are consensus estimates available , you should always compare your estimates to them and have clear reasons why your estimates are higher or lower than consensus. These are the most important things that you should also write to your forum comments. If you e.g. expect that the company profit (EBIT, PTP, EPS) for next quarter is clearly bigger than the consensus seems to believe - and that is not a non-recurring phenomenon but more permanent rise of performance level - then this should also mean a share price increase directly after the result announcement. Thus: you should tell this in your forum-comments and also give good reasons why you expect better performance than research providers in consensus.

In Valuatum Platform there usually are consensus estimates available for analysts, so finding consensus should not be a problem. Of course we can not have consensus for every small company as there probably isn't consensus available from them and partly also because we do not have access to figures of every consensus provider. However, the consensus that we have in Valuatum Platform available for analysts is going to significantly increase already in the near future so majority of the companies followed should also include some consensus estimates (in 2006 and thereafter).

Company performance after one or two years is not too important

Even though profit development next year is very important to try to estimate roughly in the right range, it does not make much sense to try to put much energy to estimates that are more than 2 years in the future. They should of course be rational, consistent and at certain generally defined resonable level as explained later on in own chapter, but to be honest they have very little intrinsic value. Of course they affect the DCF-based fair value, but it is not a parameter that really determines the share price as explained better below. The real pricing of the stock is normally done at the markets by the pricing multiples of current year and next year. So profit development about 2 years from this moment is most crucial, often even more shorter periods. Other future years are the less meaningful the more far away from the current they are. Estimating about distant future is very difficult and market does not even try to do it honestly in determing the right share price level. The market does of course discount also the distant future and thus the market value of profitable growth companies often includes assumptions of good performance in many future years as well as the the market value of unprofitable companies often includes assumptions of continuing bad performance in future years. This is however different thing as it is done in a very general way. What really determines current share price is the performance here and now and the performance in near future where markets have clear visibility.

Company performance in this quarter

As stated above the share price of a company is determined with performance in near future where markets have clear visibility. With industries in dynamic or cyclical environment the markets normally have good visibility only for current quarter results that is published in few weeks time as from that "future" they have both management guidance and lots of news flow from what has happened. It means that, in most cases there is no tremendous share price effect with the next result announcement, and thus there is also no tremendous value available even though you could estimate the next quarter result with two-digit-accuracy two weeks before it is published. This can be best seen from share price graphs: a good result announcement might increase the share price by a couple of percentage points within the announcement day but in this kind of cases the share price has normally appreciated during the past quarter normally by more than 10%-points.

So, only a fraction of the upside potential is realised with the result announcement and most of it is already in the share price. It also means that you should concentrate not on "the decimals of this quarter result" but preferably on "the trend and expected rough level of profits in current quarter and couple of quarters thereafter". In other words the investors are not so interested if you can say a week before the result that the result will be in rage 234.9 - 235.1, as they would be if you can credibly explain why the result of the company will be on average increasing about 20% e.g. in the next three quarters. The first one is most likely already in the share price but the latter is hardly there.

Some people might hereby protest and see it particularly important that the analyst is able to accurately forecast the result a week before the result announcement. And I admit that thereby investors might be able to earn some percentage points as I already stated above. And I also admit that this kind of short-term predictions are much more valuable and interesting than comments right after the result about what did happen and why the result was like it was - without any new information to markets about what will happen next quarters.

To sum up: market expectations are conservative and wait status quo to remain

At this point you perhaps feel a bit confused about what is important in the analysis: Is current quarter important or not? And what is it that markets expects currently and what does it not expect?

This is how we believe the market normally behaves and what it expects:

  •   Well performing companies - Markets are conservative: if the sales and profits of a company have been increased by e.g. 30% a year for already some time then market expects that the situation will stabilize and the growth will slow down soon. If you are sure that the growth will continue or even accelerate during the next year, then it is most likely a buy-case: the share price will probably appreciate during that year much more than the normal cost of equity i.e. more than about 10%. On the other hand, if positive development breaks very rapidly (as markets normally expect gradual slowdown) then the share price might come down also very quickly.
  •   Ordinary and stable companies - Markets expect the status quo to continue. If you have reasons to believe that this kind of company suddenly improves (or declines) a lot then there is big upside (downside).
  •   Poor companies - Markets normally expect the companies to get out of trouble but very slowly. And markets normally do not believe until they see clear facts about the improvement (first positive quarter). So promises of improvement are normally not fully discounted into the share price. These cases offer always upside if you have reasons to believe to the improvement. If there is no improvement, then this kind of companies are of course always overpriced: loss-making companies are options where investors bet on improvement. If the improvement does not come then anything is too much to pay for these companies.

    Att: each standard cases above must be used and viewed in the light of current valuation: if the pricing ratios like P/E are very high then of course market expects very good profit development in the future years. If P/E ratio or P/BV ratio is extraordinary low then the markets expect already quite bad performance to continue for some time. This means e.g. that "ordinary and stable" company might for some reason (very optimistic management guidance, rumours etc.) have great expectations (high pricing ratios) inside its current valuation and thereby of course continuing stable performance is a disappointment for markets and decreases share price. You can use e.g. valuation scatter to compare valuation ratios vs growth /profitability estimates of different companies.

And what period is then important for the analyst to forecast?

Above is discussed what markets normally expect from different companies. You should focus on the periods which are as close as possible (to be interesting) but so far away that the markets do not (yet) see there. So if you feel that markets do not know about next quarter, then you should focus on that. If the question is about a big company and the next quarter result announcement is quite close, then it is often the case that markets do already know a lot and there is very little room for surprices.

Thus "what markets do not see" depends slightly on situation and thus varies case by case. And of course you do not have to try to dig something "surprising" for every company as there is perhaps no unexpected things going to happen during the next year - at least things that could be foreseen. That kind of cases should normally be in "Hold" => if there is nothing that the markets would already know by now, then everything is already discounted in the current share price. Then there is no reason for you to say that the share should be "BUY" or "SELL"... Of course there is one exeption: if a company is very profitable and perhaps even grows fast, then it is of course a BUY if it "only" can maintain its status quo as markets can never price this kind of companies with their intrinsic value but rather wait - very rationally - that the performance will deteriorate sooner or later.

And remember also that forecasting in itself means nothing, only your arguments within these forecasts mean something.


How far should I estimate in quarter level (net sales and EBIT)?

Current year

Current year has to be estimated in quarter level. In fact, there is even no full-year estimate cells available.

Second estimate years

In normal case it is enough to have full-year estimates for the second year. But when year end is getting closer, you might consider making quarterly estimates also for the second year.

Quarter estimates for the following year should be made at the latest before running YearChange macro. In technical aspect you can still ignore those estimates but then the year change would cause a significant change to fair value as (new) current year growth and EBIT-% would become 0.

Third and fourth estimate years

You can always stay in full-year level when you make net sales and EBIT estimates for the third and fourth estimate years. The reason why there even is a possibility to estimate in quarter level, is mainly technical.

Quarter estimates dominate

Please, remember that if you enter both quarter and full-year estimate, the latter is ignored.


Seasonal variation in estimates

Some companies have quite stable turnover and operating profit between different quarters. However, other companies tend to sell each year more in certain time or make the most of the profit in certain quarters.

Consider for example a skiing center: the most of the turnover is created in the winter, while the revenues in the summer may be close to nothing. Again, some consumer goods are sold mainly at the end of the year, in christmas.

This phenomenom is called seasonal variation and you should take it into account when you think about your estimates.

How to take seasonal variation into account in Valuatum Excel model?

There are three things that help you in this:
Division graphs in I-divQ sheet
Info fields in I-divQ sheet and
Quarter graphs in O-quarter sheet.

The divison graphs are most helpful things with estimating the seasonal variation and therefore there is even an own tutorial page for them. You really should learn how to use them (it is so easy that you do not even need instructions for them as long as you only know where to find them).

Info fields in I-divQ sheet and Quarter graphs in O-quarter sheet

When you look at the Info fields in I-divQ, you can see the periodic historical values and also your estimates in the same rows. If there are considerable variation between quarters, take it into account in your estimates.

Perhaps an easier way to notice a possible variation is to look at the graphs in the O-quarter sheet. You can just change the sheet or change view: click the button in the left upper corner of I-divQ and you get two sheets to the view at the same time. When you click the button again, you will get back to the original view.


Estimating long-term growth and profitability

Short-term vs. long-term estimates

The basis for the short-term estimates is the current situation in the company: the management guidance, cyclical situation, analyst's own assessment of the competitive situation and market. However, the basis for the long-term estimates should be more the long-term growth of the sector in general.

Leveling off long-term growth

All rational company estimates are based on the fact that sales growth levels off near to the long-term GDP growth (about 3%), no matter what the business is. This means that also growth companies become "ordinary" in the long-run — even some software or mobile phones cannot grow more than 5% a year forever... Att: there is even a mathematical problem with high growth rates (higher than WACC), which makes fair value negative with high growth rates.

Profitability

Even more important for the estimates is that profitability should be leveled off to normal levels. Profitability is estimated/changed in the model with EBIT-%, but you should follow profitability with ROI-%or EVA which are much more relevant measures. In our competitive world we have to assume that sooner or later competitors will catch any company in the long run and "abnormal" profits (large positive EVA, greater ROI than 15%) will melt down.

Star companies

Of course there are companies that will not follow this rule during their next 5 years, but it is no sense that we try to "see" it in our 5+ years estimates. Those companies that have grown very rapidly and have been very profitable are for example Nokia and Microsoft. Their share prices have appreciated about 10 000% and 300 000%
correspondingly. There is no sense in trying to catch that kind of stars: it is enough if we find that those companies are more than 50% undervalued because they will grow more that 30% for the next 3 years and remain very profitable.


How to set value for Tangible assets / net sales %?

How to choose percentage value?

Normally companies need certain amount of tangible assets relative to their turnover. In many industries this proportion is quite constant in the long-run. For example a pulp & paper company might have had fixed assets about 85% of its sales and the proportion has alternated between 81% and 89% for the past ten years.

Simplyfied this means that the company needs to have a paper machine worth 850 mEUR in oder to generate 1000 mEUR sales in one year. Thereby it is very unlikely that the proportion of fixed (tangible) assets would change much relative to sales either in the future. Therefore it is quite logical basis for the estimates that the relation between tangible assets and net sales would remain roughly at the same level also in the future.

Estimates in Valuatum Excel model

In Valuatum Excel model this would mean that you can first copy the value of Tangible asset / Net sales from the last history year (I-main, J14) and paste it (as values) to estimate years (I-main, K14:T14). If you have not estimated investments with tangible assets (I-main, K13;L14;...) in absolute terms, the Tangible assets / Net sales parameter will adjust the investments automatically.

Differences inside of industry

Often the Tangible assets / Net sales ratio is rather constant even inside a certain industry, so competitors would have pretty similar relation between tangible assets and sales. Of course it is normal to have some differences between different companies inside the same industry. Some other pulp & paper company might have e.g. proportianally bigger share of certain product types (like: fine papers, tissue papers etc.) and the different products tie capital differently in production assets.

Furthermore different companies might have different philosophy in these issues and therefore two companies with exactly same businesses might have different "asset turnover". Others tend to use their old machinery as long as possible and others tend to keep their production facility very modern. Thus the latter group might have more efficient production capacity and also smaller variable costs but higher depreciation percentage.

Fine tuning

As you have set the parameter (Tangible asset / Net sales) roughly at the right level, you can (and often also should) do some alteration to either this parameter or directly to investments (I-main, K13;L14;...). It is often so that at least current year values are easier to estimate directly with absolute investments as we often know what kind of investment plans the company has for the current year.

If you estimate only with the Tangible asset / Net sales parameter, you should also take into account cyclical factors (capasity utilisation is different over the cycle and it affects Tangible asset / Net sales) and possible changes in group structure (relative share of certain business in the group might be changing).


Estimating Working capital

Formula for Working capital

Working capital consists of three parameters (see more info in ValuModels tutorials):

Working capital
= Inventories + Receivables - Non interest bearing current liabilities

It is estimated with the corresponding percentage figures: Inventories / Net sales %, Receivables / Net sales %, etc.

How to choose percentage values?

As with Tangible assets above, it is reasonable to assume that company remains the same level of working capital related to net sales as in history. For example usually when net sales grows, inventories grow too. And since receivables consist mainly of sales receivables, most probably also receivables increase.

So when you consider values for these three parameters, start with the last history year values or some average value from the latest history years.

Estimates in Valuatum Excel model

If you use the latest history year values, copy the cells J22:J25 and paste as values to the estimate columns (K22:T25).

Fine tuning

Since it is important for companies that working capital would tie as little capital as possible, they have a tendency to lower for example inventories level. You may see this in historical Inventories %, as the value may have come down year-by-year, and thus assume that this trend would continue also in the future.


General instructions for providing comments in company specific forums

What should be written in company forums?

1) Comments on estimates
The most important thing in company forums is to provide arguments about your estimates. Your estimates are reliable only if you tell what they are based on - especially if you do not have a very long track record and thus people can not see that your estimates have been very accurate in the past. With good estimate comments users can not only see what facts support the current estimate but also the risks, possible range of outcomes etc. We have dedicated instructions for estimate comments, please look at them.

Historical figures: comparability
Sometimes you have to describe also the past so that people could understand the estimates: Some companies have also had some restructuring or other major changes in the past meaning that past financial performance is not very good indication for future financial performance and these things should be described.
Adjustments
If you have adjusted the company figures somehow e.g. by transferring some capital gains or other non-recurring items from EBIT to Extra Ordinary Items, then this should of course be explained very clearly (with own company forum message which header could be like: "Adjustments made to 2004/Q3 income statement..."). You should not only tell clearly what you have done but also the arguments for doing it.

2) Market position, competitors, competitive advantages...
Besides estimate comments you can also describe any other essential things within the valuation of your target company. Those things include e.g. competitors, market position of the company, competitive advantages, historical track record and credibility of current management etc.

3.) Something new...
If you want to be pro then you can try to satisfy the needs of institutional investors and their fund managers. They always require analysts to "Tell me something new!". Fund managers and sell-side analysts typically know their domestic target companies rather well and they get masses of sell-side equity research from big companies. Therefore they have normally heard all the normal stuff. They call attention only to something that has not been told them already. This kind of things might be e.g. things about the business itself:

1) down-to-earth comments of the competitive edge of a complex and not-so-well-known product (like Basware) => why is it competitive, how close are the competitors, how big market will they have ahead..?
2) effects of new technology in certain industry (up to revenue and margin level) like VOIP, wlan or push-to-talk in operator business => will almost all voice get into data networks and when, what does it mean to operator revenues and margins?
3) what are the real consequences in sales and ebit -level of certain transactions like when Tietoenator gets lots of IT-outsourcing contracts => how profitable contracts are they in the long run, how much of them will we see in the future...
4.) What kind of growth opportunities certain companies will have in the foreign markets and why would their product offering be competitive there (like: Ponsse in Russia, Kesko in Baltics etc.)

...or things related also to the valuation:
5.) company X will reveal such figures that have not been expected as current EPS consensus estimate for yyy is ... and EPS has to be at least... because...
6.) next year P/E would be below ... which is lower than it has ever been ... lower than any other company within the same industry and this company has always been valued more than .... since...
7.) this reconstruction would mean that company ebit ... ...meaning that ROI would.... ...and as the P/BV is currently ... => the company will double its share price if and when the P/BV will rise to the same level as all the other companies producing that kind return. E.g....

Like you and me, institutional investors also like concrete things: they are perhaps not excited about your story how some technology will change the world. But they would like to hear it if you can also tell how it changes the figures of a certain company, at what level the valuation figures (like P/E, EV/EBIT, P/BV) will be after these changes have happened, how and when this change will happen and what are the proofs of it. So if you can tell with solid and understandable arguments why the share price of a certain company will rise more than 30% then you will be heard.

Do not put news on the forum

The company forums are not a news channel. So do not copy-paste many company press releases on the forum (or even big clips from them). There are different organizations and companies inside the media sector which are much better in these operations - so leave it to them. Besides: if we all would put many press releases on the company forum, it would be 90% full of them and important things would not stand out. Of course you can and perhaps even sometimes should quote some important things from those press releases - at least if you also tell your own comments on them: how this is going to change the company figures or affect valuation/share price in the long-run.

Commenting company news or rumours

Of course you can inform investors about some major news in the forum, but only in those cases where you have something to comment on the news: if your company has made a major acquisition you can tell whether you see it affecting positively or negatively on the share price and especially why it does so and how big the effect would be (with quantitative comments). If the news do not affect share price, then why bother commenting them. Only in those cases where media tells some negative news about the company with big headlines and you think that those news do not affect the company´s financials, should you comment on it on the forum. Thereby you have important message: "do not believe in the media, this event is not important for the share price" (or: "this persistent rumour is not likely to be true or happen"). To sum up: If there is news from the company but you do not believe it is important or you have nothing to say about it, you would only echo the news from the media, then do not write anything. For company releases we have the the company website address on background page. And remember that investors follow media themselves, analysts should not try to repeat news but to point out and analyse the most important things - whether they have been in media or not...

How should the comments be formulated?

Try to be brief with your comments. Use headlines also inside forum messages to make the text more readable and to enable reader to choose/skip parts that are interesting/non-interesting for him/her at the moment. Also providing summaries at the top is a very good habit. Remember that many investors browse ranking lists and multi-criteria rankings and as they find plenty of interesting companies they quickly browse their figures and comments on their figures. Thereby they are not very happy if the essential things like solid grounds for current year result or information from competition and competitive weeknesses and strengths are hard to find from the text. Already forum message headings should include the most essential things. And plenty of unrelevent forum messages hinder that the investor does not even find the right message...

Of course you can also write long comments and thoroughful information about some things. That kind of information is of course valuable in some cases and for some users, just ensure with the above means (headings, sub headings, summaries etc.) that you serve also busy investors.

You can also add images inside your forum-messages, look here how it can be done.


Commenting and providing arguments for the estimates of current year

Quantitative vs qualitative comments

Arguments for estimates should be both qualitative and especially quantitative. Always justify qualitative argument with quantitative facts (such as last year's corresponding numbers, order book and their development). They are a good way to add credibility to your arguments. And remember that graphs e.g. from quarter development illustrate the situation very clearly so please use graphs to back up your text.

You should also try to estimate what kind of quantitative impact a factor is going to have. Try to give a good insight on what presumptions your estimates are based on and how possible changes in these presumptions would affect your estimates. Use arguments that people can easily comment on and you can later get back to see what went wrong and what you were right about.

Do not try to give too exact numbers like 356,7 MEUR as your expectation - use rather acceptable range like 350-360 MEUR (range depending on uncertainty). Of course your analysis (model) includes exact numbers but in your comments you can use ranges to describe the uncertainty of your assumptions.

What things should be commented?

Normally you should comment at least the following: Net sales, EBIT, EBIT %, their development and management guidance. The advice of "commenting EBIT" should not mean that you expect EBIT of xxx mEUR but that your current EBIT estimate is based on the facts like... ...and these assumptions are backed by facts like... So please, do not just tell WHAT your estimates are (everyone can see it), but describe rather WHY your estimates are at certain level.

Quite often we need to understand the past in order to understand the future. Therefore it is also good to briefly go through what has happend in the past and from there draw conslusions what will perhaps happen in the future. Normally e.g. total turnarounds or profitability crashes do not happen over night but there are some signs about changing company performance during at least some quarters before any such change really occurs. And thereby you should comment also past performance and tell how you have interpreted it and how it has affected your estimates. A very good and recommended way to do this is to attach a couple of graphs from company views pages to back up your story. Instructions for adding graphs can be found from here.

Depending on company one should think about commenting order book, seasonal variation, balance sheet structure, investments and naturally all factors that have a significant impact on the profitability of your company.

Tell also what others think and comment possible differences. This is important so that people can see why your estimates differ from others and later one can easily see whose presumptions were correct. If consensus estimates are available, it is good to reflect your estimates on them. Do not use irrelevant remarks, which often result on question why. Don't leave readers wondering: "why?".

What kind of comments are possible?

Sometimes the analyst generates her estimates like this: she looks that the company has been growing for about 5% a year within the past 3 years and it has produced EBIT-margin about 10% each year. As there are really not any other relevant information available (company is not eager to give any information, and the business represent such a niche that there really is nothing publicly available about it), then the analyst makes a cautios estimate - based on these tiny pieces of information - that the company will grow 4% this year and the EBIT-% will be 9% (both slightly less that the realised figures) and that the capital tied up to business will be at the same relative level than with previous years (fixed assets/net sales%, inventories/sales-%, receivables/sales % etc. will remain stable).

If this is the process how the estimates have been generated, then the analyst should tell it openly to customers/users in the company forum. I know that it sometimes embarasses analysts to tell how simply the estimates have been formed - they would prefer to describe that the process of generating estimates have been much more complicated and the analyst has taken into account dozens of sophisticated factors.

However, describing the simple way of processing the estimates is actually very valuable for customers. With that information the customers are able to form their own scenarios much easier: if they happen to know some factors affecting next year sales/EBIT positively or negatively, then they can also estimate easier how the EPS, P/E etc. will differ from the estimate of the analyst. So, please tell the users exactly how the estimates have been formed no matter how simple the process has been and how little information there has been used.

Customers can also better make comments that might help you with your estimates. And they can give these helpful comments often only if you have been open enough to reveal how you have generated your estimates. The customers might give you hints about things that should be taken into account: the effects of new competitors or competitive products, new demand from certain geographical areas or towards certain products or any other interesting information. The more open you are, the more open and helpful the customers are likely to be with you.

Furthermore if the analyst makes the estimates in a simple way described above and takes thereby, in cases necessary, into account also some relevant minor things like seasonal variation, then the estimates might turn out to be very accurate. The simple way of processing the estimates is often a very good method - also from the point of view of estimate accuracy.

Estimates produced originally with a simple method can also be adjusted slightly upwards or downwards according to intuitive feeling about the management, tightening competitive situation, future trends or things like that. And these intuitive ways in adjusting the estimates might turn out to be very successful especially what comes to estimates beyond next quarter as there are often no accurate information or any guidance available after that. However, any intuitive adjustments made to the base scenario must always be commented transparently. So, even if some of your figures are based on feeling about vague things "tightening competition" and not to accurate calcuations, you still must tell those grounds to users.

Management guidance

Include management guidance to your comments. Tell what the management is expecting and compare your estimates with them. Always justify any arguments that are not in-line with management guidance.

Make obvious difference between your own thoughts and those of management or any other person. You could also check out and tell how accurate the management guidance has been in the past and how reliable you consider this information to be.

Uncertainty in estimates

If you are unsure about some things in your estimates (like you probably are), don't try to hide it behind fragile explanations. Not only tell what you know but also what (relevant) facts you don't know. It is better to tell that you are uncertain about these things and about their impact on estimates than to ignore them.

Also if you cannot estimate how big quantitative impact some factor is going to have, you should admit it. There are always some things that cause uncertainty to estimates and there is no reason to deny this. It is very essential information to tell investors things like: "I have not been able to gather information about the effects of...." OR: "this figure is more like a sophisticated guess than... " OR: "it is very hard to say how and when this is..."

Feel free to look help from those analyses that have high points. Still keep in mind that every company has its unique situation and thus there are no "universally good style" to formulate your comments.


Setting and arguing recommendation

Before reading this section you should have read the section "What is important in analysis to try to estimate?". It discusses also the basis of recommendation and different valuation cases thereby. We also recommend that you would use valuation scatter in estimating the valuation of your target company.

The key factors when setting investment recommendation is that an analyst
1) makes justified target price assumption of the company based of future financial perfomance and current valuation (with e.g. valuation scatter)
2) compares the company (valuation multiples and financial perfomance) to other companies (with e.g. valuation scatter) and
3) above all gives transparent and realistic arguments for all the factors he/she has pondered hereby, so that an investor (a customer) can see which of those arguments are reliable and which perhaps not.

The recommendation should never be based on your (unexplained) "feeling" and the recommendation should always be based on/ in line with a long-term target price set by an analyst.

Setting target price

What should the target price then be? There is no exhaustive answer on that question. There are several valuation methods, and important is that you shouldn't blindly trust one. Instead use many methods together and then set some kind of consensus target price.

Different valuation methods

Relative valuation (comparison with other companies):

For example if some multiples (e.g. P/E, EV/EBIT) are lower/higher than the ones for companies in the same industry (or companies in general). Be careful using this method, because the variable of your company may well be at the "right" level when the industry is over/undervalued. Furthermore the company itself might have such characters that justify lower relative valuation than its peers: weaker profitability etc. Hereby you can use e.g. valuation scatter.

Absolute valuation:

Some variables are very low/high. For example P/BV (Price / Book value) is low (e.g. below 1) despite of that company's profitability (e.g. ROE %) in the future seems good (e.g. better than 20% in the same time as P/BV is below 1). In this case you should recommend buying this share, because when the markets notice that profitability will improve, the P/BV (the share price) rises. Hereby you can also use e.g. valuation scatter.

DCF (discounted cash flow) value:

One thing that should also be in the line with the recommendation is the DCF value of share price. The DCF value should rather be supportive for the recommendation than be the factor on what the recommendation is based on. In other words, it is preferred that you adjust the DCF value to support your recommendation, and not vice versa, because DCF can be manipulated easily: by manipulating profitability or growth estimates in distant future you can always make DCF fair value look like as the company is "cheap".

DCF parameters (mid-term growth and profitability) should be set at the level, which makes your the DCF fair value to be about the same level as your target price (which in turn is defined by other means than DCF). If that is not easily possible (requires too high or too low estimate parameters), then it is of course a sign that something is wrong and you should rethink your target and the whole valuation. Thus the DCF acts best as a kind of "reality check": it checks whether your target price is approximately at the right range.

Remember that good profitability and good earnings development always reflect the share price. In the very long-term share prices follow the return on equity (ROE%) of the company. In the short term does not as the current market value can be far from equity book value and as current valuation (P/BV) reflects the whole future and not just one or two years.

Do not forget to compare to other companies

Analysts sometimes tend to "fall in love with some companies they analyse". This happens especially if the companies are very good at what they do. This sometimes ends to buy recommendations even in cases when the company or the whole industry is overvalued. That's why it is vital that you remember to compare your company to other companies and use that information when setting the target price and recommendation.

Great help for doing comparison gives Multi-criteria rankings (MCR) page in ValuViews where companies are ranked based on different variables. If your opinion differs a lot from MCR lists, you should give very clear justification why you have ended up on your decision. Another, perhaps even more illustrative comparison tool is valuation scatter which you should also use hereby.

For example, if the company you are analysing is located on the top of the MCR or scatter list and your recommendation is reduce, you should argue why you have decided this way. However, the MCR-list is not pure truth, so don't be afraid to disagree with it. For example a company may well be at the bottom of the list because of current bad financial performance, but the financial performance might be improving in the next years (there are already signs of that but profitability lags the other signs like improved customer orientation or improved operative efficiency which can not perhaps be seen in ebit because of overcapasity or something like that) and the market may have not noticed it yet.

Briefly, if the company is "bad" at the moment, it doesn't mean that will always be "bad" and cannot improve - but there must be reasons and proofs of that improvement - otherwise it might be bad for next ten years. So do not just expect that something must happen.... However, one common feature of really good investment target is that market is not yet aware of something that will happen.

Check list to see if the company really is cheap

The following list should be checked if you bump into company that looks very cheap with relative valuation: cheap P/E, EV/EBIT, P/BV etc. ratios:

Does the drop in earnings seem obvious (bad competitive position, cyclical fluctuations downwards inevitable in the future for the whole industry, no superior competitive strengths that would protect from future competition etc.)?

Are there some signs in the owner structure that might weaken the position of company in the long-term (main owners might want to take all the cash out of the company etc. with transfer pricing - in situation where unlisted parent company owns listed daughter company is always a very big risk - especially if they have common business and therefore room for overpriced transfer pricing in transactions)?

Are there any other features that may weaken the position of a company in the future?

Summary

Use long-term investment horizon when setting the target price and recommendation.

Use complete yet understandable arguments to explain why you have ended up to your recommendation.

Don't set recommendation separately from the other companies (MCR and scatter lists).

Don't use only one method to value the target price.

Check that the DCF-value is in the line with your recommendation (adjust fair value if possible, if not possible (requires unrealistic future estimates) then rethink and adjust target price and recomm.).

There is not one right way to value the price of a company, thus use many methods. Use relative and absolute valuation and try to find hidden strengths and weaknesses that market may not know yet. Based on these decide (long-term) target price.


Description of competitive situation and position in markets

Description of the biggest competitors

You might want to write a brief description of the worst competitors of your company. It should be able to answer at least to the following questions:

  •  What is the current competitive situation, how has it been developing and how do you believe it will develop in the future?
  •  How are market shares divided among companies? How have they been developing and how do you see the future?
  •  How big and profitable are the competitors?
  •  What are the major differences between the competitors?
  •  What are the strengths and the weaknesses of each competitor?
  •  Has the competition any special features (such as government regulation or major changes)?
Comparing to others

Always compare features of companies to the ones of your company. This way readers can get better vision of the market situation than just plain numbers without context. Remember that companies also have different kinds of valuations. If some company is in superb situation, growing fast or has exceptional profitability, it is natural that this company should have higher valuation. Valuation can be seen for example in P/E-, EV/EBITDA- and P/B - ratios. Compare these figures in your company's peer group. Still the acceptable level of these figures should be determined case by case.

Competition methods and advances

Tell about the competition methods of the business. Are companies competing with price, quality, image, brand or something else? What are the competitive advances of your company? Tell about their nature for example whether they are long-lasting or easy to copy and therefore temporary. Is the importance of your company's competitive advance diminishing or growing? Think also about the future and possible changes.

Try to express the situation in a way that everyone can assess how competition will develop in the future and how each company is going to succeed in it. You may also try to compare things like brand and image among peers group. Although it's difficult to estimate the importance of brand, it is clear that a strong and well-known brand has a significant effect on competitive situation and on consumer choices.


Where to get this kind of information?

First you should ask the company (investor relations contact). The company has surely information about its competitors and their market shares etc. and normally they also give investors at least some of this information. Even just a list of competitors is a good start and thereafter you can put the names on Google and... Also customers of the company are a very good source of information and they can tell you also much more interesting things than just the name of potential suppliers. The customers can reveal also why they prefer some suppliers over the others i.e. what are the relevant competitive advantages that the companies may have.



The track-record and creditability of current management

Importance of management guidance

Management guidance (or management outlook etc.) probably has a lot weight when considering estimates - Normally it can be said that the management has the best view about how their company is really doing and what the future holds for them. This, however, does not mean that you should believe everything management says without checking the facts.

Track-record and creditability

What you should do is find out and tell how accurate the management guidance has been in the past. Best way to do this is to use the track-record of management: basically you just tell what the management has been expecting and what has been the actual result. Compare estimate vs. actual, simple but effective. With this information you, and every one else, can measure the creditability of current management. If you for some reason doubt the credibility of management, always justify your arguments with facts. Management probably doesn't appreciate if their trustworthiness is questioned without solid arguments that are backed up with facts. For example you can support your thoughts with developments of net sales, profitability, order book or market situation.

Good management vs. bad management

Even the best of us make mistakes and management is no exception. What separates good management from bad management is the amount of mistakes and the quality of communication. Bad management makes perhaps more mistakes, more serious/stupid mistakes and/or it does not reassess and communicate the situation so quickly to investors than the good one. Good management tells relevant information openly, honestly and without delays. Bad management normally communicates poorly with the market and maybe even, in some extreme cases, delays, hides or twists relevant information (this naturally is against law and very extraordinary).

Management guidance and expectations - Different styles

It is good to recognize the style of your company's management. In many cases management gives cautious and modest estimates, so they can be outperformed and disappointments are avoided. In the other end there are some companies that are constantly over-optimistic. These companies are due to disappoint the market with less than expected results. Some companies don't really offer much management guidance - they just settle for stating some obvious facts. This is quite common among smaller companies as they typically have less resources for this kind of things. Fortunately there are also companies that can normally offer both realistic and useful management guidance.

Summary

All in all, good management can normally be trusted and it's accurate enough on its estimates. On the contradictory, bad management can rarely be trusted and its expectations can be more based on a feeling than actual facts. Still, if you don't trust management and you're estimates differ from theirs; always justify your thoughts and estimates with good, fact-based arguments. There are also different kinds of styles giving management guidance - try to recognize the style of your company.


WACC - Parameter guidance

The Importance of WACC

WACC (Weighted Average Cost of Capital) is a key component when DCF fair value is calculated. Even small changes in WACC may cause significant change in DCF. WACC alone is not that important - nobody makes investment decisions based purely on WACC. To some extent you can even modify WACC-parameters to justify your own fair value with DCF. Still remember that this can be done only after you have done reality check with DCF that has not been modified.

WACC - Parameters

How should you set WACC-parameters? Here are some tips how it should be done:

Tax rate. Simply fill out your company's tax rate. Basically this is your company's home country's tax rate for companies. In Finland the tax rate is due to decrease to 26 % (from 29 %).

Target debt ratio (D/D+E). In many cases company has stated their target debt ratio. If your company hasn't, you can think what it could be. Try to stay away from extremes. Depending on company, the debt ratio is normally around 5-60 %. Do not confuse actual debt ratio for the target debt ratio. They are usually two completely different things, but we prefer to calculate WACC with long-term target insted of volatile actual values.

Cost of debt. Try to estimate what is the cost of debt of your company. Cost of debt varies according to company and economical situation. Try to estimate your company's cost of debt, if company doesn't tell it or it can not be reliably calculated from financial statements (sometimes the company includes such items in interest expences etc. that the calculated values do not tell the whole truth). This such as size, financial situation, profitability and possible credit rating affect the value. Normally cost of debt is about 0.25% - 1.5%-points more than risk free interest rate (for small/unprofitable companies somewhat more than with blue chips). If you have not better way to estimate the value, then you can e.g. assume that it is 0.75%-points more than long-term risk-free interest rate - and it probably is not very far away from truth. So if risk-free rate is 5%, then let cost of debt be 5.75%.

Equity beta. Describes what is the relative equity risk concerning your company (normally the risk of its business sector). The average beta is 1 and thus the companies that have about average risk have beta of 1. If the business is more risky (very cyclical, high fixed costs/operational leverage) then the beta is more than 1 (normally 1.1 - 1.5). This kind of businesses are e.g. internet business (high fixed costs, high operational risk), pulp and paper (cyclical and high fixed costs). If the business is less risky (very smooth: not cyclical and not very high operational risk) then the beta is below 1 (normally 0.6 - 0.9). This kind of businesses are real estate and food and beverage retail and production. We have made a table that has different betas for different businesses. That page tells also other information on beta and its estimation. Normally you get biased betas if you estimate them from market data from illiquid companies or illiquid /not-so-diversified markets. Therefore it is normally better to estimate the beta yourself than to get it from market data. You can estimate them by assessing whether the company is more or less risky than some other industries whose beta you know.

Market risk premium. It describes the premium that equity investors tend to expect to get when investing to equity markets compared to return they would get from risk-free investments - long-term government bonds. Normally equity research producers use hereby values between 3.5% - 5%, even though some academic research has suggested also that the premium might be as big as 6%. The problem is that there is no method to get/estimate the value in reality, so we just have to take some reasonable value here. It would also be important that the value would be about the same with every analyst and currently we recommend that this value would be 4.75; So use it until you hear otherwise.

Risk free interest rate. Input the interest rate of government 10 year bond. For example Finland's government bond it is currently about 4,3 %. You should use the one of your country/your own currency area. The risk free interest rates varies a bit in different currency areas as the long-term interest rate holds inside the expectation about the future inflation. As the real interest rate (interest what people expect to get from risk free investments after inflation has been deducted) is about 3%, then the long-term risk free interest rate is currently: real interest rate + current long-term inflation expectation = 3% + 1.3% = 4.3%


Setting fair value and the meaning of DCF

How to determine fair value of company?

Fair value of company should be determined using different kinds of multiples such as P/E, P/BV and EV/EBITDA, development of sales and profitable and for some part DCF model. Multi-criteria Rankings is an excellent tool for determining fair value of company. Value of company should always be compared among its peers and competitors and also the current level of valuation in overall markets.

Read more about this (if you haven't done it already) on Setting and arguing recommendation

Reality check using DCF fair value

DCF is at its best when it is used as a reality check as it should be. With DCF you can see what would actually be demanded in certain price - expectations considering growth, profitability and their development. Had this been used in the end of the roaring nineties the outcome could have been different. Still DCF is not an absolute truth and should never be used without other methods.

Anyway the reality check with DCF is strongly recommended. If the difference between DCF fair value and the fair value you determined earlier is acceptable, you can continue to next step. If there is a significant difference between these levels, you should recheck your expectations.

Adjusting DCF to support your target price

After the reality check DCF can be modified to support and justify your fair value. Do not modify DCF before you have really thought about realistic fair value of the company and determined your target price - it would be useless and misleading. Adjusting DCF can be done best e.g. by changing parameters such as mid-term growth and profitability: Net Sales growth and Ebit-% estimates. By mid-term we mean e.g years 3-7 from current year (e.g. 2007-2011 if 2004 would be current year). If you slow down the current perhaps rapid growth towards the terminal value or decrease profitability faster than the previous estimates you also decrease fair value. If you increase growth and profitability (or preferably make them decrease in a slower pace towards the terminal value) then you increase terminal value. The terminal values themselves should not be manipulated much (See how long-term growth and profitability should be estimated.)

Most recommended way is to use net sales and ebit parameters, as all the other estimate parameters should be rather constant: there is not much sense in changing the average depreciation-% or changing the working capital or investments as there are normally only one reasonable level (look more info on tangible assets and working capital). Also WACC parameters are rather constant so they should ne be manipulated much. if you have big problems on adjusting DCF fair value to your fair value, check your estimates once again. Investors (customers) are able to see (as they should be) on what are your estimates based on. They can see your growth and profitability estimates easily. Remember this when you are justifying your target price / fair value - and never try to justify something that just is not there.


 

Submit a new question. We will answer it within 24 hours by e-mail.

 

Google
 
Web www.valuatum.com

Copyright © 2001 Valuatum Oy. All rights reserved. Disclaimer.