 |
 |
 |
 |
 |
 |
 |
|
|
|
|
|
|
|
|
|
This page contains links to the files that are included with the book. I have sorted the files so that they are listed in chapter order.
FAME 4 Errata Sheet - This Word document contains a list of known errors in the book. Fortunately, none of them are serious. If you find any that are not listed here, please let me know.
FameFncs.xla (FameFncs.xlam for Excel 2007)- This is the set of macros that came with your book. Download this file to your hard drive and save it somewhere that you can find it. Now, open Excel and go to Tools --> Add-ins, click the Browse button, and then nagivate to the directory where you saved the file. Click on the file and then the OK button, and it will now open automatically every time you start Excel. Documentation for these functions can be found here.
Chapter 2 Problem 3.xls - This is the file that is required to do problem 3 in chapter 2. This is the data for Boovin's Baked Goods.
P&G.xls - This is the file that contains the data for Procter & Gamble. You will need this data for problem 1 in chapter 5.
Chapter 5 Problem 3.xls - This is the file that is required to do problem 3 in chapter 5. This is the returns data for the S&P and GE.
ExcelSim 2007 (Excel 2003 and earlier version) - This is the Excel add-in program I've written to perform Monte Carlo simulation. Download this file and then open it in Excel 97-2003 or Excel 2007 (use the proper version) to be able to run a simulation. You may also need the documentation file and the examples file. Note that you will need the Adobe Acrobat Reader to read the documentation. A truly excellent introduction to modeling uncertainty with Monte Carlo methods is available from PriceWaterhouseCoopers is available here in PDF format. That same document provides an excellent discussion of many probability distributions and when they should be used. A good list of available articles from a wide variety of fields is available from Decisioneering, Inc (makers of the Crystal Ball Excel add-in) here.
Create a Step-Function Chart - This Flash video shows how to use Excel to create a step-function chart. In this example, I use the Federal Funds target rates for the data, but the concept is the same for any other data set. The key is that you need to have two Y values for each X value at a point where there is a change in the data.
Using Controls to Change Chart Data - This Flash video demonstrates how you can use Excel's built-in controls (e.g., a drop-down list) to change the data in a chart. This is a very useful technique for given presentations and also for business information dashboards.