Starting analysis

Next you have to choose a company on which to do analysis. This is done by using the company reservation system accessible from the analyst main page.

It is possible for an analyst to analyse more than one company at a time, but further companies can be reserved only when the analysis on the first company reservation is ready and in the database (of course you can also cancel your reservation and reserve another company). When you have reserved a company, you will be provided with the Excel model needed for doing the analysis.

Where to get information about companies?

The easiest and often also the best source of information is company stock exchange releases. E.g., from all Finnish companies, you can find all the releases at Helsinki stock exchange www-site.

• Click advanced search and you can search database easily by companies.
• Open the company's latest financial report to know what happened in the last period.
• Read also the Outlook for future.

Opening the Excel model

Get an empty Excel model from the analyst section the web interface.

Open your Excel model just like any other Excel workbook. Model includes some macros. Excel might warn you about them, but when you just click "enable macros" the model should open without problems.

But if Excel could not open our macros, it's because your Excel's security level is set to be very high or high. In this case you should change your Excel's security level to be medium. You control these in the Security dialog box (Tools menu, Options command, Security tab, Macro Security button).

In some cases you might also pump into "Circular reference" -problem announcement when opening the Excel model. Put iteration on to avoid that.

More info about this: Circular reference problem

5.1. DB2Excel - Copying and using ready made information (prefilled numbers)

DB2Excel (from DataBase To Exce) is a tool that enables you to copy all the historical (and estimate) data from any other company/analyst from Valuatum database to your Excel model. So it enables you to start with prefilled model and you should absolutely use it as there is no sense that you would input all the historical data that has been inputted already by some other analyst. Click here for more detailed instructions about how to use DB2Excel.

Starting WITHOUT prefilled numbers
Some analysts might also need our Empty Excel-Model Step-By-Step Guide (located in Valuatum's old web pages). It is especially needed if you cannot obtain prefilled model but instead you have to input even all the historical numbers by yourself. Empty Excel-Model Step-By-Step Guide is also more detailed than this document so also other analysts might find help for some problematic situations from there.

What sheets are used?

Once you have opened the Excel model, you should see something like first picture below in front of you. This is the help sheet of the model. To get to the other sheets, click on the sheet names on the lower bar. Sheets that actually are important to you right now are I-main and I-divQ (I stands for input).

Information on the sheets

I-divQ sheet has income statement figures in divisional and quarter levels from few years of history and few years of estimates. All the other information can be found in I-main sheet. There you can find all balance sheet figures, share information, long-term estimates (both income statement and balance sheet), and everything else needed.

Output sheets

You can also browse information at output sheets like O-quarter and O-overview, but remember that you are not allowed to change anything on output sheets. All changes to figures must be done at input-sheets: I-divQ and I-main.

Past figures at I-divQ sheet

All the quarters where the numbers have already been reported has to marked as passed (with "x" in row 4). With past quarters the actual figures are inputted in cumulative section beginning from row 147.

So check the row 4 at I-DivQ-sheet and see whether all the historical quarters are marked as passed quarters.

E.g. if the interim report for Q1 has already been published, the column for Q1 estimate figures should be marked as passed with an x mark and the background color should be gray.

If the interim report of the first quarter in white

1. has not been published, you can continue to the next chapter.
2. has been published, do the following:

• Change the quarter (or year)
  • See how to change a quarter or a year

• Update cumulative figures

Hiding and unhiding rows

You can open and close different parts of workbook by clicking + and - signs on the left side and on the upside in the I-divQ sheet. You can also press 1 or 2 in the left up corner. 1 will close all sections and 2 will open all of them. It is handy to keep all the other information out of sight that you are not processing; thus, it helps you a lot if you start to use the Excel-file with these +/- signs.

Important rules

You are allowed to Enter and change values in the (input) cells that are with blue font color.

You are NOT allowed to

• change any formulas in the output cells that are in black font
• remove or add any rows or columns (you can however hide them)

If you need to do own calculations that need space, then you can also add own sheets and make links from them to the input cells. But never add rows to current sheets of Valuatum Excel model like I-main and I-divQ.

So the key rule is that change only blue input cells, not black output cells.

Enter all absolute numbers in millions (of euro for example).

More information about Valuatum Excel model can be found from Excel manual.

What figures to estimate

The most important figures to estimate are

• EBIT (operating profit)
• Net sales

Where to input the estimates

The near-future estimates are done in the I-divQ sheet. There you will find the divisional information by quarters.

Input estimates in the white cells with blue font.

Making changes to the model

The future estimates can be done with absolute or relative numbers. You can put absolute figure of net sales to ESTIMATES Net sales ABS and relative net sales growth %. Let's say, you believe that your company's one division will have a rise of 15 % in net sales in Q4 of the current year (see picture 6.2). Just put 15 % to Q4 of that division. You can also input your estimates as absolute figures. Thus, if you believe that net sales will be 150 million euros in Q4 of the current year, simple put the number 150 to Q4 sector of this division. However, you need to remember one thing:

Absolute figures dominate the relative ones. This means that if you, or someone else, has filled in both an absolute figure (150 millions in this example) and a percentage (15%), then the percentage becomes unrelevant, and it no longer matters what in the growth % (15 % in this example) is as the absolute figure (150 mEUR) dominates.

Remember: all changes must be done with figures in blue font. Do not change, e.g., the info fields in black font.

INFO fields

You will also find INFO fields on i-DivQ -sheet. They are only informative as they gather different estimate paths together: you can change an estimate either in absolute terms or with percentages and the quarter in question might already be in the past and then the real historical values are inputted in the cumulative section. Therefore it is practical that we have info fields where the real and uninterrupted series of both past figures and estimates is shown. And that is why we have INFO fields. You must not input anything to INFO-fields (as you see they are in black font) so if you would like to change estimates, you use periodic estimate fields (above the info fields) and if you have to change historical figures, then change the cumulative figures on the bottom of the sheet.

Make other estimates

In the similar way you can make your own estimates about EBIT of the company. There is also a possibilty to use absolute figures or relative ones (EBIT%). After EBIT move along to the income statement (see picture 6.3). When you have done all future estimates (in I-divQ sheet you should make them current year+three years ahead) for these three (net sales, EBITs and income statement), you are ready to move along to the I-main page.

Inputting history figures and changing quarter

As you probably have current prefilled Excel model, you do not have to update the model by inputting e.g. quarter figures in past quarters (you only have to check that they have been inputted correctly by the analyst whose model you use). However, sooner or later, as time passes, you have to input also past quarter-figures. They are inputted in cumulative section and not in periodic section as estimates. More info about changing the year can be found behind this link.

Updating previous quarter

It is possible that you have received such a prefilled excel-model where not all historic quarters are updated. In that case you have to input the old historical figures. A tutorial for it will be published later on here. In case you need the instructions now, please This email address is being protected from spambots. You need JavaScript enabled to view it. .

Income statement parameters

Right in the beginning of the main sheet you will find the income statement parameters. You have filled some of them (net sales and EBIT %) already in I-divQ sheet until 2009, but other estimates should be done here: as you see from the font colours, they must not be changed here (otherwise the links would be destroyed).

Balance sheet parameters

Most of the secondary estimate parameters are connected to the balance sheet. Again it is natural to keep things in a certain level.

Weighted Average Cost of Capital (WACC)

WACC also is an important factor in the estimates especially when calculating DCF / EVA fair value. More information at: WACC - Parameter guidance

When to update?

There is no limit how often to update a model to the database. You can do it whenever you have changed estimates or any other figures in the model. Of course models should be updated after interim and fiscal year reports.

Preparations for your PC

If you have empty model -version 445 or later, you don't need to do any preparations and you can proceed straight to the next section.

If you have version previous to 445, you have to do some preparations before you can update your analysis to the database. More information: Prepare your personal computer for inserting model

Prepare company in the database

Before you can update figures to database using the Excel model, you need to Prepare company in the database.

Possible problems:

Update analysis to database

After you have filled the Excel model with your estimates, you can put it to the database over the internet with only one click. "Update to the database" button is located in the main page.

You will receive an email

In this email you will find a link. Use this link to open your analysis from the database. Note that your analysis is not yet shown anywhere in the freelance analysis pages - You cannot get there in any other way than using this link. Use it to open your analysis.

Open your analysis with the link

Now your analysis is in your screen as it would be shown to a customer. You should check your figures and estimates once more, because now they are shown in more graphical and illustrative way. You might also want to think about the valuation of your share again. When everything is good, move on to next phases.

Check historical information

Check the historical data. You have probably made your analysis based on data that other people have gathered and prepared. Nevertheless, you are responsible for all the figures in your analysis. This means you have to check the historical data, especially, if the old analyst of the company in question (whose figures you use) is not among the best analysts according to the admin points. The following figures are the most important ones and should be checked by everyone at least for last few years. They can be found at either Background, Overview, or Quarters pages in Company views pages in the system.

• Number of shares (Background)
• Net sales (Overview & Quarters)
• EBIT (Overview & Quarters)
• EPS (Overview & Quarters)
• Balance sheet total (Overview)

If figures are not correct, see Excel manual.

Att: you can ask us to do first database update if you encounter any problems

About 5-10% of our analyst encounter some problems when they try to put their first analysis into the database. So far all of these problems have been solved, but in some cases it takes some time to solve the problems (by us at Valuatum). Thus there should be some quick way for the analyst to pass these problems and go on with the analysis.

The solution for this is: If you encounter any problems then you can always send the excel-file to us by e-mail and we put it into the database. It requires only one press of a button at our side and thus takes about 5 seconds by us and thus it is no problem if we have to do this couple of time on behalf of you.

Now that you are sure about your estimates and the reasons behind them, it is time to explain them to the others. This is extremely important. At this point it should be clear to you why your estimates are as they are. Hopefully you followed the instuctions and took notes already when doing the estimates. Remember that others cannot read your mind - If you haven't explained it in the forum, there is no way people could guess that you have thought about it when preparing your estimates. And use graphs along with your comments as instructed below.

How to write forum comments?

Technically writing messages is very simple. You can find forum messages below each analysis page. Just press Write a new message and then the message page on the right will open up.

What kind of message should I write?

Forum messages should explain and justify your estimates. To do this you should be able to tell all the relevant things you have thought about while doing estimates. You should also tell how your estimate are relative to management guidance and to consensus estimates (if available).

Use graphs

It is recommended to use also graphs with your forum comments. They make your text much easier to read and with them it is much easier to make grounds for your estimates. As you e.g. describe how the past financial performance has been and what you have estimated for the future quarters and years, it is very recommended to use graphs between your text. It is very easy to insert graphs from your company views -pages. And it is also not too difficult to insert images from your own.

Guide for using graphs and images in forum comments

Look at examples from current top analysts

To get a better picture about forum messages, you can easily find good examples of them. You can go Analyst rankings page and see what the top analysts have done. Press "View"-link to look at the ones with best admin points and you should have a good idea what the good messages could include and look like. Analyst rankings page can be found behind a link in customer main page. In upright corner there is a link "All Companies". Put mouse over it, and new selections will open up. Choose the last one, Analyst rankings.

An example of initial forum message: see the demo analysis.

Where should I fill in the background info?

When you see your analysis in the screen, in the upright corner you see link "analyst". Choose that and the analyst page will open in front of you.

Now you can see link called "Edit company background info" below chapter 5. Choose that and you will come to the page where you should see your company. There is also selection between Main information and Financial bulletin. You have to fill them both.

Financial bulletin is very important for automatic analysis update watcher: if you have not filled in the financial bulletin dates (or if your analysis is unupdated for over one week after some quarter result) then automatic processes are going to rank your analysis as "non-current".

Using prefilled background info

You can use already made prefilled background info that other analysts have filled before you (if there has been analyst before you).

You can "auto-fill" this information pressing "Use prefilled values", selecting the analyst whose information you want to use and pressing "Prefill fields". All the prefilled information will now appear to the fields. Remember to check information. It is likely that some information needs updating.

When the Main information is done, save it by clicking "Update information" in the end of the page. By doing so, you will arrive to a page seen in picture 10.3. You can click Update Company Views for this company and information will come to your analysis. You can see the information clicking Background in the next page.

After this, fill in the Financial bulletin in a similar way.

A rare situation, when the company hasn't announced the dates the financial information will be released, may occure. Then you have to approximate the releasing date, and make a clear comment in to the backround page and to the forum that these dates are not announced by company, but they are approximated by you according to the information you have. After the company announces the date, you can update the dates and delete the comments.

Where should I ask for feedback?

You should ask for feedback when your analysis is ready to be rated. Asking for feedback happens through Analyst pages. There you will find a link called "Ask for feedback from administrator".

Asking for feedback

You have now the page on the left in front of you. First select the company your want to be graded from the list. Then choose a "comparison analysis": Analysis you think is about the same quality as your analysis. If you think selecting one is difficult, just choose one with points you think you at least deserve. Write some comments explaining why your analysis is at least as good as the comparison analysis. In the case of re-rate you should also write what improvements you have made (based on the last feedback comments). Do not ask feedback via email, because it causes difficulties in the system.

Finally you will receive an email

When your analysis has been rated, you will receive an email. In this email you will find points you received, comments about your analysis and improvement suggestions. There will also be a link, which will lead you to points page. There you can compare your points with others.