Excel Spreadsheet

Rule Maker Essentials Template

You must be logged in to download this document
Reviews
Shared by: Marie Ruby
Categories
Stats
views:
22
downloads:
1
rating:
not rated
reviews:
0
posted:
4/1/2008
language:
English
pages:
0
The Motley Fool's Rule Maker Essentials There seems to be some perverse human characteristic that likes to make easy things difficult. - Warren Buffett We Fools love Mr. Buffett's pithy quotes. Is it a coincidence that Buffett -- one of the most successful investors of all time -- hails not from Wall Street, but from America's heartland -Omaha, Nebraska? We think not. Buffett shuns Wall Street's bewildering ways. And, so should you, Fool. Buffett's success is the result of his rational assessment of businesses. Believe it or not, finding great companies is not complicated! Easy -- no; but, simple -- yes. If you're new to Rule Maker investing, this spreadsheet is for you. By inputing some basic financial data and answering a few questions, you'll quickly be able to tell whether a company is a cash-generating, industry-dominating, wealth-creating powerhouse -- what we call a Rule Maker. Directions: We've identified 11 general attributes of Rule-Making companies. Part 1 covers five qualitative aspects of a business. For each of these, the scoring is simple -1 point if the attribute is met, 0 points if it's not. Part 2 covers six financial criteria. Since these are more objective, each is worth 2 points if met, 0 points if not. Altogether, that's 17 possible points. Got it? If so, pick a company to analyze and let's get started! *Note* Rule Maker analysis is primarily for companies with at least $1 Billion in annual sales. Part 1: Evaluating the Biz -- Answer honestly! It's either 100% yes, or else no. 1) Dominant Brand -- Is the company the standout category king within its industry? 2) Repeat Purchases -- Do customers return for purchase at least once a month? 3) Convenience -- Within its industry, is the company's product/service accessibility and convenience the best ? 4) Expanding Possibilities -- Can you answer "yes" to the following two questions? a) Do your friends know about and use the product/service? b) Is worldwide expansion believable for their stuff? 5) Your Familiarity & Interest -- Are you a user of the company's products or at least very familiar with them? Answer Choose Choose Choose Points Choose Choose Part 2: Company Financials -- Fill in the cells outlined in blue. The spreadsheet will crunch the numbers. *Important Note* -- When evaluating quarterly (10-Q) results, use the year-to-date income statement data. For example, if a company is 3/4 of the way through its fiscal year, use the full 9 months of info. Hey Fool! Put your cursor right HERE Finding Financial Data Income Statement: Sales Prior-year Sales Cost of Goods Sold Net Income Balance Sheet: Cash & Equivalents Current Assets Current Liabilities Short-term Debt Long-term Debt Cash Flow Statement: Operating Cash Flow Capital Expenditures Our Standard 6) Sales Growth > 10% Actual Result Calculation Sales Pr. Yr. Sales (Revenue - COGS) Revenue Net Income Revenue Cash & Equivalents (ST Debt + LT Debt) (Current Assets - Cash & Equiv.) (Current Liab. - ST Debt) (Operating Cash Flow - Cap. Ex.) Revenue Points 7) Gross Margins > 50% 8) Net Margins > 7% 9) Cash-to-Debt Ratio > 1.5 or No Debt < 1.25 10) Foolish Flow Ratio 11) Cash King Margin > 10% Total Score = Rule Maker Beginners board Finished? Don't forget to save! Want to Modify this Sheet? Last Updated on April 3, 2000 Results as of Most Recent SEC Filings on 4/3/00 KO Business Basics 1) Dominant Brand 2) Repeat Purchases 3) Convenience 4) Expanding Possibilities 5) Your Familiarity & Interest Company Financials 6) Sales Growth 7) Gross Margins 8) Net Margins 9) Cash-to-Debt 10) Flow Ratio 11) Cash King Margin Total Score 1 1 1 1 1 0 2 2 0 2 2 13 MSFT 1 1 1 1 1 2 2 2 2 2 2 17 GPS 1 1 1 1 1 2 0 2 0 2 0 11 INTC 1 1 1 1 1 2 2 2 2 2 0 15 CSCO 1 1 1 1 1 2 2 2 2 2 2 17 SGP 0 1 0 1 1 2 2 2 0 2 2 13 PFE 1 1 0 1 1 2 2 2 0 0 0 10 YHOO 1 1 1 1 1 2 2 2 2 2 2 17 TROW 1 1 1 1 1 2 2 2 2 2 2 17 JDSU 1 1 1 1 1 2 0 0 2 0 0 9 NOK 1 1 1 1 1 2 0 2 2 2 0 13
Related docs
Rule Maker Essentials Template
Views: 22  |  Downloads: 1
rule maker essentials from Motley Fool
Views: 85  |  Downloads: 0
Rule Maker Essentials
Views: 107  |  Downloads: 1
Rule Maker Essentials[1]
Views: 63  |  Downloads: 0
The Motley Fool's Rule Maker Essentials
Views: 184  |  Downloads: 6
Rule Maker Template
Views: 29  |  Downloads: 4
The Motley Fool's Rule Maker Ranker
Views: 211  |  Downloads: 15
Rule Maker Ranker from Motley Fool
Views: 71  |  Downloads: 0
Rule Template
Views: 2  |  Downloads: 0
Rule Maker Ranker
Views: 156  |  Downloads: 5
RULE MAKER RANKER[1]
Views: 59  |  Downloads: 0
Business Rule Template
Views: 0  |  Downloads: 0
Design Rule Template
Views: 8  |  Downloads: 0
The Motley Fool's Rule Maker Ranker
Views: 168  |  Downloads: 4
Other docs by Marie Ruby
Yearly Calendar Template
Views: 989  |  Downloads: 23
Work Schedule Template
Views: 834  |  Downloads: 41
Capital Budgeting Template
Views: 213  |  Downloads: 21
What-If Analysis Template
Views: 308  |  Downloads: 48
Weekly Calendar Template
Views: 285  |  Downloads: 19
Tool Project Manager Template
Views: 186  |  Downloads: 31
Time Value of Money Template
Views: 135  |  Downloads: 2
Timeline Template
Views: 569  |  Downloads: 6
Three-Year Profit Projection 1 Template
Views: 159  |  Downloads: 7
Capital Budgeting 2 Template
Views: 112  |  Downloads: 1