|Introduction: The DCF Specific Times family is the most versatile of the NPV families and therefore is highly useful. The basic inputs of these functions are Cashflows and Dates.|
- Excel provides two functions that help in this area, XIRR and XNPV. If your problem is sufficiently simple, these functions are very useful, and fast.
- Where the DCF Specific Times family really helps is in the extra functionality provided by the various options.
- The two basic functions are PVT and IRRT. úPVT allows you to specify a particular NPVDate.
- These functions also allow you to specify DayCount and Periods, so that you can closely control the method by which the time difference between the cash flow date and the NPV date is determined. This is useful: Excels XNPV assumes ACT/365 - if you need something different then PVT is the answer.