In the first tab, you should fill out the general project data, as well as financial assumptions such as discount rate, SELIC, risks, etc.
Just like you did with the expenses, you should design all the future revenues of this project, with that, your cash flow will be automatically created and the analysis done!
The next step in the worksheet is projecting the expenses for the following years that will be part of your projection. At this point, the worksheet allows you to separate the fixed expenses from the variables!
Using the flows generated in the statement, the worksheet will automatically calculate the main indicators: NPV, IRR, payback, perpetuity and final value of the business!
With the projections made, the spreadsheet will automatically generate all the result statement needed to achieve the attractiveness indicators. In it, you will be able to analyze EBITDA, Profit and Free Cash Flow!
Alerts and Tips
In the next tab of the worksheet, you can receive alerts about the results of your spreadsheet and also tips on how you can improve your metrics!