年数总和法模板.xls

固定资产年数总和法卡片编号设备名称型号原值残值率净残值启用时间当前时间 使用年限0001厂房转混结构1000000.00550000/1/105/12/31200002吊车QY128500000.00525000/10/405/12/31150003轿车别克GL82000000.005100001/5/1005/12/31100004电脑G88050000.0052501/5/1205/12/3180005离心泵F4685000.00542.502/4/105/12/31100006切割机HGR-TD3015120000.0056002/10/505/12/31100007空调MRV36000.0051802/8/1005/12/3150008笔记本电脑A4530D-DR45800.00522.903/1/105/12/3150009电脑1021C-A60000.0053003/3/1505/12/3180010制冷机YKEB185000.00592.504/12/105/12/3110已提折旧月数已使用年数 本年折旧额7276633.336264145.8355521709.09555552.784541076.413841519.64404477.60364607.61333995.001323012.14