Equity Research Scenario Analysis
About the Lecture
The lecture Equity Research Scenario Analysis by eduCBA Global Online Training Experts is from the course Equity Research. It contains the following chapters:
- One Dimensional Data Tables
- Two dimensional Data Tables
- Solver
- Goal Seek
Author of lecture Equity Research Scenario Analysis
eduCBA Global Online Training Experts
Customer reviews
5,0 of 5 stars
| 5 Stars |
|
5 |
| 4 Stars |
|
0 |
| 3 Stars |
|
0 |
| 2 Stars |
|
0 |
| 1 Star |
|
0 |
Excerpts from the accompanying material
... A data table is a range of cells that shows how changing certain values in your formulas affects the results of the formulas. Data tables are especially useful when a person is using/doing price sensitivity analysis or valuation sensitivity. ...
... DATATABLE is while calculating share price from discounted cash flow analysis. Let's use this function together. ...
... The Goal Seek command is used to bring one formula to a specific value. It does this by changing one of the cells that is referenced by the formula. Goal Seek asks for a cell reference that contains a formula (the Set cell). It also asks for a value, which is the figure you want the cell to equal. Finally, Goal Seek asks for a cell to ...
... Finally, click inside the BY CHANGING CELL box and either type or click on the cell whose value can be changed to achieve the desired result. Click the OK button and the spreadsheet ...
