Applying Custom Functions In TERR

[Charles Price]

I am hoping to apply two custom functions to a set of data in TERR. The functions are calculating NPV and IRR.

I have a data set that I made a dumbed down version of that is attached.

Basically I have a string of identifying numbers (PROPNUM) all the same length. For each propnum there are a series of cash flows in the columns, with corresponding months.

Month 1-3 is the initial capital outlay in negative numbers, followed by positive cash flows up to month 6.

I have the functions built but I am having trouble getting them to apply to the subsetted (by propnum) cash flow columns.

I hope to get a single value for each function (NPV,IRR) for each cash flow column by propnum.

I hope this makes sense, please see attached excel sheet.

[Jagrata Minardi]

I have added a Wiki page on NPV/IRR calculations; this may be helpful.