This video is an example of how Microsoft Excel can be used to perform sensitivity analysis on spreadsheets with the What if / Data Table functionality. To watch the video in Full Screen, select the Full Screen option in the bottom right hand side of the video screen once video clip is playing.
Please sit back and see how easily a simple Profit and Loss spreadsheet can be analysed to understand how sensitive the Net Profit figure, for example, is to changing certain input variables.
We hope that you find this small example useful for your business, however if you are in a position where you need additional business support then do not hesitate to contact us at Wellmeadow.
Wellmeadow Limited is a management consultancy firm in Shrewsbury, providing business support and advice to firms across Shropshire and the West Midlands. We provide a mix of non executive director support, interim management on a part time basis for a variety of organisations, but mainly privately owner-managed firms (especially family firms). If you would like to chat over a business challenge you are facing, then we would be happy to speak to you on a no obligation basis. We understand that a decision to work with a firm like us may not be taken lightly, and may seem quite daunting. However, have a look at the about us page for some more information about who we are, how we work and some of the great benefits that many of our customers have experienced. Feel free tocontact us anytime 01743 234031.