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.