Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    125
    Thanked 5 Times in 5 Posts

    Computing Remaining life and no. of months

    I have an asset template where I have tried to compute the no. of months to depreciate. I have manually computed the months to depreciate in Col I


    The financial year ends on 31 Aug each year i.e current financial year 31/08/2016 and starts on 01/10/2015

    The No. of months depreciation will be 12 months, unless the no in Col F is less than 12 months or the start date is in the current financial year i.e from 01/10/2015 to 31/08/2016


    It would be appreciated if someone could kindly correct this
    Attached Files Attached Files
    Last edited by HowardC; 2016-08-17 at 12:19.

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,832
    Thanks
    136
    Thanked 484 Times in 461 Posts
    Hi Howard

    The number of months to depreciate is just..
    =min(f2-g2,12)

    see attached file.

    zeddy
    Attached Files Attached Files

  3. The Following User Says Thank You to zeddy For This Useful Post:

    HowardC (2016-08-17)

  4. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    125
    Thanked 5 Times in 5 Posts
    Thanks for the help Zeddy

  5. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,639
    Thanks
    115
    Thanked 651 Times in 593 Posts
    Howard,

    From my accounting days, here is how I would set it up (not including the depreciated values).

    Howardq.png

    HTH,
    Maud
    Attached Files Attached Files

  6. The Following User Says Thank You to Maudibe For This Useful Post:

    HowardC (2016-08-18)

  7. #5
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,423
    Thanks
    125
    Thanked 5 Times in 5 Posts
    Thanks for your input Maud-much appreciated

Posting Permissions

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