2013 | 2014 | ||||||
Price: | 80.00 | EPS | $0.00 | $0.00 | |||
Shares Out. (in M): | 1 | P/E | 0.0x | 0.0x | |||
Market Cap (in $M): | 1 | P/FCF | 0.0x | 0.0x | |||
Net Debt (in $M): | 0 | EBIT | 0 | 0 | |||
TEV (in $M): | 0 | TEV/EBIT | 0.0x | 0.0x |
Sign up for free guest access to view investment idea with a 45 days delay.
$750,000,000 6.5% series 2007A-2 Senior Current Interest Turbo Bonds due June 1, 2047.
CUSIP 118217AT5
In a yield starved world I believe the Buckeye Tobacco Settlement bonds represent an attractive risk reword opportunity. In the last four months these bonds have sold off substantially from a trading range in the mid-90s all the way down to the high-60s, and are now trading in the mid 70s. Prices have not been this low since 2011. The selloff has occurred partly because of the overall rise in treasury rates, uncertainty in future MSA payments as a result of higher than expected decreases in smoking, and the rise in popularity of e-cigarettes and alternative nicotine products which do not pay into Ohio’s Master Settlement Agreement (MSA) fund. In risk and tax adjusted terms, I’m hard pressed to find more attractive yields. With a current price around $80 for the 6.5% coupon maturing 2047 bonds, the after tax equivalent yield at the highest marginal federal rate of 39.6% is 15.55%. However, given the current cigarette decline rates, I don’t believe these bonds will pay according to their full interest and principal payment schedules. With that said, I intend to show why these still represent a good investment.
These bonds are backed solely by the state’s perpetual assignment of their cigarette consumption receipts and strategic payment by the cigarette companies as part of the MSA. If cigarette consumption declines faster than expected there will not be enough funds to pay off interest or redeem maturing bonds. Even with aggressive cigarette decline rates these bonds at their current price levels represent an attractive return. Both retail and institutional investors fail to understand how to price these bonds. In the event that there are not enough MSA payments to cover interest and principal payments, the senior bonds will continue in perpetuity until they have been fully redeemed or people stop smoking. These bonds should be priced on the IRR of the MSA payments and not based on their ratings or some spread over treasuries.
I’m recommending a position in the Series 2007A-2 Senior Current Interest Turbo Term Bonds. I prefer the bonds with the highest coupons and the longest duration, however, I believe any within this series represent an attractive risk adjusted yield.
CUSIPs in the 2007A-2 Senior Current Interest Turbo Term Bonds
CUSIP Maturity Coupon
118217AP3 June 1, 2024 5.125%
118217AN8 June 1, 2024 5.375%
118217AQ1 June 1, 2030 5.875%
118217AR9 June 1, 2034 5.750%
118217AS7 June 1, 2042 6.000%
118217AU2 June 1, 2047 6.070%
118217AT5 June 1, 2047 6.500%
History:
Before we jump into the analysis of these bonds let me provide you with some quick background information on the Master Settlement Agreement (MSA) which is the genesis for all the state’s tobacco bonds. In November of 1998 Philip Morris Inc., R. J. Reynolds, Brown and Wiliamson and Lorillard collectively known as the original participating manufacturers (OPMs), collectively representing 86.8% of the cigarette market share, arrived at an agreement with 46 States and territories (Settling States) to resolve cigarette smoking related litigation. The agreement arrived at between these parties, known as the Master Settlement Agreement (MSA), released the OPMs from past and present smoking-related claims and provided for a continuing release of future smoking claims, in exchange for certain payments to be made to the Settling States in addition to certain strategic payments and advertising/marketing restrictions.
Tobacco companies who did not join the MSA agreement at inception were invited to do so after the fact and are referred to as Subsequent Participating Manufacturers (SPMs), while the collective signers of the MSA agreement are known as Participating Manufactures (PMs). Tobacco companies who have chosen not to join the MSA are referred to as Non-Participating Manufacturers (NPMs). NPMs unlike PMs are subject to class action law suits from smokers who have been harmed by their products. Some smaller tobacco firms and some new entrants into the space will choose not to join the MSA since they may view the risk of a class action law suit as minimal and believe they will benefit from not having to comply with marketing restrictions. NPMs have been required by the state to pay into escrow accounts at a rate equivalent to the amount they would have had to have paid if they were a member of the MSA. These funds are used in the event that the NPM is sued and is unable to pay. These payments also act to counter balance any unfair competitive advantage NPMs would have obtained over PMs via price.
Subsequent to the creation of the MSA many states have elected to securitize the payment streams from the tobacco companies and issue bonds. About $40 billion of tobacco bonds have been issued by states, counties, cities and territories. These bonds have been backed by $200 billion in payments from the participating manufacturers.
Disputes and Recent News:
Starting in 2003, participating manufacturers challenged 15 of the settling states over allegations that the settling states failed to adequately enforce the collection of payments from NPMs into the escrow accounts. If this is proven it entitles participating manufactures to lower payments to the settling states. A decision was reached on September 12th of 2013 for the 2003 payments. Of the 15 states that were challenged, nine won the arbitration, proving they had adequately enforced their end of the agreement. This freed up $35 million for the State of Ohio and provides a needed boost for the Ohio Buckeye Tobacco bonds. Moving forward this victory for the State of Ohio should greatly enhance its chances of winning arbitration over other disputed years, which have yet to be resolved. Starting in 2004-2005 the settling states began to increase their enforcement of the escrow requirements of the NPM. This should further increase the likeness that Ohio will win any future arbitration battles of the PMs. Trading on Friday the 13th, 2013 seems to indicate the bond market has recognized the benefits of this settlement. The Ohio Buckeye Bonds traded up from the previous days rising as much at $10 into Monday.
Evaluation
The decline rate of US Cigarette consumption has been higher than what was projected when these bonds were underwritten. This has been caused by a number of factors. The States have aggressively raised taxes on cigarettes and “TheTruth.Com” campaign and similar anti-smoking efforts have been effective in lowering tobacco consumption. Since the signing of the MSA cigarette smoking in restaurants, bars and public places has been restricted eroding tobacco sales even more. The recession has also taken its toll on consumption. Smoking is an expensive habit and a pack of cigarettes costs on average about $6.22 in the state of Ohio. A pack a day adds up quickly to a $2,270 annual expense. Average discretionary income in the US ranges between $7,000 and $10,000, meaning a pack a day habit costs the average person between 23% and 32% of their discretionary income. Contrary to popular belief, cigarette consumption is not price inelastic. Most studies show that cigarettes have an elasticity of demand between -0.25 and -0.5 meaning a 10% increase in cigarette prices should yield a 2.5% and 5% decline in consumption. Since this bond issuance in 2007, the Price of a pack of Cigarettes has increased 25%.
|
Cost/Pack in Ohio |
Federal & State of Ohio Taxes/Pack |
Cigarette Consumption (Pack Sales Per Capita) |
1998 |
$ 1.932 |
$ 0.480 |
106.40 |
1999 |
$ 2.654 |
$ 0.480 |
104.00 |
2000 |
$ 2.793 |
$ 0.580 |
99.90 |
2001 |
$ 3.102 |
$ 0.580 |
100.00 |
2002 |
$ 3.592 |
$ 0.940 |
96.80 |
2003 |
$ 3.588 |
$ 0.940 |
90.20 |
2004 |
$ 3.496 |
$ 0.940 |
85.90 |
2005 |
$ 4.097 |
$ 1.640 |
89.00 |
2006 |
$ 4.190 |
$ 1.640 |
70.50 |
2007 |
$ 4.414 |
$ 1.640 |
67.80 |
2008 |
$ 4.480 |
$ 1.640 |
64.70 |
2009 |
$ 5.370 |
$ 2.260 |
61.60 |
2010 |
$ 5.836 |
$ 2.260 |
59.30 |
2011 |
$ 5.614 |
$ 2.260 |
56.80 |
2012 |
$ 5.525 |
$ 2.260 |
55.70 |
Lastly new forms of nicotine delivery have entered the market. E-Cigarette sales are exploding, growing from $500 million in 2012 to an expected level of $1.7 billion by year’s end 2013. E-Cigarettes do not have to pay into the MSA and are not subject to the same marketing restrictions. A refill package for an E-Cigarette sells for about $2 and are roughly equivalent to of a pack of cigarettes making them a relative bargain compared to traditional tobacco products. Bonnie Herzog of Wells Fargo has predicted that E-Cigarettes sales will surpass regular cigarette sales by 2021. Countering this explosive growth is the likelihood that the FDA will step in and add more oversight of the 200 plus e-cigarette manufacturers.
Payments of the Bonds
The senior, Series A bonds are first in the payment waterfall. In the event that tobacco settlement payments are less than the interest and or principal payments for a given year the reserve funds can be tapped to fill this hole. The reserve fund cannot be used for the other bond series until the Series A bonds have been redeemed.
“So long as no payment default has occurred, all payments of the bond obligation of the bonds made from collections will be credited against serial bond maturities and sinking fund installments and turbo term bond maturities in accordance with the payment priorities, within a priority in chronological order, and pro rata among bonds within the same payment priority as to which such payments are due on the same date, as more fully described in the indenture. The senior liquidity reserve account is available to pay the principal if the senior bonds, including the series 2007A bonds, on their maturity dates. Failure to pay the principal of the senior bonds on its maturity date will constitute a payment default, which is an event of a default under the indenture, in which case all future payments will be made on a pro rata basis subject to the payment priorities.”
The MSA payments to the Settling States is based on predetermined cash flow schedule and is annual adjusted based on a series of factors. The following are descriptions of the seven factors used for calculating the MSA Payments.
The Inflation Adjustment
Each year the MSA uses the greater of 3% or the actual Consumer Price Index for All Urban Consumer (CPI). In the years 2000, 2004, 2005, the following actual CPI inflation numbers were used 3.4%, 3.256% and 3.416% respectively.
The Volume Adjustment
The following schedule shows the annual change in cigarette consumption in the US and is used when determining the MSA payments from the cigarette companies.
Year |
Cigarettes Sold |
Decline Rate |
1999 |
441,690,449,772 |
|
2000 |
435,946,870,477 |
-1.30% |
2001 |
429,357,279,677 |
-1.51% |
2002 |
417,863,956,118 |
-2.68% |
2003 |
404,070,872,403 |
-3.30% |
2004 |
404,439,437,545 |
0.09% |
2005 |
390,250,461,641 |
-3.51% |
2006 |
391,256,200,479 |
0.26% |
2007 |
371,832,985,002 |
-4.96% |
2008 |
357,738,164,976 |
-3.79% |
2009 |
325,043,393,187 |
-9.14% |
2010 |
304,079,384,247 |
-6.45% |
2011 |
295,956,448,904 |
-2.67% |
2012 |
290,102,238,941 |
-1.98% |
CAGR |
-2.958% |
Total Net Market (RYO RYO @ 0.0325 ounces per cigarette conversion rate): Data MSAi
The Non-Settling States Reduction
The Non-Settling States Reduction was not applied to the annual payments and strategic contribution payment because such reduction has no effect on the amount of payments to be received by a State that remains a part to the MSA. The Cash Flow Assumptions include an assumption that the state will remain a party to the MSA.
The NPM Adjustment
The NPM Adjustment has not been applied to date. This adjustment comes into effect if the tobacco companies are able to prove that the State has failed to adequately enforce the escrow payment requirements of NPMs. The dispute I discussed before that was settled on September 12th 2013 is an example of this. If the Tobacco companies where able to prove that the State had failed to live up to its enforcement requirement of the MSA they’d have been able to apply an adjustment on their MSA payments to lower them.
The Offset for Miscalculated or Disputed Payments
This adjustment allows for increases or decreases to be made in the MSA payments in the event of a miscalculation of a prior year’s payment (limited to 4 year look back).
The Litigating Releasing Parties Offset
This is an adjustment that allows for a dollar for dollar offset in MSA payments in the event that a Releasing State pursues litigation against a Participating Manufacturer for a claim that was released under the MSA agreement. This adjustment is applied only to the MSA payments made to the State that has perused litigation against a Participating Manufacturer and is only applied if the Participating Manufacturer has taken all reasonable and ordinary actions to defend itself.
The Offset for Claims-Over
In the event that a Releasing State pursues a claim against a NPM and the NPM in turn pursues a claim for contribution or indemnification against a Participating Manufacturer, this adjustment allows for a dollar for dollar offset against the Participating Manufacturer’s MSA payments. This is a state specific adjustment and is only allocable on claims that were releases by the Participating Sates in the MSA agreement.
MSA Base case
Year |
Base Annual Payments |
Strategic Payments |
2000 |
$4,500,000,000 |
$861,000,000 |
2001 |
$5,000,000,000 |
$861,000,000 |
2002 |
$6,500,000,000 |
$861,000,000 |
2003 |
$6,500,000,000 |
$861,000,000 |
2004 |
$8,000,000,000 |
$861,000,000 |
2005 |
$8,000,000,000 |
$861,000,000 |
2006 |
$8,000,000,000 |
$861,000,000 |
2007 |
$8,000,000,000 |
$861,000,000 |
2008 |
$8,139,000,000 |
$861,000,000 |
2009 |
$8,139,000,000 |
$861,000,000 |
2010 |
$8,139,000,000 |
$861,000,000 |
2011 |
$8,139,000,000 |
$861,000,000 |
2012 |
$8,139,000,000 |
$861,000,000 |
2013 |
$8,139,000,000 |
$861,000,000 |
2014 |
$8,139,000,000 |
$861,000,000 |
2015 |
$8,139,000,000 |
$861,000,000 |
2016 |
$8,139,000,000 |
$861,000,000 |
2017 |
$8,139,000,000 |
$861,000,000 |
2018 |
$9,000,000,000 |
|
2019 |
$9,000,000,000 |
|
2020 |
$9,000,000,000 |
Ohio is entitled to 5.0375098% of the each annual payment and 2.7819695% of each strategic fund payment.
Senior Liquidity Reserve
The series 2007 bonds were funded with a reserve account equal to $389,231,603.13. The reserve account is supposed to be maintained at this level so long as the Series 2007A bonds are outstanding, however, the current balance of this reserve account is $383,159,831.90. These funds can only be used to pay the Series 2007A bonds and not be used on the subordinate bonds until all the Series 2007A bonds have been redeemed.
Assumptions
For the purposes of modeling these bonds I held constant everything except the cigarette decline rates. The decline rate for the 2011 was 2.67%, 1.98% for 2012 and the current decline rate is running around 5% for the first half of 2013, but should normalize back down to the 3% range. I expect moving forward that declines rates will stay around 3% per year. It’s important to remember when we talk about these decline rates, these are compounding annual rates. Every year we are saying the cigarette consumption will fall by 3% meaning in 5 years consumption would have fallen by more than 15%. Not an insignificant sum for a highly addictive product. Counteracting declines in consumption is a minimum 3% annual increase for inflation.
Because of the number of adjustments and factors used in calculating these bonds it’s difficult to show my model. I used the formula exactly as it its presented in the Buckeye Tobacco Settlement Financing Authority perspective and as it is described in the MSA agreement. I do my best to illustrate the MSA payments to show how this will affect the funding for the bonds.
To be conservative I’ve used a 5% decline rate. This is significantly higher than the current 3% rate we have seen.
Bear Case
Ohio MSA Payments |
Operating Expenses |
Serial Payments |
Starting Balance Reserve |
Funds Available |
Total Interest Due |
Interest Paid From Reserve |
Interest Coverage |
Total Principal Scheduled |
CF Available to Principal |
Principal Paid From Reserve |
Ending Balance Reserve |
Principal Coverage |
|
2014 |
$296,741,602 |
$298,513 |
$23,995,000 |
$340,891,952 |
$272,448,089 |
$288,050,630 |
$15,602,541 |
100% |
$26,660,000 |
$0 |
$26,660,000 |
$303,219,636 |
100% |
2015 |
$335,689,727 |
$307,469 |
$26,640,000 |
$304,601,999 |
$308,742,259 |
$286,470,105 |
$0 |
108% |
$29,600,000 |
$22,272,154 |
$7,327,846 |
$293,182,946 |
100% |
2016 |
$333,788,498 |
$316,693 |
$35,000,000 |
$303,219,636 |
$298,471,805 |
$285,092,180 |
$0 |
105% |
$29,165,000 |
$13,379,625 |
$15,785,375 |
$269,116,532 |
100% |
2017 |
$326,035,290 |
$326,194 |
$38,995,000 |
$293,182,946 |
$286,714,096 |
$283,562,305 |
$0 |
101% |
$32,495,000 |
$3,151,791 |
$29,343,209 |
$229,604,065 |
100% |
2018 |
$334,976,383 |
$335,979 |
$269,116,532 |
$334,640,403 |
$282,054,911 |
$0 |
119% |
$96,600,000 |
$52,585,492 |
$44,014,508 |
$176,337,692 |
100% |
|
2019 |
$330,237,489 |
$346,059 |
$229,604,065 |
$329,891,430 |
$280,375,405 |
$0 |
118% |
$106,240,000 |
$49,516,025 |
$56,723,975 |
$85,827,753 |
100% |
|
2020 |
$298,646,247 |
$356,441 |
$176,337,692 |
$298,289,807 |
$275,382,643 |
$0 |
108% |
$115,100,000 |
$22,907,164 |
$92,192,836 |
$0 |
100% |
|
2021 |
$287,770,005 |
$367,134 |
$85,827,753 |
$287,402,871 |
$269,891,630 |
$0 |
106% |
$125,508,000 |
$17,511,241 |
$47,134,631 |
$0 |
52% |
|
2022 |
$282,466,801 |
$378,148 |
$0 |
$282,088,654 |
$263,942,693 |
$0 |
107% |
$130,635,000 |
$18,145,961 |
$0 |
$0 |
9% |
|
2023 |
$277,304,132 |
$389,492 |
$0 |
$276,914,640 |
$260,601,471 |
$0 |
106% |
$135,165,000 |
$16,313,169 |
$0 |
$0 |
5% |
|
2024 |
$272,279,771 |
$401,177 |
$0 |
$271,878,594 |
$259,961,675 |
$0 |
105% |
$147,445,000 |
$11,916,919 |
$0 |
$0 |
3% |
|
2025 |
$267,391,564 |
$413,212 |
$0 |
$266,978,352 |
$259,599,060 |
$0 |
103% |
$107,700,000 |
$7,379,292 |
$0 |
$0 |
1% |
|
2026 |
$262,637,428 |
$425,609 |
$0 |
$262,211,819 |
$259,399,340 |
$0 |
101% |
$109,600,000 |
$2,812,479 |
$0 |
$0 |
0% |
|
2027 |
$258,015,349 |
$438,377 |
$0 |
$257,576,972 |
$259,315,746 |
$0 |
99% |
$111,500,000 |
-$1,738,774 |
$0 |
$0 |
0% |
|
2028 |
$253,523,384 |
$451,528 |
$0 |
$253,071,856 |
$261,130,153 |
$0 |
97% |
$117,700,000 |
-$8,058,298 |
$0 |
$0 |
0% |
|
2029 |
$249,159,657 |
$465,074 |
$0 |
$248,694,583 |
$267,823,287 |
$0 |
93% |
$119,000,000 |
-$19,128,705 |
$0 |
$0 |
0% |
|
2030 |
$244,922,361 |
$479,026 |
$0 |
$244,443,334 |
$279,548,181 |
$0 |
87% |
$122,100,000 |
-$35,104,847 |
$0 |
$0 |
0% |
|
2031 |
$240,809,755 |
$493,397 |
$0 |
$240,316,358 |
$296,468,853 |
$0 |
81% |
$114,035,000 |
-$56,152,495 |
$0 |
$0 |
0% |
|
2032 |
$236,820,168 |
$508,199 |
$0 |
$236,311,969 |
$318,760,891 |
$0 |
74% |
$123,405,000 |
-$82,448,922 |
$0 |
$0 |
0% |
|
2033 |
$232,951,991 |
$523,445 |
$0 |
$232,428,546 |
$346,612,072 |
$0 |
67% |
$129,790,000 |
-$114,183,526 |
$0 |
$0 |
0% |
|
2034 |
$229,203,684 |
$539,148 |
$0 |
$228,664,536 |
$380,223,019 |
$0 |
60% |
$137,970,000 |
-$151,558,484 |
$0 |
$0 |
0% |
|
2035 |
$225,573,770 |
$555,323 |
$0 |
$225,018,448 |
$419,807,900 |
$0 |
54% |
$115,300,000 |
-$194,789,452 |
$0 |
$0 |
0% |
|
2036 |
$222,060,839 |
$571,982 |
$0 |
$221,488,856 |
$465,595,163 |
$0 |
48% |
$124,600,000 |
-$244,106,307 |
$0 |
$0 |
0% |
|
2037 |
$218,663,542 |
$589,142 |
$0 |
$218,074,400 |
$517,828,325 |
$0 |
42% |
$135,900,000 |
-$299,753,924 |
$0 |
$0 |
0% |
|
2038 |
$215,380,598 |
$606,816 |
$0 |
$214,773,782 |
$576,766,796 |
$0 |
37% |
$176,750,000 |
-$361,993,014 |
$0 |
$0 |
0% |
|
2039 |
$212,210,787 |
$625,021 |
$0 |
$211,585,766 |
$642,686,767 |
$0 |
33% |
$184,290,000 |
-$431,101,001 |
$0 |
$0 |
0% |
|
2040 |
$209,152,953 |
$643,771 |
$0 |
$208,509,181 |
$715,882,138 |
$0 |
29% |
$195,965,000 |
-$507,372,957 |
$0 |
$0 |
0% |
|
2041 |
$206,206,003 |
$663,084 |
$0 |
$205,542,918 |
$796,665,510 |
$0 |
26% |
$205,190,000 |
-$591,122,591 |
$0 |
$0 |
0% |
|
2042 |
$203,368,908 |
$682,977 |
$0 |
$202,685,931 |
$885,369,232 |
$0 |
23% |
$216,235,000 |
-$682,683,301 |
$0 |
$0 |
0% |
|
2043 |
$200,640,700 |
$703,466 |
$0 |
$199,937,234 |
$982,346,517 |
$0 |
20% |
$249,160,000 |
-$782,409,283 |
$0 |
$0 |
0% |
|
2044 |
$198,020,475 |
$724,570 |
$0 |
$197,295,905 |
$1,087,972,616 |
$0 |
18% |
$264,725,000 |
-$890,676,711 |
$0 |
$0 |
0% |
|
2045 |
$195,507,392 |
$746,307 |
$0 |
$194,761,085 |
$1,202,646,071 |
$0 |
16% |
$281,195,000 |
-$1,007,884,986 |
$0 |
$0 |
0% |
|
2046 |
$193,100,671 |
$768,697 |
$0 |
$192,331,975 |
$1,326,790,036 |
$0 |
14% |
$297,515,000 |
-$1,134,458,061 |
$0 |
$0 |
0% |
|
2047 |
$190,799,595 |
$791,757 |
$0 |
$190,007,838 |
$1,460,853,680 |
$0 |
13% |
$312,690,000 |
-$1,270,845,843 |
$0 |
$0 |
0% |
|
2048 |
$188,603,510 |
$815,510 |
$0 |
$187,788,000 |
$1,605,313,680 |
$0 |
12% |
-$1,417,525,680 |
$0 |
$0 |
0% |
||
2049 |
$186,511,824 |
$839,976 |
$0 |
$185,671,848 |
$1,760,675,788 |
$0 |
11% |
-$1,575,003,940 |
$0 |
$0 |
0% |
||
2050 |
$184,524,007 |
$865,175 |
$0 |
$183,658,833 |
$1,927,476,510 |
$0 |
10% |
-$1,743,817,677 |
$0 |
0% |
To price these bonds, I used the model illustrated above against the scheduled payments for a long duration 6.5% coupon maturing 2047 and a shorter duration 5.375% maturing 2024. These should highlight the methodology I’m using and give an idea of what these bonds should actually yield over their life. The big concept here is that an investor is unlikely to receive his principal payment at the end of these cash flows because the decline rate of the MSA payments will exceed the initial project. However, because the current yield is high enough, an investor is more than compensated for this.
118217AT5 Coupon 6.5% due 2047
Assumed Purchase Price of $80
Cash Flows |
|
|
|
IRR |
7.669% |
|
|
Year |
CF |
Curr. Yield |
Cum CF |
Purchase |
$ (80.00) |
NA |
$ (80.00) |
2013 |
6.50 |
8.13% |
(73.50) |
2014 |
6.50 |
8.13% |
(67.00) |
2015 |
6.50 |
8.13% |
(60.50) |
2016 |
6.50 |
8.13% |
(54.00) |
2017 |
6.50 |
8.13% |
(47.50) |
2018 |
6.50 |
8.13% |
(41.00) |
2019 |
6.50 |
8.13% |
(34.50) |
2020 |
6.50 |
8.13% |
(28.00) |
2021 |
6.50 |
8.13% |
(21.50) |
2022 |
6.50 |
8.13% |
(15.00) |
2023 |
6.50 |
8.13% |
(8.50) |
2024 |
6.50 |
8.13% |
(2.00) |
2025 |
6.50 |
8.13% |
4.50 |
2026 |
6.50 |
8.13% |
11.00 |
2027 |
6.50 |
8.13% |
17.50 |
2028 |
6.40 |
8.00% |
23.90 |
2029 |
6.29 |
7.87% |
30.20 |
2030 |
6.19 |
7.73% |
36.38 |
2031 |
6.08 |
7.60% |
42.47 |
2032 |
5.98 |
7.48% |
48.45 |
2033 |
5.89 |
7.36% |
54.34 |
2034 |
5.80 |
7.25% |
60.14 |
2035 |
5.71 |
7.14% |
65.85 |
2036 |
5.62 |
7.03% |
71.47 |
2037 |
5.54 |
6.93% |
77.01 |
2038 |
5.46 |
6.83% |
82.47 |
2039 |
5.39 |
6.73% |
87.86 |
2040 |
5.31 |
6.64% |
93.17 |
2041 |
5.24 |
6.55% |
98.41 |
2042 |
5.18 |
6.47% |
103.59 |
2043 |
5.11 |
6.39% |
108.70 |
2044 |
5.05 |
6.32% |
113.76 |
2045 |
5.00 |
6.24% |
118.75 |
2046 |
4.94 |
6.18% |
123.69 |
2047 |
4.89 |
6.11% |
128.58 |
2048 |
4.84 |
6.05% |
133.42 |
2049 |
4.79 |
5.99% |
138.22 |
2050 |
4.75 |
5.94% |
142.97 |
2051 |
4.71 |
5.89% |
147.68 |
2052 |
4.67 |
5.84% |
152.35 |
2053 |
4.64 |
5.80% |
156.99 |
2054 |
4.61 |
5.76% |
161.59 |
2055 |
4.58 |
5.72% |
166.17 |
118217AN8 coupon 5.375% due 2024
Assumed Purchase Price of $80
Cash Flows |
|
|
|
IRR |
7.377% |
|
|
Year |
CF |
Curr. Yield |
Cum CF |
Purchase |
$ (80.00) |
NA |
$ (80.00) |
2011 |
5.38 |
6.72% |
(74.63) |
2012 |
6.77 |
8.47% |
(67.85) |
2013 |
8.30 |
10.37% |
(59.55) |
2014 |
7.75 |
9.69% |
(51.80) |
2015 |
7.90 |
9.88% |
(43.90) |
2016 |
7.70 |
9.63% |
(36.19) |
2017 |
7.88 |
9.85% |
(28.32) |
2018 |
13.99 |
17.49% |
(14.33) |
2019 |
14.43 |
18.04% |
0.10 |
2020 |
14.74 |
18.42% |
14.84 |
2021 |
12.98 |
16.22% |
27.82 |
2022 |
3.82 |
4.77% |
31.64 |
2023 |
3.10 |
3.88% |
34.74 |
2024 |
2.17 |
2.71% |
36.91 |
2025 |
2.17 |
2.71% |
39.07 |
2026 |
2.17 |
2.71% |
41.24 |
2027 |
2.17 |
2.71% |
43.40 |
2028 |
2.13 |
2.67% |
45.54 |
2029 |
2.10 |
2.62% |
47.64 |
2030 |
2.06 |
2.58% |
49.70 |
2031 |
2.03 |
2.53% |
51.72 |
2032 |
1.99 |
2.49% |
53.71 |
2033 |
1.96 |
2.45% |
55.67 |
2034 |
1.92 |
2.41% |
57.59 |
2035 |
1.89 |
2.37% |
59.49 |
2036 |
1.86 |
2.33% |
61.35 |
2037 |
1.83 |
2.29% |
63.18 |
2038 |
1.80 |
2.25% |
64.98 |
2039 |
1.77 |
2.22% |
66.76 |
2040 |
1.75 |
2.18% |
68.50 |
2041 |
1.72 |
2.15% |
70.22 |
2042 |
1.69 |
2.12% |
71.92 |
2043 |
1.67 |
2.09% |
73.58 |
2044 |
1.64 |
2.06% |
75.23 |
2045 |
1.62 |
2.03% |
76.85 |
2046 |
1.60 |
2.00% |
78.45 |
2047 |
1.58 |
1.97% |
80.03 |
2048 |
1.56 |
1.95% |
81.58 |
2049 |
1.54 |
1.92% |
83.12 |
2050 |
1.52 |
1.90% |
84.64 |
2051 |
1.50 |
1.87% |
86.13 |
2052 |
1.48 |
1.85% |
87.62 |
2053 |
1.46 |
1.83% |
89.08 |
2054 |
1.45 |
1.81% |
90.53 |
2055 |
1.43 |
1.79% |
91.96 |
*note that I cut off payments past 2055, but I expect these bonds to continue to pay well beyond this point.
The other bonds in this series all trade roughly in line with these two bonds. By using a 5% cigarette consumption decline rate, these are conservative yield projections. Remember these are also tax free yields. I don’t think it makes sense for these bonds to be trading at a taxable equivalent of a 12.5%. While I do expect these bonds to default, they still represent an attractive investment and the market has mispriced them because of their complexity, institutional limitations and failure to price them based on IRR of the MSA payments which continue beyond a default. If you want me to address a specific bond pricing within this series please let me know in the comments and I can run it through my model.
show sort by |
Are you sure you want to close this position Series 2007A-2 Senior Current Interest Turbo Term Bonds?
By closing position, I’m notifying VIC Members that at today’s market price, I no longer am recommending this position.
Are you sure you want to Flag this idea Series 2007A-2 Senior Current Interest Turbo Term Bonds for removal?
Flagging an idea indicates that the idea does not meet the standards of the club and you believe it should be removed from the site. Once a threshold has been reached the idea will be removed.
You currently do not have message posting privilages, there are 1 way you can get the privilage.
Apply for or reactivate your full membership
You can apply for full membership by submitting an investment idea of your own. Or if you are in reactivation status, you need to reactivate your full membership.
What is wrong with message, "".