The Sweet Sixteen Ratio Analyzer tool is available in
both an Excel and Flash file format. You can open the interactive Flash file
on the web by clicking the 'Start Tool' link at the bottom middle. This tool
will open in your browser window and allow you to interact with the EWS
Farms case farm data. Depending upon your security settings, you may have to
allow blocked content to properly run the file. To download the latest
version of Flash Player, you may
click here.
The Sweet Sixteen Ratio Analyzer tool also contains a downloadable MS
Excel file. Clicking the 'Download' link at the bottom left will allow
you to open this file in your browser window or download and save it onto
your computer. It comes with sample data from the EWS Farms case farm already
entered. This will provide a direct reference to materials in the textbook as
well as provide an example for how to enter your own data. If you choose to
enter in your own financial data, this file will calculate ratios for your
operation. If you wish to save the file with new data, we recommend you use
the 'Save As' option under the File menu in Excel to save it with using a
different file name thus preserving the original file and the sample data.
This tool does require macros to be enabled in order use all of its features.