Issue link: https://www.e-digitaleditions.com/i/850954
PADRE DAM MUNICIPAL WATER DISTRICT FIVE YEAR BUDGET FY '18‐FY '22 FUND BALANCE ACTIVITY FY '18 FY '19 FY '20 FY '21 FY '22 FY '18 FY '19 FY '20 FY '21 FY '22 FY '18 FY '19 FY '20 FY '21 FY '22 Beginning Fund Balance 25,301,062 $ 24,574,644 $ 18,231,903 $ 20,443,284 $ 22,801,954 $ 11,111,801 $ 11,550,428 $ 10,303,475 $ 10,646,369 $ 11,129,532 $ 18,256,228 $ 14,470,447 $ 13,182,651 $ 10,830,225 $ 10,783,001 $ Fund Balance Activity: Net Income/(Loss) 1,202,312 $ 1,926,052 $ 2,045,617 $ 2,708,924 $ 3,111,538 $ 673,849 $ 544,385 $ 346,249 $ 284,009 $ 178,855 $ 2,779 $ 761,968 $ 118,550 $ 317,091 $ 323,540 $ Add: Depreciation/Amort 4,899,343 5,161,846 5,351,571 5,464,144 5,599,206 810,376 931,950 1,068,477 1,155,381 1,246,904 1,040,227 1,157,363 1,257,742 1,357,257 1,422,128 Capacity Fees 922,052 772,600 1,605,661 1,335,968 315,094 ‐ ‐ ‐ ‐ ‐ 695,689 443,731 722,283 531,096 252,544 2009 COP 6,674,253 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Deduct: CIP Projects (11,272,946) (9,151,473) (4,207,196) (4,777,700) (5,099,512) (222,630) (2,090,580) (573,166) (129,840) (356,144) (5,480,581) (3,445,730) (4,268,478) (2,204,040) (3,060,644) Capital Equipment (310,137) (415,034) (314,379) (359,585) (371,080) (614,473) (455,447) (313,477) (630,868) (344,235) (43,895) (205,128) (182,524) (48,628) (58,510) Debt ‐ Principal (2,739,031) (2,506,768) (2,269,893) (2,013,080) (2,043,556) (208,495) (177,262) (185,189) (195,519) (267,724) ‐ ‐ ‐ ‐ ‐ Financing (COP) ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Fund Transfers (102,263) (2,129,963) ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Cash Generated (Used) (726,418) $ (6,342,741) $ 2,211,381 $ 2,358,670 $ 1,511,690 $ 438,627 $ (1,246,954) $ 342,894 $ 483,163 $ 457,656 $ (3,785,781) $ (1,287,795) $ (2,352,426) $ (47,224) $ (1,120,941) $ Ending Fund Balance 24,574,644 $ 18,231,903 $ 20,443,284 $ 22,801,954 $ 24,313,644 $ 11,550,428 $ 10,303,475 $ 10,646,369 $ 11,129,532 $ 11,587,188 $ 14,470,447 $ 13,182,651 $ 10,830,225 $ 10,783,001 $ 9,662,060 $ FY '18 FY '19 FY '20 FY '21 FY '22 FY '18 FY '19 FY '20 FY '21 FY '22 FY '18 FY '19 FY '20 FY '21 FY '22 Beginning Fund Balance 5,068,051 $ 5,263,788 $ 5,474,884 $ 5,354,988 $ 5,537,196 $ 35,714,019 $ 24,640,484 $ 24,253,863 $ 24,458,690 $ 25,027,553 $ 95,451,161 $ 80,499,791 $ 71,446,776 $ 71,733,556 $ 75,279,237 $ Fund Balance Activity: Net Income/(Loss) 345,876 $ 89,450 $ 90,789 $ 71,753 $ 49,384 $ 50,000 $ 40,000 $ 40,000 $ 40,000 $ 40,000 $ 2,274,816 $ 3,361,854 $ 2,641,205 $ 3,421,776 $ 3,703,319 $ Add: Depreciation/Amort 760,271 883,792 1,125,105 1,162,757 1,191,783 ‐ ‐ ‐ ‐ ‐ 7,510,217 8,134,951 8,802,895 9,139,539 9,460,021 Capacity Fees ‐ ‐ ‐ ‐ ‐ 730,874 555,000 1,070,987 862,283 255,869 2,348,615 1,771,332 3,398,932 2,729,347 823,507 2009 COP 800,000 7,200,000 ‐ ‐ ‐ 4,231,389 ‐ ‐ ‐ ‐ 11,705,642 7,200,000 ‐ ‐ ‐ Deduct: ‐ ‐ ‐ ‐ ‐ CIP Projects (920,000) (7,260,000) (622,500) (312,500) (435,000) (5,282,418) (3,111,585) (906,160) (333,420) (715,700) (23,178,575) (25,059,368) (10,577,500) (7,757,500) (9,667,000) Capital Equipment (152,770) (99,994) (81,395) (82,920) (63,675) ‐ ‐ ‐ ‐ ‐ (1,121,275) (1,175,603) (891,775) (1,122,001) (837,500) Debt ‐ Principal (637,641) (602,152) (631,895) (656,882) (687,126) ‐ ‐ ‐ ‐ ‐ (3,585,167) (3,286,182) (3,086,977) (2,865,480) (2,998,406) Financing (COP) ‐ ‐ ‐ ‐ ‐ (10,905,642) ‐ ‐ ‐ ‐ (10,905,642) ‐ ‐ ‐ ‐ Fund Transfers ‐ ‐ ‐ ‐ ‐ 102,263 2,129,963 ‐ ‐ ‐ ‐ ‐ ‐ ‐ ‐ Cash Generated (Used) 195,737 $ 211,096 $ (119,896) $ 182,208 $ 55,367 $ (11,073,534) $ (386,622) $ 204,827 $ 568,863 $ (419,831) $ (14,951,370) $ (9,053,016) $ 286,780 $ 3,545,682 $ 483,940 $ Ending Fund Balance 5,263,788 $ 5,474,884 $ 5,354,988 $ 5,537,196 $ 5,592,563 $ 24,640,484 $ 24,253,863 $ 24,458,690 $ 25,027,553 $ 24,607,722 $ 80,499,791 $ 71,446,776 $ 71,733,556 $ 75,279,237 $ 75,763,177 $ PARK OPERATION CEF & RESTRICTED FUNDS COMBINED OPERATIONS POTABLE WATER OPERATION RECYCLED WATER OPERATION SEWER OPERATION Ensuring a Strong Future