Tune Your Portfolio With a Year-End Review, Part 1
So, how did you do in 1999?
Sure, you bragged about that 250% gain in Yahoo! (YHOO) or that 1100% gain in Qualcomm (QCOM) at the office holiday party. But overall, how did your portfolio perform? Even more importantly, what are you going to do for an encore in 2000? Does your portfolio still conform to your original strategy?
Each January at Heron Capital Management, we perform a review of each client's portfolio, comparing the risk characteristics of the portfolio to the client's risk profile, determining how far the portfolio's allocations have drifted from the original strategy and taking steps to bring the portfolio back into line.
We have a broad array of automated systems to help us do this. But with a Microsoft (MSFT) Excel spreadsheet and data from all the free services on the Internet, you can perform the same analysis yourself on your own portfolio.Here's a sample Excel spreadsheet, derived from the portfolio of one of our more aggressive clients, to give you an idea of what we do. (Netscape users, right click on the link and save the file to your hard drive. You'll need Microsoft Excel software to view it.) With a little effort, this spreadsheet can be adapted to analyze your portfolio. Now let's take it step by step: Step 1: Evaluate performance against benchmarks. Even if you don't use portfolio-tracking software, you can reasonably estimate your annual return as follows: Get the total market value (including cash, mutual funds, stocks and bonds) of your portfolio from your year-end brokerage statement. Look up the same value from your year-end 1998 statement. Skim over your interim statements to see if you added or withdrew cash from your account during the year. The formula for calculating returns is: In the above chart, MV is the market value of the portfolio and CF stands for cash flow, or the sum of cash added or withdrawn during the year. If cash flows are no more than 15% of the total portfolio, this calculation will yield a reasonably close estimate. If cash flows are larger, calculate quarterly returns using the above method, then put together an annual return with the following formula: ((1+Q1return)* (1+Q2return)* (1+Q3return)* (1+Q4return)) - 1 Let's try an example for a portfolio that was worth $100,000 on Jan. 1, 1999. Let's assume $10,000 in cash was added during the year, and at year-end, the portfolio was worth $150,000. (Note: You can enter your numbers for both formulas directly into the attached spreadsheet.) In 1999, the S&P 500 index returned 21%; the Dow Jones Industrial Average, 27%; the Nasdaq Composite, 84%; and the Russell 3000, 21%. Our example portfolio returned 69%, impressive compared to all but the Nasdaq. Last January, we decided to overweight technology and underweight financial services in our aggressive portfolios. Obviously, our client was rewarded, but as we will see below, the results are entirely attributable to being in the right sector. In benchmarking your portfolio, pick broader indices such as the S&P 500 or the Russell 3000. The Nasdaq is too much of a technology sector index at this point, and the Dow is too narrowly defined to be useful. If you have significant fixed-income exposure, calculate a blended benchmark (e.g., 60% S&P 500, 40% Lehman Brothers Aggregate Bond Index). Year-end returns are available from a variety of sources, including The Wall Street Journal and Barron's. Whether you beat or trail whatever benchmark you select, the important thing is to find out why. Step 2: Examine the composition of your portfolio by sector. In a diversified portfolio (at least 25 stocks, no positions larger than 6%), about 80% of returns come from sector selection and 20% come from the individual stock selections. In 1999, the top-performing sector was technology; other sectors were mostly flat to lower. Assign each stock in your portfolio to one of these sectors:
- Basic materials
Select the service that is right for you!COMPARE ALL SERVICES
- $2.5+ million portfolio
- Large-cap and dividend focus
- Intraday trade alerts from Cramer
- Weekly roundups
Access the tool that DOMINATES the Russell 2000 and the S&P 500.
- Buy, hold, or sell recommendations for over 4,300 stocks
- Unlimited research reports on your favorite stocks
- A custom stock screener
- Upgrade/downgrade alerts
- Diversified model portfolio of dividend stocks
- Alerts when market news affect the portfolio
- Bi-weekly updates with exact steps to take - BUY, HOLD, SELL
- Real Money + Doug Kass + 15 more Wall Street Pros
- Intraday commentary & news
- Ultra-actionable trading ideas
- 100+ monthly options trading ideas
- Actionable options commentary & news
- Real-time trading community
- Options TV