Factoids'  Instablog

Factoids
Send Message
I am a private investor who has invested in individual stocks for over a decade. I have a BBA from the University of Texas at Austin. I am retired and living off of dividends and distributions from a portfolio of BDCs, consumer staple stocks, MLPs, regional banks and REITs.
  • Feedback Request - BDC Stats 8 comments
    Dec 8, 2013 9:46 PM

    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 (NASDAQ: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 (NASDAQ: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 (NYSE: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 (NASDAQ: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%.
Back To Factoids' Instablog HomePage »

Instablogs are blogs which are instantly set up and networked within the Seeking Alpha community. Instablog posts are not selected, edited or screened by Seeking Alpha editors, in contrast to contributors' articles.

Comments (8)
Track new comments
  • bythepark
    , contributor
    Comments (3) | Send Message
     
    I like 'Two Heads' :)
    ---alan
    9 Dec 2013, 01:03 AM Reply Like
  • DAG Investments
    , contributor
    Comments (4132) | Send Message
     
    Two heads are better than one ... sorry, I'm not very good at following directions. ;~) In fact, the height is perfect. And, thank you very much for considering my feedback without taking offense to it.
    9 Dec 2013, 01:10 AM Reply Like
  • NoBoB
    , contributor
    Comments (19) | Send Message
     
    I like two heads
    9 Dec 2013, 01:16 PM Reply Like
  • tachyon1
    , contributor
    Comment (1) | Send Message
     
    The S.A. expanding table feature drives me crazy. So I copy it to an Excel spreadsheet and freeze the panes to keep the header at the top of the page. I only need one header but two is not a problem.
    9 Dec 2013, 05:05 PM Reply Like
  • wildcat1932
    , contributor
    Comments (2) | Send Message
     
    I vote for 2
    9 Dec 2013, 05:14 PM Reply Like
  • hill53
    , contributor
    Comments (4) | Send Message
     
    Like two heads
    9 Dec 2013, 08:23 PM Reply Like
  • don'tbugmeplease
    , contributor
    Comments (183) | Send Message
     
    I like to print out the tables so I can mark them up and put notes on them, so I do a cut & paste. Like Tachyon1, I find SA less than convenient when it comes to copying and/or printing.
    I prefer a single header so I won't have to cut the second one out, but whatever the masses want is fine with me. I just want the info!
    10 Dec 2013, 10:37 AM Reply Like
  • 17413852
    , contributor
    Comments (8) | Send Message
     
    I vote for 2, thanks for all you do!
    12 Mar 2014, 08:58 AM Reply Like
Full index of posts »
Latest Followers

StockTalks

More »

Latest Comments


Instablogs are Seeking Alpha's free blogging platform customized for finance, with instant set up and exposure to millions of readers interested in the financial markets. Publish your own instablog in minutes.