固定资产折旧计算固定资产电脑原值10000开始使用日期1/1/2020残值率10%预计使用年限5净残值1000直线折旧法7,200.00¥双倍余额递减法8,918.71¥年份年折旧额年份年折旧额20201,650.00¥20203,112.78¥20211,800.00¥20212,301.95¥20221,800.00¥20221,532.56¥20231,800.00¥2023995.95¥2024150.00¥2024975.48¥年数总和法8,995.08¥对比分析年份年折旧额20202,975.41¥20212,567.21¥20221,859.02¥20231,150.82¥2024442.62¥Depreciationoffixedassets20202021202220232024¥0.00¥2,000.00¥4,000.00年数总和法双倍余额递减法直线折旧法1/1/202560年份年数总和法双倍余额递减法双倍余额计算辅助列112020295.08¥333.33¥60222020290.16¥322.22¥59332020285.25¥311.48¥58442020280.33¥301.10¥57552020275.41¥291.06¥56662020270.49¥281.36¥55772020265.57¥271.98¥54882020260.66¥262.92¥53992020255.74¥254.15¥5210102020250.82¥245.68¥5111112020245.90¥237.49¥5012122021240.98¥229.57¥4913132021236.07¥221.92¥4814142021231.15¥214.52¥4715152021226.23¥207.37¥4616162021221.31¥200.46¥4517172021216.39¥193.78¥4418182021211.48¥187.32¥4319192021206.56¥181.08¥4220202021201.64¥175.04¥4121212021196.72¥169.21¥4022222021191.80¥163.56¥3923232021186.89¥158.11¥3824242022181.97¥152.84¥3725252022177.05¥147.75¥3626262022172.13¥142.82¥3527272022167.21¥138.06¥3428282022162.30¥133.46¥3329292022157.38¥129.01¥3230302022152.46¥124.71¥3131312022147.54¥120.55¥3032322022142.62¥116.54¥2933332022137.70¥112.65¥2834342022132.79¥108.90¥2735352022127.87¥105.27¥2636362023122.95¥101.76¥2537372023118.03¥81.29¥2438382023113.11¥81.29¥2339392023108.20¥81.29¥2240402023103.28¥81.29¥214141202398.36¥81.29¥204242202393.44¥81.29¥194343202388.52¥81.29¥184444202383.61¥81.29¥174545202378.69¥81.29¥164646202373.77¥81.29¥154747202368.85¥81.29¥144848202463.93¥81.29¥134949202459.02¥81.29¥125050202454.10¥81.29¥115151202449.18¥81.29¥105252202444.26¥81.29¥95353202439.34¥81.29¥85454202434.43¥81.29¥75555202429.51¥81.29¥65656202424.59¥81.29¥55757202419.67¥81.29¥45858202414.75¥81.29¥3595920249.84¥81.29¥2606020254.92¥81.29¥1616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150
