BANK MANAGEMENT - COMPANION FILES
julianrsterling.com/franchise

Free. No sign-up, no email address. Nothing is locked, protected or watermarked.
Revised 24 September 2026.

Optional: to get an email if these files are ever corrected, join the reader list at
https://julianrsterling-readers.subscribepage.io/
(run by MailerLite, off the site; nothing in this archive needs it).

WHAT IS IN THE ARCHIVE

1. The book's four workbooks, corrected
   01_Four_Readings_of_Capital.xlsx     Chapters 1, 2, 14 and 24
   02_Margin_and_Deposit_Beta.xlsx      Chapters 3 to 8
   03_Gap_Duration_and_EVE.xlsx         Chapters 7, 9, 11 and 16
   04_Liquidity_and_the_Run.xlsx        Chapters 15, 17 and 25
   00_START_HERE.md                     what changed is at the end
   Each workbook closes on a Checks sheet: 91 checks in all, every one PASS.

2. Blank_Model_Set/  (new)
   The four workbooks with the 61 inputs of their shared Inputs sheet
   emptied, for your own bank. Each Checks sheet counts what is still
   missing and tests what holds for any inputs. The book's figures are in
   book_inputs.txt: type them back in and the book's results come back.

3. Working_Documents.pdf  (new)
   Thirteen printable pages: the committee exhibit with its bridge, the
   marks portfolio by portfolio, the margin before and after the shock,
   the transfer-pricing statement, the loaded cost of a deposit, the beta
   with its denominator, the weighted repricing gap, the floating book as
   written, the surface, the two horizons, what a buyer would pay, the
   liquidity sources and the two coverage figures, and the run with the
   order its thresholds fall. A4, fits Letter.

4. Forty_Questions.xlsx  (new)
   Forty questions across the book, marked by the file as you type.

5. Cases/  (new)
   Case_1_The_Run_That_Accelerates.xlsx       Chapters 17 and 25
   Case_2_The_Choice_Nobody_Was_Asked.xlsx    Chapter 17
   Case_3_One_Beta_Two_Denominators.xlsx      Chapters 3, 6, 9 and 14
   Each case: the note on the first sheet, the model after it, checks at the end.

The files open in Excel, LibreOffice Calc, Google Sheets and Numbers. No macros.
