I'd like to calculate the IRR of an investment and I'm using the following schema:

The red circle captures Investments with transactions and market values rolling up to each investment.  Each transacton captures the following details:

1. Transaction Date
2. Transaction Type

3. Units
4. Unit Price
5. Investment (Lookup)
6. Currency

I'd like to roll-up the IRR to a field on the Investment record.  Is there an application that doesnt' require APEX code that I can use for this?  I'm also open to suggestions that involve an Excel to Salesforce integration.

Thanks!

I'd like to calculate the IRR of an investment and I'm using the following schema:

The red circle captures Investments with transactions and market values rolling up to each investment.  Each transacton captures the following details:

1. Transaction Date
2. Transaction Type

3. Units
4. Unit Price
5. Investment (Lookup)
6. Currency

I'd like to roll-up the IRR to a field on the Investment record.  Is there an application that doesnt' require APEX code that I can use for this?  I'm also open to suggestions that involve an Excel to Salesforce integration.

Thanks!

Hello all,

Has anyone written code to calculate Internal Rate of Return using Apex?

Erik