Analysis of Financial Statements Worksheet

Use the worksheet below to determine if a company has the coveted Durable Competitive Advantage. Calculate the ratios and equations using the values found in the company's financial statements. Read everything and anything about the company. Understand its business and how it makes money. We also prefer to invest in companies that pay dividends.

 

Introduction

The Rundown:

 

 

Basic Information
Company Name Ticker Symbol
Date of Analysis Value of Investment

 

Weight of the Investment
Large Mid-Size Small

 

Understand the Business

Is the company very well known or has a recognizable brand name?

 

 

What does the company do and how does it make money?

 

 

Does the company pay dividends?

 

 

 

Determine if the Company has Good Management

Who is the CEO and Chairman of the company? Who are its Board Members?

 

 

Is the CEO, Chairman, and Board Members smart? Are they dumb? Are they innovative and productive? Or are they old and obsolete?

 

 

Google or find YouTube videos of the CEO, Chairman, and Board Members. Do you like their face? Is your gut feeling about them good or bad?

 

 

Does the company's management look out for the interest of shareholders? Or are they greedy and they are in it for themselves?

 

 

 

Check Mark the Durable Competitive Advantage Characteristics of the Business

Durable Competitive Advantage Characteristics of the Business
Sell a product or service that is a basic necessity Is in an industry with very little competition
Sell a unique product that doesn't change much Provides a unique service that's difficult to replicate
Is the low-cost buyer and seller of products the public constantly needs Spends very little or none at all on research and development

 

Look for a Durable Competitive Advantage Using the 10 Year Summary

10 Year Summary
Year Revenue Net Income Earnings Per Share Retained Earnings
1
2
3
4
5
6
7
8
9
10

 

Strength of Durable Competitive Advantage

If the company's 10 Year Earnings Per Share is rising, it means the company may have a Durable Competitive Advantage. In that case, we should analyze the company's Financial Statements to find out the strength of the company's durability. If the company's earnings is erratic; going through periods of losses or no profitability, then the company most likely does not have what we are looking for. In that case, stop here, there is no point in proceeding.

 

Value and Growth Analysis

Highlights of my Analysis:

 

 

 

Value and Growth Analysis
Price to Earnings Ratio 10 Year Growth Rate of Earnings/Share
Equity Bond Theory Municipal Bond Rate
Current Stock Price Relative Value
Projected 10 Year Stock Price Projected 10 Year Annual Return
Projected 10 Year Gain Projected 10 Year Fold Increase

 

Analysis of Income Statement

Highlights of my Analysis:

 

 

 

Durable Competitive Advantage Thresholds (Income Statement)
Year
Gross Profit Margin
Selling/General/Admin to Gross Profit
Research and Development to Gross Profit
Business Cost to Gross Profit
Depreciation/Amortization to Gross Profit
Interest Expense to Operating Income
Operating Income x Tax Rate
Income Taxes Paid
Operating Income x Tax Rate = Income Taxes Paid?
Net Profit Margin

 

Analysis of Balance Sheet

Highlights of my Analysis:

 

 

 

Economic Collapse Thresholds (Balance Sheet)
Year
(Net Income + Cash)/(ST & LT Debt Due)
(Net Income + Cash + Retained Earnings)/(ST & LT Due)
(Net Income + Cash + Retained Earnings)/(Current Liabilities)
Short Term Debt to Long Term Debt
Long Term Debt to Net Income
(Total Debt + Capital Expenditures)/Net Income
Adjusted Current Ratio

 

Business Efficiency Thresholds (Balance Sheet)
Year
(Property/Plant/Equipment)/Net Income
Return on Property/Plant/Equipment
Return on Equity
True Return on Equity
Return on Assets
Total Equity > 0?
If (Total Equity < 0), is Net Income Increasing?

 

Durable Competitive Advantage Thresholds (Balance Sheet)
Year
Total Receivables/Revenue < Competitors?
Total Inventory is Increasing?
Goodwill is Increasing? (Google what the company's acquisitions are)
Intangibles + Estimated Value of Brand Name
Long Term Investments (Google what the company's long term investments are)
Total Assets, is it a Huge Number?
Adjusted Debt to Equity
Preferred Stock: (Redeemable + Non Redeemable) = 0?
Retained Earnings is Increasing?
|Treasury Stock| is Increasing?

 

Price to Book Valuations (Balance Sheet)
Year
Price to Book Value
Price to True Book Value

 

Analysis of Cash Flow Statement

Highlights of my Analysis:

 

 

 

Durable Competitive Advantage Thresholds (Cash Flow Statement)
Year
Capital Expenditure/Net Income < 50 Percent?
Issuance (Retirement of Stock) < 0?
Issuance (Retirement of Debt) < 0?

 

My Financial Analysis of Stocks

  • Sold All of L Brands (LB) and Park Hotels and Resorts (PK) An article in CNBC scared us. The parent company of Victoria Secret, L Brands (LB) could be a broken company.https://www.cnbc.com/2018/05/24/victorias-secret-might ...
    Posted Jul 26, 2018, 3:41 PM by Intelligent Investor
  • We Sold All of Our Shares in PayPal, We Saw Something Else We Liked Better We dumped Paypal (PYPL). The P/E Ratio is currently at 66 which is very high. The slowdown in earnings and revenue does not justify a P/E Ratio that ...
    Posted Feb 3, 2018, 8:18 AM by Intelligent Investor
  • U.S. Bank's (USB) Return on Equity is Greater than Wells Fargo (WFC) We just realized that U.S. Bank's (USB) Return on Equity is the highest out of all the major banks. It is greater than Wells Fargo (WFC), J.P ...
    Posted Feb 3, 2018, 8:20 AM by Intelligent Investor
  • My Research 2017 View Analysis: My Research 2017
    Posted Jan 15, 2018, 4:12 PM by Intelligent Investor
  • Looks Like Capitulation in Viacom (VIAB) Capitulation is when large institutional investors give up on a stock and sell all of their holdings in that stock. Capitulation is a sign of a bottom for a stock ...
    Posted Nov 17, 2017, 10:38 AM by Intelligent Investor
  • IBM's Fortunes Finally Turns Around Today Warren Buffett purchased IBM shares in the year 2012 worth billions of dollars. Yet the stock has pummeled and has been pounded downwards for the past 5 years. The company ...
    Posted Oct 20, 2017, 1:58 PM by Intelligent Investor
  • Exchanged AT&T (T) for Time Warner (TWX) and Dumped Hilton Worldwide (HLT) I exchanged AT&T (T) for Time Warner (TWX). Their merger currently gives TWX a 6% premium. AT&T is offering $107/share for TWX. Time Warner is currently priced ...
    Posted Sep 1, 2017, 4:36 PM by Intelligent Investor
  • My Stock Holdings 2017 View Analysis: My Stock Holdings 2017Hilton Worldwide Holdings (HLT) split into 3 companies. So we now own the following 3 Hilton companies:1) Hilton Worldwide Holdings (HLT)2) Hilton ...
    Posted Aug 28, 2017, 6:46 PM by Intelligent Investor
  • Repurchased Apple After Warren Buffett Confirms He Purchased it As a rule-of-thumb, if an investment has a Return on Equity (ROE) of greater than 30%, it means the company has a Durable Competitive Advantage. Apple's Return ...
    Posted Jun 5, 2017, 12:35 PM by Intelligent Investor
  • Purchased Hilton Hotels in Anticipation of a 3 for 1 Stock Spin-Off Last December I purchased Hilton Hotels in anticipation of a 3 for 1 stock spin-off. In other words, Hilton Hotels will be splitting into 3 independent companies. The most ...
    Posted Mar 1, 2017, 6:12 PM by Intelligent Investor
Showing posts 1 - 10 of 33. View more »