| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate exit at x% return, multiple investors
I need to calculate the payment required to return x% IRR to a schedule of
investors. We have an irregular series of cash flows, so it's easy to use XIRR and find the final payment value using Solver. How do I calculate the final payment, referencing my x% return, for all investors without running solver repeatedly? I wrote a formula that does this, but it's sheer brute force. Is there a trick to handle this more easily in the future? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate Return on Investment in Excel | Excel Worksheet Functions | |||
| how do you calculate annualised return? | Excel Worksheet Functions | |||
| Function to calculate and return form another sheet | Excel Discussion (Misc queries) | |||
| Which function to calculate a 401k rate of return? | Excel Worksheet Functions | |||
| Calculate the return of irregular deposits | Excel Worksheet Functions | |||
Hybrid Mode
