Question: Help me compute this assignment in xcel format base on the following questions: Question #1: Compute the amount changes using horizontal analysis for 2022 and

Help me compute this assignment in xcel format base on the following questions:

Question #1: Compute the amount changes using horizontal analysis for 2022 and 2023 (assume that 2022 is the base year) for the following financial statement accounts/line items: 1. Investment in hotel properties, net 2. Investment in unconsolidated joint ventures 3. Lease right-of-use-assets 4. Lease liabilities

Question #2: Compute the amount changes using horizontal analysis for 2022 and 2023 (assume that 2022 is the base year) for the following financial statement accounts/line items: 1. Room revenue 2. Food and beverage revenue 3. Other revenue 4. Total revenues 5. Advance deposits and deferred revenue

Help me compute this assignment in xcel formatHelp me compute this assignment in xcel format
RLJ Lodging Trust Consolidated Balance Sheets (Amounts in thousands, except share and per share data) December 31, 2023 2022 Assets Investment in hotel properties, net . . . . . . . . . . $ 4,136,216 $ 4,180,328 Investment in unconsolidated joint ventures . .. 7,398 6,979 Cash and cash equivalents 516,675 481,316 Restricted cash reserves 38,652 55,070 Hotel and other receivables, net of allowance of $265 and $319, respectively 26,163 38,528 Lease right-of-use assets . 136,140 136,915 Prepaid expense and other assets 58,051 79,089 Total assets . . . . . . . $ 4,919,295 $ 4,978,225 Liabilities and Equity Debt, net . . . . . $ 2,220,778 $ 2,217,555 Accounts payable and other liabilities 147,819 155,916 Advance deposits and deferred revenue 32,281 23,769 Lease liabilities 122,588 117,010 Accrued interest . 22,539 20,707 Distributions payable 22,500 14,622 Total liabilities . . . . . 2,568,505 2,549,579 Commitments and Contingencies (Note 10) Equity Shareholders' equity: Preferred shares of beneficial interest, $0.01 par value, 50,000,000 shares authorized Series A Cumulative Convertible Preferred Shares, $0.01 par value, 12,950,000 shares authorized; 12,879,475 shares issued and outstanding, liquidation value of $328,266, at December 31, 2023 and 2022 . . . . . . 366,936 366,936 Common shares of beneficial interest, $0.01 par value, 450,000,000 shares authorized; 155,297,829 and 162,003,533 shares issued and outstanding at December 31, 2023 and 2022, respectively . . . . . . . . . 1,553 1,620 Additional paid-in capital . . . 3,000,894 3,054,958 Accumulated other comprehensive income 22,662 40,591 Distributions in excess of net earnings (1,055,183) (1,049,441) Total shareholders' equity . . . . 2,336,862 2,414,664 Noncontrolling interest: Noncontrolling interest in consolidated joint ventures 7,634 7,669 Noncontrolling interest in the Operating Partnership . 6,294 6,313 Total noncontrolling interest . . . . . . 13,928 13,982 Total equity . . . 2,350,790 2,428,646 Total liabilities and equity . . . . .. $ 4,919,295 $ 4,978,225 The accompanying notes are an integral part of these consolidated financial statements. F-4RLJ Lodging Trust Consolidated Statements of Operations and Comprehensive Income (Loss) (Amounts in thousands, except share and per share data For the year ended December 31, 2023 2022 2021 Revenues Operating revenues Room revenue . $ 1,095,028 $ 1,002,454 $ 667,853 Food and beverage revenue . 141,625 117,027 8,994 Other revenue 88,924 74,181 58,817 Total revenues 1,325,577 1,193,662 785,664 Expenses Operating expenses Room expense . 277,058 253,441 177,365 Food and beverage expense . 109,707 87,402 41,790 Management and franchise fee expense . . . .07,417 95,565 53,276 Other operating expenses 340,485 308,000 239,092 Total property operating expenses . 834,667 744,408 511,523 Depreciation and amortization . 179,103 184,875 187,778 Impairment losses 144,845 Property tax, insurance and other 100,229 86,996 88,852 General and administrative 58,998 56.330 47,526 Transaction costs 223 (345) 94 Total operating expenses . 1,173,220 1,072,264 980,618 Other income (expense), net . . 4,364 9.496 7,614) Interest income . 19,743 4,559 996 Interest expense (98,807) 93,155) (106,366 (Loss) gain on sale of hotel properties, net . . (34 ) 1,017 (2,378) (Loss) gain on extinguishment of indebtedness, net . . (169) (39) 893 Income (loss) before equity in income (loss) from unconsolidated joint ventures 77,454 43,276 (309,423) Equity in income (loss) from unconsolidated joint ventures . 419 457 (477) Income (loss) before income tax expense . . . 77,873 43,733 (309,900) Income tax expense . (1,256) (1,518) (1,188) Net income (loss) . . . 76,617 42,215 (311,088) Net loss (income) attributable to noncontrolling interests: Noncontrolling interest in consolidated joint ventures 35 (210) 4,384 Noncontrolling interest in the Operating Partnership . (247) (80) 1,536 Net income (loss) attributable to RLJ . . 76,405 41,925 (305,168) Preferred dividends . (25,115) (25,115) (25,115) Net income (loss) attributable to common shareholders . 51,290 16,810 $ (330,283) Basic per common share data Net income (loss) per share attributable to common shareholders . . . S 0.32 0.10 $ (2.01) Weighted-average number of common shares 155,928,663 161,947,807 163,998,390 Diluted per common share data: Net income (loss) per share attributable to common shareholders 0.32 0.10 (2.01) Weighted-average number of common shares . . . . . . . . . 156,556,414 162,292,865 163,998,390 Comprehensive income (loss): Net income (loss) . . . 76,617 $ 42,215 $ (311,088) Unrealized (loss) gain on interest rate derivatives . . . . . . . . . . . . . ... (17,929) 63,570 41,279 Reclassification of unrealized (gains) losses on discontinued cash flow hedges to other income (expense), net . . (5,866) 10,658 Comprehensive income (loss) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. 58,688 99,919 (259,151) Comprehensive loss (income) attributable to noncontrolling interests: Noncontrolling interest in consolidated joint ventures 35 (210) 4,384 Noncontrolling interest in the Operating Partnership . . . (247) (80) 1,536 Comprehensive income (loss) attributable to RLJ . 58,476 99,629 (253,231)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!