Forums

General Betting

There is currently 1 person viewing this thread.
irishlad
11 Nov 09 17:13
Joined:
Date Joined: 10 Oct 02
| Topic/replies: 329 | Blogger: irishlad's blog
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?

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
sort by:
Show
per page
Replies: 3
By:
irishlad
When: 11 Nov 09 18:10
used irr but don't know if that is right.
By:
structuredbet
When: 11 Nov 09 19:34
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:
irishlad
When: 12 Nov 09 17:46
thanks structured bet.
sort by:
Show
per page

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
‹ back to topics
www.betfair.com