Summary
Risk and uncertainty are prevalent in all business decisions we make. Many working in valuations and finance are familiar with and use various “what-if” analysis tools and techniques within their spreadsheets such as scenario and sensitivity analyses. You can go further than this though, simply with the basic Excel software. Using simulations analysis, it is possible to quantify and analyse the impact of your input. Here, we look at how to undertake simple simulations analysis using nothing more than Excel and some of its lesser-known functions and functionalities.