Ch. 8 Continuous Problem - Excel A Brian Mowad X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Comments AutoSave . On) H 5 - Q . = H5 X V fx A B C D E G H K M N 0 P Q R 29 Total Liabilities $ 2.567,300 $ 26,400 30 City of Monroe Net Position 31 Statement of Revenues, Expenditures, and Change in Fund Balances Net Investment in Capital Assets 537.300 $ 71,400 32 As of December 31, 2017 Restricted for Debt Service 142,000 $ General Street & Highway City Hall Debt City Jail Debt City Jail Total Governmental Service Service Construction Funds Unrestricted $ 240,100 56340 34 Revenues: Total Net Position 919.400 $ 27.740 35 Property Taxes $ 6,657.500 6,657.500 36 37 Sales Taxes 2,942,000 2,942,000 The City of Monroe nterest & Penalties 16, 100 5.120 21,220 Statement of Revenues, Expenses, and Changes in Fund Net position 38 800,000 800,000 Proprietary Funds 39 Licenses and Permits Intergovernmental Revenues 332,000 1,065,000 1,340,000 $ 2.737.000 For the Year Ended December 31, 2017 Business-type Governmental Activities - Activities - 40 Miscellaneous Revenues 350,000 350,000 Enterprise Internal 41 Operating Revenues: 42 Total Revenues $ 11,097,600 1.070,120 1,340,000 13.507.720 Charges for Sales and Services 1,049,500 371,200 43 Operating Expenses: 44 Expenditures: A +4 Cost of Sales and Services (493,300) $ (346,360 45 Current: Administration (109,400) $ 19,000 46 General Government $ 1,646,900 1,646,300 Selling (58,300 Public Safety 3,026.900 3.026,900 Depreciation (282,000) $ [14,600) 48 Highways and Streets 1,441,400 (1,040,500) 400,900 Total Operating Expenses 49 691,400 Operating Income * *# ## (943,600) $ 369,960) Sanitation 591,400 105,900 $ 1,240 50 Health 724,100 724.100 Nonoperating Revenues (expenses): 51 Welfare 374,300 374,300 nterest Expense (145,500) $ 52 Culture and Recreation 917,300 917,300 Total Nonoperating Expenses (145,500) $ 53 Capital Outlay 492,800 (5,330,300) $ (4.837.500 Income Before Contributions and Transfers $ (39,600) $ 1,240 54 Debt Service Change in Net Position (39,600) $ 1,240 55 56 Principal (800,000) (800,000) Net Position - Jan. 1, 2017 (160,000) Net Position - Dec. 31, 2017 4 4 4# ## 59,000 $ Interest (354,000) (514,000) 919.400 $ 26,300 127,740 57 Total Expenditures $ 9,215,100 (1,040,500) 1.154,000 160,000) (5.330,300) 1,530,300 58 59 Excess (Deficiency) of Revenues Over Expenditures $ 1,882,500 29,620 (1,154,000) (160,000) (3,990,300) (3,392,180) Other Financing Sources (Uses 62 4,000,000 4,000,000 63 Proceeds of Bonds Premium on Bonds sold 200,000 $ 200,000 64 Transfers In 1,142,000 729,700 1,871,700 65 Transfers Out (1662000) (209,700) $ (1,871,700) 66 Total Other Financing Sources (Uses) (1662000 1.142,000 23.700 3,990,300 4.200,000 67 68 220,500 $ 29,620 $ (12 000) $ 569,700 $ 807.820 69 Net Change in Fund Balance Fund Balance, January 1 737,250 180,000 580,000 1,497.250 Fund Balance, December 31 957,750 209,620 568,000 569,700 2,305,070 Info. Sheet2 + + 69% 3:12 PM Type here to search O 11/17/2019Ch. 8 Continuous Problem - Excel A Brian Mowad X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Comments AutoSave . On) H 5 - . = P10 X V fx E G H M N P Q R S T U V W X A W N - The City of Monroe Statement of Net position Proprietary Fund For the Year Ended December 31, 2017 City Hall Debt City Jail Debt Total Business-type Governmental Service Service Governmental Activities - Enterprise Activities - Internal Funds Funds - Water Utility Service Fund Assets 9,700.0 2,055,720 Current Assets: 568,000.0 360,000.0 928,000 Cash 102,400 5 35,000 200,000.0 205,120 Accounts Receivable (net) 116,500 262,000 Due From General Fund 37,000 $ 36,500 $ 3,200 11 16,850 Materials and Supplies 37,540 12 559,000 Total Current Assets 292,400 $ 75,740 13 568,000 $ 569,700 4,026,690 Noncurrent assets 14 Restricted Assets 142,000 15 Long-term Advance to Supplies 15,00 16 Capital Assets, Net of Accum. Depreciati 3,037,300 $ 78,40 17 468,800 Total Noncurrent Assets 3,194,300 $ 78,400 18 27,000 Total Assets 3,486,700 $ 154,140 495,800 Liabilities 10,500 Current Liabilities Accounts Payable 56,000 $ 19,400 153,740 Due to Stores and 8,000 17,000 Payroll Taxes Payable 3,300 $ 568,000.0 569,700.0 1,137,700 Total current liabilities 57,300 $ 19,400 720,250 Noncurrent Liabilities: 26 $ 568,000 S 569,700 S 2,028,690 Revenue Bonds Payable 2,500,000 27 568,000 $ 569,700 2,534,990 Advance from Water Fund 7,00 Total noncurrent Liabilities 2,500,000 $ 7,000 Total Liabilities 2,567,300 $ 26,400 Net Position 1 nd Change in Fund Balances Net Investment in Capital Assets 537,300 $ 71,400 32 2017 Restricted for Debt Service 142,000 $ City Hall Debt City Jail Debt City Jail Service Service Construction Total Governmental Funds 33 Unrestricted 240,100 56340 Total Net Position 19,400 $ 127,740 35 6,657,500 Info Sheet2 + + 80% 3:12 PM Type here to search O Ei EM 11/17/2019Ch. 8 Continuous Problem - Excel A Brian Mowad X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Comments AutoSave . On) H 5 - Q . = H5 X V fx B D E F G H J K M 1 Brian Mowad The City of Monroe 2 Dr. Spear City of Monroe Statement of Net position 3 Acct 621-0 General Fund Balance Sheet Proprietary Funds 4 Nov. 17, 2019 As of December 31, 2015 For the Year Ended December 31, 2017 City Hall Total Business-type General Street & City Jail Governmental Highway Debt Debt Governme Activities - Enterprise Activities - Internal Service Service ntal Funds Funds - Water Utility Service Fund Assets Assets Cash $ 1,945,900 $ 100,120 9,700.0 $ 2,055,720 Current Assets Cash with Fiscal Agent 568,000.0 360,000.0 $ 928,000 Cash 102,400 $ 35,000 Investments 5,120 200,000.0 $ 205,120 Accounts Receivable (net) 116,500 $ Taxes Receivable (net) 262,000 262,000 Due From General Fund 37,000 $ 3,200 Interest and Penalties Receivable (net) 16,850 $ 16,850 Materials and Supplies 36,500 S 37,540 Due from State Government 384,000 175,000 $ 559,000 Total Current Assets 292,400 S 75,740 Total Assets $ 2,608,750 $ 280,240 $ 568,000 $ 569,700 $ 4,026,690 Noncurrent assets: $ Restricted Assets 142,000 Liabilities and Fund Equity Long-term Advance to Supplies 15,000 Liabilities: Capital Assets, Net of Accum. Depreciation 3,037,300 $ 78,400 Accounts Payable 342,300 126,500 468,800 Total Noncurrent Asset 3,194,300 $ 78,400 Due to Other funds 27,000 27,000 Total Assets 3,486,700 $ 154,140 Total Liabilities $ 369,300 $ 126,500 S 495,800 Liabilities Deferred Inflows - Property Taxes S 10,500 10,500 Current Liabilities: Fund Equity Accounts Payable 56,000 $ 19,400 22 Restricted for street & Highway Maintenance S 153,740 $ 153,740 Due to Stores and Service Fund 8,000 23 Fund Balance - Assigned (for outstanding encumbrances) 17,000 17,000 Payroll Taxes Payable 3,300 $ 24 Debt Service 568,000.0 569,700.0 $ 1,137,700 Total current liabilities 67,300 $ 19,400 Fund Balance - Unassigned 720,250 $ 720,250 Noncurrent Liabilities: Total Fund Equity $ 737,250 153,740 $ 568,000 $ 569,700 $ 2,028,690 Revenue Bonds Payable $ 2,500,000 27 Total Liabilities, Deferred Inflows and Fund Equity $ 1,117,050 280,240 $ 568,000 $ 5 569,700 $ 2,534,990 Advance from Water Fund 7,000 28 Total noncurrent Liabilities 2,500,000 S 7,000 29 Total Liabilities 2,567,300 $ 26,400 30 City of Monroe Net Position 31 Statement of Revenues, Expenditures, and Change in Fund Balances Net Investment in Capital Assets in to 537,300 $ 71,400 32 As of December 31, 2017 Restricted for Debt Service 142,000 $ City Hall City lail Doht City Jail Total Info. Sheet2 + Select destination and press ENTER or choose Paste + 91% Type here to search meg EM 3:11 PM 11/17/2019