Posts Tagged ‘Portfolio’

Learn how to invest, read stock analysis, and find stock picks

Portfolio Update July 2009

Old School Value Stock Portfolio Performance

osv-performance

osv-july-performance

Portfolio Movers

July was another great month where my portfolio increased by 22.37% compared to the S&P’s 7.41%. YTD has increased dramatically from 49% last month to 83.42%. The rise was again due to my large position in VVTV doing well. VVTV has now grown from the initial 10% allocation to well over 30% now.

I have considered selling several times but held back each time whenever I weighed up the options between what I view as the future prospects.

Other positions that have been doing well include IGOI and PDII. As I mentioned in my recent post on IGOI, the company has been able to increase their NNWC.

PDII is also another net net that I’m looking forward to in the future.

Companies that aren’t doing so well include Ceradyne (CRDN) and Image Entertainment (DISK). CRDN has had a big slow down in sales in the tough environment with the outlook still looking bleak.

DISK has gone down considerably since I first bought it, down 42.31% but Im still holding as it’s less than 1% of my portfolio and selling it would  be more costly with the fees.

Everyone is talking about a pullback in the markets but I’m confident in the businesses that I hold (minus a few) and will purchase more if the opportunity presents itself.

Portfolio Trades

In July, three trades were made.

1. Bought more Mastech (MHH) @ $2.85.

There was a fairly big drop in MHH towards the middle of the month on low volume and no news. Seemed like a small investor selling out so I took the chance to add more. It seemed to have worked as it climbed back up to where it was trading previously. MHH now accounts for 7.5% of my total portfolio.

2. Sold BreitBurn Energy Partners (BBEP) @ $7.95 with a 26.19% gain.

I didn’t do too much homework on this company but bought it on the over-reaction following the distribution cut. Seth Klarman’s interest in the company also helped me to purchase it along with advice from fellow value investor PlanMaestro.

Since I also wasn’t keeping up with the company and doing the required work to stay on top of things, I felt it was safer to sell. CRDN is also falling into this category.

3. Sold Linktone (LTON) @ $2.44 with a 56.19% gain.

I invested in LTON after going through plenty of net net deep value stocks and LTON was trading at a 26% discount to its liquidation price. The majority of the value was comprised of cash.

LTON was also sold based on a pre-determined open sell order even though I liked the direction the company was taking.

Disclosure

I hold all stocks mentioned except sold positions.

Categorizing Your Portfolio

I have 1 stalwart, 3 fast growers, 3 turnarounds and 1 cyclical.

For those who have read One Up On Wall Street by Peter Lynch, you’ll know that I’m referring to the 6 categories that he assigns to the companies in his portfolio. As I was reading this section, I had never thought about classifying my positions in terms of growth and return potential. I always looked at the different industries that made up my portfolio and it was refreshing to see it another way.

Let me briefly go through the 6 different categories he discusses in his book.

The Slow Growers

These are the large (although not always), saturated or aging companies that are not expected to grow any faster than your fingernails. They generate more cash than they can spend (I’m sure every wife dreams of a husband like this). Examples include the electric utility and waste companies such as AW, NU and CPK. Even Coca Cola (KO) could be considered as a slow grower. One way to determine a slow grower is by their consistent and increasing dividends or even more easily by their historical charts which shows a flat line.

The Stalwarts

These companies aren’t slow growers, but don’t expect it to grow fast enough to give you 100% gains within 2 years or so. Such companies like Adobe, Home Depot and American Express may be able to provide 15-20% per year depending on when and what price you pay for them but anything beyond those rough numbers is an additional bonus.

Stalwarts can provide outstanding opportunities when it is cheap enough because the company has already established itself yet still has growth potential remaining.

Lynch mentions that he keeps a few stalwarts in his portfolio as they are a good protection during recessions and corrections but they are also one of the first to be sold when a new idea comes up.

After reviewing my past sell and purchase patterns, it too seems like my stalwarts have been the first to be replaced when either a better stalwart or faster growth company appears.

The Fast Growers

The companies that grow aggressively and often have growing pains, yet provide the best opportunities for individual investors before Wall Street comes along. There are thousands and thousands of people who knew about Wal-Mart before it became the monster it is now. There are just as many people who knew about the growth potential of Hansen Natural.

Along with growing quickly, comes the added risk these young companies will end up in bankruptcy or the company may grow tired or out of ideas and turn into a slow grower.

The Cyclicals

Up and down, up and down. Fashion, oil, auto industries are a few examples of cyclical industries. There is usually a predictable pattern of high and low sales. Retail sales are highest during the Christmas shopping season and people usually don’t buy a new car every year. They tend to wait a few years or wait until the economy gets better before making purchases. Even airlines are cyclical because people tend to travel more during the summer, hence the peak and off peak rates.

Lynch informs the reader that too many people label cyclicals incorrectly. An example is Ford and GM. Just because these are established “blue chip” companies, many people expect it to act like a JNJ. Looking at the past shows that the graph is more like a moguls course.

The Turnarounds

A majority of what value investors would invest in. Depressed, beaten and oversold companies rebound to its intrinsic value and beyond very quickly once people realize that the company has been successful in turning itself around. The risk is that turnarounds don’t always happen, and companies end up using all of their cash and they are either back to where they started or worse.

Many companies try to turn itself around by diversifying into other unrelated fields of business just for the sake of trying something. Beware of these companies.

On the other hand, Apple has transformed itself from a successful turnaround to a fast grower. They’ve gone from a mediocre computer company to a killer consumer electronics company.

The Asset Plays

An asset play is where the company owns something much more valuable than just its business. The company may own land where oil lies just beneath or it may hold huge amounts of real estate that has been depreciated in the books for so many years that it doesn’t reflect the true value of the company like Sears. It could also be a huge pile of cash sitting around like Berkshire. Spectrum in the telecommunication and media business is an expensive and desired asset as it can give growth potential, monopolies and can also be resold for millions of dollars.

For asset plays to work out, a great deal of patience is required before the market wakes up.

Portfolio Management

I’ve only assigned one category to one company but there are companies that could be a combination. You could even go further and create your own categories.

Looking at my portfolio it seems like I may have one too many turnarounds, but overall, I’m happy with how my portfolio falls into the criterias. It’s a good reflection of my investing style and strategy.

So there is a brief outline of the 6 categories, but for additional topics in an entertaining and good read, you can read it for yourself by purchasing it here.

Disclosure

No positions held in any stocks mentioned.

[tags]asset allocation, portfolio[/tags]

Investment Portfolio Spreadsheet

Written by

Jae Jun

[edit] Newer Version Now Available

There is now an even better version available. A brand new and updated version of the best stock portfolio tracking spreadsheet. Go check it out now.

Continue on with the Original Article..

For an investor, keeping track of personal performance and gains is important. Many people believe they know their return rate in their head, but surprisingly, this is always overestimated. Our actual return usually come out a few % lower and these few percentages can add up to ten of thousands. That is why a investment portfolio spreadsheet is important to track performance.

Tracking Your Performance

Tracking performance also allows an investor to be honest with themselves. As human beings, we tend to dismiss the failures much more often than when we try to acknowledge and learn from them. Everyone has made investment mistakes and it is vital to know what went wrong and then to never redo those mistakes. I believe that monitoring your portfolio in a spreadsheet or other form reminds you of those mistakes.

The Original Excel Portfolio Spreadsheet

I was sick of all the portfolio managing programs that you had to buy and install etc, so I made my own. But one day, I came across a great blog titled ‘Experiments in Finance’ where the author had created a great Portfolio Performance vs S&P 500 spreadsheet. Please visit the blog to get the original file and see the instructions.

Automated Excel Portfolio Spreadsheet

Now if you’re like me and can’t be bothered looking up the latest prices and then recording them manually, a great plugin for excel, written by Randy, is available at Randy’s Yahoo Group. You can find more info by going to ‘Files > Documentation’ section on the Yahoo group. For your convenience, I’ve made a link so you can download it right here.

Utilizing the excel add-in, the latest and historical stock prices for all tickers can be retrieved. You just add the stock symbol, no. of shares bought, purchase price and date of purchase and the rest should be updated.

Spreadsheet Installation Instructions

The instructions are pretty simple, download the zip file containing the add-in and its supplementary files and create a folder called “SMF” directly under C: and then extract all of the files into the “C:\SMF\” folder on your computer.

Then open Excel, make sure a blank workbook is open, choose the menu Tools->Add-Ins, in the dialog box which opens choose Browse and choose the folder “C:\SMF\” and then choose the file “RCH_Stock_Market_Functions.xla” and click OK.

edit: follow the link to view the full and comprehensive installation manual and FAQ.

Few Quick Comments

The #DIV/0! error you see is nothing. Just ignore it. It is the excel function spitting an error because there are no values available for an empty cell.

Feel free to modify it and share it.
If you are having trouble let me know and I will try to help.

Download Section

Randy’s SMF Add-in
Original Portfolio Performance vs S&P 500 spreadsheet & Instructions
Automated Portfolio Spreadsheet – Old School Value Version

How to Install

edit: (view the installation guide linked above)

You have to unzip the file into c:/SMF
If you put it in any other folder it wont work.

For Excel 2003:

  1. On the Tools menu, click Add-Ins
  2. Click the Browse button and navigate to the smf add ins folder
  3. Select the add in file that you see and then click OK
  4. Click Yes to any file copy or overwrite prompts
  5. Verify the Stock Market Function add in box is checked
  6. Press OK

For Excel 2007:

  1. Click the orb and then click on excel options
  2. Click Add in
  3. Down the bottom there is a drop down list and next to it there is a move button (I think). Click on the button
  4. Navigate to the SMF add in folders
  5. select the file and then click OK
  6. Verify the Stock Market Function add in box is checked
  7. Press OK

Open the spreadsheet, enter and ticker and you will see a “calculating xx%” in the bottom right corner. You are good to go.

Note: if you download the file, copy it to a USB and then copy it back to another folder or computer, MAKE SURE that the data in the “Statements” tab is pointing to c:/SMF and not your USB drive.

——————————————————————————–

If you found this article helpful and would like to receive more information on free investing tools and spreadsheets, as well as business valuations, stock analysis and updates on merger arbitrage, subscribe to the Old School Value RSS or via email.