Financial Modelling using Excel
Course
In London
Description
-
Type
Workshop
-
Level
Beginner
-
Location
London
-
Duration
3 Days
Focusing on the most topical issues, this course will teach you all the techniques available and how to apply them in practice, using Excel.
Facilities
Location
Start date
Start date
Reviews
Subjects
- MS Excel
- Excel
- Financial
- Forecasting
- Accountancy
- Cash Flow
- Financial Modelling
- Financial Reporting
- Banking Investment
- Capital Budgeting
- Equity Finance
- Project Finance
- Strategic Finance
- Risk Management
- Property Investment
- Savings and Investment
- Transactions
Course programme
There are many characteristics of model building that are common, irrespective of the end-use. In addition to addressing these common features, this course will also identify specific problems and issues associated with the building of cash flow models in specific contexts – transaction structuring, private equity, MBOs and acquisitions. You will:
- Accurately forecast corporate cash flows
- Learn how to quantify risk in your model for decision making purposes
- Maximise the flexibility and robustness of the model
- Leave with practical tips for checking and debugging modelling best practice
- Knowledge of practical hints and tricks
- Increase your knowledge of excel
- Learn how to undertake model review
- Leave with several hundred megabytes of sample models, self-tuition exercises, and reference materials
Agenda Summary
Illustration of Model Types
Model Design
Forecasting Corporate Cash Flows
Accountancy Impacts
Valuations
Implementation of Analysis
Transaction Structuring
Financing
Management Buy-Outs
Various Modelling Issues
Financial Modelling using Excel