hi david i cant figure out table 7.2 on tuckman's chpater on key rate and bucket exposures. i saw that you published a spread sheet on table 7.1 but i didn't find a one on table 7.2 appreciate if you can publish one or instead explain this table thanks gizmo

HI David on second thought i would appreciate if you can explain or publish spreadsheets on the rest of this chapter and the caculation that are mantioned in chapter 7

hi gizmo, I will see if we can expand the key rate exposure XLS to include more of chapter 7, i think it's a good idea... ... but, in regard to 7.2, that's less "interesting" that it may seem in terms of calculations: all it seeks to do is make sure that the hedging portfolio key rates equal the underlying exposure (mortgage bond) key rate. That is, if the underlying mortgage bond has a 5-year key rate of X, you want the SUM of KR01s of the hedge portfolio bonds to equal the same X; such that, if the key rate shifts by 1 bps, then the portfolio value change equals the underlying value change (the hedge works!) ...in this way, the 7.2 literally takes all those KR01 as inputs and, as text says, all it does at that point is solve for four unknowns given four equations Thanks, David

HI DAVID as usual many thanks. as i started on working the L2 - still waiting to hear your regard on the AIMS and what is your plan for the L2 nominies, also i think that your notes on the L1 studies were great., are you going to do the same on the L2 topics? i personaly think that because they diveded the exam in two they will go deeper on the readings, and that is why i think you should offer notes in what you are going to offer to the L2 nominies waitnig to hear on the program and again, many thanks gizmo.

hi david i tried to figure the numbers in table 7.2 and i can't figure why these are the numbers that tuckman put? from where does 0.01818 comes from? and what is 0.00122 stands for? after breaking my mind on it, still haven't quite figure it out... please if you can post an explanation on it, i will appreciate it hope to get answers... thanks gizmo

Hi gizmo, re: L2 notes, yes, we do plan similar treatment, please see calendar @ http://www.bionicturtle.com/products/announcement/2010_frm_calendar/ re: table 7.2, the entries (e.g., 0.01818, 0.00122) are all key rate 01s. That is, they are just like DV01 except they give the dollar change in the bond for a one basis point (1 bps) change in the key rate instead of the entire term structure parallel shift (as the yield-based DV01 assumes). So, for example, 0.01818 is the dollar change in the price of the 2-year bond (used as one of the bonds in the hedging portfolio, to hedge the mortgage bond) given a 1 bps shock to the 2-year rate (i.e., a one basis point decline in the 2-year rate 1 bps AND a decline in the neighboring rates spanning from 0 to five years). ... you will note that, in regard to the mortgage bond, the 0.98129 = 0.98 in the first row of the Key Rate 01($) column in table 7.1 (... FWIW, I also believe the table contains an error: I do not agree with Tuckman that several entries should contain zeros for the 5- and 30-year par bonds. He argues that, e.g., the 30-year bond, because it is par bond, is only sensitive to the 30-year rate, but I do not agree; i think the entire row for the 30-year bond should be nonzero as shocking the shorter rates impacts the coupons.). David

Hi David, For table 7.1, can you show how the values in column 1 were calculated? For the initial value, we don’t know the FV for PV calculation. How is 100,453.13 calculated? How is the value calculated for after 2 year shift, 5 year shift, etc.? The book does not provide explanations. Thanks.

Hi sleepybird, Do you have T3 access, because i just revised the XLS that exactly mimics the calculations (there are two aspects to it: the region of rates change and, what took me longer to figure out and requires time to understand, that he used PAR yields not spot yields), see http://www.bionicturtle.com/how-to/spreadsheet/2012.5.b.3.-key-rate-shift/

I'm still debating on which tier to register for. Well, that certainly helps in the decision making process .

i don't want to upsell you, if you don't get T3, just let me know and I'll copy the calcs here ... and in case it helps to be reminded (see my focus review article here on this @ http://www.bionicturtle.com/how-to/article/2012.p2.t5.-focus-review-1st-of-8/ ), while key rates are interesting, the particulars of Tuckman's derivation, especially the use of par yields, remains of very low testability (I'm on record with GARP that I feel they publish too many AIMs for Tuckman's Chapters 7 & 9 given the superficial testing record)

David, It would be GREATLY appreciated if you could copy the calc here (also if you could please include calc for table 7.2), since I'm on the topic right now. I got the discount code (returning customer) from Suzzane and I plan to register in the next couple days (T2 or T3). Thank you very much for your help. Sleepybird

Hi sleepybird, Here is a snippet from the learning XLS: https://www.dropbox.com/s/fpgamwpad67v5h9/0809_TuckmanTable7.1_snippet.xlsx (screenshot below) This shows show the 2-year key rate of $0.98 is calculated in Table 7.1. The green cells are the starting point: the neighboring rates to the 2-year rate (i.e., from 0.5 years up to 4.5 years since 5-year is the next key rate) are all shifted up from 5.0% to slightly higher par yields. The bond is then repriced according to this non-flat curve (it is flat at 5 years and beyond: the point is to only yank up a segment of the curve), and the result it $100,452.15 which is a $0.98 price decline. I don't have Table 7.2 in XLS (yet): the key rates for the 4 hedging securities are just given (assumed) but would be figured in the same way. Then it's a solution of four unknowns with four equations. I may add this to our development list .... thanks,

Hi David, Thanks for the posting. Sorry this is still not very clear to me. 1. How are the values from period 5 to 10 in the “shock” column determined (I can understand from period 1 to 4). 2. Your table calculates the value 100,452.15 for “after 2 year shift.” So to calculate the initial value (i.e., without any shifts), I simply change the values in the “shock” column to all 0s (i.e., sum of the PV column would be 100,453.13?) I used excel formula =PV(5%/12, 360, 3250,0), which gives me $605,415.26. Shouldn’t the value also be 100,453.13? What is the correct excel shortcut formula? 3. You used year 0.5. 1.0, etc. but isn’t the 3,250 a MONTHLY mortgage payment? Why are we pricing it based on semi annual instead of monthly basis? Thanks in advance for your patience on this. Sleepybird

hi sleepybird, I attached the XLS snippet above, can you please look at the Excel that i prepared for you, it shows the calcs ... i shared the XLS to show you the calcs, here is the link again https://www.dropbox.com/s/fpgamwpad67v5h9/0809_TuckmanTable7.1_snippet.xlsx see xls, the requires an understanding of (and complications introduced by) par yield. But, in truth, is not essential to the key rate shift technique: my full XLS also performs using simple shifts in spot rate. Yes, if you changed all the shocks (green) to zero, the green (currently 100,452.15) would match the initial value of 11,453.13. The PV() formula is already in cell G6 (initial value) = pv(5%/2, 30*2, -3,250,0) = 100,453.12; your monthly period is fine, it's just that Tuckman defined it differently for some reason Tuckman uses semi-annual mortgage payments, I agree that it's unusual. The new (3rd edition) of this text drops the mortgage and uses a C-strip instead. Here, I was just interested in matching his calcs and he used semi-annual. Of course, the whole thing can be done with monthly periods. Thanks,