✎ «A practical course of video tutorials 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!»
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.
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:
Lesson 1. 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).
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.
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. In this lesson - work with projects. Create a new project. Content and structure of plans. Pages directories and other settings.
Lesson 2. Part 2. 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. 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. 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. 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.
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. 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. 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. 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. 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. 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. 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. 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. 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. 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. 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.
Lesson 5. Part 2.
Lesson 5. Part 3.
Lesson 6. Part 1.
Lesson 6. Part 2.
☛ The following videos are in the process of preparation. For information on the placement of materials on this page, leave your message.
☛ If you want to receive information about the placement of materials on this page, leave your message.