+ Reply to Thread
Results 1 to 9 of 9

Depreciation of fixed asset

  1. #1
    Forum Contributor nasser's Avatar
    Join Date
    12-29-2006
    Location
    Kuwait
    MS-Off Ver
    2010-2013-2016
    Posts
    216

    Depreciation of fixed asset

    I'm trying to calculate the Depreciation of the fixed asset for some items
    I've tried the formulas that came with Excel but i don't know its not working or not give the correct value
    so I attached a file as an example
    what I'm trying to have is
    1- straight line method along the asset life
    2- salvage must be ( 1 )
    3- if the purchase date is equal to or before the middle of the month (14-15/02/2004) so the start of depreciation have to start from the beginning of the current month ( Feb) but if the date excess the day 15 ( 16/02/2004) the middle of the month , the the depreciation must start from the next month.
    so any one can help ?
    Attached Files Attached Files
    Last edited by nasser; 03-20-2009 at 08:14 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Depreciation of fixed asset

    I'm not quite I understand how you want to apply your Salvage and/or your End Dates in the sample mean the assets are all fully depreciated but perhaps:

    E2: =DATE(YEAR(D2),MONTH(D2)+(DAY(D2)>15),1)
    G2: =MIN(C2-1,(C2/DATEDIF(E2,F2,"m"))*DATEDIF(E2,MIN(F2,TODAY()),"m"))
    H2: =C2-G2

    Copied down for other rows.

  3. #3
    Forum Contributor nasser's Avatar
    Join Date
    12-29-2006
    Location
    Kuwait
    MS-Off Ver
    2010-2013-2016
    Posts
    216

    Re: Depreciation of fixed asset

    Quote Originally Posted by DonkeyOte View Post
    I'm not quite I understand how you want to apply your Salvage and/or your End Dates in the sample mean the assets are all fully depreciated but perhaps:

    E2: =DATE(YEAR(D2),MONTH(D2)+(DAY(D2)>15),1)
    G2: =MIN(C2-1,(C2/DATEDIF(E2,F2,"m"))*DATEDIF(E2,MIN(F2,TODAY()),"m"))
    H2: =C2-G2

    Copied down for other rows.
    ok I changed the dates and made it in 2008 but still the current value is the same

    **P.S. the date formula is working so well thank u
    Attached Files Attached Files
    Last edited by nasser; 03-20-2009 at 08:14 AM.

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Depreciation of fixed asset

    I don't understand your point, the last depreciation date for each asset is in the past (we're in 2009!) so they're all fully depreciated (less salvage value).

  5. #5
    Forum Contributor nasser's Avatar
    Join Date
    12-29-2006
    Location
    Kuwait
    MS-Off Ver
    2010-2013-2016
    Posts
    216

    Re: Depreciation of fixed asset

    Quote Originally Posted by DonkeyOte View Post
    I don't understand your point, the last depreciation date for each asset is in the past (we're in 2009!) so they're all fully depreciated (less salvage value).
    the asset life in Item 2 and 3 is 3 and 4 years , so it must be = 1 after 3 and 4 years

  6. #6
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Depreciation of fixed asset

    So just to finalise are you saying you only depreciate annually - I don't understand the significance of Last Depreciation Date otherwise.

  7. #7
    Forum Contributor nasser's Avatar
    Join Date
    12-29-2006
    Location
    Kuwait
    MS-Off Ver
    2010-2013-2016
    Posts
    216

    Re: Depreciation of fixed asset

    Quote Originally Posted by DonkeyOte View Post
    So just to finalise are you saying you only depreciate annually - I don't understand the significance of Last Depreciation Date otherwise.
    no , I depreciate monthly along with the asset life ,
    like in my excel sheet , item number 1 the asset life for it is 1 year , so after one year this item value must be equal 1

    and Item number 2 the asset life is 3 years , so after 3 years the item value must be equal 1
    and so on

  8. #8
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Depreciation of fixed asset

    It would help going forward to specify where you need formulae to avoid confusion.

    To avoid further confusion I've attached a file detailing my preferred approach -- this assumes depreciation is run on last working day of calendar month (ie Mar09 depreciation run 31st March)
    Attached Files Attached Files

  9. #9
    Forum Contributor nasser's Avatar
    Join Date
    12-29-2006
    Location
    Kuwait
    MS-Off Ver
    2010-2013-2016
    Posts
    216

    Re: Depreciation of fixed asset

    Quote Originally Posted by DonkeyOte View Post
    It would help going forward to specify where you need formulae to avoid confusion.

    To avoid further confusion I've attached a file detailing my preferred approach -- this assumes depreciation is run on last working day of calendar month (ie Mar09 depreciation run 31st March)
    thanks a lot , that's solving the case and found what i'm looking for ..
    Best Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1