Answer To: Microsoft Word - HOS802 A3 - Group Report.docx Page 1 of 5 Subject Title Hospitality Management...
Aarti J answered on Jun 01 2021
CFS
Year 4 Year 3 Year 2 Year 1
Current Year Last Year Current Year Last Year Current Year Last Year Current Year Last Year
$ $ $ $ $ $ $ $
Cash Flows from Operating Activities Cash Flows from Operating Activities Cash Flows from Operating Activities Cash Flows from Operating Activities
Guest Receipts 16,822,869 14,800,634 Guest Receipts 14,800,634 13,116,357 Guest Receipts 13,116,357 6,350,788 Guest Receipts 6,350,788 3,340,655
Other Receipts 30,553 28,304 Other Receipts 28,304 26,021 Other Receipts 26,021 14,411 Other Receipts 14,411 0
Payroll Disbursements 2,822,477 2,989,052 Payroll Disbursements 2,989,052 2,685,587 Payroll Disbursements 2,685,587 1,634,537 Payroll Disbursements 1,634,537 1,103,323
Interest Paid 1,398,058 2,265,266 Interest Paid 2,265,266 1,349,595 Interest Paid 1,349,595 444,721 Interest Paid 444,721 164,042
Income Tax Paid 704,099 106,244 Income Tax Paid 106,244 0 Income Tax Paid 0 0 Income Tax Paid 0 0
Other Operating Activities 7,363,243 5,668,525 Other Operating Activities 5,668,525 6,581,492 Other Operating Activities 6,581,492 2,843,364 Other Operating Activities 2,843,364 1,591,230
Net Cash Provided By (Used In) Operating Activities 4,565,545 3,799,851 Net Cash Provided By (Used In) Operating Activities 3,799,851 2,525,704 Net Cash Provided By (Used In) Operating Activities 2,525,704 1,442,577 Net Cash Provided By (Used In) Operating Activities 1,442,577 482,060
Cash Flows from Investing Activities Cash Flows from Investing Activities Cash Flows from Investing Activities Cash Flows from Investing Activities
Capital Expenditures 0 6,962,911 Capital Expenditures 6,962,911 3,841,495 Capital Expenditures 3,841,495 6,583,475 Capital Expenditures 6,583,475 0
Other Investing Activities 0 0 Other Investing Activities 0 0 Other Investing Activities 0 0 Other Investing Activities 0 0
Net Cash Provided By (Used In) Investing Activities 0 6,962,911 Net Cash Provided By (Used In) Investing Activities 6,962,911 3,841,495 Net Cash Provided By (Used In) Investing Activities 3,841,495 6,583,475 Net Cash Provided By (Used In) Investing Activities 6,583,475 0
Cash Flows from Financing Activities Cash Flows from Financing Activities Cash Flows from Financing Activities Cash Flows from Financing Activities
Proceeds from Debt or Equity Financing 0 0 Proceeds from Debt or Equity Financing 0 0 Proceeds from Debt or Equity Financing 0 1,565,784 Proceeds from Debt or Equity Financing 1,600,000 0
Debt Repayments 444,808 444,808 Debt Repayments 444,808 444,808 Debt Repayments 444,808 410,592 Debt Repayments 444,808 344,968
Dividends Paid 0 0 Dividends Paid 0 0 Dividends Paid 0 0 Dividends Paid 0 0
Other Financing Activities 0 0 Other Financing Activities 0 0 Other Financing Activities 0 0 Other Financing Activities 0 0
Net Cash Provided By (Used In) Financing Activities -444,808 -444,808 Net Cash Provided By (Used In) Financing Activities -444,808 -444,808 Net Cash Provided By (Used In) Financing Activities -444,808 1,155,192 Net Cash Provided By (Used In) Financing Activities 1,155,192 -344,968
INCREASE (DECREASE) IN CASH 4,794,283 -3,529,928 INCREASE (DECREASE) IN CASH -3,529,928 -1,786,620 INCREASE (DECREASE) IN CASH -1,786,620 -4,000,117 INCREASE (DECREASE) IN CASH -4,000,117 137,092
Cash Balance, Beginning of Period -9,060,817 -5,424,645 Cash Balance, Beginning of Period -5,424,645 -3,638,025 Cash Balance, Beginning of Period -3,638,025 362,092 Cash Balance, Beginning of Period 362,092 225,000
Cash Balance, End of Period -4,266,534 -8,954,573 Cash Balance, End of Period -8,954,573 -5,424,645 Cash Balance, End of Period -5,424,645 -3,638,025 Cash Balance, End of Period -3,638,025 362,092
Loan at Start of Period 3,370,608 3,815,416 Loan at Start of Period 3,815,416 4,260,224 Loan at Start of Period 4,260,224 3,105,032 Loan at Start of Period 3,105,032 3,450,000
Proceeds from Outside Borrowing 0 0 Proceeds from Outside Borrowing 0 0 Proceeds from Outside Borrowing 0 1,565,784 Proceeds from Outside Borrowing 1,600,000 0
Debt Service (Principal) 444,808 444,808 Debt Service (Principal) 444,808 444,808 Debt Service (Principal) 444,808 410,592 Debt Service (Principal) 444,808 344,968
Loan at End of Period 2,925,800 3,370,608 Loan at End of Period 3,370,608 3,815,416 Loan at End of Period 3,815,416 4,260,224 Loan at End of Period 4,260,224 3,105,032
Income
Year 4 Year 3 Year 2 Year 1
Current Year Last Year Current Year Last Year Current Year Last Year Current Year Last Year
$ $ $ $ $ $ $ $
Revenue Revenue Revenue Revenue
Rooms 11,523,657 9,417,456 Rooms 9,417,456 8,860,028 Rooms 8,860,028 4,310,461 Rooms 4,310,461 2,105,702
Food & Beverage 4,980,559 4,823,503 Food & Beverage 4,823,503 4,325,336 Food & Beverage 4,325,336 2,126,663 Food & Beverage 2,126,663 1,117,879
Other Operated Departments 693,134 667,321 Other Operated Departments 667,321 424,045 Other Operated Departments 424,045 135,295 Other Operated Departments 135,295 48,149
Other Revenue 0 0 Other Revenue 0 0 Other Revenue 0 0 Other Revenue 0 0
Total Revenue 17,197,350 14,908,280 Total Revenue 14,908,280 13,609,409 Total Revenue 13,609,409 6,572,419 Total Revenue 6,572,419 3,271,730
Expenditure Expenditure Expenditure Expenditure
Rooms 2,514,904 2,509,845 Rooms 2,509,845 2,266,915 Rooms 2,266,915 1,016,845 Rooms 1,016,845 629,891
Food & Beverage 2,656,116 2,903,654 Food & Beverage 2,903,654 2,481,131 Food & Beverage 2,481,131 1,579,626 Food & Beverage 1,579,626 866,495
Other Operated Departments 397,424 417,619 Other Operated Departments 417,619 319,307 Other Operated Departments 319,307 127,806 Other Operated Departments 127,806 31,274
Administrative & General 626,348 614,134 Administrative & General 614,134 593,284 Administrative & General 593,284 495,916 Administrative & General 495,916 395,031
Sales & Marketing 393,084 318,406 Sales & Marketing 318,406 279,993 Sales & Marketing 279,993 212,604 Sales & Marketing 212,604 148,000
Property Operation & Maintenance 3,219,980 1,321,797 Property Operation & Maintenance 1,321,797 3,693,097 Property Operation & Maintenance 3,693,097 878,358 Property Operation & Maintenance 878,358 438,972
Utilities 308,489 307,543 Utilities 307,543 275,147 Utilities 275,147 209,772 Utilities 209,772 217,642
Property Taxes &...