SURVEY OF THE TOP 40 TEXTBOOKS - Spreadsheet Modeling vs. Spreadsheet Templates
Spreadsheet Modeling is defined as teaching students how to build financial models in a spreadsheet (such as Excel). It is an active learning approach. By contrast, Spreadsheet Templates are defined as providing already-built spreadsheets to students. It is a passive learning approach. This survey examines the extent to which these two approaches are either built-in or available independently for the top 40 investments and corporate finance textbooks.
Overall Results of the Survey:
·
Spreadsheet modeling is either be built-in or available
independently for 29 of the top 40 textbooks.
·
These textbooks represent more than 90%
of the market share of investments and corporate textbooks.
·
This is an increase from 0 out of 40
textbooks with spreadsheet modeling in Fall 1998. Specifically,
·
14 textbooks have available a $15* supplement (a
Spreadsheet Modeling book / CD).
·
12 textbooks bundle a $5* supplement (a Spreadsheet Modeling
book / CD).
·
4 textbooks integrate spreadsheet modeling boxes into the primary
textbook and have available a $15*
supplement (a Spreadsheet Modeling book / CD).
·
By contrast, Spreadsheet Templates are bundled with 21
of the top 40 textbooks.
* = Wholesale price
| Investments at the Graduate Level | |||||
| # | Authors (Edition) | Spreadsheet Modeling? | Spreadsheet Templates? | Title | Publisher |
| 1 | Bodie, Kane, and Marcus (Fourth) | $15 Supplement = Book / CD** | Yes | Investments | Irwin / McGraw-Hill |
| 2 | Francis and Ibbotson (First) | $5 Supplement = Book / CD** | No | Investments | Prentice Hall |
| 3 | Haugen (Fifth) | $5 Supplement = Book / CD** | No | Modern Investment Theory | Prentice Hall |
| 4 | Radcliffe (Fifth) | No | No | Investment: Concepts, Analysis, Strategy | Addison Wesley Longman |
| 5 | Reilly and Brown (Sixth) | $15 Supplement = Book / CD** | No | Investment Analysis and Portfolio Management | Harcourt |
| 6 | Sharpe, Alexander, and Bailey (Sixth) | $5 Supplement = Book / CD** | No | Investments | Prentice Hall |
| ** In the notation of the primary textbook | |||||
| Investments at the Undergraduate Level | |||||
| # | Authors (Edition) | Spreadsheet Modeling? | Spreadsheet Templates? | Title | Publisher |
| 7 | Alexander-Sharpe-Bailey (Third) | $5 Supplement = Book / CD** | No | Fundamentals of Investments | Prentice Hall |
| 8 | Bodie, Kane, and Marcus (Fourth) | Boxes and Problems in the Primary Textbook & $15 Supplement = Book / CD** | Yes | Essentials of Investments | Irwin / McGraw-Hill |
| 9 | Corrado and Jordan (First) | $15 Supplement = Book / CD** | No | Fundamentals of Investments: Valuation and Management | Irwin / McGraw-Hill |
| 10 | Gitman / Jochnk (Seventh) | No | No | Fundamentals of Investments | Addison Wesley Longman |
| 11 | Hearth and Zaima (Second) | No | No | Contemporary Investments | Harcourt |
| 12 | Hirt and Block (Sixth) | No | No | Fundamentals of Investment Management | Irwin / McGraw-Hill |
| 13 | Jones (Seventh) | $15 Supplement = Book / CD** | No | Investments: Analysis and Management | Wiley |
| 14 | Mayo (Sixth) | No | Yes | Investments: An Introduction | Harcourt |
| 15 | Reilly / Norton | $15 Supplement = Book / CD** | Yes | Investments | Harcourt |
| ** In the notation of the primary textbook | |||||
| Corporate Finance at the Graduate Level | |||||
| # | Authors (Edition) | Spreadsheet Modeling? | Spreadsheet Templates? | Title | Publisher |
| 16 | Brealey / Myers (Sixth) | $15 Supplement = Book / CD** | Yes | Principles of Corporate Finance With Student CD-ROM | Irwin / McGraw-Hill |
| 17 | Brigham, Gapenski, and Daves (Sixth) | $15 Supplement = Book / CD** | No | Intermediate Financial Management | Harcourt |
| 18 | Brigham, Gapenski, and Ehrhardt (Ninth) | $15 Supplement = Book / CD** | Yes | Financial Management Theory and Practice | Harcourt |
| 19 | Emery (First) | $15 Supplement = Book / CD** | No | Corporate Finance: Principles and Practice | Addison Wesley Longman |
| 20 | Emery and Finnerty (First) | $5 Supplement = Book / CD** | No | Corporate Financial Management | Prentice Hall |
| 21 | Grinblatt / Titman | $15 Supplement = Book / CD** | No | Financial Markets and Corporate Strategy | Irwin / McGraw-Hill |
| 22 | Ross, Westerfield, Jaffe (Third) | $15 Supplement = Book / CD** | Yes | Corporate Finance | Irwin / McGraw-Hill |
| 23 | Scott, Martin, Petty, Scott, and Keown (Eighth) | $5 Supplement = Book / CD** | No | Financial Management | Prentice Hall |
| 24 | Shapiro and Balbirer (First) | $5 Supplement = Book / CD** | Yes | Modern Corporate Finance: A Multi-Disciplinary Approach To Value Creation | Prentice Hall |
| 25 | Van Horne | $5 Supplement = Book / CD** | No | Financial Management and Policy | Prentice Hall |
| ** In the notation of the primary textbook | |||||
| Corporate Finance at the Undergraduate Level | |||||
| # | Authors (Edition) | Spreadsheet Modeling? | Spreadsheet Templates? | Title | Publisher |
| 26 | Beasley and Brigham (Twelfth) | No | Yes | Essentials of Managerial Finance | Harcourt |
| 27 | Brealey, Myers, and Marcus (Third) | Boxes in Primary Textbook & $15 Supplement = Book / CD** | Yes | Fundamentals of Corporate Finance | Irwin / McGraw-Hill |
| 28 | Brigham / Houston Fund. (Eighth) | $15 Supplement = Book / CD** | Yes | Fundamentals of Financial Management | Harcourt |
| 29 | Brigham / Houston Concise (Second) | $15 Supplement = Book / CD** | No | Fundamentals of Financial Management, Concise Edition | Harcourt |
| 30 | Emery, Finnerty, and Stowe (First) | $5 Supplement = Book / CD** | Yes | Principles of Financial Management | Prentice Hall |
| 31 | Gitman (Ninth) | No | Yes | Principles of Managerial Finance | Addison Wesley Longman |
| 32 | Gitman (Second) | No | Yes | Principles of Managerial Finance, Brief | Addison Wesley Longman |
| 33 | Gitman (Fourth) | No | No | Foundation of Managerial Finance | Addison Wesley Longman |
| 34 | Keon, Martin, Petty, Scott (Third) | $5 Supplement = Book / CD** | Yes | Foundations of Finance: The Logic and Practice of Financial Management | Prentice Hall |
| 35 | Ross, Westerfield, Jordan Fund (Fifth) | Boxes in Primary Textbook & $15 Supplement = Book / CD** | Yes | Fundamentals of Corporate Finance With Self-Study Software | Irwin / McGraw-Hill |
| 36 | Ross, Westerfield, Jordan Ess. (Third) | Boxes in Primary Textbook & $15 Supplement = Book / CD** | Yes | Essentials of Corporate Finance | Irwin / McGraw-Hill |
| 37 | Van Horne and Wachowicz (Eleventh) | $5 Supplement = Book / CD** | Yes | Fundamentals of Financial Management | Prentice Hall |
| ** In the notation of the primary textbook | |||||
| General Principles | |||||
| # | Authors (Edition) | Spreadsheet Modeling? | Spreadsheet Templates? | Title | Publisher |
| 38 | Besley and Brigham (Sixth) | No | Yes | Principles of Finance | Harcourt |
| 39 | Bodie and Merton (First) | Spreadsheet Modeling Exercises Bundled on CD | Yes | Finance | Prentice Hall |
| 40 | Gitman and Madura (First) | No | Yes | Introduction to Finance | Addison Wesley Longman |