Base-case analysis, What-if analysis and Risk analysis
According to Heys (2008), ‘base-case analysis’, ‘what-if analysis’, and ‘risk analysis’ are the three main categories of spreadsheet analysis. Though each of these is used in speculating outcomes using Microsoft Office Excel on a worksheet, each of them applies a different form of parameters and procedures. This paper explores how Base-case analysis, What-if analysis, and Risk analysis are important features of the Microsoft Office Excel analysis process.
Heys, C. (2008). Getting the best out of excel: Teaching mathematics and its applications: An International Journal of the IMA, 27(1), 48-52.
Porter, J. & Stephenson, T. (2010). Creating an excel-based budget you’ll really use. Strategic Finance, 91(8), 26-33.