Please complete the Statement of Cash Flow. I also need to know how you got those answers.

Additional Information: Assume all current liabilities are paid on a timely basis. Retained earnings is comprised of Net Income less dividends. All purchases of property and equipment were in cash. Land with a book value of $2,000,000 was sold for $1,750,000. Equipment with a book value of $1,500,000 and accumulated depreciation of $500,000 was sold for $1,250,000. No dividends were declared or paid in 20X8. Summary Operating Statement For the Years Ending December 31, 20X7 and 20X8 20x7 20x8 Changes Operating Revenue Rooms Food and Beverage Other Operating Department Miscellaneous Income Total operating Revenue 9,606,479 5,332,155 1,100,832 447,213 16,486,679 58.37 10,037,650 32.325,460,000 6.724 1,155,000 2.72 385,000 100.0% 17,037,650 58.97 32.02 6.82 2.32 100.02 431,171 127,845 54.168 -62,213 550,971 4.57 2.42 4.92 -13.9% 3.32 Departmental Expenses Rooms Food and Beverage Other Operating Departments Total Departmental Expenses | 2,992,887 4,265,724 963,228 8,221,839 31.27 80.0% 87.5% 49.94 3,010,000 4,340,000 945,000 8,295,000 30.0% 79.52 81.82 48.72 17,113 74,276 -18,228 73,161 0.6% 1.72|| -1.92 0.94 Total Departmental Profit 8,264,840 50.1% 8,742,650 51.37 477,810 2.52 Undistributed Operating Expenses Administrative and General Information and Telecommunications Systems Sales and Marketing Property Operating and Maintenance Utilities Total Undistributed Expenses 1,335,421 263,787 1,187,041 527,574 741,901 4,055,724 8.14 1.64 7.22 3.22 4.52 4.54 1,363,012 255,565 1,209,673 681,506 749,657 4,259,413 8.04 154 7.12 4.02 4.42 25.0% 27,591 5.02 -8,222 -15% 22,632 4.12 153,932 27.94 7,756 L1.42 203,689 37.0%) Gross Operating Profit 4,209,116 25.5% 4,483,237 26.34 274.121 -34.5% Management Fees L 494,600 3.04 511,130 3.02 16,530 3.02 Income Before Non-Operating Income and 3,714,516 22,54 3,972,107 23.32 257,591 46.87 Non-Operating Income and Expenses Income Property and Other Taxes Insurance Other Total Non-Operating Income and Expenses -500,000 659,467 247,300 200,000 606,7671 -3.02 4.02 1.52 1.27 3.7% -250,000 664,468 272,602 -150,000 537,070 -1.52 250,000 3.92 5 ,001 1.62 25,302 -0.97 -350,000 3.2% -69.6971 45.42 0.92|| 4.62 -63.52|| -12.6% Earning Before Interest, Taxes, Depreciatiol 3,107,749 18.92 3,435,037/ 20.2% 327,288| 59.4% Replacement Reserve 1,318,934 1,788,815 8.02 10.9% 1,363,012 2,072,025 8.0% 44,078 12.22283,210 8.0%) 51.4% EBITDA less Replacement Reserve Rooms Sold Rooms Occupied Rooms in Hotel 34,401 35,656 35,000 36,752 125 125 Condensed Balance Sheet December 31, 20X7 and 20x8 20x8 Changes 20x7 5 % Assets Current Assets Cash Accounts Receivable Inventory Prepaids Total Current Assets 600,000 600,000/ 500,000 1,000,000 2,700,000 1.6% 1.6% 1.396 2.696 7.1% 400,000 500,000 100,000 200,000 1,200,000 1.04 1.29 0.296 0.59 2.9% -200,000 -100,000 -400,000 -800,000 -1,500,000 -33.396 -16.796 -80.096 -80.096 -55.6% Property and Equipment Land Building Equipment Accumulated Depreciation Net Property and Equipment 10,000,000 20,000,000 10,000,000 -7,000,000 33,000,000 26.496 10,000,000 52.89 24,000,000 26.496 12,000,000 -18.5% -7,761,033 87.196 38,238,967 24.0% 57.6% 4,000,000 28.896 2,000,000 -18.695 -761,033 91.896 5,238,967 0.096 20.096|| 20.096 10.996|| 15.996 0 Other Assets Goodwill Restricted Cash Total Other Assets 1,700,000 500,000 2,200,000 4,59 1.396 5.896 1,700,000 500,000 2,200,000 4. 19 1.296 5. 39 0 .096 0.09 0.0% 0 TOTAL ASSETS 37,900,000 100.0% 41,638,967 100.0% 3,738,967 -39.796 Liabilities & Owners' Equity Current Liabilities Accounts Payable Taxes Payable Current Portion of Mortgage Total Current Liabilities 800,000 600,000 1,250,000 2,650,000 2.19 500,000 1.696 800,000 3.396 1,250,000 7.095 2,650,000 1.49 1.996 3.096 6. 49 -200,000 200,000 0 0 -25.09 33.396|| 0.096 0.096 Mortgage Payable Long Term Bond Payable 9,000,000 2,000,000 23.79 538 7,750,000 2,000,000| 18.6% -1,250,000 4.8% -13.996 0.0% Common Stock Retained Earnings 20,000,000! 4,250,000 52.895 24,250,000 11.295 4,988,967 58.26 4,250,000 12.0% 738,967 21.39 17.495 Total Liabilities and Owners'Equity | 37,900,000 100.0% 41,638,967 100.0% 3,738,967 24.796 Statement of Cash Flows For The Year Ending December 31, 20x8 Net Cash Flow From Operating Activities: Net Income Adjustments to reconcile net income to net cash from operating activities: z Net Cash flow provide/(used) from operating activities Net Cash Flow from Investing Activities Net cash flow provided/(used) from investing activities Net Cash Flow from Financing Activities Net cash from provided/used from financing activities Net Increase in Cash During 20x8 Cash at the beginning of 20x8 Cash at the end of 20x8