Creating interactive spreadsheets to provide immediate feedback

Features available with electronic spreadsheets enable accounting educators to create interactive spreadsheets that provide students with immediate feedback regarding the accuracy of their solutions. Providing immediate feedback using an answer-until-correct approach can help students acquire and retain knowledge. In this approach students open an incomplete spreadsheet and create formulas to complete the accounting problem. Correct solutions are denoted by a change in font color. Security features prevent students from locating the correct answers stored in an adjacent area. Problems illustrated in this paper relate to principles of financial accounting. However, interactive spreadsheets can also be used in other accounting courses such as managerial, cost, and intermediate accounting.     

Home mortgage analysis for cultivating crucial spreadsheet and model development skills

Accounting practitioners and academics have identified spreadsheet and model development skills as important for accounting graduates to possess. We present an adaptable mortgage analysis project that provides a practical setting in which students can develop critical spreadsheet modeling skills while demonstrating knowledge of several important principles of accounting and finance. The developed spreadsheet model is designed in a structured manner to permit changing the necessary financial terms and facilitates performing sensitivity analysis on critical variables.The analysis requires an informed decision be made between employing a fixed rate mortgage or an adjustable rate mortgage (ARM) for financing a home purchase. Important theoretical skills required to arrive at an acceptable solution include understanding of present value concepts, effective rate method of interest calculation, and amortization of principle balance. The student must also verify proficiency with the necessary theoretical and practical skills of effective spreadsheet design and model development     

Power to business professors: Automatic grading of problem-solving tasks in a spreadsheet

This paper presents an innovative approach, based on Excel files and a detailed implementation guide, that allows a professor with proficient spreadsheet skills to develop individualized problem-solving tasks for assignments and examinations that test students on cognitive thinking processes beyond memorizing and drilling. The professor accomplishes this goal by requiring the students to model a business problem-solving task in a worksheet environment. Each student’s work is marked automatically by a generic “plug and play” Visual Basic for Application (VBA) algorithm. The scores and feedback provided are tailored to each individual student and address not only the problem-solving outcome but also the problem-solving process. The learning objective discussed in this work is implemented at a Norwegian university business school.     

A spreadsheet analysis of different costing systems

This note describes a project that uses a spreadsheet to illustrate the conceptual similarities and differences between actual, normal, and standard costing systems, under both variable and absorption reporting formats. Budgeting and variance analysis are also included in the illustration. The purpose of the project is to enhance, via a comprehensive numerical example, the student's understanding of these three costing systems. A spreadsheet formulation enables the student to perform sensitivity analysis, while eliminating the need for repetitive income statement formatting and calculations.     

Comparative analysis of accounting treatments for derivatives

This paper provides educators with a classroom example or a self-study tutorial to teach Statement of Financial Accounting Standards No. 133 (FAS 133), Accounting for Derivative Instruments and Hedging Activities. The example can be used in courses such as intermediate or advanced accounting that discuss derivative instruments or investments topics or in a training program that focuses on implementing FAS 133. This teaching material can help students gain technical knowledge of FAS 133. It can also help develop critical thinking skills in analyzing the impact of an accounting standard on a firm's operation. A scenario based on a futures contract used by a natural gas company to hedge price fluctuations of its gas inventory is applied across four cases to show the impact of derivative designation on the accounting treatment and to provide a comparative analysis of the economic results from using different accounting treatments for the derivative. Case 1 and Case 2 demonstrate hedge accounting under FAS 133 by designating the derivative as a fair value hedge and a cash flow hedge, respectively. Case 3 illustrates accounting for a derivative that is not designated as a hedge. Case 4 demonstrates the impact of not entering or using a derivative to mitigate market risk. A downloadable spreadsheet on the author's website can be customized for use in the classroom.     

Applying XBRL in an Accounting Information System Design Using the REA Approach: An Instructional Case*

The Church in Somewhere (CIS) is a small community church which uses an Excel spreadsheet to keep its financial records. The church administrator is considering moving from a spreadsheet accounting system to a relational database system that can easily be expanded to include more information in the future. In this paper we examine the transforming process in this hypothetical case by following a resource‐event‐agent (REA) modeling paradigm to create a database. We then link the REA model to financial reporting using Microsoft Access. In addition, using the financial report in the database, students prepare and validate an eXtensible Business Reporting Language (XBRL) document for CIS. Instead of applying the complex U.S. Generally Accepted Accounting Principles (GAAP) Taxonomies, Release 2009 , the case uses a dedicated CIS Taxonomy to complete the mapping and tagging processes.     

Risk Management and the Cost of Capital for Operating Assets

This article attempts to clarify the effect of risk management on a company's cost of capital in the spirit of the traditional M&M/CAPM model. The traditional cost of capital model can and should be used to find the hurdle rate for a company's operating assets, since it can be applied regardless of the composition of the firm's non‐operating assets or its risk management policy. The author's main message is that if a firm manages idiosyncratic risk, the correct cost of capital for the operating investment is not the firm's enterprise WACC, but rather the required return on the assets being funded. Using the case of a company with a single line of business that is evaluating an investment opportunity, the author demonstrates how to adjust the firm's overall WACC to find the cost of capital for the operating assets to be acquired.     

Determinants of Student Attitudes toward Team Exams

Abstract

We examine how student attitudes toward their group, learning method, and perceived development of professional skills are initially shaped and subsequently evolve through multiple uses of team exams. Using a Tobit regression model to analyse a sequence of 10 team quizzes given in a graduate-level tax accounting course, we show that there is an anchoring effect, in that in later rounds satisfaction on all dimensions rests on the foundation laid in the initial round. Subsequently, however, self-perceptions and the perception of others may influence satisfaction on a particular dimension. We also find that the satisfaction with one's group tends to increase when students make more correct switches but decreases when there is greater disagreement among the group. Furthermore, satisfaction with team exams tends to lessen, and to an increasing extent over time, as the number of errors a student has committed on the most recent quiz increases.     

Book Reviews

The Who Wants To Be (WWTB) game is a computer-based game that can be used in a variety of classroom settings. WWTB requires students to sit in a “hot seat” and answer a series of questions. Assistance is provided to the students in the form of “lifelines.” The lifelines include: (1) the 50/50 lifeline where two wrong answers disappear; (2) the Ask the Audience lifeline where class members vote on a correct answer; and (3) the Ask Your Team lifeline where students can verbally interact with teammates. The WWTB game is functional on most computer systems. The manner in which the game can be played, the difficulty of the game, and the rules of the game are all easily modified at the instructor's discretion. An analysis of examination scores reveals that the game has been an effective learning tool in the auditing course in which it has been incorporated. The game program and database structure are available to educators on a complimentary basis through the author's website.     

Yield Approximations: A Historical Perspective

This paper traces the historical developments of the efforts to find simple and accurate methods of approximating an annuity's implicit yield and a bond's yield to maturity. It is shown that the little known history of yield approximations is nevertheless very rich, with contributions dating as far back as the late seventeenth century. It is also shown that the standard textbook approximation formula for the bond's yield to maturity is the least accurate of a large family of formulas, some of which were suggested as early as 1855.     

Accounting Students' IT Application Skills over a 10-year Period

This paper reports on the changing nature of a range of information technology (IT) application skills that students declare on entering an accounting degree over the period from 1996 to 2006. Accounting educators need to be aware of the IT skills students bring with them to university because of the implications this has for learning and teaching within the discipline and the importance of both general and specific IT skills within the practice and craft of accounting. Additionally, IT skills constitute a significant element within the portfolio of employability skills that are increasingly demanded by employers and emphasized within the overall Higher Education (HE) agenda. The analysis of students' reported IT application skills on entry to university, across a range of the most relevant areas of IT use in accounting, suggest that their skills have continued to improve over time. However, there are significant differential patterns of change through the years and within cohorts. The paper addresses the generalizability of these findings and discusses the implications of these factors for accounting educators, including the importance of recognising the differences that are potentially masked by the general increase in skills; the need for further research into the changing nature, and implications, of the gender gap in entrants' IT application skills; and the low levels of entrants' spreadsheet and database skills that are a cause for concern.     

The effectiveness of using spreadsheets to teach financial accounting

There have been numerous attempts to integrate micro-computers into the teaching of accounting courses in higher education. Two of the reasons that have been suggested for using computers on accounting courses are: firstly, the educational benefits and, secondly, that students will then be equipped with the computing and spreadsheet skills that they will require in the workplace. One method of using the computer is to use it as a computational tool, allowing the student to develop models from scratch. Such an approach was developed by Marriott & Simon (1990a). However, as there is little evidence regarding the educational effectiveness of using such methods, a rigourous and structured research project was conducted using first–year accounting degree students at Cardiff Business School. This article outlines the rationale for the project and analyses the results obtained. The results indicate that while spreadsheets can be successfully integrated into an accounting course, their use had no measurable impact on test performance. However, the use of computers can still be deemed to be worthwhile as the students' computer skills are enhanced and it permits further integration in other courses where educational benefits may be more readily obtained.     

Life Insurance Liabilities at Market Value: An Analysis of Insolvency Risk, Bonus Policy, and Regulatory Intervention Rules in a Barrier Option Framework

This article takes a contingent claim approach to the market valuation of equity and liabilities in life insurance companies. A model is presented that explicitly takes into account the following: (i) the holders of life insurance contracts (LICs) have the first claim on the company's assets, whereas equity holders have limited liability; (ii) interest rate guarantees are common elements of LICs; and (iii) LICs according to the so‐called contribution principle are entitled to receive a fair share of any investment surplus. Furthermore, a regulatory mechanism in the form of an intervention rule is built into the model. This mechanism is shown to significantly reduce the insolvency risk of the issued contracts, and it implies that the various claims on the company's assets become more exotic and obtain barrier option properties. Closed valuation formulas are nevertheless derived. Finally, some representative numerical examples illustrate how the model can be used to establish the set of initially fair contracts and to determine the market values of contracts after their inception.     

Introducing spreadsheets into an intermediate financial accounting course: the results of a quasi-experiment

Previous research has revealed a measurable decrease in student attitude towards the use of computers when they are integrated into teaching. This fall in attitude is thought to reflect the initial diffculties encountered when attempting to use computers and learn acounting techniques at the same time. However, it is postulated that once the students' computer ability has achieved an adequate level, then attitude will recover. This paper reports the results of a continuing investigation into the attitude of second-year undergraduate accounting students towords the use of computers in their studies. The method used was to ask students to complete a questionnaire about their attitudes and self-assessed ability and to undergo a written test of their computer/spreadsheet Knowledge. These data were merged with those from earlier testing to give a two-year data set. The results indicate that the attitude of students to using computers generally continued to fall significantly. However, their ability to use computers and spreadsheets rose. In the case of spreadsheets, this rise in ability was significant. It was found that students who took, as options, additional courses which integrated computers had more positive attiudes and achieved higher scores in the computer Knowledge test than those who did not. This implies that the initial fall in attitude experienced in previous studies was not an isolated temporary phenomenon. The imporvement in ability is observed, but this did not have the expected effect.     

Determinants of Contract Choice: The Use of Warrants to Compensate Underwriters of Seasoned Equity Issues

The issuer's decision to include warrants as compensation to underwriters is studied for a sample of 1,991 negotiated firm commitment issues of seasoned equity. Using a two-stage logit model to correct for self-selection bias, we find direct evidence that warrant compensation functions as a bond, substituting for reputational capital and enabling the underwriter to certify the issue price. To a lesser degree, the decision also is affected by regulations on underwriter compensation and on the use of underwriter warrants. Issuers' decisions are consistent with an objective of minimizing total underwriting cost, including cash compensation, warrants, and underpricing.     

Electronic spreadsheet technology in the teaching of accounting and taxation—Uses,limitations, and examples

Three advantages of using electronic spreadsheets in classroom settings are identified: 1. spreadsheets provide applied settings in which to learn their usage, 2. spreadsheets aid students in understanding complex accounting problems and 3. the power of spreadsheet templates can be demonstrated. We also identify three limitations of the classroom use of electronic spreadsheets: 1. the extra time commitment for faculty and students, 2. the inherent danger of reducing repetitive problem practice and 3. the lack of any pedagogical benefits in certain accounting contexts. These benefits and limitations are combined to form an overall pedagogical strategy. In addition, several spreadsheet templates are provided as illustrations for our arguments.     

A constraint-free approach to optimal reinsurance

Reinsurance is available for a reinsurance premium that is determined according to a convex premium principle H. The first insurer selects the reinsurance coverage that maximizes its expected utility. No conditions are imposed on the reinsurer's payment. The optimality condition involves the gradient of H. For several combinations of H and the first insurer's utility function, closed-form formulas for the optimal reinsurance are given. If H is a zero utility principle (for example, an exponential principle or an expectile principle), it is shown, by means of Borch's Theorem, that the optimal reinsurer's payment is a function of the total claim amount and that this function satisfies the so-called 1-Lipschitz condition. Frequently, authors impose these two conclusions as hypotheses at the outset.     

Summation-formulas of Lubbock's type

Abstract

If it is required to calculate a sum consisting of a great many terms, it is natural to ask oneself whether an approximation might not be obtained by adding up every mth term and multiplying the result by m. If the approximation obtained in this way is not considered sufficient, certain supplementary terms must be added to the result, and these may either be expressed as differences or as differential coefficients of the function under consideration. In the former case we have formulas of Lubbock's, in the latter of Woolhouse's type. We here confine our attention to the formulas of Lubbock's type.     

Forecasting with micros: A cautionary tale

This article draws on the author's experiences of developing a micro-based forecasting software catalogue. The criteria for the information base are considered from the general, yet practical, impact of micro-computers on industry. Specification of specialist forecasting software and forecasting routines within general statistical packages are discussed, with consideration of the scope of spreadsheet packages in this area.