Template interface supports 10 languages
3 languages added by default:
Take advantage of new opportunities for organizing teamwork in Excel.
Starting with MS Office 365 (for PC), MS Office 2019 (for MAC), Microsoft realized the possibility of full-fledged teamwork in Excel.
For the organization of distributed access using Microsoft Cloud OneDrive.
When several operators work simultaneously, information about the operations they perform is visually available. There are no more conflicts and automatically created secondary copies.
Full freedom to design applicable tax solutions.
Set a flat or progressive scale, manipulate plug-in tax schemes, manage tax rates. design your schemes.
The tool allows you to make calculations in ten different currencies at once:
Now you can control the VAT by one click on the position.
For each position of the financial plan income and expenses you can One click to determine - to consider VAT or not, and set the amount of VAT.
The template will allow you to flexibly manipulate source data, manage periods, set costs in proportion to all revenues or from a particular product or service.
The template is dynamically expandable and has no limits
on the amount of input source information.
The template does not use VBA and at the same time it is easily dynamically expanded using only regular Excel features.
The calculations we have created and the logic of data interaction are expanded by using the simple “copy past” operation.
The template allows you to define your own catalog of products and services, product groups.
Set for further analysis of analytical groups for all types of income and expenses of the project.
The tool contains:
Production Cost Analysis and Cost Calculation;
Cost analysis for analytical groups;
The tool allows you to quickly build three types of forecasts:
Profit and Loss Statement (by month within the planning period);
Flow of funds (by month within the planning period);
Automatically calculated investment attractiveness indicators:
PP — Payback period;
PI — Profitability index;
IRR — Internal rate of return;
NPV — Net present value.
Automatically calculated funding requirement and size of borrowed capital;
Break-even point calculation;
Return on sales by net profit (ROS), %;
Interest coverage ratio;
For specialists, we offer the possibility of self-modification of the template code.
Excel is a tool that allows any specialist, having studied the basic functionality to create their own unique calculations, forms, graphics.
The open source code of a professional tool allows everyone to significantly reduce the time to get their unique result when planning. It is much easier to refine the functionality with a good open base.
The model works equally well on Excel for Windows and Mac.
|Computer configuration||CPU not lower than i5, not less than 4GB.||CPU i7, 8 GB RAM memory.|
|Operation system||Windows 7, 8, 10
MAC OS 10.9 Mavericks or higher
|Excel||MS Excel 2010 - 2016
MS Excel 2011-2015 for MAC