The Microsoft office software package contains one of the most sophisticated pieces of software protocols, capable of giving us the opportunity of filling in details in terms of the specific columns and rows given in it. This wonder among wonders is called the Excel worksheet. The endless virtues of this protocol in providing help to others extend its hand to the field of business as well in the form of document templates primarily. The documents made from the use of excel sheets will be neat, simple, easy to fill and so on, thereby reducing the workload of employees using them in half. They save them from a great deal of pain and overtime hours 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.