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.
- 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
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:
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.