Cart is empty 
Description
Course Duration: 2 Weeks (Monday – Thursday)
Course Outline:
Advanced Excel Functions
- Complex Excel Functions
- Using What if Analysis
- Goal Seek & Scenario Manager
- Formatting especially number formatting
- References, fixed and relative references
Business Reporting and Financial Analyses
- Pivot Table, analyzing with pivot tables
- Slicers & Timeline
- Charts, Smart Tables
- Connection of Multiple Pivot Table
- Connection of Multiple Slicers
- IF Function
- Multiple IFS
Fundamentals of Financial Modeling & Best Practices
- Overview of Financial Modeling
- Understanding Financial Statement Analysis
- Learning Financial Modeling best Practices
- Financials Model Setup
- Strategies to build financial model
Preparation of Schedules for Financial Modeling
- Revenue and pricing
- Cost of Sales
- HR and Payroll
- Operating Costs
- Working Capital
- PPE Lapsing & Depreciation
- Debt and Loan Amortization
- Equity
- Income Tax
Financial Statement Projections Model
- How to integrate financial statements
- Forecasted Income Statement
- Forecasted Balance Sheet
- Forecasted Cash Flow Statement
Scenarios Management
- Scenarios List i.e. Base, Best and Worst
- How to build scenario switch
- Selection of Economic and other indicators for scenarios
- Scenario switch integration
- Summary of each scenario
Valuation Model
- Understanding of Discounted Cash Flow (DCF) Model
- Building of DCF model
- Practical Case Study of DCF model
- Calculation of NPV, IRR, Profitability Index (PI, Return on Investment (ROI) and Payback period with case study
Reviews
There are no reviews yet.