Financial models such as the DDM represent a cornerstone of equity valuation from an academic standpoint. But in the real life, many analysts do not use the DDM. The least likely reason for this is:
| ||
| ||
|
The DDM requires assumptions that many analysts find impractical. In addition, the model lacks the flexibility to adapt to changing circumstances. Both of these problems can be overcome, to a large extent, by using spreadsheet modeling to forecast cash flows and other variables.
Relative to traditional financial models like the dividend discount model, the biggest advantage of spreadsheet modeling is:
| ||
| ||
|
Computations are no simpler or more complicated on a spreadsheet as opposed to a calculator. Accuracy tends to be improved with the use of a spreadsheet, because you don’t have to punch numbers into a calculator at any stage. However, someone truly concerned with accuracy can do a fine job with a calculator. The spreadsheet stands out when it comes to quantity. Analysts can program many permutations and scenarios into a spreadsheet, using minutes to do what would take hours or even days or weeks with a calculator.
Which of the following actions will be least helpful for an analyst attempting to improve the predictive power of his scenario analysis?
| ||
| ||
|
The whole point of scenario analysis is the flexibility to modify the inputs to see how changes in one factor affect others. In order to perform scenario analysis, you must deviate from the core model. Increased precision on the inputs will increase the predictive power of almost any model. Spreadsheets reduce the likelihood of computational inaccuracies and allow analysts to more easily modify models to reflect many scenarios.
| 欢迎光临 CFA论坛 (http://forum.theanalystspace.com/) | Powered by Discuz! 7.2 |