课程: Financial Modeling Foundations

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Sensitivity analysis and financial models

Sensitivity analysis and financial models - Microsoft Excel教程

课程: Financial Modeling Foundations

开始一个月试用 购买团队方案

Sensitivity analysis and financial models

“

- [Instructor] If we've built our financial model correctly, when we get done, the whole model should be tied together so that any change to the model dynamically updates across the entire spreadsheet. This is very useful when dealing with practical problems like the need to account for different kinds of scenarios that may arise in corporate finance. Let me show you what I'm referring to. I'm in the 03_02_Begin Excel spreadsheet. Now what we have here are the revenue projections and other projections that we've made over time, and they're tied to our revenues, our net income, our earnings per share, and of course the various balance sheet and cash flow statement items. Now, let's pretend that the firm is concerned about a recession going forward. Well, we've assumed for 2019 that we'll have revenue growth of 6.3%. But there's nothing magical about that assumption. Indeed, it's not even a very sophisticated assumption. It's simply based on an average of revenue growth over the last…

内容