corporate bond screener

---

Request for Question Clarification by pafalafa-ga on 20 Jul 2005 11:20 PDT

The Bond Screener at Yahoo Finance is generally regarded as one of the
best web-based screeners available:


http://screen.yahoo.com/bonds.html


It offers a fair number of options, but these do not include a screen
for the amount of debt.


Is the >$250 million debt criteria an absolute necessity?  Or is the
Yahoo Bond Screener useful to you, even without it?

Let me know.

pafalafa-ga

---

Clarification of Question by bernie_answers-ga on 20 Jul 2005 12:28 PDT

Looking for list of retailers with publicly issued debt in excess of
$250 million total, all issues combined. Not interested in outstanding
bank debt.

---

Clarification of Question by bernie_answers-ga on 20 Jul 2005 12:29 PDT

Yahoo! Finance has a screener that does not provide debt principal
outstanding as a parameter.

I pulled all of the retailers I could find with more than $100 million
public debt. Use the data you wish, and throw the rest away.

Company Name	Ticker	Total   Total   % of Stock Market Value	Sales,
Last Four Quarters
						
Wal-Mart Stores	WMT	$23,669 $3,490 	14.7%	$208,265 	$294,226 
Target Corp	TGT	$9,034 	$3,300 	36.5%	$52,428 	$48,136 
Kroger Co	KR	$7,900 	$865 	10.9%	$14,337 	$57,477 
Toys R Us Inc	TOY	$1,860 	$720 	38.7%	$5,923 	$11,174 
Delhaize America Inc	0446B	$3,588 	$700 	19.5%	NA	$16,013 
Safeway Inc	SWY	$6,124 	$650 	10.6%	$10,794 	$36,762 
Sears Roebuck Acceptance Corp.		NA	$304 	NA	NA	NA
Lowe's Cos.	LOW	$3,060 	$350 	11.4%	$51,072 	$37,696 
May Department Stores Co	MAY	$5,662 	$345 	6.1%	$12,206 	$14,847 
Winn-Dixie Stores Inc	WNDXQ	$314 	$280 	89.1%	$155 	$10,249 
Dillards	DDS	$1,543 	$275 	17.8%	$1,919 	$7,659 
Limited Brands Inc	LTD	$1,646 	$250 	15.2%	$9,697 	$9,405 
Rent-A-Center Inc	RCII	$705 	$245 	34.8%	$1,580 	$2,330 
Autozone Inc	AZO	$1,869 	$234 	12.5%	$7,558 	$5,664 
Albertsons Inc	ABS	$6,300 	$200 	3.2%	$7,960 	$41,253 
Federated Dept Stores	FD	$2,637 	$195 	7.4%	$12,913 	$15,754 
RadioShack	RSH	$507 	$125 	24.7%	$3,634 	$4,910 
Rite Aid Corp	RAD	$3,088 	$100 	3.2%	$2,282 	$16,794 
CVS Corp.	CVS	$1,926 	$100 	5.2%	$24,658 	$32,958 
Supervalu Inc	SVU	$1,579 	$100 	6.3%	$4,737 	$19,605 
Pathmark Stores Inc	PTMK	$623 	$100 	16.1%	$325 	$3,991

---

Clarification of Answer by vercingatorix-ga on 28 Jul 2005 14:16 PDT

Sorry, I accidentally pressed return while trying to format the table.
Let's do this again:

Company Name	Ticker	Total   Total   % of    Stock Market 	Sales
                        LT Debt Public  Debt    Value           Last 4
                                Debt    Public                  Quarters 
						
Wal-Mart Stores	WMT	$23,669 $3,490 	14.7%	$208,265 	$294,226 
Target Corp	TGT	$9,034 	$3,300 	36.5%	$52,428 	$48,136 
Kroger Co	KR	$7,900 	$865 	10.9%	$14,337 	$57,477 
Toys R Us Inc	TOY	$1,860 	$720 	38.7%	$5,923 	        $11,174 
Delhaize America0446B	$3,588 	$700 	19.5%	NA	        $16,013 
Safeway Inc	SWY	$6,124 	$650 	10.6%	$10,794 	$36,762 
Sears Roebuck 
Acceptance Corp.None    NA	$304 	NA	NA	        NA
Lowe's Cos.	LOW	$3,060 	$350 	11.4%	$51,072 	$37,696 
May Department 
Stores Co	MAY	$5,662 	$345 	6.1%	$12,206 	$14,847 
Winn-Dixie 
Stores Inc	WNDXQ	$314 	$280 	89.1%	$155 	        $10,249 
Dillards	DDS	$1,543 	$275 	17.8%	$1,919 	        $7,659 
Limited Brands 	LTD	$1,646 	$250 	15.2%	$9,697 	        $9,405 
Rent-A-Center 	RCII	$705 	$245 	34.8%	$1,580 	        $2,330 
Autozone Inc	AZO	$1,869 	$234 	12.5%	$7,558 	        $5,664 
Albertsons Inc	ABS	$6,300 	$200 	3.2%	$7,960 	        $41,253 
Federated Dept 
Stores	        FD	$2,637 	$195 	7.4%	$12,913 	$15,754 
RadioShack	RSH	$507 	$125 	24.7%	$3,634 	        $4,910 
Rite Aid Corp	RAD	$3,088 	$100 	3.2%	$2,282 	        $16,794 
CVS Corp.	CVS	$1,926 	$100 	5.2%	$24,658 	$32,958 
Supervalu Inc	SVU	$1,579 	$100 	6.3%	$4,737 	        $19,605 
Pathmark Stores PTMK	$623 	$100 	16.1%	$325 	        $3,991

The debt, market value, and sales numbers are listed in millions.
Statistics for the value of publicly traded debt reflect par value,
not market value, and are rounded to the nearest $5 million.  I hope
this helps.

V

Source: Proprietary database.