固定资产折旧自动计算表.xls
固定资产折旧自动计算表单位名称:日期:2018年7月1日折旧方法:平均年限法固定资产类别:办公设备、运输工具类单位:元编号名称使用部门入账日期单位数量原币单价购进原值使用年限残值率%预计净残值已使用月份本月折旧累计折旧净值月折旧额实际计算截止日期累计折旧计算值上月累计折旧计算值设备合计#DIV/0!1,803,260.0090,163.00462.00 1,471.18104,422.40 1,698,837.60 14,592.43386,105.00 104,422.90102,685.551装订机A#台12,000.002,000.0035%100.00531900.00100.0052.78#1900.081847.302笔记本电脑A#台27,500.0015,000.0055%750.0053237.50 12587.502412.50237.50 2018/7/1 12587.5012350.0030003冰箱A2015/1/1台11,790.001,790.0035%89.50421700.5089.5047.24 2018/1/11700.641653.4040004洗衣机A2016/1/1台11,750.001,750.0035%87.503046.181385.40364.6046.18 2018/7/11385.401339.2250005彩电A2015/1/1台21,180.002,360.0035%118.00422242.00118.0062.28 2018/1/12242.082179.8060006空调A2013/1/1台22,280.004,560.0055%228.00664332.00228.0072.20 2018/1/14332.004259.807车辆A2013/1/1台1150,000.00 150,000.00105%#66 1187.50 78375.0071625.001187.50 2018/7/1 78375.0077187.508彩电A2012/1/1 台12,000.002,000.0055%100.00781900.00100.0031.67 2017/1/11900.201868.539自卸车A#台15108,253.33 1,623,800.00105%#32#12855.08 2013/6/110#DIV/0!11#DIV/0!12#DIV/0!13#DIV/0!14#DIV/0!15#DIV/0!16#DIV/0!注:灰色部份为带公式不需录入区域-