Introduction
Financial Modelling is the process of creating a mathematical representation of a company's financial situation. This includes the creation of financial statements, projections, and analysis of financial data to make informed business decisions.
Course Objective:
- Valuation of a company
- Forecasting future performance
- Budgeting and planning
- Sensitivity analysis
- Capital structure analysis
- Scenario analysis
- Risk management
- Investment analysis
Course Outline:
Day 1
Overview of Financial Modelling/ Excel Fundamentals
- What is financial modeling?
- Importance of financial modeling
- Different types of financial models
- Basic components of financial models
- Introduction to Excel
- Basic operations in Excel
- Excel shortcuts and tips
- Introduction to Excel functions
Day 2
Building Financial Statements/ Financial Statement Analysis
- Overview of financial statements
- Building the income statement
- Building the balance sheet
- Building the cash flow statement
- Ratio analysis
- Common size analysis
- Trend analysis
- Vertical analysis
Day 3
Forecasting/ Valuation Techniques
- Understanding the forecasting process
- Forecasting techniques
- Time-series analysis
- Regression analysis
- Introduction to valuation
- Valuation methodologies
- Discounted Cash Flow (DCF) analysis
- Multiples-based valuation
Day 4
Capital Budgeting Techniques/ Risk Analysis
- Overview of capital budgeting
- Net Present Value (NPV)
- Internal Rate of Return (IRR)
- Payback Period
- Sensitivity analysis
- Introduction to risk analysis
- Risk management techniques
- Scenario analysis
- Monte Carlo simulation
Day 5
Advanced Excel/ Putting it All Together
- Advanced Excel functions
- Data tables and scenario analysis
- Goal seeks and solve
- Pivot tables and charts
- Creating a financial model
- Testing and validating the financial model
- Interpreting and presenting the results
- Tips and best practices
Credits: 5 credit per day
Course Mode: full-time
Provider: Blackbird Training Centre
