Displaying 1 result from an estimated 1 matches for "calculating_irr_manu".
2008 May 13
0
xirr...
...ou can find the code at
http://albertosantini.blogspot.com/2008/01/xirr.html
#~ Title: XIRR Excel function simulation
#~
#~ Reference 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...