6Co Analysis

6 Company Analysis is a spreadsheet workbook package using Microsoft Excel for Windows. The spreadsheet is designed to permit entry of financial statement data for six companies. The spreadsheet calculates key ratios for the companies and provides a group average (mean) for the six firms. With the output provided, comparisons across the six companies can be made. In addition, the six-firm average provides a meaningful set of industry statistics. Financial statement data and data from the Value Line Investment Survey for each company is entered into the spreadsheet for each company. Spaces are clearly labeled as to year, company, and data item. The spreadsheet then automatically calculates key ratios for each company and reports them on the industry statistics spreadsheet of the workbook.

6Co Analysis Spreadsheet

Return to main page

If you need to contact me, or have corrections for the spreadsheets, use my Georgia Tech EMail address: charles.mulford@mgt.gatech.edu