Agenda Packet TC 11/23/2015 - Special Session - Supplemental ItemsMCO COM MARKETS, INC.
SUMMARY OF BONDS REFUNDED
Trophy Club PID
PID Refunding, Series 2015 Preliminary Numbers (from BOSC)
Matches the Maturities
Maturity Interest Par Call Call
Bond Date Rate Amount Date Price
The Highlands at Trophy Club PID (From DTA), 2007REF:
CIBS 10/01/2016
7.750%
209,000.00
10/01/2017
7.750%
255,000.00
10/01/2018
7.750%
309,000.00
10/01/2017
100.000
10/01/2019
7.750%
368,000.00
10/01/2017
100.000
10/01/2020
7.750%
434,000.00
10/01/2017
100.000
10/01/2021
7.750%
503,000.00
10/01/2017
100.000
10/01/2022
7.750%
579,000.00
10/01/2017
100.000
10/01/2023
7.750%
662,000.00
10/01/2017
100.000
10/01/2024
7.750%
748,000.00
10/01/2017
100.000
10/01/2025
7.750%
846,000.00
10/01/2017
100.000
10/01/2026
7.750%
947,000.00
10/01/2017
100.000
10/01/2027
7.750%
1,059,000.00
10/01/2017
100.000
10/01/2028
7.750%
1,180,000.00
10/01/2017
100.000
10/01/2029
7.750%
1,315,000.00
10/01/2017
100.000
10/01/2030
7.750%
1,455,000.00
10/01/2017
100.000
10/01/2031
7.750%
1,609,000.00
10/01/2017
100.000
10/01/2032
7.750%
1,774,000.00
10/01/2017
100.000
10/01/2033
7.750%
1,957,000.00
10/01/2017
100.000
10/01/2034
7.750%
2,151,000.00
10/01/2017
100.000
10/01/2035
7.750%
2,365,000.00
10/01/2017
100.000
10/01/2036
7.750%
2,591,000.00
10/01/2017
100.000
10/01/2037
7.750%
2,839,000.00
10/01/2017
100.000
26,155,000.00
Nov 20, 2015 2:59 pm Prepared by SAMCO Capital Markets (MMM) (Trophy Club, Town of:TCPID-REF15D,REF15D) Page 1
CO CAPITAL MARKETK INC.
SOURCES AND USES OF FUNDS
Trophy Club PID
PID Refunding, Series 2015 Preliminary Numbers (from BOSC)
Matches the Maturities
Dated Date 12/01/2015
Delivery Date 12/22/2015
Sources:
Bond Proceeds:
Par Amount 26,410,000.00
Premium 4,273,695.90
30,683,695.90
Other Sources of Funds:
Contribution from Existing Bond Reserve 2,635,000.00
Contirbution from Current Admin Fund 142,398.48
-- 2,777,398.48
33,461,094.38
Uses:
Project Fund Deposits:
Prepayment/Delinquency Fund 250,000.00
Bond Reserve Fund 2,150,000.00
Administrative Fund 90,000.00
2,490,000.00
Refunding Escrow Deposits:
Cash Deposit 0.01
SLGS Purchases 29,805,473.00
`29,805,473.01
Cost of Issuance:
Other Cost of Issuance 525,000.00
Underwriter's Discount:
Average Takedown 132,050.00
Management Fee 13,205.00
Expenses 10,000.00
Underwriter's Counsel 60,000.00
215, 255.00
Other Delivery Date Expenses:
Bond Insurance 424,229.16
Other Uses of Funds:
Additional Proceeds 1,137.21
33,461,094.38
Nov 20, 2015 2:59 pm Prepared by SAMCO Capital Markets (MMM) (Trophy Club, Town of:TCPID-REF35D,REFI5D) Page 2
U
Ln
O
m
E
0
N
al
L
E
N
z
iI
p � 7
d c M
E
U
> L
CL n
L D. N
O Y
to
al
`n
06
C
C
7
aj
a1
K
D
a
Pli
o
� •c
Q1
Y cy
a
r
L
7 ate+
ID
tea p
2
C
cu
c
C
O
CL
E
U
C
O
m
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
000000000000000000
000000000000000000
Li ui ui ui ui ui ui ui ui ui ui ui ui ui ui ui ui ui
O Ln o o o o o o o Ln O O Ln o o O o o
i
O l lD rl M O N M u1 t\ r, tb t\ O1-4 d O O
w h u1 M It O m m lD O t\ N d O M lD w d
w O M 0a m O d n O O 0 d m d 0 N N n
M N d d 01 W 1� m O M N Lr lD u1 M rl u1 M
r, m v ri o w Ln v o v m v m o + tri of
M l0 01 rl X0.1 .m-1 N N N N M M m M M MIct
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
1 1-4-4 -4 -4 -4 -4 -4
m Ln Ln Ln ut 0 Ln Ln
N N N N N N N N
0 0 0 0 0 0 0 0
N N N N N N N N
0 0 0 0 0 0 0 0
W t\D l\D l\D l\D l\D l\D l\D
00000000
o c c It 0
N .-1 lD O N N rl 0
M u1 lD 00 C1 O - N
m en M M M d d d
U U U U U U U U
n m w m r O lD N 01 Ln .1 N uY O n l0 I- O
d M u1 n r1 O m N e-1 lD lD .-1 l0 N n M m lD
tb .--4 w N ri O O O Ln r-1 O lD r-1 n N W m m
rq u1 n O d lD h m W W m W m r� n lD lD m
O O O .--i .-i r -i r -i .-4 r -i r -i -t r -i r -i .--i .-4 .1 .--i .--4
14 14 rl r -I r -I r -I r -I r rl r -I r-4 r -I r -I r -I r -I
0 0 0 e o o\ o 0 0 0 0 el\\ o Z9 o
000000000000000000
O ut O O Ln ut O O O ut Ln O ut O ut 0 un 0
tb M t\ 01 ri M lD 0a O N 'i N N m m d d u1
O -4 -4 -4 N N N N M M M m m m fn M t'n M
o o 9 o o \ o 0 0 0 0 0 0* o h o
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
000000000000000000
O O O O m 0 Ln 0 u, Ln 0 uLn Ln
ui ui ui ui ui tri ut ui ui ut vi ui i i o o o ut
000000000000000000
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
000000000000000000
o Lr o 0 o ui ui ui o ui o o ui o ui o o ui
0u1 N m t\ LM d d u1 u1 I- m r-1 u1 M d0 w
dr, W W M O -4 N M d u1 W W M O N d u1
N- ri '-1 - r '-1 - r-1 N N N N
lD f� 00 m O-4 N M V u1 lD t\ w m O r-1 N m
r-1 N N N N N N N N N N m M m M
000000000000000000
N N N N N N N N N N N N N N N N N N
-4 14
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
-W-
000000000000000000
O
m
ui
m
lD
tri
t\
N
It
w
to
m
a
0
ut
LL
LULL
p
Ln
'i
uj
W
K
p
a
U
F-
CL a
0
U
co
m
E
0
w
N
UJ
EN
3 T
Z 41
0 ` ._
a m10
E
U 'aN
s
L Q �'
CL
N
2 N1 i
O N
N
N
Ln
OU
S
0
c
3
v
a
o � o
N 1 to
-4 O O
N Ln f,
00ti to
.4 00 m
lqt
a
tkom
a
C
Ln
1-4
LL
W
K
Ln
N
rl
LL
W
K
0
CL
U
h
4-
0
c
3
0
U
L
O
+1
v
Y
f0
6
(U
Y
CL
m
U
0
U
Q
V1
A
d
m
CL
v
a
E
CL
0)
In
N
Ln
,4
O
N
O
N
O
Z
to O
Ln
Ln Ln
�
�
-4 1-1
0 Q1
O1 O
Qt
61
00 O
00 vi
0)
00) LN
N'`-1
O l0
l0 N
1;3
a
\
�
00
00
N-1 WO
N
00 .-1
l0
LO
. .N-1
N
l0 N
ct
N
I
mm (
cr,O
m
a-+
C
7
O
u
N
O
_
�^
w ro 0
c
3
E
v
u
O O3
p
3
o
a U
>
E'
Q E
3 v
s
n
v
41
`
ou
i
d o.
a. D
03 Q
z
lqt
a
tkom
a
C
Ln
1-4
LL
W
K
Ln
N
rl
LL
W
K
0
CL
U
h
4-
0
c
3
0
U
L
O
+1
v
Y
f0
6
(U
Y
CL
m
U
0
U
Q
V1
A
d
m
CL
v
a
E
CL
0)
In
N
Ln
,4
O
N
O
N
O
Z
CO COM NAMTS, NC.
BOND DEBT SERVICE
Trophy Club PID
PID Refunding, Series 2015 Preliminary Numbers (from BOSC)
Matches the Maturities
Dated Date 12/01/2015
Delivery Date 12/22/2015
Period
Ending
Principal
Coupon
Interest
Debt Service
Annual
Debt Service
06/01/2016
400,000
5.000%
635,216.04
1,035,216.04
09/30/2016
1,035,216.04
12/01/2016
709,112.50
709,112.50
06/01/2017
755,000
5.000%
709,112.50
1,464,112.50
09/30/2017
2,173,225.00
12/01/2017
690,237.50
690,237.50
06/01/2018
820,000
5.000%
690,237.50
1,510,237.50
09/30/2018
2,200,475.00
12/01/2018
669,737.50
669,737.50
06/01/2019
890,000
5.000%
669,737.50
1,559,737.50
09/30/2019
2,229,475.00
12/01/2019
647,487.50
647,487.50
06/01/2020
970,000
5.500%
647,487.50
1,617,487.50
09/30/2020
2,264,975.00
12/01/2020
620,812.50
620,812.50
06/01/2021
1,055,000
5.500%
620,812.50
1,675,812.50
09/30/2021
2,296,625.00
12/01/2021
591,800.00
591,800.00
06/01/2022
1,145,000
5.500%
591,800.00
1,736,800.00
09/30/2022
2,328,600.00
12/01/2022
560,312.50
560,312.50
06/01/2023
1,245,000
5.500%
560,312.50
1,805,312.50
09/30/2023
2,365;625.00
12/01/2023
526,075.00
526,075.00
06/01/2024
1,350,000
5.500%
526,075,00
1,876,075.00
09/30/2024
2,402,150.00
12/01/2024
488,950.00
488,950.00
06/01/2025
1,455,000
5.500%
488,950.00
1,943,950.00
09/30/2025
2,432,900.00
12/01/2025
448,937.50
448,937.50
06/01/2026
1,570,000
5.500%
448,937.50
2,018,937.50
09/30/2026
2,467,875.00
12/01/2026
405,762.50
405,762.50
06/01/2027
1,690,000
5.500%
405,762.50
2,095,762.50
09/30/2027
2,501,525.00
12/01/2027
359,287.50
359,287.50
06/01/2028
1,815,000
5.500%
359,287.50
2,174,287.50
09/30/2028
2,533,575.00
12/01/2028
309,375.00
309,375.00
06/01/2029
1;950,000
5.500%
309,375.00
2,259,375.00
09/30/2029
2,568,750.00
12/01/2029
255,750.00
255,750.00
06,/01/2030
2,095,000
5.500%
255,750.00
2,350,750.00
09/30/2030
2,606,500.00
12/01/2030
198,137.50
198,137.50
06/01/2031
2,240,000
5.500%
198,137.50
2,438,137.50
09/30/2031
2,636,275.00
12/01/2031
136,537.50
136,537.50
Nov 20, 2015 2:59 pm Prepared by SAMCO Capital Markets (MMM) (Trophy Club, Town of:TCPID-REF15D,REF15D) Page 5
CO CAP % INC.
BOND DEBT SERVICE
Trophy Club PID
PID Refunding, Series 2015 Preliminary Numbers (from BOSC)
Matches the Maturities
Period
Ending
Principal
Coupon Interest
Debt Service
Annual
Debt Service
06/01/2032
2,400,000
5.500% 136,537.50
2,536,537.50
09/30/2032
2,673,075.00
12/01/2032
70,537.50
70,537.50
06/01/2033
2,565,000
5.500% 70,537.50
2,635,537.50
09/30/2033
2,706,075.00
26,410,000
16,012,916.04
42,422,916.04
42,422,916.04
Nov 20, 2015 2:59 pm Prepared by SAMCO Capital Markets (MMM) (Trophy Club, Town of:TCPID-REF15D,REF15D) Page 6
SAMCO UM HARM� INC.
SAVINGS
Trophy Club PID
PID Refunding, Series 2015 Preliminary Numbers (from BOSC)
Matches the Maturities
Present Value
Date
Prior
Debt Service
Refunding
Debt Service
Savings
to 12/22/2015
@ 3.3743040%
09/30/2016
1,013,506.25
1,035,216.04
-21,709.79
-15,806.42
09/30/2017
2,227,913.75
2,173,225.00
54,688.75
72,349.72
09/30/2018
2,255,933.75
2,200,475.00
55,458.75
71,708.89
09/30/2019
2,288,078.75
2,229,475.00
58,603.75
73,287.53
09/30/2020
2,320,845.00
2,264,975.00
55,870.00
69,688.73
09/30/2021
2,355,767.50
2,296,625.00
59,142.50
71,392.75
09/30/2022
2,388,458.75
2,328,600.00
59,858.75
70,876.34
09/30/2023
2,422,531.25
2,365,625.00
56,906.25
67,552.34
09/30/2024
2,457,442.50
2,402,150.00
55,292.50
65,470.05
09/30/2025
2,488,805.00
2,432,900.00
55,905.00
65,093.21
09/30/2026
2,525,037.50
2,467,875.00
57,162.50
65,282.31
09/30/2027
2,556,558.75
2,501,525.00
55,033.75
63,088.54
09/30/2028
2,590,826.25
2,533,575.00
57,251.25
63,960.82
09/30/2029
2,625,065.00
2,568,750.00
56,315.00
62,783.31
09/30/2030
2,663,383.75
2,606,500.00
56,883.75
62,692.43
09/30/2031
2,696,046.25
2,636,275.00
59,771.25
63,941.56
09/30/2032
2,731,316.25
2,673,075.00
58,241.25
62,623.47
09/30/2033
2,765,225.00
2,706,075.00
59,150.00
62,768.19
09/30/2034
2,803,648.75
2,803,648.75
1,543,201.55
09/30/2035
2,838,463.75
2,838,463.75
1,511,730.68
09/30/2.036
2,877,468.75
2,877,468.75
1,482,892.83
09/30/2037
2,911,423.75
2,911,42.3.75
1,451,868.46
09/30/2038
2,949,011.25
2,949,011.25
1,423,110.00
57,752,757.50
42,422,916.04
15,329,841.46
8,531,557.29
Savings Summary
PV of savings from cash flow 8,531,557.29
Less: Prior funds on hand -2,777,398.48
Plus: Refunding funds on hand 2,491,137.21
Net PV Savings 8,245,296.02
Nov 20, 2015 2:59 pm Prepared by SAMCO Capital Markets (MMM) (Trophy Club, Town of:TCPID-REF15D,REF35D) Page 7
CO COMUMTS, Nc.
SUMMARY OF REFUNDING RESULTS
Trophy Club PID
PID Refunding, Series 2015 Preliminary Numbers (from BOSC)
Matches the Maturities
Dated Date
12/01/2015
Delivery Date
12/22/2015
Arbitrage yield
3.374304%
Escrow yield
0.789612%
Value of Negative Arbitrage
1,249,364.56
Bond Par Amount
26,410,000.00
True Interest Cost
3.862228%
Net Interest Cost
4.243360%
All -In TIC
4.102322%
Average Coupon
5.489150%
Average Life
11.046
Paramount of refunded bonds 26,155,000.00
Average coupon of refunded bonds 7.750000%
Average life of refunded bonds 15.363
PV of prior debt to 12/22/2015 @ 3.374304% 39,899,113.63
Net PV Savings 8,245,296.02
Percentage savings of refunded bonds 31.524741%
Nov 20, 2015 2:59 pm Prepared by SAMCO Capital Markets (MMM) (Trophy Club, Town of:TCPID-REF15D,REF15D) Page 8