General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
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?
Show More
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
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539