€ 157.00 (IVA esclusa)
The model, developed as an application of the excel spreadsheet (Excel 97-2003 version and successive versions), permits the quantification of company operating capital through the use of the most diffused methods of evaluation presently in use (Simple Income Method, Mixed Equity-Income Method, Discounted Cash Flow Method, Market Multiples Methods).
The standard model was developed by the Studio Simone and commercialized with the text “Company Appraisal – Operating techniques for value measurement” edited by Ipsoa Gruppo Wki.
Herein the user given the possibility to proceed to the implementation both of a version of the model provided with protection and with an “unprotected” version. The “unprotected” version, that is without a password of protection, allows each user to freely view all of the formulas contained in it, also placing at the disposition of the user a flexible model to be adapted to his individual needs.
Through the service under consideration, the Study, besides providing the predisposition of the standard version of the model, will offer all the assistance and support necessary for the utilization of the model by furnishing a detailed operating guide and an on line support system in the case of specific utilization problems encountered by the user.
Description
The standard model operates automatically through pre-entered connections and formulas. The only effort required is to input the comprehensive data regarding the budget histories, the forecast hypotheses, the appraisal parameters of the company to be evaluated and other additional data eventually requested. Once the required data has been input, the model will automatically and immediately offer the results emerging from the application of the different assessment methodologies employed.
Phase 1 – Reclassification of the budgetary values
In this phase the user will have to proceed to the reclassification of the budgetary values for the last 3 fiscal years available according to proposed reclassification charts.
Phase 2 – Definition of forecast variables
The user must proceed to the predisposition of the forecast scenarios (Operating Statement, Balance Sheet Statement and Financial Statement) through the imputation of each of a series of forecast variables of various natures (growth rate for turnover and operating costs, tangible and non-tangible investments, amortization period, average income of financial activities, cost of money, tax rate, dividends distributed, etc.).
Phase 3 – Definition of parameters of appraisal
Once the budgets histories are reclassified and the prospective scenarios are constructed, the user must, firstly, identify the chosen appraisal criterion or criteria. Then, a series of required parameters must be entered according to the chosen appraisal method (discount rate, multiples to apply, parameters for calculating the W.a.c.c., etc).
Phase 4 – Determination of the equity value and reading of the results
The user will enter each chart relating to the chosen assessment criteria and it will be possible to view and comment on the results emerging from the application of the criteria utilized.
The version of the model not protected by a password will allow the individual user, firstly, to freely view all the formulas contained within it; secondly, it will permit the user to have at his disposition a flexible model to adapt to his individual needs.
