Showing results:
Displaying 1 - 1 of 1
Calculating IRR of terminal value cash flow
How do you appropriately calculate the IRR for the Terminal Value Cash Flow in excel? Example: 3/30/16 - Year 1 CF: -50 3/30/17 - Year 2 CF: 120 3/30/18 - Year 3 CF: 150 Terminal Year CF: 275 XIRR(Values, Dates) is standard formula, but what "date" do we realize for terminal Year? If we use 3/30/18...
or Want to Sign up with your social account?