Question

ДА F G H I J N O P Q R K L M For the Year of 2016 December 31, 2016 and 2015 Notes: 2016 2015 Change 7 $ 0 1 Assets Current A

$ $ 10,000 Liabilities and Owners Equity Current Liabilities Accounts Payable Dividends Payable Current Portion of LT Debt To

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;

  1. Dividends declared during 2016 were $50,000
  2. Other than a new building and new equipment, there were no other new investments purchased during 2016.
  3. The current portion of the long term debt at the end of 2016 was reclassified from non- current during 2016.
  4. No equipment or buildings were sold during 2016.
  5. Long term debt was borrowed to partially finance the building purchase.

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.

0 0
Add a comment Improve this question Transcribed image text
Answer #1
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
Add a comment
Know the answer?
Add Answer to:
You have been recently assigned as the new owner representative and asset manager at Capital Hotel...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The Statement of Cash Flows 215 Problem 14 sed balance sheets of the Spartan Inn are...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT