Jump to content

TARP Warrants


Guest misterstockwell

Recommended Posts

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

 

Link to comment
Share on other sites

  • 1 month later...
  • Replies 102
  • Created
  • Last Reply

Top Posters In This Topic

  • 4 weeks later...

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))

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

  • 10 months later...

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

"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

Link to comment
Share on other sites

"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.

Link to comment
Share on other sites

"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.

Link to comment
Share on other sites

"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.

Link to comment
Share on other sites

"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

 

 

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

  • 1 year later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



×
×
  • Create New...