Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Calculating IRRs

5825 2
cancel
Showing results for 
Search instead for 
Did you mean: 
ATG
6 - Interface Innovator
6 - Interface Innovator

Hi - I have a table with a list of cash flows, dates. These are linked to another table which contains individual deals. I want to calculate, for each deal, the IRR - in Excel this is using the IRR function which takes a list of dates and a list of cash flows and returns a single IRR number.

Can this be done in Airtable? Rollups seem to only allow calculations involving one linked field only - whereas I need two: both date and cashflow. Also, there doesn’t seem to be an IRR function. The calculation is relatively straight forward, can I code my own function to support this?

Secondary question - right now I have to manually for each date/cash flow record link it to a given deal. Is there a way to link all cash flows where dealID equals x?

15 Replies 15
ATG
6 - Interface Innovator
6 - Interface Innovator

I posted a short script awhile back for it

do you have experience with their extension? any thoughts?

@Hannah_Wiginton knows all about it! :slightly_smiling_face:

Hey @JonahM

The IRR automation is in our On2Air Actions app. You can start a free trial to test it out.

We can also do a demo and free setup for you if you prefer that route.

Thank you @ScottWorld !

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable
JonahM
6 - Interface Innovator
6 - Interface Innovator

thanks @Hannah_Wiginton @ScottWorld @ATG ! will take a look at the extension as well as the script
thanks!

This helped me a lot!
Thanks, I thought you should've had some recognition