Budget-Plan-Express - harmony planning
Download demo
First project
For Partners
Personal account

Skip to content

Content and structure of planning

General algorithm for calculating a business plan. Data calculation
Topography of plans

Planning. General algorithm for calculating a business plan. Data calculation

General algorithm for calculating a business plan

At the first stage, operational plans are built. Operational plans — sales, costs, settlements with creditors, etc. — are the basis of the structure of the future business plan. Therefore, until the operational plans are completed, it makes no sense to select schemes and financing options (financial and investment plans).

There are some features that need to be taken into account when preparing operational plans that you should know if you are going to prepare business plans yourself. For example, when planning in cyclical projects, sales are first planned (money receipts, receivables) and only then the cost part of the business plan. But in discrete (non-cyclic) projects it is construction, for example, consulting, the production of complex single products - in this case, the opposite is true. First, the costs are described (usually in the Gantt Chart), for example, the construction stages in the Gantt Chart, and then the sales options are planned.

So, the next step of the planning algorithm when preparing a business plan is a preliminary calculation of operational plans, first estimates of the effectiveness (operational efficiency) of the project.

The first stage can be repeated several times, it is important to find the most effective option (or - options) of operational plans.

The next step is the selection of a financing scheme. At this stage, it is necessary not only to choose the best option (options) for a financial solution, but also to eliminate cash shortages in all periods, as well as to eliminate possible cash gaps - with the help of various loan products (their options), leasing, investment, etc. Simply put, the final Cash Flowy line (cash) should not be negative, otherwise the program will not allow you to calculate the integral indicators of the project.

And only then are discounted project performance indicators (integrated indicators) calculated. And of course, the effectiveness of the project depends not only on operating activities, but also on an effective financial plan.

Approximately, such a sequence of steps, such a general algorithm is used in the preparation of business plans.

Data calculation

1. Calculations at the levels of the "plan" and "project"

The calculation process of a business plan include a serial calculation: from "slave" and "shared" plans for the final calculation of the whole project. For example, the content of the following plans depends on the "sales plan", and at the same time, the "sales plan" also includes plans for each product. Two conditional levels of data calculation can be distinguished: preliminary (at the level of the "plan") and the final calculation (at the level of the "project").

Preliminary calculations (calculations, plans)

For a part "financial plan" and "investment plan", it is sometimes necessary to do a preliminary calculation to Refine or analyze the results of the calculation. For example, for some categories of assets (or asset group), the calculations of which significantly affect the financial performance, it would be important to watch and to perform a preliminary result before he gets into financial reports.

Calculations at the plan level. Preliminary calculations

Do not forget, in some cases, business planning is the search for optimal solutions. Intermediate calculations may be required at any planning stage, including with a view to clarifying parameters for a specific product (credit, asset, investment or financial instrument, etc.).

After all part of the plan finalized and edited, you can perform a final calculation of the plan, in the form of editing: "Calculation → full settlement → OK".

Calculations at the level of "project". The final evaluation of the project

After any of your plans (for example, "sales plan") is finally completed, it still has not become part of the project, and it's time to enable it in the project. This means that the program must perform several additional calculations, which tie the plan to the project. With respect to "sales plan" it can be VAT, other taxes, the calculation of the weighted average prices, FIFO, stock of finished products for the plan, "procurement" etc.

To run final calculation, you need to call the form of the calculation: "Main menu → Data → Calculate → to Select the plans to calculate → OK" (also the F9). In addition, the form of calculation is necessary to choose the period of the beginning of the calculation, or leave the default values (the first month of the project).

The form of calculation is called from the Main menu: Data → Calculate. Or the same F9.

the Final calculation of the project sales plan, procurement plan and standard costs, fixed costs plan, financial plan, investment plan

"Calculation start period" is set for operational plans and does not matter for financial plans, which are calculated "from scratch" every time.

2. Specificity of calculating project plans

Some plans can not be counted independently of other plans. For example, a "plan for the receipt of money" can not exist without a "sales plan". Below is a list of plans that are calculated at the same time:

  1. Plan cash receipts
  2. Plan receivables

  1. Production plan
  2. Plan production costs

  1. Plan payments to creditors
  2. Profit and Loss statement

  1. Payment Plan for Accounts Payable
  2. Cash flow statement

  1. Balance sheet
  2. Financial plan
  3. Investment plan

The correctness of the calculations is "confirmed" or "not confirmed" in the balance control line.

For the correctness of calculations, it is recommended, firstly, to execute a sequence of calculations (you can not consider Plan cash receipts before the Sales Plan), and secondly, all financial plans (Profit and Loss statement, Cash flow statement and Balance sheet ") is recommended to be considered simultaneously, and not separately.

3. The total negative cash flow must be "eliminated"

If in the final lines of "profit and loss" or "Cash flow statement" there are negative values, these periods are highlighted with a red background.

In the "Report of cash flows" there can be no negative values, since there can not be negative money in reality, therefore negative values must be "eliminated"! There are three main approaches (ways) to eliminate the cash deficit in the line "Balance of cash and cash equivalents at the end of the period", use one of them or a combination of them:

  1. Find investment (see "Placed instruments instruments." Practical planning ");
  2. Attract credit or leasing resources (see "Credit products" and "Operating and financial leases")
  3. Change operating conditions, primarily: reduce costs, increase sales prices, reduce procurement prices (change suppliers), etc.
  4. In addition to these measures, of course, need to pay attention to financial optimization at all levels of planning. For example, "review", if possible, the loan terms, conditions of settlements with suppliers, etc.

    In some cases, in conditions of limitations of internal reserves and external factors, negative values can not be eliminated. In this case, the given project is considered unprofitable, and its further calculations and analysis are meaningless.

If the negative values are not eliminated in Cash-Flow, in the line "Balance of cash and cash equivalents at the end of the period", the calculation of the "Balance sheet" table will be interrupted - until negative values are eliminated.

Help about the program "Budget-Plan Express", © Strategiс-Line, LLC | Help contents

© 2007-2019,  «Strategiс-Line», LLC,  support@strategic-line.ru, send a message ✉
   Home | Product | Buy | Reading | Contacts