search for: 1bis

...ference 1: How to manage irregular intervals - http://www.geocities.com/accessreddy/excel/xirr.htm #~ Reference 2: How to calculate IRR manually - http://www.s-anand.net/Calculating_IRR_manually.html #~ #~ Step 1: enter zeroes (0) against dates that do not have any cash outflow or inflows. #~ Step 1bis: calculate IRR for these cash flow values using normal IRR function. #~ Step 1tris: or using an iteractive approach as bisection method to find the NPV zeroes. #~ Step 2: multiply this value of IRR by 365 to get annual IRR (since, these are daily cash flows). #~ Step 3: refine using the formula =(...