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