Else we can go in for the expense report template excel sheets from online services and gain a lot than by following the previous suggestion. This is due to the fact that the excel worksheet would already be ready for filling up the details, as they will have been given proper title and field names before selling. If the firm is capable of spending a small portion for the procurement of this expense report template excel sheet from good sources, then it will certainly be boon for the endeavors of the firm thereafter. Finally, by choosing the expense report template excel sheets powered with ready_made formulae for calculation, we will surely get the best from them indeed.
Also, how long is your investment horizon? Is it really that important to you to project out to 30 years or is 3λ years sufficient along with a terminal value that represents the expected NPV beyond 5 years? Usually this latter approach works best and looks the most credible to potential investors. There are numerous ways to calculate terminal value including multiples, current market values projected forward, and round guesstimates. Obviously these decisions are affected by your personal preference and the type of investment for which you're calculating present value.