Course Images

Best Practice Financial Modelling for Rebel, Rotterdam

Best Practice Financial Modelling for Rebel, Rotterdam

By F1F9 Academy

4.9(11)
  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • Delivered In-Person

  • All levels

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 sections46 lessons
Getting started4 lessons
  1. 10. Before you begin
  2. 21. Course agenda
  3. 32. Course files
  4. 43. F1F9 productivity macros
Pre course work: Excel Proficiency Skills16 lessons
  1. 10. Before you begin
  2. 21. Using the Alt key
  3. 32. Keyboard shortcuts and the mouse
  4. 43. Edit directly in cell
  5. 54. Move selection after Enter
  6. 65. Macro security and developer tab
  7. 76. Analysis toolpak
  8. 87. Reducing worksheet clutter
  9. 98. Windows explorer settings
  10. 109. Basic worksheet navigation
  11. 1110. Selecting, adding and deleting content
  12. 1211. Inserting rows and columns
  13. 1312. Adding and deleting worksheets
  14. 1413. Using the function keys
  15. 1514. Group mode
  16. 1615. Standard Excel shortcuts
Pre course work: Model Construction Skills20 lessons
  1. 10. Before you begin
  2. 21. F1F9 productivity macros
  3. 32. Spaces in formulas
  4. 43. Calculation blocks
  5. 54. Copying calculation blocks
  6. 65. Row anchoring
  7. 76. Navigating using links
  8. 87. Daisy chains
  9. 98. Copying links
  10. 109. Placeholders
  11. 1110. Placeholder macro
  12. 1211. Timing flags
  13. 1312. Cross worksheet links
  14. 1413. Paste links forward
  15. 1514. Advanced productivity
  16. 1615. Introduction to modelling balances
  17. 1716. Counterflows
  18. 1817. Temp sheet
  19. 1918. Quick charts
  20. 2019. Ten things to remember
Post course work6 lessons
  1. 10. Feedback module
  2. 21. Airco solution model
  3. 32. F1F9 template model
  4. 43. Biomass
  5. 54. Fitness Centre
  6. 65. Hotel Raja

Location

Wijnhaven 23, 3011 WH Rotterdam, Netherlands, 3011 WH, Netherlands, Rotterdam

About The Provider

Expert & Certified Financial Modelling courses for best-in-class modelling

Read more about F1F9 Academy

Reviews