Loading...
HomeMy WebLinkAboutCS 21-06 Report CS 21-06 Date: April 1 0, 2006 Subject: Cash Position Report as at December 31, 2005 Page 2 Outstandinq Investments: Attachment 3 reflects the short-term and long-term investments for both the Current Fund and the Reserve Funds outstanding as at December 31, 2005. There has been a steady increase in investments over the past few years primarily a result of use of funds on hand due to pending assessment appeal and timing of collection and remittance of development charges. Development Charqes Collected: Attachment 4 indicates the total development charges for the City, Region and School Boards, as the City is responsible for collecting development charges on behalf of all levels of government. The total amount collected of $889,387 agrees with the balance indicated under Sources of Funds on Attachment 1. However the remittance of development charges to the Region and School Boards indicated under the Use of Funds is different than the total collected on Attachment 4. This variance is a result of timing differences because payments to the Region and School Boards are due 25 days following the month collected. Other Development Contributions: Attachment 5 is provided to show other significant development contributions that have been received. Attachments: 1 . Statement of Cash Position 2. Continuity of Taxes Receivable 3. Outstanding Investments 4. Statement of Development Charges Collected 5. Other Development Contributions 6. City Portion of Development Charges Collected 2003-2005 7. Building Permits Issued 2000-2005 8. City Portion of Development Charges Collected 1991-2005 Prepared By: Approved I Endorsed By: ~-{? Avril Payne Audit Analyst ~~ '13IIIis A. Paterson Director, Corporate Services & Treasurer Attachments Copy: Chief Administrative Officer Recommended for the consideration of Pickering City ouncil ,/ J 4/ () t ATTACHMEI\!T# "_.Te) REPORT#~.)I "'ok City of Pickering Cash Position Statement for three months ending December 31, 2005 Sources of Funds: Accounts Receivable collected $ 266,710 Development charges collected 889,387 Operating 21,448,004 Grants-in-lieu: Federal 456,428 Provincial 60,746 Ontario enterprises 4,725,861 Municipal enterprises 638,286 Linear Properties - Federal specific grants 15,135 Ontario specific grants 18,585 Interest Income 156,697 Sale of land - Tax payments received 28,582,248 POA Revenue - Total $ 57,258,087 Use of Funds: Operating and Capital Expenditures $ 29,868,605 Payroll 7,152,392 Region Levy 20,403,370 Regional portion of Dev. Charges 1,295,799 School Board Levies 10,843,147 School Board portion of Dev. Charges 155,400 Debenture payment to Region 582,781 APTA Funding 97,134 Total $ 70,398,628 Net Cash Increase (Decrease) $ (13,140,541) FINANCIAL POSITION Bank Balance Net Cash Bank Balance October 1, 2005 Provided (Used) December 31,2005 Current Fund $ 15,684,476 $ (13,140,541) $ 2,543,935 TOTAL $ 15,684,476 $ (13,140,541) $ 2,543,935 Note: Includes City, Region and School Boards Cash Position final quarter 2005.xlsNET CHANGES REPORT TO EXECUTIVE COMMITTEE Report Number: CS 21-06 Date: April 1 0, 2006 From: Gillis A. Paterson Director, Corporate Services & Treasurer Subject: Cash Position Report as at December 31,2005 Recommendation: It is recommended that report CS 21-06 from the Director, Corporate Services & Treasurer be received for information. Executive Summary: The attached schedules provide the City of Pickering's cash position, continuity of taxes receivable, outstanding investments, development charges collected and other development contribution information for the three months ended December 31 2005. Financial Implications: The cash position of the Corporation for three months ended December 31,2005 was a net decrease in cash of $13,140,541 to $2,543,935. Sources of Funds totalled $57,258,087 and Use of Funds totalled $70,398,628. Background: The discussion below describes the purpose and the information contained in each of the attached schedules. Statement of Cash Position: Attachment 1 reflects the sources and uses of funds for the final quarter of 2005. Subcategories have been identified to highlight those cash transactions that are significant in nature or large dollar value transactions for the City of Pickering. Year to year periodical comparisons may not be useful due to timing. Continuity of Taxes Receivable: Attachment 2 summarizes the tax related transactions from October 1 to December 31,2005 and provides the outstanding taxes receivable as at December 31, 2005. This balance represents all three levels of taxes billed, such as City, Region and School Boards. This amount has steadily increased for the same period over the past several years but may vary where due dates and amounts for supplementary billings change from year to year. C'I a> r:: :ë :g liS 0 .::= N a> o 0r- a> ('I') 0:: (/) a> >< liS I- 'Þ- o ~ ::: .¡: a> ~ o ~ 'Þ- o ~ ..... LO o - """ M Ö 0> o ~ Q) ..0 E a> o Q) C C'I ::I .: r:: "C :.;:; r:: r:: a> o (/) () ..r:: ..... r:: o E Q) Q) ~ ..r:: ..... ~ .E >< I'G I- () "'0 If) I: .. I'G I: If) 0> .. E I: .. 0> If) E ::::s >. :0 ~ « ~ "'0 1: ~ 0> m ~ If) c. ~ 0.. I'G ::::s I- (j) If) 0> >< I'G I- "'0 I: I'G >. .. ïã I: Q) a. LO o - o M .... 0.. 0> (j) 0> .D I'G > 'Q) U 0> 0:: If) :::: o 0> .. '¡: ~ "'0 ~ m "'0 0> "'0 "'0 « .. If) 0> I- 0> .. I: ~ .D I'G > 'Q) U 0> 0:: LO (0 t- '¢ o t- CO t- .,.- CO N N LO fh fh ........- 0) 0) N .,.- ('I') (0. ('I') .,.- (0 N ~~ t- ~ fh ........ .,.- (0 O. 0) t- .,.- ....... N '¢ O. N o t- fh fh fh fh ~ 0 '¢. ~ CO ('I') 2 co N ('I') LO 0 LO LO LOCO co (0 t- LO ('I') N N ........- ('1')0 ('I')M C!:!. O. co LO LO N ~S ........ '¢ N N co t- ....... N 0 (0 t- '¢. LO 0) '¢ N M LO '¢ ('1'). (0 N ('I') o 0 LO (0 0) 0 LO co .,.- LO g¡ N in ( ) L.. ( ) ë ('I')'¢ '¢ '¢ LO co '¢ N ('I') '¢ LO ........- ('I') (0 t- ('I') LOCO .,.- N O!£, ~ - ('I') o ('I') .,.- - o N CO c5 0) o '¢ LO co ~~ N t- o (0 t- in ( ) L.. ( ) C OLO '¢O t-LO OLO '¢O) t-.,.- ~~ t-CO .,.-'¢ .,¡.,.- (O'¢ -....... - '¢ N co c5 LO - t- O) N co M coco ('1')('1') t- t- LOO LO.,.- CON in ( ) L.. .2 E ï:J C (1j :è C ~ ro ( ) X C L.. (1j 0> :;1-0... ü ï:J ï:J ï:J C C C (1j (1j ~ (1j cn:è cn:è~cn:è ( )ro ~~>-~~ '¢ ~ fj3 ('I') (1j ( ) L.. (1j ( ) 25 I- 0... 25 I- 0... .g I- 0... N N 0... L.. (1j ( ) >- TTACHMENT#--:2.... TO REPORT#~5.)I.iì ¡::- t- CD 0:;- M C"t 00 N - M """ '¢ a) o !2 '¢ t- O cD CD 00 o CO '¢ N (0 N o """ t-~ """ 00 ~ M CD """ Lt'Ì LO q 00 M in ( ) L.. ( ) ë ..J « I- o I- LO o o N a) N ...; o..LO 0>0 (j)o oðN LO"¡ """ """ >....; - u ~O -- ïãïã I: I: ü:Ü: -- LOLO 00 00 NN 0:;-0:;- NN M N M CD """ 00 ~ o ,.: M """ fh If) "'0 I- I'G o m o o J: U (j) "'0 I: I'G I: ,2 C> Q) c::: C> I: "'0 ::::s Õ I: -- "¡: ..~ 0..0.. «« oðoð LOLO NN ~~ I'G I'G ::::s ::::s I- I- .D.D 0> 0> LLLL -Ê E .- ._ l- I- 0> 0>- - I: 1:- -- - I'G I'G :¡:; ë3 I: I- 0> 0> "'0 E ëñ E 0> 0 0::0 If) 0> .. I'G "C 0> ::::s "'0 LO o o N I: "'0 0> "::; 0> ..J If) 0> >< I'G I- I'G - o I- .. I: 0> E I'G - If) I: >< I'G I- LO o o N LO o o N Lt'Ì """ c,) 0> o oð LO o o N o~ M I- 0> .D E 0> > o z Lt'Ì o o N o M ...; U o I- 0> "C I: ::::s If) .. I: 0> E .. If) ::::s ....... "'0 I'G "'0 0> > o I- 0.. 0.. I'G "(j C ::::s o o "'0 I: I'G If) I: o ëñ ë3 0> o "'0 I- I'G o a:1 ~ 0> .::; Q) 0:: .. I: Q) E If) If) Q) If) If) « If) 0> - I'G "'0 0> ::::s "C >< I'G I- ~ I'G - I: 0> E Q) C. 0.. ::::s (j) LO o o N .. I: 0>""" E8 O>N :¡:¡ ~ .. .. 0> U (j)« .... - o I'G If) ,9- 0> u .. .- ::::s I: I: ::::s ,- :æ: ~ 0> 1f)J: .." gõ 0;::00 O>LO I-M ~oð .... Or;:; O>M .. '¡: I: s: .2 .. >< (,) I'G 0> I-c/) C)!II) .5 c 0 ... Q) 0 Q) E N ~...""" ._ III M 0. Q) ... - > Q) o c .c ~ C) E Ü .5 8 'C Q) ; 0 ... 1ii ! ;j III o I'Ø ....- UI CQ ( ) ::I .. .. ( ) 0 ....0 .!:< .... UI ( ) .. ( ) .... .!: ñí~ (þ'¡: ::I ::I c;¡ñí >:æ UI >- CQCI) 0- ...0 o 'It ~ 't: .! ::I CQ ñío :æ ( ) UI CQ ( ) .s::..... o CQ :;0 0.. .... UI ( ) 1!!.... ( ) CQ ....0:: .!: c;¡.... o,C ._ ::I C.) 0 .!: E à:< _c ,!!! 0 u;:¡ c ::I as~ c.... ,_ III u..!: õ~ G,) .¡: E 13 CQ ( ) ZCl) <,,)I'-NIOOCO"-IO .... '<t<D1O'<t0>0>1'-<D CO') r--:C'ir--:":.o..rC'ir--: N o I'-'<tl'-NIONO> 0 co '<t I'- <D <D <") ..-..- 0 cDcriócriór-:LÔÑ Ñ N~N'r"ct) ('t) .... Ifi NO<DCO'<tOIOO> .... I'-NONNNCOI'- ~ r--:..r.or--:,,:.oom .... I'- <") <D co I'- <D N '<t I'- <D 0> I'- 0 N 10 co I'- co cõ ó r-: cõ cri LÔ cõ LÔ ..¡ NNN<")CO..-N"- II) N Ifi 00000000 0 00000000 0 00000000 c:i 00000000 0 00000000 0 ~~¡i~~~~~ ~ o..-COO<DOIOO "'. ...¡ c<i c<i LÔ r-: Ñ c<i Ñ .... CO') NW..........{:;;.....OtD 0> CO 0>0>..-0> 0> CO <D<D<D<D<D<D<D<D 00000000 I t I I I ¿ ¿ c:c:c:.cê;¡.cCQCQ ~~~æ:2æ:2:2 I I I I I I I <D<D<")<")..-I'-IOIO OON.....("')..-..-..... 1010101010101010 00000000 I I I I I I I I õõõ»>oo qqq~~~¿¡¿¡ ~~~~~~~~ '#.';}!.'#.'èfl'$.'$."$.;¡¿ N'<tO<DCOCONN COCO 0>0..-0 <")<") NNNC'iC'iC'iC'iC'i COO'<tN<DOIO"- II) NCOO>I'-I'-CO..-N II) N.o..rNcò..rmo cci N<D<")..-NC')1'-10 N C')ONO>I'-'<t..-N .... c<i r-: cri cri r-: ...¡ cD ~ ai MC'\I('t')O')NN""'''''' r-- O..-COO>IOOIOO o. ...¡ c<i c<i ...¡ r-: Ñ c<i Ñ .... CO') < « en enen ~ ~~ J!! Z ZZCI) ~« <êð<cêðêð ~ Eenen<cenl-enl-I- W ....üüenenenüenCl) :æ CI) g:enenozQ;!!!Q;Q; l- I- > c:: c:: I- en u. ü u. u. CI) ffi .5 ~ :æ ~ ~ :æ W IX > W ~ I- :æ ~ IX 0 W :t: I- CI) I- ..J ~ ~ :t: 0 en I- 'C c ::I U. ( ) ~ UI UI UI UI UI UI UI UI ~ c: c: c: c: c: c: c: c: ø ~ ~ ~ ~ ~ ~ ~ ~ IX en en en en en en en en oð;::;::;;~;::~~~ .....c.c.c.c.c.c.c.c ~~~~~~~~~ ::ZZZZZZZZ ::I (,) Ifi Ifi 10 <D o ..- ATTACHMENT# ..3 TO REPORT#~ ,.-(} ~ N 0> ..t ~ r-: ..- o 10 ..t ..- I'- '<t- ..- <D o .0 N 0_ ..- ~ J: 0 ...JÜ·§ ...Jt ...Jt ...Jt 5:; Q. :§~ãí~:§UJ :§UJ ::§UJ ~ Þ Z :2 ~ z en Z en z en >-...J '§ Zoð_¡;::Zoð Zoð Zoð ãí <1'--2!N<CO <cco <co J: :2 I N .- I I I t- - ~z.5~~C:: ~c:: ~c:: z~~~ UJ~~::IUJ<C UJ<C UJ<C 0<C~- en3~3(1)5roen5roCl)5ro:20.5re CI) I- Z W :æ I- CI) W > ~ :æ IX W l- e> z o ...J J!! c ( ) E .... UI ( ) > .5 'C c ::I U. ( ) ~ ( ) UI &! að .... c ( ) .. .. ::I (,) o o o o o Ó 10 N Ifi C') ..- , c: ::3 ""') ~ N <") 9 c: ::3 ""') ~ N ~ o o co C'i o o o o o Ó 10 N Ifi 0.. c:: o Ü I- 15 w c:: Ü :2 IX ~ UI c: :; en ::::: :ë UI OJ Z o o o o o Ó co 10. ..- <D o è. Q) CI) rJ:¡ o C') o > o Z ..t o ~ o o 10 C'i o o cò ~ cri I'- 10 ..- o ã: ~ z o u. o w Ü z :> o c:: 0.. UI c: :; en ::::: :ë UI Q) Z o o o o o LÔ <") C'). ..- o o o o o c<i 0> <D o è. Q) en rJ:¡ o <D o è. Q) en rJ:¡ o 10 9 >. CQ :2 ..t o <f!- o 10 C'i o 0> o I'- o cri '<t "1 ..- o ã: ~ Z o u. o w Ü Z :> o c:: 0.. UI c: :; en ::::: :ë UI Q) Z N C') d 0> I'- o N ..r '<t 0> ...¡ co o N <D I'- r-: N It) o I'- C'i iii o It) <D '" c<iö It) ~ ...J>...Jt ...JÜ <co<Cw <CW ~z~en ~o ~cð~oð ~oð <}'<t<}co <}N ~~~~ ~5~ ~5~5ro~3N LO o :>. CQ :2 .n o <f!- o LO C'i o N r--: <D 0> c<i 0> o ã: ~ Z o u. o w Ü Z ð c:: 0.. UI c: :; en - :ë UI Q) Z o o o o o Ó o LO c<i '<t ..- is o cD N '<t o is o cD N ~ o LO N ..t o o o o o Ó o LO c<i o ã: ~ z o u. o w Ü Z :> o IX 0.. UI E ::3 en - :ë UI Q) Z o o o o o cõ N <D <D o :>. CQ :2 ..t o LO o :>. CQ :2 ..t o ~ å o .0 N 10 cò N ..- c<i '<t <D 0.. c:: o Ü > w o ~ o c.. >< w UI c: :; en ::::: :ë UI Q) Z o o o o o ...¡ I'- '<t o 0 o 0 o c:i o 0 o 0 óö o II) <") .... "'¡Ñ .... I'- o ~ :2 rJ:¡ o o ..- , c: ::3 7 ..- N LO 9 c: ::3 ""') M o LO 9 c: ::3 ""') I ..- N ~ å N .0 ~ o LO o C'i o C') C'i I'- ..- c<i 0> '<t o N o en o r--: o It) o I'- óf1li o 0 C') N "'¡Ñ .... o ã: ~ Z o u. o w Ü Z :> o IX 0.. o ã: ~ z o u. o w ~ ~ :> z o W IX :¡¡¡ 0.. ~ W > ~ :æ IX UI W E I- ::3 e> en z ::::: 0 :ë ...J UI ...J Q) < Z I- o I- UI c: :; en ::::: :ë UI Q) Z Ifi Ifi Ifi !!! CQ Q) >. o ..- I C') Ë Cii I- w >- en w ¡:: ã: ~ Ü W en UI X .0 o o N ~ CQ .::3 C' iii c: ¡¡:: c: o .¡:; ëñ o 0.. .c: UI CIS Ü o o c:i o o ...¡ o It) M '<t o o ~ .... '<to .... en '" ItÎ Ifi Ifi ~ o I'- <") ..t I'- <D C'i -ö (jj >= CIO It) ui CIO CIO ...: CIO N M '<t Ifi en I- Z W :æ I- en W > ~ ...J < I- o I- CI) I- o W .., o 0:: 0.. ...J < l- ii: < o o I- CI) I- Z W :æ I- CI) W > ~ ..J < Z 0:: W I- ~ 0)" &n r;:CI)O .- .... 0 "'ON CI) CI) ~- O-or- ._ 0 ('I') ~O... 'Þ- en a> OCl)JJ ~ 0) E ._ ¡ CI) o,c° O~ 1:0) CI) r:: E=6 c.r:: o CI) Q; (/) >,c a>.... o g E CI) a> ... ,c .... ... .2 ¡¡; õfß- I- U ='C o ... .c CIS .... 0 ClSm (J_fß- E 0 CIS 0 .c.c ... u ~U) o .... .~ 'C ... ... .... CIS .~ 0 om Eõfß- CIS 0 .c.c ... u ~U) o E CIS .c ... ~ o õfß- C .2 C) Q) 0:: c o :e o C"fß- I/) ->0, .... õ o Cf) CD """ '<t co t-- LO t-- r--:- '<t o N Cf) """ N """ t-- Cf) M o co co '<t_ '<t Cf) co LO 0> o CD '<t N_ Cf) 0> Cf) .- t-- LO N """ o Cf) CD t-- """ o '<t .- 0> co M M o o W I- (J W ..J ...J o (J I- Z ::J o :æ « .... CJ.) .D o ..... L) o .... CJ.) .D E CJ.) > o Z .... CJ.) .D E CJ.) L) CJ.) CI .;;¡ 1.( ..... 00 M a; 00 00 en (Ø '<t Ñ -r- (Ø '<t '<t u) M ..... -r- 00 u) o '<t It) It) (Ø u) M '<t ..J « I- o I- REPORT# ('5 .J /-0(, o ~ - fJ) .... ¡¡:: 0> .c - t: ro .c - .... 0> .c .2> .c ~ ro .... 0> t ro :J c- "E .c - 0> .c - .... .E CD LO r-.. (J) ~ (J) ro (J) a> """">- ER-o C> . ¡:: .£ a. roB - 0"0 - 0> "0 .... .æ[ U E 0> a o 0 U 3: fJ) a 0>- C>O> (ij..Q .c a 0- - a> t: :J a> t: E+:i a.t: a 8 0> >- > 0> Q)..c: "0_ .c - C>~ :J a> at .c liS :!:: :J <{c- r, P,CH¡"lt:f"¡i H_..;î~_~rOREPORT# (:"S;; 1-,-)1. City of Pickering Other Development Contributions December 31, 2005 CONTRIBUTIONS: Cash - In - Lieu of Parkland $8,400 TOTAL CASH-IN-LlEU OF PARKLAND $8,400 Cash Position final quarter 2005.xlsOther Dev.Contrbtns flACHMENT#í..TO REPORTfLf_s"'¿/-()b .d ",¡ I/ì ....-= .... 0'= = ~ M 0 .... t "E ",¡I/ì 0 ....-= ~ ~ 0'= M .... ~ U ~ ",¡ I/ì t = ....-= (1) 0'= M M ~ U .... ",¡ I/ì (1) ~ ....-= ~ 0'= ,....-.4 M ,....-.4 0 .d ",¡~ ....-= U .... 0'= ~ ~ M 0 r.n lr) "E ",¡ ~ ....- = ~ (1)0 ~ 0'= M 0 000 .~ ~N "t:S ",¡ ~ = ....- = t: M 0'= ,..d I M 0 U ",¡ ~ ~ ('f) ....- ....-= ~ ~ 0'= 0 M Þ ~ 0 .d ",¡~ (1) .... ....- = .~ N ~ 0'= U S M "E ",¡ ~ ~ ....-= ~ 0'= 0 M ,....-.4 ",¡~ (1) ~ = ....- = > M 0'= M (1) ",¡~ Q ....- ~ ....-= ~ 0'= M = = = = = = = = = = = = = = = = . . . . . . . . = = = = = = = = = = = = = = = = = = = = = = ... ... ... ... ... ... ... = = = = = = = = = = = = = = ~ M = QC) \0 ~ M ... ... ... ~ ~ ~ '"0 (l) ~ rfJ rfJ ~ rfJ ~ o§ (l) ~o 000 ~o .~ N '"0 ~ .~ ~ ÇQ t.r) o o N I I'ITTACHMENT #...2....- TO REPORT #,f!;€ .;¿ i ~-o' II) ...... 'ã ~ ~ ~ ~ o . o z t 1I / / ./ \ \ \ ~ ~ ~ ~ 1/ V QQQQQQQQQQQQQQQQQQQ Q~Q~Q~Q~Q~Q~Q~Q~Q~ ~~~~~~~~~~~~~NN~~ ~ Q Q N ~ Q Q N ~ Q Q N N Q Q N ~ Q Q N Q Q Q N ~ o ~ o · ,...-4 1:: o ~ Þ · ,...-4 u ~ (1) ~ u (1) ~ ~ o U rfJlr) (1)0 bOO ~N ,.Q U~ ~O\ ~O\ (1) ~ S ~ o ~ (1) > (1) Q ATTACHMENT#..L '1"0 REPORT#.Ç"$"~ I 'Of:., = Q t Q ~ è .... u t 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 0 0 If) 0 If) 0 If) 0 If) "' ... "' ... ... ... "' ~ ~ ~ N N ~ ~ If) o o N ~ o o N ~ o o N N o o N ~ o o N o o o N 0\ 0\ 0\ ~ 00 0\ 0\ ~ r--- 0\ 0\ ~ \0 0\ 0\ ~ If) 0\ 0\ ~ ~ 0\ 0\ ~ ~ 0\ 0\ ~ N 0\ 0\ ~ ~ 0\ 0\ ~