Function Type: Financial
Description:
Returns the depreciation for each accounting period by using a depreciation coefficient
Function Structure:
=AMORDEGRC(cost, date_purchased, first_period, salvage, period, rate, [basis])
Argument Breakdown:
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.
| Value | Explanation |
|---|---|
| 0 | 360 days (NASD) |
| 1 | Actual |
| 3 | 365 days (in a year) |
| 4 | 360 days (in a year) |
Example:
Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.
We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.
or you can help me through https://www.buymeacoffee.com/cashheaven š
One thought on “AMORDEGRC”