Planning

Get Involved. Join the Conversation.

Topic

    Vish Thelapurath
    How to increase the maximum number of years allowed in...
    Topic posted May 23, 2018 by Vish ThelapurathGreen Ribbon: 100+ Points, tagged Financial Planning, Planning 
    91 Views, 8 Comments
    Title:
    How to increase the maximum number of years allowed in Enterprise Planning cloud application?
    Summary:
    Maximum number of years allowed in Year dimension is only 60. How to increase to 100 years?
    Content:

    We have a business need to capture 1200 months of cash flow for certain products. Enterprise Planning allows only 60 years. How an I increase this threshold from 60 to 100 years?

    Thanks,

    Vish.

     

    Image:

    Comment

     

    • Muthu Ranganathan

      Please have a SR logged with detailed justification of why you need more than 60 years and also the use case for such an application. 

    • Vish Thelapurath

      Thank you for your response.

      SR 3-17551898161 has been logged.

      Use Case:

      We calculate the value of our business by calculating the net present value of our investment and a series of future payments based on a discount rate.

      Some of our products generate cash flows or future payments for a period of 1200 months or 100 years.

      In order to build the net present value calculation model in enterprise planning, we would like to capture the cash flow for 100 years in the application.

      is it possible to have 100 years in the Year dimension? current maximum is 60 years. can this maximum threshold be extended to 100 years?

      please let us know.

      Thanks,

      Vish.

       

    • Muthu Ranganathan

      Vish, Have you explored Strategic Modeling for this. This is a typical use case for Strategic Modeling and that will have longer range plan, including getting a discounted cash flow. 

    • Vish Thelapurath

      We are looking into that option also.

      Thanks,

      Vish.

       

    • Muthu Ranganathan

      Yes, for such long range planning and scenario modeling, its best to do it with Strategic Modeling as it provides for DCF also.

    • Vish Thelapurath

      We tried creating a model in Strategic Modelling.

      The year goes up to 2050. see screen shot attached.

      is there a way to select more years when creating a model?

      Thanks,

      Vish.

    • Muthu Ranganathan

      We are going to have more years in there soon, but you can explore the modeling/functional fit and assume that 100 years will be available in short future

       

    • Vish Thelapurath

      Thank you for the clarification.

      is it possible to know how soon 100 years will be available?

      will it be available by August of this year? or is it beyond that?

      could you please provide a general time frame for the update release.

      Thanks,

      Vish.