The CFO of your nonprofit left on vacation after preparing an income statement and balance sheet (See spreadsheet below)), but nobody can find the cash flow statement and he cannot be reached. Your boss wants you to create a quick summary statement of cash flows for last year (i.e. Year 2023) to share with the board.

1) Derive a cash flow statement that includes operating, investing, and financing cash flows from the other two statements.

2) Based on the resulting statement, what concerns do you have about the organizations cash management decisions? What recommendations might you make to improve it?

Income Statement Revenues Expenses Change in Net Assets Balance Sheet Assets Llabilities Net Assets Clients Served Staff, FTE Salaries Benefits Depreciation Utilities Supplies Travel Debt Service Miscellaneous Total 2023 $195,553$177,953$183,292 $128,000$175,000$249,000 \begin{tabular}{rrrrrr} $ & 16,431 & $ & 5,530 & $ & 49,806 \\ \hline$ & 339,984 & $ & 358,483 & $ & 482,098 \end{tabular} \begin{tabular}{rrrrrr} $ & 198,450 & $ & 244,373 & $ & 292,591 \\ $ & 59,535 & $ & 73,312 & $ & 87,77 \\ $ & 25,000 & $ & 25,000 & $ & 27,300 \\ $ & 14,922 & $ & 14,623 & $ & 14,331 \\ $ & 4,549 & $ & 4,867 & $ & 5,208 \\ $ & 5,025 & $ & 5,578 & $ & 6,191 \\ $ & 3,333 & $ & 3,333 & $ & 3,333 \\ $ & 6,735 & $ & 6,398 & $ & 6,078 \\ \hline$ & 317,549 & $ & 377,484 & $ & 442,809 \end{tabular} $ 22,435 (19,001)$ 39,289 2019 2020 2021 Cash Marketable Securities Accounts Recelvable Inventory Property, Net Long-term Investments Total Accounts Payable Mortgage Refundable Advances Uncollectable Accounts Total \begin{tabular}{rrrrrr} $ & 34,440 & $ & 36,507 & $ & 38,697 \\ $ & 28,775 & $ & 27,108 & $ & 25,442 \\ $ & 5,000 & $ & 12,000 & $ & 7,000 \\ $ & 1,206 & $ & 1,086 & $ & 1,194 \\ \hline$ & 69,421 & $ & 76,701 & $ & 72,333 \end{tabular} $1,180,609$1,161,608$1,200,897 187 229 247 6 7 8