|
Financial Report
October 18, 2006
Balance Sheet
Statement of Operations
Reserve Funds Report
Treasurer's
Report
|
Ventana Lakes Property Owners Association |
|
BALANCE SHEET |
|
As Of 9-30-2006 |
|
|
|
|
|
| |
CURRENT ASSETS |
|
|
|
|
|
|
|
|
OPERATING CASH |
|
|
|
102 |
FNBAZ Operating |
$ 219,030.22 |
|
|
103 |
FNBAZ Activity CHkg |
$ 8,928.79 |
|
|
105 |
Compass Operating Acct. |
$ 75,595.01 |
|
|
110 |
Petty Cash |
$ 500.00 |
|
|
111 |
Petty Cash - Activity |
$ 210.00 |
|
|
116 |
Due To/From Reserve |
$ 25,885.20 |
|
|
|
TOTAL OPERATING CASH |
|
$ 330,149.22 |
|
|
|
|
|
|
OTHER ASSETS |
|
|
|
161 |
Assessment Receivable |
$ 11,372.11 |
|
|
165 |
Prepaid Income Tax |
$ 1,002.00 |
|
|
|
TOTAL OTHER ASSETS |
|
$ 12,374.11 |
|
|
|
|
|
|
FIXED ASSETS |
|
|
|
150 |
Building & Structures |
$ 150,000.00 |
|
|
151 |
Vehicle Asset |
$ 7,075.00 |
|
|
152 |
Office Furn & Computer Hwd |
$ 29,376.66 |
|
|
153 |
Exercise Equipment |
$ 16,027.00 |
|
|
159 |
Accum Depreciation |
$ (47,566.00) |
|
|
|
TOTAL FIXED ASSETS |
|
$ 154,912.66 |
|
|
|
|
|
|
RESERVE FUND |
|
|
|
120 |
Money Market FNBAZ |
$ 99,193.00 |
|
|
121 |
Amtrust CD 11-23-07 |
$ 100,000.00 |
|
|
122 |
Chase CD5681 M61815 5 |
$ 112,308.88 |
|
|
123 |
CDARS CD 5.60% |
$ 75,000.00 |
|
|
124 |
WF Brokerage Mny Mkt |
$ 3,118.29 |
|
|
125 |
Stonebridge CD |
$ 17,000.00 |
|
|
126 |
FNB CD 4.65% 1-30-08 |
$ 76,692.23 |
|
|
127 |
FNB CD 4.65% 1-30-09 |
$ 76,707.27 |
|
|
128 |
1st Internet CD 8-16-11 |
$ 45,000.00 |
|
|
129 |
1st Internet CD 8-16-10 |
$ 35,000.00 |
|
|
130 |
1st COMM BANK CD |
$ 15,282.41 |
|
|
132 |
FNB CD 4.75% 1-30-10 |
$ 76,726.08 |
|
|
133 |
WF Brokerage Invest |
$ 383,000.00 |
|
|
131 |
Due To/From Operating |
$ (25,885.20) |
|
|
|
TOTAL RESERVE FUND |
|
$ 1,089,142.96 |
|
|
|
|
|
|
GARDENS RESERVE |
|
|
|
171 |
Gardens Reserve Mny Mkt |
$ 42,503.64 |
|
|
172 |
World CD 2-13-07 |
$ 20,623.03 |
|
|
|
TOTAL GARDENS RESERVE |
|
$ 63,126.67 |
|
|
|
|
|
| |
TOTAL CURRENT ASSETS |
|
$ 1,649,705.62 |
|
|
|
|
|
|
|
|
|
|
| |
LIABILITIES & FUND BALANCES |
|
|
|
|
|
|
|
|
CURRENT LIABILITIES |
|
|
|
201 |
Accounts Payable |
$ 33,595.39 |
|
|
203 |
Accrued P/R Taxes |
$ 2,386.05 |
|
|
205 |
Prepaid Assessments |
$ 146,586.04 |
|
|
208 |
Building Fund |
$ 8,289.88 |
|
|
210 |
Refund Pool Keys |
$ 28,703.00 |
|
|
311 |
Pool Const Deposits |
$ 1,000.00 |
|
|
|
TOTAL LIABILITIES |
|
$ 220,560.36 |
|
|
|
|
|
|
EQUITY |
|
|
|
RETAINED EARNINGS |
$ 310,709.05 |
|
|
GARDEN RESERVES |
$ 63,126.67 |
|
|
RESERVE FUND |
$ 1,089,142.96 |
|
|
GARDENS OPERATING |
$ 32,396.13 |
|
|
CURRENT YEAR SURPLUS / DEFICIT |
$ (66,229.55) |
|
|
|
TOTAL FUND BALANCE |
|
$ 1,429,145.26 |
|
|
|
|
|
| |
TOTAL LIABILITIES AND |
|
|
| |
FUND BALANCES |
|
$ 1,649,705.62 |
|
Statement Of Operations |
|
For The Nine Months Ending 9-30-2006 |
|
|
|
|
|
|
|
|
|
|
|
|
|
CURRENT |
CURRENT |
|
|
|
|
|
|
|
INCOME |
MONTH |
MONTH |
FAVORABLE / |
YEAR TO DATE |
YEAR TO DATE |
FAVORABLE / |
ANNUAL |
|
|
|
ACTUAL |
BUDGET |
(UNFAVORABLE) |
ACTUAL |
BUDGET |
(UNFAVORABLE) |
BUDGET |
|
Operating Revenue |
|
|
|
|
|
|
|
|
401 |
Homeowner Assessments |
$ - |
$ - |
$ - |
$ 903,231.00 |
$ 903,231.04 |
$ (0.04) |
$ 1,204,308.00 |
|
402 |
Administrative Income |
$ - |
$ 200.00 |
$ (200.00) |
$ 2,954.23 |
$ 1,800.00 |
$ 1,154.23 |
$ 2,400.00 |
|
403 |
Cell Tower Income |
$ - |
$ 750.00 |
$ (750.00) |
$ 1,500.00 |
$ 6,750.00 |
$ (5,250.00) |
$ 9,000.00 |
|
410 |
Late Fees |
$ - |
$ - |
$ - |
$ 960.00 |
$ - |
$ 960.00 |
$ - |
|
430 |
Pool Keys |
$ - |
$ - |
$ - |
$ 990.04 |
$ - |
$ 990.04 |
$ - |
|
460 |
Interest Bank Accounts |
$ 430.84 |
$ - |
$ 430.84 |
$ 4,271.39 |
$ - |
$ 4,271.39 |
$ - |
|
480 |
Yacht Club Rent |
$ 424.17 |
$ - |
$ 424.17 |
$ 2,427.17 |
$ - |
$ 2,427.17 |
$ - |
|
490 |
Activities Income |
$ 1,662.18 |
$ - |
$ 1,662.18 |
$ 21,129.21 |
$ - |
$ 21,129.21 |
$ - |
|
|
Total Operating Income |
$ 2,517.19 |
$ 950.00 |
$ 1,567.19 |
$ 937,463.04 |
$ 911,781.04 |
$ 25,682.00 |
$ 1,215,708.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
CURRENT |
CURRENT |
|
|
|
|
|
|
|
EXPENDITURES |
MONTH |
MONTH |
FAVORABLE / |
YEAR TO DATE |
YEAR TO DATE |
FAVORABLE / |
ANNUAL |
|
|
|
ACTUAL |
BUDGET |
(UNFAVORABLE) |
ACTUAL |
BUDGET |
(UNFAVORABLE) |
BUDGET |
|
|
|
|
|
|
|
|
|
|
|
|
Maintenance |
$ 41,033.79 |
$ 38,210.00 |
$ (2,823.79) |
$ 352,095.93 |
$ 343,890.00 |
$ (8,205.93) |
$ 458,520.00 |
|
|
Utilities |
$ 35,245.64 |
$ 32,097.00 |
$ (3,148.64) |
$ 283,814.20 |
$ 288,873.00 |
$ 5,058.80 |
$ 385,164.00 |
|
|
Activities |
$ 1,109.28 |
$ - |
$ (1,109.28) |
$ 37,911.73 |
$ - |
$ (37,911.73) |
$ - |
|
|
Supplies |
$ - |
$ 100.00 |
$ 100.00 |
$ 202.36 |
$ 900.00 |
$ 697.64 |
$ 1,200.00 |
|
|
Administration |
$ 24,306.28 |
$ 18,885.34 |
$ (5,420.94) |
$ 181,772.41 |
$ 204,972.02 |
$ 23,199.61 |
$ 261,628.04 |
|
|
Total Expenditures |
$ 101,694.99 |
$ 89,292.34 |
$ (12,402.65) |
$ 855,796.63 |
$ 838,635.02 |
$ (17,161.61) |
$ 1,106,512.04 |
|
|
|
|
|
|
|
|
|
|
|
|
Operating Surplus |
$ (99,177.80) |
$ (88,342.34) |
$ (10,835.46) |
$ 81,666.41 |
$ 73,146.02 |
$ 8,520.39 |
$ 109,195.96 |
|
|
|
|
|
|
|
|
|
|
|
|
Allocation To Reserve |
$ - |
$ - |
$ - |
$ 72,895.96 |
$ 72,895.96 |
$ - |
$ 97,195.96 |
|
|
2005 Surplus To Reserve |
$ - |
$ - |
$ - |
$ 75,000.00 |
$ - |
$ (75,000.00) |
$ - |
|
|
|
|
|
|
|
|
|
|
|
|
NET SURPLUS |
$ (99,177.80) |
$ (88,342.34) |
$ (10,835.46) |
$ (66,229.55) |
$ 250.06 |
$ (66,479.61) |
$ 12,000.00 |
|
Ventana Lakes Property Owners
Association |
|
2006 Reserve Funds Report |
|
|
|
|
Maturity |
As Of |
As Of |
As Of |
As Of |
As Of |
As Of |
As Of |
As Of |
|
Account |
MASTER RESERVE |
Yield |
Date |
1/31/2006 |
3/31/2006 |
4/30/2006 |
5/31/2006 |
6/30/2006 |
7/31/2006 |
8/31/2006 |
9/30/2006 |
|
120 |
SFB Money Market |
|
Mny. Mkt. Acct. |
$ 246,749.72 |
$ 244,941.77 |
$ 167,345.48 |
$ 165,395.57 |
$ 169,658.65 |
$ 191,293.33 |
$ 99,193.00
|
$ 99,193.00
|
|
121 |
Amtrust CD |
4.70% |
Nov. 23, 2007 |
$ 100,000.00 |
$ 100,000.00 |
$ 100,000.00 |
$ 100,000.00 |
$ 100,000.00 |
$ 100,000.00 |
$ 100,000.00 |
$ 100,000.00 |
|
122 |
Bankone / Chase CD |
5.68% |
June 18, 2012 |
$ 112,308.88 |
$ 112,308.88 |
$ 112,308.88 |
$ 112,308.88 |
$ 112,308.88 |
$ 112,308.88 |
$ 112,308.88 |
$ 112,308.88 |
|
123 |
Bankone / Chase CD |
|
NA |
$ 54,600.65
|
$ 54,600.65
|
$ -
|
$ -
|
$ -
|
$ -
|
$ -
|
$ -
|
|
123 |
CDARS CD |
5.60% |
Aug. 30, 2011 |
$ -
|
$ -
|
$ -
|
$ -
|
$ -
|
$ -
|
$ 75,000.00
|
$ 75,000.00
|
|
124 |
WF Brokerage Money Mkt |
|
Mny. Mkt. Acct. |
$ 35,239.42
|
$ 35,346.52
|
$ 151,683.50 |
$ 2,070.53
|
$ 2,078.30
|
$ 274,504.95 |
$ 2,984.57
|
$ 3,118.29
|
|
125 |
USAA CD |
|
Matured |
$ 64,830.01
|
$ 65,024.93
|
$ 65,024.93
|
$ 65,024.93
|
$ 65,587.82
|
$ -
|
$ -
|
$ -
|
|
125 |
Stonebridge CD |
5.50% |
Aug. 18, 2011 |
$ -
|
$ -
|
$ -
|
$ -
|
$ -
|
$ -
|
$ 17,000.00
|
$ 17,000.00
|
|
126 |
FNB CD |
4.65% |
Jan. 30, 2010 |
$ 75,000.00
|
$ 75,000.00
|
$ 75,827.21
|
$ 75,827.21
|
$ 75,827.21
|
$ 76,692.23
|
$ 76,692.23
|
$ 76,692.23
|
|
127 |
FNB CD |
4.65% |
Jan. 30, 2009 |
$ 75,000.00
|
$ 75,000.00
|
$ 75,834.52
|
$ 75,834.52
|
$ 75,834.52
|
$ 76,707.27
|
$ 76,707.27
|
$ 76,707.27
|
|
128 |
RSV FNBA CD |
|
Matured |
$ 102,135.26 |
$ 102,135.26 |
$ 103,264.60 |
$ 103,264.60 |
$ 103,264.60 |
$ -
|
$ -
|
$ -
|
|
128 |
1st Internet CD |
5.64% |
Aug. 16, 2011 |
$ -
|
$ -
|
$ -
|
$ -
|
$ -
|
$ -
|
$ 45,000.00
|
$ 45,000.00
|
|
129 |
FND AZ CD |
|
Matured |
$ 99,955.74
|
$ 99,955.74
|
$ 100,926.52 |
$ 100,926.52 |
$ 100,926.52 |
$ -
|
$ -
|
$ -
|
|
128 |
1st Internet CD |
5.59% |
Aug. 16, 2010 |
$ -
|
$ -
|
$ -
|
$ -
|
$ -
|
$ -
|
$ 35,000.00
|
$ 35,000.00
|
|
130 |
1st Community Bank CD |
4.93% |
Oct. 6, 2008 |
$ 15,282.41
|
$15,282.41 |
$ 15,282.41
|
$ 15,282.41
|
$ 15,282.41
|
$ 15,282.41
|
$ 15,282.41
|
$ 15,282.41
|
|
132 |
FNB CD |
4.75% |
Jan. 30, 2010 |
$ 75,000.00
|
$ 75,000.00
|
$ 75,843.66
|
$ 75,843.66
|
$ 75,843.66
|
$ 76,726.08
|
$ 76,726.08
|
$ 76,726.08
|
|
133 |
Wells Fargo Investments |
|
Multiple CDs |
$ -
|
$ -
|
$ 58,000.00
|
$ 208,000.00 |
$ 208,000.00 |
$ 208,000.00 |
$ 383,000.00 |
$ 383,000.00 |
|
131 |
Due To/From Operating |
NA |
NA |
$ (6,445.51) |
$ (2,236.06) |
$ 770.00
|
$ 3,970.00
|
$ (2,996.14) |
$ (17,419.66) |
$ (22,821.71) |
$ (25,885.20) |
|
SUB-TOTAL |
|
|
$ 1,049,656.58 |
$ 1,052,360.10 |
$ 1,102,111.71 |
$ 1,103,748.83 |
$ 1,101,616.43 |
$ 1,114,095.49 |
$ 1,092,072.73 |
$ 1,089,142.96 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
GARDENS RESERVE |
|
|
|
|
|
|
|
|
|
|
|
171 |
Domestic Bank Mny. Mkt. |
|
NA |
$ 32,083.44
|
$ 32,157.27
|
$ 37,205.17
|
$ 37,263.04
|
$ 37,321.79
|
$ 42,388.04
|
$ 42,457.58
|
$ 42,503.64
|
|
172 |
World CD |
|
No Info |
$ 20,623.03
|
$ 20,623.03
|
$ 20,623.03
|
$ 20,623.03
|
$ 20,623.03
|
$ 20,623.03
|
$ 20,623.03
|
$ 20,623.03
|
|
SUB-TOTAL |
|
|
$ 52,706.47 |
$ 52,780.30 |
$ 57,828.20 |
$ 57,886.07 |
$ 57,944.82 |
$ 63,011.07 |
$ 63,080.61 |
$ 63,126.67 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
TOTAL RESERVE FUNDS |
|
|
$ 1,102,363.05 |
$ 1,105,140.40 |
$ 1,159,939.91 |
$ 1,161,634.90 |
$ 1,159,561.25 |
$ 1,177,106.56 |
$ 1,155,153.34 |
$ 1,152,269.63 |
Ventana
Lakes Property Owners Association
Treasurers
Report
October 18,
2006
Attached and Included As Part Of This Report
The first 2 pages of Colby
Management’s Balance Sheet for the nine months ending September 30, 2006.
Comments
The 2007 Budget Drafts for
the Master and Gardens will be submitted today for Board discussion and/or
approval. In an attempt to remove all income uncertainties from the Operational
side of the budget the Board has decided to use only assessment income in
preparing the 2007 budget draft. Any interest income derived from the
Operational bank accounts will be treated as Operational income but is not being
used to project available income.
Any additional income from
sources such as Resale Fees or Cell Tower Revenue will be added to the Ventana
Lakes Reserve Fund.
Reserves
Attached is an additional
page listing all Ventana Lakes CDs held in our Reserve Account.
Recommendations
Attached are my
recommendations to the Board from my September report with updates.
Submitted and signed
by Bob DellaPia this 18th
day of October, 2006.
Ventana Lakes Property Owners
Association
Certificate of Deposits as of
September 30, 2006
HELD AT
BANK
Yield
BALANCE MATURES WELLS FARGO
1) Citizens State Bank
4.95% $ 50,000 Nov. 24, 2006 YES
2) First Bank of Puerto
Rico 5.05% $ 58,000 April 20, 2007 YES
3) Morgan Stanley
Bank 5.25% $ 75,000 May 16, 2007 YES
4) Washington Mutual
5.25% $ 25,000 Aug. 23, 2007 YES
5) Westernbank of Puerto
Rico 5.30% $ 25,000 Aug. 23, 2007 YES
6) AmTrust
4.70% $100,000 Nov. 23, 2007
7) FNB
4.65% $ 76,692 Jan. 30, 2008
8) First Federal Savings Bank,
IN 5.40% $ 25,000 April 9, 2008 YES
9) Sky
Bank 5.25% $
50,000 May 27, 2008 YES
10) First Community
Bank 4.93% $ 15,282 Oct. 6, 2008
11) FNB
4.65% $ 76,707 Jan. 30, 2009
12) GMAC
Bank 5.30% $
50,000 May 19, 2009 YES
13) New West Bank Greenley,
CO 5.40% $ 25,000 Aug. 4, 2009 YES
14) FNB
4.75% $ 76,726 Jan. 30, 2010
15) First Internet Bank of
IN 5.59% $ 35,000 Aug. 16, 2010
16) First Internet Bank of
IN 5.64% $ 45,000 Aug. 16, 2011
17) Stonebridge
Bank 5.50% $ 17,000 Aug. 18, 2011
18) United Bank Parkersburg,
WY 5.60% $ 75,000 Aug. 30, 2011 guaranteed CDARS FNB
19) Bank
One 5.68%
$112,308 June 18, 2012
Board: Progress on recommendations approved in September.
1) Line item 171 - Gardens
reserve Money Market FNB
Move this to any
bank that has consistently offered high money market rates and that has no other
Ventana Lakes funds so that it is 100% insured. 2.15% from FNB is not in our
best interest plus we are well over FDIC insurance limits with FNB.
All funds have been moved to a money market
account at Domestic Bank with a current yield of 5.08%.
2) Line item 120 - Reserve
Money Market FNB
Move $95,000 of
this to any bank that has consistently offered high money market rates and that
has no other Ventana Lakes funds so that it is 100% insured. 2.15% from FNB is
not in our best interest and we are well over FDIC insurance limits with FNB.
The remaining funds
would be used to purchase a CD. If you look at our list of CDs ( there are now
19 ) you will see we have approx. $50,000 maturing about every 3-5 months.
The $95,000 in the
liquid MM plus what we add every month plus what matures is more then enough
available for use.
All funds ( approximately $ 99,200 ) have
been moved to a money market account at State Farm Bank with a current yield of
4.50%.
3) Line item 102 - FNB
Operating
I have paper tracked
the last 8 months for this account. We seldom use $150,000 per month yet we
carry around $300,000 yielding 2.15%.
Tammy is in
agreement that we should move $95,000 to a Money Market account at any bank that
offers consistently high rates and that we do not have other funds with. This
will give us a better rate of return in money we do not use but still have
liquid access to and it will be 100% insured.
This will be done now that all the
funds are at Compass Bank.
Now the most
important step. We should move our operating account which is really a money
market account from FNB 2.15% to Compass Bank 4.50%. Compass is where Colby
holds most of its other customers money and based on yield you can see why.
That would mean approximately $200,000 at Compass with only about $100,000 over
the FDIC insurance limits.
The Operational Account has been
completely transferred to Compass Bank. This was finalized after the September
30 Balance Sheet was prepared.
4) Line item 103 - FNB
Activity CHKG
Go to Compass at Lake
Pleasant and Beardsley and open a CHKG account there. More convenient for
deposits and the balance is not large enough to worry about FDIC insurance. But
if insurance is a concern we could open that account anywhere.
Lois Owen and Barbara Jennings have moved
the Activities checking account to Compass and have closed the FNB account.
This will be reflected in the October Balance Sheet.

|