Simple Simulations for Your Valuation Using Excel

Business Valuation Update
Business Valuation Australia
April 15, 2016
Liam Bastick
Tim Heng

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.