Innovative Spreadsheet-based Simulation for Modeling Uncertainty in Accounting for Contingencies

Integrating advanced analytical techniques into the accounting curriculum is essential in today’s dynamic accounting environment. In response to the Association to Advance Collegiate Schools of Business (AACSB) 2020 Business Accreditation Standards, which emphasize the importance of innovative curriculum development, this chapter presents a novel method for teaching accounting for contingencies. It introduces a spreadsheet-based Monte Carlo simulation to enhance the estimation of contingent losses, bridging the gap between US Generally Accepted Accounting Principles (US GAAP) and International Financial Reporting Standards (IFRS) approaches. By incorporating simulation, students gain practical skills in risk assessment, data analysis, and visualization, aligning with the competencies demanded by employers. Other applications of simulation are also discussed, promoting a forward-thinking approach to accounting education.