Welcome to Bobsite

.....a personal e-site

What's this site about?
Recommended Reading
Analyze Ann Rpt. --Mfg
Analyze Ann. Rpt.--Banks
Quick Analysis form
Annualize Your Portfolio
Follow Your Stocks form
Help for Club Officers
Class Handouts & Info
Misc. URLs for the SSG
Mutual Fund Analysis
When to Sell
Helpful Websites
Home
Email Bob
Quick Analysis form -- designed by Dr. Kaush Meisheri 
 
The QUICK ANALYSIS form, a great tool--designed by Kaush Meisheri, has been enhanced and is available for downloading. There are two files available--one automatic data fill and calculation, and one manual data fill. 
 NOTE:  Select the form that matches the version of Excel on your computer and "Save" not "Open" when downloading the file. 
 
SAVE the file to your computer
The Automatic form version 1.37 (6-12-10) requires only typing in a ticker symbol for the required data on the form to be automaticaly filled in, totals determined and the mathematical analysis completed for you. (Requires Excel 2000 or newer)  This form takes the "work" out of the analysis.  The company description is also automatically inserted into the form, and the PEG ratio has been added.  The form provides a great starting point for your analysis.  Also know the company, its products, and how it compares to peer companies.  Competitor companies are listed on the form.

    The Manual form version 3.0 can be printed and filled in manually or filled in via your computer--typing data in the appropriate cells. (Click on an area where data is to be entered and type the information.) The manual form is designed to use Value Line data.  Mac users should use this manual entry form--unless you're running Windows and MS Excel.  Or, go to the library. 
MORE INFORMATION:
An additional line has been added to both forms which uses the PEG ratio as a means to determine if the current price is reasonable.  The PEG is an important tool to help determine that important factor.  Don't pay too much for a stock--a very common mistake.