#### Pauls123

##### Board Regular
Hi,

Not really sure where to start with this one. I want to create a spreadsheet (excel 2010) in relation to betting on horse races. Say I start with a bank of \$100. I want to work out if I had a strike rate of say 40% (winner 4 out of every 10 bets) how much the balance would be after say 100 bets. If I was to start with betting 2% of the bank balance each bet.

The average dividend would then affect this as I would need an average dividend of at least \$2.5 to break square. And then of course my balance would still be \$100. So then I would need a forecast percentage profit on turnover type figure.

So the columns I would want to use (to put in varying amounts) would be Starting Balance; Estimated Strike Rate; Bets per Year (I used 100 for an example); % Bet of Balance Each Bet; Estimate Turnover; Estimate Profit on Turnover.

Or maybe this is getting all to confusing, any suggestions would be welcome,

Regards, Paul

### Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Replies
0
Views
420
Replies
2
Views
226
Replies
2
Views
638
Replies
14
Views
280
Replies
2
Views
206

1,195,673
Messages
6,011,088
Members
441,582
Latest member
Topkapi

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back