I recently had a post removed because nothing significantly bad happened to you as a result . I don ' t k o what to believe anymore . <| sep |> Wow , I know this sounds like boot licking but this is amazing , thank you and it ' s greatly appreciated . I ' m going to be spending a while pouring over this . <| sep |> I might not be understanding what you ' re asking , but you should be able to basically do this pretty simply using Excel ' s XIRR function and tracking the dates on which you deposit withdraw cash . Take a look at a returns analysis example on Macabacus . When I ' ve built LBO models this is generally how we model returns to sponsors in the case of leveraged recaps it ' s functionally the same thing but the asset you ' re valuing putting cash into withdrawing from isn ' t a company it ' s a portfolio of securities .