How to calculate Present Values of a set of Cashflows

[jlee_RGA]

I got a set of monthly cashflows for the future time period (say for 100 years) and would like to calculate the present value of it.

The following is the approach that I used.

1. calculate the discount factor for each future time period.

2. multiply the discount factor from (1) to the cashflows at each time t

3. Use the multi-row formula to add them up

   =>>> but seems that this could only add t and t+1 (2 rows together).

Are there any method that I could add all of the following cashflows at the following time together?

t + (t+1) + (t+2) + (t+3)…..(t+n) 

[DataNath]

Hey @jlee_RGA, if I'm understanding this right then you should be able to use the Multi-Row Formula, though in this instance there are easier ways. You could either use the Running Total tool, or, if you're not fussed about seeing a running sum and just want the overall sum as a single cell, you could use a Summarize tool > select the field you're interested in > use 'Sum' in the configuration drop down.

If this isn't what you're looking for then please can you provide a bit more information and preferably some data, even if it's obfuscated or mocked up, just so we can get a better idea of the request and demonstrate the working method.

[grazitti_sapna]

@jlee_RGA , I assume you can create a record id for the records which you want to sum on the basis of some condition or group by column and then summarize them using summarize tool. Please let me know if it helped. Else you can provide the input and expected result and I can share the workflow on same.