About Roelofg

Roelofg · ‎06-25-2021

@Amaya Thank you for this.... I used the suggested above and sorted out the problem. The issue around NPV is also to account for when the payments is made in the beginning of the (monthly) period or at the end of the (monthly) period. To be quite honest i do not trust the NPV formula on this stage. It is easy to check it and that is to build an amortization schedule on the input and results of the NPV formula. The theory is that the balance must be 0 at the end of the period. But is does not. Thanks for the input.

Roelofg · ‎06-24-2021

Thanks for the work around. To throw a rock in the bush.. - Are we then saying that the financial functions such as the NPV is useless and should not be used.......

Roelofg · ‎06-24-2021

Great stuff.. Thank you. But what should the formula within Anaplan then be for the NPV?

Roelofg · ‎06-24-2021

See above, Thank you

Roelofg · ‎06-23-2021

Hi Guys I am running into a problem using the NPV calculation and a subsequent amortization calculation. Please see attached: I used the NPV formula to calculate the NPV of a 12 month variable cash flows. This is equal to the opening balance of a liability. 213,473) When i develop an amortization schedule including interest cost uisng the cash flow as the payment schedule, the end balance is not zero. I attached the results as well as the formula used.. I am not sure where i made the mistake? Thank you in advance

Roelofg · ‎06-21-2021

Hi LipChean_Soh I used it but is concerned about the following statement: NPV(d, c, [m, t]) where c : Number: Cash flow. Must have at least one negative and one positive value The cashflow does not have at least one negative. Does this have an impact on the answer? Roelof

Roelofg · ‎06-18-2021

See below

Roelofg · ‎06-18-2021

5% Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Monthly 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 Variable 500 500 End of Contract 2000 1000 1000 1000 1000 1000 1500 1000 1000 1000 1000 1000 1500 1000 3000 NPV $16,422.30

Roelofg · ‎06-18-2021

Good morning I am building a model consisting of future variable monthly cash outflows without any cash inflows. I need to calculate the NPV of that in order to convert that into a liability using the variable cash outflows as down payments.. The NPV formula require cash in and cash out. What are your suggestions?

Roelofg · ‎02-12-2020

Solution I created a second module surmise the results at an higher level. That allow for overrides at the highest level. Thank you all

Roelofg · ‎02-12-2020

Thank you Misbah. That is a solution and i tested it. You identified the key challenge. The underlying BU's transactions are rolled up but the adjustments need to happen on the consolidated level..... Would it help to develop a "interim module" at highest roll-up level? I will play around. Tx

Roelofg · ‎02-12-2020

Problem Statement: We develop a table setting out the results of transactions per code type across multiple categories (AP, AR, GL. etc). The results are calculated from detailed transactions . The customer process dictates that the amounts determined should allow for overrides to assign the amounts (all or a portion) to another area within the same code e.g. Code BO87 from AR to AP on the same code using an override column per category The underpinning formulas are: Requirement: The Override column must enable user inputs (overrides) and the results has be recalculated. The layout and results does not allow for manual input

Roelofg · ‎02-06-2020

Thanks all the P1 parent had selected access applied

Roelofg · ‎02-06-2020

@sandeep_bk Thank you for the response but it is not the cause.

Roelofg · ‎02-06-2020

I am busy with the level 2 training and hit a small hick-up I build a few modules referring to the P3 SKU list and worked fine until yesterday. This morning i get this message: But if i look at the list, i can see the list items There are no sub sets Where do you suggest that i have to look to resolve this challenge?

Roelofg · ‎08-21-2019

Thank you we will explore this.

Roelofg · ‎08-21-2019

Thank you, we will explore this.

Roelofg · ‎08-21-2019

we all understand the traditional way of building a hierarchy normally following a top down approach. We sit with a challenge requiring that the hierarchy needed to build up from the bottom up using a lowest level reference code. As per the attached picture. Each lowest level will have a specific code identifying where it is physical situated in the organisation. The code by implication implies the roll-up . See the attached picture. Problem Statement - When we have the codes, is there a way of importing the list and using that to develop the roll-up structure.In real life this can be very complex and high volumes. It can be done using a manual mapping but an automated manner will be much more elegant.

Roelofg · ‎05-15-2019

The thinking behind the detail stems from a need to assign responsibilities across cost center, regions, customers and products...

Roelofg · ‎05-15-2019

Thank you for all the contributions... a lot to absorb for me...

Roelofg · ‎05-14-2019

I developed an module displaying Rep, Customer and product. This required to enable planning to be done at Rep Level, Customer and Product levels. This will be used to input unit volumes per product / customer and Rep The easy way would be to have the total product list but each Rep are responsible for selected product and of course the customers has their preference as well. For that i developed a matrix depicting those relationships. Now the problem statement: Referencing to the picture below where i use the Rep, product and customer lists resulting in this comprehensive module. How can i limit the view in alignment with the requirements above

Roelofg · ‎05-10-2019

Thank you Alex

Roelofg · ‎05-09-2019

Aaahh..... The light when on with this statement : "So from the "ask", if the dimensions of the two modules are the same (apart from time) you can just directly reference them" This resolved my problem.. Thank you

Roelofg · ‎05-09-2019

Ok let try: The hierarchy is All, Region, Country, Cost Center. The reasons for using the hierarchy in both modules are: To allow planning at the lowest level To report on the monthly cost on all levels including the lowest level Another reason is that will allow for role allocation later one saying that, it appears that i am missing a level on the second model - oops Please explain "use a staging module".. Sorry for these as i am very new to Anaplan.

Roelofg · ‎05-09-2019

Roelofg · ‎05-09-2019

I spend the last 2 days trying to dynamically linked a specific date (specified by a user) I created a module to have visible the versions, country and initiatives (as my lists) and of course the line cost items and calculate the monthly charge per cost line item per costing type based on the elapse time between start and end dates One of the line items is start date (there is an End Date as well but i think it will be resolved as for the Start Date). The monthly cost items has to be linked to the dates This is part of an "input sheet" Then to assign the cost to time, I created another Module. This one will assign the monthly costs to time based on the versions, country and initiatives. The idea to determine the monthly cost per cost type and per cost item and the first occurrence on the time line has to correspond with the start date on the input sheet and of course the last occurrence the end date. Now – the problem statement: My plan was to use the start date and end date to assign start and end dates to determine start and end time periods. I have tried numerous options without success:

About Roelofg

Re: NPV and Amortisation

Re: NPV and Amortisation

Re: NPV and Amortisation

Re: NPV and Amortisation

NPV and Amortisation

Re: NPV without an outflow

Re: NPV without an outflow

Re: NPV without an outflow

NPV without an outflow

Re: Override function to SUM function

Re: Override function to SUM function

Override function to SUM function

Re: Level 2 Training Sprint2 P3 SKU - No line item...

Re: Level 2 Training Sprint2 P3 SKU - No line item...

Level 2 Training Sprint2 P3 SKU - No line items

Re: Hierarchical structures from a customer provid...

Re: Hierarchical structures from a customer provid...

Hierarchical structures from a customer provided l...

Re: Display selected item from a list for input an...

Re: Display selected item from a list for input an...

Display selected item from a list for input and ca...

Re: Linking a set date to a specific time range

Re: Linking a set date to a specific time range

Re: Linking a set date to a specific time range

Re: Linking a set date to a specific time range

Linking a set date to a specific time range

Re: Override function to SUM function

Re: Level 2 Training Sprint2 P3 SKU - No line item...

Re: Level 2 Training Sprint2 P3 SKU - No line item...

Re: Level 2 Training Sprint2 P3 SKU - No line item...

Re: Level 2 Training Sprint2 P3 SKU - No line item...

Re: Level 2 Training Sprint2 P3 SKU - No line item...

Re: Display selected item from a list for input an...

Re: Display selected item from a list for input an...

Re: Display selected item from a list for input an...