Join my online workshop

BMDNA-based Financial Planning

Master the art of traditional financial planning and revolutionize your approach with the Business Model DNA (BMDNA). Elevate your financial planning skills by integrating BMDNA concepts, crafting a tailored simulation and navigation system for your business model.

Workshop Info

  • Online workshop via video conference
  • Total duration 4 hours including breaks
  • German / English as required
  • Small groups for effective learning
  • Answering individual questions
  • Including PDF handout and Excel template

Workshop Description

Deep dive into the world of financial planning with this workshop. First, get to know the classic financial planning: profit and loss statement, revenue planning and cost of sales, human resource planning, marketing and sales planning, operational costs, depreciation and amortization, liquidity planning with the various cash flows including financing, and important financial ratios. Then discover step-by-step how to add Business Model DNA (BMDNA) concepts to the traditional financial plan for a more accurate and data-driven simulation and navigation system. Includes a PDF handout and an Excel template to jump start and / or extend your financial plan.

Make the most of the online workshop

How does the Online Workshop work?

The online workshop consists of the following three steps:

1.

Workshop booking

Book the workshop individually or in a combination. Select for suitable dates and the desired language. After payment your participation will be confirmed and you will receive the dial-in data by email. My workshop "The Business Model DNA (BMDNA)" is a good basis.

2.

Workshop participation

Participate in the online workshop from anywhere. Thanks to the small groups, you can ask individual questions about modeling your business model at any time during the entire workshop. Receive the PDF handout and the BMDNA-based financial plan template afterwards.

3.

Create financial plans

Afterwards, you can use the financial plan template in Excel format as a source of inspiration and template for creating or optimizing your own financial plan for internal financial planning, controlling and reporting as well as for successfully approaching external investors.

Learn more details

Topics, Contents and Exercises

My online workshop consists of 18 sections and takes a total of 4:00 hours including short breaks. Sections include illustrative examples and practical instructions designed for working on your own financial plan after the fact. The workshop will be conducted in small groups and in German or English as required. Includes PDF handout and BMDNA-based financial plan template as Excel document.

Section 1: Mutual introductions, agenda and individual focus

At the beginning of the online workshop, we conduct a short round of introductions and clarify the individual backgrounds, previous knowledge, interests and wishes of the participants so that I can address them accordingly in the course of the workshop. Afterwards we discuss the agenda and the further course of the workshop. If necessary, we will also clarify whether the workshop should be conducted in German or English, if this has not already been determined in advance.

Section 2: The classic profit and loss account (P&L)

In this section, I use the Excel template and examples to introduce the basics and components of the income statement (P&L or P+L): Sales planning and cost of sales, margins, personnel planning, other operating costs, depreciation and the most important financial ratios such as EBITDA and EBIT.

Section 3: Classic liquidity planning with the various cash flows

In this section, using the Excel template and examples, I will introduce the basics and components of liquidity planning with the different cash flows: the operating cash flow, the investing cash flow, the financing cash flow, and the total cash flow once without and once with the financing cash flow. We will also see how to use these cash flows to determine exact funding needs.

Section 4: Key financial ratios and charts

In this section, with the help of the Excel template and examples, I will present the most common financial ratios and metrics and show how you can very easily extend them with your own or specific ratios. In addition, together with examples, we will discuss the most important charts and also clarify here how to create more specific charts very quickly.

Section 5: Brief Introduction to the Business Model DNA (BMDNA)

In this section, I briefly introduce the concepts of the Business Model Mechanism (BMM) and the Business Model DNA (BMDNA) as a basis for incorporation into traditional financial planning. My workshop "The Business Model DNA (BMDNA)" or my masterclass "The Business Model DNA (BMDNA)" provide the perfect foundation for this, but you can also easily follow this section without any prior knowledge.

Section 6: Brief introduction to the Excel template for BMDNA integration

In this section, I will explain how the Excel template implements the concepts of the Business Model Mechanism (BMM) and the Business Model DNA (BMDNA) in concrete terms and how the profit and loss account (P+L), the liquidity planning, the typical key figures and the charts are calculated from them in an automated way before we will deal with the additional details in the following sections.

Section 7: The roadmap as the basis for financial planning

In this section I show that the various plans or roadmaps (e.g. product releases, market entries, marketing & sales and financing rounds) are the basis for financial planning and how to integrate them, with milestones, into financial plan.

Section 8: Modeling of different target groups

In this section, I show how to integrate the different target groups, such as user groups, customer segments, and/or potential partners and their most important metrics, such as Total Addressable Market (TAM), into a financial plan and how these metrics can change over time.

Section 9: Modeling acquisition channels

In this section we will deal with the modeling of the acquisition channels planned over time, such as primarily marketing and sales activities, in order to make the various target groups aware of the company's products and / or services. We will see how to model the different activities with appropriate metrics into the financial plan.

Section 10: Modeling conversion steps

In this section, we will model the various conversion steps of the acquisition channels planned above for the different target groups. In doing so, we will see how to implement, for example, time delays of conversion steps or even multi-step or interlocking conversion processes into the financial plan.

Section 11: Modeling Active Users, Customers and Partners

In this section I will show how to model active relationships with users, customers and / or partners in the financial plan. We will also see how the relationship status changes over time and how to represent the relationship duration with appropriate metrics.

Section 12: Modeling revenue models

In this section, we will look at modeling the different revenue models and how they can be combined over time. I will show different templates for the most common revenue models and explain how you can use them as a basis and source of inspiration for your own individual revenue models and combination possibilities.

Section 13: Modeling of personnel planning (Human Ressources)

In this section, I'll show how to model individuals, job positions, and entire teams into a financial plan, and how to account for such things as part-time, full-time, salaries and fringe benefits, and changes over time in planning. I will also discuss how to automatically calculate matching full-time employee positions based on specific values such as the number of active customers. The presented templates and concepts can serve as a basis or inspiration for your personnel planning.

Section 14: Modeling of other operating costs

In this section, I show how to model other operational costs over time and at what level of detail, for example, you can have certain costs such as office rent based on the number of full-time employees or server costs based on the number of active users, calculated automatically.

Section 15: Modeling Investments with Depreciation

In this section, I briefly review the topic of investing in things with depreciation and show how to model the different depreciation durations over time.

Section 16: Modeling of financing activities

In this section, we deal with the modeling of different financing activities over time, such as the deposit of share capital, the entry of business angels and / or venture capital companies as well as loans, funding or grants. The concepts presented can serve as a basis or inspiration for modeling your individual financing activities.

Section 17: Modeling scenarios and identifying key metrics for navigation.

In this chapter, I show how to model different scenarios and compare them with each other. In addition, I explain how one can find out by "playing with metrics" which factors have influence on what (e.g. profit and loss, liquidity, growth etc.) and how you can identify your key metrics for the successful navigation and control of your company.

Section 18: Summary and outlook

In the last section, I summarize everything again and go into how you can / must individually adapt the Excel template if you want to make major changes / additions to the tables. I will also show how to extend a financial plan with views with the comparison of planned figures versus actual values and the corresponding reporting.

Who is this online workshop for?

Target Groups and the Advantages

I have developed this online workshop for the following target groups:

Entrepreneurs & Founders

Become an expert in classical and BMDNA-based financial planning. Learn how to use the individual mechanism and levers of your business model as a basis for detailed financial planning, focused navigation, investor outreach and reporting, in addition to the classic financial plan schema. Use the practical financial plan template as a basis and inspiration for different financial plan scenarios.

Managers & Consultants

Expand your expertise in classical and BMDNA-based financial planning. In addition to the classical approach, discover the modeling of the individual mechanisms and corresponding levers of business models for precise financial planning, targeted navigation, decision-making and efficient reporting. The practical financial plan template is available to you as a tool and inspiration for your projects.

Investors & M&A

Use BMDNA-based financial planning to better evaluate opportunities and risks of business models or financial plans for different scenarios. Take a look at the business model mechanism and the associated levers in the financial plan and understand in detail potential success factors and sticking points. The practical financial plan template serves as a solid foundation and inspiring example for your evaluation projects.