SPREADSHEET a b c d (a+b) - (c+d) = e e x 1.1 = f g g - f Amount of Collateral Needed (110% of Amount of Deposits Market Value Time/Savings Demand Insurance Amount of Deposits Requiring Requiring of Collateral Sufficient (Insufficient) Name of Depository * ** Accounts Accounts Coverage Bond Collateral Collateral) Provided Collateral Coverage * Put a check in this column if depository is a member of FDIC or NCUA. ** Put a check in this column if depository is not a branch of any of the other depositories here.
SPREADSHEET a b c d (a+b) - (c+d) = e e x 1.1 = f g g - f Name of Depository * ** Time/Savings Accounts Demand Accounts Amount of Insurance Coverage Amount of Bond Deposits Requiring Collateral Amount of Collateral Needed (110% of Deposits Requiring Collateral) Market Value of Collateral Provided Sufficient (Insufficient) Collateral Coverage * Put a check in this column if depository is a member of FDIC or NCUA. ** Put a check in this column if depository is not a branch of any of the other depositories here.