Business Valuation & Investment Decisions
2-Day Workshop
Develop structured models for business valuation and investment decisions and learn how to make them dynamic using sensitivity analyses. Utilize dynamic drop-down lists and sliders to adapt your models flexibly.
In addition, we will show you how to create visually appealing tables and charts that are ideal for decision-making templates.
Our seminar provides practical insights into how you can improve your decision-making processes and turn complex data into meaningful information.
Workshop Content
Basics of Business Valuation
- Objectives and reasons for business valuation
- Different models of valuation
Structured Valuation Models
- Building structured valuation models
- Separating input and output factors
Solution-Oriented Excel Use
- Scenario selection using:
- Indirect addressing, even in international Excel versions
- Creating reference and comparison functions
- Optional calculation components: Turn on/off using switches or radio buttons
- Dynamically adjusting selection options: Creating dynamic drop-down lists
- Cash flow, balance sheet, and P&L: Handling circular references or avoiding them
Excel Case Studies
- Developing an example business valuation with numerous practical exercises
- Evaluating planned investments, e.g., capacity expansions in manufacturing companies
- Quality assurance and plausibility checks for developed models
- Creating dynamic models with scenario development and sensitivity analyses
- Generating visually appealing tables and charts for decision-making templates
- Correctly embedding charts into PowerPoint and Word
Who Should Attend This Workshop?
This workshop is aimed at M&A experts, controllers, and anyone involved in creating models for business valuations and investment decisions who wants to work efficiently with Excel.