Save Untold Analysis Hours with this Powerful Spreadsheet.
Get access to powerful stock analysis tools that will save you countless hours. Just enter a stock to analyze it in full detail. Read what others have to say.
"In 30 seconds, it provides a quick glance into a stock’s financials to see if it’s worth a closer look, automating much of the tedious work of manually entering numbers for various calculations.In the past two years, I’ve personally ran hundreds upon hundreds of stocks through these spreadsheets, saving untold hours..." - More reviews
Berkshire Hathaway’s 13-F revealing a big sell off of JNJ, created a huge wave of news about whether Buffett has gone sour on the business. With everyone offering tremendous terms to Buffett in order to borrow from his horde of cash, I wouldn’t be surprised if he is getting better deals from these American icons than what JNJ is offering.
Rather than getting swamped with the noise, analyzing the numbers itself reveals that JNJ is in fine condition.
I think it is safe to say that JNJ requires no introduction. Here are some points to note regarding JNJ from the following PDF analysis.
Quick Look at the Financial Statements
Gross profit maintained at 70%
SG&A steady at 33%
Slight reduction in R&D
Larger than usual Other expense (requires digging into footnotes)
Decline in net margin to 17.3% which is around the same level during the previous recession
Steadily increasing accounts receivables, inventory and other assets
Doubled intangibles in 2006
Tripled long term debt from 2006 but still capable of paying it off easily
Other long term liabilities doubled
FCF growth maintained more than 10 years
Very good, strong and consistent numbers but the increase in debt should be looked at
Bottom line margins declining. JNJ is still subject to a recessionary environment. We think that people will still maintain their baby powder, band aids and shampoos, but when it gets tough, most resort to the cheaper and generic brands.
DCF values JNJ at $71 which is the peak price from 2008
Plenty of FCF to cover debt
Ben Graham formula values JNJ at $108 which is overly optimistic
JNJ has always been trading close to its intrinsic value but the recent dip is the biggest stray from the intrinsic line to date
Compared to its competitors, JNJ is not trading at a premium. A very respectable PE of 12.
Highest earnings yield in a long time of 13%
Johnson & Johnson still remains to be a solid company. Whether Buffett himself or his subsidiaries sold it or not, the business continues to pump out cash. Just the way I like it.
My wife and I are Christians and our focus is to love God and love people. We are proud supporters of Compassion and are grateful to be sponsoring several children. We are just two ordinary people and understand that we cannot change the world. However, that doesn't mean we can't try. Call me crazy, but our dream is to one day sponsor 1,000 children around the world. Thank you for helping us achieve this one child at a time.
Try the Free Spreadsheets
Unsure and want to try out a free version? Sign up with your email to receive free working spreadsheets straight to your inbox. The spreadsheets are 100% free working versions with no limited trial period. By signing up with your email, you are also opting in to receive blog articles to your inbox
* Calculation time will vary based on internet speed, computer speed, software version and hardware configuration. The material from Old School Value, this spreadsheet or any affiliate sites have no regard to the specific investment objectives, financial situation, or particular needs of any visitor. Information, tools and articles published are solely for informational purposes and are not to be construed as a solicitation or an offer to buy or sell any securities or related financial instruments. References made to third parties are based on information obtained from sources believed to be reliable, but are not guaranteed as being accurate. Visitors should not regard it as a substitute for the exercise of their own judgment. Any opinions expressed in this site are subject to change without notice and Old School Value or any affiliated sites or authors are not under any obligation to update or keep current the information contained herein.
Old School Value, officers, associates or clients may have an interest in the securities or derivatives of any entities from Old School Value or the Old School Value Stock Valuation Spreadsheets referred herein. Old School Value accepts no liability whatsoever for any loss or damage of any kind arising out of the use of all or any part from Old School Value or any of the tools containing the name Old School Value. Our comments are an expression of opinion. While we believe our statements to be true, they always depend on the reliability of our own credible sources.