固定资产折旧计算表(公式).xls

年份：年份：2010注意本表中带颜色的部分已设好公式，请勿改动。请使用前，先复制一个文件备份，再使用，以免不小心改动其中的公式。注意本表中带颜色的部分已设好公式，请勿改动。请使用前，先复制一个文件备份，再使用，以免不小心改动其中的公式。 1234567 一,房产类: 1 铺面 2006-12-1486,077.00 3000.00%1,620.26 98,887.92 387,189.08 1,620.26 1,620.26 1,620.26 - - - - 2 门市部房屋2002/3/1 12,245.00 3000.00%40.82 5,932.00 6,313.00 40.82 40.82 40.82 - - - - 3 主厂房 2009/7/146,000.00 3000.00%153.33 780.00 45,220.00 153.33 153.33 153.33 - - - - 4 主厂房 1988/9/11,911,385.90 3000.00%6,371.29 1,660,468.63 250,917.27 6,371.29 6,371.29 6,371.29 - - - - 小计2,455,707.90 8,185.70 1,766,068.55 689,639.35 8,185.70 8,185.70 8,185.70 - - - - 二，汽车类： 1 130小货车2002/3/151,342.90 600.00% 855.72 33,368.00 17,974.90 - - - - - - - 2 长安微型车2005/12/1 42,206.00 600.00%703.43 13,439.00 28,767.00 703.43 703.43 703.43 - - - - 3 别克林荫大道2009/7/1 378,475.00 600.00%6,307.92 16,000.00 362,475.00 6,307.92 6,307.92 6,307.92 - - - - 4 长安微型车(五菱小客） 2009/3/154,338.00 600.00%905.63 3,600.00 50,738.00 905.63 905.63 905.63 - - - - 小计526,361.90 8,772.70 66,407.00 459,954.90 7,916.98 7,916.98 7,916.98 - - - - 三，电子电器类0 1 激光照排机W-101999/4/1150,000.00 480.00%3,125.00 113,140.00 36,860.00 - - - - - - - 2 微机W-112004/6/14,788.00 480.00% 99.75 2,092.00 2,696.00 - - - - - - - 3 微机W-122006/7/150,000.00 480.00% 1,041.67 12,780.00 37,220.00 1,041.67 1,041.67 1,041.67 - - - - 4 激光照排机W-132006/10/1323,065.00 480.00%6,730.52 94,584.00 228,481.00 6,730.52 6,730.52 6,730.52 - - - - 5 扫描仪W-142007/8/1180,000.00 480.00%3,750.00 35,208.00 144,792.00 3,750.00 3,750.00 3,750.00 - - - - 6 华硕电脑W-152007/8/160,000.00 480.00%1,250.00 11,760.00 48,240.00 1,250.00 1,250.00 1,250.00 - - - - 7 华硕电脑W-162007/8/110,570.00 480.00%220.21 2,064.00 8,506.00 220.21 220.21 220.21 - - - - 8 电脑W-172008/5/111,190.00 480.00% 233.13 1,772.60 9,417.40 233.13 233.13 233.13 - - - - 10 电脑W-182008/5/128,800.00 480.00% 600.00 4,089.60 24,710.40 600.00 600.00 600.00 - - - - 11 电脑w-192008/8/112,560.00 480.00% 261.67 1,446.00 11,114.00 261.67 261.67 261.67 - - - - 12 音响设备一套1996/11/1 26,000.00 480.00%541.67 21,760.00 4,240.00 - - - - - - - 13 音响设备一套2009/1/1 17,000.00 480.00%354.17 1,246.63 15,753.37 354.17 354.17 354.17 - - - - 14 打印机w-212009/1/15,384.62 480.00%112.18 450.00 4,934.62 112.18 112.18 112.18 - - - - 15 电脑w-202008/12/110,000.00 480.00% 208.33 830.00 9,170.00 208.33 208.33 208.33 - - - - 16 打印机w-222009/3/15,512.82 480.00%114.85 411.30 5,101.52 114.85 114.85 114.85 - - - - 17 电脑w-232009/9/15,897.44 480.00% 122.86 147.00 5,750.44 122.86 122.86 122.86 - - - - 2009年12月31日 净值 各月折旧额 固定资产明细表固定资产明细表 序号名称购入时间售出时间 原值 折旧年限 （单位： 月） 残值 月折旧 2009年12月31日 累计折旧 小计900,767.88 18,766.01 303,781.13 596,986.75 14,999.59 14,999.59 14,999.59 - - - - 四，机器设备类 1 对开双色胶印机J-61993/6/1583,304.24 1320.00%4,418.97 583,304.24 - - - - - - - 2 四开双色胶印机J-71999/12/1500,000.00 1320.00%3,787.88 259,070.00 240,930.00 3,787.88 3,787.88 3,787.88 - - - - 3 8K胶印机J-82000/5/147,000.00 1320.00%356.06 28,296.00 18,704.00 356.06 356.06 356.06 - - - - 4 对开单色双面胶印机J-9 2001/5/1460,000.00 1320.00%3,484.85 254,064.00 205,936.00 3,484.85 3,484.85 3,484.85 - - - - 5 威海8K胶印机J-102002/5/164,000.00 1320.00%484.85 32,228.00 31,772.00 484.85 484.85 484.85 - - - - 6 8K胶印机J-112003/4/148,000.00 1320.00%363.64 21,036.00 26,964.00 363.64 363.64 363.64 - - - - 7 对开四色胶印机J-122004/1/11,998,000.00 1320.00%15,136.36 525,176.68 1,472,823.32 15,136.36 15,136.36 15,136.36 - - - - 8 无轴报纸印刷机J-132005/9/13,400,000.00 1320.00%25,757.58 716,508.56 2,683,491.44 25,757.58 25,757.58 25,757.58 - - - - 9 铁丝订书机2-201992/5/15,640.39 1320.00%42.73 5,281.14 359.25 - - - - - - - 10 铁丝订书机2-211993/2/16,220.51 1320.00%47.13 6,050.51 170.00 - - - - - - - 11 微控切纸机2-221992/10/1140,863.43 1320.00%1,067.15 125,789.58 15,073.85 - - - - - - - 12 全张切纸机2-231993/4/131,075.87 1320.00%235.42 28,576.87 2,499.00 - - - - - - - 13 JB135A胶订包背机2-25 1999/6/138,480.00 1320.00%291.52 25,960.00 12,520.00 291.52 291.52 291.52 - - - - 14 三面切纸机2-262000/5/173,000.00 1320.00%553.03 40,732.00 32,268.00 553.03 553.03 553.03 - - - - 15 折页机2-272001/5/1168,000.00 1320.00%1,272.73 88,776.00 79,224.00 1,272.73 1,272.73 1,272.73 - - - - 16 直线胶订包本机2-282002/5/147,000.00 1320.00%356.06 35,281.00 11,719.00 356.06 356.06 356.06 - - - - 17 锁线机2-292004/10/175,500.00 1320.00%571.97 22,833.00 52,667.00 571.97 571.97 571.97 - - - - 18 对开切纸机2-302007/1/150,450.00 1320.00%382.20 11,412.00 39,038.00 382.20 382.20 382.20 - - - - 19 半自动骑马订书机2-312007/4/135,000.00 1320.00%265.15 7,580.00 27,420.00 265.15 265.15 265.15 - - - - 20 椭圆包本机2-322007/5/1180,000.00 1320.00%1,363.64 31,752.00 148,248.00 1,363.64 1,363.64 1,363.64 - - - - 21 制模切割组合机3-261995/5/17,000.00 1320.00%53.03 6,155.00 845.00 - - - - - - - 22 对开晒版机3-272000/7/112,000.00 1320.00%90.91 7,134.00 4,866.00 90.91 90.91 90.91 - - - - 23 PS版自动显影机3-282004/5/122,000.00 1320.00%166.67 8,662.00 13,338.00 166.67 166.67 166.67 - - - - 24 海门立式停回转4-181993/4/165,135.81 1320.00%493.45 57,721.31 7,414.50 - - - - - - - 25 对开平压压痕机4-241994/3/128,182.39 1320.00%213.50 25,986.39 2,196.00 - - - - - - - 26 捆扎机2-332009/8/13,162.39 1320.00%23.96 88.00 3,074.39 23.96 23.96 23.96 - - - - 小计8,089,015.03 61,280.44 2,955,454.28 5,133,560.75 54,709.06 54,709.06 54,709.06 - - - - 五，其他 1 简易货梯T-11994/6/177,276.46 600.00%1,287.94 71,890.46 5,386.00 - - - - - - - 2 纸架 2001/3/13,037.00 600.00%50.62 1,384.00 1,653.00 - - - - - - - 3 教桌 2000/6/18,000.00 600.00%133.33 5,076.00 2,924.00 - - - - - - - 4 办公桌椅2003/12/1 19,950.00 600.00%332.50 8,376.00 11,574.00 - - - - - - - 5 乒乓球桌2008/12/1 2,859.00 600.00%47.65 216.00 2,643.00 47.65 47.65 47.65 - - - - 6 会议桌 2009/5/16,000.00 600.00%100.00 280.00 5,720.00 100.00 100.00 100.00 - - - - 小计117,122.46 0.00%1,952.04 87,222.46 29,900.00 147.65 147.65 147.65 - - - - 六，已提完折旧 1 美国大屏幕微机W-867,437.03 67,437.03 2 微机系统一套W-974,600.00 74,600.00 3 厂房二幢 160,714.02 160,714.02 4 大门.厂房一幢37,139.71 37,139.71 5 全张切纸机 10,401.05 10,401.05 6 电子交流稳压器 945.66 945.66 7 书芯压平机2-2427,480.00 27,480.00 8 铁丝订书机2-16 2-178,785.08 8,785.08 9 液压切信封多用机 3,868.05 3,868.05 10 铁丝订书机2-12 2-138,094.06 8,094.06 11 方箱印刷机 19,734.23 19,734.23 12 对开单色胶印机J-3107,279.41 107,279.41 13 四开烘版机 2,539.45 2,539.45 14 四开晒版 机3,906.26 3,906.26 15 烫金机 3,888.00 3,888.00 16 微机轻印系统 211,971.68 211,971.68 小计748,783.69 0.00%748,783.69 合计12,837,758.86 00.00%98,956.89 5,927,717.11 6,910,041.75 85,958.98 85,958.98 85,958.98 - - - - 5,927,717.11 6,894,348.67 请输入计算折旧的截止月份 290,098.62 15,693.08- 起始月：起始月： 1 1 截止月：截止月： 3 3 89101112 - - - - - 4,860.78 103,748.70 382,328.30 2007-1-12031-12-28 蒙自景明路鑫苑小区C3 - - - - - 122.46 6,054.46 6,190.54 2002-4-12027-3-28 厂大门 - - - - - 459.99 1,239.99 44,760.01 2009-8-12034-7-28 绿春巷17号 - - - - - 19,113.87 1,679,582.50 231,803.40 1988-10-12013-9-28 上河路爱国村24号 - - - - - 24,557.10 1,790,625.65 665,082.25 - - - - - - 33,368.00 17,974.90 2002-4-12007-3-28 厂部 - - - - - 2,110.29 15,549.29 26,656.71 2006-1-12010-12-28 厂部 - - - - - 18,923.76 34,923.76 343,551.24 2009-8-12014-7-28 厂部 - - - - - 2,716.89 6,316.89 48,021.11 2009-4-12014-3-28 厂部 - - - - - 23,750.94 90,157.94 436,203.96 - - - - - - 113,140.00 36,860.00 1999-5-12003-4-28 微机车间 - - - - - - 2,092.00 2,696.00 2004-7-12008-6-28 微机车间 - - - - - 3,125.01 15,905.01 34,094.99 2006-8-12010-7-28 微机车间 - - - - - 20,191.56 114,775.56 208,289.44 2006-11-12010-10-28 微机车间 - - - - - 11,250.00 46,458.00 133,542.00 2007-9-12011-8-28 微机车间 - - - - - 3,750.00 15,510.00 44,490.00 2007-9-12011-8-28 微机车间 - - - - - 660.63 2,724.63 7,845.37 2007-9-12011-8-28 微机车间 - - - - - 699.39 2,471.99 8,718.01 2008-6-12012-5-28 微机车间 - - - - - 1,800.00 5,889.60 22,910.40 2008-6-12012-5-28 微机车间 - - - - - 785.01 2,231.01 10,328.99 2008-9-12012-8-28 微机车间 - - - - - - 21,760.00 4,240.00 1996-12-12000-11-28 微机车间 - - - - - 1,062.51 2,309.14 14,690.86 2009-2-12013-1-28 微机车间 - - - - - 336.54 786.54 4,598.08 2009-2-12013-1-28 微机车间 - - - - - 624.99 1,454.99 8,545.01 2009-1-12012-12-28 微机车间 - - - - - 344.55 755.85 4,756.97 2009-4-12013-3-28 微机车间 - - - - - 368.58 515.58 5,381.86 2009-10-12013-9-28 微机车间 存放地点 累计折旧总额提完折旧时间 开始计提折旧 时间 全年计提折旧 合计 净值 - - - - - 44,998.77 348,779.90 551,987.98 - - - - - - 583,304.24 - 1993-7-12004-6-28 机印车间 - - - - - 11,363.64 270,433.64 229,566.36 2000-1-12010-12-28 机印车间 - - - - - 1,068.18 29,364.18 17,635.82 2000-6-12011-5-28 机印车间 - - - - - 10,454.55 264,518.55 195,481.45 2001-6-12012-5-28 机印车间 - - - - - 1,454.55 33,682.55 30,317.45 2002-6-12013-5-28 机印车间 - - - - - 1,090.92 22,126.92 25,873.08 2003-5-12014-4-28 机印车间 - - - - - 45,409.08 570,58