|
Bond Issue Date
<br />9/1/2021
<br />Capitalized Interest (Months)
<br />18
<br />W Bighted Avg. Bond yield
<br />S.SO%
<br />Bond Term (Years) [b]
<br />30
<br />First Year Adman $
<br />35,000
<br />Underwriter Discount
<br />3.00%
<br />Cost of Issuance
<br />6.00%
<br />Developer District Formation Costs $
<br />200,000
<br />EXHIBIT G
<br />Bond Sizing Analysis
<br />Whisper South
<br />Exhibit G
<br />Bond Sizing Analysis
<br />4/12/2021
<br />Sources:
<br />Par Bond Amount
<br />$
<br />14,090,000
<br />Uses:
<br />Capitalized Interest
<br />$
<br />1,155,000
<br />Reserve Fund
<br />$
<br />993,250
<br />Underwriter Discount
<br />$
<br />420,000
<br />Cost of Issuance
<br />$
<br />840,000
<br />Developer Distr Form Costs
<br />$
<br />290,000
<br />First Year Collection Costs
<br />$
<br />35,000
<br />Improvement Fund
<br />$
<br />10,356,750
<br />Total Uses
<br />$
<br />14,000,000
<br />Existing Tax Rate
<br />$ 2.204
<br />Equivalent PID Rate
<br />0.214
<br />Total Equivalent Tax Rate
<br />$ 2.418
<br />Avg. Annual PID Installment
<br />$ 1,084,242
<br />Min DSC Ratio
<br />1.000
<br />2022
<br />$
<br />-
<br />5.50% 1
<br />170,000
<br />$
<br />170,000
<br />$ - $
<br />aa'.
<br />10,000
<br />$ 840,000
<br />$ (770,000)
<br />$
<br />70,000
<br />.<
<br />2023
<br />$
<br />-
<br />5.50ss $
<br />770,000
<br />$
<br />770,000
<br />$ 35,700 $
<br />70,000
<br />$ 875,700
<br />$ (385,000)
<br />$
<br />490,700
<br />.,
<br />2024
<br />$
<br />229,000
<br />5.50% $
<br />770,000
<br />$
<br />990,909
<br />$ 36,414 $
<br />70,000
<br />$ 1,096,414
<br />$ -
<br />$
<br />1, 096,414
<br />2025
<br />$
<br />235,000
<br />5.50% $
<br />757,900
<br />$
<br />992,909
<br />$ 37,142 $
<br />68,900
<br />$ 1,098,942
<br />$ -
<br />$
<br />1,098,942
<br />.,
<br />2026
<br />$
<br />245,000
<br />5.50% $
<br />744,975
<br />$
<br />989,975
<br />$ 37,885 $
<br />67,725
<br />$ 1,095,585
<br />$ -
<br />$
<br />1,095,585
<br />1,
<br />2027
<br />$
<br />269,000
<br />5.50% $
<br />731,500
<br />$
<br />991,509
<br />$ 38,643 $
<br />66,500
<br />$ 1,096,643
<br />$ -
<br />$
<br />1,096,643
<br />2028
<br />$
<br />275,000
<br />5.50% $
<br />717,200
<br />$
<br />992,209
<br />$ 39,416 $
<br />65,200
<br />$ 1,096,816
<br />$ -
<br />$
<br />1,096,816
<br />.
<br />2029
<br />$
<br />299,000
<br />5.50% $
<br />702,075
<br />$
<br />992,975
<br />$ 40,204 $
<br />63,825
<br />$ 1,096,104
<br />$ -
<br />$
<br />1,096,104
<br />2030
<br />$
<br />305,000
<br />5.50% $
<br />686,125
<br />$
<br />991,125
<br />$ 41,008 $
<br />62,375
<br />$ 1,094,508
<br />$ -
<br />$
<br />1,094,508
<br />0
<br />2031
<br />$
<br />320,000
<br />S.SO% $
<br />669,350
<br />$
<br />9893SO
<br />$ 41,828 $
<br />60,8SO
<br />$ 1,092,028
<br />$ -
<br />$
<br />1,112,121
<br />1. I.
<br />2032
<br />$
<br />340,000
<br />5.50% $
<br />651,750
<br />$
<br />991,750
<br />$ 42,665 $
<br />59,250
<br />$ 1,093,665
<br />$ -
<br />$
<br />1, 093, 665
<br />,..
<br />2033
<br />$
<br />360,000
<br />5.50% $
<br />633,050
<br />$
<br />993,050
<br />$ 43,518 $
<br />57,550
<br />$ 1,094,118
<br />$ -
<br />$
<br />1,094,118
<br />2034
<br />$
<br />389,000
<br />5.50% $
<br />613,250
<br />$
<br />993,259
<br />$ 44,388 $
<br />55,750
<br />$ 1,093,388
<br />$ -
<br />$
<br />1,0931381
<br />14
<br />203S
<br />$
<br />409,000
<br />S.SO% $
<br />S92,3SO
<br />$
<br />992,3SO
<br />$ 4S,276 $
<br />53,8SO
<br />$ 1,091,476
<br />$ -
<br />$
<br />1,091,476
<br />1
<br />2036
<br />$
<br />429,000
<br />5.50% $
<br />570,350
<br />$
<br />990,359
<br />$ 46,182 $
<br />51,850
<br />$ 1,088,382
<br />$ -
<br />$
<br />1, 088,382
<br />2037
<br />$
<br />445,000
<br />S.SO% $
<br />547,250
<br />$
<br />992,250
<br />$ 47,105 $
<br />49,750
<br />$ 1,089,105
<br />$ -
<br />$
<br />1,089, 105
<br />17
<br />2038
<br />$
<br />479,000
<br />5.50% $
<br />522,775
<br />$
<br />992,775
<br />$ 48,047 $
<br />47,525
<br />$ 1,088,347
<br />$ -
<br />$
<br />1, 088, 347
<br />,
<br />2039
<br />$
<br />495,000
<br />5.50% $
<br />496,925
<br />$
<br />991,925
<br />$ 49,008 $
<br />45,175
<br />$ 1,086,108
<br />$ -
<br />$
<br />1,086,108
<br />I.')
<br />2040
<br />$
<br />529,000
<br />S.SO% $
<br />469,700
<br />$
<br />999,709
<br />$ 49,989 $
<br />42,700
<br />$ 1,082,399
<br />$ -
<br />$
<br />1,082,389
<br />tJ
<br />2041
<br />$
<br />SSU,000
<br />S.SU% 5
<br />441,100
<br />$
<br />991JOU
<br />$ SU,9BB $
<br />40,1OU
<br />$ 1,OB2,168
<br />$ -
<br />$
<br />1, UB2, 1BB
<br />!.I
<br />2042
<br />$
<br />589,000
<br />5.50% $
<br />410,850
<br />$
<br />990,859
<br />$ 52,008 $
<br />37,350
<br />$ 1,080,208
<br />$ -
<br />$
<br />1,080,208
<br />2l
<br />2043
<br />$
<br />619,000
<br />5.50% $
<br />378,950
<br />$
<br />988,959
<br />$ 53,048 $
<br />34,450
<br />$ 1,076,448
<br />$ -
<br />$
<br />1,076,448
<br />7 ^
<br />2044
<br />$
<br />645,000
<br />5.50% $
<br />345,400
<br />$
<br />990,400
<br />$ 54,109 $
<br />31,400
<br />$ 1,075,909
<br />$ -
<br />$
<br />1,075, 909
<br />/�.
<br />2045
<br />$
<br />689,000
<br />5.50% $
<br />309,925
<br />$
<br />989,925
<br />$ 55,191 $
<br />28,175
<br />$ 1,073,291
<br />$ -
<br />$
<br />1,073,291
<br />2046
<br />$
<br />729,000
<br />5.50% $
<br />272,525
<br />$
<br />992,525
<br />$ 56,295 $
<br />24,775
<br />$ 1,073,595
<br />$ -
<br />$
<br />1,073,595
<br />Ili
<br />2047
<br />$
<br />769,000
<br />5.50% $
<br />232,925
<br />$
<br />992,925
<br />$ 57,421 $
<br />21,175
<br />$ 1,071,521
<br />$ -
<br />$
<br />1,071,521
<br />2048
<br />$
<br />800,000
<br />5.50% $
<br />191,125
<br />$
<br />991,125
<br />$ 58,570 $
<br />17,375
<br />$ 1,067,070
<br />$ -
<br />$
<br />1,067,070
<br />21,
<br />2049
<br />$
<br />945,000
<br />5.50% $
<br />147,125
<br />$
<br />992,125
<br />$ 59,741 $
<br />13,375
<br />$ 1,065,241
<br />$ -
<br />$
<br />1,065,241
<br />J:9
<br />2050
<br />$
<br />890,000
<br />5.50% $
<br />100,650
<br />$
<br />990,650
<br />$ 60,936 $
<br />9,150
<br />$ 1,060,736
<br />$ -
<br />$
<br />1,060,736
<br />20S1
<br />$
<br />940,000
<br />S.SO% $
<br />S1,700
<br />$
<br />991,700
<br />$ 62,LSS $
<br />4,700
<br />$ 1,058,SSS
<br />$
<br />$
<br />1,058, SSS
<br />Total
<br />$
<br />14,000,000
<br />5.50% $
<br />15,298,800
<br />$
<br />29,298,800
<br />$ 1,384,883 $
<br />1,390,800
<br />$ 32,074,483
<br />$ (1,155,000) $
<br />- $
<br />30,919,483
<br />Footnotes:
<br />[a] Estimatesfor illustration
<br />purposes only. Actual
<br />date, interest rate, and amountsto be determined.
<br />[b] Assumes
<br />year 1
<br />administrative
<br />expenses are included
<br />in the cost of
<br />issuance.
<br />PID Petition 32
<br />
|