You have not to click on 'Calc and Diagnostics' button. But if you have some problems you can check your source data. In this case you can try to click on this button. When you have entered your source data( IRR guess, balloon (optinally), capital, loan amount, interest rate, amortization period and so on), you automatically receive the following resulting information:
You can see calculation of cash flows for every year on the picture above ('sales' sheet). Also, you can see some financial indicators on the "Result" sheet (please see the picture below).
Additionally, you can see your loan schedule (shown only for 5 months):
If you'd like to receive the resulting data for 4 years, please see the output below.
If you'd like to receive the resulting data for 3 years, please see the output below.
This products contains the same business valuation templates for 10 years. If you wish to create your project for other number of years, please note that this product contains template generator allowing you to generate the same Excel templates for the number of years you wish (up to 100!). Template generator example sheet:<>
Another method of business valuation is based on term of EVA (Economic Value Added).
This product contains the templates for EVA&NPV business valuation for periods of 5, 10 and 15 years.