Liquidity Risk Regulatory Calculations for European Banking Authority User Guide Liquidity Coverage Ratio Calculation as Per Delegated Act Calculation of Contractually Required Collateral Calculating Excess Collateral For Other Assets and Liabilities Calculating Excess Collateral Receivable 4.4.3.2.2 Calculating Excess Collateral Receivable The application calculates the excess collateral receivable for other assets and liabilities as follows, if one of the following conditions are met: If Balance Sheet Category is Asset, then the contractually due collateral is 0. If Balance Sheet Category is Liability, and Secured Indicator is N, then the contractually due collateral is 0. If Balance Sheet Category is Liability, and Secured Indicator is Y, then the application computes the contractually due collateral as follows: Figure 3-19 Excess Collateral Receivable