Booking options
£1,900
+ VATCourse Images
Best Practice Financial Modelling: classroom based
Highlights
Delivered In-Person
- Multiple Durations (see dates)
All levels
Dates
All Locations
View Dates Hide Dates
- Delivered In-Person in Dubai• to
- Delivered In-Person in Dubai• to
View Dates Hide Dates
- Delivered In-Person in London• to
- Delivered In-Person in London• to
Description
We will work closely with you, sharing insights and putting into practice core financial modelling techniques as you model a case study based on a business acquisition.
You will learn to create the step-by-step calculations required to forecast the three primary financial statements — income, balance sheet, and cash flow. More advanced topics will include a valuation of the equity in the case study company (based upon the present value of forecast dividends).
Participants can expect detailed instruction and hands-on practice with a focus on developing and working with a financial model that they have built from scratch.
Post-course, you will receive full and ongoing access to the online version of the course as well as online support from our team of modelling experts.
course Content
4 sections•46 lessons
Getting started4 lessons
- 10. Before you begin
- 21. Course agenda
- 32. Course files
- 43. F1F9 productivity macros
Pre course work: Excel Proficiency Skills16 lessons
- 10. Before you begin
- 21. Using the Alt key
- 32. Keyboard shortcuts and the mouse
- 43. Edit directly in cell
- 54. Move selection after Enter
- 65. Macro security and developer tab
- 76. Analysis toolpak
- 87. Reducing worksheet clutter
- 98. Windows explorer settings
- 109. Basic worksheet navigation
- 1110. Selecting, adding and deleting content
- 1211. Inserting rows and columns
- 1312. Adding and deleting worksheets
- 1413. Using the function keys
- 1514. Group mode
- 1615. Standard Excel shortcuts
Pre course work: Model Construction Skills20 lessons
- 10. Before you begin
- 21. F1F9 productivity macros
- 32. Spaces in formulas
- 43. Calculation blocks
- 54. Copying calculation blocks
- 65. Row anchoring
- 76. Navigating using links
- 87. Daisy chains
- 98. Copying links
- 109. Placeholders
- 1110. Placeholder macro
- 1211. Timing flags
- 1312. Cross worksheet links
- 1413. Paste links forward
- 1514. Advanced productivity
- 1615. Introduction to modelling balances
- 1716. Counterflows
- 1817. Temp sheet
- 1918. Quick charts
- 2019. Ten things to remember
Post course work6 lessons
- 10. Feedback module
- 21. Airco solution model
- 32. F1F9 template model
- 43. Biomass
- 54. Fitness Centre
- 65. Hotel Raja
Locations
Reviews
There are no reviews for Best Practice Financial Modelling: classroom based yet.Why not be the first one to review this course?
