ABCDEFGHIJKLMNOPQRSTUVWX
1
2
BMW tire/wheel warranty calculations
3
4
INSTRUCTIONS
5
1. Make a copy of this spreadsheet for your own use (you will not be able to edit this sheet). "File --> Make a copy..." You will need to log in to your Google account to do this. Alternatively, you can choose to download an Excel formatted copy of this, but you will lose the graph below.
6
2. Enter your own values for any cell marked yellow (these initial prices are based on a 5 year warranty for a 2011 X3 28i, with tires being replaced from Costco). Read Notes column for tips.
7
3. Evaluate bold sections to help make a decision on whether the tire/wheel warranty works for you.
8
Note: This analysis assumes that you won't need to replace your wheel at any point in time.
9
10
INPUTS
11
Notes:
12
Tire cost$210.99The price for a new tire
13
Installation/disposal$15Installation and disposal fees for tire ($15 is how much Costco charges if you purchase the tire from them)
14
Tax6.25%Tax rate
15
Total per tire$240.11
16
17
Tire / wheel hazard$1,347.30The total price being offered for the tire/wheel hazard protection
18
Per tire deductible$50Deductible per tire (technically, it's per incident, but I'm assuming I won't have multiple flats at once)
19
Years5Years of protection
20
21
22
OUTPUT
23
Breakeven tires7.09This is how many tires you'd need to replace for this to be a breakeven proposition
24
Tires / year1.42This is how many tires you'd have to replace each year
25
26
Analysis of how much money you make/lose, depending on how many flats you have:
27
28
Number of flatsSavings
29
0-$1,347
30
1-$1,157
31
2-$967
32
3-$777
33
4-$587
34
5-$397
35
6-$207
36
7-$16
37
8$174
38
9$364
39
10$554
40
11$744
41
12$934
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