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

固固定定资资产产折折旧旧自自动动计计算算表表单单位位名名称称：宜宜昌昌地地海海公公司司日日期期:20132013年年6 6月月1 1日日折折旧旧方方法法：平平均均年年限限法法固固定定资资产产类类别别：办办公公设设备备、运运输输工工具具类类编编号号名名称称使使用用部部门门入入账账日日期期单单位位数数量量原原币币单单价价购购进进原原值值使使用用年年限限残残值值率率%预预计计净净残残值值已已使使用用月月份份本本月月折折旧旧累累计计折折旧旧设设备备合合计计#DIV/0!1,803,260.0090,163.0014,539.65263,828.791装订机A2010/2/28台12,000.002,000.0035%100.00401900.002笔记本电脑A2010/2/28台27,500.0015,000.0055%750.0040237.509500.0030003冰箱A2012/1/1台11,790.001,790.0035%89.501747.24803.0840004洗衣机A2013/1/1台11,750.001,750.0035%87.50546.18230.9050005彩电A2013/1/1台21,180.002,360.0035%118.00562.28311.4060006空调A2013/1/1台22,280.004,560.0055%228.00572.20361.007车辆A2013/1/1台1150,000.00150,000.00105%7500.0051187.505937.508彩电A2012/1/1台12,000.002,000.0055%100.001731.67538.399自卸车A2011/11/1台#108,253.331,623,800.00105%81190.001912855.08244246.52#DIV/0!#DIV/0!注：绿色部份为带公式不需录入区域单单位位:元元净净值值月月折折旧旧额额实实际际计计算算截截止止日日期期累累计计折折旧旧计计算算值值上上月月累累计计折折旧旧计计算算值值1,539,431.2114,592.43263,828.87249,236.44100.0052.782013/2/281900.081847.305500.00237.502013/6/19500.009262.50986.9247.242013/6/1803.08755.841519.1046.182013/6/1230.90184.722048.6062.282013/6/1311.40249.124199.0072.202013/6/1361.00288.80144062.501187.502013/6/15937.504750.001461.6131.672013/6/1538.39506.721379553.4812855.082013/6/1244246.52231391.44固固定定资资产产类类别别：办办公公设设备备、运运输输工工具具类类