FT412b
Financial Modelling Workshop
Faculty
Eric Nobileau
Harbour.Space Group CFO
Course length
Duration
Total hours
Credits
Language
Course type
Fee for single course
Fee for degree students
Skills you’ll learn
Overview
Financial Modelling can be an art form. MS Excel, Apple Numbers or Google Sheets are the canvases to build the financial blueprint of a startup. By projecting numbers, you can test and illustrate the viability of a business. As with all good designs, it should be intuitive in its structure and elegant in the way it represents complexity.
This hands-on course goes into your startup Financial Model structure, from reviewing the input of core assumptions and key metrics influencing costs and revenues to testing how realistic your financing strategy and projection scenarios are. Very interactive and participative, each project will be reviewed and discussed through the scrutinising lens of the mighty Spreadsheet!
Learning highlights
- Translating a startup concept into coherent financial numbers
- Building sound financial projections
- Structuring a good model to support your financing strategy
- Transforming a business idea into a working financial model
- Demystifying financial statements
Course outline
15 classes
Introduction to Financial Modeling
What is it? Why is it so Important?
Financial Statements…
...and a bit of Accounting
Revenue and Expense Drivers
Fueling your Business Engine
Model Structure
Key Ingredients and Best Practices
Trash In, Trash Out
Good Assumptions and Occam’s Razor
Growing Revenues
Customer Acquisition Funnels
Spreadsheet Hacks
Scenarios and Dropdown Menus
Investor Metrics I
Funding Need, Break-evens, Burn Rate
Investor Metrics II
Returns and Valuations
The Summary Dashboard
Sensitivity Analysis, Graphs and KPIs
Fine-tuning your Model I
Team Break-out Session
Fine-tuning your Model II
Team Break-out Session
Fine-tuning your Model III
Team Break-out Session
Demo Day I
Presentations
Demo Day II
Presentations
Prerequisites
- Choose a preferred spreadsheet model for the course from MS Excel, Apple Numbers or Google Sheets.
- Come prepared with your startup project basic model if you already have one, a business idea to develop, or be ready to join a team on someone else’s project.
Methodology
Through interactive lectures and a practical hands-on approach, we will go into the key components that make a good model and apply the Financial Metrics and KPIs of your Capstone startup/project to bring its financial model to life.
How will it stand up to the test of your lecturer and peers? The students will work in small teams on a P&L model based on their capstone or a startup/project of their choice and present their working models to the class during the last week.
But before you jump straight into modelling, and to start you on the right footing, you will build an understanding of financial statements and put numbers into perspective with a real-life case study.
To balance theory and practice while keeping it interesting and interactive, the sessions are structured into the following parts:
-Quick Quiz: recap of previous day’s session (weeks I-II)
-Knowledge: theory part of the course (weeks I-II)
- Fieldwork: individual case studies - each student presents the financial statements of a publicly listed company (week I)
- Teamwork: work with your team to develop the financial model of a startup project or business idea (weeks I-III)
Grading
Eric joined Harbour.Space in 2018 as Group CFO after 27 years of a distinguished career in financial markets with international banks in London, New York and Paris, most recently as Managing Director at Citibank’s Markets Group in London.
His extensive experience designing and arranging bespoke financial solutions for Corporate, Sovereign and Public Sector entities in developed and emerging markets alike, has made him a respected expert in the field of risk management and structured finance in multiple jurisdictions.
See full profileApply for this course
Financial Modelling Workshop
by Eric Nobileau
Total hours
45 Hours
Dates
Jun 14 - Jul 02, 2021
Fee for single course
€1500
Fee for degree students
€750
How to secure your spot
Complete the form below to kickstart your application
Schedule your Harbour.Space interview
If successful, get ready to join us on campus
FAQ
Will I receive a certificate after completion?
Yes. Upon completion of the course, you will receive a certificate signed by the director of the program your course belonged to.
Do I need a visa?
This depends on your case. Please check with the Spanish or Thai consulate in your country of residence about visa requirements. We will do our part to provide you with the necessary documents, such as the Certificate of Enrollment.
Can I get a discount?
Yes. The easiest way to enroll in a course at a discounted price is to register for multiple courses. Registering for multiple courses will reduce the cost per individual course. Please ask the Admissions Office for more information about the other kinds of discounts we offer and what you can do to receive one.