Financial Modelling

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