IRR Modeling...
Posted: Wed Feb 10, 2010 1:22 am
Hi, Everyone,
I am trying to build a rolling IRR model and wonder if anyone has done this before? There is not an IRR bif like in CP, or a fx like in Excel, within TM1. To circumvent that, I've created my TM1 cube with the necessary fields, am calculating IRR in a slice in Perspectives, and using DBSW to return the value to the IRR% row within the TM1 model. That works, but it doesn't set off the chain reaction of calculations I had hoped.
In short, there are collections, IRR%, open basis, revenue, amortization, and end basis. When collections change, it should change end basis, which in turn changes IRR% for the next period and this sets off a chain reaction until the collections life cycle is over.
I know this is a shot in the dark, but I thought I'd give it a shot.
Cheers,
Christian
I am trying to build a rolling IRR model and wonder if anyone has done this before? There is not an IRR bif like in CP, or a fx like in Excel, within TM1. To circumvent that, I've created my TM1 cube with the necessary fields, am calculating IRR in a slice in Perspectives, and using DBSW to return the value to the IRR% row within the TM1 model. That works, but it doesn't set off the chain reaction of calculations I had hoped.
In short, there are collections, IRR%, open basis, revenue, amortization, and end basis. When collections change, it should change end basis, which in turn changes IRR% for the next period and this sets off a chain reaction until the collections life cycle is over.
I know this is a shot in the dark, but I thought I'd give it a shot.
Cheers,
Christian