Corporate Financial Modeling with Excel Training Course

 1. Modeling architecture 

1. Components of a financial model
2. Best practices for model design
3. Data validation and error checking

2. Sample detailed case 

1. Case study selection
2. Data gathering and formatting
3. Model set-up and assumptions

3. Timeline modeling 

1. Time periods and layouts
2. Linking statements 
3. Time-based formulas 

4. Revenue & Capex 

1. Revenue recognition principles
2. Sales forecasting techniques
3. Capital expenditure (Capex) planning

5. Depreciation 

1. Depreciation methods
2. Setting Up depreciation schedules
3. Impact on financial performance

1. Financial structure 

1. Capital structure analysis
2. Debt schedule

2. Cost drivers 

1. Variable costs
2. Fixed costs
3. Cost-Volume-Profit (CVP) analysis

3. Dividends & Tax 

1. Dividend policy
2. Modeling dividend payments
3. Corporate taxes
4. Tax expense calculation

4. Integrating the financials 

1. Connecting the financial statements
2. Scenario analysis
3. Sensitivity analysis

5. Valuation 

1. Valuation methods
2. Building valuation models in Excel
3. Sensitivity analysis in valuation

6. Ratio analysis

1. Key financial ratios
2. Interpreting ratio results
3. Benchmarking

1. Circularity switch & iteration 

1. Circular references explained
2. Circularity switch
3. Iterative calculations

2. Simple macros 

1. Macro recording and playback
2. Macro editing and customization
3. Benefits of macros

3. Bond valuation 

1. Bond fundamentals
2. Excel functions for Bond valuation