General Betting
There is currently 1 person viewing this thread.
i need help calculating a return on excel.
I use PMT function when the return is straight line but this isn't.
Example
Invest 100
Period 1 get 10 of my capital back and 10 additional return
Period 2 get 5 capital back and 16 additional return
etc until no capital left.
Any ideas?
I use PMT function when the return is straight line but this isn't.
Example
Invest 100
Period 1 get 10 of my capital back and 10 additional return
Period 2 get 5 capital back and 16 additional return
etc until no capital left.
Any ideas?
sort by:
Show
per page
Replies: 3
|
By:
used irr but don't know if that is right.
|
|
By:
IRR may be what you want. Depends what number you want to compare it against. IRR is the internal rate of return (i.e. omits interest rate /pv effect), thus cashflows of -100k +25k / +25k /+25k/+25k would give you a IRR of zero, whereas if that were a 'real' investment it would have an implied negative interest rate as you are laying out 100k UF and getting back 4x 25k UF. No capital loss but a loss of the risk free rate of interst
|
|
By:
thanks structured bet.
|