A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | Average | ROIC | Sales Growth | EPS Growth | BVPS Growth | Free Cash Flow Growth | Years to Repay Debt | |||||||||
6 | 1 | Invalid | Invalid | Invalid | Invalid | Invalid | #VALUE! | |||||||||
7 | 5 | #DIV/0! | Invalid | Invalid | Invalid | Invalid | ||||||||||
8 | 9 | #DIV/0! | Invalid | Invalid | Invalid | N/A | ||||||||||
9 | Ticker | MCD | ||||||||||||||
10 | Exchange | US | Sticker Price | Payback Time | Fischer Valuation Model | |||||||||||
11 | EPS (ttm) | #N/A | Current PE | #N/A | EPS (ttm) | #N/A | Last Year's Net Profit Margin | 0.0% | ------→ | 0.0% | ||||||
12 | For Rule #1 Valuation Model | Stock Price | 5-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 Growth | Invalid | ------→ | Invalid | ||||||||
16 | For Fischer Valuation Model | 5-Yr Avg Sales Growth | Invalid | |||||||||||||
17 | User Input Margin | Historical PE | 0.0 | ----------------→ | 0.0 | Payback Time (Yr) | #N/A | User Input Growth | Not Entered | |||||||
18 | User Input Growth | P/E from EPS Growth | #VALUE! | |||||||||||||
19 | User Input PE | Not Entered | Profit Multiplier | 0.00 | ||||||||||||
20 | Sales Growth Multiplier | #VALUE! | ||||||||||||||
21 | 10-Year EPS | #N/A | ||||||||||||||
22 | Sticker Price | #N/A | Fair P/S Ratio | #VALUE! | ||||||||||||
23 | Entry Price | #N/A | Associated Blog Post | http://goo.gl/2gedCi | Actual P/S Ratio | #VALUE! | ||||||||||
24 | Current Stock Price | Template URL | http://goo.gl/JlQYt4 | Entry Price | #VALUE! | |||||||||||
25 | Safety Factor | #N/A | Version | 1.4.1 | Safety Factor | #VALUE! |