1 New Message
Digest #2837
Message
Sun Nov 3, 2013 12:37 am (PDT) . Posted by:
kompiled
The GuruFocus 10 Year Model is missing "Accounts Receivable" from the balance sheet's current assets section.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
There's probably still a bunch of other errors (EBITDA was pulling from the "per-share" which I fixed, so please help check and flag any errors. Thanks
---In smf_addin@yahoogroups.com, <dan-carroll@...> wrote:
Made a bunch of fixes for spaces etc, should work better
As for ROIC, I put the calculation back in but on the variations with ADVfn, I don't know how to tell you. It's one of those metrics where people play around a bit at the fringes. Do you use average capital from previous year and this? Include leases? Perhaps there are liabilities that GuruFocus doesn't capture?
I have used EBIT/(Equity + Debt), but feel free to suggest a modification. My personal experience has been as long as you're consistent in how you calculate it, it will give useful information on a relative basis. Sorry I can't help more.
---In smf_addin@yahoogroups.com, <lottidottigigliotti@...> wrote:
Thanks for the updated GuruFocus 10 Year Model!
I noticed that some of the data didn't populate because of extra spaces added to the names of various line items.
For example: "Cash And Cash Equivalents" now has two spaces before the name. After I added the two spaces before the name in the excel sheet, it worked.
Same thing can be done to fix other line item names.
I do have a question about ROCI (Return on Captial Invested). On your old GuruFocus spreadsheet, this ROCI item was calculated. I tried to calculate it the same way with the new spreadsheet, but the figure is coming up incorrect.
For example, the ROCI for Exxon (XOM) for the year 2003 calculates to 63.90%.
But in reality, it should be closer to 22.10% (according to the ADVFN website).
I calculated the ROCI from your GuruFocus spreadsheet by using the following formula:
"Operating Income" divided by "Invested Capital"
It appears that my "Invested Capital" amount is coming up incorrect.
My "Invested Capital" calculates to 88,834 for the year 2003.
But from the ADVFN website, it should be 94,671.
Any help in solving this would be greatly appreciated since ROCI is a great analysis item.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
I found out about the issues with the model. GuruFocus added a lot of new 10 year data - especially in the Balance Sheet and Cash Flow sections, and changed a lot of the names of the various line items. As a result the old model stopped working.
I've uploaded a new version. It's a quick-n-dirty piece of work, and seems to work fine, but I have not had the time to check it thoroughly, so any feedback would be appreciated and I'll fix it as best I can.
---In smf_addin@yahoogrou
There's probably still a bunch of other errors (EBITDA was pulling from the "per-share&quo
---In smf_addin@yahoogrou
Made a bunch of fixes for spaces etc, should work better
As for ROIC, I put the calculation back in but on the variations with ADVfn, I don't know how to tell you. It's one of those metrics where people play around a bit at the fringes. Do you use average capital from previous year and this? Include leases? Perhaps there are liabilities that GuruFocus doesn't capture?
I have used EBIT/(Equity + Debt), but feel free to suggest a modification. My personal experience has been as long as you're consistent in how you calculate it, it will give useful information on a relative basis. Sorry I can't help more.
---In smf_addin@yahoogrou
Thanks for the updated GuruFocus 10 Year Model!
I noticed that some of the data didn't populate because of extra spaces added to the names of various line items.
For example: "Cash And Cash Equivalents" now has two spaces before the name. After I added the two spaces before the name in the excel sheet, it worked.
Same thing can be done to fix other line item names.
I do have a question about ROCI (Return on Captial Invested). On your old GuruFocus spreadsheet, this ROCI item was calculated. I tried to calculate it the same way with the new spreadsheet, but the figure is coming up incorrect.
For example, the ROCI for Exxon (XOM) for the year 2003 calculates to 63.90%.
But in reality, it should be closer to 22.10% (according to the ADVFN website).
I calculated the ROCI from your GuruFocus spreadsheet by using the following formula:
"Operating Income" divided by "Invested Capital"
It appears that my "Invested Capital" amount is coming up incorrect.
My "Invested Capital" calculates to 88,834 for the year 2003.
But from the ADVFN website, it should be 94,671.
Any help in solving this would be greatly appreciated since ROCI is a great analysis item.
---In smf_addin@yahoogrou
I found out about the issues with the model. GuruFocus added a lot of new 10 year data - especially in the Balance Sheet and Cash Flow sections, and changed a lot of the names of the various line items. As a result the old model stopped working.
I've uploaded a new version. It's a quick-n-dirty piece of work, and seems to work fine, but I have not had the time to check it thoroughly, so any feedback would be appreciated and I'll fix it as best I can.
Tidak ada komentar:
Posting Komentar