Financial Modeling
Ask your modeling questions here! Feel free to copy/paste specific sections from filings as appropriate.
Questions/Discussions
Sort by Date ▼ / Top Rated
Register for free or log in at the top right of this page to join the discussion
Re: Excel Formula of running a scenario analysis
I'm now at the end of the DCF model and I'm about to run a scenario analysis with changes of some variables, e.g. dividend payout ratio and beta. So if I want to set up a table with different combinations of these two variables, is there any excel formula that I can use to fill in the intrisic value...
I'm now at the end of the DCF model and I'm about to run a scenario analysis with changes of some variables, e.g. dividend payout ratio and beta. So if I want to set up a table with different combinations of these two variables, is there any excel formula that I can use to fill in the intrisic value (stock price) in the table without changing the variables each time and filling in the stock prices manually? Thank you.
Read More
Login to Reply
0
by Leon W.
added 7 years ago
