2.48 Fund Estimated Cash Forecast Report

This topic provides information on Fund Estimated Cash Forecast Report and its tags in messages.

Fund Estimated Cash Forecast Report

The Fund Estimated Cash Forecast Report message is sent by a report provider to a report user.

This message is used to provide an estimate of the cash incomings and outgoings per investment fund. This message can be used to report on several investment funds. The cash incomings and outgoings result from, for example, redemption, subscription, switch transactions or dividends.

Contents of Report

The following are the contents of this report:
  • Transactions
  • Dividends

Transactions

All unalloted transactions that are newly captured or reversed and where the maker date of the original transaction is not the same as maker date of the reversed transaction and original transaction is allocated, will be picked up.

Table 2-153 Transactions Types and Reports

Transactions Types Reports
IPO / Subscription
  • Sum IPO by Amount
  • Sum Subscriptions by Amount
  • Sum IPO by Units * Latest NAV
  • Sum Subscriptions by Units * Latest NAV
Redemptions
  • Sum Redemptions by Amount
  • Sum Redemptions by Units * Latest NAV
Switch In
  • Sum Switch transactions by Amount where fund passed is the Switch In fund and convert this amount to FBC of the Switch In fund.
  • Sum Switch transactions by Units where fund passed is the Switch In fund * Latest NAV of the Switch Out fund converted to FBC of the Switch In fund
Switch Out
  • Sum Switch transactions by Amount where fund passed is the Switch Out fund.
  • Sum Switch transactions by Units * Latest NAV of the Switch Out fund
IPO / Subscription – Reversal

Sum Gross Amount In FBC of the original transaction

Redemption – Reversal

Sum Net Amount in FBC of the original transaction

Switch In – Reversal

Sum Switched In Amount of the original transaction where fund passed is the Switch In fund

Switch Out – Reversal

Sum Net Amount in FBC of the original transaction where fund passed is the Switch Out fund

Dividends

Table 2-154 Dividend Types and Reports

Dividend Types Reports
Dividend payout
Criteria for dividend record consideration:
  • Amendment / Reversal not happened
  • Freeze Holdings done
  • EPU is available
  • Dividend is not processed
  • Date passed is the Dividend Declare Date

Dividend Amount = Sum of Freeze Holdings Units * EPU

Dividend Amendments (Outflow)
Criterion for dividend record consideration:
  • Original dividend is processed and amendment is not processed

Dividend Amount = Sum of Freeze Holdings Units * New EPU

Dividend Amendments (Inflow)
Criterion for dividend record consideration:
  • Original dividend is processed and amendment is not processed

Dividend Amount = Sum of Freeze Holdings Units * Old EPU

Estimated Cash In = A + C + F+ H + K

Estimated Cash Out = B + D + E + G + I + J

This report will be generated for all funds in an AMC as maintained in the message maintenance. The trigger could be based on an event or manual.

This topic contains the following sub-topics: