固定资产折旧抽样数据分析
企业固定资产折旧年份 资产额(单位:万元) 抽样数据 折旧递减1955 ¥8,880 ¥8,235 1956 ¥8,732 ¥7,556 ¥135.81957 ¥8,586 ¥6,808 ¥149.61958 ¥8,446 ¥6,055 ¥150.61959 ¥8,235 ¥5,335 ¥144.01960 ¥8,166 ¥4,525 ¥162.01961 ¥7,950 ¥3,846 ¥135.81962 ¥7,821 ¥3,108 ¥147.61963 ¥7,693 ¥2,346 ¥152.41964 ¥7,556 ¥1,624 ¥144.41965 ¥7,4121966 ¥7,232 年均折旧额 ¥146.91967 ¥7,1041968 ¥6,956 SLN()函数求解 ¥1451969 ¥6,8081970 ¥6,6601971 ¥6,5121972 ¥6,3641973 ¥6,2161974 ¥6,0551975 ¥5,9181976 ¥5,7331977 ¥5,6521978 ¥5,4251979 ¥5,3351980 ¥5,1651981 ¥5,0321982 ¥4,8221983 ¥4,7461984 ¥4,5251985 ¥4,4601986 ¥4,2201987 ¥4,1451988 ¥3,9551989 ¥3,8461990 ¥3,7001991 ¥3,5521992 ¥3,4111993 ¥3,2501994 ¥3,1081995 ¥2,9221996 ¥2,8231997 ¥2,6501998 ¥2,5161999 ¥2,3462000 ¥2,220抽 样 数 据1 2 3 4 5 6 7 8 9 1 0¥ 1,000¥ 2,000¥ 3,000¥ 4,000¥ 5,000¥ 6,000¥ 7,000¥ 8,000¥ 9,000年 份固定资产金额2001 ¥2,0442002 ¥1,9852003 ¥1,7642004 ¥1,624抽 样 数 据1 2 3 4 5 6 7 8 9 1 0¥ 1,000¥ 2,000¥ 3,000¥ 4,000¥ 5,000¥ 6,000¥ 7,000¥ 8,000¥ 9,000年 份固定资产金额