The Village of Parry reported the following for its Print Shop
Fund for the year ended April 30, 2017.
VILLAGE OF PARRY—PRINT SHOP FUND | ||||||||
Statement of Revenues, Expenses, and Changes in Net Position | ||||||||
For the Year Ended April 30, 2017 | ||||||||
Operating revenues: | ||||||||
Charges for services | $ | 1,110,000 | ||||||
Operating expenses: | ||||||||
Salaries and benefits | $ | 500,000 | ||||||
Depreciation | 303,000 | |||||||
Supplies used | 202,000 | |||||||
Utilities | 72,700 | |||||||
Total operating expenses | 1,077,700 | |||||||
Income from operations | 32,300 | |||||||
Nonoperating income (expenses): | ||||||||
Interest revenue | 3,400 | |||||||
Interest expense | (5,500 | ) | ||||||
Total nonoperating expenses | (2,100 | ) | ||||||
Income before transfers | 30,200 | |||||||
Transfers in | 190,000 | |||||||
Changes in net position | 220,200 | |||||||
Net position—beginning | 1,124,000 | |||||||
Net position—ending | $ | 1,344,200 | ||||||
The Print Shop Fund records also revealed the following:
1. | Contribution from General Fund for working capital needs | $ | 86,000 | ||
2. | Contribution from General Fund for purchase of equipment | 104,000 | |||
3. | Loan (interest-free) from Water Utility Fund for purchase of equipment | 304,000 | |||
4. | Purchase of equipment | (504,000 | ) | ||
5. | Purchase of one-year investments | (54,000 | ) | ||
6. | Paid off a bank loan outstanding at May 1, 2016 | (66,300 | ) | ||
The loan was for short-term
operating purposes and was the only interest-bearing debt outstanding |
|||||
7. | Signed a capital lease on April 30, 2017 | $ | 47,900 | ||
The following balances were observed in current asset and current
liability accounts. ( ) denote credit balances:
5/1/2016 | 4/30/2017 | |||||||
Cash | $ | 196,700 | $ | 383,100 | ||||
Accrued interest receivable | 300 | 800 | ||||||
Due from other funds | 40,000 | 58,000 | ||||||
Supplies | 0 | 0 | ||||||
Accrued salaries and benefits | (26,000 | ) | (36,000 | ) | ||||
Utility bills payable | (5,200 | ) | (8,000 | ) | ||||
Accounts payable (for supplies only) | (39,000 | ) | (31,000 | ) | ||||
Accrued interest payable | (2,800 | ) | 0 | |||||
Bank loan payable | (66,300 | ) | 0 | |||||
Prepare a Statement of Cash Flows for the Village of Parry Print
Shop Fund for the year ended April 30, 2017. Include the
reconciliation of operating income to net cash provided by
operating activities. (Amounts to be deducted should be
indicated by a minus sign.)
Cash Flow Statement :-
Cash Flow from Operating Activities :- | ||
Cash Received from Departments | 1092000 | |
Less : Salaries and Benefits Paid | (490000) | |
Less : Suppliers Paid | (210000) | |
Less : Utilities Paid | (69900) | (769900) |
Net Cash Flow from Operating Activity | 322100 | |
Cash Flow from Investing Activity :- | ||
Add : Interet Collection ($3400-$500) | 2900 | |
Less : Investments Purchase | (54000) | |
Net Cash Flow from Investing Activity | (51100) | |
Cash Flow from Non-Capital Financing Activities :- | ||
Less : Payment of Bank Loan Principal | (66300) | |
Add : Transfer for Working Capital | 86000 | |
Net Cash Flow from Non-Capital Financing Activities | 19700 | |
Cash Flow from Capital and Related Financing Activities :- | ||
Add : Transfer for Equipment Purchase | 104000 | |
Add : Loan from Water Utility | 304000 | |
Less : Purchase of Equipment | (504000) | |
Less : Interest Paid | (8300) | |
Net Cash Flow from Capital and Related Financing Activities | (104300) | |
Net Cash Increase | 186400 | |
Add : Beginning Cash Balance | 196700 | |
Ending Cash Balance | 383100 | |
Reconciliation of Operating Income :-
Particulars | Amount($) | Amount($) |
Operating Profit | 32300 | |
Adjustment :- | ||
Add : Depreciation | 303000 | |
Less : Increase in Accounts Receivable(other funds) | (18000) | |
Add : Increase in Salaries and Benefits Payable | 10000 | |
Less : Decrease in Accounts Payable | (8000) | |
Add : Increase in Utility Bills Payable | 2800 | 289800 |
Net Cash Flow from Operating Activity | 322100 |
The Village of Parry reported the following for its Print Shop Fund for the year ended...
The Village of Parry reported the following for its Print Shop Fund for the year ended April 30, 2017. VILLAGE OF PARRY—PRINT SHOP FUND Statement of Revenues, Expenses, and Changes in Net Position For the Year Ended April 30, 2017 Operating revenues: Charges for services $ 1,114,000 Operating expenses: Salaries and benefits $ 504,000 Depreciation 305,400 Supplies used 203,600 Utilities 73,300 Total operating expenses 1,086,300 Income from operations 27,700 Nonoperating income (expenses): Interest revenue 3,700 Interest expense (5,800 ) Total...
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2020, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund. Debits Credits Accounts payable $ 119,000 Accounts receivable $ 32,900 Accrued interest payable 36,100 Accumulated depreciation 54,500 Administrative and selling expenses 56,500 Allowance for uncollectible accounts 14,100 Capital assets 736,000 Cash 100,100 Charges for sales and services 583,000 Cost of sales and...
The Village of Lake George decided to establish an internal service fund to account for the operations of a Print Shop. The Print Shop is to begin operations on July 1, 2016 the first day of the City's fiscal year. During the fiscal year ended June 30, 2017 the following transactions occurred: The General Fund made a permanent contribution of $400,000 and a long-term advance of $800,000 to the Print Shop Fund. The advance is to be repaid by...
D (40 points) The Village of Lake George decided to establish an internal serviss fund to account for the operations of a Print Shop The Print Shop is to begin operations on July 1, 2016 the first day of the City's fiscal year During the fiscal year ended June 30, 2017 the following transactions occurred (a) The General Fund made a permanent contribution of $400,000 and a long-term advance of $800,000 to the Print Shop Fund The advance is to...
he Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2017, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund. Debits Credits Accounts payable $ 104,000 Accounts receivable $ 26,100 Accrued interest payable 29,200 Accumulated depreciation 47,000 Administrative and selling expenses 49,000 Allowance for uncollectible accounts 12,500 Capital assets 709,000 Cash 90,500 Charges for sales and services 555,000 Cost of sales and...
he Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2017, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund. Debits Credits Accounts payable $ 100,000 Accounts receivable $ 25,000 Accrued interest payable 28,000 Accumulated depreciation 45,000 Administrative and selling expenses 47,000 Allowance for uncollectible accounts 12,000 Capital assets 705,000 Cash 90,000 Charges for sales and services 550,000 Cost of sales and...
Enterprise Fund Journal Entries and Financial Statements. Following is the June 30, 2017, statement of net position for the City of Bay Lake Water Utility Fund. Page 301 Required A. For fiscal year 2017, prepare general journal entries for the Water Utility Fund using the following information. 1.The amount in the Accrued Utility Revenue account was reversed. 2.Billings to customers for water usage during fiscal year 2017 totaled $2,982,557; $193,866 of the total was billed to the General Fund. 3.Cash...
The Town of Weston has a Water Utility Fund with the following trial balance as of July 1, 2016, the first day of the fiscal year: Debits Credits Cash $ 337,000 Customer accounts receivable 204,200 Allowance for uncollectible accounts $ 30,700 Materials and supplies 122,800 Restricted assets (cash) 255,000 Utility plant in service 7,007,000 Accumulated depreciation—utility plant 2,607,000 Construction work in progress 107,000 Accounts payable 128,400 Accrued expenses payable 80,300 Revenue bonds payable 3,507,000 Net position 1,679,600 Totals $ 8,033,000...
The Town of St. John decided to establish an internal service fund to account for the operations of a Print Shop. The Print Shop is to begin operations on October 1, 2020 the first day of the City's fiscal year. During the fiscal year ended September 30, 2021 the following transactions occurred: The General Fund made a permanent contribution of $100,000 and a long term advance of $250,000 to the Print Shop Fund. The advance is to be repaid by...
O Required Information [The following information applies to the questions displayed below) The City of Saltwater Beach established an enterprise fund two years ago to construct and operate Tribute Aquatic Center, a public swimming pool. The pool was completed and began operations last year. All costs, including repayment of debt. are to be paid by user fees. The fund's preclosing trial balance for the current year, is shown below. Credits Debits $ 183,740 5,278 8,310 951,730 1,414,450 934,560 $ 42,...