文档格式-折旧计提法模板.xls

原值200000 净残值75000 预计使用年限15 年限年折旧额累计折旧帐面价值 0200000 1 8,333.338,333.33191,666.67 2 8,333.3316,666.67183,333.33 3 8,333.3325,000.00175,000.00 4 8,333.3333,333.33166,666.67 5 8,333.3341,666.67158,333.33 6 8,333.3350,000.00150,000.00 7 8,333.3358,333.33141,666.67 8 8,333.3366,666.67133,333.33 9 8,333.3375,000.00125,000.00 10 8,333.3383,333.33116,666.67 11 8,333.3391,666.67108,333.33 12 8,333.33100,000.00100,000.00 13 8,333.33108,333.3391,666.67 14 8,333.33116,666.6783,333.33 15 8,333.33125,000.0075,000.00 折旧费用分析图 0 50000 100000 150000 200000 250000 年限 折旧额 12345 年限12345 年折旧额8,333.338,333.338,333.338,333.338,333.33 累计折旧8,333.3316,666.6725,000.0033,333.3341,666.67 帐面价值191,666.67183,333.33175,000.00166,666.67158,333.33 年限年折旧额累计折旧帐面价值 原值200000 净残值75000 预计使用年限15 年限年折旧额累计折旧帐面价值 1 8,333.338,333.33191,666.67 2 8,333.3316,666.67183,333.33 3 8,333.3325,000.00175,000.00 4 8,333.3333,333.33166,666.67 5 8,333.3341,666.67158,333.33 6 8,333.3350,000.00150,000.00 7 8,333.3358,333.33141,666.67 8 8,333.3366,666.67133,333.33 9 8,333.3375,000.00125,000.00 10 8,333.3383,333.33116,666.67 11 8,333.3391,666.67108,333.33 12 8,333.33100,000.00100,000.00 13 8,333.33108,333.3391,666.67 14 8,333.33116,666.6783,333.33 15 8,333.33125,000.0075,000.00 原值50000 净残值8000 预计使用年限10 年份年折旧额 110,000.00 28,000.00 36,400.00 45,120.00 54,096.00 63,276.80 72,621.44 82,097.15 9194.30 10194.30 第1年折旧额原值年份原值第1月折旧额 4,090.9130000.00130000371.90 14090.91 23681.82 33272.73 42863.64 52454.55 62045.45 71636.36 81227.27 9818.18 10409.09 合计22500.00