00 - Reg O Insider calculator.xlsx

VP at a bank ($1.1BUSA)

You do not have access to download this document

Discussions about this document

Corrected 2/22/21: Reg O calculator and worksheet to use for monitoring against Unimpaired Capital and Surplus hurdles

VP at a bank ($1.1BUSA)
There was a formula error in Column U for the public disclosure determination - thanks to the CBANC'rs who brought to my attention as well as some hidden columns left in.    

When the bank's unimpaired capital and surplus is calculated, and your monitoring has captured all insider loans, this worksheet will aid in looking at each bucket and its unique considerations to determine if the bank is in overall compliance with each of these areas.   
 A calculator to determine the unimpaired capital and unimpaired surplus is also on CBANC, and was uploaded to reflect call reporting changes.  Please click a "Thanks" if you like my own work that I have shared here.  Thanks