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