The foreign exchange (FX) market is an important chapter in international finance. Understanding the market microstructure is critical for learning the FX market. To assist students better understand the FX market microstructure, an instructor can use an event study with minute-by-minute quote data provided in the Excel assignment, asking students…

The Monte Carlo method and related multiple imputation methods are traditionally used in math, physics and science to estimate and analyze data and are now becoming standard tools in analyzing business and financial problems. However, few sources explain the application of the Monte Carlo method for individuals and business professionals who are…

With the growth in distance education offerings, instructors who now teach quantitative material via the web have been faced with many challenges. Foremost has been the need to develop appropriate methods for teaching such material to students who are not physically in the classroom. Methodologies that have traditionally been taught in a highly…

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…

The reciprocal method of service department cost allocation requires linear equations to be solved simultaneously. These computations are often so complex as to cause the abandonment of the reciprocal method in favor of the less sophisticated and theoretically incorrect direct or step-down methods. This article illustrates how Excel's Solver…

A key issue in exponential smoothing is the choice of the values of the smoothing constants used. One approach that is becoming increasingly popular in introductory management science and operations management textbooks is the use of Solver, an Excel-based non-linear optimizer, to identify values of the smoothing constants that minimize a measure…

This paper describes a unique integrative business case appropriate for use in a managerial accounting course or other business courses related to economics or marketing. The case describes a scenario in which a managerial accountant is assisting in business decisions relating to factors influencing the profitability of a small manufacturing…

The "Monty Hall" problem or "Three Door" problem--where a person chooses one of three doors in hope of winning a valuable prize but is subsequently offered the choice of changing his or her selection--is a well known and often discussed probability problem. In this paper, the structure, history, and ultimate solution of the…

Seasoned educators use an assortment of student-centered methods and tools to enhance their student's learning environment. In respects to methodologies used in accounting, educators have utilized and created new forms of problem-based learning exercises, including case studies, simulations, and other projects, to help students become more active…

The reciprocal method of service department cost allocation requires linear equations to be solved simultaneously. These computations are often so complex as to cause the abandonment of the reciprocal method in favor of the less sophisticated direct or step-down methods. Here is a short example demonstrating how Excel's sometimes unknown matrix…

Students regularly are asked to solve Single Factor Analysis of Variance problems given only the sample summary statistics (number of observations per category, category means, and corresponding category standard deviations). Most undergraduate students today use Excel for data analysis of this type. However, Excel, like all other statistical…

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…

Just as good grammar, punctuation, style, and content organization are important to well-written documents, basic fundamentals of spreadsheet design are essential to clear communication. In fact, the very principles of good writing should be integrated into spreadsheet workpaper design and organization. The unique contributions of this paper are…

Researchers are often distressed to discover that the data they wanted to use in their landmark study is not configured in a way that is usable by a Statistical Analysis Software Package (SASP). For example, the data needed may come from two or more sources and it may not be clear to the researcher how to get them combined into one analyzable…

The rapidly changing environment in international business provides an excellent opportunity for instructors to design timely, adaptable, experiential learning, and open-ended cases. This paper presents and discusses how to prepare and use two such cases in the areas of bank accounting and international accounting. The cases can be offered and…