Big_Mac_Index.xlsx

	A	B	C	D	E	F	G	H
1	Country	Currency	Price (Local Currency)	Big Mac Exchange Rate	Column D Formula	Exchange Rate	Over/Under Valued Calculation	Column G Formula
2	Argentina	ARS	5919.76			903.78
3	Australia	AUD	7.64			1.51
4	Brazil	BRL	22.76			5.38
5	Britain	GBP	4.66			0.79
6	Canada	CAD	7.56			1.37
7	Chile	CLP	4204.40			926.08
8	China	CNY	25.59			7.25
9	Colombia	COP	19809.72			4042.80
10	Czechia	CZK	106.63			23.03
11	Denmark	DKK	39.22			6.93
12	Euro area	EUR	5.64			0.93
13	Hong Kong SAR	HKD	22.96			7.81
14	Hungary	HUF	1431.07			366.94
15	India	INR	229.57			83.48
16	Indonesia	IDR	40233.45			16355.06
17	Israel	ILS	16.81			3.72
18	Japan	JPY	503.51			157.84
19	Kuwait	KWD	1.42			0.31
20	Malaysia	MYR	13.47			4.71
21	Mexico	MXN	92.97			18.23
22	New Zealand	NZD	8.13			1.63
23	Norway	NOK	71.83			10.61
24	Oman	OMR	1.51			0.38
25	Peru	PEN	17.20			3.78
26	Philippines	PHP	167.94			58.72
27	Poland	PLN	21.19			4.02
28	Qatar	QAR	14.01			3.64
29	Romania	RON	16.34			4.63
30	Saudi Arabia	SAR	18.97			3.75
31	Singapore	SGD	6.71			1.35
32	South Africa	ZAR	52.47			18.41
33	South Korea	KRW	5508.71			1380.63
34	Sri Lanka	LKR	1729.13			303.89
35	Sweden	SEK	58.74			10.49
36	Switzerland	CHF	7.18			0.89
37	Taiwan	TWD	73.83			32.38
38	Thailand	THB	139.13			36.71
39	Turkey	TRY	152.52			32.59
40	Ukraine	UAH	116.18			40.48
41	United Arab Emirates	AED	17.98			3.67
42	United States	USD	5.69			1.00
43	Uruguay	UYU	277.64			39.27
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