Sensitivity analysis using spin button in Excel

Sensitivity analysis using spin button in Excel: In our 'business model' of our toy manufacturing company we have seven parameters like 'unit sales', 'unit price', 'unit cost', 'rate of interest', 'change in cost of manufacturing', change in price' and 'sales growth'. We can vary these parameters manually to see how our profits or 'NPV' value changes but we can also use the 'spin button' control to vary the data automatically and view how the other data changes.
Let's see the spin buttons in action!

After inputting the data and performing the standard calculations of revenues, profits before tax, tax and tax after profit, we can do a ensitive analysis by manually changing any of the parameters like unit sales price, unit cost price, sales, sales growth, etc. You can, however, use the form control spin button to automate the whole process.

Click on the 'developer' tab in the Excel ribbon, select 'insert' and choose 'spin button'. Now click inside an Excel cell and then drag the mouse to insert the control. If you press the 'alt' key while dragging the mouse to insert the spin button then the spin button fills the cell automatically. Right click on the form control and input the relevant data in the text boxes and click OK. When you now change the data using the spin button you can observe the change in the interconnected cells and so perform a sensitive analysis automatically. In the case of the 'sales growth' we can't directly change the data but input some proper data in another cell, say, D3 and in the relevant cell we get the data divided by 100 as shown in the training video. You can insert more spin buttons at the proper cells to perform a more detailed sensitivity analysis of your business model. Note how the NPV at the bottom changes with the final profits after tax!