Financial Modeling Consulting Services - Restricted

SKU 00157
$950.00
In stock
1
Product Details

Restricted to customers who received the special discounted code.

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.

  1. 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.
  2. 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.
  3. 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

Cohort Four
  • 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.
Cohort Five
  • 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.

Maya is a 4 year old ecommerce startups that has gone from strength to strength in its specialty market. The two founders are evaluating a number of growth options and are using financial modeling to pick between the choices in front of them.

  1. Maya Case Study
  2. Business Drivers
  3. Linking drivers to financial model
  4. Discussion
  5. Expansion
  6. Growth – Limits and Caps
  7. Step Functions

Day 2 – Modelling Downside

Shortfall analysis is a powerful modeling technique used in downside analysis.

While on day one we looked at growth, on day two we walk through a list of things that can go wrong and modeling their impact on Maya.

  1. Shortfall applications
  2. Order History
  3. Trends – histograms – distributions
  4. Shortfall concept
  5. Finalizing balance sheet
  6. Income statement
  7. Statement of free cash flows
  8. Debt Service Coverage Ratio

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.

How do we turn around a school system hit with a increasingly severe regional slow down? How does that impact and effect projections and debt servicing capacity.

  1. Building the Model
  2. Business Goals
  3. Modeling Challenges
  4. Finalizing Balance Sheet
  5. Income Statement
  6. Statement of Free Cash flows
  7. Assumptions, data sources, structure
  8. Design thinking and model building

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.

Given the outlook, can GEMS service its debt? Can it afford to borrow more? That is the banker’s lens.

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.

  1. Extending the Model
  2. Handling complexity
  3. Changing the context
  4. Putting it all together
  5. Cross checks and simple rules
  6. Answering the valuation question
  7. Takeaways and conclusion

Learning Objectives

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.

Prerequisites

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.

Target Audience

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.

Save this product for later