Please just do your best

Required:

Prepare, in good form, for the proprietary funds accounted for in the pictures/information given below, the following:

(1.c) A Statement of Cash Flows for the Year Ended December 31, 2020. Include restricted assets as a part of cash and cash equivalents for this statement. (Assume any materials and labor attributable to construction in process were paid by year end).

Given -

SOLVE -

1.c)

\begin{tabular}{|c|c|c|c|c|c|} \hline Stores and Services Internal S & und Closing & Entry & & & \\ \hline Account Title & Debits & Credits & \multirow{2}{*}{\multicolumn{2}{|c|}{ NET POSITION }} & \\ \hline supplies & & 312,000 & & & \\ \hline purchase & & 16,200 & 370,600 & 128,500 & Preclosing \\ \hline warehousing & & 16,900 & & 360,000 & closing entry \\ \hline delivery & & 17,500 & & & \\ \hline administrative expenses & & 8,000 & & & \\ \hline general fund & 310000 & & & 117,900 & \\ \hline \multirow[t]{2}{*}{ water utility } & 50,000 & & & & \\ \hline & \begin{tabular}{c} Net \\ Investment in \\ Capital Assets \end{tabular} & Restricted & Unrestricted & Total & \\ \hline \multicolumn{6}{|l|}{ Net Investment in Capital Assets } \\ \hline Capital Assets & & & & - & \\ \hline Less: Accumulated Depreciation & & & & - & \\ \hline Less: Advance from Enterprise fund & & & & - & \\ \hline Restricted & & & & - & \\ \hline \multirow[t]{2}{*}{ Unrestricted } & & & & - & \\ \hline & - & - & - & - & \\ \hline \end{tabular} Water and Sewer Enterprise Fund Closing Entry \begin{tabular}{|c|c|c|c|c|c|} \hline \multirow{3}{*}{\begin{tabular}{l} Account Title \\ revenue \\ depreciation expense \end{tabular}} & \multirow{3}{*}{\begin{tabular}{c} Debits \\ 1,062,000 \end{tabular}} & \multirow[t]{2}{*}{ Credits } & \multirow{2}{*}{\multicolumn{2}{|c|}{ NET POSITION }} & \multirow[b]{3}{*}{ Preclosing } \\ \hline & & & & & \\ \hline & & & & 959,000 & \\ \hline uncollectible accounts expense & 10,000 & & & 1,156,000 & closing entry \\ \hline interest expense & 162,500 & & & & \\ \hline cost of sales and services & 445,800 & & & & \\ \hline selling & 15,000 & & & & \\ \hline administration & 109,400 & & & & \\ \hline construction WIP & 99,300 & & & 2,115,000 & \\ \hline net position & & 1,156,000 & & & \\ \hline & \begin{tabular}{c} Net \\ Investment in \\ Capital Assets \end{tabular} & Restricted & Unrestricted & Total & \\ \hline Net Investment in Capital Assets & & & & & \\ \hline Capital Assets & & & & - & \\ \hline Less: Accumulated Depreciation & & & & - & \\ \hline Less: Revenue Bond Payable & & & & - & \\ \hline Restricted & & & & - & \\ \hline Unrestricted & & & & - & \\ \hline & - & - & - & - & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline & \begin{tabular}{c} Business-Type \\ Activities \\ Enterprise Funds \\ Water and Sewer \end{tabular} & \begin{tabular}{c} Governmental \\ Activities \\ Internal Service \\ Funds \end{tabular} \\ \hline \multicolumn{3}{|l|}{ Cash Flows from Operating Activities } \\ \hline \multicolumn{3}{|l|}{ Cash Received from Customers and Departments } \\ \hline \multicolumn{3}{|l|}{ Cash Paid to Suppliers and Employees } \\ \hline Net Cash Provided by Operating Activities & - & - \\ \hline \multicolumn{3}{|l|}{ Cash Flows from Capital Related Financing Activities } \\ \hline \multicolumn{3}{|l|}{ Acquisition of Capital Assets } \\ \hline \multicolumn{3}{|l|}{ Interest Paid on Long-term Debt } \\ \hline \multicolumn{3}{|l|}{ Partial Repayment of Advance from Enterprise Fund } \\ \hline Net Cash Used in Capital Related Financing Activities & - & - \\ \hline \multicolumn{3}{|l|}{ Cash Flows from Investing Activities } \\ \hline \multicolumn{3}{|l|}{ Partial Receipt of Advance to Internal Service Fund } \\ \hline Net Cash Provided from Investing Activities & - & - \\ \hline Net Increase (Decrease) in Cash & - & - \\ \hline \multicolumn{3}{|l|}{ Cash and Restricted Cash, January 1} \\ \hline Cash and Restricted Cash, December 31 & - & $ \\ \hline \multicolumn{3}{|c|}{ Reconciliation of Operating Income to Net Cash Provided by Operating Activities } \\ \hline \multicolumn{3}{|l|}{ Operating Income } \\ \hline \multicolumn{3}{|l|}{\begin{tabular}{l} Adjustments to Reconcile Operating Income to Net Cash \\ Provided by Operating Actitities \end{tabular}} \\ \hline \multicolumn{3}{|l|}{ Depreciation } \\ \hline \multicolumn{3}{|l|}{ (Increase) Decrease in Customer Accounts Receivable } \\ \hline \multicolumn{3}{|l|}{ (Increase)Decrease in Interfund Receivables } \\ \hline \multicolumn{3}{|l|}{ (Increase) Decrease in Inventories } \\ \hline \multicolumn{3}{|l|}{ Increase (Decrease) in Accounts Payable } \\ \hline \multicolumn{3}{|l|}{ Increase (Decrease) in Payroll Taxes Payable } \\ \hline \multicolumn{3}{|l|}{ Increase (Decrease) in Interfund Liabilities } \\ \hline Net Cash Provided by Operating Activities & & $ \\ \hline Non-cash investing, capital, and financing activities: & 0 & 0 \\ \hline \end{tabular} STORES AND SERVICES INTERNAL SERVICE FUND \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\multicolumn{2}{|c|}{ reference }} & & & \multirow{3}{*}{ Debits } & \multirow{3}{*}{ Credits } & & & & & & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{c} INVENTORY OF \\ SUPPLIES \end{tabular}}} & & & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{c} DUE FROM \\ OTHER FUNDS \\ \end{tabular}}} & \multirow[b]{3}{*}{bb} & \multirow[b]{3}{*}{ bb } & & \\ \hline & & \multicolumn{2}{|r|}{ Account Titles } & & & & \multicolumn{2}{|c|}{ CASH } & & & & & & & & & & & \multicolumn{2}{|c|}{ LAND } \\ \hline & & & & & & bb & 32,000 & 30,000 & & bb & 27,500 & 296,960 & & bb & 27,000 & 50,000 & & & 18,000 & \\ \hline \multirow[t]{36}{*}{6C1} & 1 & N/A & & & & & 27,000 & 367,500 & & & 312,000 & & & & 46,400 & & & & & \\ \hline & & & & & & & 360,000 & & & & & & & & & & & & & \\ \hline & 2 & Cash & & 27,000 & & & & & & & & & & & & & & & & \\ \hline & & \multicolumn{2}{|c|}{ accounts receivable } & & 27,000 & & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & & & & & & \\ \hline & 3 & \multicolumn{2}{|c|}{ supplies } & 312,000 & & & 21,500 & & & & 42,540 & & & & 23,400 & & & & 18,000 & \\ \hline & & \multicolumn{2}{|c|}{ accounts payable } & & 312,000 & & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & & & & & & \\ \hline & 4 & \multicolumn{2}{|c|}{ advance from water utility fund } & 30,000 & & & & & & & \multicolumn{3}{|c|}{ ACCUMULATED DEPR' } & & & & & & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{c} ACCUMULATED DEPR' \\ EQUIPMENT \end{tabular}}} \\ \hline & & cash & & & 30,000 & & \multicolumn{2}{|c|}{ BUILDINGS } & & & \multicolumn{2}{|c|}{ BUILDINGS } & & & EQUIF & NT & & & & \\ \hline & & & & & & bb & 80,000 & & & & & 28,000 & bb & bb & 46,000 & & & & & 25,000 \\ \hline & 5 & gener & fund & 250,560 & & & & & & & & 8,400 & & & & & & & & 6,200 \\ \hline & & water & lity fund & 46,400 & & & & & & & & & & & & & & & & \\ \hline & & invent & & & 296,960 & & & & & & & & & & & & & & & \\ \hline & & & & & & & 80,000 & & & & & 36,400 & & & 46,000 & & & & & 31,200 \\ \hline & 6 & purch & & 16,200 & & & & & & & & & & & & & & & & \\ \hline & & warel & using & 16,900 & & & & & & & ADVAN & E FROM & & & NET & SITION & & & & \\ \hline & & delive & & 17,500 & & & ACCOUNTS & YYABLE & & & ENTERPR & SE FUND & & & (beg & ing) & & & & \\ \hline & & admin & rative expense & 8,000 & & & 367,500 & 19,000 & bb & & 30,000 & 30,000 & bb & & & 128,500 & bb & & & \\ \hline & & accou & payable & & 58,600 & & & 312,000 & & & & & & & & & & & & \\ \hline & & & & & & & & 58,600 & & & & & & & & & & & & \\ \hline & 7 & cash & & 360,000 & & & & & & & & & & & & & & & & \\ \hline & & gener & fund & & 310,000 & & & & & & & & & & & & & & & \\ \hline & & water & tility & & 50,000 & & & 22,100 & & & & \begin{tabular}{l} - \\ - \end{tabular} & & & & 128,500 & & & & \\ \hline & & & & & & & & & & & & & & & & & & & & \\ \hline & 8 & accou & payable & 367,500 & & & & & & & & & & & & & & & & \\ \hline & & cash & & & 367,500 & & REVENL & - CHARG & SES & & OPERATIN & EXPENSE & & & OPERATII & EXENSES & & & OPERATIN & EXPENSES \\ \hline & & & & & & & FOR SALES & SERVICES & & & COST OF S & LES \& SER & & & ADMINIS & ATION & & & DEPRE & ATION \\ \hline & 9 & depre & tion & 14,600 & & & & & & & & & & & 8,000 & & & & 14,600 & \\ \hline & & accum & ated depreciation building & & 8,400 & & & & & & & & & & & & & & & \\ \hline & & accum & ated depreciation equipment & & 6,200 & & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & & & & & & \\ \hline & & & & & & & & \begin{tabular}{l} - \\ - \end{tabular} & & & \begin{tabular}{l} - \\ - \end{tabular} & & & & 8,000 & & & & 14,600 & \\ \hline & & & & & & & & & & & & & & & & & & & & \\ \hline & & & & & & & & & Tot & l De & bits & 254,040 & & & & & & & & \\ \hline & & & & & & & & & Tot & Cr & edits & 218,200 & & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline Stores and Services Internal S & und Closing & Entry & & & \\ \hline Account Title & Debits & Credits & \multirow{2}{*}{\multicolumn{2}{|c|}{ NET POSITION }} & \\ \hline supplies & & 312,000 & & & \\ \hline purchase & & 16,200 & 370,600 & 128,500 & Preclosing \\ \hline warehousing & & 16,900 & & 360,000 & closing entry \\ \hline delivery & & 17,500 & & & \\ \hline administrative expenses & & 8,000 & & & \\ \hline general fund & 310000 & & & 117,900 & \\ \hline \multirow[t]{2}{*}{ water utility } & 50,000 & & & & \\ \hline & \begin{tabular}{c} Net \\ Investment in \\ Capital Assets \end{tabular} & Restricted & Unrestricted & Total & \\ \hline \multicolumn{6}{|l|}{ Net Investment in Capital Assets } \\ \hline Capital Assets & & & & - & \\ \hline Less: Accumulated Depreciation & & & & - & \\ \hline Less: Advance from Enterprise fund & & & & - & \\ \hline Restricted & & & & - & \\ \hline \multirow[t]{2}{*}{ Unrestricted } & & & & - & \\ \hline & - & - & - & - & \\ \hline \end{tabular} Water and Sewer Enterprise Fund Closing Entry \begin{tabular}{|c|c|c|c|c|c|} \hline \multirow{3}{*}{\begin{tabular}{l} Account Title \\ revenue \\ depreciation expense \end{tabular}} & \multirow{3}{*}{\begin{tabular}{c} Debits \\ 1,062,000 \end{tabular}} & \multirow[t]{2}{*}{ Credits } & \multirow{2}{*}{\multicolumn{2}{|c|}{ NET POSITION }} & \multirow[b]{3}{*}{ Preclosing } \\ \hline & & & & & \\ \hline & & & & 959,000 & \\ \hline uncollectible accounts expense & 10,000 & & & 1,156,000 & closing entry \\ \hline interest expense & 162,500 & & & & \\ \hline cost of sales and services & 445,800 & & & & \\ \hline selling & 15,000 & & & & \\ \hline administration & 109,400 & & & & \\ \hline construction WIP & 99,300 & & & 2,115,000 & \\ \hline net position & & 1,156,000 & & & \\ \hline & \begin{tabular}{c} Net \\ Investment in \\ Capital Assets \end{tabular} & Restricted & Unrestricted & Total & \\ \hline Net Investment in Capital Assets & & & & & \\ \hline Capital Assets & & & & - & \\ \hline Less: Accumulated Depreciation & & & & - & \\ \hline Less: Revenue Bond Payable & & & & - & \\ \hline Restricted & & & & - & \\ \hline Unrestricted & & & & - & \\ \hline & - & - & - & - & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline & \begin{tabular}{c} Business-Type \\ Activities \\ Enterprise Funds \\ Water and Sewer \end{tabular} & \begin{tabular}{c} Governmental \\ Activities \\ Internal Service \\ Funds \end{tabular} \\ \hline \multicolumn{3}{|l|}{ Cash Flows from Operating Activities } \\ \hline \multicolumn{3}{|l|}{ Cash Received from Customers and Departments } \\ \hline \multicolumn{3}{|l|}{ Cash Paid to Suppliers and Employees } \\ \hline Net Cash Provided by Operating Activities & - & - \\ \hline \multicolumn{3}{|l|}{ Cash Flows from Capital Related Financing Activities } \\ \hline \multicolumn{3}{|l|}{ Acquisition of Capital Assets } \\ \hline \multicolumn{3}{|l|}{ Interest Paid on Long-term Debt } \\ \hline \multicolumn{3}{|l|}{ Partial Repayment of Advance from Enterprise Fund } \\ \hline Net Cash Used in Capital Related Financing Activities & - & - \\ \hline \multicolumn{3}{|l|}{ Cash Flows from Investing Activities } \\ \hline \multicolumn{3}{|l|}{ Partial Receipt of Advance to Internal Service Fund } \\ \hline Net Cash Provided from Investing Activities & - & - \\ \hline Net Increase (Decrease) in Cash & - & - \\ \hline \multicolumn{3}{|l|}{ Cash and Restricted Cash, January 1} \\ \hline Cash and Restricted Cash, December 31 & - & $ \\ \hline \multicolumn{3}{|c|}{ Reconciliation of Operating Income to Net Cash Provided by Operating Activities } \\ \hline \multicolumn{3}{|l|}{ Operating Income } \\ \hline \multicolumn{3}{|l|}{\begin{tabular}{l} Adjustments to Reconcile Operating Income to Net Cash \\ Provided by Operating Actitities \end{tabular}} \\ \hline \multicolumn{3}{|l|}{ Depreciation } \\ \hline \multicolumn{3}{|l|}{ (Increase) Decrease in Customer Accounts Receivable } \\ \hline \multicolumn{3}{|l|}{ (Increase)Decrease in Interfund Receivables } \\ \hline \multicolumn{3}{|l|}{ (Increase) Decrease in Inventories } \\ \hline \multicolumn{3}{|l|}{ Increase (Decrease) in Accounts Payable } \\ \hline \multicolumn{3}{|l|}{ Increase (Decrease) in Payroll Taxes Payable } \\ \hline \multicolumn{3}{|l|}{ Increase (Decrease) in Interfund Liabilities } \\ \hline Net Cash Provided by Operating Activities & & $ \\ \hline Non-cash investing, capital, and financing activities: & 0 & 0 \\ \hline \end{tabular} STORES AND SERVICES INTERNAL SERVICE FUND \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline \multirow{2}{*}{\multicolumn{2}{|c|}{ reference }} & & & \multirow{3}{*}{ Debits } & \multirow{3}{*}{ Credits } & & & & & & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{c} INVENTORY OF \\ SUPPLIES \end{tabular}}} & & & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{c} DUE FROM \\ OTHER FUNDS \\ \end{tabular}}} & \multirow[b]{3}{*}{bb} & \multirow[b]{3}{*}{ bb } & & \\ \hline & & \multicolumn{2}{|r|}{ Account Titles } & & & & \multicolumn{2}{|c|}{ CASH } & & & & & & & & & & & \multicolumn{2}{|c|}{ LAND } \\ \hline & & & & & & bb & 32,000 & 30,000 & & bb & 27,500 & 296,960 & & bb & 27,000 & 50,000 & & & 18,000 & \\ \hline \multirow[t]{36}{*}{6C1} & 1 & N/A & & & & & 27,000 & 367,500 & & & 312,000 & & & & 46,400 & & & & & \\ \hline & & & & & & & 360,000 & & & & & & & & & & & & & \\ \hline & 2 & Cash & & 27,000 & & & & & & & & & & & & & & & & \\ \hline & & \multicolumn{2}{|c|}{ accounts receivable } & & 27,000 & & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & & & & & & \\ \hline & 3 & \multicolumn{2}{|c|}{ supplies } & 312,000 & & & 21,500 & & & & 42,540 & & & & 23,400 & & & & 18,000 & \\ \hline & & \multicolumn{2}{|c|}{ accounts payable } & & 312,000 & & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & & & & & & \\ \hline & 4 & \multicolumn{2}{|c|}{ advance from water utility fund } & 30,000 & & & & & & & \multicolumn{3}{|c|}{ ACCUMULATED DEPR' } & & & & & & \multirow{2}{*}{\multicolumn{2}{|c|}{\begin{tabular}{c} ACCUMULATED DEPR' \\ EQUIPMENT \end{tabular}}} \\ \hline & & cash & & & 30,000 & & \multicolumn{2}{|c|}{ BUILDINGS } & & & \multicolumn{2}{|c|}{ BUILDINGS } & & & EQUIF & NT & & & & \\ \hline & & & & & & bb & 80,000 & & & & & 28,000 & bb & bb & 46,000 & & & & & 25,000 \\ \hline & 5 & gener & fund & 250,560 & & & & & & & & 8,400 & & & & & & & & 6,200 \\ \hline & & water & lity fund & 46,400 & & & & & & & & & & & & & & & & \\ \hline & & invent & & & 296,960 & & & & & & & & & & & & & & & \\ \hline & & & & & & & 80,000 & & & & & 36,400 & & & 46,000 & & & & & 31,200 \\ \hline & 6 & purch & & 16,200 & & & & & & & & & & & & & & & & \\ \hline & & warel & using & 16,900 & & & & & & & ADVAN & E FROM & & & NET & SITION & & & & \\ \hline & & delive & & 17,500 & & & ACCOUNTS & YYABLE & & & ENTERPR & SE FUND & & & (beg & ing) & & & & \\ \hline & & admin & rative expense & 8,000 & & & 367,500 & 19,000 & bb & & 30,000 & 30,000 & bb & & & 128,500 & bb & & & \\ \hline & & accou & payable & & 58,600 & & & 312,000 & & & & & & & & & & & & \\ \hline & & & & & & & & 58,600 & & & & & & & & & & & & \\ \hline & 7 & cash & & 360,000 & & & & & & & & & & & & & & & & \\ \hline & & gener & fund & & 310,000 & & & & & & & & & & & & & & & \\ \hline & & water & tility & & 50,000 & & & 22,100 & & & & \begin{tabular}{l} - \\ - \end{tabular} & & & & 128,500 & & & & \\ \hline & & & & & & & & & & & & & & & & & & & & \\ \hline & 8 & accou & payable & 367,500 & & & & & & & & & & & & & & & & \\ \hline & & cash & & & 367,500 & & REVENL & - CHARG & SES & & OPERATIN & EXPENSE & & & OPERATII & EXENSES & & & OPERATIN & EXPENSES \\ \hline & & & & & & & FOR SALES & SERVICES & & & COST OF S & LES \& SER & & & ADMINIS & ATION & & & DEPRE & ATION \\ \hline & 9 & depre & tion & 14,600 & & & & & & & & & & & 8,000 & & & & 14,600 & \\ \hline & & accum & ated depreciation building & & 8,400 & & & & & & & & & & & & & & & \\ \hline & & accum & ated depreciation equipment & & 6,200 & & & & & & & & & & & & & & & \\ \hline & & & & & & & & & & & & & & & & & & & & \\ \hline & & & & & & & & \begin{tabular}{l} - \\ - \end{tabular} & & & \begin{tabular}{l} - \\ - \end{tabular} & & & & 8,000 & & & & 14,600 & \\ \hline & & & & & & & & & & & & & & & & & & & & \\ \hline & & & & & & & & & Tot & l De & bits & 254,040 & & & & & & & & \\ \hline & & & & & & & & & Tot & Cr & edits & 218,200 & & & & & & & & \\ \hline \end{tabular}