固定资产折旧自动计算表

1、固定资产折旧自动计算表,单位名称：,日期:,2018年7月1日,折旧方法：,平均年限法,固定资产类别：办公设备、运输工具类,单位:元,编号,名称,使用部门,入账日期,单位,数量,原币单价,购进原值,使用年限,残值率%,预计净残值,已使用月份,本月折旧,累计折旧,净值,月折旧额,实际计算截止日期,累计折旧计算值,上月累计折旧计算值, 设备合计 ,#DIV/0!, 1,803,260.00 , 90,163.00 , 462.00 , 1,471.18 , 104,422.40 , 1,698,837.60 , 14,592.43 , 386,105.00 , 104,422.90 , 102,6

2、85.55 , - 1,装订机,A,2014/2/28,台,1, 2,000.00 , 2,000.00 ,3,5%,100.00,53,1900.00,100.00,52.78,2017/2/28,1900.08,1847.30,2,笔记本电脑,A,2014/2/28,台,2, 7,500.00 , 15,000.00 ,5,5%,750.00,53,237.50,12587.50,2412.50,237.50,2018/7/1,12587.50,12350.00,3,0003冰箱,A,2015/1/1,台,1, 1,790.00 , 1,790.00 ,3,5%,89.50,42,1700

3、.50,89.50,47.24,2018/1/1,1700.64,1653.40,4,0004洗衣机,A,2016/1/1,台,1, 1,750.00 , 1,750.00 ,3,5%,87.50,30,46.18,1385.40,364.60,46.18,2018/7/1,1385.40,1339.22,5,0005彩电,A,2015/1/1,台,2, 1,180.00 , 2,360.00 ,3,5%,118.00,42,2242.00,118.00,62.28,2018/1/1,2242.08,2179.80,6,0006空调,A,2013/1/1,台,2, 2,280.00 , 4,5

4、60.00 ,5,5%,228.00,66,4332.00,228.00,72.20,2018/1/1,4332.00,4259.80,7,车辆,A,2013/1/1,台,1, 150,000.00 , 150,000.00 ,10,5%,7500.00,66,1187.50,78375.00,71625.00,1187.50,2018/7/1,78375.00,77187.50,8,彩电,A,2012/1/1,台,1, 2,000.00 , 2,000.00 ,5,5%,100.00,78,1900.00,100.00,31.67,2017/1/1,1900.20,1868.53,9,自卸车,A,2015/11/1,台,15, 108,253.33 , 1,623,800.00 ,10,5%,81190.00,32,1623800.00,12855.08,2013/6/1,10,#DIV/0!,11,#DIV/0!,12,