09-【折旧】-01-固定资产折旧计算器.xlsx

固固定定资资产产折折旧旧计计算算固固定定资资产产电电脑脑原原值值1000010000开开始始使使用用日日期期2020/1/12020/1/1残残值值率率10%10%预预计计使使用用年年限限5 5净净残残值值10001000直直线线折折旧旧法法7,200.00双双倍倍余余额额递递减减法法8,918.71年年份份年年折折旧旧额额年年份份年年折折旧旧额额20201,650.0020203,112.7820211,800.0020212,301.9520221,800.0020221,532.5620231,800.002023995.952024150.002024975.48年年数数总总和和法法8,995.08对对比比分分析析年年份份年年折折旧旧额额20202,975.4120212,567.2120221,859.0220231,150.822024442.62Depreciation of fixed assets202020212022202320244,000.002,000.000.00直线折旧法双倍余额递减法年数总和法2025/1/160年份年数总和法双倍余额递减法双倍余额计算辅助列112020295.08333.3360222020290.16322.2259332020285.25311.4858442020280.33301.1057552020275.41291.0656662020270.49281.3655772020265.57271.9854882020260.66262.9253992020255.74254.155210102020250.82245.685111112020245.90237.495012122021240.98229.574913132021236.07221.924814142021231.15214.524715152021226.23207.374616162021221.31200.464517172021216.39193.784418182021211.48187.324319192021206.56181.084220202021201.64175.044121212021196.72169.214022222021191.80163.563923232021186.89158.113824242022181.97152.843725252022177.05147.753626262022172.13142.823527272022167.21138.063428282022162.30133.463329292022157.38129.013230302022152.46124.713131312022147.54120.553032322022142.62116.542933332022137.70112.652834342022132.79108.902735352022127.87105.272636362023122.95101.762537372023118.0381.292438382023113.1181.292339392023108.2081.292240402023103.2881.29214141202398.3681.29204242202393.4481.29194343202388.5281.29184444202383.6181.29174545202378.6981.29164646202373.7781.29154747202368.8581.29144848202463.9381.29134949202459.0281.29125050202454.1081.29115151202449.1881.29105252202444.2681.2995353202439.3481.2985454202434.4381.2975555202429.5181.2965656202424.5981.2955757202419.6781.2945858202414.7581.293595920249.8481.292606020254.9281.291616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150