Services
:Financial Modeling
About
About
We provide almost any type of development in MS Excel for various business requirements. We work with skilled analysts and developers to provide you with the best technical solutions (forms, templates, tables, models, add-ins, etc.). We have in-depth knowledge of mining industry needs and bring in talented engineers when needed.
We also provide audit services (logic and calculation verification) of existing calculations/models.
You can write us
You can write us
or use the form below. Usually, we respond within 24 hours.
Our services
Custom Exсel development
We solve any tasks that require technical or financial calculations: templates for calculations, complex graphs, various financial models (budgets, estimates, LBOs, 3-statements), technical calculations and much more. We help companies to develop user-friendly templates, optimize the structure, making all Excel files more user-friendly and professional looking.
VBA programming and Database solutions
We can use the built-in programming language (VBA) to help you go beyond Excel's normal capabilities. We can also use PowerQuery to perform all simple DWH and ETL tasks: connect to a database, clean and transform it, add calculated columns, and save information as a data model. We can create summary dashboards directly in an Excel workbook or customize the PowerBI solution.
Completed projects
Processing plant comparison
Following a successful Mine Comparison (see next project), we were asked to undertake the same comparison for existing and planned processing plants. The project company had previously been asked to make such a comparison, but without success. Given the complexity and heterogeneity of the processing operations, we developed an equipment-based template that allowed us to highlight the key factors for each processing operation. The final file was submitted to the technical deparatment for further analysis.
Mine comparison
The management of a mining company is puzzled by the results of an engineering project and wants to compare the resulting design data with data from two operating open pits. We developed templates to fill in for all types of operations and based on the information obtained, we made a comparison, highlighting the main insights, developing recommendations to improve cost allocation, and compiling a list of questions for the next steps.
Update model with advanced scenarios
A previous employer has asked for help in updating the model. Their technical department had developed several scenarios over the past years and now needed to evaluate the attractiveness of each option. The head office investment department estimated the labor intensity of the work at 9 FTE. We got it done 3 times faster, saving the budget and being on time for the investment committee meeting.
Project fuel calculations
A remote mine with seasonal logistics (winter road) needed to determine the optimal volume of fuel storage tanks. New expansion projects were planned for the next few years, and management wanted to make sure the facility would not run out of fuel. The challenge was to gather all the information on current and future projects, balance winter road deliveries, fuel balances at the beginning and end of the season and develop scenarios to find the optimal solution.
Cash deposit optimization
The treasury department of a mid-sized mining company allocates its free cash to bank deposits with maturities of up to 90 days. The CFO asked us to build a tool to find the optimal allocation among multiple banks based on cash inflows and outflows, bank interest rates, and deposit maturities.
Advanced production calculation
A mining company asked for help in developing a financial model. The company had all the necessary technical calculations (pre-feasibility study), price and cost data, but did not have a unified model linking production and economics. Plus there was no certainty in the capital costing. We developed a model, including the ability to dynamically calculate the amount of equipment required depending on changes in the production pattern.
Weekly report mockup
The management of a remote mine asked for an improved report that reported key performance indicators to headquarters on a weekly basis. Excel calculations (based on dummy numbers) were developed as a prototype for a possible BI system design.
Best-case scenario for local powerhouse expansion
The mine is powered by its own power plant with diesel generators. Management was concerned that the power supply could become a bottleneck for future expansion of production. Past outages were also a problem, as the backup generators could not replace the main set. Mine specialists could not make the case for purchasing new generators. We developed detailed production calculations taking into account planned maintenance and expected load growth, presenting several scenarios with economic evaluation.
About
About
We provide almost any type of development in MS Excel for various business requirements. We work with skilled analysts and developers to provide you with the best technical solutions (forms, templates, tables, models, add-ins, etc.). We have in-depth knowledge of mining industry needs and bring in talented engineers when needed.
We also provide audit services (logic and calculation verification) of existing calculations/models.
Our services
Custom Exсel development
We solve any tasks that require technical or financial calculations: templates for calculations, complex graphs, various financial models (budgets, estimates, LBOs, 3-statements), technical calculations and much more. We help companies to develop user-friendly templates, optimize the structure, making all Excel files more user-friendly and professional looking.
VBA programming and Database solutions
We can use the built-in programming language (VBA) to help you go beyond Excel's normal capabilities. We can also use PowerQuery to perform all simple DWH and ETL tasks: connect to a database, clean and transform it, add calculated columns, and save information as a data model. We can create summary dashboards directly in an Excel workbook or customize the PowerBI solution.
Completed projects
Processing plant comparison
Following a successful Mine Comparison (see next project), we were asked to undertake the same comparison for existing and planned processing plants. The project company had previously been asked to make such a comparison, but without success. Given the complexity and heterogeneity of the processing operations, we developed an equipment-based template that allowed us to highlight the key factors for each processing operation. The final file was submitted to the technical deparatment for further analysis.
Mine comparison
The management of a mining company is puzzled by the results of an engineering project and wants to compare the resulting design data with data from two operating open pits. We developed templates to fill in for all types of operations and based on the information obtained, we made a comparison, highlighting the main insights, developing recommendations to improve cost allocation, and compiling a list of questions for the next steps.
Update model with advanced scenarios
A previous employer has asked for help in updating the model. Their technical department had developed several scenarios over the past years and now needed to evaluate the attractiveness of each option. The head office investment department estimated the labor intensity of the work at 9 FTE. We got it done 3 times faster, saving the budget and being on time for the investment committee meeting.
Project fuel calculations
A remote mine with seasonal logistics (winter road) needed to determine the optimal volume of fuel storage tanks. New expansion projects were planned for the next few years, and management wanted to make sure the facility would not run out of fuel. The challenge was to gather all the information on current and future projects, balance winter road deliveries, fuel balances at the beginning and end of the season and develop scenarios to find the optimal solution.
Cash deposit optimization
The treasury department of a mid-sized mining company allocates its free cash to bank deposits with maturities of up to 90 days. The CFO asked us to build a tool to find the optimal allocation among multiple banks based on cash inflows and outflows, bank interest rates, and deposit maturities.
Advanced production calculation
A mining company asked for help in developing a financial model. The company had all the necessary technical calculations (pre-feasibility study), price and cost data, but did not have a unified model linking production and economics. Plus there was no certainty in the capital costing. We developed a model, including the ability to dynamically calculate the amount of equipment required depending on changes in the production pattern.
Weekly report mockup
The management of a remote mine asked for an improved report that reported key performance indicators to headquarters on a weekly basis. Excel calculations (based on dummy numbers) were developed as a prototype for a possible BI system design.
Best-case scenario for local powerhouse expansion
The mine is powered by its own power plant with diesel generators. Management was concerned that the power supply could become a bottleneck for future expansion of production. Past outages were also a problem, as the backup generators could not replace the main set. Mine specialists could not make the case for purchasing new generators. We developed detailed production calculations taking into account planned maintenance and expected load growth, presenting several scenarios with economic evaluation.
You can write us
You can write us
or use the form below. Usually, we respond within 24 hours.