Analyzing the Balance Sheet the Right Way with this Walkthrough


Written by

Jae Jun

follow me on

Facebook

Twitter

What You Will Learn

  • How to analyze the balance sheet and find less risky stock ideas
  • How to analyze the balance sheet using circuit city as an example

So far, we’ve had a look at the Statement of Cash Flows with AeroGrow with a further discussion on Free Cash Flow, Croc’s Income Statement and now the Balance Sheet for Circuit City.

To help get new investors started, here are some great resources on the Balance Sheet:

Circuit City Balance Sheet (click to enlarge)

Balance Sheet Analysis

Balance Sheet Analysis

Cash

Any company with lots of cash is a reassurance to investors that the company should be able to survive during downturns as well as expand during booms.

Divide the cash by the number of shares outstanding to see how much of the stock price is made of cash. On Feb 29, 2008, Circuit City had $1.76 in cash per share but by August 31, 2008, that number dropped to $0.54 and has probably dropped further since then.

If the cash per share is greater than the share price, it could be a potential net net.

Accounts Receivables

As I covered in the Statement of Cash Flows, accounts receivables is an indication of whether the company is able to collect its payments. If accounts receivables decrease from the previous years (you have to compare by going back a few years), the company  has been able to collect its money.

If this is continually increasing, the company is either willing to sell to anyone or the company may have become lenient in its payment policies to customers which could lead to an inflation of earnings causing nasty surprises later on.

Compare the increase in accounts receivable with increase in sales. e.g. If accounts receivables has increased 120% while sales only increased 90%, the company is not collecting bills.

download

I’ve only displayed a quarterly statement for Circuit City but if we look back at the previous statements, Circuit City has been unsuccessful in reducing this line. Although the sum of $330mil is a good reduction from $447mil in Nov 2007, the overall story shows that Circuit City has an unimpressive payment collection system.

Inventory

One of the most important aspects of the balance sheet. Ben Graham has written that inventory should be marked down to 50% of its valuation when calculating a liquidating value. This is true especially when it comes to electronics. With a product life cycle lasting only a few months, old inventory will continually have to be discounted.

Inventory should also be compared with cost of goods. This inventory indicator is a reliable sign of whether a manufacturer or retail company will stumble if the difference is substantial. In terms of inventory growth, Circuit City hasn’t done too bad of a job but their inventory level is far too high for a business of their size.

It’s also a good idea to compare the inventory turnover with competitors. While Best Buy has been able to turn over its inventory 6.9x times a year for the past 5 years, Circuit City has only managed an average of 5.5x in the past 5 years.

A further discussion of inventory will be required in another post as we look at how companies calculate and state the value of inventory.

Click to get your ratios list now

One Time Items

Deferred income taxes and income tax receivables should not be considered as part of business assets. They add no value to the operations of the business. Hopefully these numbers are kept low and not included too often. Circuit City needs all the cash it can get. It shouldn’t be overpaying taxes and waiting to receive it without interest from the government.

PP&E and Goodwill

PP&E is an illiquid asset and is mostly taken into consideration when the company is liquidating.

If the company owns land, additional research would be to find today’s market value of the land.

As most readers know, goodwill is best ignored. No tangible value exists and impairment charges usually always appear from a goodwill that is too high.

Although Circuit City “may” have a brand, I believe there is no tangible value because there is nothing stopping a consumer from crossing the road to Best Buy if they have better prices.

Liabilities

Liabilities is much like the assets section. There are payments that have to be made and if this number increases, the company has not been paying their bills.

Circuit City’s problem is that they are overladen with debt and no cash. They need to pay suppliers in excess of $750 mil, expenses in the amount of $270 mil and $343 mil for accrued expenses and other liabilities as well as a short term debt of $215 mil due shortly. With only $91 mil in cash and the rest tied up in inventory, no wonder the suppliers demanded cash up front for delivery of items.

Also, watch out for companies like Circuit City that have accrued so many expenses. These are obligations that must be paid which will hit earnings hard.

Circuit City has also been deferring its rent credits. Companies often abuse deferred charges by pushing expenses into the future so that they can inflate earnings even when things are not going so great.

Circuit City’s “other” liabilities add up to over $150 mil so its always important to check the footnotes as well as the possibility of off balance sheet liabilities.

Quality of assets

Quality of assets is something you should always be asking yourself whenever going through a balance sheet. Circuit City’s assets are made up of mostly inventory, property and equipment. However, we know that electronics cant hold their value for more than a few months and Circuit City does not own their stores (land). So all the stated property and equipment is probably associated to shelves, tables and other shop fitting items. Nothing that can fetch full value.

Quality of assets for Circuit City? BAD

Summing Up

  • Cash helps companies survive and grow.
  • Watch the trend in Accounts Receivables. Be careful of companies unable to collect money.
  • Take the value of inventory stated on the balance sheet with a grain of salt. Different accounting methods (FIFO, LIFO) produce different ending values even though the products are the same.
  • One time items in assets should not appear often such as sale of assets.
  • PP&E is illiquid and should be considered mostly in asset plays or liquidation. Ignore goodwill.
  • All debt isn’t bad. Just when you can’t afford it.
  • Assets should be high quality (cash is best)

This is how you should do proper Balance Sheet Analysis.

Click to get your ratios list now

Pick Winning Stocks and Fatten Your Portfolio
LIVE PREVIEW OF AAPL, MSFT