固定资产计提折旧Excel模板

1、2010年固定资产计提折旧表时间品名账面 数量单价账面金额预计残值5%计提折旧额1月2月3月4月5月6月7月8月9月10月11月12月2010折旧合计2005折旧合计2006折旧合计2007折旧合计2008折旧合计2009折旧合计累计折旧净值盘点 数量盘点金额2005/05/29掌上电脑19,580.009,580.00479.009,101.00151.68151.68151.68151.68151.680.000.000.000.000.000.000.00758.421,061.781,820.201,820.201,820.201,820.209,101.00479.0019,580.

2、002005/05/30打印机23,000.006,000.00300.005,700.0095.0095.0095.0095.0095.000.000.000.000.000.000.000.00475.00665.001,140.001,140.001,140.001,140.005,700.00300.0026,000.002006/01/22台式机54,200.0021,000.001,050.0019,950.00332.50332.50332.50332.50332.50332.50332.50332.50332.50332.50332.50332.503,990.000.003,

3、657.503,990.003,990.003,990.0019,617.501,382.50521,000.002007/12/11笔记本38,000.0024,000.001,200.0022,800.00380.00380.00380.00380.00380.00380.00380.00380.00380.00380.00380.00380.004,560.000.000.000.004,560.004,560.0013,680.0010,320.00324,000.002008/03/30笔记本37,500.0022,500.001,125.0021,375.00356.25356.2

4、5356.25356.25356.25356.25356.25356.25356.25356.25356.25356.254,275.000.000.000.003,206.254,275.0011,756.2510,743.75322,500.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0

5、00.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00合计83,080.004,154.0078,926.001,315.431,315.431,315.431,315.431,315.431,068.751,068.751,068.751,068.751,068.751,068.751,068.751