TARP Warrants

[MrB]

1 If AIG issues Common Stock as a dividend or distribution to all holders of Common Stock, or subdivides or combines Common Stock, then the exercise price will be adjusted based on the following formula:

 

EP1 = EP0 x (OS0 / OS1) Say 5% stock dividend

 

EP1 = 42.86 = the exercise price in effect immediately after the record date

EP0 = 45.00 = the exercise price in effect at the close of business on the record date

OS0 = 1,899 = the number of shares of Common Stock outstanding at the close of business on the record date prior to giving effect to such event

OS1 = 1,994 = the number of shares of Common Stock that would be outstanding immediately after, and solely as a result of, such event

 

Upon any adjustment in the exercise price, each Warrant will evidence the right to purchase (A) the number of shares of Common Stock obtained by multiplying (B) the number of shares of Common Stock purchasable immediately prior to the adjustment by the © exercise price in effect immediately prior to the adjustment and dividing that product by the (D) exercise price in effect after the adjustment. All anti-dilution adjustment calculations will be made to the nearest hundredth of a cent or 1/1,000th of a share, as applicable. No adjustment will be required if the calculation results in a change to the exercise price of less than ten cents; however, any such amount will be carried forward and applied in any subsequent adjustment of the exercise price.

A = (B*C)/D

A = 1,994 = each Warrant will evidence the right to purchase the number of shares of Common Stock

B = 1,899 = the number of shares of Common Stock purchasable immediately prior to the adjustment

C = 45.00 = exercise price in effect immediately prior to the adjustment

D = 42.86 = exercise price in effect after the adjustment

 

[randallchsu]

I complied a list of TARP warrants that got auctioned off by Treasury on Seeking Alpha last year, hope you find it useful.

 

http://seekingalpha.com/article/315902-tarp-warrants-revisited-opportunities-exist-for-long-term-investors

[stahleyp]

Randall, thanks for that.

 

On another note, anyone know what happened to misterstockwell? He is considered a "guest" now.

[racemize]

Edit: Nevermind, another version was up.

[racemize]

Hi all, if you are trying to pull warrant prices into google spreadsheets, this will work:

 

=ImportData( "http://download.finance.yahoo.com/d/quotes.csv?s=JPM-WT&ql=1&f=l1")

 

(for JPM).  Haven't figured out how often it updates yet though.  I presume on the order of 20 minutes.

 

Edit: This appears to make it update fairly often:

 

=ImportData( "http://download.finance.yahoo.com/d/quotes.csv?s=JPM-WT&ql=1&f=l1"&"&workaround="&INT(NOW()/TIME(0;2;0))&REPT(GoogleFinance("GOOG");0))

[Grenville]

Hi all, if you are trying to pull warrant prices into google finance, this will work:

 

=ImportData( "http://download.finance.yahoo.com/d/quotes.csv?s=JPM-WT&ql=1&f=l1")

 

(for JPM).  Haven't figured out how often it updates yet though.  I presume on the order of 20 minutes.

 

Edit: This appears to make it update fairly often:

 

=ImportData( "http://download.finance.yahoo.com/d/quotes.csv?s=JPM-WT&ql=1&f=l1"&"&workaround="&INT(NOW()/TIME(0;2;0))&REPT(GoogleFinance("GOOG");0))

 

Thanks, that works!

[racemize]

I'm trying to get the SEC filings for a few warrants in order to get the dividend threshold amount--how do you look them up if you know the company ticker?

 

In particular, I'm looking for:

BPFH

LNC

SBNY

TCB

VLY

 

Thanks!

[compoundinglife]

I'm trying to get the SEC filings for a few warrants in order to get the dividend threshold amount--how do you look them up if you know the company ticker?

 

In particular, I'm looking for:

BPFH

LNC

SBNY

TCB

VLY

 

Thanks!

 

I actually setup a website to track warrants few years back, there might be some stuff you are looking for on it.

 

http://warrants.valueashram.com/

 

Go to "screen all warrants" then select "50" from the drop down list of # of items to display (it shows 10 by default).

 

I have not messed with it for a year or two so some of the data may be old or broken. In theory the prices should update regularly from yahoo finance. So yeah no promise the data is accurate :)

 

If there is interest I could update it to be more useful or have more data on it. At the moment it just pulls some stuff from yahoo finance (div, book value etc..) which is not always accurate.

[racemize]

I'm trying to get the SEC filings for a few warrants in order to get the dividend threshold amount--how do you look them up if you know the company ticker?

 

In particular, I'm looking for:

BPFH

LNC

SBNY

TCB

VLY

 

Thanks!

 

I actually setup a website to track warrants few years back, there might be some stuff you are looking for on it.

 

http://warrants.valueashram.com/

 

Go to "screen all warrants" then select "50" from the drop down list of # of items to display (it shows 10 by default).

 

I have not messed with it for a year or two so some of the data may be old or broken. In theory the prices should update regularly from yahoo finance. So yeah no promise the data is accurate :)

 

If there is interest I could update it to be more useful or have more data on it. At the moment it just pulls some stuff from yahoo finance (div, book value etc..) which is not always accurate.

 

Actually, that's exactly what I've been using--it just doesn't have the dividend adjustment threshold(that's mostly what I'm missing).  Do you have those somewhere?

 

More generally, I'm interested in knowing how to find the SEC filings for these, just to get my SEC-fu up.

 

Edit: Also, thank you very much for that website, it helped me find several of the warrants.  I think it is missing Sun trust and GM warrants, btw.

[compoundinglife]

I'm trying to get the SEC filings for a few warrants in order to get the dividend threshold amount--how do you look them up if you know the company ticker?

 

In particular, I'm looking for:

BPFH

LNC

SBNY

TCB

VLY

 

Thanks!

 

I actually setup a website to track warrants few years back, there might be some stuff you are looking for on it.

 

http://warrants.valueashram.com/

 

Go to "screen all warrants" then select "50" from the drop down list of # of items to display (it shows 10 by default).

 

I have not messed with it for a year or two so some of the data may be old or broken. In theory the prices should update regularly from yahoo finance. So yeah no promise the data is accurate :)

 

If there is interest I could update it to be more useful or have more data on it. At the moment it just pulls some stuff from yahoo finance (div, book value etc..) which is not always accurate.

 

Actually, that's exactly what I've been using--it just doesn't have the dividend adjustment threshold(that's mostly what I'm missing).  Do you have those somewhere?

 

More generally, I'm interested in knowing how to find the SEC filings for these, just to get my SEC-fu up.

 

Edit: Also, thank you very much for that website, it helped me find several of the warrants.  I think it is missing Sun trust and GM warrants, btw.

 

I just dug up my spreadsheet, it only has a few of the div hurdles and a few of the CUSIPs (which are handy for finding the prospectus in edgar or via google):

 

https://docs.google.com/spreadsheet/ccc?key=0AklQsl6HU-bedDg5QWw4SFRmdXBSXzUwcTZFZFpaN0E#gid=0

 

If you can corale any more data, I can put it on the site or update the tables to have more columns like the div reduction.

[PlanMaestro]

If you can corale any more data, I can put it on the site or update the tables to have more columns like the div reduction.

 

Here is the data for GM

 

http://www.cornerofberkshireandfairfax.ca/forum/investment-ideas/general-motors-gm/msg103240/#msg103240

 

I remember posting also the  data for the MTB, ZION, STI warrants in their respective threads.

[racemize]

I've got a lot of div hurdles in this spreadsheet:

 

https://docs.google.com/spreadsheet/ccc?key=0AhTPR9eP5nWedEF1SGVLdllJTnBMSDMzM3lYZ2d0SlE&usp=sharing

[bobp]

"More generally, I'm interested in knowing how to find the SEC filings for these, just to get my SEC-fu up."

 

You know you can search on Edgar? You've got to go back to between late 2008 for some and search around a lot but they're all there.

http://www.sec.gov/edgar/searchedgar/companysearch.html

 

This hasn't updated for some time but it's still online.

http://www.stockwarrants.com/about.htm

[blainehodder]

There should be a TARP warrant ETF.  Most of the underlying companies seem cheap.

[racemize]

"More generally, I'm interested in knowing how to find the SEC filings for these, just to get my SEC-fu up."

 

You know you can search on Edgar? You've got to go back to between late 2008 for some and search around a lot but they're all there.

http://www.sec.gov/edgar/searchedgar/companysearch.html

 

This hasn't updated for some time but it's still online.

http://www.stockwarrants.com/about.htm

 

Yes, I just don't know how to search for the TARP warrant prospectus for each one (e.g., if I look up BAC, there are tons and tons of filings--how do I search just for the warrants?).  I realize this is a newbie question, I just don't know how to do it.

[MrB]

"More generally, I'm interested in knowing how to find the SEC filings for these, just to get my SEC-fu up."

 

You know you can search on Edgar? You've got to go back to between late 2008 for some and search around a lot but they're all there.

http://www.sec.gov/edgar/searchedgar/companysearch.html

 

This hasn't updated for some time but it's still online.

http://www.stockwarrants.com/about.htm

 

Yes, I just don't know how to search for the TARP warrant prospectus for each one (e.g., if I look up BAC, there are tons and tons of filings--how do I search just for the warrants?).  I realize this is a newbie question, I just don't know how to do it.

 

BAC link was posted earlier in this thread.

[racemize]

"More generally, I'm interested in knowing how to find the SEC filings for these, just to get my SEC-fu up."

 

You know you can search on Edgar? You've got to go back to between late 2008 for some and search around a lot but they're all there.

http://www.sec.gov/edgar/searchedgar/companysearch.html

 

This hasn't updated for some time but it's still online.

http://www.stockwarrants.com/about.htm

 

Yes, I just don't know how to search for the TARP warrant prospectus for each one (e.g., if I look up BAC, there are tons and tons of filings--how do I search just for the warrants?).  I realize this is a newbie question, I just don't know how to do it.

 

BAC link was posted earlier in this thread.

 

Yes, I've got that one, but I'm trying to find several others I don't have the links to--I just would like the know the best way to find them using the SEC website.

[Uccmal]

I think you have to do it the old fashioned way.  Determine the approximate date and go through each and every filing.  Tedious.

[racemize]

I think you have to do it the old fashioned way.  Determine the approximate date and go through each and every filing.  Tedious.

 

my eye!

 

oh well, that's life I guess.

[berkshiremystery]

"More generally, I'm interested in knowing how to find the SEC filings for these, just to get my SEC-fu up."

 

You know you can search on Edgar? You've got to go back to between late 2008 for some and search around a lot but they're all there.

http://www.sec.gov/edgar/searchedgar/companysearch.html

 

This hasn't updated for some time but it's still online.

http://www.stockwarrants.com/about.htm

 

Yes, I just don't know how to search for the TARP warrant prospectus for each one (e.g., if I look up BAC, there are tons and tons of filings--how do I search just for the warrants?).  I realize this is a newbie question, I just don't know how to do it.

 

Racemize,...

 

there you go...

 

http://www.sec.gov/Archives/edgar/data/70858/000119312510044940/d424b7.htm

 

 

[PlanMaestro]

Suntrust

http://www.cornerofberkshireandfairfax.ca/forum/general-discussion/suntrust-tarp-warrants/msg98021/#msg98021

 

M&T

http://www.cornerofberkshireandfairfax.ca/forum/investment-ideas/mtb-mt-bank/msg95174/#msg95174

 

ZION

http://www.cornerofberkshireandfairfax.ca/forum/investment-ideas/zions-bancorp/msg93862/#msg93862

 

GM

http://www.cornerofberkshireandfairfax.ca/forum/investment-ideas/general-motors-gm/msg103240/#msg103240

 

HIG

http://www.cornerofberkshireandfairfax.ca/forum/general-discussion/hig-warrants/msg26162/#msg26162

[compoundinglife]

I think you have to do it the old fashioned way.  Determine the approximate date and go through each and every filing.  Tedious.

 

my eye!

 

oh well, that's life I guess.

 

There are some easier ways. Edgar has full text searching with an advanced search option that allows to specify the form type. It is sometimes easier. For example:

 

Go here: http://searchwww.sec.gov/EDGARFSClient/jsp/EDGAR_MainAccess.jsp

 

Clicked on advanced.

 

I have found some of the warrants prospectus as from type 424B7, although they may not all be of that type. So if you enter Bank of America on the company name field and form type of 424B7 on the drop down then search you should be able to find it. It works for some and not for others. You can also narrow down by date.

 

Someone more familiar with the prospectus form types (424X) care to comment on the different types and what they are used for?

[racemize]

Suntrust

http://www.cornerofberkshireandfairfax.ca/forum/general-discussion/suntrust-tarp-warrants/msg98021/#msg98021

 

M&T

http://www.cornerofberkshireandfairfax.ca/forum/investment-ideas/mtb-mt-bank/msg95174/#msg95174

 

ZION

http://www.cornerofberkshireandfairfax.ca/forum/investment-ideas/zions-bancorp/msg93862/#msg93862

 

GM

http://www.cornerofberkshireandfairfax.ca/forum/investment-ideas/general-motors-gm/msg103240/#msg103240

 

HIG

http://www.cornerofberkshireandfairfax.ca/forum/general-discussion/hig-warrants/msg26162/#msg26162

 

Thanks Plan!

[racemize]

I'm trying to get the SEC filings for a few warrants in order to get the dividend threshold amount--how do you look them up if you know the company ticker?

 

In particular, I'm looking for:

BPFH

LNC

SBNY

TCB

VLY

 

Thanks!

 

Update on tarp warrants, I've got most of the SEC filings found and in my spreadsheet, which is here:

https://docs.google.com/spreadsheet/ccc?key=0AhTPR9eP5nWedEF1SGVLdllJTnBMSDMzM3lYZ2d0SlE&usp=sharing

[Daytripper]

The TCF Financial warrants are trading about for what they were sold for by Treasury, and the stock is getting close to the exercise price. Might be nice to hold some if the stock can trade up in 3.5 years. Any opinions on TCF?

 

Tom