Rule 1 - Google Docs Template - Ver 1.4.2 Public (Locked)
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJKLMNOP
1
Rule #1 Investing Spreadsheet v1.4.2
2
3
Click on File > Make a Copy to save a copy for yourself
4
Big 5
5
User InputsAverageROICSales GrowthEPS GrowthBVPS GrowthFree Cash Flow GrowthYears to Repay Debt
6
Instructions: Change only the values in this User Inputs section. Leave everything else in this spreadsheet as is.1InvalidInvalidInvalidInvalidInvalid#DIV/0!
7
5#DIV/0!InvalidInvalidInvalidInvalid
8
9#DIV/0!InvalidInvalidInvalidInvalid
9
10
TickerFSLRSticker PricePayback TimeFischer Valuation Model
11
ExchangeUSEPS (ttm)Current PE#DIV/0!EPS (ttm)
Last Year's Net Profit Margin
0.0%------→10.0%
12
Stock Price$39.745-Yr Avg Net Profit Margin0.0%
13
For Rule #1 Valuation Model
Estimated EPS Growth
0.0%
----------------→
0.0%User Input Margin10.0%
14
User Input Growth
Historical BVPS Growth
0.0%Est. EPS Growth0.00%
15
User Input PE
User Input Growth
Not Entered
User Input Growth
Not Entered
Last Year's Sales GrowthInvalid------→15.0%
16
5-Yr Avg Sales GrowthInvalid
17
For Fischer Valuation Model
Historical PE0.0
----------------→
0.0Payback Time (Yr)#DIV/0!User Input Growth15.0%
18
User Input Margin
10%
P/E from EPS Growth
0.0
19
User Input Growth
15%User Input PE
Not Entered
Profit Multiplier1.60
20
Sales Growth Multiplier1.36
21
10-Year EPS$0.00
22
Sticker Price$0.00Fair P/S Ratio2.18
23
Entry Price$0.00
Associated Blog Post
http://goo.gl/KEm3ar
Actual P/S Ratio
24
Current Stock Price
39.74Template URLhttp://goo.gl/GS3RylEntry Price#DIV/0!
25
Safety Factor
0.00Version1.4.2Safety Factor#DIV/0!
Loading...
 
 
 
Stock
Big 5
Sticker Price
Payback Time
Fischer
10-Year Data
Stock Name
P/S
EPS
Estimates
Version History