财务管理基础模板-折旧计提法.xlsx

《财务管理基础模板-折旧计提法.xlsx》由会员分享，可在线阅读，更多相关《财务管理基础模板-折旧计提法.xlsx（5页珍藏版）》请在工友文库上搜索。

1、原值200000净残值75000预计使用年限15年限年折旧额累计折旧帐面价值020000018,333.338,333.33191,666.6728,333.3316,666.67183,333.3338,333.3325,000.00175,000.0048,333.3333,333.33166,666.6758,333.3341,666.67158,333.3368,333.3350,000.00150,000.0078,333.3358,333.33141,666.6788,333.3366,666.67133,333.3398,333.3375,000.00125,000.00108,

2、333.3383,333.33116,666.67118,333.3391,666.67108,333.33128,333.33100,000.00100,000.00138,333.33108,333.3391,666.67148,333.33116,666.6783,333.33158,333.33125,000.0075,000.00折旧费用分析图050000100000150000200000250000年限折旧额12345年限12345年折旧额8,333.338,333.338,333.338,333.338,333.33累计折旧8,333.3316,666.6725,000.003

3、3,333.3341,666.67帐面价值191,666.67183,333.33175,000.00166,666.67158,333.33年限年折旧额累计折旧帐面价值原值200000净残值75000预计使用年限15年限年折旧额累计折旧帐面价值18,333.338,333.33191,666.6728,333.3316,666.67183,333.3338,333.3325,000.00175,000.0048,333.3333,333.33166,666.6758,333.3341,666.67158,333.3368,333.3350,000.00150,000.0078,333.335

4、8,333.33141,666.6788,333.3366,666.67133,333.3398,333.3375,000.00125,000.00108,333.3383,333.33116,666.67118,333.3391,666.67108,333.33128,333.33100,000.00100,000.00138,333.33108,333.3391,666.67148,333.33116,666.6783,333.33158,333.33125,000.0075,000.00原值50000净残值8000预计使用年限10年份年折旧额110,000.0028,000.0036,400.0045,120.0054,096.0063,276.8072,621.4482,097.159194.3010194.30第1年折旧额原值年份原值第1月折旧额4,090.9130000.00130000371.9014090.9123681.8233272.7342863.6452454.5562045.4571636.3681227.279818.1810409.09合计22500.00