Calculate Depreciation for Financial Year Ended in June

[Anonymous]

Hi PBI Gurus,

I wonder if anyone can help me on this.

I am trying to calculate a YTD (based on financial year ended 30/6) depreciation for assets however I am struggling to find solutions.

Please see the screenshot of the Excel file below. The actual data is a lot bigger than this. Just wonder if I want to get a YTD depreciation for all assets up until 30/6/2019. Ultimately I would like to see a column to show me the YTD depreciation for each asset. For example for below asset, the depreciation of it for Financial Year 19 up until 30/6/19 would be $120,000/10 years/12 months*8 months =$8,000. 

Could someone please have a look on this?

Cheers

Jimmy