Please Note: Blog posts are not selected, edited or screened by Seeking Alpha editors.

Feedback Request - BDC Stats

What follows is a display experiment with a "two header" spreadsheet. This is a response to a suggestion that my coverage universe is so large, that the header is lost from the screen for data that is towards the bottom of the spreadsheet - thus a second header would improve the reading experience.

I am requesting your feedback. If this improves the display - then reply with "I like two heads". If not, reply "1 head is enough". I have acclimated to the old format. I will change to the two head format if 60% prefer the new - or if the response is large (over 25 replies) and two heads gets 55% of the vote. Thanks in advance for your participation.

If I need to enlarge or expand the explanation of the spreadsheet components, (for example - why include the div/NAV ratio?) - this is also a good time to let me know that information.

The two head format

BDCs 12-06-13

Yield in the spreadsheet below is based on the Q4-13 dividend. Spreadsheet header abbreviations: Div = dividend; EPS = earnings per share; LTM = last twelve months; YTD = year to date. The dividend to EPS ratio is a measure of dividend safety. Due to calendar and fiscal years failing to overlap, I also include a dividend to the sum of the last four quarters of NII - in the Div/NIIltm column. The dividend to NAV ratio is a measure of safety and efficiency. The last four columns measure the percentage change in the 2013 EPS projection and the change in the price target since the beginning of the year; the change in the Q4-13 dividend from the Q4-12 dividend. Special dividends are not included in this data. ARCC will pay a special dividend of $0.05/share payable on 12-31-13 and again on 3-28-14. FDUS will pay a special dividend of $0.38/share payable 12-20-13. MAIN will pay a special dividend of $0.25/share on 12-24-13. FSC and FULL have cut their first quarter dividend - and that new rate is temporarily encoded as a Q4-12 div to show their forward yield

 

 


    Share Price   Div/ Div/ Div/ Div/ Q3-13 Price YTD Percent Change LTM LTM
Company_name_and_ticker 1-01 12-06 Yield EPS13 EPS14 NIIltm NAV NAV NAV Price Pr+Div EPS Target Div NAV

American Cap (NASDAQ:ACAS) 12.02 15.07 0.00 0.0 0.0 0.0 0.0 19.54 0.77 25.37 25.37 -20.95 22.32 na 12.36
Apollo Invest (NASDAQ:AINV) 8.36 8.83 9.06 92.0 90.9 92.1 9.8 8.30 1.06 5.62 15.19 -1.14 4.98 0.00 -1.69
Ares Capital (NASDAQ:ARCC) 17.50 18.27 8.32 92.7 91.6 100.4 9.4 16.35 1.12 4.40 10.91 -1.20 2.74 0.00 4.51
BlackRock (NASDAQ:BKCC) 10.06 9.64 10.79 133.3 110.6 115.6 11.1 9.38 1.03 -4.17 6.16 -22.77 0.81 0.00 -2.50
Fidus Invest (NASDAQ:FDUS) 16.45 20.11 7.56 110.9 85.4 107.9 9.5 15.98 1.26 22.25 30.80 -19.88 16.22 0.00 6.92
Fifth St (NYSE:FSC) 10.42 9.37 10.67 96.1 97.0 95.9 10.1 9.85 0.95 -10.08 -1.20 -6.31 -5.04 -13.05 0.51
Full Circle (FULL) 7.43 7.48 11.23 115.1 107.7 109.1 10.5 7.48 1.00 0.67 11.13 -9.88 10.00 -9.09 -6.75
Gladstone Inv (NASDAQ:GAIN) 6.96 7.53 7.97 84.5 85.7 80.2 7.0 9.12 0.83 8.19 15.37 29.09 -11.11 0.00 -5.49
Golub Cap (NASDAQ:GBDC) 15.98 18.08 7.08 97.7 92.8 99.3 8.5 15.21 1.19 13.14 19.15 2.34 5.88 0.00 3.70
Gladstone Cap (NASDAQ:GLAD) 8.16 9.53 8.81 100.0 96.6 103.3 9.8 9.81 0.97 16.79 26.23 -2.33 0.00 0.00 -3.48
Horizon (NASDAQ:HRZN) 14.92 14.16 9.75 99.3 93.2 102.2 9.3 14.95 0.95 -5.09 3.46 -8.55 -6.19 0.00 -11.00
Hercules (NASDAQ:HTGC) 11.13 16.82 6.66 91.1 86.8 106.4 11.1 10.42 1.61 51.12 58.67 12.84 36.84 16.67 5.77
Kayne Ander (NYSE:KED) 24.44 27.04 6.73 75.8 70.8 92.9 6.9 27.84 0.97 10.64 16.22 25.00 22.79 5.81 16.58
Kohlberg (NASDAQ:KCAP) 9.19 8.07 13.88 121.7 108.7 118.1 13.6 8.02 1.01 -12.19 -3.05 -9.80 -0.42 16.67 7.57
Main St. (NYSE:MAIN) 30.51 32.15 5.79 92.5 81.6 90.1 9.9 20.01 1.61 5.38 10.96 -1.47 25.38 3.33 10.83
Medley Cap (NYSE:MCC) 14.56 13.95 10.61 98.7 93.7 100.0 11.6 12.65 1.10 -4.19 3.43 3.45 5.18 2.78 1.03

    Share Price   Div/ Div/ Div/ Div/ Q3-13 Price YTD Percent Change LTM LTM
Company_name_and_ticker 1-01 12-06 Yield EPS13 EPS14 NIIltm NAV NAV NAV Price Pr+Div EPS Target Div NAV

MCG Capital (NASDAQ:MCGC) 4.60 4.67 10.71 113.6 102.0 137.4 9.7 5.10 0.92 1.52 9.67 -4.35 7.99 -10.71 -1.52
New Mountain (NYSE:NMFC) 14.90 14.98 9.08 89.5 98.6 104.8 9.5 14.32 1.05 0.54 7.38 11.76 1.50 0.00 3.47
NGP Capital (NGPC) 7.22 7.61 8.41 100.0 103.2 96.7 7.0 9.22 0.83 5.40 12.05 -17.95 -16.67 0.00 -1.72
Prospect (NASDAQ:PSEC) 10.87 11.17 11.85 84.3 105.1 82.8 12.4 10.72 1.04 2.76 14.03 5.37 9.84 0.32 -1.02
Pennant Float (NASDAQ:PFLT) 12.70 13.93 7.75 93.9 93.9 94.3 7.7 14.10 0.99 9.69 17.55 4.55 6.43 5.88 0.29
Pennant Cap (NASDAQ:PNNT) 10.99 11.93 9.39 102.8 98.2 106.4 10.7 10.49 1.14 8.55 18.74 -3.54 0.51 0.00 2.66
Saratoga (NYSE:SAR) 15.40 15.27 0.00 0.0 0.0 0.0 0.0 23.77 0.64 -0.84 -0.84 -2.11 -32.09 na -12.61
Solar Cap (NASDAQ:SLRC) 23.91 22.96 6.97 84.7 90.4 71.6 7.1 22.25 1.03 -3.97 2.72 -26.46 -4.84 -33.33 -0.49
Solar Senior (NASDAQ:SUNS) 18.66 18.30 7.70 119.5 104.4 113.1 7.7 17.91 1.02 -1.93 5.06 -16.90 1.32 0.00 -1.56
Medallion (TAXI) 11.74 15.99 5.75 73.6 76.7 161.0 9.0 10.38 1.54 36.20 42.08 17.92 27.04 9.52 3.04
Triangle Cap (NYSE:TCAP) 25.49 29.62 7.29 96.0 93.9 93.6 13.8 15.94 1.86 16.20 22.56 -0.44 15.45 1.89 2.70
THL Credit (NASDAQ:TCRD) 14.79 16.79 8.10 94.4 94.4 89.8 10.3 13.38 1.25 13.52 20.42 0.70 9.11 3.03 0.23
TICC Cap (NASDAQ:TICC) 10.12 10.68 10.86 111.5 102.7 131.7 11.9 9.90 1.08 5.53 14.13 -14.75 -4.21 0.00 2.96

Sector Average     8.84 98.7     9.8   1.10 7.62 14.98 -2.68 5.23

With the 10 Treasury at 2.85% and sector average yield (on Q4 dividends) at 8.84% - the spread is 599 bps.
The cap weighted ETF BDCS is up 6.77% year to date - with dividends its total return is 14.24%.
Sector yield, Dividend/NAV and Dividend/EPS ratio filter out the zero payout ACAS and SAR.
Weeding out ACAS and SAR, the average share price gain is 7.28%.