折旧计提法模板.xls

原值200000净残值75000预计使用年限15年限年折旧额累计折旧帐面价值02000001￥8,333.33￥8,333.33￥191,666.672￥8,333.33￥16,666.67￥183,333.333￥8,333.33￥25,000.00￥175,000.004￥8,333.33￥33,333.33￥166,666.675￥8,333.33￥41,666.67￥158,333.336￥8,333.33￥50,000.00￥150,000.007￥8,333.33￥58,333.33￥141,666.678￥8,333.33￥66,666.67￥133,333.339￥8,333.33￥75,000.00￥125,000.0010￥8,333.33￥83,333.33￥116,666.6711￥8,333.33￥91,666.67￥108,333.3312￥8,333.33￥100,000.00￥100,000.0013￥8,333.33￥108,333.33￥91,666.6714￥8,333.33￥116,666.67￥83,333.3315￥8,333.33￥125,000.00￥75,000.00折旧费用分析图050000100000150000200000250000年限折旧额12345年限12345年折旧额￥8,333.33￥8,333.33￥8,333.33￥8,333.33￥8,333.33累计折旧￥8,333.33￥16,666.67￥25,000.00￥33,333.33￥41,666.67帐面价值￥191,666.67￥183,333.33￥175,000.00￥166,666.67￥158,333.33年限年折旧额累计折旧帐面价值折旧费用分析图050000100000150000200000250000年限折旧额12345年限12345年折旧额￥8,333.33￥8,333.33￥8,333.33￥8,333.33￥8,333.33累计折旧￥8,333.33￥16,666.67￥25,000.00￥33,333.33￥41,666.67帐面价值￥191,666.67￥183,333.33￥175,000.00￥166,666.67￥158,333.33年限年折旧额累计折旧帐面价值原值200000净残值75000预计使用年限15年限年折旧额累计折旧帐面价值1￥8,333.33￥8,333.33￥191,666.672￥8,333.33￥16,666.67￥183,333.333￥8,333.33￥25,000.00￥175,000.004￥8,333.33￥33,333.33￥166,666.675￥8,333.33￥41,666.67￥158,333.336￥8,333.33￥50,000.00￥150,000.007￥8,333.33￥58,333.33￥141,666.678￥8,333.33￥66,666.67￥133,333.339￥8,333.33￥75,000.00￥125,000.0010￥8,333.33￥83,333.33￥116,666.6711￥8,333.33￥91,666.67￥108,333.3312￥8,333.33￥100,000.00￥100,000.0013￥8,333.33￥108,333.33￥91,666.6714￥8,333.33￥116,666.67￥83,333.3315￥8,333.33￥125,000.00￥75,000.00原值50000净残值8000预计使用年限10年份年折旧额1￥10,000.002￥8,000.003￥6,400.004￥5,120.005￥4,096.006￥3,276.807￥2,621.448￥2,097.159￥194.3010￥194.30第1年折旧额 原值年份原值第1月折旧额￥4,090.9130000.00130000￥371.9014090.9123681.8233272.7342863.6452454.5562045.4571636.3681227.279818.1810409.09合计22500.00