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.

Please show direct and indirect method

Solutions

Expert Solution

Inglis City

Statement of cash flows
Amount $ Amount
Operating Activities
Receipt form sale of goods or services $        2,915,500
Payment for supplies $       (1,642,100)
Payment to employee for salaries $          (479,300)
Operating expense paid $            (89,200)
Transfer to general fund $            (25,000)
cash flow from operating activities $        679,900
Investing Activities
receipt of interest on investments $             42,000
acquisition of equity investment $            (75,000)
sale of equipment $             57,500
cash flow from investing activities $          24,900
Financing Activities
Grant received for summer ineterns $             50,000
Long term debt payments $          (525,000)
transfer to general fund $             25,000
cash flow from financing activities $       (450,000)
Net cash flows during the period $        254,800
Add: Beginning Cash balance $        895,635
Ending Cash Balance $     1,150,435

Since net income is not given, hence reconciliation with net income is not possible, hence indirect method is not possible, so, direct method cash flow statement is presented.


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