Free 7-day Trial
All Articles and Columns »

10-Year Financials are Now Available; Features in the Example of Walgreen Company and USG Corp.

August 07, 2008 | About:
insider

About two months ago, we informed our users that we have licensed 10-year financial data. The data is now available to all users. Here we like to introduce the features in the new page.

The financials data covers over 8000 stocks traded on the big three exchanges in the US . The URL for all the financial data is: http://www.gurufocus.com/financials.php?symbol=[symbol], from here you can easily switch any other stocks by enter the symbol in the “Go” box at the top right corner.

Based on the suggestions of our users and the creativities of GuruFocus staff, the new financial page has these features.

All reports are in the same page, annuals and quarterly

As suggested by our users, all three financial statements (balance sheet, income statement, and cashflow statement) are at the same page. 10-year data is listed from left to the right in the sequence of fiscal year so that users can better see the trend of the business.

The latest 4 quarters of data is shown at the right most column, distinguished from the annuals with different colors.

Hopefully it is now easier for our users to see all the information at once.

Per share data

In order to make it even clearer for our users, we have also listed the per share data. The data includes:

  • Revenue per Share = Total Revenue / Total Shares Outstanding
  • Earning per Share = Net income / Total Shares Outstanding
  • Book value per Share = Total shareholder equity / Total Shares Outstanding
  • Free Cash Flow per Share = (Cash flow from operations + (increase) Decrease in Prop,Plant,& Equipment) / total shares outstanding,

Valuation Ratios

We have listed the historical valuation ratios so that users can see the change of these ratios over time. These ratios are defined as:

  • Return on Equity (ROE) = Net Income / Total Shareholder Equity
  • Return on Asset (ROA) = Net Income / Total Asset
  • Return on Capital (ROC) = Net Income / Total Fixed Asset (Total Asset less Intangibles)
  • Debt to Equity = Total Debt / Total Shareholder Equity
  • Gross Margin = Gross Income / Total Revenue = (Total Revenue – Cost of Goods Sold) / Total Revenue
  • Operating Margin = Operating Income / Total Revenue = (Total Revenue – Cost of Goods Sold – SGA – RND) / Total Revenue
  • Net Margin = Net Income / Total Revenue

Visualize

In order to make the financial statements more straight forward to users, we had made the data more visible by using charts. You can click on any row of data in the financial page to show the data in chart. Clicks on the rows of “Fiscal Period” display the summary of the data.

Business Predictability

With visualized data it is now much easier to interpret the data. For instance, if you take a look at the trend of “Revenue” and “Net Income” of Walgreen Company , go to: http://www.gurufocus.com/financials.php?symbol=wag. Then click on the row of “Revenue” and “Net Income”, charts like this will appear:


A 10-year exponential growth trendline is automatically added. Now you can easily to the predictability of the business by looking at the discrepancy between data and the trendline. In the case of WAG we can clearly see that it is a very predictable business with a 10-year revenue growth of 15.1% per year, and 5-year revenue growth of 13.2%.

In contract to the Walgreen, take a look at the net income of USG Corp. This is what we get. We can clearly see how “predictable” this business is.

Economic Moat

Does the business have economic moat? One indicator is if the Walgreen company can keep or even expand its profit margin while growing its earnings. We can look at the chart of gross margin by click on the row of “Gross Margin”. This is what we get:

Buying back shares?

Does the company buying back shares? Click on the row of “Shares Outstanding”. We get this chart:

We can see that Walgreen issued share before, but it has been buying back shares over the past 5 years at an average rate of -0.8% per year.

Be Creative and Customize Your Charts

You can use the Customized Chart to create the charts that are not available by simply clicking the data. You can select multiple sets of data and draw them against any other set of data. An example of ROE, ROC and ROA over the past 10 years for Walgreen is shown here:

Share: Webmasters, and bloggers, place the chart on your site

If you are blogging or running your own website, you can place the chart on your site by copying and pasting the chart html code into your site. The chart code is available by clicking “Place This on Your Site” link. A text box like this will show up:

Final Comments

The data is licensed from a third party, and we do not place any ads in the context of data so that our users can concentrate on their investment research. If you find our work useful, please let others know about this as well.

If you have any suggestions or comments, please reply in the comment area of the article. GuruFocus is devoted to the excellence of value investing research and is always getting better. If you find this work useful and would like to try other research tools on our site, you are invited for a Free Trial of GuruFocus Premium Membership.

 


Rating: 3.2/5 (65 votes)

Comments

waileacapital
Waileacapital - 5 years ago
Love these charts! Thanks Charlie!
bloveday
Bloveday premium member - 5 years ago
Great addition to the sevices you offer!
hpmst3
Hpmst3 - 5 years ago
.
Eric McGough
Eric McGough premium member - 5 years ago
Fantastic!

Now if I could only screen for companies based on based 5 or 10 year averages that would be absolute heaven:

10 year ROE average > X

10 year debt/equity average < X

10 year profit margin average > X

etc, etc, etc

hpmst3
Hpmst3 - 5 years ago
.
sm2200
Sm2200 premium member - 5 years ago
I miss the feature you had up until a few momths ago, that is on the top tool bar, one could enter a stock's symbol and find out who had it in their portfolio.

I also wish you had a way that we could communicate with you. Would recommend on toolbar a "Contact Us" key.

Sam Marx sgm2200@comcast.net
augustabound
Augustabound - 5 years ago
hpmst3 Wrote:

>They said that for ten year rate,

> they take the last 3 years and average them.

>Then they go back ten years and average the three

> years.

>They then take the the two averages and compute the annualized growth rate.

You lost me on the second step with going back ten and averaging 3 years.

If I interpret that right we would average the last 3 years

The second step would be to average the last ten years?

Then average those two to get a ten year growth rate.
Gangstarr
Gangstarr - 5 years ago
This site gets better all the time! Thank you for providing so much useful information free of charge.
kfh227
Kfh227 premium member - 5 years ago
Augustabound,

I think what was meant was the following:

Average 2005,2006,2007.

then average 1995,1996,1997.

Then using those averages, figure out an annual rate. it makes sense because it would soften the effect of an oddly high or oddly low year. For long term oriented investors (most here) it makes alot of sense.
Sivaram
Sivaram - 5 years ago
One additional request...

Can you add historical year-end P/E, P/S, P/BV, and dividend yield? Similar to how you are showing ROE, margin, etc for the year-end, it would help a lot if you showed the valuation measures.

Thanks...
augustabound
Augustabound - 5 years ago
kfh227 Wrote:

-------------------------------------------------------

> Augustabound,

>

> I think what was meant was the following:

>

> Average 2005,2006,2007.

> then average 1995,1996,1997.

>

> Then using those averages, figure out an annual

> rate. it makes sense because it would soften the

> effect of an oddly high or oddly low year. For

> long term oriented investors (most here) it makes

> alot of sense.

Ok thanks kfh. I was confused by the 3 and 10 year average in the second step.

I can see the value in not wanting a great or poor year to hinder an average.

hpmst3
Hpmst3 - 5 years ago
.

gurufocus
Gurufocus premium member - 5 years ago
Eric McGough:

Yes, we will add these into the "Guru Screener" we have, which is for Premium Members, and you are one of them.

Hpmst3:

We are using Least Squares Fitting method to fit 10-year data for growth rate. In this way, all the data points in the 10 years contribute to the fit, instead of just first 3 years and the last 3 years. It is not Grapham did not know Least Squares Fitting , but it might be difficult to do Least Squares Fitting at his time.

Good thing with Least Squares Fitting is that it gives you the accuracy of the fitting, which will be used to measure the predictability of business later.

Gangstarr:

Thank you for your comment

Sm2200:

The search box is added back. We hope to use the "symbol Look up" box to replace the "Search" box, it works, but it might be slower. Anyway, we will keep both of them.

Also we do have a "contact us" link at the bottom toolbar.

Sivaram:

Those and a lot more other features will be added, we are still working on the data. Also some of these features will be for Premium Members.

Thank you all for the comment!

Rajer
Rajer - 5 years ago
I am relatively New to GuruFocus.

How ever I am really impressed with what the Site offers.

This 10 year Feature, is something I have been looking for and I will post more comments after using it for some time.

My thanks to Guru's team for this excellent info. site.

Thanks to Monish for introducing this site to mYself.Thanks you and wishing you the best.
sm2200
Sm2200 premium member - 5 years ago


Thanks for returning the feature you had up until a few momths ago, that is on the top tool bar, where one could enter a stock's symbol and find out who had it in their portfolio.

However, I still suggest that you add somewhere on top of the page a simple way of communicating with you, such as a "CONTACT US " key.

biojohn
Biojohn - 5 years ago
Wow! This is great and the least squares fit is a nice touch. This work you've done really opens up a lot of interesting possibilities for added features. Here are a couple of thoughts:

1) First, when I put my cursor over the per share data points on the trend line of the graph, I only see one place to the right of the decimal point. I'd like to expand that to two places when looking at the per share data.

2) Would be interesting to add multiples (P/E, P/B, EBIT/EV, etc.) as an additional section to the 10 year financials information.

3) Integrate the Screener so that it can screen for data points in the 10 year financials.

4) Use the FCF trendline, along with a cost of equity calculation to obtain a mechanically-derived present value. You could even use the least squares fit to come up with a standard error estimate of that present value.


Again, thanks for the service!

aviad123
Aviad123 - 5 years ago
Great thing!

You didn't mention one important thing: where is the financial data taken from? Who is the supplier?
KingCroesus
KingCroesus - 5 years ago
Stumbled on this site....found the 10 year financials. LOVE. Keeping GuruFocus on the short list! :)
DTEARE
DTEARE - 5 years ago
This site is GREAT! How do i get ROIC ?
JoePass
JoePass premium member - 5 years ago
What does "TTM" represent?

gurufocus
Gurufocus premium member - 5 years ago
TTM = Trailing Twelve Months
siavash
Siavash - 3 years ago
As Aviad pointed out, what's the source of data? Certain data sets are cleaner than others (ie Compustat). Otherwise, very helpful, thanks.
cm1750
Cm1750 premium member - 3 years ago
I also would like to see ROIC.

Since many of us are FCF junkies, having CROIC would be nice also, where CROIC is FCF/(net debt+equity-excess cash). Excess cash may be tough as it is pretty subjective.

Hmcustodio
Hmcustodio premium member - 3 years ago
According to the instructions, to close the charts one clicks the row above the chart. In my case, when I click the row above the chart, a duplicate chart opens.
gurufocus
Gurufocus premium member - 3 years ago
Which browser are you using? Should work find under Firefox and IE.
Hmcustodio
Hmcustodio premium member - 3 years ago
I use Chrome. Can you fix it?

Which browser are you using? Should work find under Firefox and IE.
michaelwang18
Michaelwang18 - 2 years ago
i have a hard time to reproduce your free cash flow numbers from the data on the page.

it is probably not calculated as you stated:

Free Cash Flow per Share = (Cash flow from operations + (increase) Decrease in Prop,Plant,& Equipment) / total shares outstanding

most people agree that is the right formula to use?

Alex Garcia
Alex Garcia premium member - 2 years ago
Yes it is. I would double check by reading the company's 10-K or 10-Q.
Cornelius Chan
Cornelius Chan - 2 years ago
Amazing tools in 1 website. I just signed up for Premium. Looking forward to getting much use from your site.

I have a question though: what currency date and rate do you use in your 10-year financials for Nokia (NOK)? Euro to USD.

Thanks.
gurufocus
Gurufocus premium member - 2 years ago
All $million USD.
nwht
Nwht premium member - 8 months ago
I am a premium member and use the 10 Y Financials section a lot. Though the new graphs are great, I really miss the trendlines with the percentage growth that were available when you clicked on the rows of data. Please can you let me know if these will be returning?
gurufocus
Gurufocus premium member - 4 months ago
The trendline has been added back.

Please leave your comment:


Get WordPress Plugins for easy affiliate links on Stock Tickers and Guru Names | Earn affiliate commissions by embedding GuruFocus Charts
GuruFocus Affiliate Program: Earn up to $400 per referral. ( Learn More)
Free 7-day Trial
FEEDBACK
Hide