DCF Specific Times family
| Discounted Cash Flow category | Home |
Calculate Discounted Cashflow Analysis on cashflows that occur at irregular times.
| Component | What the name means |
|---|---|
| PVT | Present Value of cashflows at specific Dates |
| IRRT | Internal Rate of Return of cashflows at specific times |
| PayBackT | Payback Date |
| PayBackDiscT | Discounted Payback Date |
| DurationT | Macaulay Duration |
| AvLifeT | Average Life |
| PVTIC | PVT with Investment and Capitalisation |
| IRRTIC | Internal Rate of Return of cashflows at specific times |
| PVTX | PVT Extended |
| IRRTX | Internal Rate of Return of cashflows at specific times, extended version |
| PVTCX | PVT Extended with capitalisation |
| IRRTCX | Internal Rate of Return of cashflows at specific times |
| PVTR | PV of cashflows between a FromDate and a ToDate with time-dependent Realisation balances |
| IRRTR | IRR between a FromDate and a ToDate with time-dependent Realisation balances |
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.