Training - Financial Modeling with Excel

Analítica

General objectives:

The training will provide the participant with a complete understanding of how to build a financial model for decision making from start to finish. The models developed will include revenues, operating costs, maintenance costs, fixed and variable expenses, investments, depreciation, financing and taxation expenses, capital costs, loans, among other variables. As a result, we will have an integrated model of financial projections for an industrial company. The model developed will be fully dynamic with the possibility of creating various scenarios and adjusting deadlines for specific events;
During the training, participants will also have an insight on how to create the analysis reports for the end users, as well as interpret the results through sensitivity analysis, in addition to running tests to reduce the incidence of modeling errors;
The training will use experienced approaches and concepts from national and international authors;
Through the techniques discussed we will produce models that are flexible, robust, transparent and easy to handle for end users.


Specific objectives:

The training will provide the participant with a complete understanding of how to build a financial model for decision making from start to finish. The models developed will include revenues, operating costs, maintenance costs, fixed and variable expenses, investments, depreciation, financing and taxation expenses, capital costs, loans, among other variables. As a result, we will have an integrated model of financial projections for an industrial company. The model developed will be fully dynamic with the possibility of creating various scenarios and adjusting deadlines for specific events.


Who is it for:

Executives from financial institutions, executives from companies working in the areas of corporate finance, investment and controllership, consultants who want to improve themselves in the areas of company valuation and mergers and acquisitions, as well as presidents, directors and executives who are participating in processes of buying or selling a company and need to go deeper into this methodology.


Methodology:

The course is fully interactive, consisting of a mixture of theory, group discussions, slideshow, Excel-based exercises.
Participants will be provided with the training handout, a guide covering key Excel formulas, instructions for modeling exercises and exercise solution files. These will be used during the course and will serve as reference material for participants.


Complete program:

Part 1: Modeling Basics

  • What do financial models do and the risks associated with financial modeling.

  • The different approaches to building models and the benefits they bring to the final result.

Part 2: Structure

  • Template design.

  • The general process of developing a model and the items needed to develop it.

  • Layouts, structure and flows of a suitable financial model.

  • Adopting a model approach to ensure consistency across model sheets.

  • Using 'control accounts' as an essential foundation for model calculations.

Part 3: Weather Related Components

  • Define the timing of the model in order to allow for the flexibility of specific events and periods.

  • Define percentage references for events that may occur in the middle of previously defined periods

  • Overlaying calculated forecasts with actual data or forecast information.

Part 4: Entries

  • Assumptions, sensitivities and scenarios to be defined.

  • Alternative layouts for model inputs and scenarios.

  • Using range names and data validation to increase model robustness and improve user interface.

  • Creating one and two variable data tables to assess the potential impact of various hypotheses relating to the model's key measures.

Part 5: Calculations

  • Fixed Assets and Depreciation:

    • The different forms of capital expenditure related to different asset classes.;

    • Depreciation methodologies including the standard method used in Brazil.

  • Modeling of operations:

    • Generation of revenue forecasts, operating and maintenance costs and working capital;

    • Using indexing factors based on different cash flow timing assumptions to convert real to nominal cash flows.

  • Debt and equity financing:

    • Modeling different approaches to meet the model's funding needs;

    • Costs related to debt financing, such as interest, commissions, expenses and fees;

    • Different debt repayment methods, including annuity, linear, punctual and others;

    • Search alternatives for capital supply, such as capital contribution, debentures, bridge loans, among others;

    • Limiting factors to the distribution of dividends, such as accounting restrictions and restrictions imposed by creditors.

  • Taxation:

    • Different approaches to corporate tax modeling, considering state, federal and municipal taxes, considering possible profit and loss adjustments, among others;

    • Other taxes and fees withheld or not at source.

Part 6: Exits

  • Integrated financial statements:

  • The importance of integrated financial statements and how to configure them;

  • Projected Balance Sheet;

  • Income Statement for the Projected Year;

  • Cash Flow Projected by the direct and indirect model;

  • Calculating the IRR and NPV of cash flow;

  • Using matrices for analysis of results;

  • Other essential output measures, such as financial, industrial, commercial, profitability, indebtedness, liquidity, and other KPI's important to the model;

  • Creating custom graphics.

 

Part 7: Implementation and Use

  • Using the template:

    • Creating dashboards, hyperlinks and content pages to facilitate use and navigation around the model;

    • Interpretation of model outputs and monitoring of key measures such as KPIs;

    • Perform stress tests on a model based on previously defined sensitivities and scenarios.

    • Model review and testing:

    • Using a control sheet to automatically detect and identify potential modeling errors quickly;

    • Common modeling errors, including tips on how to spot them.

Part 8: Others

  • Dealing with circular cells:

    • Why circular references are bad;

    • Typical circular references in financial models;

    • Methods to get around circular cells, including implementing 'copy and paste' macros;

    • Workbook protection, printing, versioning and project management.

 

Credit hours: 16h class

Investment, deadline and application procedures

Possibility of installments in up to 6 installments on the credit card

Progressive discount for:

  • 1 registration = 10%

  • 2 registrations = 15%

  • 3 registrations = 20%

Progressive discount for:


1 registration = 10%

2 registrations = 15%

3 registrations = 20%

 

The registration fee includes:

  • printed handout and worksheets;

  • Valini & Associates Certificate.

  • Check out the payment facilities for our events. Boleto, Credit Card up to 06 interest-free installments, or Deposit to Account.

If you prefer, request an In-Company proposal with the benefits of adapting training to your company's reality!