||.......|| Suggested format for Asking Portfolio Questions (edit original post)Maturity Coupon Bid Asked Chg Yield* Accrued principal
2012 Jul 15 3.000 100.08 100.08 unch. -0.584 1278
2013 Apr 15 0.625 100.15 100.16 - 2 0.029 1087
2014 Jan 15 2.000 104.14 104.15 + 1 -0.822 1243
||.......|| Suggested format for Asking Portfolio Questions (edit original post)
||.......|| Suggested format for Asking Portfolio Questions (edit original post)
Kevin M wrote:Thanks for chiming in Larry. Haven't you pointed out that the large inflation factor is not so much of a concern, since a nominal loss would be due to deflation, meaning that the real return still would be positive (or at least not negative)? This is exactly the point I'm most interested in, as it seems that it's the key to this apparent anomaly.
||.......|| Suggested format for Asking Portfolio Questions (edit original post)richard wrote:Kevin, if the idea is to lock in a real return, you can ignore the inflation factor and the level of inflation / deflation. A low inflation factor may give you a bonus if there's inflation, but a high factor won't change your real returns even if there is deflation.
||.......|| Suggested format for Asking Portfolio Questions (edit original post)Kevin M wrote:So why is Larry talking about deflation as the risk here? It's only a risk to the nominal return, not the real return.
||.......|| Suggested format for Asking Portfolio Questions (edit original post)Kevin M wrote:I think maybe I've got it. If there is deflation, even money earning 0% in a money market will provide a better real return than the TIPS. I actually have some in a MM, and was thinking of putting at least some of that into this TIPS.
I agree. So I've made an estimate that takes seasonal adjustment into account. I've made the following assumptions:market timer wrote:With such a short term instrument, accounting for seasonality is critical.
Seasonal Not
Seasonally Adjustment Seasonally
Adjusted Factor Adjusted
---------- ---------- ----------
0.99700 0.3% decrease June (same as May)
1.01162 Increase July - Jan: 7 months @ 2% / year
1.00858 99.303% 1.00155 June - Jan
1.00165 Increase Feb @ 2% / year
1.01025 98.990% 1.00005 June - Feb 229.946 Mon 06/25/12 **
229.815 Wed 08/01/12 **
230.172 Mon 04/01/13 (229.815 X 1.00155)
229.826 Wed 05/01/13 (229.815 X 1.00005)
230.010 Mon 04/15/13 (average of 4/1 and 5/1)
0.03% % Chg 4/15/13 vs 6/25/12 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
------ ------ ------- ------- ------- ------- ------- ------- ------- ------ ------ ------
2010 99.640 99.698 100.088 100.293 100.459 100.349 100.166 100.115 100.034 99.859 99.709 99.440
2011 99.632 99.685 100.123 100.391 100.592 100.394 100.180 100.123 100.008 99.831 99.655 99.401
||.......|| Suggested format for Asking Portfolio Questions (edit original post)#Cruncher wrote:So, given my assumptions (and further assuming I've done the calculations correctly), there would be no significant inflation adjustment to these TIPS between now and maturity.
It looks that way. Today's yields for the 4/15/2013 nominal versus the 4/15/2013 TIPS implies a break-even CPI not seasonally adjusted change, of -0.1%. * I.e., if the Reference CPI fell 0.1% from 6/25/2012 to 4/15/2013 the nominal return on the two securities would be the same.market timer wrote:... we should consider 2.0% as a sort of break-even seasonally adjusted inflation rate ... If realized inflation is above this rate, the investor profits.
100.17 = 100 X 1.00207^(294/365) Nominal Treasury maturing 4/13/2013 with YTM of 0.207%
100.27 = 100 X 1.00338^(294/365) TIPS maturing 4/13/2013 with YTM of 0.338%
-0.1% = 100.17 / 100.27 - 1#Cruncher wrote:If anyone buys these, I'd be interested to know your broker, the bid/ask when you placed the order, and what price you actually got.
#Cruncher wrote:Edit 12:00 PM 6/22/12: Bought at Vanguard an hour ago at price of 100.2891 = YTM of +0.263%. When placed order the spread was 0.334/0.266 so I got a YTM slightly less than the ask. But I'm still happy.
tarnation wrote:#Cruncher wrote:Edit 12:00 PM 6/22/12: Bought at Vanguard an hour ago at price of 100.2891 = YTM of +0.263%. When placed order the spread was 0.334/0.266 so I got a YTM slightly less than the ask. But I'm still happy.
I got a price close to that, but my yield calc was different. What is the settlement date on that?
Actually, in this case today + 3 is correct because Treasuries settle the next business day which is Monday. I suspect any discrepancy your spreadsheet got was because this bond has so little time to mature and is therefore more sensitive to how the YTM (aka Internal Rate of Return) is calculated. I just calculated it again with FICALC, and using a price of 100.2891 and a 6/25/2012 settlement date, it returned a 0.266% YTM. (I don't know how I got the 0.263% reported in my previous post.)tarnation wrote:DUH, go[t] it. My excel spreadsheet uses TODAY()+3 for settle date, which is not correct due to the weekend.tarnation wrote:I got a price close to that, but my yield calc was different. What is the settlement date on that?#Cruncher wrote:Bought at Vanguard an hour ago at price of 100.2891 = YTM of +0.263%.
06/25/12 -100.4103 = 100.2891 + accrued interest of 0.1212 (0.3125 X 71/183)
10/15/12 0.3125
04/15/13 100.3125tarnation wrote:They're baack. Got some today at 0.36% (100.109).
Doc wrote:Are you making enough to buy a Starbucks?
seems like the price always drops after I buy.Doc wrote:tarnation wrote:They're baack. Got some today at 0.36% (100.109).
You paid too much.
Maturity Coupon Bid Asked Chg Yield* Accrued principal
2013 Apr 15 0.625 100.01 100.01 unch. 0.551 1092
(Decimals are in 32nds so price was 100.0313)
Schwab is showing them with a little higher yield at 14:46 Friday.)
Thursday, November 15, 2012 closing
http://online.wsj.com/mdc/public/page/2 ... nav_2_3010
(There was no quote for the January maturity. You probably bought all of them. Or maybe there wasn't one.)
Are you making enough to buy a Starbucks?
tfb wrote:Doc wrote:Are you making enough to buy a Starbucks?
I was wondering how the positive yield translate into dollars with only less than 6 months to maturity.
tarnation wrote:If I'm lucky. I guess if I really wanted to preserve my coffee purchasing power, coffee commodity futures would be the thing.
Doc wrote:tfb wrote:Doc wrote:Are you making enough to buy a Starbucks?
I was wondering how the positive yield translate into dollars with only less than 6 months to maturity.tarnation wrote:If I'm lucky. I guess if I really wanted to preserve my coffee purchasing power, coffee commodity futures would be the thing.
I've been rolling a significant amount of 28 day t-bills until the fiscal cliff situtation gets more stable and I do measure the "profit" by the number of Starbucks I can buy. Unfortunately it is in the low single digits provided I save up for a couple of months. But all is not lost. I have several empty Starbucks bags I can turn in for a free "tall".
tarnation wrote:Doc wrote:
I've been rolling a significant amount of 28 day t-bills until the fiscal cliff situtation gets more stable and I do measure the "profit" by the number of Starbucks I can buy. Unfortunately it is in the low single digits provided I save up for a couple of months. But all is not lost. I have several empty Starbucks bags I can turn in for a free "tall".
If inflation is flat until 4/15, looks like I may make enough to buy one tall Cappuccino per bond. what is the deal with the bags??
With today's release of the February CPI we know what the Reference CPI will be when these TIPS mature on 4/15/2013. At 231.16013 it's a little higher than my "guesstimate" of 230.010. (See TreasuryDirect 0-5/8% 5-YEAR TIPS Due April 15, 2013 Ref CPI and Index Ratios for April 2013.)#Cruncher on 6/22/2012 wrote:And now [my estimate of] the Reference CPI that is used to determine TIPS inflation adjustment:So, given my assumptions (and further assuming I've done the calculations correctly
- Code: Select all
229.946 Mon 06/25/12 [settlement date for purchase 6/22/2012]
...
230.010 Mon 04/15/13 (average of 4/1 and 5/1)
0.03% % Chg 4/15/13 vs 6/25/12), there would be no significant inflation adjustment to these TIPS between now and maturity.
Here is how it will turn out (per $1,000 bond):#Cruncher wrote:Edit 12:00 PM 6/22/12: Bought at Vanguard an hour ago at price of 100.2891 = YTM of +0.263%.
--- Before Inflation Adjustment --- Index --- After Inflation Adjustment ---
Principal Interest Total Ref CPI Ratio Principal Interest Total
----------- -------- --------- --------- ------- ----------- -------- ---------
06/25/12 (1,002.891) (1.212) (1,004.103) 229.94640 1.08791 (1,091.055) (1.319) (1,092.374)
10/15/12 - 3.125 3.125 229.67981 1.08664 - 3.396 3.396
04/15/13 1,000.000 3.125 1,003.125 231.16013 1.09365 1,093.650 3.418 1,097.068
----------- -------- --------- ----------- -------- ---------
Total (2.891) 5.038 2.147 2.595 5.494 8.089
YTM 0.266% 0.922%Return to Investing - Theory, News & General
Users browsing this forum: Abe, dickenjb, Five Scoop, gerrym51, Investing is boring, matjen, MossySF, nyinca, pkcrafter, rosenbaga, Sheepdog, Torg Fadum, WhiskeyJ and 52 guests