Project Assumptions
On the first tab, you should fill out the general project data, as well as some financial assumptions like discount rate, risks, etc. for up to 10 years of the projection
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!
Revenue 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!
Attractiveness Indicators
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!
Valuation
With the projections made, the spreadsheet will automatically generate all the result statements needed to achieve the attractiveness indicators. In it, you will be able to analyze EBITDA, Profit, and Free Cash Flow!
Dashboards
You can view all the information of the worksheet in two control panels ready to show you the general valuation and some analysis according to the chosen year
Valuation Excel Spreadsheet Template
We want to make sure that you have a good experience trying our templates
Please, if you have any problems or questions, don’t hesitate to contact us through:
Freedom to test and share it with your team
Templates that you make more productive in any task
You can stop your subscription at any time. No questions asked.