|
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
|