IBM Apptio

IBM Apptio

 View Only
  • 1.  Double Declining Balance Depreciation Calculations

    Posted Wed October 18, 2017 04:57 PM

    Most of our assets use the Double Declining Balance method of calculating depreciation.  We're seeing a discrepancy in the way ITP applies that method versus what we are accustomed to.  The difference we're seeing is how often monthly depreciation is recalculated.  ITP appears to be recalculating the monthly depreciation amount on a monthly basis which results in a decrease in the monthly depreciation each month.  We believe it is common to do the calculation on an annual basis and keep monthly depreciation flat for consecutive 12 month periods. 

     

    Before raising this as an issue and asking for changes to the calculation, I wanted to get supporting (or contradicting) opinions from the community.   Are you using this depreciation method for your assets and is the monthly recalculation of the depreciation amount consistent with your accounting systems or would you rather see it changed (or be given an option to have the monthly depreciation amount change every 12 months) ?





    #ApptioPlanning(ITP/ITFMF)


  • 2.  Re: Double Declining Balance Depreciation Calculations

    Posted Tue November 14, 2017 05:06 PM

    Hey @George McElfresh is the annual depreciation amount calculated based on the asset's book value for the fiscal year or is the 12 months based on the in-service date? 


    #ApptioPlanning(ITP/ITFMF)


  • 3.  Re: Double Declining Balance Depreciation Calculations

    Posted Wed November 15, 2017 01:08 PM

    The depreciation should reset at the beginning of each fiscal year.  Sorry, my example might have suggested otherwise.  Please let me know if you have any questions or would like me to review any examples.


    #ApptioPlanning(ITP/ITFMF)


  • 4.  Re: Double Declining Balance Depreciation Calculations

    Posted Wed November 15, 2017 01:40 PM

    Does the following example accurately describe annual double declining? 

     

    Asset Amount: $1,000,000
    Useful Life: 3 years (36 months)
    In-Service Date: 1/1/17
    Purchase Date: 1/1/17

     

    Annual Double Declining:

    Year

    Book Value FY Start

    Depreciation Rate

    Depreciation Expense (FY)

    Depreciation Expense (Month)

    Accumulated Depreciation

    Book Value Year End

    2017

    $1,000,000

    66.67%

    $666,666.67

    $55,555.56

    $666,666.67

    $333,333.33

    2018

    $333,333.33

    66.67%

    $222,222.22

    $18,518.52

    $888,888.89

    $111,111.11

    2019

    $111,111.11

    66.67%

    $74,074.07

    $6,172.84

    $962,962.96

    $37,037.04

     


    #ApptioPlanning(ITP/ITFMF)


  • 5.  Re: Double Declining Balance Depreciation Calculations

    Posted Wed November 15, 2017 01:47 PM

    For an asset that goes into service on January 1 yes.  If it goes into service anywhere other than the first month of the fiscal year then things would look different...


    #ApptioPlanning(ITP/ITFMF)


  • 6.  Re: Double Declining Balance Depreciation Calculations

    Posted Wed November 15, 2017 02:16 PM

    If it went into service in Feb 2017, would the Accumulated Depreciation for 2017 be $611,111.16 ($55,555.56 * 11 months)? That would make the Book Value for FY18 start at $388,888.84.


    #ApptioPlanning(ITP/ITFMF)


  • 7.  Re: Double Declining Balance Depreciation Calculations

    Posted Wed November 15, 2017 02:24 PM

    Yes and then you'd see a small amount of depreciation trickle over into 2020.  Looks like you've got it !


    #ApptioPlanning(ITP/ITFMF)


  • 8.  Re: Double Declining Balance Depreciation Calculations

    Posted Thu November 16, 2017 01:23 PM

    Thanks for the feedback! We'll consider this idea for a future release!

     

    I created an Idea for Annual Double Declining Depreciation Method to track its progress.


    #ApptioPlanning(ITP/ITFMF)