« Back to the Investor Classroom

Using a Simple Worksheet to Analyze a Stock

Step 1: How Do I Determine What a Stock is Worth?

Using A Simple Worksheet To Analyze A Stock Splash image

The task of selecting stocks can be made easier by organizing the decision process to ensure that salient data and information is evaluated in some logical sequence that allows an investor to make a reasonable decision.

Classroom Steps

The ultimate goal is to determine, through a range of values, what you think the stock is really worth.

The Valuation Worksheet provides an easy-to-follow systematic format that allows you to walk through the complete process of placing a value on a stock without getting bogged down in complicated financial analysis. However, any final real-world decision would include the further evaluation of other fundamental aspects of the company.

At the bottom of the worksheet, two valuation models are presented, one based on a firm's earnings and the other on its dividends.

To read more, please become an AAII member or CLICK HERE.

This article is reserved for the paid membership of AAII.

To gain complete access to this article and all of the member benefits and investment education AAII offers, please take a moment to join AAII today.

As a member of our nonprofit investor association, you'll benefit from our monthly magazine, website, model portfolios, investor classrooms, local chapter network and our unconditional money back guarantee.

Invest the AAII Way

We've been helping investors for over 30 years. Our unique educational directive coupled with winning model portfolios are what every "do it yourself" investor needs to successfully grow and manage investment wealth.

Read this entire article instantly when you sign up »

Join AAII Today!

Join AAII
to read more »

just $29
40% off our regular rate

10,000+
investment guides, classrooms, and articles — free at AAII.com

meet 150,000 members
all learning to invest

dozens
of Stock Screens and Model Portfolios, all with proven returns