THE ASSET-BASED FINANCE HANDBOOK - BLANK MODEL SET: THE BOOK'S OWN INPUTS

Type these back into the blank files and the book's results come back. Cell references are sheet!cell.
The segment reference and diligence checklists have no blank version: that workbook arrives empty.

Borrowing_Base_and_Advance_Rate_Blank.xlsx  (Appendix C, Chapters 5 and 22)

   The loan tape (1,880 contracts) and the obligor, broker and jurisdiction lists: copy the sheets Loan tape (A5:L1884), Obligors (A5:A204) and Brokers (A5:A9, D5:D7) from Borrowing_Base_and_Advance_Rate.xlsx.

   Criteria!C6                               72
   Criteria!C7                               30
   Criteria!C8                               0.1
   Criteria!C9                               Kelvara Finance
   Criteria!C15                              0.005
   Criteria!C16                              0.1
   Criteria!C17                              0.2
   Criteria!C18                              0.05
   Criteria!C19                              0.55
   Criteria!C20                              0.25
   Criteria!C25                              0
   Criteria!C26                              0
   Criteria!C27                              3500000
   Criteria!C28                              4200000
   Criteria!C29                              0
   Criteria!C30                              0
   Criteria!C31                              168000000
   Criteria!C32                              200000000
   Advance rate!C5                           0.024
   Advance rate!C6                           2.5
   Advance rate!C7                           0.015
   Advance rate!C14                          0.88
   Advance rate!D26                          0.92
   Advance rate!C29                          0.054
   Advance rate!C33                          0
   Advance rate!C34                          0.03

   Result: 17.2% of the pool fails the criteria; eligible pool EUR 203.2m; headroom EUR 3.1m; advance rate 88%, enhancement 12%, break-even 5.0 times.

The_Meridian_Transaction_Blank.xlsx  (Chapter 22)

   Screening!C5                              1900
   Screening!C6                              640
   Screening!C7                              48
   Screening!C8                              520
   Screening!C9                              200
   Screening!C10                             31
   Screening!C11                             0.22
   Screening!C20                             0.54
   Screening!C21                             0.31
   Screening!C22                             0.15
   Screening!C26                             0.021
   Screening!C27                             0.029
   Screening!C28                             0.034
   Screening!C35                             0.61
   Screening!E35                             0.022
   Screening!C36                             0.28
   Screening!D36                             0.19
   Screening!E36                             0.051
   Screening!C37                             0.11
   Screening!E37                             0.024
   Screening!C47                             0.08
   Diligence!C5                              340000
   Diligence!C13                             220
   Diligence!C14                             4
   Diligence!C15                             11
   Diligence!C16                             3
   Diligence!C22                             0.12
   Diligence!C24                             0.91
   Diligence!C26                             4
   Diligence!C27                             0.3
   Diligence!C32                             4
   Diligence!C33                             14
   Diligence!C34                             0.08
   Diligence!C35                             2022
   Diligence!C41                             14
   Diligence!C42                             48
   Diligence!C43                             10
   Diligence!C44                             40
   Structure!C5                              200
   Structure!C6                              2
   Structure!C7                              4
   Structure!C11                             0.024
   Structure!C12                             2.5
   Structure!C14                             0.015
   Structure!C16                             0.88
   Structure!C17                             0.92
   Structure!C24                             0.005
   Structure!C25                             0.1
   Structure!D25                             0.15
   Structure!C26                             0.2
   Structure!D26                             0.28
   Structure!C27                             0.05
   Structure!C28                             0.55
   Structure!C29                             0.25
   Structure!C30                             0.08
   Structure!C33                             0.17
   Structure!C38                             0.032
   Structure!C39                             0.04
   Structure!C40                             0.05
   Structure!C42                             0.06
   Structure!C47                             0.06
   Structure!C48                             4.2
   Structure!C49                             3.5
   Structure!C50                             0.011
   Structure!C51                             40
   Structure!C52                             10
   Structure!C53                             12
   Structure!C54                             0.0525
   Structure!C55                             0.0075
   Structure!C56                             0.0125
   Eighteen months!B6                        0.84
   Eighteen months!B8                        0.026
   Eighteen months!B9                        0.029
   Eighteen months!B10                       0.061
   Eighteen months!B11                       0.033
   Eighteen months!B12                       0.09
   Eighteen months!B18                       0.045
   Eighteen months!C22                       800000
   Eighteen months!C24                       8
   Eighteen months!C27                       exit catering entirely
   Eighteen months!C31                       0.28
   Eighteen months!D31                       0.026
   Eighteen months!C32                       0.56
   Eighteen months!D32                       0.027
   Eighteen months!C33                       0.84
   Eighteen months!D33                       0.028
   Eighteen months!C34                       0.88
   Eighteen months!D34                       0.029
   Eighteen months!C35                       0.9
   Eighteen months!D35                       0.031
   Eighteen months!C36                       0.92
   Eighteen months!D36                       0.033
   Stressed case!B5                          168
   Stressed case!B7                          0.85
   Stressed case!B9                          31
   Stressed case!B10                         24
   Stressed case!B11                         0.158
   Stressed case!B13                         0.0875
   Stressed case!B14                         0.054
   Stressed case!B15                         0.15
   Stressed case!B16                         2
   Stressed case!B17                         6
   The pool's life!C9                        48
   The pool's life!C21                       31
   What made the difference!C18              22
   What made the difference!C19              the minimum liquidity covenant
   What made the difference!C28              19

   Result: level one fires at month 16; debt at month nine 57.9% of peak on the 24-month term; contracts of 48 months behind the Stage one book; at 92% the stressed loss leaves 2.6 points.

Trigger_Design_and_Stress_Testing_Blank.xlsx  (Appendices A, E and G, Chapters 4 and 5)

   Trigger grid!C5                           0.025
   Trigger grid!C6                           0.035
   Trigger grid!C7                           0.03
   Trigger grid!C8                           0.06
   Trigger grid!C9                           0
   Trigger grid!C15                          0.05
   Trigger grid!C28                          0.032
   Trigger grid!C29                          0.04
   Trigger grid!C30                          0.045
   Trigger grid!C31                          0.045
   Trigger grid!C32                          0.06
   Headroom monitor!C5                       0.032
   Headroom monitor!D5                       0.029
   Headroom monitor!C6                       0.04
   Headroom monitor!D6                       0.029
   Headroom monitor!C7                       0.05
   Headroom monitor!D7                       0.029
   Headroom monitor!C8                       0.045
   Headroom monitor!D8                       0.061
   Headroom monitor!C9                       0.045
   Headroom monitor!D9                       0.031
   Headroom monitor!C10                      0.06
   Headroom monitor!D10                      0.024
   Headroom monitor!C11                      0.02
   Headroom monitor!D11                      0.004
   Headroom monitor!C12                      40
   Headroom monitor!D12                      48
   Headroom monitor!C13                      10
   Headroom monitor!D13                      14
   Headroom monitor!C14                      0
   Headroom monitor!D14                      3.1
   Stress testing!C5                         200
   Stress testing!C6                         0.88
   Stress testing!C7                         7
   Stress testing!C8                         0
   Stress testing!C9                         0.024
   Stress testing!C10                        0.18
   Stress testing!C11                        3.5
   Stress testing!C12                        0.015
   Stress testing!C21                        2.5
   Stress testing!C33                        0.125
   Stress testing!C34                        0.25
   Stress testing!C35                        4
   Stress testing!C36                        3.5
   Stress testing!C42                        0
   Stress testing!C43                        0.005
   Stress testing!C44                        0
   Stress testing!C45                        0
   Lead and lag!B5                           3
   Lead and lag!B6                           6
   Lead and lag!B7                           3
   Lead and lag!B14                          0.075
   Lead and lag!B15                          30
   Lead and lag!B17                          24
   Lead and lag!B18                          31
   Lead and lag!B19                          0.45
   Lead and lag!B20                          2.2
   The four numbers!C5                       0.075
   The four numbers!C6                       60
   The four numbers!C7                       0.3
   The four numbers!C10                      0.68
   The four numbers!C13                      9
   The four numbers!C16                      0.18
   The four numbers!C17                      31
   The four numbers!C23                      0.158
   The four numbers!C24                      0.011
   The four numbers!C28                      0.035
   The four numbers!C29                      0.0525
   The four numbers!C33                      0.061

   Result: expectations implied by the two delinquency triggers 2.46% and 2.50%; excess spread floor 3.5%; lagging trigger a year late.

