Depreciation Using Profile Formula

Highlighted
Previous Contributor

Depreciation Using Profile Formula

Suppose materials are purchased in January, and then in another Line Item, I would like the materials to be depreciated over 3 months (spread that purchase value out over 3 months)?  Which formula should be used?

Message 1 of 7
6 REPLIES 6
Previous Contributor

RE: Depreciation Using Profile Formula

You will want to use the Profile function: learn more at https://community.anaplan.com/anapedia/calculation-functions/profile.
Message 2 of 7
Occasional Contributor

Re: RE: Depreciation Using Profile Formula

The link above is broken. This is the link for the "Profile" function:

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/PROFILE.html

 

Message 3 of 7
Previous Contributor

RE: Depreciation Using Profile Formula

[quote=Gina Magdaleno]You will want to use the Profile function: learn more at https://community.anaplan.com/anapedia/calculation-functions/profile.[/quote] Hi, I have to use this function for defferring some of expense over period of five quarters. Can you please provide a simple example on how to use this Profile() function? Regards
Message 4 of 7
Previous Contributor

RE: Depreciation Using Profile Formula

Hi Ankesh, If you are going to be spreading the expenses evenly over 5 quarters, you could use: SPREAD(expense line item,5) If you have a custom spread, then the attached screenshots will show you an example of using PROFILE. In this example, I first created two lists:
  • Timing %s
  • Timing Profiles
I then created two modules:
  • Timings - Qtrs
  • Profile - Qtrs
The 'Timings - Qtrs' module has the two lists that I created. This allows you to add percentage spreads over periods. And you can create various profiles. The 'Profile - Qtrs' module has 4 line items with varying dimensionality. [list=1]
  • Revenue Orders - values are entered by month and product.
  • Timing % - assigns the timing %s for each product based on the Profile selected (next line item).
  • Profile - assigns the profile to each product.
  • Revenue - spreads the Revenue Orders based on the Profile assigned for each Product. Let me know if you still have any questions!
  • Message 5 of 7
    Previous Contributor

    RE: Depreciation Using Profile Formula

    Hey John! Thanks a lot! This is much helpful. I finally got my deferred expenses ready. Regards
    Message 6 of 7
    Previous Contributor

    RE: Depreciation Using Profile Formula

    What do you mean by "The 'Timings - Qtrs' module has the two lists that I created. This allows you to add percentage spreads over periods. And you can create various profiles."? Also, what screenshot are you referring to in your post?
    Message 7 of 7