The economic management of the company-excel file v. 1.01 - Online

The file, in excel format Online, it is designed for the control of economic management corporate and the dynamic forecast of the financial results of the year. It helps improve corporate profits.

It works only Online.

The price indicated refers to the annual user's license, non-assignable and non-exclusive of the product for 1 user. 

More details

144,00 € tax excl.

More info

THE ECONOMIC MANAGEMENT OF THE COMPANY

The document consists of the following worksheets:

- 1 sheet contains links linking to other sheets;

- 1 sheet contains the instructions for use;

- 1 sheet contains the calculation, monitoring and forecasting economic results of the company;

The images shown below are only indicative and are only partially functioning of the worksheet.

Picture 1 demo - The economic management company 

The worksheet can be used, alternatively, to monitor the contribution margins of products sold or the contribution margin of product families, or the contribution margins of each seller with respect to the products sold by him.

Economic analyzes should, therefore, be related to individual homogeneous categories.

The worksheet, as well as being offered, is designed to handle up to 130 products.

The user must enter in the worksheet accounting data taken from the budget of the previous year and  the actual accounting data of current period.

Of course, the designation of the items of cost and revenue can be modified and renamed by the user depending on the structure of your chart of accounts in the general ledger.

Then, you must take care to insert the cumulative turnover of the current period for each product or family of products or agent. 

Entering, then, the other information requested in the file, the user can get an overview of the economic business of the current period and a projection of the company's operating results as of December 31 or June 30 depending on the year end .

The worksheet can be easily adapted also to companies close their financial year on 30 June.

The worksheet allows carry out the management control of the company  and to simulate the economic results at the end of the year, acting on the fixed costs and variables or on the contribution margins in order to obtain a point of budget balance always lower.

Of course, the changes will translate into goals to be achieved, and these, devranno be monitored continuously.

Picture no. 2 demo - The management of the break even point

This part of the file highlights, on the one hand, the fixed cost incurred by the company and the net contribution margin achieved in the interim period considered; on the other hand, shows the fixed costs and the contribution margin expected until the end of the year.

For both periods, the system will highlight the revenue that the company will have to make to achieve a balanced budget.

In addition, beyond the economic forecast period, the worksheet, as it is set, it allows the user to do simulations of break even point arbitrarily changing some parameters.

Reviews

Grade 
03/01/2017

La gestione economica aziendale online

Ottimo prodotto da gestire anche on line con un solo link collegato ad internet.
Non occorre avere Office. Excel è gestito online e i vantaggi sono evidenti..

    Write your review!

    Write a review

    The economic management of the company-excel file v. 1.01 - Online

    The economic management of the company-excel file v. 1.01 - Online

    The file, in excel format Online, it is designed for the control of economic management corporate and the dynamic forecast of the financial results of the year. It helps improve corporate profits.

    It works only Online.

    The price indicated refers to the annual user's license, non-assignable and non-exclusive of the product for 1 user.