£20-FREE BET 2nd-3rd-Place-Refund-Lock-In-Profit-Spreadsheet-
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLQRSTUVWXYZ
1
2
Horse Racing - 2nd Place Refund Lock-In Profit Calculator
3
Instruction
4
1. Enter Back Stake £ / Back Odds
5
Back Stake
£20.00Back Odds5.00
Refund Value
£16.00
2. Enter Refund Value - If Free Bet 80% & If Cash 100% of Back Stake
6
3. Enter Lay Odds for Both Win & Place
7
4. Enter Exchange (Lay) Commission
8
Lay Stake
5. Enter Your Profit Preference;
9
Win£15.27Win Lay Odds5.50
Lay Commission
0.00%£4.73
- "S" if You Want Same Profit for all outcomes
10
Place£4.80
Place Lay Odds
1.904.727272727
- "F" if You Want Focus Profit When Horse Placed 1st, 2nd or 3rd but Breakeven When Unplaced
11
So you need to enter all the Cream Coloured Cell
12
Then the sheet will calculate and show;
13
*Profit Preference: Enter "S" for Same Profit in All Outcomes or "F" for Focus Profit On 1st - 3rd but 0 when Unplaced
Required Lay Stakes for Win & Lay Respectively
14
*Profit Preference
Your Guaranteed Profits for 3 Different Scenario of Horse Final Result
15
f1st
2nd or 3rd
Unplaced
16
£6.95£6.95£0.07
17
Important Note
18
This sheet works both "2nd Place Refund" & "2nd & 3rd Places Refund"
19
Refund£16.00
However,
20
Bookie£80.00-£20.00-£20.00
- for the "2nd Place Refund" it ONLY works when Exchange' Pays 2 Or Less Places.
21
Win Lay-£68.73£15.27£15.27
- for the "2nd & 3rd Place Refund" it ONLY works when Exchange' Pays 3 Or Less Places.
22
Place Lay
-£4.32-£4.32£4.80
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...