Home » Excel Spreadsheet » Treasury Bill Calculator

It occurred to me that my last post Treasury Bill Math with twelve formulas, has little value if you are sitting on a trading desk and need to work quickly. I put together this calculator that will calculate two of the four pieces of information, given two pieces. It looks like this:


The page is protected. The the yellow entry cells are not. You will get a reminder if you enter more than two entries. There is no password, so it can be unprotected. I used the same named letters that I used in Treasury Bill Math . I concatenated the named letters and created a lookup table to find the results I needed:


For example, the data I entered is the discount rate (i) and the money market rate (y). They concatenate to iy and the letters across the top are used in the lookup.

Download “T-Bills2

Leave a Reply

Your email address will not be published. Required fields are marked *