Browse By

Category Archives: Asset Liability Management

Calculating EXCEL Duration Between Bond Coupon Payments

Excel duration between coupon dates How does EXCEL calculate DURATION for settlement dates between coupon dates? This was a question posed by one of our readers recently. We have already examined the calculation of Excel Duration and Price functions when settlement dates equal coupon payments dates in

CIR - Projected rates

CIR Interest Rate Model – Appropriate Time Step

What is the appropriate time step to use in estimating parameters for, and projecting short rates using, the CIR model? Can estimates based on daily time series data be used in an interest rate model that projects short rates at a monthly time interval? The


ILAAP ALM LCR Reports template validator

ILAAP ALM LCR Reports template validator This product is designed for banking professionals, consultants, implementation teams and model auditors responsible for asset liability management and risk management model testing, validation and audits within banking and other deposit taking institutions. The tool is designed to validate

Liquidity Gap

Liquidity gap – Implementation.

Liquidity Gap Implementation challenges. A quick review of common liquidity gap implementation challenges as part of the bank asset liability management platform implementation.  What is Liquidity Gap? The liquidity gap reports presents a summarized view of the bank’s balance sheet by breaking total assets and liabilities

Positive gap rules for bank ALM analysis & strategy

ALM training for board & ALCO members.

ALM training for Board members. 7 posts. 60 minutes. I have long felt a need a for a high level overview course on Asset Liability Management training for board members, executive committee and ALCO teams. A course that focuses in equal measure on high level

Net Interest Income Analysis - Bank ALM

Net Interest Income (NII) vs Economic Value (EVE)

Net Interest Income – Earnings versus Economic Value. The two elements used within bank ALM analysis are economic value and earnings. Why is earning emphasized more than value? What is wrong with value analysis? In the ALM world we use two tools to illustrate the impact

Calculating NII - Bank ALM

Asset Liability Management Training Guide. 3rd Edition.

Asset Liability Management Training Guide. 3rd Edition. The brand new, revised 3rd edition of the ALM Study Guide is out. With 190 pages, 189 figures and illustrations, the new edition weighs in at thrice the size of the 2nd edition and spends more time on