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

固固定定资资产产明明细细表表年年份份：2010注注意意本本表表中中带带颜颜色色的的部部分分已已设设好好公公式式，请请勿勿改改动动。请请使使用用前前，先先复复制制一一个个文文件件备备份份，再再使使用用，以以免免不不小小心心改改动动其其中中的的公公式式。序号名称购入时间售出时间原值折旧年限（单位：月）残值月折旧2009年12月31日累计折旧2009年12月31日净值各月折旧额1234567一,房产类:1 铺面2006-12-1486,077.003000.00%1,620.2698,887.92387,189.081,620.261,620.261,620.26-2 门市部房屋2002/3/112,245.003000.00%40.825,932.006,313.0040.8240.8240.82-3 主厂房2009/7/146,000.003000.00%153.33780.0045,220.00153.33153.33153.33-4 主厂房1988/9/11,911,385.903000.00%6,371.291,660,468.63250,917.276,371.296,371.296,371.29-小计2,455,707.908,185.701,766,068.55689,639.358,185.708,185.708,185.70-二，汽车类：1 130小货车2002/3/151,342.90600.00%855.7233,368.0017,974.90-2 长安微型车2005/12/142,206.00600.00%703.4313,439.0028,767.00703.43703.43703.43-3 别克林荫大道2009/7/1378,475.00600.00%6,307.9216,000.00362,475.006,307.926,307.926,307.92-4 长安微型车(五菱小客）2009/3/154,338.00600.00%905.633,600.0050,738.00905.63905.63905.63-小计526,361.908,772.7066,407.00459,954.907,916.987,916.987,916.98-三，电子电器类01 激光照排机W-101999/4/1150,000.00480.00%3,125.00113,140.0036,860.00-2 微机W-112004/6/14,788.00480.00%99.752,092.002,696.00-3 微机W-122006/7/150,000.00480.00%1,041.6712,780.0037,220.001,041.671,041.671,041.67-4 激光照排机W-132006/10/1323,065.00480.00%6,730.5294,584.00228,481.006,730.526,730.526,730.52-5 扫描仪W-142007/8/1180,000.00480.00%3,750.0035,208.00144,792.003,750.003,750.003,750.00-6 华硕电脑W-152007/8/160,000.00480.00%1,250.0011,760.0048,240.001,250.001,250.001,250.00-7 华硕电脑W-162007/8/110,570.00480.00%220.212,064.008,506.00220.21220.21220.21-8 电脑W-172008/5/111,190.00480.00%233.131,772.609,417.40233.13233.13233.13-10 电脑W-182008/5/128,800.00480.00%600.004,089.6024,710.40600.00600.00600.00-11 电脑w-192008/8/112,560.00480.00%261.671,446.0011,114.00261.67261.67261.67-12 音响设备一套1996/11/126,000.00480.00%541.6721,760.004,240.00-13 音响设备一套2009/1/117,000.00480.00%354.171,246.6315,753.37354.17354.17354.17-14 打印机w-212009/1/15,384.62480.00%112.18450.004,934.62112.18112.18112.18-15 电脑w-202008/12/110,000.00480.00%208.33830.009,170.00208.33208.33208.33-16 打印机w-222009/3/15,512.82480.00%114.85411.305,101.52114.85114.85114.85-17 电脑w-232009/9/15,897.44480.00%122.86147.005,750.44122.86122.86122.86-小计900,767.8818,766.01303,781.13596,986.7514,999.5914,999.5914,999.59-四，机器设备类1 对开双色胶印机J-61993/6/1583,304.241320.00%4,418.97583,304.24-2 四开双色胶印机J-71999/12/1500,000.001320.00%3,787.88259,070.00240,930.003,787.883,787.883,787.88-3 8K胶印机J-82000/5/147,000.001320.00%356.0628,296.0018,704.00356.06356.06356.06-4 对开单色双面胶印机J-9 2001/5/1460,000.001320.00%3,484.85254,064.00205,936.003,484.853,484.853,484.85-5 威海8K胶印机J-102002/5/164,000.001320.00%484.8532,228.0031,772.00484.85484.85484.85-6 8K胶印机J-112003/4/148,000.001320.00%363.6421,036.0026,964.00363.64363.64363.64-7 对开四色胶印机J-122004/1/11,998,000.001320.00%15,136.36525,176.681,472,823.3215,136.3615,136.3615,136.36-8 无轴报纸印刷机J-132005/9/13,400,000.001320.00%25,757.58716,508.562,683,491.4425,757.5825,757.5825,757.58-9 铁丝订书机2-201992/5/15,640.391320.00%42.735,281.14359.25-10 铁丝订书机2-211993/2/16,220.511320.00%47.136,050.51170.00-11 微控切纸机2-221992/10/1140,863.431320.00%1,067.15125,789.5815,073.85-12 全张切纸机2-231993/4/131,075.871320.00%235.4228,576.872,499.00-13 JB135A胶订包背机2-251999/6/138,480.001320.00%291.5225,960.0012,520.00291.52291.52291.52-14 三面切纸机2-262000/5/173,000.001320.00%553.0340,732.0032,268.00553.03553.03553.03-15 折页机2-272001/5/1168,000.001320.00%1,272.7388,776.0079,224.001,272.731,272.731,272.73-16 直线胶订包本机2-282002/5/147,000.001320.00%356.0635,281.0011,719.00356.06356.06356.06-17 锁线机2-292004/10/175,500.001320.00%571.9722,833.0052,667.00571.97571.97571.97-18 对开切纸机2-302007/1/150,450.001320.00%382.2011,412.0039,038.00382.20382.20382.20-19 半自动骑马订书机2-312007/4/135,000.001320.00%265.157,580.0027,420.00265.15265.15265.15-20 椭圆包本机2-322007/5/1180,000.001320.00%1,363.6431,752.00148,248.001,363.641,363.641,363.64-21 制模切割组合机3-261995/5/17,000.001320.00%53.036,155.00845.00-22 对开晒版机3-272000/7/112,000.001320.00%90.917,134.004,866.0090.9190.9190.91-23 PS版自动显影机3-282004/5/122,000.001320.00%166.678,662.0013,338.00166.67166.67166.67-24 海门立式停回转4-181993/4/165,135.811320.00%493.4557,721.317,414.50-25 对开平压压痕机4-241994/3/128,182.391320.00%213.5025,986.392,196.00-26 捆扎机2-332009/8/13,162.391320.00%23.9688.003,074.3923.9623.9623.96-小计8,089,015.0361,280.442,955,454.285,133,560.7554,709.0654,709.0654,709.06-五，其他1 简易货梯T-11994/6/177,276.46600.00%1,287.9471,890.465,386.00-2 纸架2001/3/13,037.00600.00%50.621,384.001,653.00-3 教桌2000/6/18,000.00600.00%133.335,076.002,924.00-4 办公桌椅2003/12/119,950.00600.00%332.508,376.0011,574.00-5 乒乓球桌2008/12/12,859.00600.00%47.65216.002,643.0047.6547.6547.65-6 会议桌2009/5/16,000.00600.00%100.00280.005,720.00100.00100.00100.00-小计117,122.460.00%1,952.0487,222.4629,900.00147.65147.65147.65-六，已提完折旧1 美国大屏幕微机W-867,437.0367,437.032 微机系统一套W-974,600.0074,600.003 厂房二幢160,714.02160,714.024 大门.厂房一幢37,139.7137,139.715 全张切纸机10,401.0510,401.056 电子交流稳压器945.66945.667 书芯压平机2-2427,480.0027,480.008 铁丝订书机2-16 2-178,785.088,785.089 液压切信封多用机3,868.053,868.0510 铁丝订书机2-12 2-138,094.068,094.0611 方箱印刷机19,734.2319,734.2312 对开单色胶印机J-3107,279.41107,279.4113 四开烘版机2,539.452,539.4514 四开晒版 机3,906.263,906.2615 烫金机3,888.003,888.0016 微机轻印系统211,971.68211,971.68小计748,783.690.00%748,783.69合计12,837,758.8600.00%98,956.895,927,717.116,910,041.7585,958.9885,958.9885,958.98-5,927,717.116,894,348.67请输入计算折旧的截止月份290,098.62-15,693.08起起始始月月：1 1截截止止月月：3 3全年计提折旧合计累计折旧总额净值开始计提折旧时间提完折旧时间存放地点89101112-4,860.78103,748.70382,328.302007-1-12031-12-28 蒙自景明路鑫苑小区C3-122.466,054.466,190.542002-4-12027-3-28 厂大门-459.991,239.9944,760.012009-8-12034-7-28 绿春巷17号-19,113.871,679,582.50231,803.401988-10-12013-9-28 上河路爱国村24号-24,557.101,790,625.65665,082.25-33,368.0017,974.902002-4-12007-3-28 厂部-2,110.2915,549.2926,656.712006-1-12010-12-28 厂部-18,923.7634,923.76343,551.242009-8-12014-7-28 厂部-2,716.896,316.8948,021.112009-4-12014-3-28 厂部-23,750.9490,157.94436,203.96-113,140.0036,860.001999-5-12003-4-28 微机车间-2,092.002,696.002004-7-12008-6-28 微机车间-3,125.0115,905.0134,094.992006-8-12010-7-28 微机车间-20,191.56114,775.56208,289.442006-11-12010-10-28 微机车间-11,250.0046,458.00133,542.002007-9-12011-8-28 微机车间-3,750.0015,510.0044,490.002007-9-12011-8-28 微机车间-660.632,724.637,845.372007-9-12011-8-28 微机车间-699.392,471.998,718.012008-6-12012-5-28 微机车间-1,800.005,889.6022,910.402008-6-12012-5-28 微机车间-785.012,231.0110,328.992008-9-12012-8-28 微机车间-21,760.004,240.001996-12-12000-11-28 微机车间-1,062.512,309.1414,690.862009-2-12013-1-28 微机车间-336.54786.544,598.082009-2-12013-1-28 微机车间-624.991,454.998,545.012009-1-12012-12-28 微机车间-344.55755.854,756.972009-4-12013-3-28 微机车间-368.58515.585,381.862009-10-12013-9-28 微机车间-44,998.77348,779.90551,987.98-583,304.24-1993-7-12004-6-28 机印车间-11,363.64270,433.64229,566.362000-1-12010-12-28 机印车间-1,068.1829,364.1817,635.822000-6-12011-5-28 机印车间-10,454.55264,518.55195,481.452001-6-12012-5-28 机印车间-1,454.5533,682.5530,317.452002-6-12013-5-28 机印车间-1,090.9222,126.9225,873.082003-5-12014-4-28 机印车间-45,409.08570,585.761,427,414.242004-2-12015-1-28 机印车间-77,272.74793,781.302,606,218.702005-10-12016-9-28 机印车间-5,281.14359.251992-6-12003-5-28 机印车间-6,050.51170.001993-3-12004-2-28 机印车间-125,789.5815,073.851992-11-12003-10-28 机印车间-28,576.872,499.001993-5-12004-4-28 机印车间-874.5626,834.5611,645.441999-7-12010-6-28 机印车间-1,659.0942,391.0930,608.912000-6-12011-5-28 机印车间-3,818.1992,594.1975,405.812001-6-12012-5-28 机印车间-1,068.1836,349.1810,650.822002-6-12013-5-28 机印车间-1,715.9124,548.9150,951.092004-11-12015-10-28 机印车间-1,146.6012,558.6037,891.402007-2-12018-1-28 机印车间-795.458,375.4526,624.552007-5-12018-4-28 机印车间-4,090.9235,842.92144,157.082007-6-12018-5-28 机印车间-6,155.00845.001995-6-12006-5-28 机印车间-272.737,406.734,593.272000-8-12011-7-28 机印车间-500.019,162.0112,837.992004-6-12015-5-28 机印车间-57,721.317,414.501993-5-12004-4-28 机印车间-25,986.392,196.001994-4-12005-3-28 机印车间-71.88159.883,002.512009-9-12020-8-28 机印车间-164,127.183,119,581.464,969,433.57-71,890.465,386.001994-7-11999-6-28 机印车间-1,384.001,653.002001-4-12006-3-28 装订车间-5,076.002,924.002000-7-12005-6-28 厂部-8,376.0011,574.002004-1-12008-12-28 厂部-142.95358.952,500.052009-1-12013-12-28 厂部-300.00580.005,420.002009-6-12014-5-28 厂部-442.9587,665.4129,457.05-257,876.945,436,810.366,652,164.81