Amortisation
This applies to intangible assets such as patents or copyrights.
For example you acquire a patent for £20,00 with a useful life of 5 years.
AMORDEGRC
AMORDEGRC
Returns the depreciation of an asset in a single period (declining-balance method).
Amortized declining balance
depreciation factors
t < 3, factor = 1
t = 3 or 4, factor = 1.5
t = 5 or 6, factor = 2
t > 6, factor = 2.5
d0 = factor x cost x rate x yearfrac()
d1 = factor x (cost - d0) x rate
d2 = factor x (cost - d0 - d1) x rate
d3 = factor x (cost - d0 - d1 - d2) x rate
AMORLINC
AMORLINC
Returns the depreciation of an asset in a single period (linear method).
d0 = cost x rate x yearfrac()
d1 = cost x rate
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext