Spreadsheet: 816857d1675866741-help-with-match-index-formula-fx-rates-ans
Sheet: BBerg FCast

Contributor | Bloomberg Composite
As of
 | Spot | Q1 23 | Q2 23 | Q3 23 | Q4 23 | 2024 | 2025 | 2026 | 2027
[NAME] | EURCZK
Forecast |  | 24.1 | 24.3 | 24.4 | 24.3 | 24.6 | 23.9 | -- | --
Forward | 23.8 | 23.9 | 24.1 | 24.3 | 24.5 | 24.8 | 25 | 25.2 | 25.4
[NAME] | USDCZK
Forecast |  | 22.7 | 22.78 | 22.55 | 22.38 | 22.1 | 21.58 | 20.3 | --
Forward | 22.23 | 22.3 | 22.39 | 22.45 | 22.48 | 22.51 | 22.5 | 22.51 | 22.54
[NAME] | EURHUF
Forecast |  | 400 | 396 | 390 | 390 | 386 | 382 | -- | --
Forward | 394 | 401 | 413 | 423 | 432 | 455 | 472 | 490 | 509
[NAME] | USDHUF
Forecast |  | 375 | 371 | 370 | 364 | 359 | 368 | -- | --
Forward | 368 | 374 | 383 | 391 | 397 | 413 | 425 | 443 | 458
Polish Zloty | EURPLN
Forecast |  | 4.7 | 4.7 | 4.7 | 4.65 | 4.6 | 4.61 | -- | --
Forward | 4.76 | 4.79 | 4.84 | 4.89 | 4.95 | 5.13 | 5.31 | 5.49 | 5.67
Polish Zloty | USDPLN
Forecast |  | 4.43 | 4.36 | 4.26 | 4.23 | 4.18 | 4.06 | -- | --
Forward | 4.45 | 4.47 | 4.49 | 4.52 | 4.55 | 4.66 | 4.77 | 4.9 | 5.03
Russian Ruble | EURRUB
Forecast |  | 74.25 | 77.3 | 76.01 | 79.06 | 98.15 | -- | -- | --
Forward | 76.33 | 77.92 | 82.31 | 85.65 | 88.8 | 102.46 | 96.68 | 100.46 | 113.38
Russian Ruble | USDRUB
Forecast |  | 70 | 72.7 | 72 | 73.4 | 92.5 | 100 | -- | --
Forward | -999998 | -- | -- | -- | -- | -- | -- | -- | --
Ruble Basket | RUBBASK
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | -999998 | -- | -- | -- | -- | -- | -- | -- | --
Turkish Lira | USDTRY
Forecast |  | 19.46 | 20.35 | 21 | 21.85 | 22 | 26 | -- | --
Forward | -999998 | -- | -- | -- | -- | -- | -- | -- | --
Israeli Shekel | USDILS
Forecast |  | 3.45 | 3.45 | 3.4 | 3.28 | 3.21 | -- | -- | --
Forward | 3.48 | 3.47 | 3.46 | 3.44 | 3.42 | 3.36 | 3.31 | 3.27 | 3.23
S. African Rand | USDZAR
Forecast |  | 17.27 | 17 | 16.83 | 16.5 | 16.38 | 17.15 | -- | --
Forward | -999998 | -- | -- | -- | -- | -- | -- | -- | --
Nigerian Naira | USDNGN
Forecast |  | 450 | 480 | 480 | 500 | -- | -- | -- | --
Forward | 461.33 | 462.39 | 467.71 | 473.1 | -- | -- | -- | -- | --
[NAME] | USDGHS
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 12.15 | 12.75 | 13.64 | 14.44 | 15.21 | -- | -- | -- | --
[NAME] | USDKES
Forecast |  | 122.5 | 120 | 120 | 120 | -- | -- | -- | --
Forward | 124.93 | 125.47 | 127.12 | 128.77 | 131.07 | -- | -- | -- | --
[NAME] | USDUGX
Forecast |  | 3700 | 3700 | 3700 | 3700 | -- | -- | -- | --
Forward | -999998 | -- | -- | -- | -- | -- | -- | -- | --
Icelandic Krona | USDISK
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 142 | 143 | 143 | 144 | 145 | 150 | 155 | 160 | 166
Icelandic Krona | EURISK
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 152 | 153 | 155 | 156 | 158 | 165 | 172 | 179 | 186
[NAME] | USDBGN
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 1.83 | 1.82 | 1.81 | 1.81 | 1.8 | 1.78 | -- | -- | --
[NAME] | EURBGN
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 1.96 | 1.96 | 1.96 | 1.96 | 1.96 | 1.96 | -- | -- | --
[NAME] | USDRON
Forecast |  | 4.65 | 4.67 | 4.63 | 4.61 | 4.5 | -- | -- | --
Forward | -999998 | -- | -- | -- | -- | -- | -- | -- | --
[NAME] | EURRON
Forecast |  | 4.95 | 5 | 5.05 | 5.1 | 5.01 | 4.76 | -- | --
Forward | 4.9 | 4.93 | 4.98 | 5.03 | 5.08 | 5.28 | 5.52 | 5.75 | 5.99
Ukrainian Hryvnia | EURUAH
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 39.5 | -- | -- | -- | -- | -- | -- | -- | --
Ukrainian Hryvnia | USDUAH
Forecast |  | 38.1 | 38.5 | 41.28 | 40.54 | -- | -- | -- | --
Forward | -999998 | -- | -- | -- | -- | -- | -- | -- | --
Serbian Dinar | EURRSD
Forecast |  | 117.3 | 117.3 | 117.3 | 117.3 | -- | -- | -- | --
Forward | 117.35 | 117.67 | 118.46 | 119.41 | 121.23 | 129.01 | -- | -- | --
Argentinian Peso | USDARS
Forecast |  | 209 | 240 | 270 | 315 | 450 | -- | -- | --
Forward | 178.45 | 216.4 | 255.45 | 296.75 | 338.16 | 427.23 | -- | -- | --
Brazilian Real | USDBRL
Forecast |  | 5.3 | 5.2 | 5.2 | 5.21 | 5 | 4.78 | 4.61 | --
Forward | 5.39 | 5.48 | 5.58 | 5.67 | 5.77 | 6.25 | 6.76 | 7.35 | 7.92
Chilean Peso | USDCLP
Forecast |  | 926 | 925 | 920 | 910 | 876 | 840 | 840 | --
Forward | 853 | 864 | 874 | 877 | 880 | 886 | 893 | 902 | 913
Colombian Peso | USDCOP
Forecast |  | 4950 | 4833 | 4800 | 4800 | 4600 | -- | -- | --
Forward | 4832 | 4910 | 5000 | 5097 | 5195 | 5647 | 6138 | 6642 | 7099
Mexican Peso | USDMXN
Forecast |  | 19.93 | 20 | 20.15 | 20 | 19.2 | 19.45 | 19.5 | --
Forward | 19.43 | 19.73 | 20.07 | 20.42 | 20.73 | 21.79 | 22.69 | 24.4 | 25.28
[NAME] | USDPEN
Forecast |  | 3.87 | 3.9 | 3.8 | 3.85 | 3.7 | -- | -- | --
Forward | 3.82 | 3.85 | 3.87 | 3.89 | 3.91 | 3.97 | 4.09 | 4.23 | 4.34
[NAME] | USDVES
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 17.03 | -- | -- | -- | -- | -- | -- | -- | --
Contributor | Bloomberg Composite |  |  |  |  |  |  |  |  |  |  |  |  | Q1 23 | Q2 23 | Q3 23 | Q4 23
As of |  |  |  |  |  |  |  |  |  |  |  | EURUSD | Forecast
 | Spot | Q1 23 | Q2 23 | Q3 23 | Q4 23 | 2024 | 2025 | 2026 | 2027 |  |  | USDJPY | Forecast
Euro | EURUSD |  |  |  |  |  |  |  |  |  |  | [NAME] | Forward
Forecast |  | 1.07 | 1.08 | 1.1 | 1.11 | 1.15 | 1.15 | 1.12 | 1.1
Forward | 1.07 | 1.07 | 1.08 | 1.08 | 1.09 | 1.1 | 1.11 | 1.12 | 1.13
[NAME] | USDJPY
Forecast |  | 130 | 127 | 125 | 125 | 120 | 115 | 115 | --
Forward | 131 | 130 | 129 | 127 | 125 | 120 | 116 | 112 | 109
[NAME] | EURJPY
Forecast |  | 138 | 138 | 137 | 137 | 135 | 131 | 136 | --
Forward | 140 | 140 | 139 | 137 | 136 | 132 | 129 | 126 | 123
British Pound | [NAME]
Forecast |  | 1.21 | 1.23 | 1.24 | 1.25 | 1.28 | 1.28 | 1.25 | --
Forward | 1.2 | 1.2 | 1.2 | 1.21 | 1.21 | 1.22 | 1.21 | 1.21 | 1.21
British Pound | EURGBP
Forecast |  | 0.89 | 0.88 | 0.89 | 0.89 | 0.89 | 0.89 | 0.91 | --
Forward | 0.89 | 0.89 | 0.89 | 0.9 | 0.9 | 0.91 | 0.91 | 0.92 | 0.93
Swiss Franc | USDCHF
Forecast |  | 0.93 | 0.92 | 0.92 | 0.92 | 0.91 | 0.9 | 0.91 | --
Forward | 0.92 | 0.92 | 0.91 | 0.9 | 0.89 | 0.87 | 0.85 | 0.84 | 0.82
Swiss Franc | EURCHF
Forecast |  | 1 | 1 | 1.01 | 1.02 | 1.05 | 1.06 | 1.03 | --
Forward | 0.99 | 0.99 | 0.98 | 0.98 | 0.97 | 0.96 | 0.95 | 0.94 | 0.93
Canadian Dollar | USDCAD
Forecast |  | 1.34 | 1.32 | 1.3 | 1.29 | 1.25 | 1.26 | 1.26 | --
Forward | 1.35 | 1.34 | 1.34 | 1.34 | 1.34 | 1.33 | 1.33 | 1.32 | 1.32
Australian Dollar | AUDUSD
Forecast |  | 0.69 | 0.7 | 0.71 | 0.72 | 0.75 | 0.75 | 0.76 | --
Forward | 0.69 | 0.69 | 0.69 | 0.7 | 0.7 | 0.7 | 0.7 | 0.69 | 0.68
NZ Dollar | NZDUSD
Forecast |  | 0.64 | 0.64 | 0.65 | 0.66 | 0.68 | 0.7 | 0.72 | --
Forward | 0.63 | 0.63 | 0.63 | 0.63 | 0.63 | 0.63 | 0.62 | 0.62 | 0.61
[NAME] | EURDKK
Forecast |  | 7.44 | 7.44 | 7.45 | 7.45 | 7.46 | 7.46 | -- | --
Forward | 7.44 | 7.44 | 7.43 | 7.42 | 7.42 | 7.41 | 7.39 | 7.38 | 7.37
[NAME] | USDDKK
Forecast |  | 7.01 | 6.95 | 6.83 | 6.84 | 6.92 | 7.22 | -- | --
Forward | 6.96 | 6.94 | 6.89 | 6.85 | 6.82 | 6.72 | 6.66 | 6.6 | 6.54
Norwegian Krone | EURNOK
Forecast |  | 10.56 | 10.47 | 10.31 | 10.06 | 9.65 | 9.75 | -- | --
Forward | 11.1 | 11.11 | 11.11 | 11.11 | 11.11 | 11.12 | 11.15 | 11.19 | 11.23
Norwegian Krone | USDNOK
Forecast |  | 9.91 | 9.68 | 9.45 | 9.2 | 8.75 | 8.6 | -- | --
Forward | 10.39 | 10.36 | 10.31 | 10.26 | 10.21 | 10.1 | 10.04 | 10 | 9.97
Swedish Krona | EURSEK
Forecast |  | 11.03 | 10.87 | 10.75 | 10.6 | 10.25 | 10.3 | -- | --
Forward | 11.36 | 11.36 | 11.37 | 11.37 | 11.36 | 11.35 | 11.34 | 11.35 | 11.36
Swedish Krona | USDSEK
Forecast |  | 10.4 | 10.14 | 10 | 9.69 | 9.35 | 9.8 | -- | --
Forward | -999998 | -- | -- | -- | -- | -- | -- | -- | --
DXY Dollar | DXY
Forecast |  | 103 | 100.9 | 100.2 | 98.8 | 96.1 | 95.1 | -- | --
Forward | 103.6 | -- | -- | -- | -- | -- | -- | -- | --
Chinese Renminbi | USDCNY
Forecast |  | 6.78 | 6.75 | 6.68 | 6.65 | 6.5 | 6.65 | -- | --
Forward | 6.79 | 6.77 | 6.73 | 6.7 | 6.67 | 6.63 | 6.71 | 6.93 | 7.17
Offshore Deliverable Renminbi | USDCNH
Forecast |  | 6.75 | 6.71 | 6.69 | 6.64 | 6.5 | -- | -- | --
Forward | 6.79 | 6.77 | 6.73 | 6.69 | 6.66 | 6.59 | 6.57 | 6.55 | 6.52
Hong Kong Dollar | USDHKD
Forecast |  | 7.8 | 7.8 | 7.8 | 7.8 | 7.76 | -- | -- | --
Forward | 7.85 | 7.83 | 7.81 | 7.81 | 7.8 | 7.79 | 7.77 | 7.78 | 7.79
[NAME] | USDINR
Forecast |  | 82 | 81.6 | 81 | 80 | 79.5 | 83 | -- | --
Forward | 82.7 | 82.99 | 83.45 | 83.89 | 84.32 | 86.17 | 88.85 | 92.04 | 95.39
[NAME] | USDIDR
Forecast |  | 15300 | 15200 | 15089 | 15000 | 14700 | 14625 | -- | --
Forward | 15144 | 15171 | 15188 | 15214 | 15248 | 15488 | 15968 | 16432 | 16996
Malaysian Ringgit | USDMYR
Forecast |  | 4.35 | 4.32 | 4.3 | 4.25 | 4.14 | -- | -- | --
Forward | 4.3 | 4.29 | 4.27 | 4.25 | 4.23 | 4.23 | -- | -- | --
Philippine Peso | USDPHP
Forecast |  | 55.3 | 55 | 54.9 | 54.1 | 54.3 | 54.5 | -- | --
Forward | 55.1 | 55.2 | 55.3 | 55.4 | 55.6 | 56.1 | 57.1 | 58.3 | 59.3
Singapore Dollar | USDSGD
Forecast |  | 1.33 | 1.33 | 1.33 | 1.32 | 1.3 | 1.32 | -- | --
Forward | -999998 | -- | -- | -- | -- | -- | -- | -- | --
[NAME] | USDKRW
Forecast |  | 1250 | 1250 | 1235 | 1220 | 1185 | 1220 | -- | --
Forward | 1256 | 1253 | 1248 | 1242 | 1237 | 1221 | 1211 | 1205 | 1199
Taiwanese Dollar | USDTWD
Forecast |  | 30.3 | 30.1 | 29.8 | 29.6 | 29.6 | 30.2 | -- | --
Forward | -999998 | -- | -- | -- | -- | -- | -- | -- | --
Thai Baht | USDTHB
Forecast |  | 33.2 | 33 | 32.8 | 32.5 | 32 | -- | -- | --
Forward | -999998 | -- | -- | -- | -- | -- | -- | -- | --
[NAME] | USDVND
Forecast |  | 23500 | 23450 | 23450 | 23325 | 22850 | -- | -- | --
Forward | -999998 | -- | -- | -- | -- | -- | -- | -- | --
Kazakhstan Tenge | EURKZT
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 488 | 496 | 511 | 526 | 540 | 614 | -- | -- | --
Kazakhstan Tenge | USDKZT
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 456 | 463 | 474 | 485 | 496 | 557 | 651 | 706 | 786
[NAME] | EURCZK
Forecast |  | 24.6 | 24.6 | 24.7 | 24.4 | 24.4 | 24.2 | -- | --
Forward | 24.1 | 24.3 | 24.5 | 24.7 | 24.9 | 25.3 | 25.5 | 25.8 | 26.1
[NAME] | USDCZK
Forecast |  | 23.79 | 23.43 | 23.3 | 22.45 | 22.36 | 21.58 | 20.2 | --
Forward | 22.78 | 22.89 | 22.97 | 23.04 | 23.08 | 23.2 | 23.3 | 23.37 | 23.46
[NAME] | EURHUF
Forecast |  | 410 | 410 | 411 | 410 | 404 | 397 | -- | --
Forward | 400 | 413 | 425 | 436 | 446 | 481 | 511 | 536 | 560
[NAME] | USDHUF
Forecast |  | 410 | 402 | 394 | 385 | 382 | 366 | 360 | --
Forward | 379 | 389 | 398 | 407 | 414 | 441 | 466 | 492 | 512
Polish Zloty | EURPLN
Forecast |  | 4.8 | 4.77 | 4.78 | 4.7 | 4.68 | 4.58 | -- | --
Forward | 4.68 | 4.74 | 4.79 | 4.85 | 4.91 | 5.11 | 5.31 | 5.5 | 5.7
Polish Zloty | USDPLN
Forecast |  | 4.71 | 4.66 | 4.59 | 4.46 | 4.43 | 4.19 | 4.13 | --
Forward | 4.43 | 4.46 | 4.49 | 4.52 | 4.56 | 4.69 | 4.83 | 4.97 | 5.12
Russian Ruble | EURRUB
Forecast |  | 69.4 | 71.19 | 74.13 | 78.5 | 81.45 | -- | -- | --
Forward | 77.07 | 79.99 | 84.16 | 88.07 | 91.23 | 98.16 | 104.11 | 109.08 | 113.3
Russian Ruble | USDRUB
Forecast |  | 66.1 | 68 | 70 | 70 | 76.05 | -- | -- | --
Forward | 72.97 | 75.32 | 78.83 | 82.13 | 84.71 | 90.15 | 95 | 98.8 | 101.84
Ruble Basket | RUBBASK
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | -999998 | -- | -- | -- | -- | -- | -- | -- | --
Turkish Lira | USDTRY
Forecast |  | 20 | 20.75 | 22 | 22 | 21.5 | 31 | 33 | --
Forward | 18.73 | 20.15 | 21.84 | 23.6 | 25.37 | 33.58 | 42.85 | 53.61 | 65.86
Israeli Shekel | USDILS
Forecast |  | 3.5 | 3.45 | 3.4 | 3.35 | -- | -- | -- | --
Forward | 3.53 | 3.52 | 3.49 | 3.48 | 3.46 | 3.41 | 3.38 | 3.35 | 3.33
S. African Rand | USDZAR
Forecast |  | 17.5 | 17.25 | 17 | 16.5 | 16.9 | 17 | 17 | --
Forward | 16.97 | 17.09 | 17.22 | 17.34 | 17.46 | 18.14 | 19.02 | 20.01 | 21.17
Nigerian Naira | USDNGN
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 461.11 | 468.31 | 476.99 | 485.76 | -- | -- | -- | -- | --
[NAME] | USDGHS
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 10.13 | 11.05 | 12.13 | 12.47 | 13.47 | -- | -- | -- | --
[NAME] | USDKES
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 123.46 | 124.73 | 126.4 | 128.05 | 130.74 | -- | -- | -- | --
[NAME] | USDUGX
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 3728 | 3772 | 3838 | 3890 | 3952 | 4270 | -- | -- | --
Icelandic Krona | USDISK
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 144 | 144 | 145 | 145 | 146 | 150 | 155 | 160 | 165
Icelandic Krona | EURISK
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 152 | 153 | 155 | 156 | 157 | 164 | 170 | 176 | 183
[NAME] | USDBGN
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 1.85 | 1.84 | 1.83 | 1.83 | 1.82 | 1.8 | -- | -- | --
[NAME] | EURBGN
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 1.96 | 1.95 | 1.96 | 1.96 | 1.96 | 1.96 | -- | -- | --
[NAME] | USDRON
Forecast |  | 4.94 | 4.86 | 4.81 | 4.68 | -- | -- | -- | --
Forward | 4.67 | 4.7 | 4.73 | 4.76 | 4.79 | 4.93 | 5.11 | 5.18 | 5.24
[NAME] | EURRON
Forecast |  | 5.01 | 5.04 | 5.05 | 5.02 | 4.97 | 4.91 | -- | --
Forward | 4.93 | 4.99 | 5.05 | 5.1 | 5.16 | 5.37 | 5.62 | 5.87 | 6.12
Ukrainian Hryvnia | EURUAH
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 38.9 | -- | -- | -- | -- | -- | -- | -- | --
Ukrainian Hryvnia | USDUAH
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 36.85 | 39.59 | 42.7 | 44.65 | 46.02 | 53.29 | -- | -- | --
Serbian Dinar | EURRSD
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 117.31 | 118.06 | 119.85 | 121.72 | 123.72 | 129.73 | -- | -- | --
Argentinian Peso | USDARS
Forecast |  | 209 | 240 | 270 | 315 | 450 | -- | -- | --
Forward | 178.45 | 216.4 | 255.45 | 296.75 | 338.16 | 427.23 | -- | -- | --
Brazilian Real | USDBRL
Forecast |  | 5.3 | 5.2 | 5.2 | 5.21 | 5 | 4.78 | 4.61 | --
Forward | 5.39 | 5.48 | 5.58 | 5.67 | 5.77 | 6.25 | 6.76 | 7.35 | 7.92
Chilean Peso | USDCLP
Forecast |  | 926 | 925 | 920 | 910 | 876 | 840 | 840 | --
Forward | 853 | 864 | 874 | 877 | 880 | 886 | 893 | 902 | 913
Colombian Peso | USDCOP
Forecast |  | 4950 | 4833 | 4800 | 4800 | 4600 | -- | -- | --
Forward | 4832 | 4910 | 5000 | 5097 | 5195 | 5647 | 6138 | 6642 | 7099
Mexican Peso | USDMXN
Forecast |  | 19.93 | 20 | 20.15 | 20 | 19.2 | 19.45 | 19.5 | --
Forward | 19.43 | 19.73 | 20.07 | 20.42 | 20.73 | 21.79 | 22.69 | 24.4 | 25.28
[NAME] | USDPEN
Forecast |  | 3.87 | 3.9 | 3.8 | 3.85 | 3.7 | -- | -- | --
Forward | 3.82 | 3.85 | 3.87 | 3.89 | 3.91 | 3.97 | 4.09 | 4.23 | 4.34
[NAME] | USDVES
Forecast |  | -- | -- | -- | -- | -- | -- | -- | --
Forward | 17.03 | -- | -- | -- | -- | -- | -- | -- | --