|
<br />~
<br />
<br /> Pheasant Marsh Phase I
<br /> Debt Service Fund 327
<br /> Cash Flow Analysis
<br />Estimated Balance 6/1/2003 $662,466
<br /> Assessments Interest Debt Service Fiscal Fees Balance
<br />Year 2003 $0 $7,500 ($19,260) ($250) $650,456
<br />Year 2004 $0 $11,000 ($112,433) ($250) $548,773
<br />Year 2005 $0 $9,000 ($115,065) ($250) $442,458
<br />Year 2006 $0 $7,000 ($117,298) ($250) $331,910
<br />Year 2007 $0 $5,000 ($119,168) ($250) $217,492
<br />Year 2008 $0 $3,000 ($120,696) ($250) $99,546
<br />Year 2009 $0 $500 ($121,893) ($250) ($22,097)
<br />Year 2010 $0 $0 ($122,765) ($250) ($145,112)
<br />Year 2011 $0 $0 ($128,198) ($250) ($273,560)
<br />Year 2012 $0 $0 ($128,172) ($250) ($401,982)
<br />Year 2013 $0 $0 ($127,781) ($250) ($530,013)
<br /> $0 $43,000 ($1,232,729) ($1,750)
<br />Estimated Balance 12/31/2013 ($530,013)
<br /> ___u
<br />~j+--+-~~
<br /> Pheasant Marsh Phase II
<br /> Debt Service Fund 342
<br /> ---
<br />-T Cash Flow Analysis
<br />Estimated Balance 6/1/2003 $34,000
<br /> -~
<br /> Assessments Interest Debt Service Fiscal Fees Balance
<br /> --~--- ----
<br />Year 2003 $0 $250 ($18,642) ($250) $15,358
<br />Year 2004 $816,581 $17,000 ($22,370) ($250) $826,319
<br />------- -- -_.~------~- ---
<br />Year 2005 $0 - $15,000 ($76,545) ($250) $764,524
<br />------ --- ---~-~- ------
<br />Year 2006 $0 $14,000 ($74,895) ($250) $703,379
<br />Year 2007 $0 $12,000 ($73,245) ($250) $641 ,884
<br />Year 2008 $0 $11,000 ($76,520) ($250) $576,114
<br />Year 2009 $0 $10,000 ($74,630) ($250) $511,234
<br />Year 2010 $0 $9,000 ($77,470) ($250) $442,514
<br />Year 2011 $0 $8,000 ($79,988) ($250) $370,277
<br />Year 2012 $0 $6,000 ($77,275) ($250) $298,752
<br />Year 2013 $0 $4,000 ($74,475) ($250) $228,027
<br />Year 2014 $0 $3,000 ($76,538) ($250) $154,239
<br /> $816,581 $109,250 ($802,592) ($3,000)
<br />Estimated Balance 12/31/2014 $228,027
<br />Estimated Balance Both Phases ($301,986)
<br />
<br />5/22/2003
<br />
<br />2:54 PM
<br />
<br />Pheasant Marsh Phases I & II cash flow
<br />
|