You have been recently assigned as the new owner representative and asset manager at Capital Hotel Investments, Inc and will oversee 12 hotel properties including the Hilton Garden Inn of Tysons, VA.
Following a poor operational 2016 at the Hilton hotel at Tysons, Capital Hotel Investments’ CFO asked you to work with the Hilton’s property management to identify why the hotel’s cash position remains the same despite the realizing $300,000 gain on investments in 2016.
The property director of finance as informed you of the following;
The condensed balance sheets and income statements for the Hilton Garden Inn are attached. You are required to prepare a Statement of Cash Flow for 2016.
Cash Flow Statement | |||
Indirect Method | |||
Cash flow from Operating Activities | |||
Net Income | $ 2,90,000.00 | ||
Adjustments | |||
Depreciation | $ 4,00,000.00 | ||
Gain on sale of Investments | $ -3,00,000.00 | ||
Decrease in Accounts Receivable | $ -5,000.00 | ||
Increase in inventories | $ 5,000.00 | ||
Increase in Accounts payable | $ 10,000.00 | ||
Total Adjustments | $ 1,10,000.00 | ||
Cash from operating activities | $ 4,00,000.00 | ||
Cash flow from Investing Activities | |||
Sale of investments | $ 3,40,000.00 | ||
Purchase of Building | $ -10,00,000.00 | ||
Purchase of Equipment | $ -1,00,000.00 | ||
Cash used in investing activities | $ -7,60,000.00 | ||
Cash flow from Financing Activities | |||
Payment of Long term debt | $ -1,00,000.00 | ||
Borrowing Long term debt | $ 5,00,000.00 | ||
Dividend Paid | $ -30,000.00 | ||
Cash from financing activities | $ 3,70,000.00 | ||
Net Increase in cash | $ 10,000.00 | ||
Opening Balance of Cash | $ 30,000.00 | ||
Closing Balance of Cash | $ 40,000.00 | ||
Cash paid for income taxes | $ 1,10,000.00 |
You have been recently assigned as the new owner representative and asset manager at Capital Hotel...
The Statement of Cash Flows 215 Problem 14 sed balance sheets of the Spartan Inn are as follows: The condensed bala Spartan Inn Condensed Balance Sheets December 31, 20X1 and 20X2 20X1 Assets Current Assets: 20X2 Cash $ $ Marketable Securities Accounts Receivable Inventory Total Current Assets Investments Property and Equipment: 30,000 50,000 100,000 20,000 200,000 100,000 40,000 50,000 95,000 25,000 210,000 60,000 500,000 5,000,000 1,000,000 (1,600,000) 4,900,000 $5,200,000 500,000 6,000,000 1,100,000 (2,000,000) 5,600,000 $5,870,000 Land Building Equipment Accumulated Depreciation...
Excel Online Structured Activity: Statement of cash flows You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year....
Excel Online Structured Activity: Statement of cash flows You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year....
You have just been hired as a financial analyst for Barrington Industries. Unfortunately, company headquarters (where all of the firm's records are kept) has been destroyed by fire. So, your first job will be to recreate the firm's cash flow statement for the year just ended. The firm had $100,000 in the bank at the end of the prior year, and its working capital accounts except cash remained constant during the year. It earned $5 million in net income during...
E7.14 Cash Flow Statement Conversion The Luh Company's 2020 cash flow statement appears below. LO in its functional currency. New Taiwan dollars (NTS). NT$100.000 45,000 (4,000) 24,000 (32,000) 133,000 THE LUH COMPANY Statement of Cash Flows For Year Ended December 31, 2020 (in millions) Operating Activities Net income................. Depreciation and amortization expense. ... Gain on sale of long-term investments ......... Decrease in other current operating assets.... Decrease in current operating liabilities... Cash provided by operating activities ........ Investing Activities Acquisition...
Please create a balance sheet based on the following income and cash flow statements: for 2016 Income Statement 2016 Sales 655,150 Expenses excluding depreciation and amortization 386,878 EBITDA 268,272 Depreciation and amortization 7,388 EBIT 260,884 Interest expense 8,574 EBT 252,310 Taxes (20%) 20% 50,462 Net income 201,848 Common dividends 12,554 Addition to retained earnings 189,294 Cash flow Statement 2016 Operating Activities 203,409 Net Income 201,848 Depreciation and amortization 7,388 Increase in accounts payable 7,652 Increase in accruals (wages, utilities etc.)...
Please calculate the following ratios: Market value added Market to book ratio Return on Asset The Home Depot, Inc. Cash Flow All numbers in thousands Period Ending 1/29/17 1/31/16 Net Income 7,957,000 7,009,000 Operating Activities, Cash Flows Provided By or Used In Depreciation 1,973,000 1,863,000 Adjustments To Net Income 267,000 100,000 Changes In Accounts Receivables -138,000 -181,000 Changes In Liabilities 654,000 1,151,000 Changes In Inventories -769,000 -546,000 Changes In Other Operating Activities -161,000 -23,000 Total Cash Flow From Operating Activities...
Cash flow statement Please provide formula/equation so i know how to solve for. Thank you! BUS 7013 - Managerial Accounting Cash Flow Statement Amount Calculations - Chapter 14 End of year Beginning of year Current year Change Income statement Balance sheet Cash Accounts receivable Inventory Prepaid expenses Total current assets Equipment, at cost Less: Accum. depreciation Net equipment Total assets 86,000 112,000 141,000 18,000 357,000 298,000 (100,000) 198,000 555,000 54,000 126,000 120,000 21,000 321,000 240,000 (76,000) 164,000 485,000 32,000 (14,000)...
Please provided formulas/equations, so I can learn how to solve for. Thank you! :) Cash Flow Statement Amount Calculations - Chapter 14 End of year Beginning of year Current year Income statement Balance sheet Cash Accounts receivable Inventory Prepaid expenses Total current assets Equipment, at cost Less: Accum. depreciation Net equipment Total assets 86,000 112,000 141,000 18,000 357,000 298,000 (100,000) 198,000 555,000 54,000 126,000 120,000 21,000 321,000 240,000 (76,000) 164,000 485.000 Change 32,000 (14,000) 21,000 (3,000) 36,000 58,000 (24,000) 34,000...
MC TRAVEL INC. Balance Sheet December 31, $ Restated 2020 Restated 2019 Change ASSETS-Current assets Cash Temporary investments Accounts receivable Allowance for doubtful accounts Total current assets 7,600,000 2,006,000 5,000,000 -200,000 14,406,000 5,040,000 1,900,000 3,700,000 -100,500 10,539,500 2,560,000 106,000 1,300,000 -99,500 3,866,500 Capital assets Land Building and equipment Accumulated depreciation Total capital assets 40,250,000 40,270,000 -5,175,000 75,345,000 15,250,000 40,072,000 -3,450,000 51,872,000 25,000,000 198,000 -1,725,000 23,473,000 Total assets 89,751,000 62,411,500 27,339,500 LIABILITIES AND SHAREHOLDERS' EQUITY Accounts payable Interest payable Income taxes...