Creating multiple portfolios – New Feature

We recently added a new feature to your EquityStat portfolio manager. You can now create multiple portfolios for your account. Having multiple portfolios gives you the ability to group and separate your investments. For example, you can have a portfolio for your individual stocks, a portfolio for your mutual funds and a portfolio for your 401K.

To add a new portfolio click the New menu and then chose the New Portfolio menuitem from the dropdown menu.

Create a New EquityStat Portfolio
How to create a new portfolio in EquityStat

You will then see two new tabs. A tab for your current portfolio and a tab for your new portfolio.

Change Portfolio Name EquityStat
How to change the portfolio name

To edit the name of your portfolio click the pencil icon, which will display an edit box.

Edit Portfolio Name
How to edit a portfolio name.

Next type over the current portfolio name with the new portfolio name and click the Save button.

View portfolio investments
View a specific portfolio

To view the investments of each portfolio click on the portfolio’s tab. From here you can also add new investments to the portfolio as well as edit investments.

To view the view the performance all your entire account (all portfolios) click the Account Value box at the top.

To delete a portfolio first delete all the investments in the portfolio. Once the portfolio is empty, click the ‘X’ icon in the portfolio tab.

Behind the Design

Behind the Design of EquityStat’s Portfolio Manager

EquityStat’s portfolio manager was built for investors by investors.  As investors we found many portfolio managers just didn’t work how we wanted them to.  Whether the portfolio manager was from a brokerage account, mutual fund or from a software company, many just didn’t work well.  This was a driving force for us building EquityStat’s portfolio manager.

One major problem of other portfolio managers is they don’t refresh your investment prices and portfolio value automatically.  To see your latest values, you have to manually refresh the page.

We didn’t want our portfolio manager to behave this way.  With our portfolio manager your prices and portfolio values are updated automatically without you having to refresh the page.  Every 15 minutes we query the latest prices of your investments and update your portfolio.  In the upper right hand corner, we even display the last time the quotes were updated.  All of this happens automatically without you having to constantly refresh the page to see how your investments are performing.

Another problem of other portfolio managers is entering transactions.  When entering transactions the portfolio manager will post back the transaction to the webserver and then do a page refresh with the new data. This is very cumbersome.

EquityStat’s portfolio manager does all of the saving in the background.  When you add or edit a transaction, the transaction is saved and updated behind the scene.  The only thing you see is notification at the top of the portfolio that the transaction has been saved.  The benefit of this is less page refreshing and a more natural, less cumbersome way of entering transactions.

In the coming weeks, we will highlight more design features or our portfolio manager and how it benefits our users.

If you bought Berkshire stock how rich would you be?

If you bought Berkshire Hathaway (BRK.A) stock instead of paying for college, how rich would you be?  Instead of having that fabulous wedding, what if you bought Berkshire?  How about if you owned a couple of shares of Berkshire instead of your dream home, how rich would you be?

Use our Berkshire Calculator to find out.  Just click this link

http://www.equitystat.com/pages/howrich.aspx

and then enter the year you went to college, had that fabulous wedding or bought your dream home.  Next, enter the amount you paid.  Click Go and you will see how rich you could be.

Warning: For those over 40 this calculator could make you sick to your stomach.

 

 

 

Changing Columns in Your Portfolio

By default we display a pre-configured set of columns for your portfolio.  If you desire you can easily change the columns that are displayed in your portfolio.  To do this click the Options link at the top of your portfolio and choose the Change Columns menuitem.

Change Performance Metrics in EquityStat's Investment Portfolio Manager
Change Columns In Your Portfolio

Clicking the Change Columns menuitem will display a list of columns that are available and a list of columns your are currently using.  You can add and remove columns as well as change the order of your columns.  If you want a description of a column, just click on the column in either of the lists.

When you are finished change your columns, click the Change button to save your changes and get back to your portfolio.

Importing your transactions into EquityStat

Do you have a lot of transactions that you need to import into EquityStat that you don’t want to manually enter? If so then you can use EquityStat’s import feature to import these transactions.

To import your transactions first get these transactions into a CSV (comma separated variable) file. The easiest way to generate a CSV file is to use Excel or any other spreadsheet application. With Excel you can enter your data into a spreadsheet and then save the file as a CSV file.

The CSV file must be in a certain format for you to import your transactions into your portfolio. The first line in the file must identify what each column is. The following column indentifiers are valid – Symbol, Date, TranType, Quantity, Price, Amount, Commission.

The valid values for the TranType column are Buy, Sell, Div, Rediv (Re-invested Dividend), Longcg (Long-Term Capital Gain), Shortcg (Short-Term Capital Gain), Relongcg (Re-Invest Long Term Capital Gain), Reshortcg (Re-Invest Short Term Capital Gain).

If you have a TranType value of Div then you will need an Amount column and you will not need the Quantity and Price column. If you have a TranType value of something other than a non re-invested dividend or non re-invested capital gain, you will need a Quantity and Price column. All rows must have a Symbol and Date column.

Here is a screen shot of a sample Excel file in the proper format.

Import Transactions into EquityStat's Stock Portfolio Tracker
Import transactions into EquityStat

Once you have your data entered in your spreadsheet, save it as a CSV file.

Next, login to your portfolio and  click the New menu and choose Import Transactions.  Then from the Import page, upload your CSV file from your computer.  The transactions that will be imported will then be displayed.  If everything is correct, continue the import process.

If you have any questions with how to do an import, feel free to contact our support desk by clicking the Help link from our home page.

Does Buffett think Berkshire stock is underpriced?

If you read Berkshire’s annual letter, you can gain a lot of insight as to what Buffett thinks of Berkshire. So based on the 2014 annual letter, does Buffett think Berkshire’s stock is undervalued, overvalued or just right?

First, Buffett has always said, over time Berkshire’s stock price will reflect the intrinsic value of the business. Calculating Berkshire’s intrinsic value is not a precise exercise but a lot of analysts do it, including Buffett and Munger.

In his 2014 annual letter, Buffett points out several times that the value of an asset on the books is a lot less than the true or intrinsic value of the asset. For example, when discussing Berkshire’s insurance float he says

Charlie and I believe the true economic value of our insurance goodwill – what we would happily pay for float of similar quality were we to purchase an insurance operation possessing it – to be far in excess of its historic carrying value. Under present accounting rules (with which we agree) this excess value will never be entered on our books. But I can assure you that it’s real. That’s one reason – a huge reason – why we believe Berkshire’s intrinsic business value substantially exceeds its book value.

When discussing the businesses that make up Berkshire, Buffett says

Furthermore, the intrinsic value of these businesses, in aggregate, exceeds their carrying value by a good margin, and that premium is likely to widen. Even so, the difference between intrinsic value and carrying value in both the insurance and regulated-industry segments is far greater. It is there that the truly big winners reside.

And finally, Buffett points out that the peculiarities of Marmon’s rail car business which causes Marmon’s book value to be undervalued.

One further fact about our rail operation is important for you to know: Unlike many other lessors, we manufacture our own tank cars, about 6,000 of them in a good year. We do not book any profit when we transfer cars from our manufacturing division to our leasing division. Our fleet is consequently placed on our books at a “bargain” price. The difference between that figure and a “retail” price is only slowly reflected in our earnings
through smaller annual depreciation charges that we enjoy over the 30-year life of the car. Because of that fact as well as others, Marmon’s rail fleet is worth considerably more than the $5 billion figure at which it is carried on our books.

Based on these quotes is Buffett hinting that book value is substantially under intrinsic value? And since Buffett believes stock price will eventually be the same as intrinsic value, does Buffett believe Berkshire’s stock price is undervalued?

I think the answer is a yes!

Best Quotes from Berskhire Letter

On Saturday Warren Buffett released his annual letter on Berkshire Hathaway.  If you are an investor it is a must read.  Here are the best quotes from the letter.

On Berkshire’s Investments

… stock repurchases at Coca-Cola, American Express and Wells Fargo raised our percentage ownership of each. Our equity in Coca-Cola grew from 9.1% to 9.2%, our interest in American Express increased from 14.2% to 14.8% and our ownership of Wells Fargo grew from 9.2% to 9.4%. And, if you think tenths of a percent aren’t important, ponder this math: For the four companies in aggregate, each increase of one-tenth of a percent in our ownership raises Berkshire’s portion of their annual earnings by $50 million.

On BNSF Railroad

BNSF, like all railroads, also moves its cargo in an extraordinarily fuel-efficient and environmentally friendly way, carrying a ton of freight about 500 miles on a single gallon of diesel fuel. Trucks taking on the same job guzzle about four times as much fuel.

Elephant Hunting or Tuna Fishing?

In past letters Buffett has said he is elephant hunting for new businesses.  He is now fishing.

With the acquisition of Van Tuyl, Berkshire now owns 9 1⁄2 companies that would be listed on the Fortune500 were they independent (Heinz is the 1⁄2). That leaves 490 1⁄2 fish in the sea. Our lines are out.

Investing Wisdom

… my experience in business helps me as an investor and that my investment
experience has made me a better businessman. Each pursuit teaches lessons that are applicable to the other. And some truths can only be fully learned through experience. (In Fred Schwed’s wonderful book, Where Are the Customers’ Yachts?, a Peter Arno cartoon depicts a puzzled Adam looking at an eager Eve, while a caption says, “There are certain things that cannot be adequately explained to a virgin either by words or pictures.”

For the great majority of investors, however, who can – and should – invest with a multi-decade horizon, quotational declines are unimportant. Their focus should remain fixed on attaining significant gains in purchasing power over their investing lifetime. For them, a diversified equity portfolio, bought over time, will prove far less risky than dollar-based securities.

Funny

The gecko, I should add, has one particularly endearing quality – he works without pay. Unlike a human spokesperson, he never gets a swelled head from his fame nor does he have an agent to constantly remind us how valuable he is. I love the little guy.

When I was a teenager– in my one brief flirtation with honest labor – I tossed about 500,000 papers.

Benjamin Franklin Wisdom

Buffett always has some common sense wisdom in his letters.

It’s better to have a partial interest in the Hope Diamond than to own all of a rhinestone.

In the world of business, bad news often surfaces serially: You see a cockroach in your kitchen; as the days go by, you meet his relatives.

Market forecasters will fill your ear but will never fill your wallet.

We’ve found that if you advertise an interest in buying collies, a lot of people will call hoping to sell you their cocker spaniels.

… never underestimate the man who overestimates himself.

Dividend?

Buffett has always said Berkshire won’t pay a dividend but hints that they might in the future.

Eventually – probably between ten and twenty years from now – Berkshire’s earnings and capital resources will reach a level that will not allow management to intelligently reinvest all of the company’s earnings. At that time our directors will need to determine whether the best method to distribute the excess earnings is through dividends, share repurchases or both.

Getting Started with EquityStat Portfolio Manager

Quick Start Guide

Here is a quick getting started guide for using EquityStat’s portfolio manager.

EquityStat Stock Portfolio Directions
Add transactions to EquityStat

After you join EquityStat, you will be logged into your account.  Since you have no investments in your portfolio, you will see the page above.  From this page you can click the New Investment button to add a new investment to your portfolio.

After clicking the New Investment button, you will be presented a dialog where you can enter a buy transaction for your investment.  Using the dialog, enter the symbol of your investment, the date the purchase took place, the amount of shares purchased and the price for each share.  When finished click the Save button.  Once you have entered your first purchase, you can then enter other transactions such as other buys, sells and dividends.

Getting Start With EquityStat Portfolio Tracker
Directions on EquityStat’s Portfolio Manager

The image above shows a portfolio with several investments already entered.  The top table will show all of your investments along with data about the investments.  Below the investment table are the transactions for the selected investment.  You can sort your investments and transactions by clicking on a column heading.  In addition you can expand a column by putting your mouse between columns and then drag to lengthen the width of the column.  Above the investment table is a summary of the portfolio which will show you the total portfolio value, the total dollar return, the gain/loss for the day and the year-to-date return.

Add Transactions to EquityStat's Investment Portfolio
How to add transactions to EquityStat

If you want to enter a new investment that is not in your portfolio, click the New menu and then choose the New Investment menuitem.  If you want to add transactions to an existing investment, go to the transaction table below the investment table and click the Add button.  A new row will then be added to the transaction table where you can add a new buy, sell, dividend transaction as well as many other transaction types.  You can also edit an individual transaction by selecting the transaction and clicking the Edit button.  If you want to remove a transaction, click the Delete button.

Hide Sold Investments in EquityStat's Stock Portfolio Tracker
How to hide sold investments in your portfolio

If you have investments in our portfolio that have been sold and you don’t want them to show, click the three line graphic at the left and choose Hide Sold Investments menuitem.  This will hide any sold investments.  To view your sold investments click the graphic again and choose View Sold Investments.

Cost Basis

What is Cost Basis?

Investopedia defines cost basis as:

The original value of an asset for tax purposes (usually the purchase price), adjusted for stock splits, dividends and return of capital distributions. This value is used to determine the capital gain, which is equal to the difference between the asset’s cost basis and the current market value. Also known as “tax basis”.

Why is it important?

The IRS is requiring more and more reporting of your cost basis of your investment.  They also require your report the capital gains/losses of your investments. To calculate your capital gains you need to know your cost basis.

How do you calculate it?

On the surface calculating cost basis sounds easy. Just use the price you paid for your stock. For example, if you purchased a 100 shares of XYZ company for $120 then your cost basis is $120. However, things get complicated if you had 3 for 2 stock split. Also, what if you purchase an additional 50 shares for $90? What if you have a split, reinvest capital gains and purchases in a given year? What is your cost basis? Now things get really complicated.

How EquityStat makes things easier

With EquityStat all you have to do is enter your purchases, splits, capital gains and we will calculate your cost basis. Then when you sell your stock whether all of your shares or just some of your shares, we can easily calculate your gain or loss. You can then generate IRS Form 8949 that will show your cost for each investment you sold in the last year.

TurboTax and Investment Taxes

Do you use TurboTax to calculate your investment gains and losses?  Do you use TurboTax to generate form Schedule D or Form 8949?  If so be aware that TurboTax is now charging extra for these features.

In addition to paying $59.99 for the Deluxe version of Turbo tax, if you want to calculate your investment capital gains or losses from stock, mutual fund or ETF sales you will have to pay an additional $20 or $30.

You can read more about the changes to TurboTax here.

http://www.latimes.com/business/hiltzik/la-fi-mh-intuits-catastrophic-turbotax-20150118-column.html

If you are looking for an alternative to TurboTax for calculating your capital gains or losses, checkout EquityStat.  With EquityStat you can generate IRS Form 8949 .  Form 8949 is used to report your short and long term capital gains and loses.  Once you enter your purchases and sales of your investments into EquityStat, you can then generate Form 8949 and use this form to fill out your Schedule D Form.