Budget-Plan Express is 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 is automated and prepares reports in Russian and English. Built-in Gantt chart allows you to quickly plan, for example, the stages of construction. The basis for calculating investment performance indicators (PB, DPB, NPV, PI, IRR, MIRR and others) is net cash flow (NCF). The program has powerful tools for analysis, forecasting of price trends using moving average models (SMA, WMA and EMA), in the investment and coefficient analysis, universal user settings are available.
It is recommended to start the work with the program from downloading the demo version (pre-register) and viewing the methodological materials. In the demo version of the program, you will find two examples of calculating a business plan: an example of a 12-storey residential complex project (a discrete model) and a project for the production of cheeses and cheese products using mini-plants and specialized modules (cyclic model).
☛ Register in the Personal Area (recommended!), Where you can create (print) the entire package of documents (accounts, contracts, acts, etc.), as well as send messages and download installation and update files.
Sign up with one click using your social network or popular services of Yandex, Google and others.
On November 1, 2018, a new version of Budget-Plan Express (a software product for financial planning, analysis and preparation of business plans) was released.
The updated version accelerated the work of some procedures, the functions for creating reference books and the module of the Gant chart were also optimized.
Download and install Update on the old version can not be!
This time the update affected not only libraries, but also project files. Therefore, unfortunately, the old projects in the new version can not be used! That is, in the new version you can work only with new projects. Accordingly, from November 1, 2018, updating of old versions is not supported.
Users of the program
To compensate for the inconvenience associated with the inability to use Update for old versions of the program, all users will be able to download and install free new versions from their personal account. Information on downloading the working version of the program (logins, passwords for registering a license) Users will receive an additional message.
The user can use the full power of MS Office - prepare presentations using the fragments of the Program calculations, modify and independently analyze the data, create graphics of any complexity and independently compose business plans. While many export-import operations are automated for key office applications (Excel, Word, Project). What makes Budget-Plan Express a natural addition to MS office.
On the practical side, it is the rapid development of plans, according to the IFRS standards, close to the financial statements, and - rapid preparation of reports and business plans. Ease of using the program for planning, allows you to resort to it more often for business analysis, and of course, in order to prepare a reasoned analysis and business plans for creditors and investors.
Budget-Plan Express is not just one of the few such large-scale add-ins COM, but also a management system for additional databases, built-in tables and other tools. This is a fundamentally new product that uses the Excel spreadsheet (other applications) as an object library container and ActiveX controls.
Below are announced some features of the Program. It is recommended to read this section , since a comprehensive view of the program will help to form a holistic approach to planning, results-oriented.
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.