construct a full statement of Cash flows and comment on each of the activities from the perspective of the potential investors.

• one set of comparative income statements (where "YTD" represents year two and "Last YTD" represents year one) and
• two balance sheets for the same periods.
• Please ignore the data in the income statement relating to "Last 3 months" and "Prior 3 months"

there is 2 years f the balance sheet

thank you

201 MASTER 8 9 & 10 Robin Reid 3 Months Summary Income for Dec Y2 Last 3 Months Prior 3 Months YTD Last YTD $ % $ % $ % $ % Revenue Rooms $2,517,775 62.37% $3,033,965 63.53% $10,401,132 61.89% $10,204,235 66.23% $1,247,018 30.89% $1,420,148 29.74% $5,276,757 31.4% $4,159,542 27.0% $271,789 6.73% $321,532 6.73% $1,126,786 6.71% $1,044,170 6.78% $4,036,582 100% $4,775,645 100% $16,804,675 100% $15,407,946 100% Food & Beverage Other Departments Total Revenue Departmental Expenses Rooms Food & Beverage Other Departments Total Expenses Total Departmental Profit $804,832 31.97% $954,953 31.48% $3,247,590 31.22% $2,922,924 28.64% $867,251 69.55% $921,575 64.89% $3.528.215 66.86% $3,141,556 75.53% $230,025 84.63% $217,391 67.61% $810,569 71.94% $678,788 65.01% $1,902, 107 47.12% $2,093,919 43.85% $7,586,374 45.14% $6,743,268 43.76% $2,134,474 52.88% $2,681,726 56.15% $9,218,301 54.86% $8,664,678 56.24% Undistributed Expenses Marketing & Sales $ 730,560 18.1% $768,060 16.08% $2,953,740 17.58% $1,989,543 12.91% Administrative and General $451,540 11.19% $474,198 9.93% $1,841,388 10.96% $1,857,939 12.06% $127,555 3.16% $143,950 3.01% $527,170 3.14% $524,620 3.4% Property Operations and Maintenance Total Undistributed Expenses Gross Operating Profit $1,309,655 32.44% $1,386,208 29.03% $5,322,298 31.67% $4,372, 102 28.38% $824,820 20.43% $1,295,518 27.13% $3,896,003 23.18% $4,292,576 27.86% Less: Management Fees Base Fee $80,732 2.0% $95,513 2.0% $336,093 2.0% $308, 159 2.0% Incentive Fee $57,737 1.43% $90,686 1.9% $272,720 1.62% $300,480 1.95% $686,351 17.0% $1,109,319 23.23% $3,287,190 19.56% $3,683,937 23.91% Income before fixed charges Fixed Charges Property Taxes $60,000 1.49% $60,000 1.26% $240,000 1.43% $240,000 1.56% $30,000 0.74% $30,000 0.63% $120,000 0.71% $120,000 0.78% Insurance Property Depreciation Building $303,868 7.53% $304,503 6.38% $1,223,255 7.28% $1,255,732 8.15% $104,420 2.59% $104,671 2.19% $416,658 2.48% $366,273 2.38% Property Depreciation FF&E Total Fixed Charges Net Operating Income $498,288 12.34% $499,174 10.45% $1,999,913 11.9% $1,982,004 12.86% $188,063 4.66% $610,145 12.78% $1,287,277 7.66% $1,701,933 11.05% Other Income $16,200 $16,200 $64,800 $40,200 Total Income $204,263 $626,345 $1,352,077 $1,742,133 Income Tax $51,066 25.0% $156,586 25.0% $338,019 25.0% $435,533 25.0% Net Profit $153,197 3.78% $469,759 9.8% $1,014.058 6.01% $1,306,599 8.46% Robin Reid 201 MASTER 8 9 & 10 Balance Sheet for Dec Y2 Hotel Aman Hotel Amyp Hotel Blue Pacific Hotel Omega Show all Hotel Amyp Current Assets Cash $90,750 $1,522,173 Inventories Accounts Receivable $1,063,794 $2,676,718 Total Current Assets Restricted Cash $313,131 $0 $313,131 $35,000,000 Replacement Reserve Borrowed Capital Total Restricted Cash Long Term Assets Building Property & Equipment Plus: Building Capital Additions Less: Building Depreciation FF&E Property & Equipment Plus: FF&E Capital Additions Less: FF&E Depreciation Net Long Term Assets $1,156,000 $2,478,987 $5,000,000 $1,524,500 $782,930 $39,418,583 Total Assets $42,408,432 $347,775 Current Liabilities Accounts Payable Taxes Payable Total Current Liabilities Long Term Liabilities $0 $347,775 Bank Loan $14,625,000 Owners Equity Share Capital Retained Earnings Total Owners Equity $15,000,000 $12,435,657 $27,435,657 Total Liabilities & Equity $42,408,432 21:08