Function Type: Financial
Returns the depreciation for each accounting period by using a depreciation coefficient
=AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])
cost – The cost of the asset.
date_purchased – The date that the asset was purchased.
first_period – The date of the end of the first period.
salvage – The salvage value after asset has been fully depreciated.
period – The period in which to calculate the linear depreciation.
rate – The rate of depreciation.
basis – it is the type of year basis to use when calculating the depreciation. If this parameter is omitted, it assumes that the basis is set to 0.
|0||360 days (NASD)|
|3||365 days (in a year)|
|4||360 days (in a year)|
If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig.