MIME-Version: 1.0 X-Document-Type: Workbook Content-Type: multipart/related; boundary="----=_NextPart_01C729B2.DAFD0140" This document is a Single File Web Page, also known as a Web Archive file. If you are seeing this message, your browser or editor doesn't support Web Archive files. Please download a browser that supports Web Archive, such as Microsoft Internet Explorer. ------=_NextPart_01C729B2.DAFD0140 Content-Location: file:///C:/9159C637/RRHOA-Budget2007.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" RRHOA - 2007 Budget <body> <p>This page uses frames, but your browser doesn't support them.</p> </body> ------=_NextPart_01C729B2.DAFD0140 Content-Location: file:///C:/9159C637/RRHOA-Budget2007_files/stylesheet.css Content-Transfer-Encoding: quoted-printable Content-Type: text/css; charset="us-ascii" tr {mso-height-source:auto;} col {mso-width-source:auto;} br {mso-data-placement:same-cell;} .style43 {mso-number-format:"_\(* \#\,\#\#0\.00_\)\;_\(* \\\(\#\,\#\#0\.00\\\)\;_\(= * \0022-\0022??_\)\;_\(\@_\)"; mso-style-name:Comma; mso-style-id:3;} .style0 {mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; mso-rotate:0; mso-background-source:auto; mso-pattern:auto; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; border:none; mso-protection:locked visible; mso-style-name:Normal; mso-style-id:0;} .style58 {mso-number-format:0%; mso-style-name:Percent; mso-style-id:5;} td {mso-style-parent:style0; padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:General; text-align:general; vertical-align:bottom; border:none; mso-background-source:auto; mso-pattern:auto; mso-protection:locked visible; white-space:nowrap; mso-rotate:0;} .xl65 {mso-style-parent:style43; mso-number-format:"_\(* \#\,\#\#0\.00_\)\;_\(* \\\(\#\,\#\#0\.00\\\)\;_\(*= \0022-\0022??_\)\;_\(\@_\)";} .xl66 {mso-style-parent:style0; text-align:center;} .xl67 {mso-style-parent:style0; font-size:12.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:center;} .xl68 {mso-style-parent:style0; font-size:12.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0;} .xl69 {mso-style-parent:style0; text-decoration:underline; text-underline-style:single; text-align:right;} .xl70 {mso-style-parent:style0; text-align:left;} .xl71 {mso-style-parent:style43; mso-number-format:"_\(* \#\,\#\#0_\)\;_\(* \\\(\#\,\#\#0\\\)\;_\(* \0022-\= 0022??_\)\;_\(\@_\)"; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none;} .xl72 {mso-style-parent:style0; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none;} .xl73 {mso-style-parent:style43; mso-number-format:"_\(* \#\,\#\#0_\)\;_\(* \\\(\#\,\#\#0\\\)\;_\(* \0022-\= 0022??_\)\;_\(\@_\)"; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:1.0pt solid windowtext; border-left:none;} .xl74 {mso-style-parent:style43; mso-number-format:"_\(* \#\,\#\#0_\)\;_\(* \\\(\#\,\#\#0\\\)\;_\(* \0022-\= 0022??_\)\;_\(\@_\)"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none;} .xl75 {mso-style-parent:style43; mso-number-format:"_\(* \#\,\#\#0_\)\;_\(* \\\(\#\,\#\#0\\\)\;_\(* \0022-\= 0022??_\)\;_\(\@_\)"; text-align:center; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:1.0pt solid windowtext; border-left:.5pt solid windowtext; white-space:normal;} .xl76 {mso-style-parent:style43; mso-number-format:"_\(* \#\,\#\#0_\)\;_\(* \\\(\#\,\#\#0\\\)\;_\(* \0022-\= 0022??_\)\;_\(\@_\)"; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:.5pt solid windowtext;} .xl77 {mso-style-parent:style43; mso-number-format:"_\(* \#\,\#\#0_\)\;_\(* \\\(\#\,\#\#0\\\)\;_\(* \0022-\= 0022??_\)\;_\(\@_\)"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;} .xl78 {mso-style-parent:style43; mso-number-format:"_\(* \#\,\#\#0_\)\;_\(* \\\(\#\,\#\#0\\\)\;_\(* \0022-\= 0022??_\)\;_\(\@_\)"; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:1.0pt solid windowtext; border-left:.5pt solid windowtext;} .xl79 {mso-style-parent:style0; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:.5pt solid windowtext;} .xl80 {mso-style-parent:style0; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none;} .xl81 {mso-style-parent:style43; mso-number-format:"\#\\ ??\/??";} .xl82 {mso-style-parent:style58; mso-number-format:"0\.0%";} .xl83 {mso-style-parent:style43; mso-number-format:"0_\)\;\\\(0\\\)"; text-align:center; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:1.0pt solid windowtext; border-left:none; white-space:normal;} .xl84 {mso-style-parent:style43; mso-number-format:"0_\)\;\\\(0\\\)"; text-align:center; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:1.0pt solid windowtext; border-left:.5pt solid windowtext; white-space:normal;} .xl85 {mso-style-parent:style43; mso-number-format:"_\(* \#\,\#\#0\.00_\)\;_\(* \\\(\#\,\#\#0\.00\\\)\;_\(*= \0022-\0022??_\)\;_\(\@_\)"; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none;} .xl86 {mso-style-parent:style43; mso-number-format:"_\(* \#\,\#\#0\.00_\)\;_\(* \\\(\#\,\#\#0\.00\\\)\;_\(*= \0022-\0022??_\)\;_\(\@_\)"; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:1.0pt solid windowtext; border-left:none;} .xl87 {mso-style-parent:style0; border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid windowtext;} .xl88 {mso-style-parent:style43; mso-number-format:"_\(* \#\,\#\#0_\)\;_\(* \\\(\#\,\#\#0\\\)\;_\(* \0022-\= 0022??_\)\;_\(\@_\)"; text-align:center; border:.5pt solid windowtext; white-space:normal;} .xl89 {mso-style-parent:style0; border:.5pt solid windowtext;} .xl90 {mso-style-parent:style43; mso-number-format:"_\(* \#\,\#\#0_\)\;_\(* \\\(\#\,\#\#0\\\)\;_\(* \0022-\= 0022??_\)\;_\(\@_\)"; border:.5pt solid windowtext;} .xl91 {mso-style-parent:style43; mso-number-format:"\#\\ ??\/??"; border:.5pt solid windowtext;} .xl92 {mso-style-parent:style43; mso-number-format:"_\(* \#\,\#\#0\.00_\)\;_\(* \\\(\#\,\#\#0\.00\\\)\;_\(*= \0022-\0022??_\)\;_\(\@_\)"; border:.5pt solid windowtext;} .xl93 {mso-style-parent:style58; mso-number-format:"0\.0%"; border:.5pt solid windowtext;} .xl94 {mso-style-parent:style0; text-decoration:underline; text-underline-style:single; text-align:right; border:.5pt solid windowtext;} .xl95 {mso-style-parent:style0; font-size:12.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; border:.5pt solid windowtext;} .xl96 {mso-style-parent:style0; text-align:left; border:.5pt solid windowtext;} .xl97 {mso-style-parent:style0; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; border:.5pt solid windowtext;} .xl98 {mso-style-parent:style0; font-size:12.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;} .xl99 {mso-style-parent:style0; text-align:left; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none;} .xl100 {mso-style-parent:style0; font-size:12.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;} .xl101 {mso-style-parent:style0; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none;} .xl102 {mso-style-parent:style0; border-top:.5pt solid windowtext; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;} .xl103 {mso-style-parent:style43; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; mso-number-format:"0_\)\;\\\(0\\\)"; text-align:center; border:.5pt solid windowtext; white-space:normal;} ------=_NextPart_01C729B2.DAFD0140 Content-Location: file:///C:/9159C637/RRHOA-Budget2007_files/tabstrip.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii"
 Ren Ridge HO= A - 5 year plan   Ren Ridge HO= A - amount per home 
------=_NextPart_01C729B2.DAFD0140 Content-Location: file:///C:/9159C637/RRHOA-Budget2007_files/sheet001.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" RRHOA - 2007 Budget
Income  2006 proposed budget  2007 b= udget 2008 2009 2010  <= /td> Assum= ptions
&nb= sp; Homeowner due= s   &nbs= p; 96,450        10= 6,000     116,600     128,260     141,086    Expenses increase 5% a year 
&nb= sp; Special asses= sment <= span style=3D'mso-spacerun:yes'>       &nbs= p;  -          &nbs= p;   5,000        5,= 000         5,000 <= span style=3D'mso-spacerun:yes'>       &nbs= p;     -      Special assessment capped at $5k<= /td>
&nb= sp; Late fees <= span style=3D'mso-spacerun:yes'>       &nbs= p;  -              
&nb= sp; Interest inco= me <= span style=3D'mso-spacerun:yes'>       &nbs= p;  -              
&nb= sp; Architectural= review <= span style=3D'mso-spacerun:yes'>       &nbs= p;  -              Target reserve based on reserve study 
&nb= sp; Other income<= /td> <= span style=3D'mso-spacerun:yes'>       &nbs= p;  -              Reserve expenditures based on res= erve study 
&nb= sp; Total income<= /td>   &nb= sp; 96,450        11= 1,000   &nb= sp; 121,600   &nb= sp; 133,260   &nb= sp; 141,086    
Expenses              
Administration              
&nb= sp; Legal      1,000 <= span style=3D'mso-spacerun:yes'>       &nbs= p;        -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -      
&nb= sp; Newsletter         400 <= span style=3D'mso-spacerun:yes'>       &nbs= p;        -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -      
&nb= sp; Accounting      8,100        &nbs= p;   8,505        8,= 930         9,377         9,846    
&nb= sp; Consulting <= span style=3D'mso-spacerun:yes'>       &nbs= p;  -              
&nb= sp; Office expens= es/bank charges         600        &nbs= p;     630        &nbs= p;  662        &nbs= p;  695        &nbs= p;   729    
&nb= sp; Total adminis= tration   &= nbsp; 10,100        &nbs= p;   9,135        9,= 592       10,071 <= /td>       10,575 <= /td>    
Utilities              
&nb= sp; Electricity      8,500        &nbs= p;   8,925        9,= 371         9,840       10,332 <= /td>    
&nb= sp; Telephone         200        &nbs= p;     210        &nbs= p;  221        &nbs= p;  232        &nbs= p;   243    
&nb= sp; Water/sewer      7,500        &nbs= p; 10,000       10,500 <= /td>       11,025 <= /td>       11,576 <= /td>    
&nb= sp; Garbage <= span style=3D'mso-spacerun:yes'>       &nbs= p;  -          &nbs= p;        -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -      
&nb= sp; Total utiliti= es   &= nbsp; 16,200        &nbs= p; 19,135       20,092 <= /td>       21,096 <= /td>       22,151 <= /td>    
Operations              
&nb= sp; Maintenance &= amp; repair         300        &nbs= p;   3,500        3,= 675         3,859         4,052    
&nb= sp; 2006 landscape catch-up     10,000            
&nb= sp; Landscape     35,000        &nbs= p; 36,750       38,588 <= /td>       40,517 <= /td>       42,543 <= /td>    
&nb= sp; Total operati= ons   &= nbsp; 45,300        &nbs= p; 40,250       42,263 <= /td>       44,376 <= /td>       46,594 <= /td>    
Other expenses              
&nb= sp; Social commit= tee      1,500        &nbs= p;   1,500        1,= 575         1,654         1,736    
&nb= sp; Insurance      5,200        &nbs= p;   5,460        5,= 733         6,020         6,321    
&nb= sp; Quarterly mee= tings         100        &nbs= p;     105        &nbs= p;  110        &nbs= p;  116        &nbs= p;   122    
&nb= sp; Taxes & l= icenses         150        &nbs= p;     150        &nbs= p;  158        &nbs= p;  165        &nbs= p;   174    
&nb= sp; Bad debt      1,500        &nbs= p;   1,000        1,= 050         1,103         1,158    
&nb= sp; Total other e= xpenses      8,450        &nbs= p;   8,215        8,= 626         9,057         9,510    
&nb= sp;                
&nbs= p; Total expense= s     80,050        &nbs= p; 76,735       80,572 <= /td>       84,600 <= /td>       88,830 <= /td>    
&nb= sp; Net profit/lo= ss before reserve contribution     16,400        &nbs= p; 34,265       41,028 <= /td>       48,660 <= /td>       52,256 <= /td>    
&nb= sp;                
Reserves              
&nb= sp; carry over re= serve balance     49,097        &nbs= p; 65,000     102,265    &nb= sp;  88,855     142,596    
&nb= sp; transfer from= excess in Operating fund     25,600 <= span style=3D'mso-spacerun:yes'>       &nbs= p;        -   <= span style=3D'mso-spacerun:yes'>       &nbs= p;    -   <= span style=3D'mso-spacerun:yes'>       &nbs= p;     -   <= span style=3D'mso-spacerun:yes'>       &nbs= p;     -      
&nb= sp; Maintenance R= eserve contribution     16,400        &nbs= p; 34,265    &nb= sp;  41,028       48,660 <= /td>       52,256 <= /td>    
&nb= sp; Reserve expen= ditures    (31,400) <= span style=3D'mso-spacerun:yes'>       &nbs= p;        -        (58,438) <= span style=3D'mso-spacerun:yes'>       &nbs= p;     -      (163,970)    
&nb= sp; Accumulated r= eserve funds   &= nbsp; 59,697        &nbs= p; 99,265       84,855 <= /td>     137,515       30,882 <= /td>    
&nb= sp; Interest earn= ed      2,000        &nbs= p;   3,000        4,= 000         5,081         3,575    
&nb= sp; Expected year= end reserve balance     61,697        10= 2,265       88,855 <= /td>     142,596       34,457 <= /td>    
&nb= sp; Target year e= nd Reserve balance     86,404        12= 5,283     107,883     151,252       31,060 <= /td>    
Reserve deficit vs. target    (24,707)         (23,018)    = ;  (19,028)        (8= ,656)         3,397    
=
=
=
=
=
=
=
=
=
=
=
=
=
=
------=_NextPart_01C729B2.DAFD0140 Content-Location: file:///C:/9159C637/RRHOA-Budget2007_files/sheet002.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" RRHOA - 2007 Budget
Income  2006 proposed budget  2007 budget 2008 2009 2010 Assumptions
Homeowner dues         322         353.33        &nbs= p;  389        &nbs= p;  428        &nbs= p;   470  Expenses increase 5% a year 
Special assessment        &nbs= p;  -          &nbs= p; 16.67        &nbs= p;    17        &nbs= p;    17        &nbs= p;     -    Target reserve based on reserve study 
Late fees        &nbs= p;  -          &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -    Reserve expenditures based on res= erve study 
Interest income        &nbs= p;  -          &nbs= p;      -          &nbs= p;    -   0 0  Interest earned based on reserve study 
Architectural review        &nbs= p;  -          &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -  
Other income        &nbs= p;  -          &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -  
Total income         322         370.00        &nbs= p;  405        &nbs= p;  444        &nbs= p;   470
Expenses        &nbs= p;  -          &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -  
A= dministration        &nbs= p;  -          &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -  
Legal        &nbs= p;    3        &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -  
Newsletter        &nbs= p;    1        &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -  
Accounting        &nbs= p;  27        &nbs= p;      28        &nbs= p;    30        &nbs= p;    31        &nbs= p;    33
Consulting        &nbs= p;  -          &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -  
Office expenses/bank charges        &nbs= p;    2        &nbs= p;        2        &nbs= p;      2        &nbs= p;      2        &nbs= p;      2
Total administration        &nbs= p;  34        &nbs= p;      30        &nbs= p;    32        &nbs= p;    34        &nbs= p;    35
Utilities        &nbs= p;  -          &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -  
Electricity        &nbs= p;  28        &nbs= p;      30        &nbs= p;    31        &nbs= p;    33        &nbs= p;    34
Telephone        &nbs= p;    1        &nbs= p;        1        &nbs= p;      1        &nbs= p;      1        &nbs= p;      1
Water/sewer        &nbs= p;  25        &nbs= p;      33        &nbs= p;    35        &nbs= p;    37        &nbs= p;    39
Garbage        &nbs= p;  -          &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -  
Total utilities        &nbs= p;  54        &nbs= p;      64        &nbs= p;    67        &nbs= p;    70        &nbs= p;    74
O= perations        &nbs= p;  -          &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -  
Maintenance & repair        &nbs= p;    1        &nbs= p;      12        &nbs= p;    12        &nbs= p;    13        &nbs= p;    14
Landscape         117        &nbs= p;    123        &nbs= p;  129        &nbs= p;  135        &nbs= p;   142
Total operations         151        &nbs= p;    134        &nbs= p;  141        &nbs= p;  148        &nbs= p;   155
O= ther expenses        &nbs= p;  -          &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -  
Social committee        &nbs= p;    5        &nbs= p;        5        &nbs= p;      5        &nbs= p;      6        &nbs= p;      6
Insurance        &nbs= p;  17        &nbs= p;      18        &nbs= p;    19        &nbs= p;    20        &nbs= p;    21
Quarterly meetings        &nbs= p;    0        &nbs= p;        0        &nbs= p;      0        &nbs= p;      0        &nbs= p;      0
Taxes & licenses        &nbs= p;    1        &nbs= p;        1        &nbs= p;      1        &nbs= p;      1        &nbs= p;      1
Bad debt        &nbs= p;    5        &nbs= p;        3        &nbs= p;      4        &nbs= p;      4        &nbs= p;      4
Total other expenses        &nbs= p;  28        &nbs= p;      27        &nbs= p;    29        &nbs= p;    30        &nbs= p;    32
       &nbs= p;  -          &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -  
Total expenses         267        &nbs= p;    256        &nbs= p;  269        &nbs= p;  282        &nbs= p;   296
Net profit/loss before reserve contribution        &nbs= p;  55        &nbs= p;    114        &nbs= p;  137        &nbs= p;  162        &nbs= p;   174
<= /td>        &nbs= p;  -          &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -  
Reserves        &nbs= p;  -          &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -  
carry over reserve balance         164        &nbs= p;    217        &nbs= p;  341        &nbs= p;  296        &nbs= p;   475
transfer from excess in Operating fund        &nbs= p;  85        &nbs= p;      -          &nbs= p;    -          &nbs= p;     -          &nbs= p;     -  
Maintenance Reserve contribution        &nbs= p;  55        &nbs= p;    114        &nbs= p;  137        &nbs= p;  162        &nbs= p;   174
Reserve expenditures        (1= 05)        &nbs= p;      -          &nbs= p; (195)        &nbs= p;     -          &nbs= p;  (547)
Accumulated reserve funds         199        &nbs= p;    331        &nbs= p;  283        &nbs= p;  458        &nbs= p;   103
Interest earned        &nbs= p;    7        &nbs= p;      10        &nbs= p;    13        &nbs= p;    17        &nbs= p;    12
Expected year end reserve balance         206        &nbs= p;    341        &nbs= p;  296        &nbs= p;  475        &nbs= p;   115
Target year end Reserve balance         288        &nbs= p;    418        &nbs= p;  360        &nbs= p;  504        &nbs= p;   104
Difference        &nbs= p; (82)        &nbs= p;     (77)        &nbs= p;   (63)        &nbs= p;   (29)        &nbs= p;    11
------=_NextPart_01C729B2.DAFD0140 Content-Location: file:///C:/9159C637/RRHOA-Budget2007_files/filelist.xml Content-Transfer-Encoding: quoted-printable Content-Type: text/xml; charset="utf-8" ------=_NextPart_01C729B2.DAFD0140--