Excel modeling
With our extensive corporate experience, we can deliver solution for any problem that required technical or financial calculations: input tables, charts, various financial models (budgets, evaluations, startups, LBO, 3-statements), technical calculations, and many more.
Embedded programming language (VBA) helps you to go above usual Excel capabilities.
PowerQuery can perform all simple DWH and ETL tasks: connect to database, clear and transform it, add calculated columns, keep info as data model. We can create summary dashboards right in the Excel workbook, or tune-in PowerBI solution.
The startup company needed a strategic financial model to show its future cash flows. We developed a standard 3 statement model with interrelated revenue and expense calculations.
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.
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.
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 6 FTE. We got it done 3 times faster, saving the budget and being on time for the investment committee meeting.
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.
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.
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.
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.
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.
Power generation company (fossil fuel and large thermal generation) required an independent economic assessment of the feasibility of processing APG using the GTL process.
We initiate the project by clearly defining the scope of work with the client and reaching a mutual agreement on the cost associated with the project.
[Contract signing, 50% advanced payment]
Once the scope and cost are established, we sign NDA and request the client to provide us with all the necessary materials, data, and information required to commence the work.
Using the provided materials, we develop the required calculations in Excel, tailoring them to the client's specific wishes and specifications.
We present the completed calculations to the client for their review and approval. Any necessary adjustments or modifications requested by the client are implemented promptly.
After incorporating the requested adjustments, we proceed to finalize the project, ensuring all calculations meet the client's requirements and expectations. The client's final approval is sought before moving forward.
In the last step, we transfer the sources of the Excel calculations to the client, adhering to the agreed-upon method of transfer. This ensures that the client possesses the necessary resources for future use or further customization.
[Work completion signing, 50% final payment]
- min project is $6,000
- time&material contract is available
- for complex projects – MVP every 2 weeks
- min project is $6,000
Scan this QR code to start a chat (or tap it on mobile device)