Okaloosa County BOCC — February 27, 2014 — IV.b. Dec OCTC

22  23 Total Historical TDT Collections and Percentage Breakdown FY 2009 - Current % (+/-) % (+/-) % (+/-) Cum (+/-) Month FY 2009 FY 2010 FY 2011 FY 2012 FY 2013 FY 2014 2011-2012 2012-2013 2013-2014 2013-2014 October $478,148.95 $522,443.42 $521,660.33 $598,158.00 14.49% $609,091.44 1.83% $680,330.93 11.70% 11.70% November $206,354.05 $210,704.19 $213,947.00 $239,511.00 11.95% $259,606.95 8.39% $273,038.26 5.17% 9.75% December $203,215.30 $235,157.23 $217,922.30 $289,595.00 32.89% $288,498.30 -0.38% $291,672.28 1.10% 7.59% January $277,999.51 $285,996.44 $256,775.00 $297,124.03 15.71% $298,995.38 0.63% February $386,604.93 $376,473.90 $365,490.00 $437,614.00 19.73% $395,790.00 -9.56% March $755,427.84 $727,272.00 $768,790.00 $1,028,053.00 33.72% $1,118,616.08 8.81% April $792,139.00 $779,028.05 $847,476.00 $987,462.61 16.52% $905,964.12 -8.25% May $986,600.37 $955,032.36 $1,079,025.00 $1,296,974.20 20.20% $1,264,606.99 -2.50% June $2,091,522.22 $1,730,975.65 $2,290,684.30 $2,755,441.00 20.29% $2,797,225.80 1.52% July $2,245,536.10 $1,483,002.44 $2,749,706.99 $2,755,052.00 0.19% $2,897,646.65 5.18% August $1,169,781.00 $756,365.51 $1,225,204.88 $1,421,408.96 16.01% $1,588,763.04 11.77% September $800,409.00 $700,746.00 $1,028,530.00 $1,067,149.50 3.75% $1,098,414.84 2.93% Total $10,393,738.27 $8,763,197.19 $11,565,211.80 $13,173,543.30 13.91% $13,523,219.59 2.65% $1,245,041.47 Amounts for September 2013 through current reported by the Okaloosa County Tax Collector's Office. All amounts prior to September 2013 reported by the Okaloosa County Clerk of Courts. Page 1  Total TDT Collections in Thousands $300 $600 $900 $0 $1,200 $1,500 $1,800 $2,100 $2,400 $2,700 $3,000 $3,300 598.2 609.1 Oct FY 2012 680.3 239.5 259.6 Nov 273.0 289.6 288.5 Dec 291.7 297.1 299.0 Jan FY 2003 0.0 437.6 395.8 Feb 0.0 FY 12 1,028.1 1,118.6 Mar FY 13 Month Page 2 Page 2 0.0 987.5 FY 14 906.0 Apr FY 2012 - 2014 0.0 1,297.0 1,264.6 May Total Monthly TDT Collections 0.0 2,755.4 2,797.2 Jun 0.0 2,755.1 2,897.6 Jul 0.0 1,421.4 1,588.8 Aug 0.0 1,067.1 1,098.4 Sep 0.0 24  25 TDT Rental Receipts and Amount Remitted by Rental Type / Tax Area December 2013 Gross Rental Exempt Rental Taxable Rental 5% of Taxable Collection Total Amount Distibution to Tax Collector Rental Type Adjustments Penalty Interest Receipts Receipts Receipts Rental Receipts Allowance Remitted TDD/BCC Commission Condo $3,326,087.76 $348,539.51 $2,977,548.25 $148,877.41 $318.51 $2,018.64 $70.40 ($2,175.50) $149,109.46 $144,636.18 $4,473.28 Hotel / Motel $1,741,863.00 $58,294.86 $1,683,568.14 $84,178.41 $0.00 $0.00 ($762.14) $83,416.27 $80,913.78 $2,502.49 Single Family Dwelling $831,184.74 $23,049.73 $808,135.01 $40,406.75 $680.00 $25.36 ($233.52) $40,878.59 $39,652.23 $1,226.36 Other $441,243.91 $72,731.42 $368,512.49 $18,425.62 $0.00 $0.00 ($157.66) $18,267.96 $17,719.93 $548.04 Total $6,340,379.41 $502,615.52 $5,837,763.89 $291,888.19 $318.51 $2,698.64 $95.76 ($3,328.82) $291,672.28 $282,922.12 $8,750.17 Gross Rental Exempt Rental Taxable Rental 5% of Taxable Collection Total Amount Distibution to Tax Collector Tax Area Adjustments Penalty Interest Receipts Receipts Receipts Rental Receipts Allowance Remitted TDD/BCC Commission Destin $4,035,429.68 $242,372.25 $3,793,057.43 $189,652.87 $318.51 $2,398.64 $94.36 ($2,260.73) $190,203.65 $184,497.54 $5,706.11 Okaloosa Island $1,856,698.75 $164,202.68 $1,692,496.07 $84,624.80 $300.00 $1.40 ($827.90) $84,098.30 $81,575.35 $2,522.95 Fort Walton Beach $448,250.98 $96,040.59 $352,210.39 $17,610.52 $0.00 $0.00 ($240.19) $17,370.33 $16,849.22 $521.11 Total $6,340,379.41 $502,615.52 $5,837,763.89 $291,888.19 $318.51 $2,698.64 $95.76 ($3,328.82) $291,672.28 $282,922.12 $8,750.17 Page 3  26 Percentage of Gross Rental, Taxable Rental, and Number of Units by Rental Type December 2013 Gross Rental Taxable Rental Rental Type % % Number of Units % Receipts Receipts Condo $3,326,087.76 52.46% $2,977,548.25 51.00% 6,253 57.39% Hotel / Motel $1,741,863.00 27.47% $1,683,568.14 28.84% 3,144 28.85% Single Family Dwelling $831,184.74 13.11% $808,135.01 13.84% 611 5.61% Other $441,243.91 6.96% $368,512.49 6.31% 888 8.15% Total $6,340,379.41 100.00% $5,837,763.89 100.00% 10,896 100.00% Gross Rental by Taxable Rental by Number of Units by Rental Type Rental Type Rental Type Other Other Other 6.96% 6.31% 8.15% Single Single Single Family Family Family Dwelling Dwelling Dwelling 13.11% 13.84% 5.61% Condo Condo Condo 52.46% 51.00% Hotel / 57.39% Hotel / Hotel / Motel Motel Motel 28.85% 27.47% 28.84% Page 4  27 Percentage of Gross Rental, Taxable Rental, and Number of Units by Tax Area December 2013 Gross Rental Taxable Rental Tax Area % % Number of Units % Receipts Receipts Destin $4,035,429.68 63.65% $3,793,057.43 64.97% 6,465 59.33% Okaloosa Island $1,856,698.75 29.28% $1,692,496.07 28.99% 3,564 32.71% Fort Walton Beach $448,250.98 7.07% $352,210.39 6.03% 867 7.96% Total $6,340,379.41 100.00% $5,837,763.89 100.00% 10,896 100.00% Gross Rental by Taxable Rental by Number of Units by Tax Area Tax Area Tax Area Fort Fort Fort Walton Walton Walton Beach Beach Beach 7.07% 6.03% 7.96% Okaloosa Okaloosa Okaloosa Island Island Island Destin 29.28% Destin 28.99% Destin 32.71% 59.33% 63.65% 64.97% Page 5  28 Year to Date Percentage of Gross Rental Receipts by Rental Type / Tax Area FY 2014 YEAR TO DATE RENTAL TYPE OCT 2013 NOV 2013 DEC 2013 JAN 2014 FEB 2014 MAR 2014 APR 2014 MAY 2014 JUNE 2014 JULY 2014 AUG 2014 SEPT 2014 GROSS SALES Condo $ 8,308,588.62 3,149,452.93 3,326,087.76 $ 14,784,129.31 Hotel / Motel $ 3,348,581.10 1,885,569.12 1,741,863.00 $ 6,976,013.22 Single Family Dwelling $ 1,659,015.03 422,191.52 831,184.74 $ 2,912,391.29 Other $ 1,173,994.87 568,409.91 441,243.91 $ 2,183,648.69 Total $ 14,490,179.62 $ 6,025,623.48 $ 6,340,379.41 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 26,856,182.51 YEAR TO DATE TAX AREA OCT 2013 NOV 2013 DEC 2013 JAN 2014 FEB 2014 MAR 2014 APR 2014 MAY 2014 JUNE 2014 JULY 2014 AUG 2014 SEPT 2014 GROSS SALES Destin $ 9,041,836.21 3,128,561.42 4,035,429.68 $ 16,205,827.31 Okaloosa Island $ 4,782,376.77 2,439,165.73 448,250.98 $ 7,669,793.48 Fort Walton Beach $ 665,966.64 457,896.33 1,856,698.75 $ 2,980,561.72 Total $ 14,490,179.62 $ 6,025,623.48 $ 6,340,379.41 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 26,856,182.51 Year to Date Year to Date Gross Rental by Gross Rental by Rental Type Tax Area Other 8.13% Fort Walton Beach 11.10% Single Family Dwelling 10.84% Condo 55.05% Destin Okaloosa Island 60.34% Hotel / Motel 28.56% 25.98% Page 6  29 Year to Date Percentage of Taxable Rental Receipts by Rental Type / Tax Area FY 2014 YEAR TO DATE RENTAL TYPE OCT 2013 NOV 2013 DEC 2013 JAN 2014 FEB 2014 MAR 2014 APR 2014 MAY 2014 JUNE 2014 JULY 2014 AUG 2014 SEPT 2014 TAXABLE RENTAL Condo $ 7,753,638.68 2,767,247.54 2,977,548.25 $ 13,498,434.47 Hotel / Motel $ 3,236,954.32 1,808,528.67 1,683,568.14 $ 6,729,051.13 Single Family Dwelling $ 1,657,382.07 410,716.06 808,135.01 $ 2,876,233.14 Other $ 1,005,684.24 500,853.91 368,512.49 $ 1,875,050.64 Total $ 13,653,659.31 $ 5,487,346.18 $ 5,837,763.89 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 24,978,769.38 YEAR TO DATE TAX AREA OCT 2013 NOV 2013 DEC 2013 JAN 2014 FEB 2014 MAR 2014 APR 2014 MAY 2014 JUNE 2014 JULY 2014 AUG 2014 SEPT 2014 TAXABLE RENTAL Destin $ 8,708,099.23 2,912,346.67 3,793,057.43 $ 15,413,503.33 Okaloosa Island $ 4,414,625.83 2,217,756.25 352,210.39 $ 6,984,592.47 Fort Walton Beach $ 530,934.25 357,243.26 1,692,496.07 $ 2,580,673.58 Total $ 13,653,659.31 $ 5,487,346.18 $ 5,837,763.89 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 24,978,769.38 Year to Date Year to Date Taxable Rental by Taxable Rental by Rental Type Tax Area Other 7.51% Fort Walton Beach Single Family Dwelling 10.33% 11.51% Condo Okaloosa Island 54.04% 27.96% Destin Hotel / Motel 61.71% 26.94% Page 7  30 Total TDT Collections and Percentage Breakdown FY 2014 TOTAL MONTH FIRST % SECOND % THIRD % FOURTH % FIFTH % COLLECTIONS October $ 680,330.93 $ 136,066.19 $ 136,066.19 $ 136,066.19 $ 136,066.19 $ 136,066.19 November $ 273,038.26 $ 54,607.65 $ 54,607.65 $ 54,607.65 $ 54,607.65 $ 54,607.65 December $ 291,672.28 $ 58,334.46 $ 58,334.46 $ 58,334.46 $ 58,334.46 $ 58,334.46 January $ - $ - $ - $ - $ - $ - February $ - $ - $ - $ - $ - $ - March $ - $ - $ - $ - $ - $ - April $ - $ - $ - $ - $ - $ - May $ - $ - $ - $ - $ - $ - June $ - $ - $ - $ - $ - $ - July $ - $ - $ - $ - $ - $ - August $ - $ - $ - $ - $ - $ - September $ - $ - $ - $ - $ - $ - Total $ 1,245,041.47 $ 249,008.29 $ 249,008.29 $ 249,008.29 $ 249,008.29 $ 249,008.29 *Percentage breakdown per Okaloosa County Ordinance No. 13-20, Sec. 20-72 (d) Page 8