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.
Invoicing: Speaking of templates, Excel comes equipped with a wide variety of templates for invoicing services __ like laundry service for your work grubs. Create Recommendations: Whether you put it on your receipts or on your work orders, Excel's ability to add drop_down menus to a cell can make it easy for your employees to select an extra bit of maintenance that a customer's car could use. Maintain Service Histories: The same drop_down menus that power the ability to offer maintenance recommendations can be used to create standardized service histories that are easy to read and use. Work Orders: A simple Excel template will allow you to create standardized and easy_to_read work orders that can be printed, modified, and saved with ease.