 |
|
|
|
 |
Krypton
83.798 g/6.022x10^23

Registered: Nov 2003
Location: Texas
|
|
|
Here are some simple valuation formulas that I use on a daily basis. I developed all of them independently in the development of my model over a period of 2 years. I won't be listing all of them but just the simplest ones. I am still writing a thesis on my model, and have been for almost a year now. Unfortunately, I'm am changing it so often, whatever I write quickly becomes outdated. So, when I find the time to stop improving it, I'll get that thesis done, and perhaps you guys can read it. These formulas can very easily be transferred into an excel spreadsheet so you can use them for practical purposes of estimating a stock's true value BEFORE you buy it. The higher the "margin of safety", the better. You want the estimate to be as high as possible above the current market price, because that would indicate an undervaluation.
How I get my intrinsic value is by averaging all my stock price estimates. You can do the same thing with these formulas. Instead of relying on just one, you can average the results of all of them, and get an average valuation.
NOTE: Sub-numbers indicate the time period. For example PE1 would mean the estimated PE for next year. A -1 would mean PE for last year.
-> Estimating metrics: A lot of these metrics must be estimated into the future for you to obtain an estimated future target price. Here is a simple way of doing it...
Problem: Estimate PE for next year.
[(PE-4 - PE-5) + (PE-3 - PE-4) + (PE-2 - PE-3) + (PE-1 - PE-2) / 4] + PE-1 = PE1
All you're doing is averaging the amount of growth from the last 5 years. Then all you do is add the average growth amount to last year's metric, which for this example is the PE. You can use this method to estimate almost anything. I only estimate one year into the future because I believe anything past 1 year is impossible to accurately gauge.
-> Stock Price Growth Valuation
[(Stock Price-4 - Stock Price-5) + (Stock Price-3 - Stock Price-4) + (Stock Price-2 - Stock Price-3) + (Stock Price-1 - Stock Price-2) / 4] + Stock Price-1 = Stock Price1
-> PE Valuation
(PE1)(EPS1) = Price1
-> PS Valuation
(PS1)(Sales per Share1) = Price1
-> PB Valuation
(PB1 x Total Equity1) / Shares Outstanding1 = Price1
-> Ratings Valuation
This valuation uses the ratings of any analyst to estimate the future stock price. Before I give the formula, you must make sure the rating itself is quantified on a 0-100 scale. For example, say you're getting your rating from stock scouter. Their ratings are given on a scale of 0-10. This mean you must convert this rating by multiplying it by 10, so that the rating fits the 0-100 scale. Maybe you're using the CAPS rating at Motley Fool. You must multiply these ratings by 20 because their scale is on a 0-5 scale. If the rating is in the form of a recommendation such as STRONG BUY, you can easily quantify this by looking to see how many ratings are possible. Say a STRONG BUY is the highest rating out of 5 ratings (strong sell, sell, hold, buy, strong buy). You would assign a 100 to that strong buy, 80 to buy, 60 to hold, 40, to sell, and 20 to strong sell.
Stock Price0 - [Stock Price0 x (Relative Strength - Stock Rating)] = Price1
The reason I assign the estimated price to the future instead of the present is because the equation assumes that market never values a stock according to its rating. Rating are usually based on good or bad things. A good rating is likely a result of a good analysis, and so the stock can be expected to rise. So this rise or decline could only be expected in the future.
-> Gamma Valuation
Before you do this valuation, you must first calculate the gamma, and this is very simple. All you do is take the stock rating (must be on a 0-100) scale, and divide it by the relative strength of the stock. So a stock rating of 80 divided by a relative strength of 40 would equal a gamma of 2.
Stock Price0 x Gamma = Price1
-> 52 Week High Valuation
Stock Rating x (52 Week High / 85) = Price1
___________________
|
|
Aug-06-2008 00:35
|
|
|
 |
 |
Capitalizt
Supreme tranceaddict
Registered: Feb 2005
Location: USA
|
|
|
Holy crap..that stuff is too complicated Krypt...You are making things too hard on yourself.
This is the only formula I use..
P/E > average annual growth rate (past 2-3 years) = overvalued
P/E < average annual growth rate = undervalued
|
|
Aug-06-2008 05:18
|
|
|
 |
All times are GMT. The time now is 10:02.
Forum Rules:
You may not post new threads
You may not post replies
You may not edit your posts
|
HTML code is ON
vB code is ON
[IMG] code is ON
|
|
|
|
|
|
Contact Us - return to tranceaddict
Powered by: Trance Music & vBulletin Forums
Copyright ©2000-2026, Jelsoft Enterprises Ltd.
Privacy Statement / DMCA
|