View Single Post
  #278 (permalink)  
Old 11-07-2007, 03:20 PM
AustinA6 AustinA6 is offline
Junior Member
 
Join Date: Nov 2007
Posts: 1
Re: Margin of Safety Calculator for MSN Money

Justin,

Thanks for a great resource. I do have a couple of questions:

1) the Free Cash Flow raw data from MorningStar does not look correct. In looking at the query and the actual webpage you are pulling from, you are not getting the actual FCF at the bottom of the Morningstar table. Looking at the raw data on the xls tab, you are only getting "cash from investing" which is a negative number.

2) On the "-Main-" tab, in the growth % table, you lable the far right column as "TTM" but looking at the calculations, they are actually the full Fiscal 1Yr numbers...which is the right answer, just not labled correctly. To get TTM, it seems to me that you would have to do a complex query to get the last x fiscal quarters of data from the previous FY and the current FY and then do the growth calculation over y periods (FQ, or Months).

Again, It is much better than my initial effort in Excel and I appreciate you putting it together.

Thanks

AustinA6
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote