Declining balance depreciation method

Options
KokiS
KokiS Member, ALL USERS Posts: 5 New Contributor

Hi, I want to calculate depreciation of assets  using declining balance depreciation method on Anaplan.

I went through Anapedia's financial function pages to find function like Excel's VDB, but couldn't find any function applicable for the method.

 

Is there any function that is available for declining balance depreciation method, or is there any other best practice for the method on Anaplan?

 

Best,

Comments

  • KokiS
    KokiS Member, ALL USERS Posts: 5 New Contributor

    Hi Maarten

     

    Thanks for your quick reply.

    I'll check PREVIOUS() function you mentioned.

     

    Best,

  • KokiS
    KokiS Member, ALL USERS Posts: 5 New Contributor

    Hi LipChean

     

    Thanks for your reply.

    I got some solutions that might work for my problem here.

    So I will try if those solutions work for me. And if they doesn't work, will post further information in detail as you described.

     

    thanks,

  • KokiS
    KokiS Member, ALL USERS Posts: 5 New Contributor

    Hi Naveed

     

    Thanks for your information.

    It helped me a lot.

    currentry l'm trying to apply the method to my model, and might ask some question again.

     

    Thanks,

  • KokiS
    KokiS Member, ALL USERS Posts: 5 New Contributor

    Hi Misbah

     

    Thanks for detailed information.

    l'm trying to apply the method to my model. if the problem is solve, i will let you know.

     

    Thanks,