固定資產(chǎn)折舊自動(dòng)計(jì)算表模版

固定資產(chǎn)折舊自動(dòng)計(jì)算表,,,,,,,,,,,,,,,,,,

單位名稱：,,,,,,,,,,,,,,,,,,

日期:,2016年6月30日,,,,,,,折舊方法：,,平均年限法,,,固定資產(chǎn)類別：辦公設(shè)備、運(yùn)輸工具類,,,,單位:元,

編號(hào),名稱,使用部門,入賬日期,單位,數(shù)量,原幣單價(jià),購(gòu)進(jìn)原值,使用年限,"殘值

率%",預(yù)計(jì)凈殘值,已使用月份,本月折舊,累計(jì)折舊,凈值,月折舊額,實(shí)際計(jì)算截止日期,累計(jì)折舊計(jì)算值,上月累計(jì)折舊計(jì)算值

,設(shè)備合計(jì),,,,,"850,141.87","898,011.87",,,"44,900.59",,"16,715.47","731,841.86","166,170.01","16,968.07",,"731,842.19","714,874.12"

FJSH-A00001,TCL立式空調(diào),總經(jīng)理辦公室,2012年6月30日,臺(tái),1,"3,999.00","3,999.00",5,5%,199.95,48,63.32,3039.36,959.64,63.32,2016/6/30,"3,039.36","2,976.04"

FJSH-A00002,海爾冰柜,總經(jīng)理辦公室,2013年1月31日,,1,"2,659.00","2,659.00",5,5%,132.95,41,42.10,1726.10,932.90,42.10,2016/6/30,"1,726.10","1,684.00"

FJSH-A00003,HP電腦,總經(jīng)理辦公室,,,1,"5,000.00","5,000.00",3,5%,250.00,,131.94,4617.90,382.10,131.94,1902/12/31,"4,617.90","4,485.96"

FJSH-A00004,保險(xiǎn)柜,總經(jīng)理辦公室,,,1,800.00,800.00,3,5%,40.00,,21.11,738.85,61.15,21.11,1902/12/31,738.85,717.74

FJSH-A00005,美的空調(diào),總經(jīng)理辦公室,,,1,"2,600.00","2,600.00",3,5%,130.00,,68.61,2401.35,198.65,68.61,1902/12/31,"2,401.35","2,332.74"

FJSH-A00006,魚缸組合,總經(jīng)理辦公室,2013年6月30日,,1,"2,000.00","2,000.00",3,5%,100.00,36,52.70,1900.00,100.00,52.78,2016/6/30,"1,900.08","1,847.30"

FJSH-A00007,原木茶桌,總經(jīng)理辦公室,,,1,"10,000.00","10,000.00",5,5%,500.00,,158.33,9341.47,658.53,158.33,1904/12/31,"9,341.47","9,183.14"

FJSH-A00008,辦公椅,總經(jīng)理辦公室,,,1,"10,000.00","10,000.00",5,5%,500.00,,158.33,9341.47,658.53,158.33,1904/12/31,"9,341.47","9,183.14"

FJSH-A00009,太師椅,總經(jīng)理辦公室,,,1,-,,,5%,,,,,,,1899/12/31,-,-

FJSH-A00010,辦公桌組合,總經(jīng)理辦公室,,,1,-,,,5%,,,,,,,1899/12/31,-,-

FJSH-A00011,折疊床,總經(jīng)理辦公室,,,1,-,,,5%,,,,,,,1899/12/31,-,-

FJSH-A00012,電腦,財(cái)務(wù)辦公區(qū),2016年5月1日,,3,"1,533.33","4,600.00",3,5%,230.00,1,121.39,121.39,4478.61,121.39,2016/6/30,121.39,-

FJSH-A00013,多動(dòng)能打印一體機(jī),財(cái)務(wù)辦公區(qū),2012年9月30日,,1,"1,700.00","1,700.00",3,5%,85.00,45,,1614.96,85.04,44.86,2015/9/30,"1,614.96","1,570.10"

FJSH-A00014,辦公桌,財(cái)務(wù)辦公區(qū),,,2,500.00,"1,000.00",3,5%,50.00,,26.39,923.65,76.35,26.39,1902/12/31,923.65,897.26

FJSH-A00015,皮質(zhì)沙發(fā),財(cái)務(wù)辦公區(qū),,,1,"3,000.00","3,000.00",3,5%,150.00,,79.17,2770.95,229.05,79.17,1902/12/31,"2,770.95","2,691.78"

FJSH-A00016,大小茶幾,財(cái)務(wù)辦公區(qū),,,3,200.00,600.00,3,5%,30.00,,15.83,554.05,45.95,15.83,1902/12/31,554.05,538.22

FJSH-A00017,鐵皮文件柜,財(cái)務(wù)辦公區(qū),2016年5月1日,,1,530.00,530.00,3,5%,26.50,1,13.99,13.99,516.01,13.99,2016/6/30,13.99,-

FJSH-A00018,辦公椅,財(cái)務(wù)辦公區(qū),,,5,160.00,800.00,3,5%,40.00,,21.11,738.85,61.15,21.11,1902/12/31,738.85,717.74

FJSH-A00019,美的空調(diào),財(cái)務(wù)辦公區(qū),,,1,"2,600.00","2,600.00",3,5%,130.00,,68.61,2401.35,198.65,68.61,1902/12/31,"2,401.35","2,332.74"

FJSH-A00020,京瓷打印一體機(jī),綜合辦公區(qū),2013年5月31日,,1,"4,400.00","4,400.00",3,5%,220.00,37,,4179.96,220.04,116.11,2016/5/31,"4,179.96","4,063.85"

FJSH-A00021,美的空調(diào),綜合辦公區(qū),,,2,"2,600.00","5,200.00",3,5%,260.00,,137.22,4802.70,397.30,137.22,1902/12/31,"4,802.70","4,665.48"

FJSH-A00022,辦公桌,綜合辦公區(qū),,,3,"1,000.00","3,000.00",3,5%,150.00,,79.17,2770.95,229.05,79.17,1902/12/31,"2,770.95","2,691.78"

FJSH-A00023,電腦,綜合辦公區(qū),,,3,"1,666.67","5,000.00",3,5%,250.00,,131.94,4617.90,382.10,131.94,1902/12/31,"4,617.90","4,485.96"

FJSH-A00024,傳真機(jī),綜合辦公區(qū),,,1,600.00,600.00,3,5%,30.00,,15.83,554.05,45.95,15.83,1902/12/31,554.05,538.22

FJSH-A00025,辦公椅,綜合辦公區(qū),,,3,200.00,600.00,3,5%,30.00,,15.83,554.05,45.95,15.83,1902/12/31,554.05,538.22

FJSH-A00026,會(huì)議桌,綜合辦公區(qū),,,1,"2,000.00","2,000.00",3,5%,100.00,,52.78,1847.30,152.70,52.78,1902/12/31,"1,847.30","1,794.52"

FJSH-A00027,鐵皮柜,綜合辦公區(qū),,,2,400.00,800.00,3,5%,40.00,,21.11,738.85,61.15,21.11,1902/12/31,738.85,717.74

FJSH-A00028,玻璃茶幾,綜合辦公區(qū),,,1,300.00,300.00,3,5%,15.00,,7.92,277.20,22.80,7.92,1902/12/31,277.20,269.28

FJSH-A00029,熱水器,宿舍,2013年1月31日,,1,"1,269.00","1,269.00",3,5%,63.45,41,,1205.55,63.45,33.49,2016/1/31,"1,205.64","1,172.15"

FJSH-A00030,空調(diào),宿舍,,,1,"2,600.00","2,600.00",3,5%,130.00,,68.61,2401.35,198.65,68.61,1902/12/31,"2,401.35","2,332.74"

FJSH-B00001,閩AQP292,,2012年12月31日,,1,"300,000.00","300,000.00",4,5%,15000.00,42,5937.50,249375.00,50625.00,5937.50,2016/6/30,"249,375.00","243,437.50"

FJSH-B00002,閩AF297M,,,,1,"36,000.00","36,000.00",4,5%,1800.00,,712.50,33487.50,2512.50,712.50,1903/12/31,"33,487.50","32,775.00"

FJSH-B00003,閩A0292Y,,2014年1月31日,,1,"71,794.87","71,794.87",4,5%,3589.74,29,1420.94,41207.26,30587.61,1420.94,2016/6/30,"41,207.26","39,786.32"

FJSH-B00004,閩AHB396,,,,1,"80,000.00","80,000.00",4,5%,4000.00,,1583.33,74416.51,5583.49,1583.33,1903/12/31,"74,416.51","72,833.18"

FJSH-C00001,手電鉆,車間,2013年10月31日,,12,130.00,"1,560.00",3,5%,78.00,32,41.17,1317.44,242.56,41.17,2016/6/30,"1,317.44","1,276.27"

FJSH-C00002,電錘,車間,2013年10月31日,,3,250.00,750.00,3,5%,37.50,32,19.79,633.28,116.72,19.79,2016/6/30,633.28,613.49

FJSH-C00003,電焊機(jī),車間,,,3,500.00,"1,500.00",3,5%,75.00,,39.58,1385.30,114.70,39.58,1902/12/31,"1,385.30","1,345.72"

FJSH-C00004,手動(dòng)切割機(jī),車間,,,4,500.00,"2,000.00",3,5%,100.00,,52.78,1847.30,152.70,52.78,1902/12/31,"1,847.30","1,794.52"

FJSH-C00005,角磨機(jī),車間,2013年10月31日,,3,150.00,450.00,3,5%,22.50,32,11.88,380.16,69.84,11.88,2016/6/30,380.16,368.28

FJSH-C00006,三相切割機(jī),車間,,,1,"1,200.00","1,200.00",3,5%,60.00,,31.67,1108.45,91.55,31.67,1902/12/31,"1,108.45","1,076.78"

FJSH-C00007,雙頭切割鋸,車間,2012年12月31日,,1,"68,000.00","68,000.00",5,5%,3400.00,42,1076.67,45220.14,22779.86,1076.67,2016/6/30,"45,220.14","44,143.47"

FJSH-C00008,角碼自動(dòng)切割機(jī),車間,2012年12月31日,,1,"15,000.00","15,000.00",5,5%,750.00,42,237.50,9975.00,5025.00,237.50,2016/6/30,"9,975.00","9,737.50"

FJSH-C00009,單頭切割機(jī),車間,,,1,"23,000.00","23,000.00",5,5%,1150.00,,364.17,21486.03,1513.97,364.17,1904/12/31,"21,486.03","21,121.86"

FJSH-C00010,五刀端面銑床,車間,2012年12月31日,,1,"32,000.00","32,000.00",5,5%,1600.00,42,506.67,21280.14,10719.86,506.67,2016/6/30,"21,280.14","20,773.47"

FJSH-C00011,V型切割機(jī),車間,,,1,"28,000.00","28,000.00",5,5%,1400.00,,443.33,26156.47,1843.53,443.33,1904/12/31,"26,156.47","25,713.14"

FJSH-C00012,手動(dòng)鋸條,車間,,,1,"9,000.00","9,000.00",5,5%,450.00,,142.50,8407.50,592.50,142.50,1904/12/31,"8,407.50","8,265.00"

FJSH-C00013,垂型組角機(jī),車間,,,1,"56,000.00","56,000.00",5,5%,2800.00,,886.67,52313.53,3686.47,886.67,1904/12/31,"52,313.53","51,426.86"

FJSH-C00014,重型高精度仿型銑床,車間,2012年12月31日,,1,"34,000.00","34,000.00",5,5%,1700.00,42,538.33,22609.86,11390.14,538.33,2016/6/30,"22,609.86","22,071.53"

FJSH-C00015,同步組角機(jī),車間,2012年12月31日,,1,"11,000.00","11,000.00",5,5%,550.00,42,174.17,7315.14,3684.86,174.17,2016/6/30,"7,315.14","7,140.97"

FJSH-C00016,沖床,車間,,,3,"9,000.00","27,000.00",5,5%,1350.00,,427.50,25222.50,1777.50,427.50,1904/12/31,"25,222.50","24,795.00"

FJSH-C00017,臺(tái)鉆,車間,,,2,"2,000.00","4,000.00",3