Jump to content

Applying Custom Functions In TERR

Charles Price

Recommended Posts

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.

Link to comment
Share on other sites

  • 2 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...