固定资产折旧计算表单位名称:XXX日期:reserved-40237x1F折旧方法:平均年限法固定资产类别:办公设备、运输工具类单位:元编号名称使用部门入账日期单位数量原币单价购进原值使用年限残值率%预计净残值已使用月份本月折旧累计折旧净值月折旧额实际计算截止日期累计折旧计算值上月累计折旧计算值设备合计167,591.00176,101.008,805.051,500.2464,589.20111,511.801,700.5464,589.5262,888.9810001HP打印机A2006/2/28台11,690.001,690.0035%84.50480.01605.5084.5044.602009/2/281605.601561.0020002联想电脑A2006/2/28台25,050.0010,100.0055%505.0048159.927676.162423.84159.922010/2/287676.167516.2430003冰箱A2006/2/28台11,790.001,790.0035%89.50480.01700.5089.5047.242009/2/281700.641653.4040004洗衣机A2006/2/28台11,750.001,750.0035%87.50480.01662.4887.5246.182009/2/281662.481616.3050005彩电A2006/2/28台21,180.002,360.0035%118.00480.02242.00118.0062.282009/2/282242.082179.8060006空调A2006/7/31台22,280.004,560.0055%228.004372.203104.601455.4072.202010/2/283104.603032.4070007汽车A2007/1/31台1150,000.00150,000.00105%7500.00371187.5043937.50106062.501187.502010/2/2843937.5042750.0080008空调A2007/5/17台11,990.001,990.0055%99.503331.511039.83950.1731.512010/2/281039.831008.3290009打印机B2007/5/17台11,861.001,861.0035%93.053349.111620.63240.3749.112010/2/281620.631571.520.00.00.00.00.00.02010/2/280.00.0注:绿色部份为带公式不需录入区域