Using best practice modelling rules and Excel shortcuts, based on real historical financial statements, participants will learn how to forecast and put together a fully integrated financial model. This training will give them the basic modelling fundamentals to continue working on their in-house mod
Using best practice modelling rules and Excel shortcuts, based on real historical financial statements, participants will learn how to forecast and put together a fully integrated financial model. This training will give them the basic modelling fundamentals to continue working on their in-house models.
Key Topics
Using Excel keyboard shortcuts
Using standards for best practise
Understanding circular references and iteration
Modeling a detailed three-statement financial model step-by-step
Modeling a detailed debt schedule include a cash sweep
Finding errors and integrity checking
Who Should Attend?
Financial analysts in investment banks
Junior equity research
Junior investment managers
Finance functions at corporations
City Training UK (“City Training”) is a world leading provider of premium public courses, in-house training and courses for universities and schools.
City Training was founded and is currently managed by several ex-investment bankers who are trainers themselves and passionate about training.
We work with a team of expert trainers, who are among the most experienced specialists in their respective fields. You and your team will benefit from the knowledge, experience and creative approach of a professional with years’ of experience in your sector using recent case studies in your industry.
Why Choose City Training?
Client Focus – A small London-based friendly team dedicated to its clients and tailoring courses to your business.
Experience and professionalism – Our trainers all held senior positions in the City, Wall Street or other leading financial centres and are talented lecturers. Practical Programmes – Up-to-date, practical training including all the latest trends and recent case studies in your field
From heads of departments to credit analysts, recent graduate joining M&A, vice-president in private equity, middle office risk professionals, our trainers have trained thousands of professionals at the following leading institutions worldwide.
We offer courses in financial spreadsheet modeling for both finance professionals. If you are looking for an introduction to financial modeling, a practical guide, a refresher or to enhance your existing understanding then we have the right course for you.
This two-day course is designed for those looking to expand their financial modelling skills. Numerous hands-on practical Excel exercises are used to demonstrate different functionality in a modelling context.
Hands-on practical training course to help you learn exactly what is required to do in your daily work. Up-skill your knowledge to be a Financial Analyst. Practical assignments, illustration spreadsheets, excel shortcuts- all included and can be downloaded at your end for self-practice.
This is an exclusive programme offered by Cambridge Finance and in line with the Royal Institution of Chartered Surveyors (RICS) financial modelling competency.
A financial model is a tool that usually comes as an integrated part of any ‘spreadsheet software’, like Microsoft Excel to forecast the financial prediction of the business in the future. I
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy