Analyze the Annual Report

There are two methods of analyzing the Annual Report — using a computerized form, or a manual form. Each is described below.  This tool now works with newer Mac operating systems.

The Annual Report Analysis form has been updated to version 9.51NOTE, PLEASE READ:  If using an Excel version older than 2019, upon entering a new ticker symbol, it will take 5 or more minutes for the update to take place.  From then on, updates will take about 15 seconds.  Why, because Microsoft is restricting the use of older versions of Excel.  To eliminate this problem you must upgrade to Office 2019 or Office 365.  I found an upgrade to Office 2019 at a reasonable cost (not a subscription) at Oscar Myke is a link to the website.

You will need extreme patience for the first company analyzed.  After 5-6 minutes you’re good to go.

Annual Report Analysis form works on a PC as well as newer Mac operating system.  See NOTE above.
Click here if using Excel 2007 or later

Handout for IEC presentation 2021.

Manual Data entry form version 2.7.2 (Will work with older versions of Excel but requires data entered manually) On this form you’ll find a link to Yahoo data, which is the method I recommend when filling in the data manually. Use this version if you are using an older Mac.

NOTE: The Student & Teacher version of MS Office, which includes Excel is available at a reasonable cost at and other stores. I recommend that version, which will allow all the features of these spreadsheets to operate using the automatic fill of data features..

These forms are primarily for use in analyzing manufacturing and retail companies. A form for analyzing the Banking Industry is available. Click here to download and read a discussion of that form.