- Tutor is available to students
Financial Modelling in Excel
London Training For Excellence
Summary
Overview
Number crunching is one the most important aspects of any job in the world of finance. Unlike other businesses, professionals in the finance industry have to work with large amounts of numbers. There is thus a need for people who have a good knowledge of MS Excel to create financial projections, analyse competition and markets and make financial models. A mastery over Excel is actually a way to excel in the finance world, as it ensures accuracy, speed and can give you that edge over your peers.
Our courses are aimed at both intermediate and experienced staff – it is expected that all participants will have a good grasp of Excel prior to attending our courses.
Description
Day 1
- Financial Modelling Principles
- Excel as a tool for financial modelling
- Building financial models best practices
- Modelling growth drivers, depreciation, cost drivers, asset & debt schedules
Day 2
- Valuation Principles
- Projecting cash flow statement
- Circular references and handling them
- Financial ratio analysis
- Valuation using DCF & Comps
- Scenario analysis and Building valuation dashboards
Day 3
- Advanced Functions, Tools & Charting Techniques
- Advanced Tools in Excel for Auditing Financial Models
- Mastering Financial Functions
- Advanced Charting Techniques in Excel
Day 4
- Using Macros & VBA for Financial Modelling
- Understanding Macros & VBA for Financial Modelling
Day5
- Implementing Monte Carlo Simulation
- Advanced Charting Techniques in Excel
- Commodities
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.