In this paper the authors present a unique approach to teaching introductory statistics at both the undergraduate and graduate levels. The approach uses a feature in Excel called "spinners" to dynamically adjust key variables, such as sample size, confidence levels, and probabilities, among others, to enable an expanded discussion of…

Financial analysts generally create static formulas for the computation of NPV. When they do so, however, it is not readily apparent how sensitive the value of NPV is to changes in multiple interdependent and interrelated variables. It is the aim of this paper to analyze this variability by employing a dynamic, visually graphic presentation using…

This paper discusses and illustrates the use of dynamic Excel presentations to improve learning in Financial Management courses. Through the use of such presentations, multiple and varied examples of important principles in Financial Management, which would ordinarily take an excessive amount of time to cover, can be considered within the time…

This paper extends the discussion of the critical line approach using three risky stocks as described in Haugen's Modern Investment Theory, 4th edition. A dynamic presentation of the concepts involved in finding the efficient set, using two EXCEL spreadsheets and an HP-12C hand-held calculator, is provided. This dynamic presentation will enable…