ABCDEFGHIJKLMNOP
1
Rule #1 Investing Spreadsheet v1.4.1
2
3
User Inputs
4
Instructions: Change only the values in this User Inputs section. Leave everything else in this spreadsheet as is.Big 5
5
AverageROICSales GrowthEPS GrowthBVPS GrowthFree Cash Flow GrowthYears to Repay Debt
6
1InvalidInvalidInvalidInvalidInvalid#VALUE!
7
5#DIV/0!InvalidInvalidInvalidInvalid
8
9#DIV/0!InvalidInvalidInvalidN/A
9
TickerMCD
10
ExchangeUSSticker PricePayback TimeFischer Valuation Model
11
EPS (ttm)#N/ACurrent PE#N/AEPS (ttm)#N/A
Last Year's Net Profit Margin
0.0%------→0.0%
12
For Rule #1 Valuation Model
Stock Price5-Yr Avg Net Profit Margin#DIV/0!
13
User Input Growth
Estimated EPS Growth
#VALUE!----------------→0.0%User Input Margin
Not Entered
14
User Input PE
Historical BVPS Growth
0.0%Est. EPS Growth#VALUE!
15
User Input Growth
Not Entered
User Input Growth
Not Entered
Last Year's Sales GrowthInvalid------→Invalid
16
For Fischer Valuation Model
5-Yr Avg Sales GrowthInvalid
17
User Input MarginHistorical PE0.0----------------→0.0Payback Time (Yr)#N/AUser Input Growth
Not Entered
18
User Input Growth
P/E from EPS Growth
#VALUE!
19
User Input PE
Not Entered
Profit Multiplier0.00
20
Sales Growth Multiplier#VALUE!
21
10-Year EPS#N/A
22
Sticker Price#N/AFair P/S Ratio#VALUE!
23
Entry Price#N/A
Associated Blog Post
http://goo.gl/2gedCiActual P/S Ratio#VALUE!
24
Current Stock Price
Template URLhttp://goo.gl/JlQYt4Entry Price#VALUE!
25
Safety Factor#N/AVersion1.4.1Safety Factor#VALUE!