Personal travel budget calculator
Calculations below demonstrate the £ value of your Personal Travel Budget (PTB) (Column G)
Calculations are based on a distance measurement (miles) from home to school/college (using Google Maps shortest driving distance) (Column A)
4 journeys per day (outward journey: home to school/college to home and inward journey: home to school/college to home) (Column B)
190 days per academic year (5 days per week x 38 weeks per academic year) (Column C)
Mileage rate: 45 pence per mile for all miles up to 10,000 per academic year (number of miles shown in Column E)
Mileage rate: 25 pence per mile for all miles in excess of 10,000 per academic year (number of miles shown in Column F)
Please note: should your child's attendance vary from the example used (190 days), an adjustment is required to the calculations below.
,
| Column A |
Column B |
Column C |
Column D |
Column E |
Column F |
Column G |
| Distance (miles) from home address to school/college |
Number of journeys per day |
Number of school days per academic year |
Total miles (per academic year) |
Miles (up to 10,000 miles) |
Miles (in excess of 10,000 miles) |
Total PTB (£) |
| 1 |
4 |
190 |
760 |
760 |
0 |
£342.00 |
| 2 |
4 |
190 |
1520 |
1520 |
0 |
£684.00 |
| 3 |
4 |
190 |
2280 |
2280 |
0 |
£1,026.00 |
| 4 |
4 |
190 |
3040 |
3040 |
0 |
£1,368.00 |
| 5 |
4 |
190 |
3800 |
3800 |
0 |
£1,710.00 |
| 6 |
4 |
190 |
4560 |
4560 |
0 |
£2,052.00 |
| 7 |
4 |
190 |
5320 |
5320 |
0 |
£2,394.00 |
| 8 |
4 |
190 |
6080 |
6080 |
0 |
£2,736.00 |
| 9 |
4 |
190 |
6840 |
6840 |
0 |
£3,078.00 |
| 10 |
4 |
190 |
7600 |
7600 |
0 |
£3,420.00 |
| 11 |
4 |
190 |
8360 |
8360 |
0 |
£3,762.00 |
| 12 |
4 |
190 |
9120 |
9120 |
0 |
£4,104.00 |
| 13 |
4 |
190 |
9880 |
9880 |
0 |
£4,446.00 |
| 14 |
4 |
190 |
10,640 |
10,000 |
640 |
£4,660.00 |
| 15 |
4 |
190 |
11,400 |
10,000 |
1400 |
£4,850.00 |
| 16 |
4 |
190 |
12,160 |
10,000 |
2160 |
£5,040.00 |
| 17 |
4 |
190 |
12,920 |
10,000 |
2920 |
£5,230.00 |
| 18 |
4 |
190 |
13,680 |
10,000 |
3680 |
£5,420.00 |
| 19 |
4 |
190 |
14,440 |
10,000 |
4440 |
£5,610.00 |
| 20 |
4 |
190 |
15,200 |
10,000 |
5200 |
£5,800.00 |
| 21 |
4 |
190 |
15,960 |
10,000 |
5960 |
£5,990.00 |
| 22 |
4 |
190 |
16,720 |
10,000 |
6720 |
£6,180.00 |
| 23 |
4 |
190 |
17,480 |
10,000 |
7480 |
£6,370.00 |
| 24 |
4 |
190 |
18,240 |
10,000 |
8240 |
£6,560.00 |
| 25 |
4 |
190 |
19,000 |
10,000 |
9000 |
£6,750.00 |
| 26 |
4 |
190 |
19,760 |
10,000 |
9760 |
£6,940.00 |
| 27 |
4 |
190 |
20,520 |
10,000 |
10,520 |
£7,130.00 |
| 28 |
4 |
190 |
21,280 |
10,000 |
11,280 |
£7,320.00 |
| 29 |
4 |
190 |
22,040 |
10,000 |
12,040 |
£7,510.00 |
| 30 |
4 |
190 |
22,800 |
10,000 |
12,800 |
£7,700.00 |
,