Budget-Plan Express – a software product for financial planning, analysis and preparation of business plans
Budget-Plan Express – it is a modern and affordable, easy to use software product for financial planning, for the development and preparation of business plans, presentations, financial and investment analysis. The developer of the software product Budget-Plan Express is «Strategic-Line», LLC.
Create a business plan yourself
For a number of reasons, the development of business plans is considered a labor-intensive process, which is why most companies try to order a business plan «on the side». With the use of a specialized software product, everything changes, as the most time-consuming processes for the development of the financial part of the business plan will be undertaken by the program.
Now you can independently develop business plans. Of course, using the program will save your money in order, but much more important is the development of positive financial planning practices, which in itself increases the level of management and the quality of decision-making.
The first objective of financial planning is the development of financial plans and reports, only then you can proceed to the analysis, without which the business plan has no practical meaning, that is, you need to calculate the integral indicators (PB, DPB, NPV, PI, IRR, etc.). The basis for calculating investment performance indicators (integral indicators) is net cash flow (Net Cash Flow, NCF).
Any business plan can be conditionally divided into 2 main parts: general description and financial calculation ...
Analysis based on financial ratios (coefficient analysis) allows you to examine the financial condition, performance and investment potential of the organization, and includes the following groups of indicators:
1. Liquidity Ratios: absolute liquidity (Cash ratio); Urgent liquidity (QR); current liquidity (CR); net working capital (NWC).
Indicators of investment efficiency. Calculation of key indicators
In Budget-Plan Express all key integral indicators are calculated, as well as other indicators that are calculated, including on their basis:
☛ Note that the basis for calculating investment performance indicators (integral indicators) is net cash flow (Net Cash Flow, NCF). To obtain a net cash flow from the total cash flow, financing (credit financing and equity instruments) is completely excluded.
Legal address: DUBROVSKAYA 1-YA, 13
Specialization, competences: development of own software for financial planning, development of business plans and analysis, reporting and planning in IFRS, integration with MS Office applications and other applications, specializing in performance management, development of integrated solutions, control and management of the project team .
Budget-Plan Express - an active addition to your office
Methods and algorithms of calculation of the credit (leasing) products
Budget-Plan Express, you can easily plan for credit or lease products of any complexity. For ease of operation for users defined three types of products that are selected from the list: "Standard", "Annuity", "Consumer". Choosing the type of product, the user selects the formula and the standard algorithm which will be used to settle payments.
Using the advanced settings, the user can model virtually any unique loan product.
Eliminate the deficit of cash or temporary cash shortages
In the final stages of planning, in the final line of the report on movement of funds (Cash flow) may generate negative values, which mean a shortage of cash or temporary cash gap (cash deficiency), i.e., the lack of funds needed to Finance the next ensuing costs. In contrast to the production of the current gap, a temporary financial gap can be predicted.
If schedule and in recent periods has been in the negative zone, it would not have anything to do with the cash gap, and would apply to the budget deficit of the project, and in this case the project would be uneconomic (non-viable).
Model weighted average cost of capital – WACC
Model weighted average cost of capital (Weight Average Capital Cost, WACC) represents the weighted average yield expected from all invested in the company capital, both own and borrowed.
WACC is calculated by computing a weighted value of the component sources of financing according to the following formula:
WACC = [Ve / (Ve + Vd)] × ke + [Vd / (Ve + Vd)] × kd × (1 – T)Где:
Ve – the amount of capital of the company;
Vd – borrowed funds;
ke is the ratio of the cost of equity capital;
kd is the ratio of the cost of borrowed capital;
T – the rate of income tax.
Preparation of reports and business plans in Word
Готовый бизнес-план можно передавать из программы прямо Word – в той валюте и на том языке (русский, английский или пользовательский), которые выбрал пользователь.
The process of creating business plans in Word, as automated as possible. In the first stage create a document in Word, marked where the exported table in the currency and language (Russian, English, or custom) that the user has selected. However, a business plan is a free report, not limited to the scope of the standards, and includes a range of materials and illustrations of the analytical text, conclusions, fragments of tables, graphs, risk analysis, contingency analysis, etc.
Revision of the business plan of the project, including arrangement of material, layout and design are the next steps, which may need much more time. However, much of the routine work on the creation of financial tables in the programme.
Preparation for planning. Transliteration
Transliteration is a special feature for rendering text tables (plans) into other languages (Russian, English and custom).
In some cases, the "transliteration" is used to set up tables in accordance with the requirements of corporate reporting. For example, the reports used the term "profit Margin" instead of "gross profit".
In the preparation of business plans, texts, tables can also be translated into any other foreign (custom) language. It may be important, for example, if a partner prefers to use statements on their own (in this case custom) language. In other words, for internal use can be one the language of the text table for external partners and investors – is another.
Example of calculation of the production plan construction of 12-storey 3-sectional residential complex
The example describes approaches to the planning of stages of construction works, the useful tips to simplify the process and improve the quality of planning.
Summary budget report is also important for the analysis of the cost structure in percentage, and in this example will be demonstrated. For example, the construction of an apartment building suggests a structure like this cost on average in Russia in 2016 (see detailed example)...
Note that the description of a business plan construction using Gantt charts and tied to it cost structure is the fastest and most effective way to develop financial spreadsheets. The reason is that with the help of Gantt chart not only describes the important stages, but almost all the construction costs, with the exception of the associated costs, not so much: the land (6 to 15 % of construction costs), credit load (about 10-15%), marketing (3-10%), the contents of the device (3-8%).
Example of capitalization of costs (included in cost of non-current assets)
To account for the capitalization of costs (assigning them to the value of non-current assets), for example, in construction projects, use of a special algorithm.
Capitalization, as reception of the regulation is that the costs that will bring income in future periods are not reflected in the statement of profit and loss and the carrying amount of the asset or liabilities side of the balance. For this reason, the capitalization of the distorted financial results, as the value of capitalized expenditure is not equal to the cost charged to expenses or costs. In business planning, this approach is not acceptable, therefore, for planning purposes and financial analysis capitalization of costs "for the implementation of stages of production" is always included in the statement of profit and loss.
Thus, in the statement of profit and loss revenue and cost should be reflected in full, including targeted funding and remuneration of the Builder.
Plan production. Create a Gantt chart or export (import) from MS Project
Gantt chart (Gantt chart) is created using the program interface, but if desired, it can be imported from MS Project. Figure transformirovalsya in the financial table of the plan the costs for implementation of stages of production.
Gantt chart (Gantt chart) is nothing but a kind of format editing and presentation of data, in addition to the common traditional graphical and tabular view of systematic data. The Gantt chart is widespread in business planning projects, most likely, the simplicity and adaptability of the planning process. In the Gantt chart, it is customary to use some specific names and terms related to network planning: the lag, the percentage complete, resource type, type restrictions, etc.
Note that the description of the business plan, for example, construction using Gantt charts and tied to it cost structure is the most efficient way to design the financial tables.
Methods of calculation of indicators of investment efficiency (PB, DPB, NPV, PI, IRR) for simple examples
In the calculation of the majority of integral indices, we use discounted cash flow. Discounted cash flow (Discounted Cash Flow, DCF) – method of evaluation used to analyze the attractiveness of certain investment opportunities. Discounted cash flow analysis (DCF) uses the estimated future free cash flows and discounts them (most often using weighted average cost of capital, WACC) to obtain their true value, to obtain adjusted estimates of the potential investment.
Discounted cash flow is calculated by the formula:
DCF = ∑ CFn (1 + r)-nГде:
CFn – the amount of cash flow for n periods;
r – the discount rate (for example, the discount rate can use weighted average cost of capital, WACC);
n – the number of periods that give rise to cash flows.
Features of the calculation of cash flows in the Budget-Plan Express
For the calculation of investment performance (PB, DPB, NPV, PI, IRR and others) used two methods for determining initial investment and net income. In the first and in the second case, you must first:
1. To net cash flow (Net Cash Flow, NCF).
2. To find the net investment (net financing requirement) using the following algorithm:
❷ In this series (cumulatively) the first negative value of a number refers to the investments.
❸ In subsequent negative amounts of some investments is only a negative growth, and after any positive amount, the account growth is interrupted – until the first negative amount, etc.
3. Find the net income. To do this, from the net cash flow (NCF) are deducted the net investment.
Further, depending on the chosen method, will be compared to the net income and initial investment where the initial investment in the first case, the net need for investment in the second – sources of funding.
Method of correcting price fluctuations
In some cases, there is a need to adjust some prices to account for the effects of external factors on price changes.
The need for adjustments may not be associated with the modeling of factors external risks. For example, the basis price forecasts were taken from the projections of the wholesale prices more volatile than prices at subsequent stages in the chain of sales.
In the first case it is possible to use a method of correcting price fluctuations, mathematically "describe" the possible influence of factors external risks. In the second case, can be a useful method of smoothing short-term fluctuations.
In the first and in the second case, the models of the moving averages.
Before you begin planning, it is recommended to read the basic materials and examples contained in online Help (the user manual), refer to the Announcements of opportunity for Budget Plan Express, sample business plans and other materials, posted on this site, this will allow you to quickly master the interface program and start to use the whole range of its capabilities.
☛ Sign up with one click, using your social network or popular services of Yandex, Google and others. In Personal account you can create (print) all the documents (invoices, contracts, acts, etc.), perform online payments, and also to send messages and use the setup files downloaded program updates. To write invoice or run online payment without registering.
See useful materials with examples and description of methods, practical planning
the Practice of planning:
sales Plan. The practice of planning. Model moving averages (SMA, WMA and EMA)