spoofhopper
New Member
- Joined
- Jan 25, 2012
- Messages
- 3
Hi there,
I'm trying to calculate IRR on some groupings of investments. I'm assuming a pivot table is the best way to do this, but if there's a way to do it with formulas/tables that's fine too. I can't figure out how to use a Calculated Field since I don't have a rate or cash flows.
Any thoughts are appreciated! I'm using Excel 2013 on Windows 8.1, and have ASAP Utilities installed if that helps.
Sample workbook is here: https://drive.google.com/open?id=0BxDvRMtaB52ETldrWnROblJ1TTQ&authuser=0
Trying to fill in the Yellow cells on the 'Pivot' tab.
I'm trying to calculate IRR on some groupings of investments. I'm assuming a pivot table is the best way to do this, but if there's a way to do it with formulas/tables that's fine too. I can't figure out how to use a Calculated Field since I don't have a rate or cash flows.
Any thoughts are appreciated! I'm using Excel 2013 on Windows 8.1, and have ASAP Utilities installed if that helps.
Sample workbook is here: https://drive.google.com/open?id=0BxDvRMtaB52ETldrWnROblJ1TTQ&authuser=0
Trying to fill in the Yellow cells on the 'Pivot' tab.
