Budget-Plan Express, a software product for financial planning, for the development and preparation of business plans and presentations, financial and investment analysis. The process of creating business plans in Word automated and preparing reports in Russian and English languages. Built-in Gantt chart allows you to quickly plan, for example, the stages of construction. The basis for the calculation of indicators of investment efficiency (PB, DPB, NPV, PI, IRR, MIRR, and others) is net cash flow (NCF). The program includes powerful tools for analysis to predict price trends we use the models moving averages (SMA, WMA and EMA). In the investment and financial analysis, universal user settings are available.
Software product Budget Plan Express (BPE) is a fundamentally new product for planning and analysis using Excel (other office applications) jointly with the object library and ActiveX controls. BPE "embedded" in the office, as his "financial" addition, and from a practical point of view, is the rapid development of plans and reports, in fact close to of financial statements, quick preparation of presentations and business plans.
With BPE, you can use the full power of the office, where now the elements of the complex planning and review, "at hand": to prepare presentations with graphics and snippets of BPE calculations, modify and independently analyze data, create schedules of any complexity independently and compose business plans, using the full exchange with Excel, Word and Project.
Before operation, we recommend that you read this section – about its possibilities. A comprehensive view of the program will help to form a holistic approach to planning, focusing on results, and simplify the process of studying the background material.
System and special requirements
The program works on Windows, but it requires pre-installation on a User's computer in any version of MS Excel (any version from 2003 and later) macro-enabled, and also the corresponding version of MS Word to prepare reports and business plans. Typically, Excel is installed with MS office.
The program was tested on Windows XP, Windows Vista, Windows 7, 8, 10.
Please note that the program comes in a 32-bit binary code, but works correctly on 32-bit and 64-bit Windows, locally.
To protect the program developed 3 commercial and one non-commercial license for partners, which is limited to a period of 180 days, with further prolongation.
Commercial Internet license "Start" and "Standard" is the most convenient for most users, as they allow to download, register the program via the Internet and immediately to start to work.
A commercial license is "Special" is designed for companies that do not use (disabled) the Internet generally are closed public and private entities with a dual purpose.
BPE can be used for the development of business plans, financial analysis and management purposes – for reporting and planning risks.
Projects can be developed from scratch or on the basis of the operating company, beginning with any month of planning.
The detailed planning period is 36 months, which is considered a standard planning horizon (recommendations IFRS), however, for the calculation of recoupment and other integral indicators, calculation period can be set – up to 15 years (180 months).
In customizing for investment parameters allow to determine the estimated net cash flow and initial investment.
The topology of the plans is divided into four subsection: "Operational plans", "Financial reports", "Special plans" and "Financial analysis", containing 14 basic plans and secondary plans (fixed plans).
For example "Financial plan" includes plans: "Credit products", "Operating and financial leases", "Reserves for future expenses", "Placed equity instruments" and "Dividends."
The program has no modifications (calculations in all licenses are unified) and adaptable to "complex" and "simple" projects, to any tax regimes - to the tax legislation of other states.
When preparing business plans, the texts of the tables can also be translated into another language: Russian, English and "user" language (not available in the "Start" license). It may be important, for example, in the preparation of presentations for the international forum, or if the partner (investor) prefers to use statements in their own language.
The program is not restricted to the framework of the Russian accounting and tax legislation, the components of settings allow you to adapt the program, reflecting the principles of IFRS.
For built-in tables (in forms editing) developed its own standards: a time scale, formats, colors, context menu, call of the graphics editor, enter the calculation formula in the cell, etc.
With custom "payment schemes" defines the payment periods for accounts receivable, accounts payable obligations and taxes for each taxpayer and the lender.
To account for the capitalization of costs, for example, in construction projects, use a special interface ("investments in non-current assets").
In BPE is used the currency of the country, which in the settings will be specified by the user (by default - ruble), and also - three any additional currencies (for use in calculations).
In the settings menu of the forecasting parameters, you can select moving averages, in accordance with the objectives of (smoothing interval, the predictive interval, the smoothing constant).
For taxes there are standard calculation algorithms used by the program. For some taxes, for example, for profit tax - customizable calculation algorithms.
Any plan or all plans, simultaneously or selectively, can be exported immediately to Excel. Then these data can be analyzed, structured, compiled for your own reports, presentations, graphs, etc.
Preparing automated reports in Word allows you to quickly prepare the calculation part of a business plan, automatically creating and filling tables in Word. Before creating reports in Word, it is recommended that you select the language (using the "translit" function) and the currency for calculating the future report (business plan).
Gantt chart can be exported to MS Project and import from MS Project.
A special procedure allows you to import directories and data for operational plans for the whole project period (36 months of the project) from files (where previously named ranges were created).
In BPE, you can distinguish two conditional levels of data calculation: preliminary and final calculations - at the level of the plan and at the project level (final calculation).
If the "Report on movement of funds" in the row "balance at end of period" are negative values, the calculation of "balance" will be interrupted to eliminate negative values.
In the calculations of performance indicators, the adjustments to the cost of equity are used: preferred and ordinary shares (stakes), reinvested profits. At the same time, the percentage (coefficient) of borrowed sources of financing is calculated automatically.
In BPE also calculated deferred taxes and IFRS 12 are reflected in the financial statements as a separate line.
The basis of planning based on the principles of IFRS and the priority of applying the rules of IFRS when the impossibility of harmonization of accounting rules.
If you plan to work with a large number of projects, create a standard "starter" projects to reduce development time of new.
The Gantt chart is used for discrete models, for example - for the construction plan, in the second stage, based on the data from the Gantt chart, the "Production plan" is calculated.
Specify in the "general settings" data depreciation rates, they can later be used in non-linear depreciation in tax accounting.
Financial analysis includes the most commonly used groups of indicators: Liquidity Ratios, Debt ratios, Profitability ratios, Asset management ratios and Market value ratios.
In the settings (the "Financial analysis" tab), you can set the parameters of the normative values of financial and economic indicators, for example, according to industry standards.
The program calculates all the main indicators of investment efficiency: PB, DPB, NPV, PI, IRR, ARR, MIRR, and other indicators based on the data calculated in the program.
Most software products define initial investments - as a schedule for the need for working capital and other assets. In Budget-Plan Express, you can choose any of 2 ways to determine the initial investment, depending on the user settings.
Net cash flow, which is the basis for the calculation of integral indicators may be adjusted: subject to the effect of cash equivalents, interest on loans, dividends and other highly liquid assets.
Settings allow you to define the initial investment – as the need for working capital and other assets (absolute need for financing) and directly used sources of funding.
For the present value of the net investment, you can specify in the settings a discount method "postnumerando" (default) or "prenemerando".
To reduce the influence of discounting on the initial investment, set in the settings step of discounting. The impact of discounting in this case will increase gradually from month to month. Or set the option: "Assume an initial investment: the need for funding (not discounted 1st year)"
If the initial investment is made before the beginning of the month of calculation (the index of the month specified in the settings), they, along with other cash flows, are not discounted (see the NPV calculation example).
Modeling of cash flows
The funds generated in the "sales Plan", modelled in the cash flows of the "inflow of money" using the algorithm of separation of cash flow – "accruals" and "payment".
The algorithm of separation of cash flow models relative to the "real" cash flows, determining the payment periods for each payment group.
The calculation algorithm checks the "payment schemes" and determines the payment periods for each payment group. "Payment patterns" for each month can contain their own calculation algorithm. After the payment schemes are configured, these schemes need to be "tied" to a particular product.
Taxes and other payments
In BPE presents the main taxes: profit tax, VAT, single tax, property tax, sales tax and payments to pension and other funds.
The tax calculations and other calculations can be performed starting from the selected (User) period. The subsequent period can be set a different tax rate.
The paid taxes can be adjusted in several ways – a reversal in the PAD or in the "table adjustments", then it is necessary to rerun the final calculation.
"Mathematics" of price trend adjustments
To account for the effects of external factors on price changes in the BPE adjustments price fluctuations, mathematically "describe" the possible influence of factors external risks.
When forecasts of wholesale prices more volatile than prices at subsequent stages in the chain of sales can be a useful method of smoothing short-term fluctuations using the model of moving averages.
In BPE, the three most commonly used moving average models and their modifications are used: simple moving average - SMA, weighted moving average - WMA and exponentially weighted moving average - EMA (EWMA).
Method for correcting the fluctuations of the prices (adjusted for seasonal variations, seasonal adjustment) is used for adjustments, unexpected price spikes associated with sharp changes in external factors.
To identify spikes (forecast trend) is used the standard deviation (a measure of the dispersion of values of a random variable about its expectation) from the moving average.
Correction of price fluctuations for a certain period, using the standard deviation, allows you to "react" to jumps in trend fluctuations and "ignore" trend changes within the standard deviation.
Trends and estimated currency
In addition to the main currency, you can also specify three any "calculated" currencies (by default - Dollar, Euro and Yuan), which indicate the trend of rates to the main currency.
"Calculated" currencies is used in two cases: to prepare business plans in Word (the conversion table in the specified currency) and for adjustments to settlement prices (sales and purchases), if price fluctuations dependent on the fluctuations of currencies.
Foreign currency loans and other financial receipts and payments are translated into the main currency. The costs incurred or the profit received are accounted for as "Other non-operating expenses or revenues".
In place with the trends of the currencies you can create additional predictive trends, by analogy with the currency trends, adjustments to settlement prices (sales and purchases), if price fluctuations dependent on the fluctuations of the trend values.
Optional planning tools
Here you can easily model the credit (leasing) products of any complexity, to choose the optimum scheme of financing, for example, when address shortages of cash or "cash gaps".
Information about assets is displayed in the actualized (past) and in the future period. Here you can plan all stages that reflect the impact of assets on investment activities, including: revaluation, modernization, the formation of residual value and deferred taxes, etc.
The break-even analysis methodology allows the company to decide on how many products must be produced and sold in order to fully cover its fixed and variable costs. To clarify the fixed costs in the composition of products, the ABC-method (Activity Based Costing) of the separation of indirect (fixed) costs associated with the production of a particular product is applied.
When part of the contract can be deferred, transferred to other tax periods, for these cases, you can model the allocation of costs for inventories, followed by write-offs for costs. In other cases, when costs increase the value of an asset for several months (for example, in construction projects), here they can be capitalized by including them in the value of this asset - before putting the facility into operation.
☛ Register in the Personal Cabinet (recommended!), where it is possible to create (print) all the documents (invoices, contracts, acts, etc.), and also to send messages and use the setup files downloaded program updates.
Register with one click, using your social network or popular services Yandex, Google and others.