Price of CGTV+Netflix by country

	A	B	C	D	E	F	G	H
1	The calculations below are meant to compare (across countries) the total discounted price of the new CGTV device when purchasing with 6 months of Netflix. For those who are unaware of this offer: in the US, you can pay $90 for the device with 6 months of standard Netflix ($84 value), which is applied to your account as $84 credit if you're already subscribed. Feel free to comment if you find mistakes or inaccuracies in any particular cell and I will update.
2
3
4	Prices in LOCAL currency
5			US	Canada	France	UK	Australia	Japan
6	standard	the price for just the chromecast device	50	70	70	60	99	7600
7	bundle	bundled price (with 6m netflix)	90	120	110	90	140	11200
8	bundle - std	the bundled cost of 6 months of netflix	40	50	40	30	41	3600
9	netflix credit	amount that is credit to your netflix account (price of 6 months standard plan)	84	90	72	54	96	7920
10	bundle - credit	discounted price if we don't factor taxes	6	30	38	36	44	3280
11	bundle+tax - credit	discounted price after tax	12.3	45.6	38	36	44	4400
12	bundle savings (std+tax - bundle+tax-credit)	amount you save by purchasing the bundle	41.2	33.5	32	24	55	3960
13	tax rate constant	average sales tax rate in the country plus 1	1.07	1.13	1	1	1	1.1
14
15	Prices converted to USD
16			US	Canada	France	UK	Australia	Japan
17	standard	the price for just the chromecast device	50	55	85	82	76	74
18	bundle	bundled price (with 6m netflix)	90	95	133	123	108	109
19	bundle - std	the bundled cost of 6 months of netflix	40	40	48	41	32	35
20	netflix credit	amount that is credit to your netflix account (price of 6 months standard plan)	84	71	87	74	74	77
21	bundle - credit	discounted price if we don't factor taxes	6	24	46	49	34	32
22	bundle+tax - credit	discounted price after tax	12	36	46	49	34	43
23	bundle savings (std+tax - bundle+tax-credit)	amount you save by purchasing the bundle	41	26	39	33	42	38
24	tax rate constant	average sales tax rate in the country plus 1	1.07	1.13	1	1	1	1.1
25	USD exchange rate	local to USD exchange rate	1	0.79	1.21	1.37	0.77	0.0097
26
27	Edit: I have been told that sales tax is already included in prices in UK, France/EU, and Australia, so changed the tax rate constant to 1.
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