In: Accounting
Given the following pre-closing trial balance, prepare the Balance Sheet
CITY OF LASALLE | ||||
General Fund | ||||
Trial Balance | ||||
December 31, 2017 | ||||
Debit | Credit | |||
Estimated Revenues and Grants | 2,300,000 | |||
Estimated Other Financing Sources | 400,000 | |||
Appopriations | 2,150,000 | |||
Estimated Other Financing Uses | 500,000 | |||
Budgetary Fund Balance | 50,000 | |||
Cash | 500,000 | |||
Taxes Receivable | 600,000 | |||
Allowance for uncollectible taxes | 50,000 | |||
Due from Federal Government | 200,000 | |||
Supplies | 50,000 | |||
Tax Refunds Payable | 800,000 | |||
Vouchers Payable | 100,000 | |||
Due to Other Funds | 150,000 | |||
Deferred Real Estate Taxes | 50,000 | |||
Tax Revenue | 2,100,000 | |||
Federal Grants | 300,000 | |||
Expenditures | 2,200,000 | |||
Other Financing Sources-Bonds Proceeds | 450,000 | |||
Other Financing Uses-Transfers | 550,000 | |||
Fund Balance-Nonspendable | 50,000 | |||
Fund Balance-Unassigned | 50,000 | |||
Totals | $ 6,800,000 | $ 6,800,000 |
CITY OF LASALLE | |||||||
BALANCE SHEET | |||||||
AS AT DECEMBER 31, 2017 | |||||||
ASSETS | $ | LIABILITIES | $ | ||||
CURRENT ASSETS | LIABILITIES | ||||||
Due from Federal Government | $200,000.00 | Tax Refunds Payable | $800,000.00 | ||||
Taxes Receivable | $600,000.00 | Vouchers Payable | $100,000.00 | ||||
Cash | $500,000.00 | Due to Other Funds | $150,000.00 | ||||
Supplies | $50,000.00 | Deferred Real Estate Taxes | $50,000.00 | ||||
Other Financing Uses- Transfers | $550,000.00 | Other Financing Sources- Bonds Proce | $450,000.00 | ||||
ESTIMATIONS | FUNDS & BALANCES | ||||||
Estimated Revenues and Grants | $2,300,000.00 | Funds Balance- Nonspendable | $50,000.00 | ||||
Estimated Other Financing Sources | $400,000.00 | Funds Balance - Unassigned | $50,000.00 | ||||
Income for the Year | $200,000.00 | ||||||
Allowance for Uncollectible Taxes | $50,000.00 | ||||||
ESTIMATIONS | |||||||
Appropriations | $2,150,000.00 | ||||||
Estimated Other Financing Uses | $500,000.00 | ||||||
Budgetary Fund Balance | $50,000.00 | ||||||
4600000 | 4600000 |
CITY OF LASALLE | |||||||
INCOME AND EXPENDITURE | |||||||
FOR THE YEAR ENDED DECEMBER 31, 2017 | |||||||
Expenditure | $ | INCOME | $ | ||||
Expenditures | $2,200,000.00 | Tax Revenue | $2,100,000.00 | ||||
Excess of Income Over | Federal Grants | $300,000.00 | |||||
Expenditure | $200,000.00 | ||||||
$2,400,000.00 | $2,400,000.00 | ||||||
THANK YOU
HOPING FOR A POSITIVE RESPONSE