2 Messages

Digest #3824

Google Net PPE by Chovek2

Re: Google Net PPE by "Randy Harmelink" rharmelink

Messages

1a

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

Reply to sender . Reply to group . Reply via Web Post . All Messages (2) . Top ^

1b

Re: Google Net PPE

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