-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
internal rate of return
-
X
Can anybody tell me why this implementation of the secant method does not work?
I want to implement the secant method in order to find the internal rate of return of an investment. Public Function irr(payment As Double, endValue As Double, T As Integer) As Double Dim x0 As Double Dim x1 As Double Dim f0 As Double Dim f1 As Double Dim temp As...- xfu14
- Thread
- internal rate of return secant method vba & code
- Replies: 4
- Forum: Excel Questions
-
S
Need help with a slightly modified Internal Rate of Return calculation
I need to find a "baseline" rate of return calculation that finds the baseline rate of return, given annual deviations from the baseline rate and the CAGR for the entire duration. This could be either a formula or a VBA macro. Here's an example. CAGR 10% Year#) Beginning...- sandeep6699
- Thread
- internal rate of return successive approximation
- Replies: 1
- Forum: Excel Questions
-
S
Internal Rate of Return
Consider the cash flows seen here. The internal rate of return on the cashflows (rounded to the nearest 1%) is ....... Date Cash Flow 4/10/2011 -1000 5/1/2012 500 1/1/2014 600 4/10/2015 700- suhantm
- Thread
- cash flow internal rate of return
- Replies: 2
- Forum: Excel Questions
