Ventana Lakes
Property Owners' Association
Financial Report
September 9, 2006
Balance Sheet
Statement of Operations
Reserve Funds Report
Treasurer's
Report
| Ventana Lakes Property Owners Association | |||
| BALANCE SHEET | |||
| As Of 8-31-2006 | |||
| CURRENT ASSETS | |||
| OPERATING CASH | |||
| 102 | FNBAZ Operating | $ 229,806.61 | |
| 103 | FNBAZ Activity CHkg | $ 8,375.89 | |
| 110 | Petty Cash | $ 500.00 | |
| 111 | Petty Cash - Activity | $ 210.00 | |
| 116 | Due To/From Reserve | $ 22,821.71 | |
| TOTAL OPERATING CASH | $ 261,714.21 | ||
| OTHER ASSETS | |||
| 161 | Assessment Receivable | $ 13,362.04 | |
| 165 | Prepaid Income Tax | $ 1,002.00 | |
| TOTAL OTHER ASSETS | $ 14,364.04 | ||
| FIXED ASSETS | |||
| 150 | Building & Structures | $ 150,000.00 | |
| 151 | Vehicle Asset | $ 7,075.00 | |
| 152 | Office Furn & Computer Hwd | $ 29,376.66 | |
| 153 | Exercixe 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 | Bankone CD5681 M61815 5 | $ 112,308.88 | |
| 123 | cdars cd 5.60% | $ 75,000.00 | |
| 124 | WF Brokerage Mny Mkt | $ 2,984.57 | |
| 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 | $ (22,821.71) | |
| TOTAL RESERVE FUND | $ 1,092,072.73 | ||
| GARDENS RESERVE | |||
| 171 | Gardens Reserve Mny Mkt | $ 42,457.58 | |
| 172 | World CD 2-13-07 | $ 20,623.03 | |
| TOTAL GARDENS RESERVE | $ 63,080.61 | ||
| TOTAL CURRENT ASSETS | $ 1,586,144.25 | ||
| LIABILITIES & FUND BALANCES | |||
| CURRENT LIABILITIES | |||
| 203 | Accrued P/R Taxes | $ 1,529.20 | |
| 205 | Prepaid Assessments | $ 9,248.01 | |
| 208 | Building Fund | $ 8,289.88 | |
| 210 | Refund Pool Keys | $ 28,665.00 | |
| 311 | Pool Const Deposite | $ 2,000.00 | |
| TOTAL LIABILITIES | $ 49,732.09 | ||
| EQUITY | |||
| RETAINED EARNINGS | $ 310,709.05 | ||
| GARDEN RESERVES | $ 63,080.61 | ||
| RESERVE FUND | $ 1,092,072.73 | ||
| GARDENS OPERATING | $ 37,601.52 | ||
| CURRENT YEAR SURPLUS / DEFICIT | $ 32,948.25 | ||
| TOTAL FUND BALANCE | $ 1,536,412.16 | ||
| TOTAL LIABILITIES AND | |||
| FUND BALANCES | $ 1,586,144.25 | ||
| Statement Of Operations | ||||||||
| For The Eight Months Ending 8-31-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 | $ 920.55 | $ 200.00 | $ 720.55 | $ 2,954.23 | $ 1,600.00 | $ 1,354.23 | $ 2,400.00 |
| 403 | Cell Tower Income | $ - | $ 750.00 | $ (750.00) | $ 1,500.00 | $ 6,000.00 | $ (4,500.00) | $ 9,000.00 |
| 410 | Late Fees | $ (30.00) | $ - | $ (30.00) | $ 960.00 | $ - | $ 960.00 | $ - |
| 430 | Pool Keys | $ - | $ - | $ - | $ 990.04 | $ - | $ 990.04 | $ - |
| 460 | Interest Bank Accounts | $ 495.42 | $ - | $ 495.42 | $ 3,840.55 | $ - | $ 3,840.55 | $ - |
| 480 | Yacht Club Rent | $ 250.00 | $ - | $ 250.00 | $ 2,003.00 | $ - | $ 2,003.00 | $ - |
| 490 | Activities Income | $ - | $ - | $ - | $ 19,467.03 | $ - | $ 19,467.03 | $ - |
| Total Operating Income | $ 1,635.97 | $ 950.00 | $ 685.97 | $ 934,945.85 | $ 910,831.04 | $ 24,114.81 | $ 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 | $ 36,767.99 | $ 38,210.00 | $ 1,442.01 | $ 311,062.14 | $ 305,680.00 | $ (5,382.14) | $ 458,520.00 | |
| Utilities | $ 44,270.09 | $ 32,097.00 | $ (12,173.09) | $ 248,568.56 | $ 256,776.00 | $ 8,207.44 | $ 385,164.00 | |
| Activities | $ - | $ - | $ - | $ 36,802.45 | $ - | $ (36,802.45) | $ - | |
| Supplies | $ - | $ 100.00 | $ 100.00 | $ 202.36 | $ 800.00 | $ 597.64 | $ 1,200.00 | |
| Administration | $ 12,425.06 | $ 18,885.34 | $ 6,460.28 | $ 157,466.13 | $ 186,086.68 | $ 28,620.55 | $ 261,628.04 | |
| Total Expenditures | $ 93,463.14 | $ 89,292.34 | $ (4,170.80) | $ 754,101.64 | $ 749,342.68 | $ (4,758.96) | $ 1,106,512.04 | |
| Operating Surplus | $ (91,827.17) | $ (88,342.34) | $ (3,484.83) | $ 180,844.21 | $ 161,488.36 | $ 19,355.85 | $ 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 | $ (91,827.17) | $ (88,342.34) | $ (3,484.83) | $ 32,948.25 | $ 88,592.40 | $ (55,644.15) | $ 12,000.00 | |
| Ventana Lakes Property Owners Association | ||||||||
| 2006 Reserve Funds Report | ||||||||
| As Of | As Of | As Of | As Of | As Of | As Of | As Of | ||
| Account | MASTER RESERVE | 1/31/2006 | 3/31/2006 | 4/30/2006 | 5/31/2006 | 6/30/2006 | 7/31/2006 | 8/31/2006 |
| 120 | Money Market | $ 246,749.72 | $ 244,941.77 | $ 167,345.48 | $ 165,395.57 | $ 169,658.65 | $ 191,293.33 | $ 99,193.00 |
| 121 | Amtrust CD | $ 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 | $ 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 | $ 54,600.65 | $ 54,600.65 | $ - | $ - | $ - | $ - | $ - |
| 123 | CDARS CD 5.60% | $ - | $ - | $ - | $ - | $ - | $ - | $ 75,000.00 |
| 124 | WF Brokerage Acct | $ 35,239.42 | $ 35,346.52 | $ 151,683.50 | $ 2,070.53 | $ 2,078.30 | $ 274,504.95 | $ 2,984.57 |
| 125 | USAA CD | $ 64,830.01 | $ 65,024.93 | $ 65,024.93 | $ 65,024.93 | $ 65,587.82 | $ - | $ - |
| 125 | Stonebridge CD | $ - | $ - | $ - | $ - | $ - | $ - | $ 17,000.00 |
| 126 | FNB CD | $ 75,000.00 | $ 75,000.00 | $ 75,827.21 | $ 75,827.21 | $ 75,827.21 | $ 76,692.23 | $ 76,692.23 |
| 127 | FNB CD | $ 75,000.00 | $ 75,000.00 | $ 75,834.52 | $ 75,834.52 | $ 75,834.52 | $ 76,707.27 | $ 76,707.27 |
| 128 | RSV FNBA CD | $ 102,135.26 | $ 102,135.26 | $ 103,264.60 | $ 103,264.60 | $ 103,264.60 | $ - | $ - |
| 128 | 1st Internet CD | $ - | $ - | $ - | $ - | $ - | $ - | $ 45,000.00 |
| 129 | FND AZ CD | $ 99,955.74 | $ 99,955.74 | $ 100,926.52 | $ 100,926.52 | $ 100,926.52 | $ - | $ - |
| 128 | 1st Internet CD | $ - | $ - | $ - | $ - | $ - | $ - | $ 35,000.00 |
| 130 | 1st Com Bank CD | $ 15,282.41 | $15,282.41 | $ 15,282.41 | $ 15,282.41 | $ 15,282.41 | $ 15,282.41 | $ 15,282.41 |
| 132 | FNB CD | $ 75,000.00 | $ 75,000.00 | $ 75,843.66 | $ 75,843.66 | $ 75,843.66 | $ 76,726.08 | $ 76,726.08 |
| 133 | WF Brokerage Invest | $ - | $ - | $ 58,000.00 | $ 208,000.00 | $ 208,000.00 | $ 208,000.00 | $ 383,000.00 |
| 131 | Due To/From Operating | $ (6,445.51) | $ (2,236.06) | $ 770.00 | $ 3,970.00 | $ (2,996.14) | $ (17,419.66) | $ (22,821.71) |
| 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 | |
| GARDENS RESERVE | ||||||||
| 171 | Gardens Reserve Mny Mkt | $ 32,083.44 | $ 32,157.27 | $ 37,205.17 | $ 37,263.04 | $ 37,321.79 | $ 42,388.04 | $ 42,457.58 |
| 172 | World CD | $ 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 | |
| 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 | |
Treasurer's Report
Attached and Included As Part Of This Report
The first 2 pages of Colby Management’s Balance Sheet for the seven months ending July 31, 2006. The Aug. report is not yet available.
Comments
Since the only financial information readily available for my report comes from Colby Management I have decided to use the first 2 pages of Colby Management’s Balance Sheet as part of my official Treasurers Report. I will use this comment section to inform the Board and the Association of any questions and/or concerns since my last report and the outcomes, if any, of such questions and/or concerns.
Included is an additional page listing all VLPOA CD’s in the order of their maturities.
Please Note - A large amount of money was moved in August so this report will bring the Association up to date and will not stop with the July 31 statement.
Reserves
If you compare the attached list of CDs with the previous list from my July report you will see that 1 CD from FNB has matured and 9 new CDs totaling $347,000 have been purchased.
Line item 124 from the July report shows $274,504.95, as of today there is less then $3,000 in that account.
Line item 133 from the July report shows $208,000, as of today there is more then $383,000 in that account.
I have utilized the Wells Fargo brokerage account to purchase CDs in the secondary market when their available rates are comparable to most banks nationwide. However, I have also dealt with individual banks to achieve better yields then available in the secondary CD market. I was even able to negotiate a competitive yield utilizing the new Federally insured CDARS program.
December 31, 2005 report shows VL Master Reserves $952,646.93. July 31, 2006 report shows VL Master Reserves $1,114,095.49. This is an increase in $161,449.44 in just 7 months. This Board, by using good money management, has increased reserves significantly while maintaining our amenities.
Better Insured Funds
Board: After several e-mail and phone conversations with Anne Dill and Tammy Matthews the following will be my recommendation to the Board on Saturday Sept. 9, 2006. All of these recommendations have been discussed with Tammy Matthews and she is in agreement that these would be in the best financial interests of Ventana Lakes. I will work along with Tammy to do all the needed research and make all the arrangements.
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.
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.
3) Line item 102 - FNB Operating
I have paper tract 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.
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.
I even discussed this with Anne Dill and she even agreed if Compass offers 4.50% we should use them because FNB cannot match that. They offered us a 30 day CDARS CD at 4.50% but why would we tie money up for even 30 days for the same yield as liquid funds.
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.
Again, I will do the bank research and work with Tammy. Lois will just have to sign. Bob
Certificate of Deposits as of August 18, 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% $ 75,827 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) Matrix( First Community Bank) 4.93% $ 15,282 Oct. 6, 2008
11) FNB 4.65% $ 75,834 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% $ 75,843 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