AND 1- ANSWER: For the balance sheet prepare VERTICAL Analysis (Do not perform this analysis for the cells colored black, only perform for the cells in yellow). Perform work in the table below." PLEASE USE THE EXOIL FUNTIONALITY TO PERFORM THE ANALYSIS. (DO NOT USE A CALCULATOR AND THEN TYPE YOUR ANSWER INTO THE CELLS Anabte the change in the accounts indicated below in vellow. Think about what could be causing this chance? What concerns does this raise for you? Performans in the yellow cells below. Set As Hecellerne male of what tower should look like wat phase of the suit would this analytic Vertical Analysis) most likely be performed? (Plannin substantive, completion Pick 1) Briefly Explan why (1 sentence) Tree Substante cost would be used for the suditor to detect o material statement as the analyte wy detailed and provides y reliable ewidence ANSWER: BALANCE SHEET December 1, 2X NACE- th 20xx 20XX % of Assets of Assets 20xx 20XX-1 Anth Change Analysis of Change 11 5% 6% of the 55100 4.0001 3.000 45001 2.500 21,200 40700 3000l 527100 52290 Honde ter Tel ) Lorem Tee 51500 51.000 11100 21200 11.500 $1.000 1600 45.000 Common Stock Promos 15.500 14.800 10 ma 121122000 3 50 Instructions Excel Tips Common Formulas sady Financials Q1 02 03 OSO Ratio Gross Profit Ratio 04 Q5-7 Guidence Virtual Bookstore Pay 25 atv A Automatic Zoom 60113 LUX Hotel Co. Statement of Financial December 31, 20XX 20XX-1 20XX-2 (CY) (PY) (2yrs 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 800 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 900 43,500 45,200 Stockholder's Equity: Common Stock In Rar Stockel million shares wa SIGA 5,100 4,000 5,700 3,000 5,400 2,500 4,500 3,500 3,250 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 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 (no Par Stock, 1 million shares outstanding) Retained Earnings Total Stockholder's Equity 5,000 1,300 6,300 5,000 1,400 6,400 5,000 1,300 6,300 Total liabilities and Stockholder's equity 27,500 52,400 51,500 See accompanying notes to financial statements. 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 nared Aile Paste B TUX, X AD SE Styles Styles Pane Dictate TI Stockholder's Equity: Common Stock (no Par Stock, 1 million shares outstanding) Retained Eamings Total Stockholder's Equity 14,600 ang 15,300 1,300 16,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) vat 15,500 Revenues LUX Hotel- Rental Revenue Inventory Sales (Net of Sales Returns and Discounts) 21,500 20,350 19,800 12,000 10,000 9,000 8,500 Total Revenues 27,500 31,500 29,350 28,300 ties 11,300 9,450 8,125 7,350 ni 830 507 505 500 mins 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,175 1,350 94 13,244 15,056 AND 1- ANSWER: For the balance sheet prepare VERTICAL Analysis (Do not perform this analysis for the cells colored black, only perform for the cells in yellow). Perform work in the table below." PLEASE USE THE EXOIL FUNTIONALITY TO PERFORM THE ANALYSIS. (DO NOT USE A CALCULATOR AND THEN TYPE YOUR ANSWER INTO THE CELLS Anabte the change in the accounts indicated below in vellow. Think about what could be causing this chance? What concerns does this raise for you? Performans in the yellow cells below. Set As Hecellerne male of what tower should look like wat phase of the suit would this analytic Vertical Analysis) most likely be performed? (Plannin substantive, completion Pick 1) Briefly Explan why (1 sentence) Tree Substante cost would be used for the suditor to detect o material statement as the analyte wy detailed and provides y reliable ewidence ANSWER: BALANCE SHEET December 1, 2X NACE- th 20xx 20XX % of Assets of Assets 20xx 20XX-1 Anth Change Analysis of Change 11 5% 6% of the 55100 4.0001 3.000 45001 2.500 21,200 40700 3000l 527100 52290 Honde ter Tel ) Lorem Tee 51500 51.000 11100 21200 11.500 $1.000 1600 45.000 Common Stock Promos 15.500 14.800 10 ma 121122000 3 50 Instructions Excel Tips Common Formulas sady Financials Q1 02 03 OSO Ratio Gross Profit Ratio 04 Q5-7 Guidence Virtual Bookstore Pay 25 atv A Automatic Zoom 60113 LUX Hotel Co. Statement of Financial December 31, 20XX 20XX-1 20XX-2 (CY) (PY) (2yrs 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 800 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 900 43,500 45,200 Stockholder's Equity: Common Stock In Rar Stockel million shares wa SIGA 5,100 4,000 5,700 3,000 5,400 2,500 4,500 3,500 3,250 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 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 (no Par Stock, 1 million shares outstanding) Retained Earnings Total Stockholder's Equity 5,000 1,300 6,300 5,000 1,400 6,400 5,000 1,300 6,300 Total liabilities and Stockholder's equity 27,500 52,400 51,500 See accompanying notes to financial statements. 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 nared Aile Paste B TUX, X AD SE Styles Styles Pane Dictate TI Stockholder's Equity: Common Stock (no Par Stock, 1 million shares outstanding) Retained Eamings Total Stockholder's Equity 14,600 ang 15,300 1,300 16,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) vat 15,500 Revenues LUX Hotel- Rental Revenue Inventory Sales (Net of Sales Returns and Discounts) 21,500 20,350 19,800 12,000 10,000 9,000 8,500 Total Revenues 27,500 31,500 29,350 28,300 ties 11,300 9,450 8,125 7,350 ni 830 507 505 500 mins 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,175 1,350 94 13,244 15,056