BORROWING - Company Liquidity

Stage 1 is create a Named Report Style by entry in 'REPORT' box and click OK. A grid for entry of the row definitions is presented, see help? on the grid.

Stage 2 is to use the Report Style, this is achieved by selecting the style from the list at top of screen, select the paramters to operate below and click Report

There are several edit processes e.g. rename, delete, copy..  that are enabled when highlight a report style from top list

Example of a configuration for the Gross Collateral Column.

• Cash & Cash Equivalents. 

  sum of accounting entries in NOM account 1000.0001 ( Wells Fargo bank) which have been agreed in the BREC process.

• Eligible US Receivables.

  list individual accounting entries for accounts maintained as resident in ’USA’ or are marked in CLI with ‘Other Classification = ‘BB’. Transactions that are over due by more 30 days are excluded.  SI’s where their allocated Purchase Invoicing has not passed cash to the supplier are also excluded.

• Eligible Non US Receivables.

  list individual accounting entries for accounts maintained as resident not in ’USA’ and are marked in CLI with ‘Other Classification = ‘BB’. Transactions that are over due by more 30 days are excluded.  SI’s where their allocated Purchase Invoicing has not passed cash to the supplier are also excluded.

• Unsold US Inventory

  list TRADE market value (and any Pol)  which have Traffic Shipping Status = ‘Warehoused ‘ i.e. CQ, L, R or W. The Traffic Warehouse Location references a port code that is setup as USA. The Purchase TRADE is NOT allocated. The TRADE Finance bank = ‘SOCG.T’

• Pre-sold US Inventory

  list TRADE market value (and any Pol) which have Traffic Shipping Status = ‘Warehoused ‘ i.e. CQ, L, R or W. The Traffic Warehouse Location references a port code that is setup as USA. The Purchase TRADE is allocated BUT is not Sales Invoiced. The TRADE Finance bank = ‘SOCG.T’

• CQE advances

  list TRADE advances which are assigned as CQEADV or CQEINV. The market price is current month NY16 price less current month NY11 price (TPRICE). The Fobbing discount is applied to each NY price, if maintained in +Options. The country for the Fobbing discount is the TRADE x commodity country of origin.

• Net Liquidation.

  Standard EQUITY report on account USA.T

• Documentary L/Cs

  LCMAINT workable value on OUTGOING only where issue bank = ‘SOCG.T’. Same criteria for inclusion as per CASHUG

• Eligible USQ contracts

  Pre payment (Clean – ADVANCE) unused per TRADE/Invoice marking/Other where TRADE commodity = ‘USQ’

• Eligible World RAW contracts

  Pre payment (Clean – ADVANCE) unused per TRADE/Invoice marking/Other where TRADE commodity = ‘RAW’

• Eligible World WHT contracts

  Pre payment (Clean – ADVANCE) unused per TRADE/Invoice marking/Other where TRADE commodity = ‘WHT’

• Inventory outside USA for #16

  List Purchase TRADE market value that are NOT sales invoiced (phys01_saleinvdate=0), Shipping status indicates warehoused (cmy28_inwarehouserep=1) and the Warehouse location references a Port that is located outside ‘USA’. Where TRADE commodity=’USQ’

•  Inventory outside USA  for #11

  List Purchase TRADE market value that are NOT sales invoiced (phys01_saleinvdate=0), Shipping status indicates warehoused (cmy28_inwarehouserep=1) and the Warehouse location references a Port that is located outside ‘USA’. Where TRADE commodity=’RAW’

• Inventory outside USA for #5

  List Purchase TRADE market value that are NOT sales invoiced (phys01_saleinvdate=0), Shipping status indicates warehoused (cmy28_inwarehouserep=1) and the Warehouse location references a Port that is located outside ‘USA’. Where TRADE commodity=’WHT’

• Forward Book Profit for NY11.  M2M on any TRADE that have commodity code = ‘RAW’. Note:  keep total of Profit and total for Loss and show total of both.

• Forward Book Profit for NY16.  M2M on any TRADE that have commodity code = ‘USQ’. Note:  keep total of Profit and total for Loss and show total of both.

• Forward Book Profit for White.  M2M on any TRADE that have commodity code  = ‘WHT’.  Note:  keep total of Profit and total for Loss and show total of both.

• The totals lines a)  b) and c) are straightforward as is Total a+b+c

• The Total Loans Outstanding value is calculated by locate ALL banks (NOM) associated in the CLI account ‘SOCG.T’ via view/banking details

• Borrowing  Base  excess (deficit) is difference total Borrowing less 17.