Asset-Depreciation by xiaoyounan

VIEWS: 2 PAGES: 2

									Asset Depreciation

Instructions:

This template allows you to monitor asset depreciation using any of four different methods. To use
the template, you only need to enter data into the following three cells:

F3 – Initial cost
F4 – Salvage value
F5 – Useful life
                                                                                                          Dec 26, 2011
                                                                               Initial cost            £10,000.00
    Asset Depreciation                                                    Salvage value                 £1,500.00
   Annual depreciation amounts under various methods                Useful life (years)                      10

                                                                                                150%
                            Double Declining                        Sum of Years
   Years                                     Straight-Line                                      Declining Balance
                            Balance                                 Digits

                      1                   £2,000.00       £850.00              £1,545.45                       £1,500.00
                      2                   £1,600.00       £850.00              £1,390.91                       £1,275.00
                      3                   £1,280.00       £850.00              £1,236.36                       £1,083.75
                      4                   £1,024.00       £850.00              £1,081.82                         £921.19
                      5                     £819.20       £850.00                £927.27                         £783.01
                      6                     £655.36       £850.00                £772.73                         £665.56
                      7                     £524.29       £850.00                £618.18                         £565.72
                      8                     £419.43       £850.00                £463.64                         £480.87
                      9                     £177.72       £850.00                £309.09                         £408.74
                     10                       £0.00       £850.00                £154.55                         £347.43




                  Total                   £8,500.00     £8,500.00              £8,500.00                       £8,031.26




                                Free Business Templates from www.biztemplates365.com




Free Business Templates from www.biztemplates365.com                Businessclub365.com - Tools and Resources for Small Business

								
To top