31
AUG
2020
Financial Modeling in Excel
0 Comment
1. Excel shortcuts
-cell referencing
-linking multiple worksheets
-adding links
-dashboard
-functions
-macro recording/viewing
2. VBA BASIC scripting
– objects and ranges
-controlling scripts
3. VBA data handling and manipulation
4. Building 3 statement model
– income statement
– cash flow statement
-balance sheet
5. Sensitivity and scenario analysis
-NPV sensitivity
-scenario analysis implementation
-Goal seek and solver
-break even
-curve fitting
6. Macro; sensitivity and scenario
– macro sensitivity
– macro scenario
-macro breakeven analysis
7. Optimization using vba
– portfolio management
8. Simulation using vba
– Montecarlo simulation introduction
– application of Montecarlo simulation
9. Risk modeling
– factoring risks or uncertainties
10. Crystal ball: data forecasting
-probabilistic modeling
-incorporating cross-elasticity
11. Crystall ball: data optimization
– project selection
– product optimization
© Copyright 2013, SeaGate. All rights reserved.