# Fat Pitch Finder Spreadsheet Version 0.2

Last year, I put together a stock analysis spreadsheet to help me to track a list of wide moat companies that I’m interested in investing in for the long term. I finally have finished updating that spreadsheet.

This new version of the **Fat Pitch Finder Spreadsheet** has been updated to address a problem with my net cash calculations that I discovered as a result of a comment I received on my analysis of the intrinsic value of Microsoft. I wasn’t including restricted cash when determining net cash on hand, so I was undervaluing some companies. In addition, I also added the following new features:

- Increased documentation using cell comments
- New Free Cash Flow trend chart
- Added trailing twelve-month free cash flows to the trend analysis
- Cash and equivalents and debts are now broken out before net cash is calculated

To use this spreadsheet, you need to have Microsoft Excel, and I recommend that it is at least the Excel 2003 version. In addition, you need to install an “Add-In” to make the Fat Pitch Finder spreadsheet work. The add-in you need is **RCH_Stock_Market_Functions.xla** at the smf_addin group files. Be sure to install the add-in in the directory **C:\Program Files\SMF Add-In** in order for the spreadsheet to work. Finally, download the spreadsheet below and uncompress it before opening it.

If you find any problems with the Fat Pitch Finder spreadsheet or have any ideas on how to improve it, please share your thoughts below.

**Download:** Fat Pitch Finder 0.2

Pingback:Festival of Stocks #29 - Fat Pitch Financials

Hy, when i run your excel programa i have all numbers multiplied by 1000. Why?

Thank you and thanks for all topics you post.

When I open the spreadsheet, I get this alert “Microsoft Excel cannot find ‘RCHGetElementNumber’ on ‘RCH_Stock_Market_Functions.xla’. There are two possible reasons: + The name you specificed may not be defined. + The name you specified is defined as something other than a rectangular cell reference. Check the name and try again.” Errors ensue.

Eeep!?!

I get the same message as Kent. Any tips?

Hey there,

I’ve just installed the spreadsheet and have come upon some problems. I know it’s installed correctly because for some stocks, it works. But here’s the problem, about half of the time, it’s full of errors. I did some investigating, and it all seems to lead to cell W6. Just as an example, ticker ANF came up with the errors. So I looked up the definitions of what that cell needed, which Cash from Operating Activities from the last 4 quarters, and then Capital Expeditures for the same last 4 quarters. I entered it all into the spreadsheet, and all of the numbers popped up, no errors.

So, I would like to ask that you take a look at cell W6. I’m beginning to think the cell is not the problem, but maybe websites that it is pulling info from? I don’t know for sure.

Thanks!

So, I did a little more homework, and the problem is obviously that the spreadsheet cannot get the information it needs from Google. So, I searched in the definitions for different quarterly reports. The numbers for AdvFN’s cash from operating activities are 11366, 11367, 11368, and 11369. But, getting the capital expenditures is a little harder. Exactly what forms the capital expenditures? I tried to find out online, but could receive no reasonable answer. On AdvFN’s “investing activities”, they have many more options listed than google does. But, from the articles I read online, I concluded that capital expenditures include the “purchase of property, plant & equipment” option, and the “acquisitions” option. So here are the numbers for that: 11446, 11447, 11448, 11449, 11466, 11467, 11468, and 11469.

Therefore, the W6 cell should have this formula (I think and hope!):

=SUM(RCHGetElementNumber($A6,11366),RCHGetElementNumber($A6,11367),RCHGetElementNumber($A6,11368),RCHGetElementNumber($A6,11369),RCHGetElementNumber($A6,11446),RCHGetElementNumber($A6,11447),RCHGetElementNumber($A6,11448),RCHGetElementNumber($A6,11449),RCHGetElementNumber($A6,11466),RCHGetElementNumber($A6,11467),RCHGetElementNumber($A6,11468),RCHGetElementNumber($A6,11469))

——————-

Well, a few minutes has passed, I wanted to do a little more research before I posted this, it turns out that AdvFn’s quarterly numbers are vastly different from Googles, creating some inconsistent results. Some of the quarters information are exactly the same, others are totally different. I don’t know!!! Anybody out there got some ideas?

So, I did a little more homework, and the problem is obviously that the spreadsheet cannot get the information it needs from Google. So, I searched in the definitions for different quarterly reports. The numbers for AdvFN’s cash from operating activities are 11366, 11367, 11368, and 11369. But, getting the capital expenditures is a little harder. Exactly what forms the capital expenditures? I tried to find out online, but could receive no reasonable answer. On AdvFN’s “investing activities”, they have many more options listed than google does. But, from the articles I read online, I concluded that capital expenditures include the “purchase of property, plant & equipment” option, and the “acquisitions” option. So here are the numbers for that: 11446, 11447, 11448, 11449, 11466, 11467, 11468, and 11469.

Therefore, the W6 cell should have this formula (I think and hope!):

=SUM(RCHGetElementNumber($A6,11366),RCHGetElementNumber($A6,11367),RCHGetElementNumber($A6,11368),RCHGetElementNumber($A6,11369),RCHGetElementNumber($A6,11446),RCHGetElementNumber($A6,11447),RCHGetElementNumber($A6,11448),RCHGetElementNumber($A6,11449),RCHGetElementNumber($A6,11466),RCHGetElementNumber($A6,11467),RCHGetElementNumber($A6,11468),RCHGetElementNumber($A6,11469))

——————-

Well, a few minutes has passed, I wanted to do a little more research before I posted this, it turns out that AdvFn’s quarterly numbers are vastly different from Googles, creating some inconsistent results. Some of the quarters information are exactly the same, others are totally different. I don’t know!!! Anybody out there got some ideas?

I have found just manually inputting the numbers from Google yields the most consistent results, but it sure is time consuming!

Brandon, the latest version of the smf_addin Excel plugin should be able to bring in numbers from Google directly into your spreadsheet.

Your best bet is to always do a quick check on the quarterly financials by checking the official 10-Q filings with the SEC. Google tends to include announced numbers from press releases even before the 10-Q is available. I believe the ADVFN financials only includes numbers as reported in the 10-Q or 10-K. Also, Google’s financials (from Reuters) also adjust past financials for restatements. I do not believe the ADVFN numbers are adjusted for restatements. They are only “as reported”. I hope that helps.

Now all I need is a complete list of stock market symbols and I can run my own stock screen in excel!

Hi,

Is it possible to make this spread sheet work for indian stocks?

Please advise.

Thanks

Prashant

Possible — maybe. But you’d have to find a data source for Indian companies that have all of the data elements that are being using. Not a trivial task, as far as I know.