excel如何计算固定资产折旧(双倍余额递减法)呢?今天就教大家如何操作使用方法步骤。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bd315c6034a85edfe02cd5b05b540923dc547584?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
材料/工具
Excel
电脑
方法
1/5
序号、固定资产原值、预计净残值和使用年限输入单元表格内并输入相应的数值。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/241f95cad1c8a786438a619d7509c93d71cf5084?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
2/5
制作下面的表格。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7c1ed21b0ef41bd508f3c36743da81cb38db3d84?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
3/5
DDB函数的语法表达式:DDB(固定资产原值,净残值,预计使用年限,period,为余额递减率), 该参数为2. 然后得出结果。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d043ad4bd11373f03c9f440cb60f4bfbfaed0484?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
4/5
填充到2021年的年折旧单元格,最后使用固定资产的直线法,公式是=(固定资产原值-已累计折旧-预计净残值)/2。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/4b90f603738da977ee8fadb8a251f8198718e385?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述
5/5
往下的数值都是这样得出。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9f2f070828381f3003b9a63abb014c086f06f085?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
请点击输入图片描述