余额折旧法分析图表模板.xls

固定资产单倍余额递减法卡片编号设备名称型号原值残值率净残值启用时间当前时间使用年限0001厂房转混结构1000000.00550000/1/105/12/31200002吊车QY128500000.00525000/10/405/12/31150003轿车别克GL82000000.005100001/5/1005/12/31100004电脑G88050000.0052501/5/1205/12/3180005离心泵F4685000.00542.502/4/105/12/31100006切割机HGR-TD3015120000.0056002/10/505/12/31100007空调MRV36000.0051802/8/1005/12/3150008笔记本电脑A4530D-DR45800.00522.903/1/105/12/3150009电脑1021C-A60000.0053003/3/1505/12/3180010制冷机YKEB185000.00592.504/12/105/12/3110已提折旧月数已使用年数本年折旧额7274863.916263438.8355512769.51555238.61454879.893841593.81404221.45364144.55333954.521322637.81卡片编号(全部)求和项:本年折旧额使用年限设备名称581015笔记本电脑395.712厂房电脑1239.257813吊车3259.636763轿车16384空调311.04离心泵870.4切割机1228.8制冷机2960总计706.752 1239.25781321443.2 3259.63676320 总计395.7125314.415314.411239.2578133259.63676316384311.04870.41228.829605314.41 31963.25658固定资产双倍余额递减法卡片编号设备名称型号原值残值率净残值启用时间当前时间使用年限0001厂房转混结构1000000.00550000/1/105/12/31200002吊车QY128500000.00525000/10/405/12/31150003轿车别克GL82000000.005100001/5/1005/12/31100004电脑G88050000.0052501/5/1205/12/3180005离心泵F4685000.00542.502/4/105/12/31100006切割机HGR-TD3015120000.0056002/10/505/12/31100007空调MRV36000.0051802/8/1005/12/3150008笔记本电脑A4530D-DR45800.00522.903/1/105/12/3150009电脑1021C-A60000.0053003/3/1505/12/3180010制冷机YKEB185000.00592.504/12/105/12/3110已提折旧月数已使用年数本年折旧额7275314.416263259.6455516384.00555395.51454870.403841228.80404311.04364395.71333843.751322960.00双倍余额法折旧费用图0100020003000400050006000700080009000年份折旧费123456789年份012345678折旧费8000.006000.004500.003375.002531.251898.441423.83271.48年份折旧费双倍余额递减法折旧费用原值32000.00预计残值4000.00使用年限8原值-预计残值折旧费总折旧剩余价值年份032000.00128000.008000.008000.0024000.00228000.006000.0014000.0018000.00328000.004500.0018500.0013500.00428000.003375.0021875.0010125.00528000.002531.2524406.257593.75628000.001898.4426304.695695.31728000.001423.8327728.524271.48828000.00271.4828000.004000.00