Hi,
May anyone be able to help with the below table formula? Thanks in advance.
May anyone be able to help with the below table formula? Thanks in advance.
1/1/2020 | 31/12/2020 | 31/8/2021 | ||||
Date purchase | Useful life (Yr) | Mth | Cost Amount | Depreciation b/f | Depreciation | Depreciation |
2/7/2020 | 5 | 60 | 15,000 | ??? | ??? | ??? |
4/5/2012 | 5 | 60 | 33,000 |