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.