MIME-Version: 1.0 X-Document-Type: Workbook Content-Type: multipart/related; boundary="----=_NextPart_01CA7F2C.33CE5810" 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 Windows® Internet Explorer®. ------=_NextPart_01CA7F2C.33CE5810 Content-Location: file:///C:/ACB422B2/BudgetSummaryWorksheet2.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" <body> <p>This page uses frames, but your browser doesn't support them.</p> </body> ------=_NextPart_01CA7F2C.33CE5810 Content-Location: file:///C:/ACB422B2/BudgetSummaryWorksheet2_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;} .style45 {mso-number-format:"_\(\0022$\0022* \#\,\#\#0\.00_\)\;_\(\0022$\0022* \\\(= \#\,\#\#0\.00\\\)\;_\(\0022$\0022* \0022-\0022??_\)\;_\(\@_\)"; mso-style-name:Currency; mso-style-id:4;} .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, sans-serif; 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;} .font20 {color:black; font-size:8.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:Tahoma, sans-serif; mso-font-charset:0;} .font21 {color:black; font-size:8.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Tahoma, sans-serif; mso-font-charset:0;} .font23 {color:black; font-size:8.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Tahoma; mso-generic-font-family:auto; mso-font-charset:1;} .font24 {color:black; font-size:8.0pt; font-weight:700; font-style:normal; text-decoration:none; font-family:Tahoma; mso-generic-font-family:auto; mso-font-charset:1;} td {mso-style-parent:style0; padding:0px; mso-ignore:padding; color:windowtext; font-size:10.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Arial, sans-serif; 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:style0; mso-number-format:"Short Date";} .xl66 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:.5pt solid black; border-left:none;} .xl67 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:none; border-right:none; border-bottom:.5pt solid black; border-left:none;} .xl68 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:none; border-right:1.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none;} .xl69 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:1.5pt solid black; border-bottom:none; border-left:none;} .xl70 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:none; border-left:1.5pt solid black;} .xl71 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:right;} .xl72 {mso-style-parent:style0; mso-number-format:0%; text-align:right;} .xl73 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)";} .xl74 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none;} .xl75 {mso-style-parent:style0; color:black; font-size:12.0pt; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)";} .xl76 {mso-style-parent:style0; mso-number-format:"0\.0%"; text-align:right;} .xl77 {mso-style-parent:style0; mso-number-format:Percent;} .xl78 {mso-style-parent:style0; mso-number-format:"0\.0%";} .xl79 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:right; border-top:none; border-right:none; border-bottom:.5pt solid black; border-left:none;} .xl80 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:none; border-left:1.5pt solid windowtext;} .xl81 {mso-style-parent:style0; mso-number-format:0%;} .xl82 {mso-style-parent:style0; mso-number-format:"0\.0%"; text-align:right; border-top:none; border-right:none; border-bottom:2.0pt double windowtext; border-left:none;} .xl83 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:2.0pt double windowtext; border-left:none;} .xl84 {mso-style-parent:style0; font-size:12.0pt; font-weight:700; mso-number-format:0%;} .xl85 {mso-style-parent:style0; font-size:12.0pt; font-weight:700; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)";} .xl86 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:right; border-top:none; border-right:1.5pt solid black; border-bottom:none; border-left:none;} .xl87 {mso-style-parent:style0; mso-number-format:0%; border-top:none; border-right:none; border-bottom:2.0pt double windowtext; border-left:none;} .xl88 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:right; border-top:none; border-right:1.5pt solid black; border-bottom:.5pt solid black; border-left:none;} .xl89 {mso-style-parent:style0; color:black; font-weight:700; font-style:italic; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:none; border-left:1.5pt solid black;} .xl90 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)";} .xl91 {mso-style-parent:style0; mso-number-format:"_\(* \#\,\#\#0\.00_\)\;_\(* \\\(\#\,\#\#0\.00\\\)\;_\(*= \0022-\0022??_\)\;_\(\@_\)";} .xl92 {mso-style-parent:style0; color:black; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:.5pt solid black; border-right:1.5pt solid black; border-bottom:none; border-left:none;} .xl93 {mso-style-parent:style0; mso-number-format:"Medium Date"; border-top:none; border-right:none; border-bottom:.5pt solid black; border-left:none;} .xl94 {mso-style-parent:style0; mso-number-format:"Medium Date";} .xl95 {mso-style-parent:style0; font-size:12.0pt; font-weight:700; mso-number-format:0%; text-align:right; border-top:2.0pt double windowtext; border-right:none; border-bottom:none; border-left:none;} .xl96 {mso-style-parent:style0; font-size:12.0pt; font-weight:700; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:right; border-top:2.0pt double windowtext; border-right:none; border-bottom:none; border-left:none;} .xl97 {mso-style-parent:style45; mso-number-format:"_\(\0022$\0022* \#\,\#\#0_\)\;_\(\0022$\0022* \\\(\#\,\= #\#0\\\)\;_\(\0022$\0022* \0022-\0022??_\)\;_\(\@_\)";} .xl98 {mso-style-parent:style0; mso-number-format:"_\(\0022$\0022* \#\,\#\#0_\)\;_\(\0022$\0022* \\\(\#\,\= #\#0\\\)\;_\(\0022$\0022* \0022-\0022??_\)\;_\(\@_\)";} .xl99 {mso-style-parent:style0; color:black; font-style:italic; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:1.5pt solid black; border-bottom:none; border-left:none;} .xl100 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:2.0pt double black; border-right:none; border-bottom:1.5pt solid black; border-left:none;} .xl101 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; font-style:italic; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:2.0pt double black; border-right:none; border-bottom:1.5pt solid black; border-left:none;} .xl102 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:1.5pt solid black; border-left:1.5pt solid black;} .xl103 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:1.5pt solid black; border-left:none;} .xl104 {mso-style-parent:style0; mso-background-source:auto; mso-pattern:black gray-0625;} .xl105 {mso-style-parent:style0; text-align:right;} .xl106 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0";} .xl107 {mso-style-parent:style0; font-size:12.0pt; font-weight:700; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:none; border-left:1.5pt solid windowtext;} .xl108 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:none; border-left:1.5pt solid windowtext;} .xl109 {mso-style-parent:style0; color:black; font-weight:700; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:1.5pt solid windowtext; border-left:1.5pt solid windowtext;} .xl110 {mso-style-parent:style0; border-top:none; border-right:none; border-bottom:1.5pt solid windowtext; border-left:none;} .xl111 {mso-style-parent:style0; mso-number-format:Fixed; border-top:none; border-right:none; border-bottom:1.5pt solid windowtext; border-left:none;} .xl112 {mso-style-parent:style0; font-weight:700;} .xl113 {mso-style-parent:style0; color:black; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:.5pt solid black; border-right:none; border-bottom:none; border-left:none;} .xl114 {mso-style-parent:style0; color:black; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:.5pt solid black; border-right:none; border-bottom:none; border-left:none;} .xl115 {mso-style-parent:style0; color:black; font-size:16.0pt; font-weight:700; font-family:Cambria, serif; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:left;} .xl116 {mso-style-parent:style0; color:black; font-style:italic; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:0; border-top:.5pt solid black; border-right:none; border-bottom:none; border-left:none;} .xl117 {mso-style-parent:style0; color:black; font-style:italic; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:0;} .xl118 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; font-style:italic; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center;} .xl119 {mso-style-parent:style0; color:black; mso-number-format:"\0022$\0022\#\,\#\#0_\)\;\\\(\0022$\0022\#\,\#\#0\\\)"; text-align:right;} .xl120 {mso-style-parent:style0; text-align:right; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none;} .xl121 {mso-style-parent:style0; mso-number-format:"\0022$\0022\#\,\#\#0_\)\;\\\(\0022$\0022\#\,\#\#0\\\)"; text-align:right;} .xl122 {mso-style-parent:style0; mso-number-format:"\0022$\0022\#\,\#\#0_\)\;\\\(\0022$\0022\#\,\#\#0\\\)"; text-align:right; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none;} .xl123 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:none; border-right:none; border-bottom:1.5pt solid black; border-left:none;} .xl124 {mso-style-parent:style0; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none;} .xl125 {mso-style-parent:style0; font-weight:700; border-top:none; border-right:none; border-bottom:none; border-left:1.5pt solid windowtext;} .xl126 {mso-style-parent:style0; border-top:1.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none;} .xl127 {mso-style-parent:style0; border-top:none; border-right:none; border-bottom:none; border-left:1.5pt solid windowtext;} .xl128 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:1.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none;} .xl129 {mso-style-parent:style0; text-align:center;} .xl130 {mso-style-parent:style0; text-align:center; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none;} .xl131 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center;} .xl132 {mso-style-parent:style0; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none;} .xl133 {mso-style-parent:style0; color:black; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:left;} .xl134 {mso-style-parent:style0; border-top:none; border-right:none; border-bottom:2.0pt double windowtext; border-left:none;} .xl135 {mso-style-parent:style0; border-top:none; border-right:none; border-bottom:2.0pt double windowtext; border-left:1.5pt solid windowtext;} .xl136 {mso-style-parent:style0; border-top:2.0pt double windowtext; border-right:none; border-bottom:1.5pt solid black; border-left:1.5pt solid windowtext;} .xl137 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; font-style:italic; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:1.5pt solid black; border-right:none; border-bottom:none; border-left:1.5pt solid windowtext; background:white; mso-pattern:black gray-0625;} .xl138 {mso-style-parent:style0; mso-number-format:"\0022$\0022\#\,\#\#0";} .xl139 {mso-style-parent:style0; color:black; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none;} .xl140 {mso-style-parent:style0; color:black; font-size:16.0pt; font-weight:700; font-family:Cambria, serif; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:left; border-top:none; border-right:none; border-bottom:none; border-left:1.5pt solid windowtext;} .xl141 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:.5pt solid black; border-left:1.5pt solid windowtext;} .xl142 {mso-style-parent:style0; color:black; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:none; border-left:1.5pt solid windowtext; background:white; mso-pattern:black none;} .xl143 {mso-style-parent:style0; color:black; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:none; border-left:1.5pt solid windowtext;} .xl144 {mso-style-parent:style0; font-weight:700; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)";} .xl145 {mso-style-parent:style0; mso-number-format:0%; border-top:none; border-right:none; border-bottom:none; border-left:1.5pt solid windowtext; background:white; mso-pattern:black none;} .xl146 {mso-style-parent:style0; color:black; font-style:italic; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:left; border-top:none; border-right:none; border-bottom:none; border-left:1.5pt solid windowtext;} .xl147 {mso-style-parent:style0; color:black; font-style:italic; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:none; border-left:1.5pt solid windowtext;} .xl148 {mso-style-parent:style0; mso-number-format:0; text-align:right;} .xl149 {mso-style-parent:style43; mso-number-format:"_\(* \#\,\#\#0_\)\;_\(* \\\(\#\,\#\#0\\\)\;_\(* \0022-\= 0022??_\)\;_\(\@_\)"; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none;} .xl150 {mso-style-parent:style0; mso-number-format:Fixed; text-align:left; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none;} .xl151 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:right; border-top:none; border-right:1.5pt solid windowtext; border-bottom:.5pt solid black; border-left:none;} .xl152 {mso-style-parent:style0; color:black; font-weight:700; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none;} .xl153 {mso-style-parent:style0; color:black; font-style:italic; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none;} .xl154 {mso-style-parent:style0; font-size:12.0pt; font-weight:700; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:right; border-top:2.0pt double black; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none;} .xl155 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0"; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none;} .xl156 {mso-style-parent:style0; border-top:none; border-right:1.5pt solid windowtext; border-bottom:1.5pt solid black; border-left:none;} .xl157 {mso-style-parent:style0; mso-number-format:"\0022$\0022\#\,\#\#0"; text-align:right; padding-right:12px; mso-char-indent-count:1;} .xl158 {mso-style-parent:style0; font-weight:700; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:2.0pt double windowtext; border-right:1.5pt solid windowtext; border-bottom:1.5pt solid windowtext; border-left:none;} .xl159 {mso-style-parent:style0; border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid windowtext;} .xl160 {mso-style-parent:style0; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none;} .xl161 {mso-style-parent:style0; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:none; border-left:none;} .xl162 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none; background:#D7E4BC; mso-pattern:black none;} .xl163 {mso-style-parent:style0; background:#D7E4BC; mso-pattern:black none;} .xl164 {mso-style-parent:style0; mso-number-format:"\0022$\0022\#\,\#\#0_\)\;\\\(\0022$\0022\#\,\#\#0\\\)"; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none; background:#D7E4BC; mso-pattern:black none;} .xl165 {mso-style-parent:style0; mso-number-format:"\0022$\0022\#\,\#\#0_\)\;\\\(\0022$\0022\#\,\#\#0\\\)"; border-top:none; border-right:1.5pt solid windowtext; border-bottom:2.0pt double black; border-left:none; background:#D7E4BC; mso-pattern:black none;} .xl166 {mso-style-parent:style0; font-size:12.0pt; font-weight:700; mso-number-format:"\0022$\0022\#\,\#\#0_\)\;\\\(\0022$\0022\#\,\#\#0\\\)"; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none; background:#D7E4BC; mso-pattern:black none;} .xl167 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; background:#D7E4BC; mso-pattern:black none;} .xl168 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:right; background:#D7E4BC; mso-pattern:black none;} .xl169 {mso-style-parent:style0; text-align:right; background:#D7E4BC; mso-pattern:black none;} .xl170 {mso-style-parent:style0; color:black; font-style:italic; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none; background:#D7E4BC; mso-pattern:black none;} .xl171 {mso-style-parent:style0; mso-number-format:"_\(* \#\,\#\#0_\)\;_\(* \\\(\#\,\#\#0\\\)\;_\(* \0022-\= 0022??_\)\;_\(\@_\)"; text-align:right; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none; background:#D7E4BC; mso-pattern:black none;} .xl172 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:right; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none; background:#D7E4BC; mso-pattern:black none;} .xl173 {mso-style-parent:style58; mso-number-format:0%; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none; background:#D7E4BC; mso-pattern:black none;} .xl174 {mso-style-parent:style58; mso-number-format:0%; text-align:right; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none; background:#D7E4BC; mso-pattern:black none;} .xl175 {mso-style-parent:style0; color:black; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; background:#D7E4BC; mso-pattern:black none;} .xl176 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0"; background:#D7E4BC; mso-pattern:black none;} .xl177 {mso-style-parent:style0; mso-number-format:"\0022$\0022\#\,\#\#0_\)\;\\\(\0022$\0022\#\,\#\#0\\\)";} .xl178 {mso-style-parent:style0; text-align:left; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none;} .xl179 {mso-style-parent:style0; text-align:left;} .xl180 {mso-style-parent:style0; mso-number-format:Fixed; text-align:left;} .xl181 {mso-style-parent:style0; mso-number-format:"\0022$\0022\#\,\#\#0_\)\;\\\(\0022$\0022\#\,\#\#0\\\)"; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none;} .xl182 {mso-style-parent:style0; font-weight:700; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:.5pt solid windowtext;} .xl183 {mso-style-parent:style0; font-size:8.0pt; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none; background:white; mso-pattern:black none;} .xl184 {mso-style-parent:style0; font-weight:700; mso-number-format:0%; text-align:center; border-top:.5pt solid windowtext; border-right:.5pt solid windowtext; border-bottom:none; border-left:none;} .xl185 {mso-style-parent:style0; mso-number-format:"\0022$\0022\#\,\#\#0_\)\;\\\(\0022$\0022\#\,\#\#0\\\)"; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none;} .xl186 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:right; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none;} .xl187 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none; background:white; mso-pattern:black none;} .xl188 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0"; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none; background:white; mso-pattern:black none;} .xl189 {mso-style-parent:style0; background:white; mso-pattern:black none;} .xl190 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0"; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none;} .xl191 {mso-style-parent:style0; mso-number-format:Percent; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none;} .xl192 {mso-style-parent:style0; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:.5pt solid windowtext;} .xl193 {mso-style-parent:style0; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none;} .xl194 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0"; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none;} .xl195 {mso-style-parent:style0; text-align:right; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none; background:#D7E4BC; mso-pattern:black none;} .xl196 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0"; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none; background:#D7E4BC; mso-pattern:black none;} .xl197 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none; background:#D7E4BC; mso-pattern:black none;} .xl198 {mso-style-parent:style0; mso-number-format:0%; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none; background:#D7E4BC; mso-pattern:black none;} .xl199 {mso-style-parent:style0; mso-number-format:"mmm\\-yy"; background:#D7E4BC; mso-pattern:black none;} .xl200 {mso-style-parent:style0; mso-number-format:Percent; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none; background:#D7E4BC; mso-pattern:black none;} .xl201 {mso-style-parent:style0; border-top:none; border-right:.5pt solid windowtext; border-bottom:none; border-left:none; background:#D7E4BC; mso-pattern:black none;} .xl202 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:1.5pt solid black;} .xl203 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none;} .xl204 {mso-style-parent:style0; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:.5pt solid windowtext;} .xl205 {mso-style-parent:style0; mso-number-format:"\0022$\0022\#\,\#\#0_\)\;\[Red\]\\\(\0022$\0022\#\,\#\#= 0\\\)"; background:#D7E4BC; mso-pattern:black none;} .xl206 {mso-style-parent:style0; text-align:center; border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid windowtext;} .xl207 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:none; border-right:none; border-bottom:none; border-left:.5pt solid windowtext;} .xl208 {mso-style-parent:style0; mso-number-format:0;} .xl209 {mso-style-parent:style0; font-weight:700; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none;} .xl210 {mso-style-parent:style0; font-weight:700; mso-number-format:0; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none;} .xl211 {mso-style-parent:style0; border-top:none; border-right:.5pt solid windowtext; border-bottom:.5pt solid windowtext; border-left:none;} .xl212 {mso-style-parent:style0; font-weight:700; background:#D7E4BC; mso-pattern:black none;} .xl213 {mso-style-parent:style0; border-top:1.0pt solid windowtext; border-right:1.0pt solid windowtext; border-bottom:none; border-left:none;} .xl214 {mso-style-parent:style0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; border-top:none; border-right:1.0pt solid windowtext; border-bottom:none; border-left:none;} .xl215 {mso-style-parent:style0; mso-number-format:"\0022$\0022\#\,\#\#0"; text-align:right; border-top:none; border-right:1.0pt solid windowtext; border-bottom:none; border-left:none; padding-right:12px; mso-char-indent-count:1;} .xl216 {mso-style-parent:style0; border-top:none; border-right:1.0pt solid windowtext; border-bottom:none; border-left:none;} .xl217 {mso-style-parent:style0; mso-number-format:"\0022$\0022\#\,\#\#0"; border-top:none; border-right:1.0pt solid windowtext; border-bottom:none; border-left:none;} .xl218 {mso-style-parent:style0; mso-number-format:Fixed; border-top:none; border-right:1.0pt solid windowtext; border-bottom:1.0pt solid windowtext; border-left:none;} .xl219 {mso-style-parent:style0; color:black; font-size:20.0pt; font-weight:700; font-family:Cambria, serif; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:1.5pt solid black; border-right:none; border-bottom:none; border-left:1.5pt solid windowtext;} .xl220 {mso-style-parent:style0; color:black; font-size:20.0pt; font-weight:700; font-family:Cambria, serif; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:1.5pt solid black; border-right:none; border-bottom:none; border-left:none;} .xl221 {mso-style-parent:style0; color:black; font-size:20.0pt; font-weight:700; font-family:Cambria, serif; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:1.5pt solid black; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none;} .xl222 {mso-style-parent:style0; color:black; font-size:16.0pt; font-weight:700; font-family:Cambria, serif; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:left; border-top:none; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none;} .xl223 {mso-style-parent:style0; font-size:18.0pt; font-weight:700; font-family:Cambria, serif; mso-font-charset:0; mso-number-format:"mmm\\-yy"; text-align:center; border-top:none; border-right:none; border-bottom:1.5pt solid black; border-left:1.5pt solid windowtext;} .xl224 {mso-style-parent:style0; font-size:18.0pt; font-weight:700; font-family:Cambria, serif; mso-font-charset:0; text-align:center; border-top:none; border-right:none; border-bottom:1.5pt solid black; border-left:none;} .xl225 {mso-style-parent:style0; font-size:18.0pt; font-weight:700; font-family:Cambria, serif; mso-font-charset:0; text-align:center; border-top:none; border-right:1.5pt solid windowtext; border-bottom:1.5pt solid black; border-left:none;} .xl226 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; font-style:italic; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:1.5pt solid black; border-right:none; border-bottom:none; border-left:1.5pt solid windowtext; background:white; mso-pattern:black gray-0625;} .xl227 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; font-style:italic; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:1.5pt solid black; border-right:none; border-bottom:none; border-left:none; background:white; mso-pattern:black gray-0625;} .xl228 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; font-style:italic; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:1.5pt solid black; border-right:1.5pt solid black; border-bottom:none; border-left:none; background:white; mso-pattern:black gray-0625;} .xl229 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; font-style:italic; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:1.5pt solid black; border-right:none; border-bottom:none; border-left:1.5pt solid black; background:white; mso-pattern:black gray-0625;} .xl230 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; font-style:italic; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:1.5pt solid black; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none; background:white; mso-pattern:black gray-0625;} .xl231 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; font-style:italic; font-family:SWISS; mso-generic-font-family:auto; mso-font-charset:0; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:none; border-right:1.5pt solid black; border-bottom:none; border-left:none; background:white; mso-pattern:black gray-0625;} .xl232 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; font-style:italic; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:1.5pt solid black; border-right:none; border-bottom:none; border-left:1.5pt solid black; mso-background-source:auto; mso-pattern:black gray-0625;} .xl233 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; font-style:italic; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:1.5pt solid black; border-right:none; border-bottom:none; border-left:none; mso-background-source:auto; mso-pattern:black gray-0625;} .xl234 {mso-style-parent:style0; color:black; font-size:12.0pt; font-weight:700; font-style:italic; mso-number-format:"\#\,\#\#0_\)\;\\\(\#\,\#\#0\\\)"; text-align:center; border-top:1.5pt solid black; border-right:1.5pt solid windowtext; border-bottom:none; border-left:none; mso-background-source:auto; mso-pattern:black gray-0625;} ------=_NextPart_01CA7F2C.33CE5810 Content-Location: file:///C:/ACB422B2/BudgetSummaryWorksheet2_tabstrip.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii"
 Summary Budget 
------=_NextPart_01CA7F2C.33CE5810 Content-Location: file:///C:/ACB422B2/BudgetSummaryWorksheet2_sheet001.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii"
13th & "I&quo= t; Apts.
Summary Budget input data to = green cells only
Sponsor/Developer:  Associated Ministries       Owner:  Associated Ministries
   
DEVELOPMENT BUDGET PROJECT DATA CONSTRUCTION/D= ESIGN VARIABLES
Description   %TDC Per Unit Estimate Total Number of Units 35 dev fee calc =3D 503509.9          
   Land 10,000 350,000   site developme= nt cost 1,500,000 total land acq cost 350,000
   Acquisition Costs 0 0        &nbs= p;            -   res cost per s= q ft $115  
Total Acquisition (asking price) 6.2% 10,000 350,000 Number of Parking Spaces   commercial coo= nstruction contract 245,000  
Res. Construction (+ site dev costs) 67.9% 108,925 3,812,363 Assessors Parcel Number   res square fee= t calc  
Architectural Fees 1.6% 2,543 89,000 Number of Stories: Zoning:   type total units sq ft/unit total  
Survey & Eng. 0.3% 457 16,000 Acreage: Density: #DIV/0! 1-bdrm 10 450 4500  
Commercial Construction 4.4% 7,000 245,000 FINANCING 2-bdrm 16 550 8800  
Perm Financing Csts 0.2% 343 12,000 Source   % TDC Per Unit Total 3-bdrm 9 650 5850  
Attorney Fees 0.4% 714 25,000 Res. Bank Loan<= /td> 0% 0   total 19150  
Appraisal 0.1% 129 4,500 State HTF 22% 35,000 $1,225,000   plus 5% 958  
Other Costs  1.0% 1,571 55,000 City (HOME) 4% 7,143 $250,000   total res sq f= t 20108      
Developer Fee 9.0% 14,386 503,510 Foundation 1% 1,429 $50,000
Capitilized Reserves 1.3% 2,143 75,000 County 2060 3% 4,286 $150,000
Syndication Costs 0.8% 1,286 45,000 LP Capital Cont= ributions 66% 105,415 $3,689,531 9% TAX CREDIT CALCULATION
Contingency  (10% of const): 6.8% 10,892 381,236 0% 0   TAX CREDIT EQU= ITY CALCULATION   9%
TOTAL DEVLPM'T COSTS 100% 160,389 5,613,609 Commercial Loan= 4% 7,000 $245,000 Basis $4,505,372
RENTAL INCOME (ANNUAL) 0% 0   Deduct federal= grant amounts 0
Unit Type Number Gross Utility  Net Annual     0% 0   Eligible Basis= 4,505,372
Target of Units Rent Allowance Rent Revenue Total Sources 100% 160,272 $5,609,531   WSHFC Determination of Basis   4,505,372
Studio     ADDITIONAL FUND= S REQUIRED 4,078 Allowable Basi= s (lesser of eligible or IHFA Award) 4,505,372
30%<= /td>     0 0 RESERVES Impact Fees  
40%     0 0 Replacement Re= serves   High Cost Area Adjustment 130%[1]
50%<= /td>     0 0 Max. funder required per uni= t annual contribution/unit/yr 250 Adjusted Basis= 5,856,984
Section 8     0 0 Project Replace= ment Reserve Contribution (annual) 8,750 LIHTC Credit R= ate  as of: Oct-09 9.00% IRS published 9% rate
Subtotal 0       0   LIHTC Credit C= alculated 527,129 annual credit available to i= nvestor
1 Bedroom Operating Rese= rves   Actual Awarded= by WSHFC 527,129
30%<= /td> 2 383 83 300 7,200 "capitaliz= ed" operating reserve cnbtribution        &nbs= p;     25,000 10 year value<= /td> 5,271,286
40% 4 511 83 428 20,544   % Sale to Equi= ty Investor 99.99%
50%<= /td> 2 638 83 555 13,320   Net raise $/ T= ax Credit 0.7 what investor is willing to = pay for each credit $
Section 8 2 650 650 15,600   Net Equity to = Project     3,689,531 10-year value of credits to = investor
Subtotal 10       56,664 OPERATING EXPENSES
2 Bedroom      Item   % EGI Per Unit Annual
30%<= /td> 4 459 114 345 16,560 Administration 17% 1,000 35,000
40%<= /td> 4 613 114 499 23,952 Utilities 18% 1,086 38,000
50%<= /td> 3 766 114 652 23,472 Operating & Maintenance 27% 1,600 56,000
Section 8 4 825 825 39,600 Taxes & Ins= urance 6% 329 11,500
Subtotal 15       103,584 Service Expense= s 32% 1,857 65,000
3 Bedroom   Total Operating= 100% 5,871 205,500
30%<= /td> 2 531 130 401 9,624     Per month<= /td> 489 17,125
40%<= /td> 2 708 130 578 13,872  
50%<= /td> 3 885 130 755 27,180  
Section 8 2 950 950 22,800  
Subtotal 9       63,852 PROJECTED CASH FLOW VARIABLES
  Managers Units 1     Rent Increase Rate - Tenant 2%
  Total "Workforce" Units 8 Workforce rev 63,972   Rent Increase Rate - Operating S= ubsidy 2%
  S8 total/specia= l needs 8 total s8 rev 78,000   Vacancy Rate 7%
&n= bsp; TOTAL UNITS/RENT REVENUE 35   224,100   Operating Expense Increase   3%
CA= SH FLOW    
  Year: 1 2 3 4 5 6 7
GROSS INCOME Per Unit  
Total Rental Income 2% 6,403 224,100 228,582 233,154 237,817 242,573 247,425 252,373
Other Income (Laundry?) 97 3,400 3,468 3,537 3,608 3,680 3,754 3,829
Operating Subsidy (O & M?) 400 14,000 14,280 14,566 14,857 15,154 15,457 15,766
Services Revenue 2% 65,000 $66,300 $67,626 $68,979 $70,358 $71,765 $73,201
SCHEDULED GROSS INCOME 8,757 306,500 312,630 318,883 325,260 331,765 338,401 345,169
  (Less) Vacancy Allowance 5% 438 15,325 15,632 15,944 16,263 16,588 16,920 17,258
EFFECTIVE GROSS INCOME 8,319 291,175 296,999 302,938 308,997 315,177 321,481 327,910
NET  INCOME  
  (Less) Operating Expenses 3.50% (5,871) (205,500) (212,693) (220,137) (227,842) (235,816) (244,070) (252,612)
  (Less) Reserves (8,750) (9,013) (9,283) (9,561) (9,848) (10,144) (10,448)
  NET OPERATING INCOME 2,198 76,925 75,294 73,519 71,594 69,513 67,268 64,850
   
DEBT SERVICE CALCULATION  
Source Amount Rate Term  
HTF  $       &nbs= p;   1,225,000 [2] 2.00% 40 $44,515 $44,515 $44,515 $44,515 $44,515 $44,515 $44,515
   
Private  [3] 5.50% 30 $0 $0 $0 $0 $0 $0 $0
   
DEBT SERVICE (Total) 44,515 44,515 44,515 44,515 44,515 44,515 44,515
NET CASH FLOW 32,410 30,778 29,003 27,079 24,998 22,752 20,335
Debt Service Coverage      1.73 1.69 1.65 1.61 1.56 1.51 1.46
&nb= sp;                  
=
=
=
=
=
=
=
=
[1]
QCT =3D 290.01
[2]
Walter Zisette:
% of units >30% AMI =3D % of loan requiring debt service

[3]
Walter Zisette:
=3D+pv(c73,D73,-E67)
------=_NextPart_01CA7F2C.33CE5810 Content-Location: file:///C:/ACB422B2/BudgetSummaryWorksheet2_filelist.xml Content-Transfer-Encoding: quoted-printable Content-Type: text/xml; charset="utf-8" ------=_NextPart_01CA7F2C.33CE5810--