CCYEXPSEL - Ccy Exposure (+Stocks)
What is
For a company that uses different currencies and applies FOREX cover for their exposure, CCYEXPSEL will provide a useful tool for monitoring the overall position. Non matured exposure is analysed with the booked currency positions. If the company is operating strict back to back FX cover, the report would show a square position. There is a feature that will allow you to view the contents of the summary with drilldowns and printing of the detail.
a) Current accounting balances i.e. Debtors, Creditors and Banks (NOM accounts which have been marked correctly as 'Bank account'). Note that Debtors and Creditors will also include transactions that have not yet been authorised/posted into the client balances.
b) FX; all TRS deals that have a maturity date >= today and the deal is not set up as broker/bank, if double entry being operated.
c) Non invoiced Purchases and Sales; the value reported is the contract amount, when there has been No invoice marking or a final invoice is required in which case the value accumulated is the contract value less invoiced value.
d) Stocks/Position evaluation; only contracts for the selected currency which are not sales invoiced are included. The process is to accumulate all purchase contract quantities and subtract sale contract quantities to arrive at the net stock position per principal commodity. The values of all the purchase contracts are summed and divided by the total of the purchase contract quantities to provide an average price. The average price is multiplied by the net stock position to arrive at the Position/stock exposure value. On the drilldown the analysis is by commodity row with columns for stock classified purchases, other currency tonnage totals and the extended value computation.