Question

In: Accounting

E7-23 Enterprise Fund Statement of Cash Flows [LO 7-5] Inglis City had a beginning cash balance...

E7-23 Enterprise Fund Statement of Cash Flows [LO 7-5]

Inglis City had a beginning cash balance in its enterprise fund of $895,635. During 2017, the following transactions occurred:

1. Interest received on investments totaled $42,400.
2. The city acquired additional equity investments totaling $75,000.
3. A grant was received from the state in the amount of $50,000 for summer interns.
4. Receipts from sales of goods or services totaled $2,915,500.
5. Payments for supplies were made in the amount of $1,642,100.
6. Payments to employees for salaries amounted to $479,300.
7. Equipment was sold for $57,500. It had a book value of $56,625.
8. $25,000 was transferred to the General Fund.
9. Other cash expenses for operations were $89,200.
10. Long-term debt payments totaled $525,000.
Required

Prepare a statement of cash flows for the Inglis City enterprise fund.

Can you provide the reconciliation of operating income to net cash provided by operating activities

Solutions

Expert Solution

Solution

INGLIS CITYENTERPRISE FUND

STATEMENT OF CASH FLOWS

FOR THE YEAR ENDED DECEMBER 31, 2017

Particulars

Amount ($)

Amount ($)

Amount ($)

(A)Cash flows from operating activities:

Cash received from customers

2,915,500

Cash paid to:

Suppliers

(1,642,100)

Employees

(479,300)

Other

(89,200)

(2,210,600)

Net cash provided by operations

704,900

(B) CASH FLOWS FROM NON-CAPITAL FINANCING ACTIVITIES:

Grant from state for summer interns

50,000

Transfer to general fund

(25,000)

Net cash provided by noncapital financing activities

25,000

(C) CASH FLOWS FROM CAPITAL FINANCING ACTIVITIES:

Proceeds from sale of capital assets

57,500

Debt payment


(525,000)

Net cash used by capital financing activities

(467,500)

(D) CASH FLOWS FROM INVESTING ACTIVITIES:

Purchase of investments

(75,000)

Interest received on investments

42,400

Net cash provided by investing activities

(32,600)

NET INCREASE IN CASH AND CASH EQUIVALENTS (Total of A+ B+ C+D)

229,800

Add: CASH AND CASH EQUIVALENTS, 1/1/2017

895,635

CASH AND CASH EQUIVALENTS, 12/31/2017

1,125,435


Related Solutions

E7-23 Enterprise Fund Statement of Cash Flows [LO 7-5] Inglis City had a beginning cash balance...
E7-23 Enterprise Fund Statement of Cash Flows [LO 7-5] Inglis City had a beginning cash balance in its enterprise fund of $895,635. During 2017, the following transactions occurred: 1. Interest received on investments totaled $42,400. 2. The city acquired additional equity investments totaling $75,000. 3. A grant was received from the state in the amount of $50,000 for summer interns. 4. Receipts from sales of goods or services totaled $2,915,500. 5. Payments for supplies were made in the amount of...
Locate the errors in the following statement of cash flows. The cash balance at the beginning...
Locate the errors in the following statement of cash flows. The cash balance at the beginning of the year was $240,000. The cash balance at the end of the year may be incorrect. Also, other amounts may need to be changed from positive to negative, or from negative to positive. Shasta Inc. Statement of Cash Flows For the Year Ended December 31, 2016 1 Cash flows from operating activities: 2 Net income $360,000.00 3 Adjustments to reconcile net income to...
IFRS 23-7 Skysong Corporation has contracted with you to prepare a statement of cash flows. The...
IFRS 23-7 Skysong Corporation has contracted with you to prepare a statement of cash flows. The controller has provided the following information. December 31 2017 2016 Buildings $ –0– $28,550 Equipment 44,000 19,000 Patents 4,920 6,150 Investments –0– 2,900 Inventory 10,400 7,800 Accounts receivable 12,150 8,800 Cash 34,580 12,800 $ 106,050 $86,000 Share capital—ordinary $ 42,800 $32,800 Retained earnings 20,650 5,800 Allowance for doubtful accounts 2,900 4,300 Accumulated depreciation on equipment 1,900 4,300 Accumulated depreciation on buildings –0– 5,800 Accounts...
IFRS 23-7 Bridgeport Corporation has contracted with you to prepare a statement of cash flows. The...
IFRS 23-7 Bridgeport Corporation has contracted with you to prepare a statement of cash flows. The controller has provided the following information. December 31 2017 2016 Buildings $ –0– $29,850 Equipment 50,500 25,500 Patents 5,440 6,800 Investments –0– 3,550 Inventory 11,050 9,100 Accounts receivable 12,800 10,100 Cash 32,435 14,100 $ 112,225 $99,000 Share capital—ordinary $ 44,100 $34,100 Retained earnings 21,300 7,100 Allowance for doubtful accounts 3,550 5,600 Accumulated depreciation on equipment 2,550 5,600 Accumulated depreciation on buildings –0– 7,100 Accounts...
IFRS 23-7 Sandhill Corporation has contracted with you to prepare a statement of cash flows. The...
IFRS 23-7 Sandhill Corporation has contracted with you to prepare a statement of cash flows. The controller has provided the following information. December 31 2017 2016 Buildings $ –0– $29,250 Equipment 47,500 22,500 Patents 5,200 6,500 Investments –0– 3,250 Inventory 10,750 8,500 Accounts receivable 12,500 9,500 Cash 33,425 13,500 $ 109,375 $93,000 Share capital—ordinary $ 43,500 $33,500 Retained earnings 21,000 6,500 Allowance for doubtful accounts 3,250 5,000 Accumulated depreciation on equipment 2,250 5,000 Accumulated depreciation on buildings –0– 6,500 Accounts...
E7-1.   (Determining Cash Balance) (LO 1) The controller for Clint Eastwood Co. is attempting to determine the...
E7-1.   (Determining Cash Balance) (LO 1) The controller for Clint Eastwood Co. is attempting to determine the amount of cash to be reported on its December 31, 2017, balance sheet. The following information is provided. 1. Commercial savings account of $600,000 and a commercial checking account balance of $900,000 are held at First National Bank of Yojimbo. 2. Money market fund account held at Volonte Co. (a mutual fund organization) permits Eastwood to write checks on this balance, $5,000,000. 3. Travel...
Multistep income statement and balance sheet LO 7-1, 7-5 Use the following information to prepare a...
Multistep income statement and balance sheet LO 7-1, 7-5 Use the following information to prepare a multi-step income statement and a balance sheet for Sherman Equipment Co. for Year 2. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.) (Balance Sheet only: Items to be deducted must be indicated with a minus sign.) Salaries Expense $ 70,000 Operating Expenses $ 63,000 Common Stock 100,000 Cash Flow from Investing Activities 79,400 Notes...
The City of Comstock had a total General Fund balance of $1,400,000 at the end of...
The City of Comstock had a total General Fund balance of $1,400,000 at the end of its fiscal year. The year end balance sheet reports inventory of material and supplies of $60,000. City Council passed an ordinance that all revenue received from hotel occupancy taxes must be used for beautification projects in the City. The City received $280,000 in hotel occupancy taxes and spent $225,000 on beautification projects this year. The City received a Federal grant of $120,000 for specifically...
The statement of cash flows is not prepared the same as theincome statement or balance...
The statement of cash flows is not prepared the same as the income statement or balance sheet. The statement of cash flows requires that the net income must be converted from an accrual basis to a cash basis. This statement can be prepared in either of two ways - the Indirect method or the Direct method.What is the difference between preparing one compared to the other - and which do you feel is a better way to prepare this statement?Your...
An Enterprise Fund had the following selected accounts from a Statement of Revenues, Expenses, and Changes...
An Enterprise Fund had the following selected accounts from a Statement of Revenues, Expenses, and Changes in Fund Net Position: Charges for sales and Services $900,000 Operating Expenses: Supplies $160,000 Depreciation 75,000 Non-Operating revenues and expenses: Interest expense $ 85,000 Interest revenue 30,000 Gain on the sale of equip. 5,000 Balance in Selected Accounts: Beg. Ending Supplies $15,000 $20,000 Interest Receivable 1,000 3,000 Accounts Payable 22,000 12,000 Interest Payable 13,000 10,000 Capital Assets 900,000 845,000 Accumulated Depreciation 400,000 425,000 NOTE:...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT