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
First Solar, Inc. (FSLR)
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.1-9.4%-17.5%-164.2%-8.0%-95.3%-7.0
7
53.8%InvalidInvalidInvalidInvalid
8
93.8%InvalidInvalidInvalidInvalid
9
10
TickerFSLRSticker PricePayback TimeFischer Valuation Model
11
ExchangeUSEPS (ttm)-3.48Current PE-8.1EPS (ttm)-3.48
Last Year's Net Profit Margin
-12.1%------→10.0%
12
Stock Price$28.345-Yr Avg Net Profit Margin5.1%
13
For Rule #1 Valuation Model
Estimated EPS Growth
-37.3%
----------------→
Not Entered
User Input Margin10.0%
14
User Input Growth
Historical BVPS Growth
-8.0%Est. EPS Growth-37.33%
15
User Input PE
User Input Growth
Not Entered
User Input Growth
Not Entered
Last Year's Sales Growth-17.5%------→15.0%
16
5-Yr Avg Sales GrowthInvalid
17
For Fischer Valuation Model
Historical PE-9.2
----------------→
Not Entered
Payback Time (Yr)-3.8User Input Growth15.0%
18
User Input Margin
10%
P/E from EPS Growth
-74.7
19
User Input Growth
15%User Input PE
Not Entered
Profit Multiplier1.60
20
Sales Growth Multiplier1.36
21
10-Year EPS#VALUE!
22
Sticker Price#VALUE!Fair P/S Ratio2.18
23
Entry Price#VALUE!
Associated Blog Post
http://goo.gl/KEm3ar
Actual P/S Ratio1.01
24
Current Stock Price
28.34Template URLhttp://goo.gl/GS3RylEntry Price$61.11
25
Safety Factor
#VALUE!Version1.4.2Safety Factor2.16
Loading...
 
 
 
Stock
Big 5
Sticker Price
Payback Time
Fischer
10-Year Data
Stock Name
P/S
EPS
Estimates
Version History