I am building a financial model. I intend to add a scroll bar for certain values in the P&L Statement, such as Revenue growth, COGS, EBITDA atc. I would like to add scroll bars to each of these rows, so that I can determine values for revenues, using different values of revenue growth, say 5%, 10%, 15% etc. What is the process for adding such scroll bars? Thanks!
How do I add sensitivity analysis to a financial model via a scroll-bar?
- Thread starter nitin2k
- Start date
Nitin2k
Firstly, Welcome to the Chandoo.org Forums
Scroll bars are what is known as a Form Control
You can read abbout them here: http://chandoo.org/wp/2011/03/30/form-controls/
You may also want to have a look: at http://chandoo.org/wp/2010/05/06/data-tables-monte-carlo-simulations-in-excel-a-comprehensive-guide/
As it has some good techniques for setting up tables of sensitivities
Firstly, Welcome to the Chandoo.org Forums
Scroll bars are what is known as a Form Control
You can read abbout them here: http://chandoo.org/wp/2011/03/30/form-controls/
You may also want to have a look: at http://chandoo.org/wp/2010/05/06/data-tables-monte-carlo-simulations-in-excel-a-comprehensive-guide/
As it has some good techniques for setting up tables of sensitivities
Thanks Hui for the quick reply. In fact I've already subscribed to Chandoo's regular updates over email. You had sent me the Monte Carlo files over email, since I was unable to load the ones on the link on Chandoo. Hope it is alright if I come back to you in case I need your assistance on form control?