The world's most_used spreadsheet shows up in such a wide variety of places that it's sometimes easy to forget just how much it can impact a business. Far beyond just tracking the bottom line, even a relatively straightforward business like an auto shop can find several uses for Microsoft Excel. Tracking the Bottom Line: Yes, it's true! You can put Excel to use by giving it your income and your outgo and having it chart your profits over time.
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.