Field | Used For |
---|---|
Inception Date | Calculating ITD returns. You can store multiple inception dates, for example fund, manager, and performance dates. |
Front End Load | Calculating front-end load adjusted returns. Stored as percentages in entity fields by year. |
Fiscal year end | Calculating returns from fiscal year to date. See the following figure. |
CDSC loads | Calculating back-end load adjusted returns. Stored as percent (such as 5.00) in entity fields by year. |
Benchmark | Performance Comparison. |
It also may be helpful to maintain additional data about the fund such as:
- Open or closed end fund indicator
- Daily or periodic dividends
- Daily or monthly pricing
- Reinvestment date assumption (month end, specific date)
- Income spreading method (forwards, backwards, split month/year end)
These fields might be required to automate the creation of the NAV related data for each fund.