Support

 
Technical support is provided by our consultants at the addresses:
[email protected]

 +7 (926) 203-47-82

Help file "Enterprise Financial Model" (pdf) download
Help file "EFM (calculations checking)" (pdf) download

FAQ related to "Enterprise Financial Model" installation
FAQ related to "Enterprise Financial Model" operation

 


FAQ related to "Enterprise Financial Model" installation
 

 

How to install this software on Windows Vista?

 

Answer:
When installing the software on Windows Vista it is NOT recommended to specify Windows system folders (for example, to select folder: "C:\Program Files\EFM" or "C:\Windows\EFM" for installation) in dialog box "Installation folder" of installation module. We strongly recommend installing the software in folder set "on default".

 

When starting the software neither button in tool bar is active.

 

Answer:
Before using the software you should decrease protection of Microsoft Excel macros to medium or low level.

Configuration in Microsoft Excel 2003 Before starting the software run Microsoft Excel, select in menu: "Tools" > "Macro" > "Security" and set the required level of protection ("Medium" or "Low").

Configuration in Microsoft Excel 2007 Before starting the software run Microsoft Excel, open the main menu and select: "Excel Options" > "Trust Center" > "Trust Center Settings..." > "Macro Settings..." > "Enable all macros...". Then close Microsoft Excel and start the software

 

File setupEFM.exe downloaded from your website can not run on my computer!

 

Answer:
In many companies it is customary to set restrictions in the Operating system which do not allow employees to install any applications without permission of the System Administrator. For installation do the following operations: call an employee of the Department who is in charge of PC operation and install the application with "Administer access rights" (if you have the keycode then you can register the software at once).

 

Is it possible to transfer calculated projects to other computers?

 

Answer:
Any file of EFM software can be transferred to another computer. After starting on a new PC the software will run in "Demo-version" and in this case some functions will be disabled. If a registered version of EFM software is installed on the PC then it is possible to run the software on it without any restrictions.

  "Print Reports" module does not work. Project data cannot be transferred.
 

Answer:
To provide operation of "Print Reports" module you should configure your Antivirus programs to work with "Print Reports" application. Antivirus programs may consider this application as "Dangerous Software" and inactivate the connection due to the fact that the software has to address another Excel file to print results of calculations performed by user (for data transfer). Use relevant User guide to configure Antivirus programs. Finally you should enter "Print Reports" module on the list of programs permitted to address other files.


FAQ related to "Enterprise Financial Model" operation
 

  Help file shows significantly more total line and data than the software does. Why?
 

Answer:
Enterprise Financial Model software offers the possibility of unfolding and folding of results for both tables in whole and individual types of products, expenses, investments or loans. Table entry underlining or "Up-arrow" or "Down-arrow" symbols feature that data can be represented in generalized / detailed view

  Is it possible to delete several items of products / expenses at once?
 

Answer:
There is such option in version 3.1. For this purpose select items which you want to delete and press "Delete entry" button on the software toolbar.

  How to consider price changes in time for each type of product?
 

Answer:
In version 3.1 it can be done using trends: 1. Click "Settings" button on the software toolbar. 2. On "Others" property page select items "Additional trends (Sales Plan)". 3. Press OK button to save changes. 4. In "Sales plan" table double-click on any product number. 5. Lines under selected type of products will be unfolded. Price change in time is set in line "Unit sales price trend (%)".

  Why project calculation results by years do not coincide with calculation results by months?
 

Answer:
The following concept is applied in this software: when selecting option of background data entry by years in "Period data" section all data entered by user are uniformly distributed by months in hidden columns of the software.

For example:
1. If user performs project calculation by months and adds a new position of investment expenditures (for example "Equipment") in the amount of 1200 rub. in January, then depreciation of equipment will begin from March (in the month following the first month of equipment commissioning).

2. If user performs calculation by years and enters investment expenditures equal to 1 200 rub. in the first year, then depreciation of equipment will begin from February of the following year only. This is due to the fact that the software will distribute investment expenditures automatically by 1200 rub./12 months = 100 rub. per month during the first year. Thus, the last investment in equipment will be performed in December of the first year and depreciation of equipment will begin from February of the following year only.

 
Calculations under Contract for Services Rendered will be executed according to the following scheme: 5% will be paid 30 days prior to execution of works (prepayment); 95% will be paid 30 days after execution of works (delay). How to specify such payments in the software?
 

Answer:
For this purpose enter two types of products in "Sales Plan" table: the first type - "Advance Purchase Contract", the second type - "Contract for Purchases on credit". Set price in both types of products equal to 1. Enter the amount of services rendered and set terms of payment (Advance purchases / Purchases on credit, % and number of days) in the respective periods.

  How to consider inflation in the course of calculations?
 

Answer:
Units sales price trends should be used for consideration of changes in product prices and expenses.

  How to account non-typical accrual of depreciation in the software calculations?
 

Answer:
For this purpose open "Financial parameters" table and select manual mode of calculation "Depreciation". Then enter accumulated depreciation within the respective periods.

  How to account non-typical assessment and repayment of taxes in the software calculations?
 

Answer:
1. Accounting of income tax, social or property tax open "Financial parameters" table and select manual mode of calculation against respective tax. Then using keyboard enter assessed amount of taxes in respective period (or calculate it using formulas). In this case payments by each type of taxes will be made with regularity selected in "Settings" window.

2. Accounting of other taxes The software allows accounting any specific taxes in calculations (for example: Land Tax, Transport Tax etc.). For this purpose open "Financial parameters" table, enter assessed amount of taxes in line "Other taxes (accrued)", and enter amount of paid taxes in line "Other taxes (paid)".

Note In cases when more than one "other" tax is present in calculations it is necessary to calculate each assessment and payment (for example using user's work space) and then summarize obtained results in lines "Other taxes (accrued)" and "Other taxes (paid)".

  How to account variable personnel cost in calculations?
 

Answer:
See examples of variable personnel cost calculation in help file of the software.

  How to transfer entered data quickly to the next period?
 

Answer:
Select cell with data which should be transfer to the next periods. Then click the right mouse button and in appeared menu select "EFM: Copy to future periods (ALT+S)". As a result the background data of selected cell will be automatically transferred to the next periods of calculations.

  Is it possible to add new name of products / expenses not at the end of the table but between selected cells?
 

Answer:
There is no such option in this software version.

  Where can I send my remarks/proposals related to the software operation?
 

Answer:
We appreciate users who actively participate in adaptation of the software. You are kindly requested to send all your remarks and proposals to our consultants: