固定资产折旧自动计算表模板

单位名称：宜昌地海公司日期:编号2016年使7月1日用名称部入账日期折旧方法：平均年限法已使单数位量原币单价#DIV/0!购进原值 582,872.81使用年限残值率%预计净残值 29,143.用月份 设备合计12345678装订机笔记本电脑0003冰箱0004洗衣机0005彩电0006空调车辆彩电AAAAAAAA2010/2/28台2010/2/28台2012/1/1台2013/1/1台2013/1/1台2013/1/1台2013/1/1台2012/1/1台1 2,000.00 2,000.002 7,500.00 15,000.001 1,790.00 1,790.001 1,750.00 1,750.002 1,180.00 2,360.002 2,280.00 4,560.001 150,000.00 150,000.001 2,000.00 2,000.001 119,683.76 119,683.761 246,122.22 246,122.221 37,606.83 37,606.83#DIV/0!#DIV/0!3533351055555%5%5%5%5%5%5%5%5%5%5%100.00750.00.5087.50118.00228.007500.00100.005984.1912306.111880.347777424242425112016/2/29台910自卸车半挂车AAA2016/6/12016/6/1台台注：绿色部份为带公式不需录入区域

算表

固定资产类别：办公设备、运输工具类

本月折旧 7,678.74累计折旧 90,339.1900.0014250.001700.501662.482242.0072.201187.5031.6714.9936.94595.443032.4049875.001710.1474.9536.94595.44净值 492,532.92100.00750.00.5087.52118.001527.60100125.002.82110208.81242225.2837011.39单位:元实际计算截累计折旧月折旧额止日期计算值 90,340.192013/2/282015/2/282015/1/12016/1/12016/1/12016/7/12016/7/12016/7/12016/7/12016/7/12016/7/21900.0814250.001700.1662.482242.083032.4049875.001710.1474.9536.94595.44-0.00上月累计折旧计算值 82,215.471847.3014012.501653.401616.302179.802960.2048687.501678.517579.96 8,124.7252.78237.5047.2446.1862.2872.201187.5031.6714.9936.94595.44