Computerized Investing > First Quarter 2011

A Simple Valuation Spreadsheet

| | | COMMENTS (9) | A A   Reset

Many individual investors view individual stock analysis and selection as a daunting task. However, the process can be made easier by organizing the decision-making process to ensure that pertinent data and information are evaluated in a logical sequence so that the investor can arrive at a reasonable and thoughtful decision.

The ultimate goal of fundamental analysis is to determine, using a variety of variables, what you think a stock is really worth and comparing that estimated value to the stock’s current stock price. This way you can gain an insight into whether the stock is undervalued, overvalued or fairly valued.

...To continue reading this article you must be a Computerized Investing Subscriber.

Gain exclusive access to this article and all of the benefits and investment education a Computerized Investing subscription offers.

SUBSCRIBE TODAY for just $24.
Log in
Already a CI subscriber? Login to read the rest of this article.

A subscription to Computerized Investing includes a monthly email and access to the CI Website, all of which aim to benefit your investing skills with respect to computers and the Internet.



Edward from NY posted over 7 years ago:

Is there a spreadsheet that compares different companies Revenue/Employee? Net earnings/employee?

Richard from CA posted over 7 years ago:

Could we get this spreadsheet incorporated into SIPro???

Richard from CA posted over 7 years ago:

Or is the Valuations Tab serving the same function?

Carroll from CA posted over 6 years ago:

Are these evaluations essentially what is used by the various advisors, ie) Standard and Poors, etc? If so, is this exercise merely a duplication of what is already available?

E from GA posted over 6 years ago:

It would be most helpfull if you published the answers to the questions.

Joesph from PA posted over 6 years ago:

I, like others, are interested in the responses to the above questions. Where can one easily and collectively get the information to propagate/load into the spreadsheet to facilitate analysis?

Fuad Nuwaysir from FL posted over 5 years ago:

After updating Adobe Reader, I tried downloading the book “Stock Investing Strategies,” by Maria Crawford Scott and John Bajkowski.
I get the following message:
"This file is damaged and could not be repaired."
I hope you are able to repair the damaged file and post it again.
The other two books downloaded without a hitch.
F. Nuwaysir

Joe Lan from IL posted over 5 years ago:

Hi Fuad,

The file is working properly and is not damaged.


Stu from RI posted over 4 years ago:

Can you suggest a site from which you could obtain the historical data listed on this sheet. Can find lots of sites for the current info, but having a real problem finding the past 5 yrs

You need to log in as a registered AAII user before commenting.
Create an account

Log In