Microsoft Excel - From Beginner to Expert in 6 Hours

Analysis Tool That Performs Fundamental Analysis Of the Market

Share-pricer is an easy-to-use, but flexible stock analysis tool. It performs fundamental analysis, not technical analysis of market movements. From the current and future state of the company, Share-pricer calculates fair value for the company share. It is also possible to compare what kind of expectations are present in the market prices of different companies

Share-pricer main features

• easy comparison of companies
• automatic calculation of required growth
• uses essential fundamentals
• based on sound mathematical theory of Economic Profit
• handles the passing of time better than any Excel sheet you can make
• easy installer and uninstaller
• two language options: English and Finnish

To be able to correctly calculate the shareholders' equity in the future, we also need to know the dividend ratio (payout ratio) of the company. Also, for our purposes, the initial amount of equity is not needed, because it does not affect the share value. If company has high amount of equity, it's future earnings are valued exactly that much lower, and vice versa. This effect enables us to eliminate shareholders' equity from the inputs.

This leaves us with the following inputs:

• cost of equity
• dividend ratio
• future earnings estimates

Below is a picture of an analysis of a high tech company called "Company A".

So the result was that share value is 24.67 (dollars, assuming that the earnings were given in dollars). Now we can input the current market price of the share. Based on that the program automatically calculates the P/E ratio, and the amount of long term growth that is required from the company for it to be worth the market price (Required growth).

Pressing OK brings us back to the main window. There we can easily compare the companies. By clicking the table headers, the companies can be sorted based on the following criteria:

• A user defined order that can be used, for example, to enter the latest market prices
• Alphabetically by name
• Discount (how much cheaper is the market price than the estimated value)
• P/E ratio
• Required growth, a very powerful figure that takes into account all the most important fundamentals of the company
• Modification dates of analysis or market price

Here is an example of how to quickly find buying opportunities even if you have not updated your data for a while:

1. Update market prices: Sort the table by the market price update timestamp to find market prices that are badly out-of-date.
2. Update analysis: Sort the table by the analysis update timestamp. Often a more effective way is to sort the table by the Discount column. Large positive or negative values of Discount may be good indicators of companies that have out-of-date analysis. This method requires that market prices are updated first and that you always match the value estimate to the market price when doing an analysis. (There are also other ways to make an analysis.)
3. Sort by Required growth. The value stocks should have a small required growth and the growth stocks should have a large one. Try to find either a growth stock among the value stocks or a value stock with a very small required growth.

Below is a picture of the main window:

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over \$70.00. ALL purchases totaling over \$150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.