Senin, 24 Oktober 2016

[smf_addin] Digest Number 3824

2 Messages

Digest #3824
1a
Google Net PPE by Chovek2
1b
Re: Google Net PPE by "Randy Harmelink" rharmelink

Messages

Sun Oct 23, 2016 11:19 pm (PDT) . Posted by:

Chovek2

Hi, I am looking for a way to get the net property, plant and equipment number from Google. There is a gross PPE number in the definitions (3668 on the annual), but not a net number. Further, on the Google statements there is an accumulated depreciation line, but not a corresponding definition.


Any suggestions on how I can either get the net PPE number or incorporate the accumulated depreciation to have my spreadsheet calculate it?


All suggestions appreciated,




Thanks,


Keith

Mon Oct 24, 2016 1:01 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

This would get you the first year of depreciation:

=RCHGetTableCell("https://www.google.com/finance?fstype=ii&q=MMM",1,"BALANNUALDIV","Accumulated
Depreciation, Total")

On Sun, Oct 23, 2016 at 11:19 PM, keith@
​...wrote:

> Hi, I am looking for a way to get the net property, plant and equipment
> number from Google. There is a gross PPE number in the definitions (3668
> on the annual), but not a net number. Further, on the Google statements
> there is an accumulated depreciation line, but not a corresponding
> definition.
>
> Any suggestions on how I can either get the net PPE number or incorporate
> the accumulated depreciation to have my spreadsheet calculate it?
>
> All suggestions appreciated,
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar