直线折旧分析图表模板.xls

卡片编号(全部)使用年限设备名称数据58101520笔记本电脑 求和项:月折旧额75.95166667求和项:本年折旧额911.42厂房求和项:月折旧额414.58333求和项:本年折旧额4975电脑求和项:月折旧额114.01求和项:本年折旧额1368.13吊车求和项:月折旧额276.389求和项:本年折旧额3316.67轿车求和项:月折旧额1658.333求和项:本年折旧额19900空调求和项:月折旧额59.7求和项:本年折旧额716.4离心泵求和项:月折旧额70.47917求和项:本年折旧额845.75切割机求和项:月折旧额99.5求和项:本年折旧额1194制冷机求和项:月折旧额153.3958求和项:本年折旧额1840.75求和项:月折旧额汇总135.6516667114.01 1981.708 276.389 414.58333求和项:本年折旧额汇总1627.82 1368.1323780.5 3316.674975总计75.95166667911.42414.58333334975114.01041671368.125276.38888893316.6666671658.3333331990059.7716.470.47916667845.7599.51194153.39583331840.752922.34263935068.11167固定资产直线折旧表卡片编号设备名称型号原值残值率净残值启用时间 当前时间使用年限月折旧额本年折旧月数0001厂房转混结构1000000.00550000/1/105/12/3120￥414.58120002吊车QY128500000.00525000/10/405/12/3115￥276.39120003轿车别克GL82000000.005100001/5/1005/12/3110￥1,658.33120004电脑G88050000.0052501/5/1205/12/318￥51.82120005离心泵F4685000.00542.502/4/105/12/3110￥70.48120006切割机HGR-TD3015120000.0056002/10/505/12/3110￥99.50120007空调MRV36000.0051802/8/1005/12/315￥59.70120008 笔记本电脑A4530D-DR45800.00522.903/1/105/12/315￥75.95120009电脑1021C-A60000.0053003/3/1505/12/318￥62.19120010制冷机YKEB185000.00592.504/12/105/12/3110￥153.4012本年折旧额已提折旧月数总折旧额￥4,975.0072￥29,850.00￥3,316.6762￥17,136.11￥19,900.0055￥91,208.33￥621.8855￥2,850.26￥845.7545￥3,171.56￥1,194.0038￥3,781.00￥716.4040￥2,388.00￥911.4236￥2,734.26￥746.2533￥2,052.19￥1,840.7513￥1,994.15折旧费用图表01234567805000100001500020000250003000035000年份费用额原值-预计残值折旧费总折旧剩余价值直线法折旧费用原值32000.00预计残值4000.00使用年限8原值-预计残值折旧费总折旧剩余价值年份032000.00128000.003500.003500.0028500.00228000.003500.007000.0025000.00328000.003500.0010500.0021500.00428000.003500.0014000.0018000.00528000.003500.0017500.0014500.00628000.003500.0021000.0011000.00728000.003500.0024500.007500.00828000.003500.0028000.004000.00