Spreadsheet: 89307d1289071011-copying-specific-data-from-one-file-into-another-file-generic_2q10
Sheet: Location D

Location D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 Months Combined
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CALCULATE
 |  | 3 Months |  | 6 Months |  | 3 Months |  |  | 9 Months |  | 3 Months |  |  | 12 Months |  | 3 Months |  |  | 3 Months |  |  | 6 Months |  | 3 Months |  |  | 9 Months |  | 3 Months |  |  | 12 Months |  | 3 Months |  |  | 3 Months |  |  | 6 Months |  | 3 Months |  |  | TTM
 |  | 2008-03-31 00:00:00 |  | 2008-06-30 00:00:00 |  | 2008-06-30 00:00:00 | PPD |  | 2008-09-30 00:00:00 |  | 2008-09-30 00:00:00 | PPD |  | 2008-12-31 00:00:00 |  | 2008-12-31 00:00:00 | PPD |  | 2009-03-31 00:00:00 | PPD |  | 2009-06-30 00:00:00 |  | 2009-06-30 00:00:00 | PPD |  | 2009-09-30 00:00:00 |  | 2009-09-30 00:00:00 | PPD |  | 2009-12-31 00:00:00 |  | 2009-12-31 00:00:00 | PPD |  | 2010-03-31 00:00:00 | PPD |  | 2010-06-30 00:00:00 |  | 2010-06-30 00:00:00 | PPD |  | 2010-06-30 00:00:00 | PPD
OPERATING STATEMENT
Census & Occupancy
[NAME] |  | 162 |  | 162 |  | 162 |  |  | 162 |  | 162 |  |  | 162 |  | 162 |  |  | 162 |  |  | 162 |  | 162 |  |  | 162 |  | 162 |  |  | 162 |  | 162 |  |  | 162 |  |  | 162 |  | 162 |  |  | 162
Operating Beds |  | 142 |  | 142 |  | 142 |  |  | 142 |  | 142 |  |  | 142 |  | 142 |  |  | 142 |  |  | 142 |  | 142 |  |  | 142 |  | 142 |  |  | 142 |  | 142 |  |  | 142 |  |  | 142 |  | 142 |  |  | 142
Days in Period |  | 91 |  | 182 |  | 91 |  |  | 274 |  | 92 |  |  | 366 |  | 92 |  |  | 90 |  |  | 181 |  | 91 |  |  | 273 |  | 92 |  |  | 365 |  | 92 |  |  | 90 |  |  | 181 |  | 91 |  |  | 365
Patient Days - Capacity |  | 12922 |  | 25844 |  | 12922 |  |  | 38908 |  | 13064 |  |  | 51972 |  | 13064 |  |  | 12780 |  |  | 25702 |  | 12922 |  |  | 38766 |  | 13064 |  |  | 51830 |  | 13064 |  |  | 12780 |  |  | 25702 |  | 12922 |  |  | 51830
Payor Mix - Days & Percent
Residential Care (RC)
Private |  | 0 |  | 0 |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | #N/A |  | 0 | #N/A
Other (1) |  | 0 |  | 0 |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | #N/A |  | 0 | #N/A
Total Residential Days |  | 0 |  | 0 |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 | #N/A |  | 0 | #N/A
Skilled Nursing Care (SNF)
Private |  | 817 |  | 1605 |  | 788 | 0.1219436706901888 |  | 2239 |  | 634 | 0.09246025958874143 |  | 2722 |  | 483 | 0.07196066746126341 |  | 374 | 0.05982085732565579 |  | 924 |  | 550 | 0.08483726669751658 |  | 1693 |  | 769 | 0.109575377600456 |  | 2758 |  | 1065 | 0.1529513140887548 |  | 496 | 0.07279131200469621 |  | 853 |  | 357 | 0.05373269114990969 |  | 2687 | 0.09792630926783046
Medicare |  | 631 |  | 962 |  | 331 | 0.05122253172392448 |  | 1873 |  | 911 | 0.1328569345194691 |  | 3139 |  | 1266 | 0.1886174016686532 |  | 892 | 0.1426743442098528 |  | 1453 |  | 561 | 0.08653401203146692 |  | 2255 |  | 802 | 0.1142775719578227 |  | 2874 |  | 619 | 0.08889846330604624 |  | 803 | 0.1178456119753449 |  | 1668 |  | 865 | 0.1301926550270921 |  | 3089 | 0.1125769889573235
Medicaid |  | 5257 |  | 10600 |  | 5343 | 0.8268337975858867 |  | 15912 |  | 5312 | 0.7746828058917894 |  | 20875 |  | 4963 | 0.7394219308700835 |  | 4986 | 0.7975047984644914 |  | 10358 |  | 5372 | 0.8286287212710165 |  | 15805 |  | 5447 | 0.7761470504417213 |  | 21084 |  | 5279 | 0.7581502226051989 |  | 5515 | 0.8093630760199589 |  | 10937 |  | 5422 | 0.8160746538229982 |  | 21663 | 0.789496701774846
Other |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
Total SNF Days |  | 6705 |  | 13167 |  | 6462 |  |  | 20024 |  | 6857 |  |  | 26736 |  | 6712 |  |  | 6252 | 1 |  | 12735 |  | 6483 | 1 |  | 19753 |  | 7018 | 1 |  | 26716 |  | 6963 | 1 |  | 6814 | 1 |  | 13458 |  | 6644 | 1 |  | 27439 | 1
Patient Days - Actual |  | 6705 |  | 13167 |  | 6462 |  |  | 20024 |  | 6857 |  |  | 26736 |  | 6712 |  |  | 6252 |  |  | 12735 |  | 6483 |  |  | 19753 |  | 7018 |  |  | 26716 |  | 6963 |  |  | 6814 |  |  | 13458 |  | 6644 |  |  | 27439
Premium Mix |  | 0.2159582401193139 |  | 0.1949570896939318 |  | 0.1731662024141133 |  |  | 0.205353575709149 |  | 0.2253171941082106 |  |  | 0.2192175344105326 |  | 0.2605780691299165 |  |  | 0.2024952015355087 |  |  | 0.1866509619159796 |  | 0.1713712787289835 |  |  | 0.1998683744241381 |  | 0.2238529495582787 |  |  | 0.2108100014972301 |  | 0.2418497773948011 |  |  | 0.1906369239800411 |  |  | 0.1873235250408679 |  | 0.1839253461770018 |  |  | 0.210503298225154
Occupancy % |  | 0.5188825259247795 |  | 0.5094799566630552 |  | 0.500077387401331 |  |  | 0.5146499434563586 |  | 0.5248775260257196 |  |  | 0.5144308473793581 |  | 0.5137783221065524 |  |  | 0.4892018779342723 |  |  | 0.4954867325499961 |  | 0.5017025228292834 |  |  | 0.5095444461641645 |  | 0.5372014696876913 |  |  | 0.5154543700559522 |  | 0.5329914268218003 |  |  | 0.5331768388106416 |  |  | 0.5236168391564858 |  | 0.5141618944435846 |  |  | 0.5294038201813621
Revenue
RC Private |  | 0 |  | 0 |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 | #N/A
RC Other |  | 0 |  | 0 |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 | #N/A |  | 0 |  | 0 | #N/A |  | 0 | #N/A
Private |  | 97339 |  | 209728 |  | 112389 | 142.6256345177665 |  | 283539 |  | 73811 | 116.4211356466877 |  | 332630 |  | 49091 | 101.6376811594203 |  | 27526 | 73.59893048128342 |  | 95533.4 |  | 68007.4 | 123.6498181818182 |  | 204431 |  | 108897.6 | 141.6093628088427 |  | 324473.56 |  | 120042.56 | 112.7160187793427 |  | 72201.92 | 145.5683870967742 |  | 104998.18 |  | 32796.25999999999 | 91.8662745098039 |  | 333938.34 | 124.2792482322293
Medicare |  | 206226 |  | 378929 |  | 172703 | 521.761329305136 |  | 815857 |  | 436928 | 479.6136114160263 |  | 1382865 |  | 567008 | 447.8736176935229 |  | 437450 | 490.414798206278 |  | 721915.18 |  | 284465.1800000001 | 507.0680570409983 |  | 1081247 |  | 359331.8199999999 | 448.0446633416458 |  | 1417089.14 |  | 335842.1399999999 | 542.5559612277866 |  | 340214.3 | 423.6790784557908 |  | 693413.83 |  | 353199.53 | 408.3231560693641 |  | 1388587.79 | 449.5266396892197
Medicaid |  | 536190 |  | 1072865 |  | 536675 | 100.4445068313681 |  | 1626491 |  | 553626 | 104.2217620481928 |  | 2153205 |  | 526714 | 106.1281482974008 |  | 551643 | 110.6383874849579 |  | 1204858.38 |  | 653215.3799999999 | 121.5963104988831 |  | 1848261 |  | 643402.6200000001 | 118.1205470901414 |  | 2478464.56 |  | 630203.56 | 119.3793445728358 |  | 598822.05 | 108.5806074342702 |  | 1244901.65 |  | 646079.5999999999 | 119.1589081519734 |  | 2518507.83 | 116.258497438028
Ancillary |  | 10019 |  | 18301 |  | 8282 | 1.28164654905602 |  | 24804 |  | 6503 | 0.9483739244567595 |  | 22935 |  | -1869 | -0.2784564958283671 |  | -12784 | -2.044785668586052 |  | 2048.99 |  | 14832.99 | 2.287982415548357 |  | 9879 |  | 7830.01 | 1.115703904246224 |  | 13930.41 |  | 4051.41 | 0.5818483412322275 |  | 1529.41 | 0.2244511300264162 |  | 3742.23 |  | 2212.82 | 0.3330553883202889 |  | 15623.65 | 0.5693957505740005
Other |  | 473 |  | 1896 |  | 1423 | 0 |  | 2564 |  | 668 | 0 |  | 3148 |  | 584 | 0 |  | 1017 | 0 |  | 1963.42 |  | 946.4200000000001 |  |  | 2902 |  | 938.5799999999999 | 0 |  | 2981.03 |  | 79.0300000000002 | 0 |  | 788.89 | 0 |  | 1405.13 |  | 616.2400000000001 | 0 |  | 2422.74 | 0
Contractual Adjustments |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
Prior Period Adjustments |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  | 0
Total Revenue |  | 850247 |  | 1681719 |  | 831472 | 128.6709996904983 |  | 2753255 |  | 1071536 | 156.2689222692139 |  | 3894783 |  | 1141528 | 170.072705601907 |  | 1004852 | 160.7248880358285 |  | 2026319.37 |  | 1021467.37 | 157.5609085300015 |  | 3146720 |  | 1120400.63 | 159.646712738672 |  | 4236938.7 |  | 1090218.7 | 156.5731293982479 |  | 1013556.57 | 148.7461945993543 |  | 2048461.02 |  | 1034904.45 | 155.7652694160144 |  | 4259080.350000001 | 155.2199551732935
Operating Expenses
Nursing |  | #N/A |  | 0 |  | #N/A | #N/A |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | #N/A | #N/A
Administrative & General |  | #N/A |  | 0 |  | #N/A | #N/A |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | #N/A | #N/A
Activities, Soc Svs & Marketing |  | #N/A |  | 0 |  | #N/A | #N/A |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | #N/A | #N/A
Dietary |  | #N/A |  | 0 |  | #N/A | #N/A |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | #N/A | #N/A
Housekeeping |  | #N/A |  | 0 |  | #N/A | #N/A |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | #N/A | #N/A
Laundry |  | #N/A |  | 0 |  | #N/A | #N/A |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | #N/A | #N/A
Plant Operation & Maint |  | #N/A |  | 0 |  | #N/A | #N/A |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | #N/A | #N/A
Residential Care |  | #N/A |  | 0 |  | #N/A | #N/A |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | #N/A | #N/A
Ancillary & Pharmacy |  | #N/A |  | 0 |  | #N/A | #N/A |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | #N/A | #N/A
Other Expenses |  | #N/A |  | 0 |  | #N/A | #N/A |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | #N/A | #N/A
Prior Period Adjustments |  | #N/A |  | 0 |  | #N/A | #N/A |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | #N/A | #N/A
Total Operating Expenses |  | 630510 |  | 1319263 |  | 688753 | 106.5851129681213 |  | 2088908 |  | 769645 | 112.2422342132128 |  | 2777146 |  | 688238 | 102.5384386174017 |  | 686157 | 109.75 |  | 1388320.11 |  | 702163.1099999999 | 108.3083618695048 |  | 2168869 |  | 780548.8900000001 | 111.2209874608151 |  | 3325414.87 |  | 1156545.87 | 166.0987893149505 |  | 706416.45 | 103.6713310830643 |  | 1419243.49 |  | 712827.04 | 107.2888380493679 |  | 3356338.25 | 122.3199916177703
EBITDARM |  | 219737 |  | 362456 |  | 142719 | 22.08588672237697 |  | 664347 |  | 301891 | 44.02668805600117 |  | 1117637 |  | 453290 | 67.53426698450536 |  | 318695 | 50.97488803582853 |  | 637999.26 |  | 319304.2600000001 | 49.25254666049671 |  | 977851 |  | 339851.74 | 48.42572527785694 |  | 911523.8300000001 |  | -66327.17000000016 | -9.525659916702594 |  | 307140.1200000001 | 45.07486351629001 |  | 629217.5299999998 |  | 322077.4099999998 | 48.47643136664657 |  | 902742.1000000006 | 32.89996355552318
 |  | 0.2584390183087973 |  | 0.2155270886515524 |  | 0.1716461889275886 |  |  | 0.2412951215924424 |  | 0.2817366845350973 |  |  | 0.2869574505177824 |  | 0.3970905663286402 |  |  | 0.3171561583198322 |  |  | 0.3148562213073056 |  | 0.3125936954794749 |  |  | 0.3107524660598973 |  | 0.3033305506084908 |  |  | 0.215137365570099 |  | -0.06083840792677667 |  |  | 0.303032044871457 |  |  | 0.3071659767292032 |  | 0.3112146343558576 |  |  | 0.211957048427133
Less: Management Fee |  | 42423 |  | 83989 |  | 41566 | 0.04999085958396675 |  | 137161 |  | 53172 | 0.04962222454495229 |  | 194582 |  | 57421 | 0.05030187608188323 |  | 50192 | 0.04994964432573155 |  | 101217.78 |  | 51025.78 | 0.04995341162978118 |  | 157191 |  | 55973.22 | 0.04995821896315784 |  | 211697.87 |  | 54506.87 | 0.04999627139031829 |  | 50638.37 | 0.0499610692672043 |  | 102352.76 |  | 51714.38999999999 | 0.04997020739450874 |  | 212832.85 | 0.04997155078325769
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
EBITDAR |  | 177314 |  | 278467 |  | 101153 | 15.65351284432064 |  | 527186 |  | 248719 | 36.27227650576054 |  | 923055 |  | 395869 | 58.97929082240763 |  | 268503 | 42.94673704414587 |  | 536781.48 |  | 268278.4800000001 | 41.38184173993523 |  | 820660 |  | 283878.52 | 40.45005984611001 |  | 699825.9600000001 |  | -120834.0400000002 | -17.35373258652882 |  | 256501.7500000001 | 37.64334458467862 |  | 526864.7699999998 |  | 270363.0199999998 | 40.6928085490668 |  | 689909.2500000006 | 25.14338168300596
Less: Rent |  | 119389 |  | 239701 |  | 120312 | 18.61838440111421 |  | 361857 |  | 122156 | 17.81478780807933 |  | 484014 |  | 122157 | 18.19979141835519 |  | 119349 | 19.08973128598848 |  | 239643.02 |  | 120294.02 | 18.55530155792071 |  | 362726 |  | 123082.98 | 17.53818466799658 |  | 486659.92 |  | 123933.92 | 17.79892575039494 |  | 121291.62 | 17.80035515115938 |  | 243552.49 |  | 122260.87 | 18.40169626730885 |  | 490569.39 | 17.8785447720398
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
EBITDA |  | 57925 |  | 38766 |  | -19159 | -2.964871556793562 |  | 165329 |  | 126563 | 18.4574886976812 |  | 439041 |  | 273712 | 40.77949940405244 |  | 149154 | 23.85700575815739 |  | 297138.46 |  | 147984.4600000001 | 22.82654018201452 |  | 457934 |  | 160795.54 | 22.91187517811342 |  | 213166.0400000001 |  | -244767.9600000001 | -35.15265833692376 |  | 135210.1300000001 | 19.84298943351924 |  | 283312.2799999998 |  | 148102.1499999998 | 22.29111228175795 |  | 199339.8600000006 | 7.264836910966164
Less: Deprec & Amortization |  | 705 |  | 1410 |  | 705 | 0.1090993500464253 |  | 2768 |  | 1358 | 0.1980457926206796 |  | 3847 |  | 1079 | 0.1607568533969011 |  | 1079 | 0.1725847728726807 |  | 2157.94 |  | 1078.94 | 0.1664260373283974 |  | 3237 |  | 1079.06 | 0.1537560558563693 |  | 5143.27 |  | 1906.27 | 0.2737713629182824 |  | 1995.9 | 0.2929116524801879 |  | 4274.02 |  | 2278.12 | 0.3428838049367851 |  | 7259.35 | 0.2645632129450782
Less: Income Tax |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 | 0
Less: Interest |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0 | 0 |  | 38766 | 6.200575815738963 |  | 75890.59 |  | 37124.59 | 5.726452259756285 |  | 115690 |  | 39799.41 | 5.67104730692505 |  | 155211.8 |  | 39521.79999999999 | 5.675973000143615 |  | 35825.82 | 5.257678309363076 |  | 78449.39 |  | 42623.57 | 6.415347682119205 |  | 157770.6 | 5.749866977659535
Net Income |  | 57220 |  | 37356 |  | -19864 | -3.073970906839988 |  | 162561 |  | 125205 | 18.25944290506052 |  | 435194 |  | 272633 | 40.61874255065554 |  | 109309 | 17.48384516954575 |  | 219089.93 |  | 109780.9300000001 | 16.93366188492983 |  | 339007 |  | 119917.07 | 17.087071815332 |  | 52810.97000000012 |  | -286196.0300000001 | -41.10240269998566 |  | 97388.41000000012 | 14.29239947167598 |  | 200588.8699999998 |  | 103200.4599999998 | 15.53288079470195 |  | 34309.91000000056 | 1.250406720361549
EBITDAR Rent Coverage |  | 1.48517870155542 |  | 1.161726484244955 |  | 0.8407557018418778 |  |  | 1.456890429092155 |  | 2.036076819804185 |  |  | 1.907083266186515 |  | 3.240657514510016 |  |  | 2.249729784078626 |  |  | 2.239921196119127 |  | 2.23018966362584 |  |  | 2.262479116468078 |  | 2.306399471316018 |  |  | 1.438018483215137 |  | -0.9749876385738478 |  |  | 2.114752445387407 |  |  | 2.163249367723564 |  | 2.211361820016493 |  |  | 1.406343860957164
Adjustments |  | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0 |  | 0 |  |  | 0 |  |  | 0 |  | 0 |  |  | 0
Adjusted EBITDAR |  | 177314 |  | 278467 |  | 101153 |  |  | 527186 |  | 248719 |  |  | 923055 |  | 395869 |  |  | 268503 |  |  | 536781.48 |  | 268278.4800000001 |  |  | 820660 |  | 283878.52 |  |  | 699825.9600000001 |  | -120834.0400000002 |  |  | 256501.7500000001 |  |  | 526864.7699999998 |  | 270363.0199999998 |  |  | 689909.2500000006