Specialized & Periodic Reporting

Compensation Workbook

Visual Reference: Compensation Workbook (Sample Report Data)

Send-Only Example:

BANK NAME (BXXX) DDM compensation workbook
Day of month     Daily DDM balance     Program Rate     Daily Accrual
2016-10-01       $65,870,771.61        0.4700           $0.00
2016-10-02       $65,870,771.61        0.4700           $0.00
2016-10-03       $66,017,771.61        0.4700           $2,539.53
2016-10-04       $66,624,771.61        0.4700           $855.56
2016-10-05       $67,045,771.61        0.4700           $860.97
2016-10-06       $66,721,171.61        0.4700           $856.81
2016-10-07       $66,729,771.61        0.4700           $3,427.65
2016-10-08       $66,729,771.61        0.4700           $0.00
2016-10-09       $66,729,771.61        0.4700           $0.00
2016-10-10       $66,729,771.61        0.4700           $0.00
2016-10-11       $67,401,171.61        0.4700           $865.54
2016-10-12       $67,440,771.61        0.4700           $866.04
2016-10-13       $67,029,339.41        0.4700           $860.76
2016-10-14       $66,692,338.57        0.4700           $2,569.30
2016-10-15       $66,692,338.57        0.4700           $0.00
2016-10-16       $66,692,338.57        0.4700           $0.00

Gross Compensation                  $13,702.14
Less Send side customer interest    $12,827.53
Plus pre-paid customer Interest     $0.00
Final compensation                  $874.61

Reciprocal Example (Key Summary Fields):

... [Daily Row Data] ...

Gross Send-side Fee: $23,130.34
Less Send-side Customer Interest: ($18,367.73)
Plus Pre-Paid Customer Interest: $0.00
Final Compensation: $4,762.61

Total Send-side Accrual: $0.00
Total Receive-side Accrual: $138.89

Total Send-side Customer Interest Accrual: ($1,354,821.50)
Total Reciprocal Customer Interest Accrual: ($1,304,335.78)

Total Receive-side Customer Interest Accrual: ($1,304,335.78)

Total Interest Difference: ($50,485.72)

How to Read Compensation Workbook Information

This workbook calculates the financial costs and earnings of the program for the Client.

The Accruals: Look for Daily Accrual to see what is being earned/owed on a day-to-day basis.
Final Compensation: At the bottom of the "Reciprocal Example," focus on the Final compensation amount. This is the net dollar figure that will be settled at month-end.
The Difference: In the Reciprocal view, focus on the Interest Difference column to see how the "Send" and "Receive" rates are balancing out.

Call Report Information

The information provided assists the Client with completing their firm-wide Call Reporting regulatory filings. While this report can be useful in completing Call Report filing, R&T does not prepare or file Call Reports on behalf of participating institutions. Each participating institution remains responsible for determining the appropriate regulatory classification of its complete balance sheet, reconciling information from all relevant products and service providers, and submitting its institution-wide Call Report. Detailed transaction and account-level data can be reviewed and reconciled using the Customer Deposits Held at Bank Report.

Visual Reference: Call Report Information (Sample Report Data)

Schedule RC-E: Deposit Liabilities

Schedule RC-E-Deposit Liabilities

                                                                      Transaction Accounts
                                                                           (Column A)
                                                                        Total Transaction
                                                                            Accounts
                                                                     (including Total Demand
                                                                            Deposits)


Deposits of:                                 All values expressed in actual dollars

                                                           RCON

1. Individuals, partnerships, and corporations             B549        $80,566,713.58

2. U.S. Government                                         2202                 $0.00

3. States and political subdivisions in the U.S.           2203         $4,476,600.00

4. Commercial banks and other depository institutions
   in the U.S.                                             B551         $3,233,100.00

5. Banks in foreign countries                              2213                 $0.00

6. Foreign governments and official institutions
   (including foreign central banks)                       2216                 $0.00

7. Total (sum of items 1 through 6)                        2215        $88,276,413.58

8. Total column B                                          2210        $88,276,413.58



Memoranda                                   All values expressed in actual dollars

                                                           RCON

1. Selected components of total deposits (i.e., sum of item 7,
   columns A and C):

   a. Total Individual Retirement Accounts (IRAs) and
      Keogh Plan accounts                                  6835         $2,678,508.35

   b. Total brokered deposits                              2365                 $0.00

   c. Brokered deposits of $250,000 or less
      (fully insured brokered deposits)                    HKO5                 $0.00


   d. Maturity data for brokered deposits:

      (1) Brokered deposits of $250,000 or less with a
          remaining maturity of one year or less
          (included in Memorandum item 1.c. above)        HKO6                 $0.00


      (3) Brokered deposits of more than $250,000 with
          remaining maturity of one year or less
          (included in Memorandum item 1.b. above)        K220                 $0.00


   g. Total reciprocal deposits *                         JH83        $88,276,413.58



* Based on information your bank has previously provided to us, we understand that your bank wishes to classify the "reciprocal deposits" at your bank under the programs we administer as "not brokered deposits" (i.e., core deposits). Accordingly, in this sample report, we have included all such "reciprocal deposits" in RCON JH83 on Schedule RC-E. Your bank is solely responsible for conducting its own analysis and determination as to whether that classification is, in fact, accurate. If your bank determines that such funds should not be classified as core deposits, but should instead be classified as "brokered" (and reported in Schedule RC-O, item 9, instead of in RCON JH83 on Schedule RC-E as currently set forth above), your bank will need to revise those Schedules accordingly when using the information in this sample report to prepare your bank's Call Reports.
  See "Important Disclosure" on the last page of this sample report.

h. Sweep Deposits:

   (1) Fully insured, affiliate sweep deposits                  MT87             $0.00

       (a) Fully insured, affiliate, retail sweep deposits      MT88             $0.00

   (2) Not fully insured, affiliate sweep deposits              MT89             $0.00

       (a) Not fully insured, affiliate, retail sweep deposits  MT90             $0.00

   (3) Fully insured, non-affiliate sweep deposits              MT91    $88,276,413.58

       (a) Fully insured, non-affiliate, retail sweep deposits  MT92    $83,799,813.58

   (4) Not fully insured, non-affiliate sweep deposits          MT93             $0.00

       (a) Not fully insured, non-affiliate, retail sweep
           deposits                                             MT94             $0.00


i. Total sweep deposits that are not brokered deposits          MT95    $88,276,413.58


Note: Memorandum items 1.h.(1)(a), 1.h.(2)(a), 1.h.(3)(a), and
1.h.(4)(a) are to be completed by banks with $100 billion or
more in total assets.

Schedule RC-F: Other Assets

RCON
6. All other assets:                                   2168               $308.74
   DDM SHORTFALL RECEIVABLE                            3549               $308.74

Schedule RC-G: Other Liabilities

RCON
4. All other liabilities:                              2930                 $0.00
   DDM SHORTFALL PAYABLE                               3552                 $0.00

Schedule RC-K: Quarterly Averages

Liabilities:                                           RCON
11. Nontransaction accounts:
a. Savings deposits (includes MMDAs)                   3485        $28,585,389.74

Schedule RC-Balance Sheet



                                       All values expressed in actual dollars

                                                              RCON

13. Deposits                                                  2200    $88,276,413.58


(1) Noninterest-bearing*                                      6631



* Some banks take the position to report deposit balances of their customers in this item with respect to which: (1) the banks set a 0% interest rate; and (2) are fully reciprocated through the DDM Program.

How to Read Call Report Information

Schedule RC-E (Deposit Liabilities): Use Line 1 to find the total reciprocal balances for individuals and corporations.
Line 7 (Total): This should match the Receiving Institution's total DDM Program position for the final day of the quarter.
Schedule RC-O (Insurance Assessment): Use this section to report the number and amount of deposit accounts that are $250,000 or less.

Customer Deposits Held at Bank Report

Visual Reference: Customer Deposits Held at Bank Report (Sample Report Data)

DEMAND DEPOSIT MARKETPLACE

CUSTOMER DEPOSITS HELD AT DEMO BANK

CURRENT DATE   BROKER/BANK                         R&T A/C #   ACCOUNT TYPE                    BALANCE      BANK ACCT#

2019-10-25     R BANK NAME 1                       6583511     Unknown                         231,905.27   1419757
2019-10-25     R BANK NAME 2                       6844871     Gov't (Municipality, State)     249,000.00   1419757
2019-10-25     R BANK NAME 3                       6996882     Corporation                     249,000.00   1419757
2019-10-25     R BANK NAME 4                       17076364    Corporation                     249,000.00   1419757

--------------------------------------------------------------------------------

2019-10-25     TOTAL BANK BALANCE:                             18,546,542.78

How to Read Customer Deposits Held at Bank Report Information

Use this report to confirm which customer balances and account types have been allocated to the Program Account at the receiving institution. This report provides a receive-side view of the balances comprising the Program Account on a given day and can be used to support reconciliation activities, audits, examinations, and Call Report reporting requirements.

Broker/Bank: Identifies the sending institution whose customer deposits have been allocated to the Program Account.
R&T A/C #: Displays the R&T account associated with the allocated balance.
Account Type: Confirms the FDIC category being allocated to the Program Account.
Balance: Displays the portion of the customer account balance allocated to the Program Account identified in the Bank Acct # field.

Note: Review the Balance field to confirm how much of each customer account is being allocated to the Program Account. This can help validate that allocations are operating as expected by ensuring that no more than the account's SMDIA is being allocated
Bank Acct #: Displays the Program Account receiving the allocation.
Total Bank Balance: Displays the total balance comprising the Program Account on the report date. Compare the total balance and supporting account details when performing reconciliation, audit, examination, or Call Report validation activities.

For information on how DDM Program data contributes to FDIC reporting codes, see Call Report Information.