|
2019 Water and Sewer Business Pro -Forma
<br />ACCOUNT
<br />2018
<br />Estimated
<br />2019
<br />DESCRIPTION
<br />Adopted
<br />12/31/2018
<br />Adopted
<br />Liability
<br />$
<br />13,717.00
<br />$
<br />15,717.00
<br />$
<br />16,972.00
<br />Property
<br />$
<br />3,989.00
<br />$
<br />10,158.00
<br />$
<br />12,357.00
<br />Automobile
<br />$
<br />425.00
<br />$
<br />357.00
<br />$
<br />475.00
<br />$
<br />18,131.00
<br />$
<br />26,232.00
<br />$
<br />29,804.00
<br />Rentals:
<br />Copier Lease Payments
<br />$
<br />500.00
<br />$
<br />493.00
<br />$
<br />493.00
<br />Copier Overage Charges
<br />$
<br />50.00
<br />$
<br />50.00
<br />$
<br />50.00
<br />$
<br />550.00
<br />$
<br />543.00
<br />$
<br />543.00
<br />Miscellaneous:
<br />Gopher State Service Charges
<br />$
<br />1,800.00
<br />$
<br />1,443.00
<br />$
<br />1,535.00
<br />Truck License Tabs
<br />$
<br />-
<br />$
<br />37.00
<br />$
<br />-
<br />Discharge Permit - Vactor Truck
<br />$
<br />-
<br />$
<br />425.00
<br />$
<br />425.00
<br />$
<br />1,800.00
<br />$
<br />1,905.00
<br />$
<br />1,960.00
<br />Assessment Collection Fees
<br />$
<br />1,000.00
<br />$
<br />822.00
<br />$
<br />1,000.00
<br />$
<br />2,800.00
<br />$
<br />2,727.00
<br />$
<br />2,960.00
<br />Depreciation
<br />Estimated Depreciation
<br />$
<br />60,253.00
<br />$
<br />78,768.00
<br />$
<br />89,247.00
<br />Estimated Contributed Depreciation
<br />$
<br />169,171.00
<br />$
<br />197,458.00
<br />$
<br />202,713.00
<br />$
<br />229,424.00
<br />$
<br />276,226.00
<br />$
<br />291,960.00
<br />TOTAL SEWER EXPENSES
<br />$
<br />1,200,051.00
<br />$
<br />1,186,452.00
<br />$
<br />1,367,865.00
<br />NET INCOME - SEWER
<br />$
<br />53,780.00
<br />$
<br />109,586.00
<br />$
<br />54,314.00
<br />Sewer Fund Share of PW Facility Bonds
<br />$
<br />53,780.00
<br />$
<br />54,135.00
<br />$
<br />54,314.00
<br />$
<br />-
<br />$
<br />55,451.00
<br />$
<br />-
<br />WATER & SEWER NET INCOME
<br />$
<br />268,013.00
<br />$
<br />299,813.04
<br />$
<br />190,632.00
<br />Rice Creek Grant for Vactor Truck
<br />$
<br />-
<br />$
<br />25,200.00
<br />$
<br />-
<br />Returned Check Fees
<br />$
<br />540.00
<br />$
<br />540.00
<br />$
<br />540.00
<br />Special Assessments
<br />$
<br />825.00
<br />$
<br />825.00
<br />$
<br />825.00
<br />Investment Earnings:
<br />- Interest Income
<br />$
<br />33,200.00
<br />$
<br />89,635.00
<br />$
<br />50,000.00
<br />- Change in Value of Investments
<br />Rents & Royalties:
<br />- T Mobile Base Rent
<br />$
<br />32,418.00
<br />$
<br />34,039.00
<br />$
<br />35,740.00
<br />- Connexus Energy Annual Tower Lease
<br />$
<br />3,408.00
<br />$
<br />3,510.00
<br />$
<br />3,510.00
<br />Transfer to PW Facility Bond Sinking Fund
<br />$
<br />(107,560.00)
<br />$
<br />(108,269.00)
<br />$
<br />(108,628.00)
<br />CHANGE IN RETAINED EARNINGS
<br />$
<br />230,844.00
<br />$
<br />345,293.04
<br />$
<br />172,619.00
<br />Contributed Depreciation
<br />$
<br />316,256.00
<br />$
<br />371,021.00
<br />$
<br />382,181.00
<br />TOTAL CHANGE IN RETAINED EARNINGS
<br />$
<br />547,100.00
<br />$
<br />716,314.04
<br />$
<br />554,800.00
<br />Page 8
<br />
|