Practical course of video lessons on business planning. Practice of financial planning
✎ «A practical course of video tutorials ("12 lessons in business planning") will help you in a few hours to master the tools of the program and begin practical planning — the development and preparation of business plans.
Learn to prepare your own business plans. Plan your business yourself!
We wish you success!»
Practice of financial planning
Who are the courses for?
There are two categories of users, let's call them conditionally: "financial" and "non-financial" managers. For "financial" managers materials presented here to a large extent, should be clear enough.
| "Financial" managers
|| "Non-financial" managers
For "financial" managers. As a rule, numerous references to the formulas given in the articles in financial mathematics, financial modelling, it is impossible to apply in practice. The reasons can be several. For example, when calculating the modified internal rate of return (MIRR) the initial investment is usually recorded at the beginning of the project. But in life so does not happen. When calculating the net cash flow (NCF), must be taken into account present investment needs, that is, at different stages of the project. And maybe, until you get to the details, you will lose a lot of time. Here are real formulas, only those that "work" and is applicable in practice.
For "non-financial" managers. This project was created with the expectation of those entrepreneurs who are engaged in casual work, and who have not had the time to learn the science of financial planning. This video will help you to quickly learn how to create business plans. Step by step, together we will sort out all the secrets of planning, and you will be able to create business plans for themselves, virtually any complexity.
Financial planning today
The practice of financial planning is creating financial models for projects based on generated cash flows.
In accordance with today's requirements, the process of creating financial models must be optimized and executed in the most shortest time, depending on the purpose of user – from 2 days to 4 weeks.
The key objectives of financial planning is:
- Create business plans for investors and lenders, as well - for partners or for internal use.
- Planning and evaluation of risks affecting the cost and integrated indicators of the project - financial risks, risks associated with the increase in project costs, inflationary and other.
- Create presentations for financial and other executives.
- Selection of financing schemes for the project and optimization of the capital structure.
- Timely adjustment of plans, improvement of management quality.
Practical video tutorial course «12 lessons on business planning». Make a business plan yourself!
Lesson 1. About the program. The main differences and features of the program for the preparation of business plans. Licenses, installation and registration. Interface overview. Cooperation and partnership with educational institutions in Russia and the CIS.
Lesson 2. Standard interfaces and tools of the program. With Budget-Plan Express, you can use the full power of MS Office applications - prepare presentations, modify and analyze data, create charts and independently assemble business plans.
Lesson 3. Data preparation and project settings before planning. Some operational plans cannot be initially standardized, since their content depends on the company's activities (for example, a sales plan).
Lesson 4. Operational planning - planning sales, cash receipts and receivables. Methods and secrets of planning practice.
Lesson 5. Operational planning - planning variable (direct) fixed (fixed) costs. The plan “procurement and regulatory costs” displays direct material and other regulatory costs included in the cost of sales. Planning fixed costs is recommended to start after the planning of all major operational plans has been completed.
Lesson 6. Operational planning - planning costs for the stages of production (work with a Gantt chart). Gantt chart is widely used in business planning projects, most likely for the simplicity and adaptability of the planning process.
Lesson 7. Financial reports. Product Report. Profits and Losses Report. Cash flow statement and balance sheet.
Lesson 8. Financial planning As part of the "financial plan" reflects the financial activities of the company (primarily, data on loans and investments).
Lesson 9. Investment Planning. The structure and content of the plans, as part of the investment plan, reflects the investment activity of the company, i.e., the generated investment cash flow in the “Cash Flow Statement”.
Lesson 10. Financial and investment analysis. Preparation of reports. When calculating most of the integral indicators, Discounted Cash Flow (DCF) is used - an assessment technique used to analyze the attractiveness of a certain investment opportunity.
Lesson 11. Practical planning. An example of a business plan for a construction project. The summary estimate report is also important for analyzing the cost structure as a percentage, and in this example it will be demonstrated.
Lesson 12. Practical planning. An example of a business plan for the production of hard cheese. Suppose a business plan scenario. A small workshop for the production of cheese. The company uses a simplified tax system (6% of revenue).
Lesson 1. About the program. The main differences and features of the software product.
In this Lesson - the main differences and features of the program for the preparation of business plans. Licenses, installation and registration. Interface overview. Cooperation and partnership with educational institutions in Russia and the CIS.
Lesson 2 [Part 1-5]. Standard interfaces and tools of the program.
With Budget-Plan Express, you can use the full power of Office applications - prepare presentations, modify and analyze data, create charts and independently assemble business plans.
Lesson 2. Part 1. Standard interfaces and tools of the program. In this lesson - work with projects. Create a new project. Content and structure of plans. Pages directories and other settings.
Lesson 2. Part 2. Standard interfaces and tools of the program. In this Lesson is an overview of the interfaces. Timeline and planning horizon. Cash flow modeling. The contents of the main menu items.
Lesson 2. Part 3. Standard interfaces and tools of the program. In this Lesson - the contents of the main menu items. Overview of the "general settings" form. Building "instant" graphs. Help about the program.
Lesson 2. Part 4. Standard interfaces and tools of the program. In this Lesson are some forms of editing. Form "sales planning". Work with standard built-in tables. The “installment plan modeling” form and other editing forms.
Lesson 2. Part 5. Standard interfaces and tools of the program. In this lesson - the preparation of reports. The general algorithm for calculating a business plan. Perform non-standard calculations. Example of preparing a business plan report in Word.
Lesson 3 [Part 1-4]. Data preparation and project settings before planning.
Some operational plans cannot be initially standardized, since their content depends on the company's activities (for example, a sales plan). These data must be pre-structured, that is, reflect the analytical slice for the future business plan - by products, departments, suppliers, customers, etc.
Lesson 3. Part 1. Data preparation and project settings before planning. In this Lesson - editing the form "General Settings". General data settings (tax mode, start year, etc.) Tax settings: set standard taxes. Methods of adjustment of tax payments. Simulation of non-standard accounting schemes (allocation of costs to stocks, capitalization of costs).
Lesson 3. Part 2. Data preparation and project settings before planning. In this Lesson - editing the form "General Settings". Installation of the directory and new accounting period. Other settings: depreciation rates, trends (currencies, prices, etc.), number formats, financial and investment analysis (project performance indicators).
Lesson 3. Part 3. Data preparation and project settings before planning. In this Lesson - the creation and editing of directories. Translation of texts of plans into other languages ("Translit"). An example of creating a directory of "procurement and regulatory costs." Analytical structure of editable operational plans.
Lesson 3. Part 4. Data preparation and project settings before planning. In this Lesson are opening balances and adjustment tables. How to create a named range for importing external data. Appointment and editing of the table "initial balances". Appointment and editing of the “adjustments” table.
Before you begin planning in the program, create a simple table - which will reflect the main parameters of the project - by product (average annual price, sales volume seasonality, forecast prices, etc.), payments (installment terms for various customer categories), supplies (price , risks affecting price changes, consumption per unit of production, recommended stock, procurement schedule), etc.
Lesson 4 [Part 1-6]. Operational planning - planning sales, cash receipts and receivables. Methods and secrets of planning practice.
Lesson 4. Part 1. Operational planning - planning sales and cash receipts. In this Lesson is a cyclic and discrete model in planning. Planning methodology in cyclic and discrete projects (comparison table). Use of the seasonality factor in the balance of the revenue and expenditure side of the budget. An example for calculating the sales plan. How to calculate the trend of seasonality (example).
When developing sales plans, the difference in planning approaches is always taken into account - in discrete and cyclical production. These are two fundamentally different models with their own features and approaches: discrete production does not imply the presence of seasonal cycles, on the contrary, cyclical production is represented as a process, with distinct annual (seasonal) cycles.
Lesson 4. Part 2. Operational planning - planning sales and cash receipts. In this Lesson - analysis of examples of sales planning in two ways. An example of a sales plan calculation (taking into account seasonality factors) by the classical method - by annual values. An example of a sales plan calculation (taking into account seasonality factors) by interpolation. The final calculation of sales, taking into account safety stock and taxes (VAT). The final review of the methods and tools of sales.
Sales planning is the planning of price and quantity (sales), taking into account the safety stock and taxes. Seasonal adjustment (seasonal fluctuations) is a seasonal adjustment of data. Seasonal adjustments allow better planning of price trends and risks.
Lesson 4. Part 3. Operational planning - planning sales and cash receipts. In this Lesson - adjusting plans with the use of moving averages. Tools for modeling price trends (three models). The method of smoothing short-term fluctuations (example). Examples of working with an exponential smoothing model series. Short-term price forecast (example).
The need for adjustments may not be related to the influence of external factors. For example, wholesale prices are more volatile than prices at subsequent stages in the sales chain. In this case, you can use the method of adjusting price fluctuations or the method of smoothing short-term fluctuations.
Lesson 4. Part 4. Operational planning - planning sales and cash receipts. In this lesson - modeling the influence of external factors on the forecast price trends. Analysis of the example of price planning in conditions of turbulence (unpredictability) of markets. Application of the table of forecast trends to the price range (example). Some methods of sales planning (trade and construction project). Planning for the receipt of money (example).
The method of adjusting price fluctuations (seasonal fluctuations) is used for adjustments to unforeseen price spikes associated with external factors. Planning for such risks (short-term price shocks) is especially important with a high degree of price elasticity of demand.
Lesson 4. Part 5. Operational planning - planning sales and cash receipts. In this Lesson, there are examples of planning a receipt of money. Tools for planning deferred payments - “payment schemes”. An example of planning rental payments - once a quarter (quarterly payment). Example planning of complex payments - 30% advance payment and installment plan for 6 months. An example of creating a payment scheme and performing a test (control) calculation.
The principle of setting “payment schemes” is universal and allows you to create payment models of any configuration - separately for each month and for each product, distributing them in specified periods.
Lesson 4. Part 6. Operational planning - planning sales and cash receipts. In this Lesson is planning receivables. An example of the calculation of quarterly payments. The final calculation of the plans of "receipt of money" and "receivables". Analysis of the plan of receivables. Periods of maximum debtor risks. Findings.
The receivables plan is an important element of the business plan, because all deferred payments, when calculating the project, fall into the group of receivables risks and are considered as part of the financial risks of the company.
Lesson 5 [Part 1-3]. Operational planning. Planning for variable (direct) and fixed costs.
Lesson 5. Part 1. In this Lesson - how to plan direct regulatory costs. Standard procurement plan and standard costs in cyclical projects (comparison table). Methods of accounting for material and intangible costs. An example of creating and editing a direct cost table (example). An example of the calculation of the sales schedule and the need for inventory (at the weighted average price and FIFO).
At the first stage, when all costs are consistently planned, including standard costs for materials and components, calculations are used at the “level” of the plan. After the final completion of the plan editing, the final calculation is performed. The data on VAT and calculations for the accounting of insurance stocks are activated in the table only after the completion of the final calculations.
Lesson 5. Part 2. In this Lesson are stock accounting methods. Methods of stock accounting procurement. Models of moving average in procurement plans (taking into account the influence of external factors). An example of creating a table of fixed costs (example). Aggregation (grouping) of data in the table of fixed costs. Tools for quick (10-15 seconds) planning of cost plan trends.
Planning for procurement and regulatory costs - this is price planning for 36 months (standard planning horizon) regulatory and other direct costs - including taxes, the schedule of purchases and stock. Here it is necessary to indicate the consumption per unit of product (s) and the purchase schedule (if the type of cost is “material”).
Lesson 5. Part 3. In this Lesson - planning fixed costs. Demonstration of the example of the planning of fixed costs (table). “Instant” construction of cost trends by two methods: 1) from the initial value 2) between the initial and final values. An example of posting the costs of a “fixed costs plan” by product (example). Summarizing. Control question.
Note that the planning methods shown here are designed to quickly fill rows. In other cases, use regular editing - keyboard input. Planning fixed costs is recommended to start after the planning of all major operational plans has been completed. Do not forget that part of the calculations of financial plans are plans of "settlements with creditors" in which all transaction costs accumulate.
Lesson 6 [Part 1-5]. Operational planning. Cost planning for production stages (work with a Gantt chart). Work with a Gantt chart on the example of a construction project.
Lesson 6. Part 1. In this lesson is cost planning with a Gantt chart. Gantt Chart - a tool for presentations and the preparation of business plans. Familiarity with the Gantt chart tools. An example of using a Gantt chart for calculating a business plan. Translating data from a Gantt chart to a direct cost plan.
The chart is transformed into a financial table called the “cost plan for the implementation of production stages” —the main goal of creating a Gantt chart: to ultimately get a financial table, which will then be included in the calculation of operating costs.
Lesson 6. Part 2. In this lesson are Gantt chart tools for creating a table of direct costs. An example of using the Gantt chart to calculate the stages of construction of a 12-storey residential complex. Examples of creating a cost table, cost structuring methods. "Binding" of the cost table to the Gantt chart. An example of the calculation of the cost table.
A Gantt chart is nothing more than a peculiar format for editing and presenting data, in addition to the common, traditional graphical and tabular presentation of systematic data. Gantt chart is widely used in business planning projects, most likely for the simplicity and adaptability of the planning process.
Lesson 6. Part 3. In this lesson, you’ll learn how to export a Gantt chart to MS Project (from Budget-Plan Express). Simple export - create a new project. Modification (settings) of the calendar in MS Project for use in business plans - calculation by day (cancel the hourly calculation). An example of exporting a Gantt chart to an existing project file.
“Budget-Plan Express” takes into account all actual calendar days (including weekends), but MS Project by default shows the duration of work in work days. If you want the display of the number of days in MS Project and Budget-Plan Express to match, in order to estimate the duration of the project stages in MS Project in actual calendar days, you need to make additional settings (in the “Standard Project Calendar”, tab “Work Weeks”).
Lesson 6. Part 4. In this lesson you will learn how to import a Gantt chart from MS Project (in Budget-Plan Express). Creating a special (synchronized) file for import. An example of setting up the Resource sheet in MS Project. An example of adding costs in a Gantt chart (MS Project) using a Resource sheet (how to “tie” resources to tasks). An example of importing a Gantt chart from MS Project, including resource costs. Financing schedule.
If you constantly use the same imported file, it is recommended to create a Gantt chart in “Budget-Plan Express” and export it to MS Project (export settings - “tasks, resource sheet”), in order to use it to import data. One of the mandatory conditions for importing data: the project period in MS Project must be within the project period limits in Budget-Plan Express.
Lesson 6. Part 5. In this lesson, there are examples of accounting for capitalization of costs and allocation of costs to reserves in Budget-Plan Express. A practical example of the allocation of costs to stocks, periods of accumulation and write-off of costs. An example of the calculation of the report "profit and loss" (cost accounting). Tools for editing and displaying capitalization in the balance. Calculation of the product report. Security Question.
In some cases, costs increase the value of an asset over several months (for example, in construction projects), that is, they are capitalized by including them in the value of this asset - before the object is put into operation. The algorithm for calculating the “write-off of an asset” corresponds to the operations in the accounting entry - “putting a facility into operation” (debit 86, 62 - share holders and other buyers, credit 08 - construction of fixed assets).
Lesson 7 [Part 1-2]. Financial reports. Product report (break-even analysis). Profits and Losses Report. Cash flow statement and balance sheet.
Lesson 7. Part 1. In this lesson - product report, break-even analysis. The content of the table "product report". Calculation and analysis of product reports. Perform a break-even analysis. The content and meaning of the break-even table. Break-even chart.
Break-Even Analysis allows the company to decide on how much it is necessary to produce and sell products in order to fully cover its fixed and variable costs. The break-even analysis enables the company to make decisions that allow it to maintain a certain level of profitability and to justify the possibilities of sustainable business expansion.
Lesson 7. Part 2. In this lesson - the method of creating financial tables (profit and loss statement, cash flow and balance sheet). Methods of creating financial tables: two plans for creating financial tables (plans for "settlements with creditors" and "payables”). Financial reports: “profit and loss”, “cash flow” and “balance sheet”.
The primary goal of financial planning is to develop financial reports: Profit and Loss Report (P&L), Cash Flow and Balance Sheet. The investment analysis is based on the discounted cash flow (DCF) assessment methodology used to analyze the attractiveness of a certain investment opportunity.
☛ The following videos are in the process of preparation. For information on the placement of materials on this page, leave your message.
Lesson 8. Financial planning
Lesson 9. Investment Planning.
Lesson 10. Financial and investment analysis. Preparation of reports.
Lesson 11. Practical planning. An example of a business plan for a construction project.
Lesson 12. Practical planning. An example of a business plan for the production of hard cheese.
☛ If you want to receive information about the placement of materials on this page, leave your message.