Can anyone help me who is fluent with financial matters?

Question

Can anyone tell me where to find the market price, book value, and other such info that pertains to a company for years past? For example, I am looking for the market price of a company's stock for 2005. The only info I find is the price for the last trading day of 2005. I need to find the average price for a whole year (1/1/05-12/31/05). Also I need the market value as compared to market price and book value. It is next to impossible to find. It is for a project in finance class, and this is not on the income statement or balance sheet.
Are there any good sites or books that have that and industry averages for certain whole years?

Answer 1

There are very few, if any sites that will provide you with average annual price. However, Yahoo finance has the information you need to calculate that price. Go to Yahoo finance and enter the symbol for the stock in question. When the data for that stock displays on the screen, on the left hand side of the page near the top you will find "historical prices". Click on that. Enter the start date and the end date i e 1/1/2005 and 12/31/2005 and press enter. That will bring up the daily stock prices for the stock in question. Next down load them to a spread sheet. At the bottom of the page you will see "Download to spreadsheet". Click on that. Once you have the prices in the spread sheet, you can calculate the average price for the year. Sum the closing prices x the volume figure for each day and put that figure in a new column. Then sum the that column down the page and sum the volumn figure down the page. Then divide the sum of price x volume by sum of volumns. That will give you the average price for the year or rather close enough. Also Yahoo finance has the has the current market value, and book value and current price. You can get the year end figures by going to the SEC filings. On the left side of the page again but further down, and when you get there displaying the 10k for the company. It will have the book value. Divide the tangible assets by the number of shares outstanding. The market value is the price of the stock x the number of shares outstanding.

Answer 2

Muncie's got it. Others have good sources for data too.

1) Download the data

2) Take an average

3) Then multiply that by the shares outstanding at the end of 2005 to give you an approximate average market value for the firm at the end of 2005.

Book value will be on the financial statements, but since you're in a Finance class, you probably knew that.

Good luck!

Answer 3

Find the company's SEC Form 10K. (SEC website has EDGAR filings. That's the electronic verision of the 10K, 10 Q, etc.)

Most companies report their historic stock market prices in High and Low range each quarter. I don't know if that is good enough to calculate your "average".

Book value is the Net Equity of the Company divided by the issued and outstanding shares of the company. That information is on their published Balance Sheet.

Answer 4

You can get stock prices from Yahoo! Finance or from the CRSP database.

The book information is on the company's balance sheet. You can get that information from the Compustat database.

CRSP and Compustat are both available through WRDS (Wharton Research Data Service) which is an expensive service. However, since you are a student, your school probably has a subscription. You can talk to the people in your B-School library or your professor.

Balance Sheet information is also available to the public through the SEC's EDGAR database -- which you can get at on line from the Yahoo! Finance site. Most companies also have their financial statements on line on the company web sites -- usually in the Investors or About Us section.

Answer 5

Download this free financial software

http://www.lsefinance.blogspot.com