HomeMy WebLinkAbout1.05 Exhibit EEXHIBIT E
Financial Plan
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
ROSE RANCH METROPOLITAN DISTRICT (GARFIELD COUNTY)
FINANCING PLAN for Ser. 2002 S 2007 Issues
Nonrated structure, 20 -yr bond maturities, 35 mills
^ N O 0 r N ON M .^- O rm 3 N^ M NN n M N V Eb O O' A A' . b N
= aviH$a8� NNNNN m" .L. ..Li ...._ 7.
i ,� Y' n 8 n
m
8 88 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8
is" s .�tmm = = = =0NCO
_= pp pp p p pp pp .
a S- E o 0 A. g E O 8 G 8 S s O 0 O O p O O OE A, 0 0 0 0 0 0 0 0 0
„ 5 a z s s> ��OO GGN Y O D 0 Ymo 0 0 D 0 D ANO O
pp pp
I O 0 0 0 r h N IT 10 O n Y O -o-N A Ol yOp' iO OI m 1� 2 N N
of aO r C �Opp� N O c'1 O OOH. N 0 N n _ N P O 0i O N N CO. pp N
< E N N m O< OD ON 0 A Ofl" N N n S 2 r N N 4 2 O N 0 2 M
2 C
8
o
m S
E
i
g
YM 3
1 !
S
88 88 88 88 88 88 88 pppp 88 88 p pp 88 pp SS 88 pp 88 88 88 88 SS 88 88 88
Ts E » 0 0 0 0 0 0 0 0 0 0 0 S 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
tea{ 888888888888888888888888888888
O
$•' 8 g v� a °ii 3 A 3 B^ v m m r 3 A .! 33 3 o' O 2 3 A
3i Nyxnm.00 $� :H� o<'i°" c'4",
pN
O 1
S
N
w 3 a i' m 5 e 5 rn^ F- ,i o F n§ F,ac m r r o m g E: Frn
e : N 0 2 ,g,' m `u .- 7: o o Li o$ n2 g
1'81 N N
ria "§§§,..,,,,,$)§,,,$.,§§§...,......0,.......,—,0
: N N N N N N N N N
u 1
g 8' n c ro sN h m 2. 2 M ' m YHm 2„2,
M^IA m N NN r e F.
Ar-n8 2 2
Onar omm"On , $nnn N2Oa r f .- _
3x41
EgE5QEEgEEQ83EE$EEQEQEEEg3Qn
M M M M M M M M M M M M M M M M M M M M M M M r.,-, `.
"' 8 YgY 2 A 7 8 'tpp S _ 4 4 R A: .F T8 Y8 m m YY 8�
o Y j E O T N N M n m 3 2 O A � Q O� b 1 N N 2 3- � N�pp N' A A
--8< » N e- .r- N N N N M M M M p M M M M p M M M A 8 M p M M p8M
0 8 0 0 0 0 0 0 0 0 00 O O O O 8 0 0 0 0 0 0 0 0 0 0 8 0 0
51' 22222212222,222222222222222=-82.
i3,1 » N N cV N N H N N N N N N N N N N N, N N C1 N N N N N N
p N `iO N N 0 b nri O O 22pp S O 2- pp
•6 N pp N m n M rt.'. I
11411 rnm`Aiii: mrA`A3E uoi gos ° 33�"AA
o^ i t. �» Y .--� Ner � NN 2 NNNM2 MM MMMM MM MM MMMM M M M MM MM Mo M
17 N NU` -
vm sp 8 8 o NS ♦ N " N N 2 2 S C 2 R n O V A A n n N ,flii N N
C lN a n AO^ M N M p 2 3 N E, E O 3 2N22t7M
i 3 '8 a 8 S P. 'I 8 MMMF.
ag 8 F 8 g '°
o F, a'
S' g a R - o 8 m N iD 01 O
_ _ N
m NN M .. NN b b b b to- r
CS 8 S O O 8 pp p O 0 O O 0 0i i• 00000
^NNO
<<1Ia n n r r r r r r r r r r r r r
i, b , 0 CNI0 N N N N N N N 0 0 0 0 0 00
w 3 a 8 8N N p
• b I 0 0 0 0 0 0
aMrB2
g a d » N N N
3n a c'4000BN
8
N
2-
-N
q
T O N N N N N N N N N N ry N ry N N N N N N N N N N
Prepared by Kirkpatrick Pettis
35 ml plan 2 lap
03/13/2000 8.44 AM Fin PI
NET DEBT SERVICE
ROSE RANCH METROPOLITAN DISTRICT
SERIES 2000 G.O. BONDS
Current interest bonds; proportional debt service
Financing plan includes tap fee revenue & golf course AV
Period Total Cap'd Int. @ Net
Ending Principal Interest Debt Service 5.00% Debt Service
12/01/2001 396,400 396,400 396,400
12/01/2002 396,400 396,400 396,400
12/01/2003 5,000 396,400 401,400 401,400
12/01/2004 5,000 396,000 401,000 401,000
12/01/2005 5,000 395,600 400,600 400,600
12/01/2006 45,000 395,200 440,200 440,200
12/01/2007 95,000 391,600 486,600 486,600
12/01/2008 145,000 384,000 529,000 529,000
12/01/2009 190,000 372,400 562,400 562,400
12/01/2010 250,000 357,200 607,200 607,200
12/01/2011 305,000 337,200 642,200 642,200
12/01/2012 305,000 312,800 617,800 617,800
12/01/2013 305,000 288,400 593,400 593,400
12/01/2014 355,000 264,000 619,000 619,000
12/01/2015 385,000 235,600 620,600 620,600
12/01/2016 430,000 204,800 634,800 634,800
12/01/2017 460,000 170,400 630,400 630,400
12/01/2018 510,000 133,600 643,600 643,600
12/01/2019 550,000 92,800 642,800 642,800
12/01/2020 610,000 48,800 658,800 658,800
4,955,000 5,969,600 10,924,600 792,800 10,131,800
Nov 22, 1999 12:06 pm Prepared by KIRKPATRICK PETTIS QUANTITATIVE GROUP (Rose Ranch Met DistROSERNC-OONR3)
BOND DEBT SERVICE
ROSE RANCH METROPOLITAN DISTRICT
SERIES 2000 G.O. BONDS
Current interest bonds; proportional debt service
Financing plan includes tap fee revenue & golf course AV
Dated Date 12/01/2000
Delivery Date 12/01/2000
Annual
Period Debt Debt
Ending Principal Coupon Interest Service Service
12/01/2000
06/01/2001 198,200 198,200
12/01/2001 198,200 198,200 396,400
06/01/2002 198,200 198,200
12/01/2002 198,200 198,200 396,400
06/01/2003 198,200 198,200
12/01/2003 5,000 8.000% 198,200 203,200 401,400
06/01/2004 198,000 198,000
12/01/2004 5,000 8.000% 198,000 203,000 401,000
06/01/2005 197,800 197,800
12/01/2005 5,000 8.000% 197,800 202,800 400,600
06/01/2006 197,600 197,600
12/01/2006 45,000 8.000% 197,600 242,600 440,200
06/01/2007 195,800 195,800
12/01/2007 95,000 8.000% 195,800 290,800 486,600
06/01/2008 192,000 192,000
12/01/2008 145,000 8.000% 192,000 337,000 529,000
06/01/2009 186,200 186,200
12/01/2009 190,000 8.000% 186,200 376,200 562,400
06/01/2010 178,600 178,600
12/01/2010 250,000 8.000% 178,600 428,600 607,200
06/01/2011 168,600 168,600
12/01/2011 305,000 8.000% 168,600 473,600 642,200
06/01/2012 156,400 156,400
12/01/2012 305,000 8.000% 156,400 461,400 617,800
06/01/2013 144,200 144,200
12/01/2013 305,000 8.000% 144,200 449,200 593,400
06/01/2014 132,000 132,000
12/01/2014 355,000 8.000% 132,000 487,000 619,000
06/01/2015 117,800 117,800
12/01/2015 385,000 8.000% 117,800 502,800 620,600
06/01/2016 102,400 102,400
12/01/2016 430,000 8.000% 102,400 532,400 634,800
06/01/2017 85,200 85,200
12/01/2017 460,000 8.000% 85,200 545,200 630,400
06/01/2018 66,800 66,800
12/01/2018 510,000 8.000% 66,800 576,800 643,600
06/01/2019 46,400 46,400
12/01/2019 550,000 8.000% 46,400 596,400 642,800
06/01/2020 24,400 24,400
12/01/2020 610,000 8.000% 24,400 634,400 658,800
4,955,000 5,969,600 10,924,600 10,924,600
Nov 22, 1999 12:06 pm Prepared by KIRKPATRICK PETTIS QUANTITATIVE GROUP (Rose Ranch Met DistROSERNC-00NR3)
NET DEBT SERVICE
ROSE RANCH METROPOLITAN DISTRICT
SERIES 2002 G.O. BONDS
Current interest bonds; proportional debt service
Financing plan includes tap fee revenue
Period Total Cap'd Int. @ Net
Ending Principal Interest Debt Service 5.00% Debt Service
12/01/2003 406,400 406,400 406,400
12/01/2004 406,400 406,400 406,400
12/01/2005 5,000 406,400 411,400 411,400
12/01/2006 5,000 406,000 411,000 411,000
12/01/2007 25,000 405,600 430,600 430,600
12/01/2008 60,000 403,600 463,600 463,600
12/01/2009 100,000 398,800 498,800 498,800
12/01/2010 145,000 390,800 535,800 535,800
12/01/2011 190,000 379,200 569,200 569,200
12/01/2012 185,000 364,000 549,000 549,000
12/01/2013 170,000 349,200 519,200 519,200
12/01/2014 210,000 335,600 545,600 545,600
12/01/2015 225,000 318,800 543,800 543,800
12/01/2016 250,000 300,800 550,800 550,800
12/01/2017 275,000 280,800 555,800 555,800
12/01/2018 310,000 258,800 568,800 568,800
12/01/2019 335,000 234,000 569,000 569,000
12/01/2020 370,000 207,200 577,200 577,200
12/01/2021 1,055,000 177,600 1,232,600 1,232,600
12/01/2022 1,165,000 93,200 1,258,200 1,258,200
5,080,000 6,523,200 11,603,200 812,800 10,790,400
Nov 22, 1999 1206 pm Prepared by KIRKPATRICK PETTIS QUANTITATIVE GROUP (Rose Ranch Met DistROSERNC-02NR5)
BOND DEBT SERVICE
ROSE RANCH METROPOLITAN DISTRICT
SERIES 2002 G.O. BONDS
Current interest bonds; proportional debt service
Financing plan includes tap fee revenue
Dated Date 12/01/2002
Delivery Date 12/01/2002
Annual
Period Debt Debt
Ending Principal Coupon Interest Service Service
12/01/2002
06/01/2003 203,200 203,200
12/01/2003 203,200 203,200 406,400
06/01/2004 203,200 203,200
12/01/2004 203,200 203,200 406,400
06/01/2005 203,200 203,200
12/01/2005 5,000 8.000% 203,200 208,200 411,400
06/01/2006 203,000 203,000
12/01/2006 5,000 8.000% 203,000 208,000 411,000
06/01/2007 202,800 202,800
12/01/2007 25,000 8.000% 202,800 227,800 430,600
06/01/2008 201,800 201,800
12/01/2008 60,000 8.000% 201,800 261,800 463,600
06/01/2009 199,400 199,400
12/01/2009 100,000 8.000% 199,400 299,400 498,800
06/01/2010 195,400 195,400
12/01/2010 145,000 8.000% 195,400 340,400 535,800
06/01/2011 189,600 189,600
12/01/2011 190,000 8.000% 189,600 379,600 569,200
06/01/2012 182,000 182,000
12/01/2012 185,000 8.000% 182,000 367,000 549,000
06/01/2013 174,600 174,600
12/01/2013 170,000 8.000% 174,600 344,600 519,200
06/01/2014 167,800 167,800
12/01/2014 210,000 8.000% 167,800 377,800 545,600
06/01/2015 159,400 159,400
12/01/2015 225,000 8.000% 159,400 384,400 543,800
06/01/2016 150,400 150,400
12/01/2016 250,000 8.000% 150,400 400,400 550,800
06/01/2017 140,400 140,400
12/01/2017 275,000 8.000% 140,400 415,400 555,800
06/01/2018 129,400 129,400
12/01/2018 310,000 8.000% 129,400 439,400 568,800
06/01/2019 117,000 117,000
12/01/2019 335,000 8.000% 117,000 452,000 569,000
06/01/2020 103,600 103,600
12/01/2020 370,000 8.000% 103,600 473,600 577,200
06/01/2021 88,800 88,800
12/01/2021 1,055,000 8.000% 88,800 1,143,800 1,232,600
06/01/2022 46,600 46,600
12/01/2022 1,165,000 8.000% 46,600 1,211,600 1,258,200
5,080,000 6,523,200 11,603,200 11,603,200
Nov 22, 1999 12:06 pm Prepared by KIRKPATRICK PETTIS QUANTITATIVE GROUP (Rose Ranch Met DistROSERNC-02NR5)