VIDEO
HIGHLIGHT
Log InSign up
Planilha de Estudo de Viabilidade Econômica em Excel
SummaryTranscriptChat

Planilha de Estudo de Viabilidade Econômica em Excel

Introduction to the Spreadsheet

In this video, we will learn about the utilization of the economic feasibility study spreadsheet. Before understanding how the spreadsheet works, it is recommended to watch the economic feasibility tutorial video available on our channel, where all the necessary concepts are explained.

Initial Project Information

  • Fill in general project information such as name, schedule, responsible person for analysis, project description, and relevant observations.
  • Example: Evaluating the creation of a new bar and restaurant in our city.

Investments

  • Detail all investments made throughout the project.
  • Separate investments into initial and additional categories.
  • Example: Initial investments include renovation, furniture and decoration, equipment purchase, company establishment costs, branding services, and visual materials.
  • Depreciate specific investments if applicable (e.g., equipment).
  • Plan for future expansion if necessary.

Costs

  • Specify fixed costs (e.g., electricity, water, payroll) and variable costs.
  • Estimate average cost per item produced or sold (e.g., $12 per item).

Gains and Taxes

  • Define project gains and tax rates applied to cash flow.
  • Consider gains from various sources (e.g., energy consumption reduction).
  • Input fictitious percentages for revenue and profit taxes.

Revenue Estimation

  • Estimate monthly revenues using different methods:
  • Average monthly revenue expectation per year.
  • Average monthly sales quantity with ticket average.
  • Monthly revenue breakdown by year.

Minimum Attractiveness Rate

  • Determine the minimum rate of return required for an economically viable project.
  • Set percentages for capital structure (own capital vs. third-party capital), cost of own capital,

cost of third-party capital,

inflation rate,

and desired profitability percentage.

Cash Flow Analysis

  • Analyze cash flows automatically calculated by the spreadsheet for up to 10 years.

Project Cash Flow Analysis

In this section, the speaker discusses how to analyze the cash flows of a project in detail. The calculations for the cash flow are automated, eliminating the need for manual calculations. The project's cash flows can be analyzed in detail, including investments, revenues, costs, taxes, depreciation, and free cash flow.

Analyzing Project Components

  • The project's components such as investments, revenues, costs, taxes, depreciation, and free cash flow can be analyzed individually.
  • The spreadsheet automatically evaluates the economic feasibility of the project.
  • The screen displays a summary of indicators such as Net Present Value (NPV), Internal Rate of Return (IRR), and Payback Period.
  • Graphs show NPV by scenario and sensitivity analysis.

Evaluation Parameters

  • The evaluation parameters can be adjusted to determine the study period and scenarios.
  • The study period can range from one to ten years.
  • Scenarios can have different percentages for investments, revenues, fixed costs, and variable costs.
  • An optimistic scenario may include additional investment needs but higher revenues.
  • A pessimistic scenario may have additional investment needs and lower monthly revenue estimates.

Indicators: NPV, IRR, Payback Period

  • Net Present Value (NPV) measures the profitability of the project above the minimum viability rate.
  • In our example scenario over three years, we have an NPV of 136 thousand reais above the minimum attractiveness rate. This indicates that undertaking this project is more profitable than leaving money in current investments.
  • Internal Rate of Return (IRR) expresses profitability as a percentage above the minimum attractiveness rate. In our example scenario, we have a 4.92% annual return above TMA (minimum attractiveness rate).
  • Payback Period represents how long it takes to recover the initial investment. In our probable scenario, it would take two years and nine months to recover the investment.

Graphs: NPV by Scenario and Sensitivity Analysis

  • The NPV by scenario graph provides a summary of the project's performance in different scenarios.
  • The sensitivity analysis helps understand how changes in components affect project profitability.
  • Our project is highly sensitive to revenue variations but less sensitive to investment, fixed costs, and variable costs.

Automated Calculations

  • The spreadsheet automates all calculations, saving time on manual calculations.
  • This method of evaluation is applicable to various types of projects, whether starting a new business, investing in an existing business, or purchasing equipment.

Consolidated Viability Report

In this section, the speaker explains the consolidated viability report of the project. This report summarizes key information and provides a complete analysis of the project's feasibility. It can be easily printed or sent via email for sharing purposes.

Key Information in the Report

  • The consolidated viability report includes essential information and a comprehensive analysis of feasibility.
  • It simplifies sharing the study with others through printing or email.

Timestamps are provided for each section based on their occurrence in the transcript.

Video description

📊 Baixe a Planilha Estudo de Viabilidade Econômica: https://resultar.com.br/produto/planilha-de-estudo-de-viabilidade-economica/?utm_source=youtube&utm_medium=planilha-viabilidade 💻 Conheça todas as planilhas profissionais Resultar: https://resultar.com.br/loja/?utm_source=youtube&utm_medium=planilha-viabilidade Optar pela realização de bons projetos de investimento pode ser o fator determinante para o sucesso do seu negócio. Vamos entender de forma prática sobre como realizar a avaliação econômica de projetos e tomar decisões assertivas de investimento. ----- Avalie a viabilidade econômica dos seus projetos e tome melhores decisões de investimento no seu negócio com a planilha Estudo de Viabilidade Econômica. Optar pela realização de bons projetos de investimento pode ser o fator determinante para o sucesso do seu negócio. Entender as vantagens, desvantagens e tomar decisões assertivas, passa pelo Estudo de Viabilidade Econômica do seu investimento. Analisar a viabilidade dos seus projetos é fundamental para evitar problemas como: - Mal dimensionamento dos custos do projeto - Falta de mensuração dos ganhos e lucratividade - Determinação incorreta dos recursos financeiros necessários - Determinação incorreta de em quanto tempo o investimento se pagará A planilha Estudo de Viabilidade permite analisar de forma prática e consistente os principais indicadores financeiros de avaliação de viabilidade econômica. Através de projeções e indicadores como VPL, TIR e PAYBACK, podemos verificar o potencial de retorno do investimento e tomarmos a melhore decisão. Os resultados da utilização da planilha de estudo de viabilidade econômica são: - Melhor registro e organização dos números do seu projeto - Análise rápida e consistente de indicadores de viabilidade econômica - Mensuração dos resultados projetados - Identificação das variáveis mais importantes para o sucesso do seu projeto - Maior embasamento para a tomada de decisão 📊 Baixe a Planilha Estudo de Viabilidade Econômica: https://resultar.com.br/produto/planilha-de-estudo-de-viabilidade-economica/?utm_source=youtube&utm_medium=planilha-viabilidade