Fort Walton Beach — Comprehensive Financial Report September 30, 2021 — reading text

Governmental Trust Training Code Block Grant Care Service Funds REVENUES Permits and fees $ - $ - $ 635,702 $ - $ - $ - $ 635,702 Intergovernmental 9,125 - - 294,572 - - 303,697 Fines 8,864 4,482 - - - - 13,346 Miscellaneous 4,623 18 1,078 - 662,796 - 668,515 Total revenues 22,612 4,500 636,780 294,572 662,796 - 1,621,260 EXPENDITURES Current Public safety 2,784 - 470,461 - - - 473,245 Physical environment - - - - 15,413 - 15,413 Economic environment - - - 296,871 - - 296,871 Capital outlay 8,434 - 1,150 - - - 9,584 Debt service Principal - - - - - 1,203,619 1,203,619 Interest - - - - - 704,720 704,720 Total expenditures 11,218 - 471,611 296,871 15,413 1,908,339 2,703,452 EXCESS (DEFICIENCY) OF REVENUES OVER (UNDER) EXPENDITURES 11,394 4,500 165,169 (2,299) 647,383 (1,908,339) (1,082,192) OTHER FINANCING SOURCES Transfers in - - - - 55,167 1,908,339 1,963,506 Total other financing sources - - - - 55,167 1,908,339 1,963,506 NET CHANGE IN FUND BALANCE 11,394 4,500 165,169 (2,299) 702,550 - 881,314 FUND BALANCE (DEFICIT) AT BEGINNING OF YEAR 96,814 13,529 769,240 (17,483) 3,451,682 21,156 4,334,938 FUND BALANCE (DEFICIT) AT END OF YEAR $ 108,208 $ 18,029 $ 934,409 $ (19,782) $ 4,154,232 $ 21,156 $ 5,216,252 100  CITY OF FORT WALTON BEACH, FLORIDA LAW ENFORCEMENT TRUST SPECIAL REVENUE FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE – BUDGET AND ACTUAL FOR THE YEAR ENDED SEPTEMBER 30, 2021 Variance with Final Budget - Budgeted Amounts Positive Original Final Actual (Negative) REVENUES Intergovernmental $ - $ 10,500 $ 9,125 $ (1,375) Fines - - 8,864 8,864 Miscellaneous 2,309 2,309 4,623 2,314 Total revenues 2,309 12,809 22,612 9,803 EXPENDITURES Current Public safety 14,402 14,402 2,784 11,618 Capital outlay - 10,500 8,434 2,066 Total expenditures 14,402 24,902 11,218 13,684 NET CHANGE IN FUND BALANCE (12,093) (12,093) 11,394 23,487 FUND BALANCE AT BEGINNING OF YEAR 12,093 12,093 96,814 84,721 FUND BALANCE AT END OF YEAR $ - $ - $ 108,208 $ 108,208 101  CITY OF FORT WALTON BEACH, FLORIDA LAW ENFORCEMENT TRUST TRAINING SPECIAL REVENUE FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE – BUDGET AND ACTUAL FOR THE YEAR ENDED SEPTEMBER 30, 2021 Variance with Final Budget - Budgeted Amounts Positive Original Final Actual (Negative) REVENUES Fines $ 400 $ 400 $ 4,482 $ 4,082 Miscellaneous 100 100 18 (82) Total revenues 500 500 4,500 4,000 EXPENDITURES Current Public safety 500 500 - 500 Total expenditures 500 500 - 500 NET CHANGE IN FUND BALANCE - - 4,500 4,500 FUND BALANCE AT BEGINNING OF YEAR - - 13,529 13,529 FUND BALANCE AT END OF YEAR $ - $ - $ 18,029 $ 18,029 102  CITY OF FORT WALTON BEACH, FLORIDA FLORIDA BUILDING CODE SPECIAL REVENUE FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE – BUDGET AND ACTUAL FOR THE YEAR ENDED SEPTEMBER 30, 2021 Variance with Final Budget - Budgeted Amounts Positive Original Final Actual (Negative) REVENUES Permits and fees $ 472,211 $ 472,211 $ 635,702 $ 163,491 Miscellaneous 2,000 2,000 1,078 (922) Total revenues 474,211 474,211 636,780 162,569 EXPENDITURES Current Public safety 479,061 479,061 470,461 8,600 Capital outlay 4,510 4,510 1,150 3,360 Total expenditures 483,571 483,571 471,611 11,960 NET CHANGE IN FUND BALANCE (9,360) (9,360) 165,169 174,529 FUND BALANCE AT BEGINNING OF YEAR 9,360 9,360 769,240 759,880 FUND BALANCE AT END OF YEAR $ - $ - $ 934,409 $ 934,409 103  CITY OF FORT WALTON BEACH, FLORIDA COMMUNITY DEVELOPMENT BLOCK GRANT SPECIAL REVENUE FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE – BUDGET AND ACTUAL FOR THE YEAR ENDED SEPTEMBER 30, 2021 Variance with Final Budget - Budgeted Amounts Positive Original Final Actual (Negative) REVENUES Intergovernmental $ 234,807 $ 433,526 $ 294,572 $ (138,954) Total revenues 234,807 433,526 294,572 (138,954) EXPENDITURES Current Economic environment 255,836 454,555 296,871 157,684 Total expenditures 255,836 454,555 296,871 157,684 NET CHANGE IN FUND BALANCE (21,029) (21,029) (2,299) 18,730 FUND BALANCE (DEFICIT) AT BEGINNING OF YEAR 21,029 21,029 (17,483) (38,512) FUND BALANCE (DEFICIT) AT END OF YEAR $ - $ - $ (19,782) $ (19,782) 104  CITY OF FORT WALTON BEACH, FLORIDA BEAL MEMORIAL CEMETERY PERPETUAL CARE SPECIAL REVENUE FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE – BUDGET AND ACTUAL FOR THE YEAR ENDED SEPTEMBER 30, 2021 Variance with Final Budget - Budgeted Amounts Positive Original Final Actual (Negative) REVENUES Miscellaneous $ 26,500 $ 26,500 $ 662,796 $ 636,296 EXPENDITURES Current Physical environment 12,200 12,200 15,413 (3,213) EXCESS OF REVENUES OVER EXPENDITURES 14,300 14,300 647,383 633,083 OTHER FINANCING SOURCES (USES) Transfers in 40,983 40,983 55,167 14,184 Transfers out (60,000) (60,000) - 60,000 Total other financing sources (uses) (19,017) (19,017) 55,167 74,184 NET CHANGE IN FUND BALANCE (4,717) (4,717) 702,550 707,267 FUND BALANCE AT BEGINNING OF YEAR 4,717 4,717 3,451,682 3,446,965 FUND BALANCE AT END OF YEAR $ - $ - $ 4,154,232 $ 4,154,232 105  CITY OF FORT WALTON BEACH, FLORIDA DEBT SERVICE FUND SCHEDULE OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE – BUDGET AND ACTUAL FOR THE YEAR ENDED SEPTEMBER 30, 2021 Variance with Final Budget - Budgeted Amounts Positive Original Final Actual (Negative) REVENUES Miscellaneous $ - $ - $ - $ - Total revenues - - - - EXPENDITURES Debt service Principal 799,647 799,647 1,203,619 (403,972) Interest 276,932 276,932 704,720 (427,788) Total expenditures 1,076,579 1,076,579 1,908,339 (831,760) DEFICIENCY OF REVENUES UNDER EXPENDITURES (1,076,579)