NPV without an outflow

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?

Accepted answers

ChrisAHeathcote

@Roelofg

It is possible to calculate the NPV as per your table.

NPV can work with with data whose source is either dimensioned by time period or a transactions list.

I will outline both approaches;

With Time

Cashflows are laid out using time dimension.

Without Time

Time dimension has been removed and a transaction list added.

This is the result;

The difference in values is due to the time calculation taking the full model calander and discounting over the full 3 years. The no time calculation only calculates for the values and dates presented and will stop discounting after the final transaction.

Misbah

@Roelofg

In Our April Group Event we discussed how NPV can be calculated without Anaplan timescale. Here is the link.

https://community.anaplan.com/t5/Modelers-Forum-India/Recording-of-Group-Event-13-04-2021/m-p/105085

Hope this helps

Misbah

All comments

LipChean_Soh

Hi @Roelofg

I would suggest that you come up with a mock up in excel, and share the screen shot here.

Thanks,

LipChean

Roelofg



		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

See below

LipChean_Soh

Hi @Roelofg

Have you given the NPV formula a try?

https://help.anaplan.com/c504a4f5-5513-42e3-91cf-b34d873d18f3-NPV

Thanks,

LipChean

Roelofg

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

LipChean_Soh

Hi @Roelofg

Looking back at your example, how did you arrive at 16,422.3

When i tried to do a mockup in Excel, i arrived at 11,560.3

Please note that i moved 2000 to Feb21 to be added with the 1000 from Feb21.

Thanks,

LipChean

ChrisAHeathcote

@Roelofg

It is possible to calculate the NPV as per your table.

NPV can work with with data whose source is either dimensioned by time period or a transactions list.

I will outline both approaches;

With Time

Cashflows are laid out using time dimension.

Without Time

Time dimension has been removed and a transaction list added.

This is the result;

Misbah

@Roelofg

In Our April Group Event we discussed how NPV can be calculated without Anaplan timescale. Here is the link.

https://community.anaplan.com/t5/Modelers-Forum-India/Recording-of-Group-Event-13-04-2021/m-p/105085

Hope this helps

Misbah

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…