Introduction to Financial Modelling
Training
In London
Description
-
Type
Training
-
Location
-
Duration
1 Day
-
Start date
Different dates available
Main Topics Covered During This Training. Overview of the modelling process. The key Excel functions in modelling. Model structure: inputs, workings, outputs. Forecasting revenues and margins. Calculating tax and dividends. Incorporating fixed assets and working capital. Forecasting net income and shareholders' equity. Analysing cash flow statement from operations, investing and financing activities. Linking up interest. Analysing key ratios. Suitable for: Participants who want or need to be able to build basic financial models should attend this course. From: Corporates. Investment Banks. Private Equity companies. Analysts. M&A Departments. Consultants
Facilities
Location
Start date
Start date
Start date
About this course
To attend this course, participants should have a basic knowledge of Excel.
Reviews
Subjects
- Excel
- Financial Reporting
- Cash Flow
- Forecasting
- Financial Modelling
- Strategic Finance
- Financial
- Equity
- Financial Training
- MS Excel
Course programme
A one day practical course which focuses on the fundamentals of putting together a financial model. This course includes an introduction to the key Excel functions used in modelling.
Objectives:
- To provide an introduction to financial modelling using Excel, including best practice on structuring a model.
- To introduce the key elements in a forecasting model and enable the participants to complete a forecast income, cash flow statement and balance sheet.
- To introduce the concept of interpretation and analysis and the key ratios used in analysing a forecast.
Course Level: Introductory
Introduction to Financial Modelling