f 01- NSWER For the balance sheet prepare a VERTICAL A(Do not perform this analysis for the cells colored black, only perform for the cells in yellow). Perform work in the table below LASE USE THE EXCEL FUNTIONALTY TO PERFORM THE ANALYSIS. DO NOT USE A CALCULATOR AND THEN TYPE YOUR ANSWER INTO THE CELLS Al the change in the accounts indicated below in welow. Think about what could be causing this change? What cances des trase for you? wartow Below Set Are Bevel Gran who on should look What she she would the war Anas mostly be performed? Pantin substantia completion 1 Brytan wystna) the Better to matemat wy did and cu ANSWER BALANCE STREET ERRE 2002 of Assets of Assets 20/0 20XX1 Ant Change Analysis of Change Investors 115 SN 15100 1700 4.000 3000 200 21200 200 3000 3100 12an OP Le Der SILOS 11.500 SO $1,000 1709 6118 Shareholders Stock Photo 15.300 14.00 11.10 2012 30 Instructions Decod Tips Common Forms Soldestinationwide INTERO Paste Financial 01 02 03 DS Ratio Gross Profit Ratio 04 05-7 Guidance Questions MacBook Air Home Exercise - Acrocedures. ACC 322 V2 (version 1). ab. AutoRecovered Review View Tell me Formulas Data Insert Draw Page Layout XF SUMO PMT 911 01- ANSWER for the balance sheet prepare VERTICAL Anal Do not perform the analysis for the cells colored black, only perform for the cells in yellow). Perform work in the below." PLEASE USE THE EXCEL FUNTIONALITY TO PERFORM THE ANALYSIS. DO NOT USE A CALCULATOR AND THEN TYPE YOUR ANSWER INTO THE CELLS Are the changin tersindicated below in Thabout what could be causing this conte? Wo does this raise for you? on the lowell. Ser Account Revalentemente 02- ANSWER whatsached would this analytic Vertical Anlamly be performed in the completion Portaplan whilsentence DE DOMINGO LANCERET Bered 19 20X20XX of Ass of Asset 20xx Change Analysis of Change and their nos 5% 13.00 31208 4000 2000 119 100-SUMQ11 2010 200 2002 panon Epe Q Account som 11.00 To AN Cor Pre 15.300 18. Totalhadas 10 Instructions Exo Tips Common Formulas Financials 01 02 os DUO Ratio Cross Pront Ratio 04 25-7 Oukience Questions kar GIV Automatic Zoom 8013 LUX Hotel Co. Statement of Financial December 31, 20xx 20XX-1 20XX-2 (CY) (PY) (2 yrs ago) (Rounded to Thousands) 5,100 4,000 5,700 3,000 5,400 2,500 Assets Cash and cash equivalents Inventories Accounts receivable (Net of $124K, $100K, $85K allowance for uncollectible Accts.) Property Plan & Equipment (Net of Accum. Depr. Of $5.7M, $4.4M. $3.1M) Other assets Total assets 4,500 3,500 3,250 21,200 3,000 37,800 46,700 3,100 62,000 46,700 2,700 60,550 Liabilities and Member's Equity Liabilities: Accounts payable and accrued expenses Other Payables Long Term Debt Total liabilities 1,500 1,000 18,700 21,200 1,500 1,000 43,500 46,000 800 900 43,500 45,200 Stockholder's Equity: Common Stock Ino Par Stock 1 million shares Paste B TU X X AD = y a Styles Styles Pane Dictate TI Stockholder's Equity: Common Stock (no Par Stock, 1 million shares outstanding) Retained Eamings Total Stockholder's Equity ng 15,300 1,300 16,600 14,600 1,400 16,000 14,050 1,300 15,350 Total liabilities and Stockholder's equity 37,800 62,000 60,550 See accompanying notes to financial statements. Year ended December 31, 20XX 20xx-1 20XX-2 20XX-3 (Rounded to Thousands) vab 15,500 Revenues LUX Hotel- Rental Revenue Inventory Sales (Net of Sales Returns and Discounts) 19,800 21,500 10,000 20,350 9,000 12,000 8,500 Total Revenues 27,500 31,500 29,350 28,300 ot tien 11,300 9,450 8,125 7,350 ni 830 507 505 500 min hel Expenses Cost of Goods Sold (Inventory sales) Legal, professional, audit, and regulatory fees Salary Expense Interest expense Depreciation & Amortization expense Other expenses Total Expenses Net Income 2,014 1,555 1,350 150 17,199 10,301 1,930 2,175 1,350 110 15,522 15,978 1,850 2,175 1,350 100 14,105 15,245 1,775 2,1 1,350 94 13,244 15,056 Commo n Stock Retaine d Earnings TOTAL Balance at December 31, 20XX-1 $14,600 $1,400 $16,000 Common Stock 700 700 Dividends Net Income (10,401) 10,301 $1,300 (10,401) 10,301 $16,600 Balance at December 31, 20XX $15,300 See accompanying notes to financial statements. 1. Organization and Nature of Business I LUX Hotel Co. (the "Company"), a subsidiary of Global LUX Hotel Co. (the "Parent"), was organized in December 1999 in the State of Delaware. A certain number of shares are traded on the NYSE and the company is registered with the SEC. The Company operates luxury hotel properties. The company is head quartered in Dubai, and its main hotel is operated on the Palm Island in Dubai. The company seeks tourists from around the world (Rental Revenue). The company also has another division that sells pictures, vases, home dcor, furniture from the middle east (Inventory Division). 2. Summary of Significant Accounting Policies Use of Estimates - The preparation of the financial statements in conformity with U.S. generally accepted accounting principles ("GAAP") requires management to make estimates and assumptions that affect the reported amounts of assets and liabilities and disclosure of contingent assets and liabilities at the date of the financial statements and the reported amounts of revenues and expenses during the rentina narind el f 01- NSWER For the balance sheet prepare a VERTICAL A(Do not perform this analysis for the cells colored black, only perform for the cells in yellow). Perform work in the table below LASE USE THE EXCEL FUNTIONALTY TO PERFORM THE ANALYSIS. DO NOT USE A CALCULATOR AND THEN TYPE YOUR ANSWER INTO THE CELLS Al the change in the accounts indicated below in welow. Think about what could be causing this change? What cances des trase for you? wartow Below Set Are Bevel Gran who on should look What she she would the war Anas mostly be performed? Pantin substantia completion 1 Brytan wystna) the Better to matemat wy did and cu ANSWER BALANCE STREET ERRE 2002 of Assets of Assets 20/0 20XX1 Ant Change Analysis of Change Investors 115 SN 15100 1700 4.000 3000 200 21200 200 3000 3100 12an OP Le Der SILOS 11.500 SO $1,000 1709 6118 Shareholders Stock Photo 15.300 14.00 11.10 2012 30 Instructions Decod Tips Common Forms Soldestinationwide INTERO Paste Financial 01 02 03 DS Ratio Gross Profit Ratio 04 05-7 Guidance Questions MacBook Air Home Exercise - Acrocedures. ACC 322 V2 (version 1). ab. AutoRecovered Review View Tell me Formulas Data Insert Draw Page Layout XF SUMO PMT 911 01- ANSWER for the balance sheet prepare VERTICAL Anal Do not perform the analysis for the cells colored black, only perform for the cells in yellow). Perform work in the below." PLEASE USE THE EXCEL FUNTIONALITY TO PERFORM THE ANALYSIS. DO NOT USE A CALCULATOR AND THEN TYPE YOUR ANSWER INTO THE CELLS Are the changin tersindicated below in Thabout what could be causing this conte? Wo does this raise for you? on the lowell. Ser Account Revalentemente 02- ANSWER whatsached would this analytic Vertical Anlamly be performed in the completion Portaplan whilsentence DE DOMINGO LANCERET Bered 19 20X20XX of Ass of Asset 20xx Change Analysis of Change and their nos 5% 13.00 31208 4000 2000 119 100-SUMQ11 2010 200 2002 panon Epe Q Account som 11.00 To AN Cor Pre 15.300 18. Totalhadas 10 Instructions Exo Tips Common Formulas Financials 01 02 os DUO Ratio Cross Pront Ratio 04 25-7 Oukience Questions kar GIV Automatic Zoom 8013 LUX Hotel Co. Statement of Financial December 31, 20xx 20XX-1 20XX-2 (CY) (PY) (2 yrs ago) (Rounded to Thousands) 5,100 4,000 5,700 3,000 5,400 2,500 Assets Cash and cash equivalents Inventories Accounts receivable (Net of $124K, $100K, $85K allowance for uncollectible Accts.) Property Plan & Equipment (Net of Accum. Depr. Of $5.7M, $4.4M. $3.1M) Other assets Total assets 4,500 3,500 3,250 21,200 3,000 37,800 46,700 3,100 62,000 46,700 2,700 60,550 Liabilities and Member's Equity Liabilities: Accounts payable and accrued expenses Other Payables Long Term Debt Total liabilities 1,500 1,000 18,700 21,200 1,500 1,000 43,500 46,000 800 900 43,500 45,200 Stockholder's Equity: Common Stock Ino Par Stock 1 million shares Paste B TU X X AD = y a Styles Styles Pane Dictate TI Stockholder's Equity: Common Stock (no Par Stock, 1 million shares outstanding) Retained Eamings Total Stockholder's Equity ng 15,300 1,300 16,600 14,600 1,400 16,000 14,050 1,300 15,350 Total liabilities and Stockholder's equity 37,800 62,000 60,550 See accompanying notes to financial statements. Year ended December 31, 20XX 20xx-1 20XX-2 20XX-3 (Rounded to Thousands) vab 15,500 Revenues LUX Hotel- Rental Revenue Inventory Sales (Net of Sales Returns and Discounts) 19,800 21,500 10,000 20,350 9,000 12,000 8,500 Total Revenues 27,500 31,500 29,350 28,300 ot tien 11,300 9,450 8,125 7,350 ni 830 507 505 500 min hel Expenses Cost of Goods Sold (Inventory sales) Legal, professional, audit, and regulatory fees Salary Expense Interest expense Depreciation & Amortization expense Other expenses Total Expenses Net Income 2,014 1,555 1,350 150 17,199 10,301 1,930 2,175 1,350 110 15,522 15,978 1,850 2,175 1,350 100 14,105 15,245 1,775 2,1 1,350 94 13,244 15,056 Commo n Stock Retaine d Earnings TOTAL Balance at December 31, 20XX-1 $14,600 $1,400 $16,000 Common Stock 700 700 Dividends Net Income (10,401) 10,301 $1,300 (10,401) 10,301 $16,600 Balance at December 31, 20XX $15,300 See accompanying notes to financial statements. 1. Organization and Nature of Business I LUX Hotel Co. (the "Company"), a subsidiary of Global LUX Hotel Co. (the "Parent"), was organized in December 1999 in the State of Delaware. A certain number of shares are traded on the NYSE and the company is registered with the SEC. The Company operates luxury hotel properties. The company is head quartered in Dubai, and its main hotel is operated on the Palm Island in Dubai. The company seeks tourists from around the world (Rental Revenue). The company also has another division that sells pictures, vases, home dcor, furniture from the middle east (Inventory Division). 2. Summary of Significant Accounting Policies Use of Estimates - The preparation of the financial statements in conformity with U.S. generally accepted accounting principles ("GAAP") requires management to make estimates and assumptions that affect the reported amounts of assets and liabilities and disclosure of contingent assets and liabilities at the date of the financial statements and the reported amounts of revenues and expenses during the rentina narind el
