https://community.betfair.com/general_betting/go/thread/view/94082/23468658/excel-helpi need help calculating a return on excel.I use PMT function when the return is straight line but this isn't.ExampleInvest 100Period 1 get 10 of my capital back and 10 additional returnPeriod 2 get 5 capital back and 16 additional returnetc until nohttps://community.betfair.com/general_betting/go/thread/view/94082/23468658/excel-help?post_id=419141654#419141654thanks structured bet.Thu, 12 Nov 2009 11:46:10 -0600https://community.betfair.com/general_betting/go/thread/view/94082/23468658/excel-help?post_id=419141474#419141474IRR 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 wereWed, 11 Nov 2009 13:34:43 -0600https://community.betfair.com/general_betting/go/thread/view/94082/23468658/excel-help?post_id=419141470#419141470used irr but don't know if that is right.Wed, 11 Nov 2009 12:10:47 -0600https://community.betfair.com/general_betting/go/thread/view/94082/23468658/excel-help?post_id=419141466#419141466i need help calculating a return on excel.I use PMT function when the return is straight line but this isn't.ExampleInvest 100Period 1 get 10 of my capital back and 10 additional returnPeriod 2 get 5 capital back and 16 additional returnetc until noWed, 11 Nov 2009 11:13:37 -0600