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

固固定定资资产产折折旧旧计计算算表表单单位位名名称称:XXX日日期期:20102010年年2 2月月2828日日折旧方法：平均年限法固定资产类别：办公设备、运输工具类编编号号名名称称使使用用部部门门入入账账日日期期单单位位数数量量原原币币单单价价购购进进原原值值使使用用年年限限残残值值率率%预预计计净净残残值值已已使使用用月月份份本本月月折折旧旧累累计计折折旧旧设设备备合合计计167,591.00 176,101.008,805.051,500.2464,589.2010001HP打印机A2006/2/28台11,690.001,690.0035%84.50481605.5020002联想电脑A2006/2/28台25,050.0010,100.0055%505.0048159.927676.1630003冰箱A2006/2/28台11,790.001,790.0035%89.50481700.5040004洗衣机A2006/2/28台11,750.001,750.0035%87.50481662.4850005彩电A2006/2/28台21,180.002,360.0035%118.00482242.0060006空调A2006/7/31台22,280.004,560.0055%228.004372.203104.6070007汽车A2007/1/31台1150,000.00 150,000.00105%7500.00371187.5043937.5080008空调A2007/5/17台11,990.001,990.0055%99.503331.511039.8390009打印机B2007/5/17台11,861.001,861.0035%93.053349.111620.63注：绿色部份为带公式不需录入区域单位:元净净值值月月折折旧旧额额实实际际计计算算截截止止日日期期累累计计折折旧旧计计算算值值上上月月累累计计折折旧旧计计算算值值111,511.801,700.5464,589.5262,888.9884.5044.602009/2/281605.601561.002423.84159.922010/2/287676.167516.2489.5047.242009/2/281700.641653.4087.5246.182009/2/281662.481616.30118.0062.282009/2/282242.082179.801455.4072.202010/2/283104.603032.40106062.501187.502010/2/2843937.5042750.00950.1731.512010/2/281039.831008.32240.3749.112010/2/281620.631571.521900/1/0固定资产类别：办公设备、运输工具类