|
Financials/Budget
For the period ending March 31, 2010
Trabue Woods HOA
For the period ending March 31, 2010
|
Account YTD Actual Annual Budget
|
|
|
|
Operating Income
|
|
|
|
Association Fee $11,910.34 $23,190.30
|
|
|
|
Total Income $11,910.34 $23,190.30
|
|
|
|
Utilities
|
|
|
|
Electric $ 213.42 $ 1,020.00
|
|
Water & Sanitation $ 0.00 $ 150.00
|
|
|
|
Total Utilities $ 145.87 $ 1,170.00
|
|
|
|
Maintenance
|
|
|
|
Site Lighting $ - $ 50.00
|
|
Total Maintenance $ - $ 50.00
|
|
|
|
Grounds Care
|
|
|
|
Grass Mowing $ 0 $ 100.00
|
|
Spring Clean-Up $ 0 $ 4240.00
|
|
Landscaping $ 0 $ 850.00
|
|
Grounds Contract $ 0 $ 1360.00
|
|
Grounds Maintenance $ 0 $ 150.00
|
|
|
|
Total Grounds Care $ 0 $ 6,700.00
|
|
|
|
Recreation
|
|
Social Events/Activities $ 0 $ 1500.00
|
|
|
|
Total Recreation $ 0 $ 0
|
|
|
|
Administrative Expense
|
|
|
|
Legal $ 45.00 $ 11,000.00
|
|
Auditing & Accounting Fees $ 0 $ 300.00
|
|
Copier Expense/Copies $ 547.52 $ 1,000.00
|
|
Misc. Administrative Expense $ 0 $ 350.00
|
|
Website Expense $ 0 $ 225.00
|
|
Postage $ 931.94 $ 950.00
|
|
Management Fees $ 3118.50 $ 12,474.00
|
|
Federal Income Tax $ 0 $ 82.00
|
|
Insurance $ 0 $ 1,405.00
|
|
|
|
Total Administrative $ 4642.96 $29,286.00
|
|
|
|
|
|
Total Operating Expenses $4856.38 $37,206.00
|
|
|
|
|
|
Net Operating Flow / (Drain) $ 7095.63
|
|
|
|
|
|
|
**********************************************************************************************************************************************************
Trabue Woods HOA
For the period ending February 28, 2010
|
Account YTD Actual Annual Budget
|
|
|
|
Operating Income
|
|
|
|
Association Fee $11,022.52 $23,190.30
|
|
|
|
Total Income $11,022.52 $23,190.30
|
|
|
|
Utilities
|
|
|
|
Electric $ 145.87 $ 1,020.00
|
|
Water & Sanitation $ 0.00 $ 150.00
|
|
|
|
Total Utilities $ 145.87 $ 1,170.00
|
|
|
|
Maintenance
|
|
|
|
Site Lighting $ - $ 50.00
|
|
Total Maintenance $ - $ 50.00
|
|
|
|
Grounds Care
|
|
|
|
Grass Mowing $ 0 $ 100.00
|
|
Spring Clean-Up $ 0 $ 4240.00
|
|
Landscaping $ 0 $ 850.00
|
|
Grounds Contract $ 0 $ 1360.00
|
|
Grounds Maintenance $ 0 $ 150.00
|
|
|
|
Total Grounds Care $ 0 $ 6,700.00
|
|
|
|
Recreation
|
|
Social Events/Activities $ 0 $ 1500.00
|
|
|
|
Total Recreation $ 0 $ 0
|
|
|
|
Administrative Expense
|
|
|
|
Legal $ 45.00 $ 11,000.00
|
|
Auditing & Accounting Fees $ 0 $ 300.00
|
|
Copier Expense/Copies $ 223.58 $ 1,000.00
|
|
Misc. Administrative Expense $ 0 $ 350.00
|
|
Website Expense $ 0 $ 225.00
|
|
Postage $ 641.10 $ 950.00
|
|
Management Fees $ 2079.00 $ 12,474.00
|
|
Federal Income Tax $ 0 $ 82.00
|
|
Insurance $ 0 $ 1,405.00
|
|
|
|
Total Administrative $ 2988.68 $29,286.00
|
|
|
|
|
|
Total Operating Expenses $3,134.55 $37,206.00
|
|
|
|
|
|
Net Operating Flow / (Drain) $ 7887.97
|
|
|
|
|
|
|
*********************************************************************************************************************************************************
Trabue Woods HOA
For the period ending January 31, 2010
|
Account YTD Actual Annual Budget
|
|
|
|
Operating Income
|
|
|
|
Association Fee $8983.25 $23,190.30
|
|
|
|
Total Income $8983.25 $23,190.30
|
|
|
|
Utilities
|
|
|
|
Electric $ 44.82 $ 1,020.00
|
|
Water & Sanitation $ 0.00 $ 150.00
|
|
|
|
Total Utilities $ 44.82 $ 1,170.00
|
|
|
|
Maintenance
|
|
|
|
Site Lighting $ - $ 50.00
|
|
Total Maintenance $ - $ 50.00
|
|
|
|
Grounds Care
|
|
|
|
Grass Mowing $ 0 $ 100.00
|
|
Spring Clean-Up $ 0 $ 4240.00
|
|
Landscaping $ 0 $ 850.00
|
|
Grounds Contract $ 0 $ 1360.00
|
|
Grounds Maintenance $ 0 $ 150.00
|
|
|
|
Total Grounds Care $ 0 $ 6,700.00
|
|
|
|
Recreation
|
|
Social Events/Activities $ 0 $ 1500.00
|
|
|
|
Total Recreation $ 0 $ 0
|
|
|
|
Administrative Expense
|
|
|
|
Legal $ 0 $ 11,000.00
|
|
Auditing & Accounting Fees $ 0 $ 300.00
|
|
Copier Expense/Copies $ 223.58 $ 1,000.00
|
|
Misc. Administrative Expense $ 0 $ 350.00
|
|
Website Expense $ 0 $ 225.00
|
|
Postage $ 640.07 $ 950.00
|
|
Management Fees $ 1039.50 $ 12,474.00
|
|
Federal Income Tax $ 0 $ 82.00
|
|
Insurance $ 0 $ 1,405.00
|
|
|
|
Total Administrative $ 1903.15 $29,286.00
|
|
|
|
|
|
Total Operating Expenses $1947.97 $37,206.00
|
|
|
|
|
|
Net Operating Flow / (Drain) $ 7035.28 $20,759.54
|
|
|
|
|
****************************************************************************************************************************************************************
Trabue Woods HOA
For the period ending December 31, 2009
|
Account YTD Actual Annual Budget
|
|
|
|
Operating Income
|
|
|
|
Association Fee $26,317.79 $22,086.54
|
|
|
|
Total Income $26,317.79 $22,086.54
|
|
|
|
Utilities
|
|
|
|
Electric $ 784.85 $ 1,020.00
|
|
Water & Sanitation $ 36.50 $ 150.00
|
|
|
|
Total Utilities $ 821.35 $ 1,170.00
|
|
|
|
Maintenance
|
|
|
|
Site Lighting $ - $ 50.00
|
|
Total Maintenance $ - $ 50.00
|
|
|
|
Grounds Care
|
|
|
|
Grass Mowing $ 100.00 $ 0.00
|
|
Spring Clean-Up $ 4,240.00 $ 0.00
|
|
Landscaping $ 850.00 $ 0.00
|
|
Grounds Contract $ 1,973.85 $ 6,700.00
|
|
Grounds Maintenance $ 0.00 $ 150.00
|
|
|
|
Total Grounds Care $ 7,163.85 $ 6,850.00
|
|
|
|
Recreation
|
|
Social Events/Activities $ 631.47 $ 750.00
|
|
|
|
Total Recreation $ 631.47 $ 750.00
|
|
|
|
Administrative Expense
|
|
|
|
Legal $ 2,715.02 $11,000.00
|
|
Auditing & Accounting Fees $ 300.00 $ 2,000.00
|
|
Office Supplies $ 86.69 $ 0.00
|
|
Copier Expense/Copies $ 173.58 $ 0.00
|
|
Misc. Administrative Expense $ 54.10 $ 1,100.00
|
|
Bank Fees $ 98.41 $ 0.00
|
|
Software Licensing Fee $ 96.85 $ 0.00
|
|
Web Site Expense $ 215.76 $ 225.00
|
|
Postage $ 749.07 $ 948.00
|
|
Newsletters $ 683.56 $ 0.00
|
|
Management Fees $ 2,079.00 $ 0.00
|
|
Federal Income Tax $ 0.00 $ 82.00
|
|
Insurance $ 1,237.00 $ 1,405.00
|
|
|
|
Total Administrative $ 8,489.04 $17,510.00
|
|
|
|
|
|
Total Operating Expenses $17,105.71 $25,580.00
|
|
|
|
|
|
Net Operating Flow / (Drain) $ 9,212.08 ($3,493.46)
|
|
|
|
|
|
|
| Trabue Woods HOA |
| For the period ending November 30, 2009 |
|
Account
|
YTD Actual |
Annual Budget |
| Operating Income |
| Association Fee |
$20,522.14 |
$22,086.54 |
| Total Income |
$20,522.14 |
$22,086.54 |
|
Utilities
|
| Electric |
$718.78 |
$1,020.00 |
| Water & Sanitation |
$36.50 |
$150.00 |
| Total Utilities |
$755.28 |
$1,170.00 |
|
Maintenance
|
| Site Lighting |
$0.00 |
$50.00 |
| Total Maintenance |
$0.00 |
$50.00 |
|
Grounds Care
|
| Grass Mowing |
$100.00 |
$0.00 |
| Spring Clean-Up |
$4,240.00 |
$0.00 |
| Landscaping |
$850.00 |
$0.00 |
| Grounds Contract |
$1,973.85 |
$6,700.00 |
| Grounds Maintenance |
$0.00 |
$150.00 |
| Total Grounds Care |
$7,163.85 |
$6,850.00 |
|
Recreation
|
| Community/Social Events |
$631.47 |
$0.00 |
| Total Recreation |
$631.47 |
$0.00 |
|
Administrative Expense
|
| Legal |
$2,715.02 |
$11,000.00 |
| Auditing & Accounting Fees |
$300.00 |
$2,000.00 |
| Social Activities |
$0.00 |
$750.00 |
| Office Supplies |
$86.69 |
$0.00 |
| Copier Expense/Copies |
$167.42 |
$0.00 |
| Misc. Administrative Expense |
$54.10 |
$1,100.00 |
| Bank Fees |
$98.41 |
$0.00 |
| Software Licensing Fee |
$96.85 |
$0.00 |
| Web Site Expense |
$215.76 |
$225.00 |
| Postage |
$749.07 |
$948.00 |
| Newsletters |
$683.56 |
$0.00 |
| Management Fees |
$1,039.50 |
$0.00 |
| Federal Income Tax |
$0.00 |
$82.00 |
| Insurance |
$1,237.00 |
$1,405.00 |
| Total Administrative |
$7,443.38 |
$17,510.00 |
|
Total Operating Expenses
|
$15,993.98 |
$25,580.00 |
| Net Operating Flow / (Drain) |
$4,528.16 |
($3,493.46) |
============================================================================
2008 Estimated Budget based on available data from 2007 & 2008.
AEP ($85/mo) $1,020
H20/Sewer $ 150
Removed meters to save money
Insurance $1,405
Taxes $ 82
Maintenance $ 200
Lights & Gas for mowing
Landscaping $6,700-$10,000
Attorney Loveland $11,000
Dues collections, Deed Restrictions & other legal needs
Accountant $2,000
Tax prep, Correct Quick Books & quarterly audits
USPS (PO Box) $ 48
Change from USPS Store to Hilliard P O will save $132.00
Website $ 225
Social Events $ 750
Fundraisers, Donations to cut costs
Welcome Wagon $ 750
Approximately 30 homes/year
Postage $ 900
Bulk Mailing saves approx. 0.25 per mailing ($0.41-$0.42 verses $.0155 & $0.165)
Office Supplies $ 350
Total: $25,580-$28,880
==============================================================================================================
| Ordinary Income & Expense Summary as it appears 07/06/06 - 07/31/07 pg 1 |
|
|
|
| |
|
|
|
| Income |
Actual Income |
Total |
Expenses |
| Opening Equity Bank Balance 8/06 |
$4,017.00 |
|
|
| Current Account Balance 8/8/07 |
|
$15,927.27 |
|
| |
|
|
|
| Homeowner Member Dues 7/06-6/30/07 |
$20,517.00 |
|
|
| Homeowner member dues 07/01/07-08/08/07 |
$13,095.00 |
|
|
| Total Income for 2006 & 2007 |
$33,612.00 |
|
|
| |
|
|
|
| Actual Expense from 07/06-6/31/07 |
|
|
$13,083.45 |
| Actual Expense from 07/01/07-08/08/07 |
|
|
$4,763.05 |
| Total Expense |
|
|
$17,846.50 |
| |
|
|
|
| Total Income |
|
$33,612.00 |
|
| Less Total Expense |
|
$17,684.73 |
|
| Balance as of 08/08/2007 |
|
$15,927.27 |
|
| |
|
|
|
| Ordinary Income & Expense Summary as it appears 08/06-07/31/07 pg 2 |
|
|
|
| |
|
|
|
| Expense |
Actual |
Total |
|
| |
|
|
|
| Adminstrative |
|
|
|
| Accounting |
$0.00 |
|
|
| Bank Service Charges |
$5.90 |
|
|
| Mail Box |
$380.00 |
|
|
| Annual meeting |
|
|
|
| Website |
$215.76 |
|
|
| Equipment (prior Board approved) |
|
|
|
| Quick Books |
$160.11 |
|
|
| Computer with service plan |
$700.89 |
|
|
| Signs |
$276.00 |
|
|
| Office Supplies |
|
|
|
| Envelopes,paper, labels |
$81.54 |
|
|
| Ink,printing |
$307.74 |
|
|
| Stapling,Assembly |
$32.00 |
|
|
| Postage |
$566.50 |
|
|
| Misc. office expense |
$643.34 |
|
|
| Legal fees/cost |
|
|
|
| Baker Law Group |
$9,743.40 |
|
|
| Allen Kuehnle,Stovale,Newman |
$250.00 |
|
|
| Total Legal Fees |
|
$9,993.40 |
|
| Dues/Deed Enforcement |
|
|
|
| Parking (Kevin Cross submitted) |
$4.00 |
|
|
| Total Adminstrative Expense |
$13,367.18 |
$13,367.18 |
|
| |
|
|
|
| Insurance |
$665.00 |
$665.00 |
|
| |
|
|
|
| Landscaping |
$1,887.00 |
|
|
| Phase I both sides |
|
|
|
| weeding, trimming, waste removal |
|
|
|
| Mowing vacant lot |
|
|
|
| Total Landscaping |
$1,887.00 |
$1,887.00 |
|
| |
|
|
|
| Ordinary Income & Expense Summary as it appears 08/06-07/31/07 pg 3 |
|
|
|
| |
|
|
|
| Expense |
Actual |
Total |
|
| Maintenance/Repair |
|
|
|
| Sprinkler (repair in 2008) |
$350.00 |
|
|
| Lights |
$46.88 |
|
|
| Total Maintenance/Repair |
$396.88 |
$396.88 |
|
| |
|
|
|
| Property Tax |
$608.34 |
$608.34 |
|
| |
|
|
|
| Social Committee |
|
|
|
| Garage Sale Ads/Newspaper |
|
|
|
| Permit for Fall Festival |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
|
|
| Total Social Committee Expense |
$106.63 |
$106.63 |
|
| |
|
|
|
| Utilities |
|
|
|
| Electric |
$332.80 |
|
|
| Water |
$320.90 |
|
|
| Total Utilities |
$653.70 |
$653.70 |
|
| |
|
|
|
| Total Expense |
|
$17,314.30 |
|
|