Financial Modeling - restricted - discounted
About the Course
As a founder what are the most common uses of financial models at work? How do models focused on growth and scale differ from models focused on risk and strategy? Do we need complex models or simple models? How do we validate assumptions? How much does model design matter?
This is the restricted discounted version of the course. Please make sure that you have the relevant discount approval from us before using it.
We start by focusing on asking and answering the right questions. The models we build are only as good as the questions we ask. Do we need to build a model to manage and plan for growth or debt servicing? Launch roadmap or capital requirements? Scale, turnaround or downside protection? For validating assumptions or pricing product offering?
We use three case studies to work with multiple approaches to designing models.
A model for forecasting growth for a startup on high-octane fuel. A model for determining debt service capacity under a turnaround for a school system in the Middle East. A model for identifying trading signals for bitcoin day traders.
- Building a financial model for growth and capital allocation for startups and founders. The Maya’s Closet case study looking at a growing startup’s capital need and decisions the founders need to make to pick one or more growth strategies.
- Building a financial model for credit analysis and financial forecasting. The GEMS Education case study looks at the GEMS school system debt load in the midst of the Covid-19 related slow down in UAE to evaluate the capacity of the group to raise more debt.
- Building a financial model for fun and curiosity. The directional trading model for Bitcoin case study looks at possible signals and their relationship with changes in Bitcoin prices on a daily basis.
Course timing & Structure
- 4th to 7th July - 7 am to 10 am Pakistan standard time (GMT +5) – For US West Coast, Canada, South American and Far Eastern customers.
- 11th to 14th July - 5 pm to 8 pm Pakistan standard time (GMT +5) – For MENA, Pakistan, Europe, US East Coast customers.
Financial Modelling Day Planner
|Day 1 – Financial Modelling an E-commerce Startups.|
Maya’s closet case study walk through how we quickly build a simple financial model and use it for making business decisions and strategic choices.
Day 2 – Modelling Downside
Shortfall analysis is a powerful modeling technique used in downside analysis.
Day 3 – GEMS Education: Turning Around School System
GEM Case study take a difference lens. For one unlike Maya, the model is significantly more complicated. We end working with many more assumptions and add another level of modeling complexity.
Day 4 – GEMS Continued
Day four is an intense sprint that requires team members to incorporate new data and answer new questions when faced with a time sensitive deadline.
What is GEMS cash outlook? Under which scenarios do cash projection go dangerously low? That is the founder’s lens.
How much is GEMS worth? From the founder perspective? From a buyers point of view? That is the investor and deal lens.
After taking this course you will be able to:
- Build better financial models with a specific view towards free cash flows, risk and downside exposure.
- Link economic models to business models and analyze interaction of the two.
- Model impact of multiple drivers and relationships with each other using scenarios.
- Define and present key performance and business metrics and their relationship with risk and exposure.
- Analyze sensitivity of key performance and business metrics to changes in economic and business cycles.
- Review relationships and transactions from a hands on analytics lens.
This is a hands on course and requires some background and exposure to EXCEL. All participants would need a laptop with EXCEL professional installed on it. The course cannot be taken on a phone. Participant need to build and submit models for review.
The intended audience are founders, product managers, financial analysts, credit analysts, relationship managers and consultants responsible for building growth, valuation and debt servicing models for clients.