Soon on the first tab, you should fill out the general project data, as well as financial assumptions like discount rate, SELIC, risks, etc. for up to 10 years of projection
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!
Projection of Expenses
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 spreadsheet allows you to separate costs, expenses and investments!
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!
You can view all the information in the worksheet in two control panels ready to show you general valuation and annual analyzes according to the chosen year