Journal of Real Options and Strategy
Online ISSN : 1884-1635
Print ISSN : 1881-5774
ISSN-L : 1881-5774
Practice
A Design and Empirical Test of a Decision Support System with Dynamic and Interactive Representation of Financial Models
Yasutomi Kitahara
Author information
JOURNAL FREE ACCESS

2010 Volume 3 Issue 2 Pages 159-183

Details
Abstract
Decision making in business planning is an essential managerial activity to invest corporate resources. Spreadsheet software like Excel is commonly utilized in financial planning in business decision. The dynamic re-calculation function of spreadsheet makes users to perform so called "What-If analysis", that is to change decisional and/or environmental values and to observe objective values like NPV with a financial model described on a spreadsheet. The "VI(Visual Interactive)-What-If" contrived by the researcher is an extended feature to Excel to change cell values by moving a mouse on slide bars instead of using a keyboard. The dynamic and continuous data change shows the financial model as "animation". The VI-What-If is expected to make users to handle financial models not only efficiently but also effectively because of its cognitive effect. This study is to research how the function affects quality of decisions in business planning by conducting user experiment. It was found that VI-What-If function affects users to recognize more risk and reduce overconfidence.
Content from these authors
© 2010 The Japan Association of Real Options and Strategy
Previous article Next article
feedback
Top