Average ADR and RevPAR figures for Playa Hotels and Resorts. Quarterly figures sourced from previous quarterly financial reports.

playa_hotels_and_resorts

# Average Portfolio Performance for 2020

hotels=# select portfolio, cast(avg(adr) as decimal(5,2)) as adr, cast(avg(revpar) as decimal(5,2)) as revpar from playa where year='2020' group by portfolio order by revpar desc;
     portfolio      |  adr   | revpar 
--------------------+--------+--------
 Jamaica            | 315.39 | 128.55
 Yucatan Peninsula  | 292.27 | 120.73
 Pacific Coast      | 395.25 | 102.31
 Dominican Republic | 239.74 |  61.79
(4 rows)

# Average Portfolio Performance for 2021

hotels=# select portfolio, cast(avg(adr) as decimal(5,2)) as adr, cast(avg(revpar) as decimal(5,2)) as revpar from playa where year='2021' group by portfolio order by revpar desc;
     portfolio      |  adr   | revpar 
--------------------+--------+--------
 Yucatan Peninsula  | 318.49 | 168.23
 Pacific Coast      | 344.01 | 163.14
 Jamaica            | 300.86 | 129.10
 Dominican Republic | 268.10 | 110.26
(4 rows)

# Portfolio Performance for Q1 2022

hotels=# select portfolio, cast(adr as decimal(5,2)), cast(revpar as decimal(5,2)) from playa where year='2022' order by revpar desc;
     portfolio      |  adr   | revpar 
--------------------+--------+--------
 Yucatan Peninsula  | 429.45 | 308.75
 Pacific Coast      | 454.61 | 302.89
 Jamaica            | 415.11 | 280.54
 Dominican Republic | 324.26 | 250.68
(4 rows)

# Original figures sourced from historical quarterly reports

hotels=# select * from playa order by year, quarter;
     portfolio      |  adr   | revpar | quarter | year 
--------------------+--------+--------+---------+------
 Yucatan Peninsula  | 299.22 | 221.58 | Q1      | 2020
 Dominican Republic | 227.33 | 130.21 | Q1      | 2020
 Jamaica            | 349.22 | 247.17 | Q1      | 2020
 Pacific Coast      | 344.28 | 214.92 | Q1      | 2020
 Yucatan Peninsula  | 298.32 | 110.45 | Q2      | 2020
 Jamaica            | 355.09 | 131.43 | Q2      | 2020
 Dominican Republic | 226.04 |  64.74 | Q2      | 2020
 Pacific Coast      | 342.58 | 106.93 | Q2      | 2020
 Yucatan Peninsula  | 288.40 |  56.94 | Q3      | 2020
 Jamaica            | 236.94 |  39.23 | Q3      | 2020
 Dominican Republic | 268.25 |   7.76 | Q3      | 2020
 Pacific Coast      | 578.90 |   6.01 | Q3      | 2020
 Pacific Coast      | 315.24 |  81.38 | Q4      | 2020
 Jamaica            | 320.30 |  96.36 | Q4      | 2020
 Dominican Republic | 237.34 |  44.46 | Q4      | 2020
 Yucatan Peninsula  | 283.15 |  93.94 | Q4      | 2020
 Dominican Republic | 282.27 |  73.33 | Q1      | 2021
 Yucatan Peninsula  | 290.91 | 121.66 | Q1      | 2021
 Pacific Coast      | 311.06 |  87.20 | Q1      | 2021
 Jamaica            | 279.87 |  73.57 | Q1      | 2021
 Yucatan Peninsula  | 311.22 | 145.60 | Q2      | 2021
 Jamaica            | 295.96 | 111.51 | Q2      | 2021
 Dominican Republic | 266.65 |  94.73 | Q2      | 2021
 Pacific Coast      | 330.29 | 145.39 | Q2      | 2021
 Pacific Coast      | 372.39 | 225.43 | Q3      | 2021
 Jamaica            | 314.62 | 181.39 | Q3      | 2021
 Dominican Republic | 260.61 | 144.26 | Q3      | 2021
 Yucatan Peninsula  | 336.35 | 217.75 | Q3      | 2021
 Pacific Coast      | 362.28 | 194.53 | Q4      | 2021
 Jamaica            | 312.97 | 149.93 | Q4      | 2021
 Dominican Republic | 262.86 | 128.73 | Q4      | 2021
 Yucatan Peninsula  | 335.48 | 187.92 | Q4      | 2021
 Pacific Coast      | 454.61 | 302.89 | Q1      | 2022
 Jamaica            | 415.11 | 280.54 | Q1      | 2022
 Dominican Republic | 324.26 | 250.68 | Q1      | 2022
 Yucatan Peninsula  | 429.45 | 308.75 | Q1      | 2022
(36 rows)