Provider of the Services Experience:

For provider’s experience details, click here: Resume 

New Businesses Financial Modeling:

The Financial Model of a green-field business comprises the accounting and financial part of a Business Plan. Projections of revenues, operating costs, and future general and administrative expenses budgets are assembled with the support of people with expertise and knowledge of the business under analysis, along with estimates of the necessary investments (fixed assets and/or intangibles). Likewise, the experts will establish reasonable hypotheses for loans and financing to leverage the business. Using the actual accounting and tax rules, we are now able to develop the financial model. The provider of the services offered, has extensive experience in modeling new businesses, especially in the area of long-term concessions, in infrastructure projects (port and airport terminals, hydroelectric power plants, toll roads, among others). Now the investors have access to their rates of return (IRR), net present value of the enterprise (NPV), minimum capital required (maximum exposure), among other indices. The model also allows sensitivity analysis, by varying the main parameters adopted. 

Running Businesses Analysis

The previous financial life of a brown-field business can be represented, in a condensed way, in its Financial Statements. The open accounts on the balance sheet project future effects on the business (e.g.: depreciation/amortization of property, plant and equipment/intangible assets, settlement of loans and financing, accounts payable, accounts receivable, among others). The history of revenues, costs and expenses also allows inferring trend curves for the future. Based on historical data and assumptions of future development, we now can develop the financial model. In the case of an M&A (merger and acquisition), the model makes it possible to assess the value of future cash flows, that is, the net value of the business (equity value). In the case of a total or partial acquisition of the business, for a given amount paid, the investor now has the information to assess its rates of return (IRR), net present value of the enterprise (NPV), minimum equity capital required (maximum exposure), among other indices.

Custom Software Development

Depending on the nature of the project, a suitable programming language may be chosen. The provider of the services offered has already developed projects in several languages, since the time of the DOS Operating System, in Basic and Dataflex. More recently, already in the Windows environment, he has been using Delphi and Python, in addition to VBA – Visual Basic for Applications.

VBA Programming (macros) for Advanced Excel

For applications that do not require a large-capacity database, Excel offers unsurpassed flexibility. With the use of macros, written in VBA – Visual Basic for Applications, beautiful user interfaces are possible, along with sophisticated data entry validation. Processing this data is relatively slow, but fast enough for most applications. It also allows the automatic generation of complex reports, both on screen and printed. Anyway, it is an extremely flexible tool for developing all types of applications, from a simple home application, for an individual user, to reasonably sophisticated applications, for corporate use. We look forward to the challenge to develop a personalized solution for your case. Try us!

As an appetizer of what is possible, click: Teaser 

Technical Translations in the field of Engineering (German and English)

Another area in which the provider of the services offered believes he can make significant contributions is the translation of technical texts, combining his knowledge of engineering, accounting, and finance, with fluency in several languages. However, the proposal is limited to translations from German or English, always to Portuguese. Translations from Portuguese into these languages would be hampered by the lack of a day to day experience, in a technical environment, in these languages.

Support in Bids for Infrastructure Concessions

Yet another area where the provider of the services offered accumulates years of experience is the analysis of bidding documents for infrastructure concessions (port and airport terminals, hydroelectric power plants, toll roads, among others). With the support of the engineering and budgeting teams of the bidding company, we propose to support the financial proposals with the respective Financial Models. The assumptions for demand growth and minimum parameters of Return on Investments (ROI), Internal Rate of Return (IRR) and Net Present Value of Cash Flow (IRR), among others, will be established together with the people responsible for the bidding process. With data from the Cost, Expenses and Capex budgets, in addition to the boundary conditions of the financing that leverages the project, it will be possible to calculate the Minimum Tariff or the Maximum Bid for the bid under analysis.

To Return, click here: English (USA)