Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Balance Sheet Information as of December 31st Starstruck Hotel 2016 2017 310,000 4,500,000 561,718 319,935 Accounts Payable Accumulated Depreciation equipment Retained Earnings Cash Cash Bank

image text in transcribedimage text in transcribed

Balance Sheet Information as of December 31st Starstruck Hotel 2016 2017 310,000 4,500,000 561,718 319,935 Accounts Payable Accumulated Depreciation equipment Retained Earnings Cash Cash Bank Balance for Capital Reserve (FFSE) (Hint: An FF&E Reserve shows on the Balance Sheet as both an Asset and a Liability) Accounts Receivable 300,000 5,000,000 2,957,708 77,669 3,339,951 7,528,058 8,525,999 Food and Beverage Inventories Operating Inventories 15 Year 8.5% Note Prepaid Insurance Investments (Long-term) Land 320,200 609,300 8,564,056 75,000 385,000 15,000,000 450,000 700,000 8,201,637 144,329 385,000 15,000,000 Capital One 6.5% Line of Credit (Hint: A Current Liability) Current Maturities of Long Term Debt Building Equipment Host Hotels and Resorts, LLC Member Accumulated Depreciation, Building Organization Pre-Opening Costs 25,000 332,986 260,000,000 19,930,000 14,209,233 260,000,000 250,000 25,000 362,419 260,000,000 20,200,000 14,209,233 260,000,000 200,000 Wages Payable 40,000 40,000 6,400,000 8,187,000 Thomas B. Mellor, LLC Member Colvin Mill Capital, LLC Member Contractual Escrow Reserve (offset expensed to P&L) 30-Year 10.5% Note 6,400,000 8,187,000 3,339,951 1,287,500 Starstruck Hotel Statement of Cash Flow for Year Ended 12/31/17 Hint: Don't forget the amortization of pre-opening expenses Cash Flow from Operations Net Income $ 3,395,990 Adj. to Determine Operating Cash Flow + Depreciation & Amortization Prepaid Insurance Food and Bever. Inventories Acct. Receive. Acct Payable Operating Inventories Ttl. Cash Flow from Operations 3,395,990 Cash Flox from Investments Tul. Cash Flow from Investments Cash Flow from Financing $ +/- Borrow/PayLT Debt Ttl Cash Flow from Financing - >>>>>>LT Debt Ending Balance Plus:Current Maturity of LT Debt Minus: LT Debt Beginning Balance LT Debt Addtl. Borrowed or Paid $ - 3,395,990 } This number should match the number in cellK31 - } This number should match the number in cell K29 Net Cash Flow 2017 Change in Cash on Balance Sheet $ 2016 2017 Current Ratio Formula: Current Assets/Current Liabilities Balance Sheet Information as of December 31st Starstruck Hotel 2016 2017 310,000 4,500,000 561,718 319,935 Accounts Payable Accumulated Depreciation equipment Retained Earnings Cash Cash Bank Balance for Capital Reserve (FFSE) (Hint: An FF&E Reserve shows on the Balance Sheet as both an Asset and a Liability) Accounts Receivable 300,000 5,000,000 2,957,708 77,669 3,339,951 7,528,058 8,525,999 Food and Beverage Inventories Operating Inventories 15 Year 8.5% Note Prepaid Insurance Investments (Long-term) Land 320,200 609,300 8,564,056 75,000 385,000 15,000,000 450,000 700,000 8,201,637 144,329 385,000 15,000,000 Capital One 6.5% Line of Credit (Hint: A Current Liability) Current Maturities of Long Term Debt Building Equipment Host Hotels and Resorts, LLC Member Accumulated Depreciation, Building Organization Pre-Opening Costs 25,000 332,986 260,000,000 19,930,000 14,209,233 260,000,000 250,000 25,000 362,419 260,000,000 20,200,000 14,209,233 260,000,000 200,000 Wages Payable 40,000 40,000 6,400,000 8,187,000 Thomas B. Mellor, LLC Member Colvin Mill Capital, LLC Member Contractual Escrow Reserve (offset expensed to P&L) 30-Year 10.5% Note 6,400,000 8,187,000 3,339,951 1,287,500 Starstruck Hotel Statement of Cash Flow for Year Ended 12/31/17 Hint: Don't forget the amortization of pre-opening expenses Cash Flow from Operations Net Income $ 3,395,990 Adj. to Determine Operating Cash Flow + Depreciation & Amortization Prepaid Insurance Food and Bever. Inventories Acct. Receive. Acct Payable Operating Inventories Ttl. Cash Flow from Operations 3,395,990 Cash Flox from Investments Tul. Cash Flow from Investments Cash Flow from Financing $ +/- Borrow/PayLT Debt Ttl Cash Flow from Financing - >>>>>>LT Debt Ending Balance Plus:Current Maturity of LT Debt Minus: LT Debt Beginning Balance LT Debt Addtl. Borrowed or Paid $ - 3,395,990 } This number should match the number in cellK31 - } This number should match the number in cell K29 Net Cash Flow 2017 Change in Cash on Balance Sheet $ 2016 2017 Current Ratio Formula: Current Assets/Current Liabilities

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Handbook Of Mortgage Backed Securities

Authors: Frank Fabozzi

6th Edition

0071460748, 978-0071460743

More Books

Students also viewed these Finance questions