Treasury Finance and Development Banking: A Guide to Credit, Debt, and Risk, + Website

About the Web Site

In order to illustrate some of the more practical points presented in this book, we offer the reader two spreadsheets containing a considerable amount of VBA code that the reader is free to use, copy, or modify. Additional material of potential interest to the reader will be added to the web site in the future. The choice of implementation is given by the fact that most people are familiar with VBA. In order to show the points made, all languages are more or less equivalent and, most important, VBA is available to anyone with an Excel license and does not need compiling. To access the spreadsheets, please visit www.wiley.com/go/treasuryfinance and enter the following password on the sign-in page: treasury789.

THE IMPLEMENTATION OF THE BOOTSTRAPPING OF AN INTEREST RATE CURVE

The spreadsheet “TreasuryFinanceInterestRateCurve.xlsm” contains the implementation of the bootstrapping of an interest rate curve as shown in Section 2.5. As mentioned above, the code is written in VBA so that it can be used in any Excel session. It is probably not the most efficient way of bootstrapping (ideally one would have built an object handle instead of bootstrapping at each interpolation request), but it is extremely easy to understand and to modify if needed.

The spreadsheet is fairly self-explanatory and already contains some realistic input values. We need to stress some constraints needed for the function to work:

• The first column of the input range must contain the type code ...