Question

In: Accounting

The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31,...

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 $ 117,000
Accounts receivable $ 31,900
Accrued interest payable 35,100
Accumulated depreciation 53,500
Administrative and selling expenses 55,500
Allowance for uncollectible accounts 13,900
Capital assets 732,000
Cash 99,500
Charges for sales and services 579,000
Cost of sales and services 509,000
Depreciation expense 53,500
Due from General Fund 18,200
Interest expense 41,400
Interest revenue 6,200
Transfer in from General Fund 128,500
Bank note payable 628,500
Supplies inventory 20,700
Totals $ 1,561,700 $ 1,561,700

a. Prepare the reconciliation of operating income to net cash provided by operating activities that would appear at the bottom of the December 31 Statement of Cash Flows. Recall that the beginning balance of all assets and liabilities is zero.

b. . Prepare the Net Position section of the December 31 balance sheet. (Assume that the revenue bonds were issued to acquire capital assets and there are no restricted assets.)

Solutions

Expert Solution

Income Statement for the period ended 31.12.2020 Balance Sheet as on 31.12.2020
Particulars Amount Particulars Amount Liabilities Amount Amount Assets Amount Amount
sales and services 579000
Cost of goods sold 509000 Non Current Assets:
Transfer in from general fund 128500 Capital assets 732000
Gross profit 70000 -Due from general fund 18200 -depreciation 53500 678500
579000 579000 -Profit/(loss) 60300 50000
Gross profit 70000
Administrative and selling cost 55500 Bank note payable 628500
Depreciation 53500 Current Liabilities Current Assets:
Interest expenses 41400 Interest revenue 6200 Accounts payable 117000 Accounts receivable 31900
Allowance for uncollectible 13900 Accrued interest payable 35100 cash 99500
inventory 20700
830600 830600
Net profit -60300
90100 90100
Reconciliation station of Operating income and Operating cash flow
Particulars Note Amount
Cashflow from Operational activities
Operating Profit Before Tax -60300
Add
Depreciation 53500
Interest Expenses 41400
increase in accounts payable 117000
increase in accrued interest payable 35100
Less
Allowance for uncollectable accounts 13900
interest revenue 6200
increase in accounts receivables 31900
increase in inventory 20700
Cash Flow from the Operating activities 114000
Assumption: It is assumed that Bank note payable are non current liabilities and doesn’t come under the operating cash foow
ii) Net position as on 31.12.2020 is $ 50000 from the above balance sheet

Related Solutions

The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31,...
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 $ 96,000 Accounts receivable $ 32,000 Accrued interest payable 28,000 Accumulated depreciation 45,000 Administrative and selling expenses 47,000 Allowance for uncollectible accounts 12,000 Capital assets 712,000 Cash 89,000 Charges for sales and services 550,000 Cost of sales and...
The village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31,...
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 $ 103,000 Accounts receivable $ 25,800 Accrued interest payable 28,900 Accumulated depreciation 46,500 Administrative and selling expenses 48,500 Allowance for uncollectible accounts 12400 Capital assets 707,000 Cash 90,200 charges for sales and services 553,000 Cost of sales and...
The Village of Seaside Pines prepared the following General Fund Trial Balance as of December 31,...
The Village of Seaside Pines prepared the following General Fund Trial Balance as of December 31, 2017, the last day of its fiscal year. Control accounts are used for budgetary entries. Debits Credits Accounts Payable $  19,000 Allowance for Uncollectible Taxes 12,000 Appropriations (Control) 494,000 Budgetary Fund Balance 5,000 Cash $175,000 Deferred Inflows—Property Taxes 38,000 Due from Capital Projects Fund 5,000 Due to Debt Service Fund 17,000 Encumbrances 63,000 Estimated Revenue (Control) 534,000 Estimated Other Financing Uses (Control) 35,000 General Government...
qewrwfieaHOJIOFJOJW261erokgpwarofaw1615646w4489f84q9fw1e56 The following is the Trial Balance obtained from Round Enterprise as at 31 st. December...
qewrwfieaHOJIOFJOJW261erokgpwarofaw1615646w4489f84q9fw1e56 The following is the Trial Balance obtained from Round Enterprise as at 31 st. December 2009. Debit (RM). Credit (RM). Capital. 22,490 Cash at bank 16,000 Cash in hand 900 Inventory (as at 1st January 2009) 7,320 Account receivables. 8,200 Account payables 6,300 Fixture and fittings 4,800 Vehicles 32,000 Purchases 36,200 Sales 71,800 Returns 500 300 Commission received 1 ,660 Carriage outwards 460 Discount received 620 Carriage inwards 790 Provision for doubtful debt 800 Accumulated depreciation on vehicles. 3,200...
The trial balance for the General Fund of the City of Topeka as of December 31,...
The trial balance for the General Fund of the City of Topeka as of December 31, 2017 is presented below:      CITY OF TOPEKA The General Fund Adjusted Trial Balance - December 31, 2017 Debit Credit Cash 216,000 Property Tax Receivable 31,000 Estimated Uncollectible Taxes 8,000 Due from Trust Fund 41,000 Vouchers Payable 55,000 Reserve for Encumbrances 20,000 Unassigned Fund Balance 205,000 288,000 288,000 Transactions for the year ended December 31, 2018 are summarized as follows: 1. The City Council adopted...
An inexperienced bookkeeper prepared the following trial balance for Philip Browning, M.D., as of December 31,...
An inexperienced bookkeeper prepared the following trial balance for Philip Browning, M.D., as of December 31, 20XX. You have discovered the following errors in your review of the accounting records and need to prepare a corrected trial balance. Philip Browning, M.D. Trial Balance December 31, 20XX Debit Credit Cash 17,500 Medical Supplies 600 Medical Equipment 6,000 Accounts Payable 4,000 Philip Browning, Capital 30,000 Philip Browning, Drawing 1,000 Medical Fees 7,000 Rent Expense 2,500 Salaries Expense 2,000 Utilities Expense 1,000 Miscellaneous...
The following trial balance was prepared for Tile, Etc., Inc. on December 31, 2017, after the...
The following trial balance was prepared for Tile, Etc., Inc. on December 31, 2017, after the closing entries were posted: Account Title Cash $ 140,000 Accounts receivable 131,000 Allowance for doubtful accounts $ 21,000 Inventory 437,000 Accounts payable 101,000 Common stock 480,000 Retained earnings 106,000 Tile, Etc. had the following transactions in 2018: Purchased merchandise on account for $610,000. Sold merchandise that cost $450,000 for $950,000 on account. Sold for $275,000 cash merchandise that had cost $172,000. Sold merchandise for...
The following trial balance was prepared for Tile, Etc., Inc., on December 31, 2016, after the...
The following trial balance was prepared for Tile, Etc., Inc., on December 31, 2016, after the closing entries were posted: Account Title Debit Credit Cash $ 195,000 Accounts Receivable 142,000 Allowance for Doubtful Accounts $ 26,500 Inventory 459,000 Accounts Payable 112,000 Common Stock 535,000 Retained Earnings 122,500 Totals $ 796,000 $ 796,000 Tile, Etc. had the following transactions in 2017: 1. Purchased merchandise on account for $665,000. 2. Sold merchandise that cost $505,000 for $1,060,000 on account. 3. Sold for...
The following trial balance was prepared for Tile, Etc., Inc. on December 31, 2017, after the...
The following trial balance was prepared for Tile, Etc., Inc. on December 31, 2017, after the closing entries were posted: Account Title Cash $ 110,000 Accounts receivable 125,000 Allowance for doubtful accounts $ 18,000 Inventory 425,000 Accounts payable 95,000 Common stock 450,000 Retained earnings 97,000 Tile, Etc. had the following transactions in 2018: Purchased merchandise on account for $580,000. Sold merchandise that cost $420,000 for $890,000 on account. Sold for $245,000 cash merchandise that had cost $160,000. Sold merchandise for...
The following is a pre-closing trial balance for the Village of Lake Augusta’s general Fund as...
The following is a pre-closing trial balance for the Village of Lake Augusta’s general Fund as of December 31, 2017: Debits Credits Accounts payable 6,800 Appropriations 160,000 Budgetary fund balance 38,000 Budgetary fund balance: reserve for encumbrances 5,000 Cash 116,500 Deferred revenues: property taxes 3,000 Due to other funds 5,000 Encumbrances 5,000 Estimated other financing sources 8,000 Estimated other financing uses 10,000 Estimated revenues 200,000 Estimated uncollectible taxes 2,000 Expenditures 154,000 Fund balance 54,700 Other financing sources 10,000 Other financing...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT