ࡱ> bd  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry$ FIW0,ҾEF/@Workbook'(v_VBA_PROJECT_CUR"V#1,`#1,VBA#9Y#1,`#1, ZO\pGeorge Davidsons Ba= ThisWorkbook=&x-8X@"1MArial1hMArial1MArial1MArial1MArial1hMArial1MArial1.MTimes New Roman1MArial1.MTimes New Roman1.MTimes New Roman1.MTimes New Roman1 MArial1$MArial1.MTimes New Roman1.@MTimes New Roman1.MTimes New Roman1.MTimes New Roman1.MTimes New Roman1MArial1.MTimes New Roman1.MTimes New Roman1MArial1.MTimes New Roman1.MTimes New Roman1.hMTimes New Roman1.hMTimes New Roman1.@MTimes New Roman1.@MTimes New Roman1.MTimes New Roman1MArial1.MTimes New Roman1.MTimes New Roman1.MTimes New Roman1.@MTimes New Roman1.MTimes New Roman1@MArial1.MTimes New Roman1@MArial1.MTimes New Roman1.MTimes New Roman1@MArial1.MTimes New Roman1.hMTimes New Roman1.@MTimes New Roman1.@MTimes New Roman1.hMTimes New Roman1MCourier1.MTimes New Roman1.MTimes New Roman1@MArial1.TMTimes New Roman1MArial1.hMTimes New Roman1MArial1.MTimes New Roman1.MTimes New Roman1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1 Calibri1. Times New Roman17Arial1.7Times New Roman1Arial1.Times New Roman1 Arial1. Times New Roman1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.00000% 0.00000 00000mmmm\ d\,\ yyyy"#,##0.00000_);\(#,##0.00000\)#,##0.000_);\(#,##0.000\)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off" "$"#.00 %#.00 #.00 "$"#"$"#,##0\ ;\("$"#,##0\)!"$"#,##0\ ;[Red]\("$"#,##0\)""$"#,##0.00\ ;\("$"#,##0.00\)'""$"#,##0.00\ ;[Red]\("$"#,##0.00\) #\ ?? m/d/yy m/d/yy\ h:mmm/d#,##0.0_);\(#,##0.0\) #,##0.0000_);\(#,##0.0000\)0.00_);\(0.00\)0.0000_);\(0.0000\) 0.00000.0000;[Red]0.0000 0;[Red]0 "$"#,##0 0.000% General_) 0.0% 0_);\(0\) #,##0.0000 0.0000% "$"#,##0.0000 dd\-mmm\-yy "$"#,##0.00#,##0;[Red]#,##0 mm/dd/yy "$"#,##0.0\ ;\("$"#,##0.0\)"$"#,##0;[Red]"$"#,##0 0.000000!"$"#,##0.00;[Red]"$"#,##0.00 "$"#,##0.0_);\("$"#,##0.0\)$[$-409]dddd\,\ mmmm\ dd\,\ yyyy[$-409]h:mm:ss\ AM/PM "$"#,##0.00.0 "$"#,##0.00094_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"??_);_(@_)$"$"#,##0.000\ ;\("$"#,##0.000\)],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)                 :  :  :  :  :  :  :  :  :  :  :  :  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  ;  <  =   > ff   )     *              ?   @    A  A    B   C ` D  O 0       E       F  a G # (#4#4    %"@  %" q @  q @ q H  q"X  q h@@  q `@  q `P @  q `@  q `  q `P  q H  q h@  q lP  q dP  q `  q hP@ q h q hP q"xP q"xP 0"\+ q!xP q"|P q hP q!X q H p q L A @ @ @  q H 0!|+ p  p  @ @ q H q#X p! q!\  q p p +p  q H p# p p p q H p  q#P q"X p" q"\  A" p  q"X p +0#L+ A  0#L+ @ @ 0!\+  #L !p A A  A p A  @  q L q L q L@  p q L  q L q L p 0#h  "X @ p "p q L+A#P #A  p  + p #L A" @ #@ A#` A A A A A q h A A#  A $@ A q h A  A P "A" A  A q h  q H q H A A" A"P q hP A" A H  # $@  A @ A" A q h A"P A#  "+ 0"|+ A 0#hP+ A#  #+  #  #  A" %q hP A @ q lP`  A" @ P A P  ! + %q H @ @ A &A#P 0!| + %q h @"   lP` A @@ A @ "P @ p  ' ,P  A @  ,P  A P@ A P A"PP p P@  p P  @ P  @ PP  @ A  @  A    @  H    L Q    @   P  !\  "X  H  H   #P  Q" "X " "\ "X @#H+  H @#H Q  @#H !    @#h P   H Q#P Q  Q" #Q  Q#` Q    H (  l`    l`  P  P   X  "X #! # # * H * H +! #" !X  H  H  X  xP ##hP )! ! # H Q!x Q x P  Q   "x " "xP , h #  # hP Q"x Q x P# Q  "x  "xP # h # hP P"  h #P P"P  h`  ` #P ` Q"xP Q xP P P Q P  "xP  P P"PP #  ` !x  x # h  "xP #!x Q  "xP  hP #P P # hPP #X - h Q h #x` P ` P  # X   `  hP #!x` # x` # h` Q hP` !xP  xP # hP #xP Q hPP P P Q#x # hP #!P # P # P #P P #!U # U # U # hU # hU # X    "xP Q"xP Q!x P  "P Q!xP  "PP  "` .!X !X  X "X  H , H !  !X & & #! # #  # #    H      H     "X  "   L  ! L+ !    h   ! l + ! ,    (    L   L   H+  h + L   h`    (`    h   (  H  #X   " +   "@ + $ H $   " H ""X " " $  H  !"  "   L $ h   !"8   "    l   "X  @#l+  " @#H+ @#h +  @#l + $ h`   !"  H "    @"|+ " !   L  #+ $#X   h   !X 0#L %0!\  0#L  " @#hP   H   h   L   l   h  ! L  ! l  #  #  "  "  @#l  "  # "q H  "  q"P  q q   q @  q  q P  q P  q ,PP  q"p  q `  q `P  q `P  q `PP  q"p  q"pP  q"p  q"p  q"pP  q"p  q"p  q!P  q" "1# $ $  H  #  q!X %0!| # x p  @#h "1! @ @  %p  1# p A"  p %0!| 0#l  0#l  @ @#h /a" $a  1a 1a 2a"@@ 2a"@@ 1a"@ 1a"@ 1a"@@ 1a"@@ 1`"Q@ @ 1a" 1a"QP@ 1`"@@+ 1`"@@+ 1`"@@+ 1`"@@+ 1` @@ 1`"@ 1`"@@ 1a"@ q H 0#hP  0#\  1# 1" 1%a"@@ 1%a"@@ 1a"@@ 1a"@@ 1 a"@@ @#L  " %0!|+ q!X  "` Q!x Q"x * h  " Q!x   " 3q  3 L $q!X 5q H 5 L 5q  5q" 5 q H  p# @" 0" + q"\ 7q (U@@ 5q (U@ q x+  "+ 0"|+ 0#hP+  0#\ 7 00_)}}B ??v00_)̙[$ -##0.  }A}C }00_)[$ -}A}D e00_)[$ -}x}I00_)[$##  }}J ???00_)[$???## ???  ??? ???}-}N 00_)}-}P 00_)}(}X00_)}(}Y00_)}(}Z00_)}(}[00_)}(}^ 00_)}(}_ 00_)}(}` 00_)}(}f00_)}(}g00_)}(}h00_)}(}i00_)}(}j00_)}(}k00_)}(}l00_)}(}m00_)}(}p00_)}(}{ 400_)}(}| 400_)}(}} 400_)}(} 00_)}(} 00_)}(} 00_)}(} 00_)}(} 00_)}<} 00_)[$}<} 00_)[$}<} 00_)[$}(} 00_)}(}00_)}(}00_)}(}00_)}(}00_) 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0] -Comma0.&Currency/. Currency [0]%0 Currency_PART IV - PROJECT COSTS1 Currency_t22 Currency_t2t3 Currency04 Currency0_t25 Currency0_t2t 6Date7Explanatory TextG5Explanatory Text % 8Fixed9 : Followed Hyperlink :Good;Good  a%; Heading 1( Heading 1< Heading 2( Heading 2= Heading 3G Heading 3 I}%23> Heading 49 Heading 4 I}% ?HEADING1 @HEADING2A( Hyperlink BInputuInput ̙ ??v% C Linked CellK Linked Cell }% DNeutralANeutral  e%"NormalE Normal_Book1FNormal_PG 21 RENT CHARTG Normal_t2H Normal_t2t INoteb Note   JOutputwOutput  ???%????????? ???K$PercentL Percent_t2M Percent_t2t NTitle1Title I}% OTotal TotalP Warning Text? Warning Text % Qwhite RYellowS Yellow_t2T Yellow_t2tXTableStyleMedium9PivotStyleLight16M#6:D^4L8X dlbecerra - Personal ViewMnMtcFK)'X dbharding - Personal ViewNr)LIgԉ4X daauerbach - Personal View`MACROSMSignature PageRent Qual. ChartxWEligBasisLimits Breakdown Carryover]Percentage_LimitsI OPER INCOME NOI 6              YYYYYYYYYY Y Y  TISTAFFEXCEL FILESApplication Review and 8609 Templates20208609 review 2019.xlsMACROS 8609 Review CONTENTS TCSignature PageRent Qual. ChartEligBasisLimits Breakdown CarryoverPercentage_Limits OPER INCOMENOIYF%HUNIAP 20178. PART_III_POINTS.xlsFamilySeniorSup HsgYYY (tc_carryover_indep_audit_attach (2).xlsMACROS CONTENTS TCSignature PageRent Qual. ChartEligBasisLimits Breakdown CarryoverPercentage_LimitsTies OPER INCOMENOIYYZ VZaY Z 9Y Z #+   _xlfn.IFERRORza)w;  ;  ;  ; '0 ; 3< ; BJ; SY; SY; ``; bbza)w;  ;  ;  ; '0 ; 3< ; BJ; SY; SY; ``; bbz a)w;  ;  ;  ; '0 ; 3< ; BJ; SY; SY; ``; bbza)w;  ;  ;  ; '0 ; 3< ; BJ; SY; SY; ``; bbza)w;  ;  ;  ; '0 ; 3< ; BJ; SY; SY; ``; bbza)w; ;;;%. ;19 ;>G;PV;PV;]];__! ACREAGE;YY%AGENCY_DEBTSERV:o BR_1;// BR_10;88BR_11: ;BR_11:; BR_11:;BR_11:;BR_11:;BR_11:;BR_12: <BR_12:< BR_12:<BR_12:<BR_12:<BR_12:<BR_13: =BR_13:= BR_13:=BR_13:=BR_13:=BR_13:=BR_14: >BR_14:> BR_14:>BR_14:>BR_14:>BR_14:>BR_15: ?BR_15:? BR_15:?BR_15:?BR_15:?BR_15:?BR_16: @BR_16:@ BR_16:@BR_16:@BR_16:@BR_16:@BR_17: BBR_17:B BR_17:BBR_17:BBR_17:BBR_17:BBR_18: CBR_18:C BR_18:CBR_18:CBR_18:CBR_18:CBR_19: DBR_19:D BR_19:DBR_19:DBR_19:DBR_19:D BR_2;00 BR_3;11 BR_4;22 BR_5;33 BR_6;44 BR_7;55 BR_8;66 BR_9;77$ CARRY_PERC;xx" CASHFLOW; O" CASHFLOW;O" CASHFLOW;O" CASHFLOW;O" CASHFLOW;O" CASHFLOW;S CLOSING:" CNTRCTFE;hhCOMMIT:" CONSTERM;CONSTR: CONSTR:  CONSTR: CONSTR: CONSTR: CONSTR:   COUNTY;" DATE_PRP;" DEBT_OTH;rr" DEV_NAME;  DEV_STREET: % DEVELOPMENT;S#DEVFEE: DEVFEE:  DEVFEE: DEVFEE: DEVFEE: DEVFEE: ! DEVFEE_PERC< ! DEVFEE_PERC<!  DEVFEE_PERC<! DEVFEE_PERC<! DEVFEE_PERC<! DEVFEE_PERC<DSR:  DSR:  DSR: DSR: DSR: DSR: DSR_SOLV: DSR_SOLV: DSR_SOLV:DSR_SOLV:DSR_SOLV:DSR_SOLV: DU_1;// DU_10;88DU_11: ;DU_11:; DU_11:;DU_11:;DU_11:;DU_11:;DU_12: <DU_12:< DU_12:<DU_12:<DU_12:<DU_12:<DU_13: =DU_13:= DU_13:=DU_13:=DU_13:=DU_13:=DU_14: >DU_14:> DU_14:>DU_14:>DU_14:>DU_14:>DU_15: ?DU_15:? DU_15:?DU_15:?DU_15:?DU_15:?DU_16: @DU_16:@ DU_16:@DU_16:@DU_16:@DU_16:@DU_17: ADU_17:A DU_17:ADU_17:ADU_17:ADU_17:ADU_18: BDU_18:B DU_18:BDU_18:BDU_18:BDU_18:BDU_19: CDU_19:C DU_19:CDU_19:CDU_19:CDU_19:C DU_2;00DU_20: DDU_20:D DU_20:DDU_20:DDU_20:DDU_20:D DU_3;11 DU_4;22 DU_5;33 DU_6;44 DU_7;55 DU_8;66 DU_9;77" DWELUNIT;:: ERR1; F10A; J  F10A;J  F10A;J  F10A;J  F10A;J  F10A;J  F10B; [  F10B;[  F10B;[  F10B;[  F10B;[  F10B;Z  F10C; #  F10C;#  F10C;#  F10C;#  F10C;#  F10C;.  F10D; 5  F10D;5  F10D;5  F10D;5  F10D;5  F10D;@  F10E;   F10E;  F10E;  F10E;  F10E;  F10E;   FAMILY;$X @& FEDERAL_LOW_INCOME_HOUSING_TAX_CREDITS;8FINAL<%" FINANCE1;""" FINANCE2;##" FINANCE3;$$! form10E;H ! form10F; ! Form10G;M  FUNDA_AMT:  FUNDA_DESC: FUNDA_FLAG: FUNDB_AMT:  FUNDB_DESC: FUNDB_FLAG: FUNDC_AMT:  FUNDC_DESC: FUNDC_FLAG: FUNDD_AMT:  FUNDD_DESC: FUNDD_FLAG: FUNDE_AMT:  FUNDE_DESC: FUNDE_FLAG: FUNDF_AMT: $ FUNDF_DESC; kk$ FUNDF_DESC;kk$ FUNDF_DESC;kk$ FUNDF_DESC;kk$ FUNDF_DESC;kk$ FUNDF_DESC;jj FUNDF_FLAG: FUNDG_AMT: l  FUNDG_AMT:l   FUNDG_AMT:l  FUNDG_AMT:l  FUNDG_AMT:l  FUNDG_AMT:k  FUNDG_DESC: l FUNDG_DESC:l  FUNDG_DESC:l FUNDG_DESC:l FUNDG_DESC:l FUNDG_DESC:k FUNDG_FLAG: l FUNDG_FLAG:l  FUNDG_FLAG:l FUNDG_FLAG:l FUNDG_FLAG:l FUNDG_FLAG:k FUNDH_AMT: m  FUNDH_AMT:m   FUNDH_AMT:m  FUNDH_AMT:m  FUNDH_AMT:m  FUNDH_AMT:l  FUNDH_DESC: m FUNDH_DESC:m  FUNDH_DESC:m FUNDH_DESC:m FUNDH_DESC:m FUNDH_DESC:l FUNDH_FLAG: m FUNDH_FLAG:m  FUNDH_FLAG:m FUNDH_FLAG:m FUNDH_FLAG:m FUNDH_FLAG:l$FUNDS_ESCROWED: " GROSHELT;" GROSRENT;   HMFA;' HOPE_VI_CYCLE;$   INDUCE;mJinputEligBasisLimits)G;;;=; ;',mJinputEligBasisLimits)G;;;=; ;',mJ inputEligBasisLimits)G;;;=; ;',mJinputEligBasisLimits)G;;;=; ;',mJinputEligBasisLimits)G;;;=; ;',mJinputEligBasisLimits)G;;;;;(-;(-V >inputTies);: : : : : : ; ,1V >inputTies);: :::<: ; V > inputTies);: :::<: ; V >inputTies);: :::<: ; V >inputTies);: :::<: ; V >inputTies);: : : : : : ; */" INSUR_EX;cc" LOW_INC_PERC:,%MANAGE_FEE_PERC:`! MAX_DEV_FEE:j" MGMT_RVW;MIP: MIP: MIP:MIP:MIP:MIP:$MORTG_INTEREST:l MORTG_RATE: MORTG_TERM:" MORTG1_2;xxMORTGAGE: MORTGAGE:  MORTGAGE: MORTGAGE: MORTGAGE: MORTGAGE: # mos._______on: # mos._______on:#  mos._______on:# mos._______on:# mos._______on:# mos._______on:( MRTGandFEE_AMT;mm%MRTGandFEE_PERC:m! MUNICIP;# NET_APT_RENTS:J NET_INCOME:v# NET_OPERATING:i%NET_OTHR_RENTAL:O" NETRNTAR;::%PAYMNTS_PERYEAR: " PREPARER;  ; g  ;T   ;#  ;8  ;9  ;B   ;": ( rangeBreakdown; f ( rangeBreakdown; f ( rangeCarryOver;S( rangeCarryOver;S. rangeEligBasisLimits;& 9rangeMFbreakdown);FV;E" rangeNOI;8& rangeOperInc;9& rangeOperInc;9, rangePercentLimits;@ , rangePercentLimits;@ " rangeRQC;": & rangeSigPage; 7 # rangeTies;( % RE_TAX_PERC;" RE_TAXAB;! RENT_UP;%RETURN_ONEQ_AMT:~ %RETURN_ONEQUITY:x" REVIEWBY; RR_PERC:e S_U; >  S_U;>  S_U;>  S_U;>  S_U;>  S_U;>  SandU;!5Y? SCHEDULE_10_B___EST._DEVELOPMENT_COSTS_AND_CAPITAL_REQUIREMENTS;P SOLV1: SOLV1: SOLV1:SOLV1:SOLV1:SOLV1:SOLV2:  SOLV2:  SOLV2: SOLV2: SOLV2: SOLV2:   solver_adj:   solver_opt: solver_typ solver_val! SPONSOR;$SPONSOR_EQUITY:  SQFT;YY" SQFT_ACR;YY SSS;%A. SUBURBAN_RURAL_CYCLE;$\ ! TOT_ADM;" TOT_EMPL;! TOT_EXP;gg& TOT_EXPENSES;gg! TOT_FUNDYES:r ! TOT_M_R;" TOT_MCTR;" TOT_RENT;::" TOT_REVENUES:X" TOT_UTIL;" TOT_WAGE; %TOTAL_DEBT_SERV:t$TOTAL_RENT_INC:Q  TOTPRJ; % URBAN_CYCLE;$X ! VACANCY;II" VACANCY_PERC:I" WKS_MORTGAGE:5 Iv Other:MAINTENANCE CONTRACTSTenantHMFA 1st Mortgage, NOTE I#TAX CREDIT RENT QUALIFICATION CHARTThe purpose of this chart is to show that the rent charged for each tax credit eligible unit is at or below the set-aside selected. See N.J.A.C. 5:80-33.12(c)(7)(i)..2\1abcdefghijk= e + f= g x 12 = i x 30%= h / jStudio, Eff, SRO orUnitCounty Income Limit (100%)30% of AffordabilitySquare Footage# of BathroomsUtility Allowances Gross RentAnnual Gross RentAdjusted for Family SizeCounty Median Income Percentage7Provide information for Superintendent's Unit(s) below: Column A:Show the number of units for each bedroom size. If you need more lines, you may duplicate this chart. Show all units in the project on this chart, including market rate units. Column B:1BR, 2BR, 3BR, etc. Column C:Unit Square Footage Column D: 1 Bath, 1.5 Baths, 2 Baths, etc. Column E:Show the amount of rent charged for each unit. This is the actual rent a non-subsidized tenant will pay. If the unit will be a Section 8 Project Based Assistance unit, you may show Fair Market Rent (FMR).Only Project Based Section 8 may show FMRs. Even if you anticipate renting to Section 8 Certificate holders, you must still reflect rents at or below 50% or 60% (depending on elected set-aside). Column F:Calculate the utility allowance for each tax credit unit using the chart provided. Refer to IRS Final Regulation TD 8520 for requirements relating to the calculation of utility allowances. Column G:EAdd the utility allowance to the monthly rent to find the Gross Rent. Column H:?Multiply the Gross Rent by 12 to get the Annualized Gross Rent. Column I:List the county median income limit for the appropriate size household. Assume 1.5 persons per bedroom. Refer to the chart titled "ӣƵ Income Limits by County Adjusted by Family Size". Column J:0Multiply the County Median Income Limit by 30%. Column K:Divide the number in Column H by the number in Column J. The Code does not allow for the rounding down of affordability percentages. In allocating the units in a project which shall be occupied by individuals of low and moderate income, the distribution must reflect low and moderate income units among the different sized units to reflect the same percentagedistribution as the number of different sized units bears to the total number of units. A greater percentage of the low and moderate income units may, however, be allocated to the larger units. Additionally, low and moderateincome units shall be distributed throughout the project such that the tenants of such units will have equal acess to and enjoyment of all common facilities of the project. N.J.A.C. 5:80-8.3.EXPENSESNET OPERATING INCOME DEBT SERVICEXDATEINIT MODIFCATIONSLES!UNPROTECTED STAGES & PROJECT TYPE?CHANGED COST OF LAND & IMPROV PER DU & SQFT TO INCLUDE BUILDINGACQUISTION (1B)7/9/93les^Imported 10-G standalone changes into Form10. Changed Develop Fee % calc. (reversed divsion)%Added Sponsor Equity - line 13a,b,c HChanged carryover of sources based on Y,N,G source flages on pages E & F%changed application speedbar command "unprotected fields on top of 10-G L* Changed 10-G Development Fee Reference (looking in column H rather than J)2Change Print Scaling to 81% - Widen Columns H & E LPer DD - On Page 10D modified No of Bed & No of Units columns to be inputted Fire Suppression System! Total Number of Units+ Rehabilitation expenses per unitIrather than carried over from Page A. Need to split out unit income typesWPage 10E - changed net commercial rentals = commerical inc + garage (-) comm vacancys $ was adding the three fields before.JPage 10C - Changed Computer Charges to be Dwelling Units * 44.4 (was 40.4)03/28/95Nremoved startup macro \0 which would put up the Form10 application Bar from I:)since this is being used on r2d2 & njhmfaper unitCostCostsBedroomsTotalReplacement ReservesNet RentProject: Municipality:County:0Additional Items Added to Eligible Basis Limits:Special Needs Cycle(Y or N)Volume Cap Tax CreditsTotal Units (including Super) # of UnitsPer Unitx(include all units)Elig Basis LimitPer Unit Limit EFFICIENCIES1-BR2-BR3-BR4-BR5-BRTOTAL ELIGIBLE BASIS LIMIT Green FeaturesGreen FeaturesLimits apply to total eligible basis for rehabilitation or new construction tax credits BEFORE any applicable 130% adjustment for project location within a DDA or QCT. Reviewer:Stage:QCT (Y or N) Project Name:DDA{Windowsoff}{Paneloff}{Home} Special NeedsScattered Site Single/Duplex DevelopmentNon-Depreciable Non-EligibleEligible Basis forEligible Basis Rehab / NCfor Acquisition ACQUISITION Building Relocation Other: CONSTRUCTION Demolition Off-Site Improvements Residential Structures Environmental Clearances Surety & Bonding Building PermitsCONTRACTOR FEE Contractor Overhead & Profit General Requirements CONTINGENCY Hard Contingency  Soft ContingencyPROFESSIONAL SERVICES Appraiser & Market Study Architect Attorney Cost Certification / Audit Engineering Environmental Consultant Historical Consultant Professional Planner Soil Investigation SurveyorCARRYING & FINANCING Interest Points & Bank Fees R.E. Taxes Insurance Title Insurance & Recording Utility Connection Fees Other Impact Fees Tax Credit Fees SUB-TOTALLANDORGANIZATIONAL COSTSSYNDICATION EXPENSESMARKETING EXP & HAS FEEESCROWS:Working CapitalOperating Deficit EscrowDebt & InsuranceTaxTOTALEligible Basis LimitLesser of Total or LimitQCT / DDA Adjustment FUNDING SOURCEINTEREST AMORTIZATIONAMOUNTRATE=Basis as AdjustedApplicable FractionQualified BasisTax Credit PercentageTax Credits basedon Qualified Basis SYNDICATORLP or Non-Voting Member %PRICINGConstruction Cost / UnitReasonably ExpectedIncurred throughBasis) Hard Contingency (10% Rehab / 5% New)CARRYOVER PERCENTAGEDEVELOPER PERCENTAGE INCURRED # of Bedrooms!Contractor Profit/Overhead Limits Construction Contract Amount Bracket %Maximum Fee for3Example Calculation of Maximum Contractor Profit/OHBracket MinimumBracket MaximumLower Bracketsto$0Construction Contract of amount over $ 500,000 +of amount over $ 1,000,000 +- Bracket Minimumof amount over $ 5,000,000 +of amount over $10,000,000 + Differenceof amount over $15,000,000 +and overof amount over $20,000,000 +x Bracket % for Contract AmountDifference x Bracket %+Maximum Fee for Lower BracketsAmounts included inMaximum Profit & OHConstruction Contract Demolition3Calculation of Maximum Contractor Profit & OverheadOff-Site ImprovementsResidential StructuresEnvironmental ClearancesSurety & BondingBuilding Permits Other: General Requirements + Maximum Fee for Lower BracketsConstruction Contract AmountDeveloper Fee LimitsProjects with 25 Units or Less/Scattered Site Single Family or Duplex Projects General Rule*A*Building Acquisition Costs Excluded if Related Party Transaction"Construction Cost + Contractor Fee&FEDERAL LOW INCOME HOUSING TAX CREDITSOPERATING INCOMEPER UNITANNUALYEARor %TRENDINGINCOMETAX CREDIT UNITS GROSS RENTnet rentLAUNDRYPARKINGOTHERSUBTOTALVACANCYPHYSICAL COLLECTIONNET SUBSIDIES SECTION 8 SECTION 9NON TAX CREDIT UNITSCOMMERCIAL INCOMEOTHER:EFFECTIVE INCOMETenant PopulationElevator (Y or N) Rehab or NewADMINISTRATIONSALARIESM&R INSURANCE UTILITIESMANAGEMENT FEEREAL ESTATE TAXESRESERVESSOCIAL SERVICESTOTAL OPERATING EXPENSESFIRST HARD DEBT SE< RVICEFIRST HARD DEBT SERVICING FEEbpSECOND HARD DEBT SERVICECASH FLOW AFTER HARD DEBTRATIO ANALYSISFIRST HARD DEBT COVERAGE RATIOEXPENSE : EFFECTIVE INCOMEOPERATING DEFICIT RESERVEINTEREST INCOME#UTILIZATION FOR CASH FLOW SHORTFALLBALANCE Total Maximum LIHTC5INVESTOR PROCEEDS NEEDED FROM LOW INC HSG TAX CREDITS-FEDERAL LOW INCOME HOUSING TAX CREDITS NEEDEDCommunity Service FacilityGarage Parking Community Service Facility Garage Parking Print Date:First Mortgage DSCR)HOME EXPRESS DEBT SERVICE (If Applicable)Fire Suppression System Other: Developer FeeSubtotal Neg. Arb, Cost of Issuance Acquisition'Garage Parking for Tax Credit ResidentsbSubstantial v. Minimum Rehabilitation (NOTE: Minimum Rehab. is defined as less than $25,000/unit)'4Total Eligible Basis FF & E FF & E: Development Cost / Unit**"DEVELOPER FEE - CONSTRUCTION/REHAB!DEVELOPER FEE - EXISTING BUILDING%Mandatory Deferred Fee - Constr/Rehab(Projects in the Supportive Housing CycleTotal # of Residential Floors 4 residential floors or less5 or 6 residential floors Eligible Basis Limits (per unit)7 residential floors and above **see QAP for per unit cost capsDEVELOPER FEE - Constr/RehabDEVELOPER FEE - BuildingCommunity Service ExclusionHERA basis boost+Mandatory Deferred Fee - Existing Building AVG AFFORDABILITY+ Site Work 50% testE 2022 ELIGIBLE BASIS LIMITS WORKSHEET "BREAKDOWN OF COSTS & BASIS -- 2022CARRYOVER -- 20222022 CONTRACTOR FEE LIMITSCALENDAR YEAR -- 2022-15-YEAR OPERATING PROFORMA REQUIRED SIGN-OFFSWe acknowledge the attached pro forma substantially matches the assumptions used in our underwriting of the mortgage (equity investment). 1st Mortgagee*__________________________________________ORSyndicator/Investor(if no lender)BREAKDOWN OF COSTS AND BASISREQUIRED SIGN-OFFSQThe undersigned acknowledges review of the attached Breakdown of Costs and Basis.2Application/Re-Application, or 42(m) Determination Carryover AccountantCURRENT INDICATIONS Print DateNet Income (Year 1)Net Expense (Year 1)Annual Tax Credit Amountz 2RE0..l@   M6/D5[o1L7r=YIwD#HF,_K/h5n"[X3aWcc PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭Vȉ<&J &M5BNe tY>?#!mfKx=[Ԃu}ˆ ~umoLz^W/}ةLo;9iwk/_tV[,ac߬56YvYp1ϡAz 9ۮ7ެe ."Zk1~EȰ RӔ/x$( :7vʗsSj{"bF^x^xz?>~,ɸ7Gg_zy5^|?}V I򋧿>OQ>19ٵ<Ÿ8ߊaG@tOE*\ʻ/ yToN:"1Q(v; y4<$jbRa|PŻǴI Y3wJG݈8b2(<& QHT^w/B(`Z!94[Mc˴j`jG7;Q]o YC5*CocU 9 IQ/ RV+`%*;æWѼ9/#~7qZ$*cߓrUngN>%OOi Dh[BvoLJƌB6>p&>w O]>.ɲ,5,<ؾt&9 ԔEЇIIqhJ#f6kAS&2D)p3ӕ5teO`jvzEOG)9cshger-# ~fu-ԙՍh&9܊- 6 AлY3hX"M$#Fz6#b.w*lyhĭɾ̮]nR3+=,)'Kak.zi X 8Ka6!_ 5[ M܆< kW Ds/Z/j@&8?&5- C⫲K3Zw1K|D!`~J0A?Uֶy&,Xg1K#[y$[BTV)bBRvVt=낕@[\׶Dž8d4~_@`rx \kp*O69mY&ԧ HE]HKN!Vj%2BƣJԊ=" u\ӵC&Y0>g4&oN)j rihr"VTU,koy#ŬjQJpRk3܎Ws;ɢ!JT~u "֠ۀW_ Nq֙4)ڬuZˋw֒TvќXHegvtm,{2Da*20V=CoOQ2'@C8D.IrG[Ȥiࠆ)d͛|?&f9>b|w##(ɇ"C *_p=ce΂aenv*Wm瓗{varAˇ$IDpKs6* ʢG0egAnlCYt֏$Ysă)2|FS` uz'Xr*󠍒F`Bi m/Ҷj9Xrmox86tFo˜ b`>ASDbƟPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!ÄA theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK] QLV[ZB<wYvI$ ZO ]}  dMbP?_*+%8&?'?(?)?Mz\\2kadvsrv\HP5Si_238C odXXLetter DINU"`z`SMTJPHP LaserJet 5SiInputBinOption1RESDLLUniresDLLOrientationPORTRAITResolutionOption1PaperSizeLETTERMediaTypeAutoSelectCollateOFFEconomodeOption1RETOption1HalftoneHT_PATSIZE_AUTODuplexNONEStaplingBogusOutputBinOption1GraphicsModeHPGL2MODE"dXX??&U} U}   8 8 8 8 8 8  8  8  8 8 8 8 8 8 8 8 8 8 8 8 UB UC UD!UEM4D?  ] UE UF UG UH UI UJ UK UL UM! Uit?  ] UJ UN! U?  ] UJ UO VV VPVVVVVVVV VQVVVVVVVV VVVVVVVVVVV !V=s?  ] VJ VRVVVVVVVV VV VVVVVVVVVV VV VWVVVVVVVV VV VXVVVVVVVV VV VYVVVVVVVV VVVVVVVVVVV UZ UJ U[ U\,|*A*AA6( [6666 *  \  V>#6:ٌ4<@ &?'?(?)?M\\2kadvsrv\5Si_3250C odXXLetter DINU"06KOZ "dXX??&#6:D^4L@nMtcFK)'d@=@&?'?(?)?M\\2kadvsrv\5Si_3250C odXXLetter DINU"06KOZ "dXX??&nMtcFK)'@r)LIgԉ4d@=@&?'?(?)?M\\2kadvsrv\5Si_3250C odXXLetter DINU"06KOZ "dXX??&r)LIgԉ4 7 Sheet251ggD ZO 5g-  dMbP?_*+%&ffffff?'ffffff?(?)?"333333?333333?&<3U} t}  } .} }  } .5                          d     e f g h i g j k l m n f g i g*Nh.""""..  #%&'(,),, -./01234   o h ~ @ #f #g %i %g & 'p 'g() ,q -r --S1@AJ-.. /s/-Z'9 / 0t0/Z(# 011 220Z)V 2 3u 33 2Z)a34$,>H:::H a- >@2 22 ."   33ggD ZO N-*KzSlV  dMbP?_*+%,&?'?(?)?M\\HMF-PRT-003\RICOH_Multifamil  odXX10DRe>js xW˖6 Mdh]@$dqL,qz(ڢll6OvQEq wv/O;t[Td-Z@f) FေqYg䒢( z\SZ+1Z㈘3Ν)Va˟.zy%9|)HV8 Aϱ>ZPHg_k8 Ίy5RZqC}LE|.ߜu0" RCJ:{[ŽRQM2ATSxK$$ (g➻l dѱSRhmT4Ņ//8ׂ!sn}xh /Ϥz_nU1nDyQt%|O59Wk%ՆСX:rwxmUo,5mk%6MVXSY?g6?Pvr c%4q0Ɉ@^,exZcqm~3:r}Tey6lRyɬp֐E{W&k\D l//ѹ!()<%'  EwHc7M,ӗl}`faoE$p2`Rԧ} 'uB lUៜċDG>5b2kvKl&DAaqH'i)8Sٽ ~^dDGۢxrC4Í':z*|ײszǏ' Y fdu,&%g< Ar$u!$@ cW^ _KQhTS8߮8TkӘZ_竤yKջ-͏ȖjLvedv|_wwb)Fd X_ͻJ#m}?%w_̕!va:x~Z"@XX333333?333333?&43U} ]}  } } ] }  } ] } .}  } t} ]} } .} t} ] } }  } N8@,,@ @,,8  ;@0 ;@0 ;@0 ;@0 ;@0;@0;@0;@0;@0;@0;@0;@0;@0;@0;@0;@0;@0;@0;@0w@;@ 8,     !!  !!! !! " # # # # # # #  #  #  # $%%%%% % % %  %  % & ' ' '' ' ''  '  '  ( ))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) $l % % % %c % % %  %  %!  *" ))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) 899W:: :    LL :    L  + :    L333333?. < #D D B   !  #LLB& ^ D D    899X:: ;   ;   . ;   <  "  #LLB #   _    LL   899X:: ;   ;   . ;   <      _    899X:: ;   ;   . ;   <      _    899-:: ;   ;   . ;  <      _   899-::; ;   . ;   <     _  899-::; ;   . ;  <  -  #D DB _  899-::; ;   . ;  <     ! #LLB _  899-::; ;   . ;  <  " #LLB     _  899-::; ;   . ;  <      _  899-::; ;   . ;  <      _  899-::; ;   . ;  <      _  899-::; ;   . ;  <      _  899-::; ;   . ;  <      _  899-::; ;   . ;  <      _  899-::; ;   . ;  <      _  899-::; ;   . ;  <      _  899-::; ;   . ;   <     _  899-::; ;   . ;  . < #DD B    _   /#0000000000_ ,-----11-11  `  22222222222 # ^ %    $  %))))))))) DCl, blw(  :AG  K@ ! ," K@# 8 $ K@% ,& K@' ,( ,) K@* ,+ K@, ,- K@. ,/ K@0 ,1 K@2 ,3 K@4 ,5 @6 ,7 ,8 ,9 ,: ,; ,< ,= ,> ,? ,   ))))))))) ! & ! '!)))))))) ! ["  )))))))) " \ # ( # )#)))))))) ># (#%  % x%B%$  ))))))))) % * % +%))))))))) &  ))))))))) ' , ' -'))))))))) () ( .())))))))) )!!!!!!!!!!! * / * 0*!!!!!!!!! +!!!!!!!!!!! , 1 , 2,!!!!!!!!! -!!!!!!!!!!! . 3 . 4.!!!!!!!!! /!!!!!!!!!!! 0 5 0 60!!!!!!!!! 1!!!!!!!!!!! 2 7 2 82!!!!!!!!! 3!!!!!!!!!!! 4 9 4 :4!!!!!!!!! 5! !!!!!!!!! 6! !!!!!!!!! 7!!!!!!!!!!! 8 ;8!!!!!!!!!! 9 <9!!!!!!!!!! : =:!!!!!!!!!! ;!!!!!!!!!!! <!!!!!!!!!!! =!!!!!!!!!!! >!!!!!!!!!!! ?!!!!!!!!!!! Dl D, 8 84 8 8 8 8 8 8 ,,, @ ,A ,B ,C ,D ,E ,F ,G ,H ,I ,J ,K ,L ,M ,@!!!!!!!!!!! A!!!!!!!!!!! B!!!!!!!!!!! C!!!!!!!!!!! D!!!!!!!!!!! E!!!!!!!!!!! F!!!!!!!!!!! G!!!!!!!!!!! H!!!!!!!!!!! I!!!!!!!!!!! J! J!!K! K!!L! L!!M!  T)  M7  !-  4 !    A# )>PP  ***  7 Sheet16ggD ZO Ak  dMbP?_*+% &?'?(?)?M\\HMF-PRT-003\RICOH_Multifamil  odXX10DRe>js xW˖6 Mdh]@$dqL,qz(ڢll6OvQEq wv/O;t[Td-Z@f) FေqYg䒢( z\SZ+1Z㈘3Ν)Va˟.zy%9|)HV8 Aϱ>ZPHg_k8 Ίy5RZqC}LE|.ߜu0" RCJ:{[ŽRQM2ATSxK$$ (g➻l dѱSRhmT4Ņ//8ׂ!sn}xh /Ϥz_nU1nDyQt%|O59Wk%ՆСX:rwxmUo,5mk%6MVXSY?g6?Pvr c%4q0Ɉ@^,exZcqm~3:r}Tey6lRyɬp֐E{W&k\D l//ѹ!()<%'  EwHc7M,ӗl}`faoE$p2`Rԧ} 'uB lUៜċDG>5b2kvKl&DAaqH'i)8Sٽ ~^dDGۢxrC4Í':z*|ײszǏ' Y fdu,&%g< Ar$u!$@ cW^ _KQhTS8߮8TkӘZ_竤yKջ-͏ȖjLvedv|_wwb)Fd X_ͻJ#m}?%w_̕!va:x~Z"AXX??&U} }  } } } } } t}  } } } |} A@@@ @ @   @ @ @  @ @ @@ YY @ DD D88@@ @@ @0@@ YYYYYYYYYY _rr}}}}}}Y[3YYYYYYYY Y [dYYYYYYY Y [eYYYYYYY Y [fYYYYYYY YYYYYYYYYY YYYYYYYYYY YYYYYYYYYY Y \YY tS usss ~ ? vAD  YYYYYYvwsss ~ @ vA D  Y ch  \i YY vQ~ xvA sss ~ @ vA D  YYYYYvxsss ~ @ vA D  Y cj  \i YY vR~ x@$A sss ~ @ @$A D YYYYYvxsss ~  @ @$A D Y ckD \YY yT~ zA sss ~  @ A D c\~   @ A D {{{{{{ cP \~  "@ A  : *D {{{{{{YYYYYYYYY ~  $@ A  YYYYYYYYYY ~  &@ A  YY ]g^_aa ~  (@ A  YjkY`abaa ~  *@ A  Y lY d9aeZ    ~~ ~  ,@ A  Y ` l m lnY`af ~  .@ A  Y o p qY dFaeZ    ~~  0@ D  A  Y rmZ*DD Y D Y B% N/AD% : BfB"#LLBY  1@  : " L A  Y sm*DY ha" DD    2@   A  Y tm*DYPPMMM  3@   A  Y um*DYPPMMM  4@   A  Y vm*DY VHW"] DD    5@   A  Y wm*DYPPMMM  6@   A  Y nxGo1% %LBp# %pYPPMMM  7@   A  Dl""666"""kMMMSrMMcM0 ! " # $ % & ' @( @) @* @+ @, @- @. / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  YYYYYPPPPP  8@!   A  !YYYYYNNNNN ! 9@"  ! A  "YYYYYNNNNN " :@#  " A!  #Y #q{#YYYY# ;@$  # A"  $YqYYYY$ <@%  $ A#  %YYJJJ% =@&  % A$  &YKLMMM& >@'  & A%  'ONMPP' ?@(  ' A&  (ONMPP( @@)  ( A'  )ONMPP) @@*  ) A(  *ONMPPYYYYY * A@+  * A)  +ONMPP+ A@,  + A*  ,ONMPP, B@-  , A+  -ONNNN- B@.  - A,  .ONNNN. C@/  . A-  /I/ C@0  / A.  0I0 D@1  0 A/  1 D@2  1 A0  2 E@3  2 A1  3 E@4  3 A2  4 F@5  4 A3  5 F@6  5 A4  6YqYYYY6 G@7  6 A5  7 G@8  7 A6  8 H@9  8 A7  9 H@:  9 A8  : I@  : A9  ; < = > ? D l^^^hTTTRRR\RRRRHH>>>>>T>>>> @ @ T  ?     N ! B9: f><<   "7 Sheet13ggD ZO $%y  dMbP?_*+%PM&L&16&YUnified Application for Housing Production Programs&R&16&Yrevised - &D&?'?(?)?M \\HMF-PRT-002\HP600-MF-TC C odXXLetterDINU" 4 mR  SMTJ IUPH#xAkAZUDۺPF.)ěD ^ћE0M/LvfcQ3̛͛%i 縅Sܻ"i-^}Oj% "<4xycvx`X}P`>ÿh_8H A> Vk/}d+<_!i>*F(cl5 W\]ʸ:XI h5M2 TrDG!dW !aYcֹC ˆo{`ZtW#"Kz/Z;EA6s Lu D   Y [  -  D D D D   Y [ -  DDD D   {"Yssss Y [sss Y [s     LLL  Y [s D      Y []s     Y [s     Y [s     Y [s     Y [s     Y [;s     Y [<s     Y @Sss     Y yss5 '  DDD   Y Ass\ '  DDD         !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcefghijklmnopqrstuvwxyz{|}~ "Yss Y [s Y [c ' DDD    Y [ s ' #D D D    D5lz<P$Za}&:}}}}}}}}FZS!h"h#h$h%8&h'h(h)h*h+h,h-h.h/h0h182h3h4h5h6h7h8h9h:h;h<h=> ?D@h"!Y[s !!"Y "["s ""#Y ##M## 7% LD#%   B# '# $D#D#D#  # ##$Y $$M$$ 7%'<D$%'< B$ '$ ' D$D$D$  $ $$"%Yss %%&Y &[&s &&'Y '['s -' ( D'D'D' D'  ' ''(Y ([(s ( ) ( (- LLL ( (()Y )[)s ) * ( ) ))*Y *[* * + ( * **+Y +[+s + , ( + ++,Y ,[,s , - ( , ,,-Y -[-s - . ( - --.Y .[.s -. / D.D.D. D.  . ../Y /[/s '/ 0 D/D/D/  / //0Y 0[0s -0 3 D0D0D0 D0  0 00"1Yss 112Y 2[2s 223Y 3[3s -3 4 D3D3D3 D3  3 334Y 4[4s -4 5 D4D4D4 D4  4 445Y 5[5 -5 6 D5D5D5 D5  5 556Y 6[6s -6 9 D6D6D6 D6  6 667Y 7[7s -7 8 D7D7D7 D7  7 778Y 8[8s '8 >D8D8D8  8 889Y 9[9s '9 < D9D9D9  9 99:Y :[:s:6c D: : -: f D:D:D: D:  : ::;Y ;QD;s;6>D;; ;;<Y <[I<ss '< > D<D<D<  < <<=Y>Y >y >dc#>Y % =>#>: % <B>#> L % < B> #> L % < B> #> R % < B>>"?Yss ??@Y @nL@oD@p: .D@ D@ D>D  B@ '@ e D@D@D@  @ e @{D?lBZBV}}}}}FZ~ /BAhBhChDhEhFGHIJKhL MhNO PQRSTUVWXYZ[\ ]^_ `TAY AnMAo=Ap@ 'D  DAD  BABAlA,D  D {Gz? BAaa A A mL DAA{BY B[BsBCBBHLB B AB B A B BBCY C[CsCDBC C AC C A C CDY D[DsDEBD D AD D A D DEY E[EsEFBE E AE E A E FY F[ FFFGBF F AF F A"F F GY[ GbGGHBG G AG G A"G G HY[ HHHIBH H AH H A H |H{ IY[ I[IIJDII I AI I A I |I{ JY[ J[JJKDJJ J AJ J A J |J{ KY[ K[K?RKV DKK K AK  K SAK {LY Ly Ls#LL %>K?L#L> %>K.L#L B %>K BL #L d %>K L #L X %>K .L"MYssuuuuuu MNYsssuuuu N N uN P Z Y Z YES Z y Z yes Z YES Z Y Z y Z yes B%NOT APPLICABLE:B N NOYssssu O>Oc Z2 Ouuu OPYiii P P uPP T :DN NOT APPLICABLE  $L $L $N BB P QY Q5Quu Q{RYsssvv Rn R R PR ?A:DY DY DY B% dB R R{SY SSs SS SS SSu S{ TY`a TTab T T T $T X DP DR A T UY UU>74u U{VYgXYZv[ Vn V V ~ V ?V V ?cDV "WYu XY X X X $X ] DT DV AX $X ] DV DL AYY YNYYfiDY DY B%!D@D>D p= ף?$D@D>D {Gz?"BYuu YZY ZZZvZfL DA Zn Z Z u~ Z "@Z Z Mb?Z"[Y`aaaaauu [\Y \7\aaaa*\ODL%UZM\ \ \ u \]Y`aaaaa ] ] ] u$] _ DX DZ A] $] ZDX DZ A]^Y ^^aauuu _Y __au _ 6 _ u !_ e D] D] _ `Y ``aa `^`uuvu `(`CSD lyo0fFDw&0:{aT8bT cT0dTeTfT gT@hTiTjTkTlTmTnToTpqrstuvwxyz{|}~aY`aaaaa)aa TE bondsZLauuvv "bY`aaaaauuuuuu b{ c8caaaagc@QD_ D_ D` D` B%D\ D`D_Bcuc 7 pZ Y Z YES Z y Z yes B%Aggregate Basis TestCarryover TestBCarryover Testc mc N WDc Carryover Test B`"۹?ZLA#x&1?; >BAB c ZZ c{dggggu d Kd d h\Z Z B%ZZ LDYDZDFDGDHDIDJDKDD De ZB d iUd jkk{XeeBDc Dc DcD_ B% Funding GapBeggggYeCDe Funding Gap  DcD_  D_D` Beu e Xe Qe h;;DA0%'Z$jABB0 e ZZ e{f f f Xf A BZ Z B%%#ZBf  gg g  hh  ii  jj k  ll  m n o p qq rr ss s tt t uu u vv vw ww{ xx{y y{ zz{ {{{ ||{ } ~   D l[0d" """"                 """""""          (:  @ B8L 5L D-O De V  Z 3\ a c :c /c d  f  ><<J ^^UUZZWWXXYY 7 Sheet8ggD ZO $Q5IXi[\  dMbP?_*+%&?'?(?)?M \\HMF-PRT-002\HP600-MF-TC C odXXLetterDINU" 4 mR  SMTJ IUPH#xAkAZUDۺPF.)ěD ^ћE0M/LvfcQ3̛͛%i 縅Sܻ"i-^}Oj% "<4xycvx`X}P`>ÿh_8H A> Vk/}d+<_!i>*F(cl5 W\]ʸ:XI h5M2 TrDG!dW !aYcֹC ˆo{`ZtW#"Kz/Z;EA6s Lu8D D B%Z Z B          Z D    Z N8D D B%Z Z B  ]  ;Z N8D D B%Z Z B    Z N8D D B%Z Z B    Z N8D D B%Z Z B    Z N8D D B%Z Z B    Z N8D D B%Z Z B  [;  Z N8D D B%Z Z B  [<  Z N8D D B%Z Z B   @  Z N8D D B%Z Z B   z  Z N8D D B%Z Z B  ;%Z  : B Z N8D D B%Z Z B       Z N 8D D B%Z Z B 3      Z  N #8D  D  B%Z Z B D{l0mPPHdF000P! h" h# h$ h% 8& h' h( h) h* h+ h, h- h. h/ h0 h1 82 h3 h4 h5 h6 h7 h8 h9 h: h; h< h= >  ? D@h!      " ""      # #  #!##Z ##N#$8D# D# B%Z #Z #B #$ $  $!$$Z $$N$'8D$ D$ B%Z $Z $B $%  ""& && ""' ' ' ''Z ''N'(8D' D' B%Z 'Z 'B '( ( ( ((Z ((N()8D( D( B%Z (Z (B () ) ) ))Z ))N)*8D) D) B%Z )Z )B )* * * **Z **N*+8D* D* B%Z *Z *B *+ + + ++Z ++N+,8D+ D+ B%Z +Z +B +, , , ,,Z ,,N,-8D, D, B%Z ,Z ,B ,- - - --Z --N-.8D- D- B%Z -Z -B -. . . ..Z ..N./8D. D. B%Z .Z .B ./ / / //Z //N/08D/ D/ B%Z /Z /B /0 0 0 00Z 00N038D0 D0 B%Z 0Z 0B 01  2 22 3 3 3 33Z 33N348D3 D3 B%Z 3Z 3B 34 4 4 44Z 44N458D4 D4 B%Z 4Z 4B 45 5 5 55Z 55N568D5 D5 B%Z 5Z 5B 56 6 6 66Z 66N678D6 D6 B%Z 6Z 6B 67 7 7 77Z 77N788D7 D7 B%Z 7Z 7B 78 8 8 88Z 88N898D8 D8 B%Z 8Z 8B 89 9 9 99Z 99N9:8D9 D9 B%Z 9Z 9B 9: : : :<Z ::~ := :; ;D ; ;Z ;;~ ;= ;< <J;<<%Z < : <B< <<Z <<N<>8< D< B%Z <Z <B <=   > ># > #>$L % =B>#>$L % =B>%#>$L % =B?  @ @V @ @@Z @@N@Q8D@ D@ B%Z @Z @B @Dl000nnAhBhChDhEhFGHIJKLh MNv@ O P  Q  !R T U V W X Y Z [ \ ] ^ _ ` A AW A AAZ AANA8DA DA B%Z AZ AB AB B B BBZ BBBCDB BC C C CDZ CC C&AC C&AD D D DEZ DD D&AD D&AE E E EFZ EE E&AE E&AF F F FFGZ FF' F&AF' F&AF3 G G bGGHZ GG' G&AG' G&AG3 H H HHIZ HH' H&AH' H&A I IIIJZ II' I&AI' I&A J JJJKZ JJ' J&AJ' J&A K K[KKZ KKAZ KK' K&AK' K&AL L# L #L(> %>K.L)#L(N %>K.L)#L(@ %>K.M       N N*N      >N+(DL DLDLB Q#JQ,B4D@ D@ B%D@D@BQ-R        T        U        V        W        X        Y        Z        [        \        ]        ^        _        `        B8Xxxxxxxpfa b c d e f g h i j k l m n o p q a        b        c        d        e        f        g        h        i        j        k        l        m        n        o        p        q        &@   --  x   L  D % D; 1A K 7L cN ><F  7 Sheet7ggD ZO Kr  dMbP?_*+%PM&L&16&YUnified Application for Housing Production Programs&R&16&Yrevised - &D&'(?)?M\\HMF-PRT-003\RICOH_Multifamil  odXX10DRr xV˖6 Mdh]@$dqL,qz(ڢllf,<..u}0.uq9eizB+"Lrj )wu@.):00g5U5>JY:|Nܙo*lr:u^ @N$?#r R߶NCsOV&'ٗZ0a|~$|Tb"-ᄽw\Pdm2Ac7gr918@{⭰hT)&ؽٿm*g L,0iwI"õ[U<qFlyKH.䥣LYd1$ymmZO9 @_]"!RԞ+d)oțm4 /;Yk$=$ɬe$RfH6ZjrGb/ivk*\R:%E&sXxU5>d:,p\ -͏Ȗ{jL223337444444 ?22333@444444 A BCD EF G 44  H  IIJ K L M NOP Q 44R@3S ~ K L~ TA N~ O'@ P Q 44 U 9~ VugA S~ KA L~ T.A N~ O%@ P( W@ D D A 44UP3S ~ K = L~ TSA N~ O#@ P4 W@w@ D D D D A 44 X YH Z cA 2D  D  B%D % BfB S~ K-1 L~ TcA NL O(\µ? 6 ףp= ?ffffff?(\µ?Q?{Gz? P4 WPA D D D D A 44UP3S ~ KZb L~ T8lANOQ? P4W+A D D D D A 44  U P! V/AA D D  S~ K L~ TsANOx&? P4W,W3ADDDDA44UP3S ~ [ \ ]^_X9v? `4as8ADDDDA 44  X YH bQ?2D  D  B%D % BfB S 122333344UP3S 122333344  U P( V@A D D A S 122333344UP3S 122333344  X YH Z+A2D  D  B%D % BfB Scddee f344UP@S gh;33 i 344  j `! kt0A D D  lg;;33 i3444444 g 223m&+" !L L B%$B$Z  344  H  IeJ g 223m$Z 344n@@S g 223m$Z  344  U7 m" !D  D  B%$B$ o&D& S g 223m$Z 344UP9S g 223m$Z  344  X7 p !D  D  B%$B$H q 2D  D  B%D % BfB S g 223m$Z 344UPPS g9 223m$Z  344  U7 m" !D  D  B%$B$! r D D  S g: 223m $Z 344UPPS Dl0$9$$0$pZ$j$:y: .@ !.@".@#.@$.@ %.@&.@ '.@(.@).@ *+ ,0-./ 0.@01.@2.@3.@4.@ 5.@0678 90:;.@<.@=.@>.@?.@ g@ 23 m"$  Z  344 X YH t 2D  D  B%D % BfB7 u !D  D  B%%B% !gz!23m! Z !344UPPS "g"2~ "s"3"m$$""Z  "344 " U7" m& !D"  D"  B%$B$(" r D D A" S #g2233u344UPPS $v $wwx7$p( !D$ D$ B%$B$$y$Z  $344 $ X7$ p !D$  D$  B%$B$H$ q$ 2D  D  B%D % BfB$ S %g2233S344UP9S &z &{{|7&}$ !D& D& B%$B$#&~ %$B &344 & U7& m) !D&  D&  B%$B$!& & D" D$ & S '122333344UPPS (122333344U( U?D&  D&  B%Budgeted Contractor Profit & OHB( 4( 2Z ( S)122333344| a) }( KD(  D(  B%D( D&  Within Limit Exceeds LimitBB) l *1223333444444 +|3444444 , , -1223333444444 .>.223337444444 /12@33@444444 0A0BCDE~ 04@ 044 0 B 0 4CD 1qO1LNOP~ 14@ 144 1 CC 1 4BD 22LNOP.2?@D1D0D1D124444DD 33LNOP~ 3.@34444DD 4E4\]^_`~ 4 @44444DD 5FLNOGH44o5 5 Y@Z > Z > B%/Z @ Z >Z Z Z BC5 9 -D5  D5  B%% B% 5 ED 68;;9999449944 6::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: 7?7223333444444 8?223333444444 94 9 :1223333444444 ;>G;223337444444 <@3@@444444 =U = = = ==9444444 =:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::> >T>9444444 >::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ?9444444 ?:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::DlZ$:$$$$$0$\\jFF0$$0$@.@ A.@BCDEFGHIJ @/ @0@K@A5Z  ;  ZB @9]@444444 @::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: A8;;9999444444 A::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: B8223333444444 B::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: C1223333444444 C:::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::DDDEEEFFFGGGHHHIIIJJJ [ J- :f :  :8 :;! :7& :)& :6&  :8(  :>5 : @ :>@22  7 Sheet10ggD ZO :7  dMbP?_*+%8&?'?(?)?M \\HMF-PRT-002\HPCLJM651_MFC odXXLetter.DINU" :L SMTJ HP Color LaserJet M651 PCL 6InputBinFORMSOURCERESDLLUniresDLLHPDocUISUITrueESPRITSupportedTrueResolution600dpiFastResFalseHPPhysicalOrientationPO_PortraitOrientationPORTRAITHPOrientRotate180FalseDuplexNONEMediaTypeAUTOCollateONHPMediaTypeTreeviewPopupTrueColorMode24bppTextAsBlackFalseTTAsBitmapsSettingTTModeOutlineJPEGEnableAutoAlternateLetterHeadFalseHPPaperSizeALMConstraintsSTATEMENTHPEarlyWarmUpCommandEnablePrintQualityGroupPQGroup_2HPDocPropResourceDatahpchl155.cabHPColorSmartAutomaticHPColorSmart_ColorOptions_EdgeControlNormalHPColorSmart_Text_NeutralGraysBlackOnlyHPColorSmart_Text_HalftoneDetailHPColorSmart_Graphics_NeutralGraysBlackOnlyHPColorSmart_Graphics_HalftoneDetailHPColorSmart_Photo_NeutralGrays4-ColorHPColorSmart_Photo_HalftoneDetailHPColorModeCOLOR_MODEHPPDLTypePDL_PCL6HPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNT_COLORAUTHHPJobByJobOverrideJBJOHPJobAccWoPinTrueHPManualDuplexDialogItemsInstructionID_01_FACEDOWN-NOROTATEHPPCL6PassThroughTrueHPStaplingOpposedFalseHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPManualFeedOrientationFACEUPHPOutputBinOrientationFACEDOWNHPManualDuplexDialogModelModelessHPMapManualFeedToTray1TrueHPManualDuplexPageRotateDriverRotateHPPrintOnBothSidesManuallyFalseHPPrintInGrayScaleFalseHPNUseDiffFirstPageChoiceTRUEHPPageExceptionsFileHPCPE155HPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsCoverInsertionHPDuplicateJobNameOverrideSWFWHPPngPassthroughTruePSAlignmentFileHPCLS155HPConsumerCustomPaperTrueHPColorPlaneHPCPHPEnableRAWSpoolingTrueRGBColorDefault-sRGBJRConstraintsJRCHDPartialJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffHPEasyColorOnHPMHDLLNameHPFIE155HP_DIBStitch_TintTestDisabledHPSmartHubInet_SID_263_BID_514_HID_265HPSmartHub_OnlinediagnostictoolsTRUEHPSmartHub_SupportandtroubleshootingTRUEHPSmartHub_ProductmanualsTRUEHPSmartHub_CheckfordriverupdatesTRUEHPSmartHub_ColorprintingaccessusageTRUEHPCustomDUplexableRange3.00x5.00_8.5x14.0HPXMLFileUsedhpcm6516.xmlPSServices_DeviceandSuppliesStatusTRUEPSServicesOptionPSServicesDummyOptionPaperSizeLETTERIUPH"xMkA*B//00$$ 7 Sheet11ggD ZO @>p~  dMbP?_*+%8&?'?(?)?M \\HMF-PRT-002\HPCLJM651_MFC odXXLetter.DINU" :L SMTJ HP Color LaserJet M651 PCL 6InputBinFORMSOURCERESDLLUniresDLLHPDocUISUITrueESPRITSupportedTrueResolution600dpiFastResFalseHPPhysicalOrientationPO_PortraitOrientationPORTRAITHPOrientRotate180FalseDuplexNONEMediaTypeAUTOCollateONHPMediaTypeTreeviewPopupTrueColorMode24bppTextAsBlackFalseTTAsBitmapsSettingTTModeOutlineJPEGEnableAutoAlternateLetterHeadFalseHPPaperSizeALMConstraintsSTATEMENTHPEarlyWarmUpCommandEnablePrintQualityGroupPQGroup_2HPDocPropResourceDatahpchl155.cabHPColorSmartAutomaticHPColorSmart_ColorOptions_EdgeControlNormalHPColorSmart_Text_NeutralGraysBlackOnlyHPColorSmart_Text_HalftoneDetailHPColorSmart_Graphics_NeutralGraysBlackOnlyHPColorSmart_Graphics_HalftoneDetailHPColorSmart_Photo_NeutralGrays4-ColorHPColorSmart_Photo_HalftoneDetailHPColorModeCOLOR_MODEHPPDLTypePDL_PCL6HPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNT_COLORAUTHHPJobByJobOverrideJBJOHPJobAccWoPinTrueHPManualDuplexDialogItemsInstructionID_01_FACEDOWN-NOROTATEHPPCL6PassThroughTrueHPStaplingOpposedFalseHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPManualFeedOrientationFACEUPHPOutputBinOrientationFACEDOWNHPManualDuplexDialogModelModelessHPMapManualFeedToTray1TrueHPManualDuplexPageRotateDriverRotateHPPrintOnBothSidesManuallyFalseHPPrintInGrayScaleFalseHPNUseDiffFirstPageChoiceTRUEHPPageExceptionsFileHPCPE155HPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsCoverInsertionHPDuplicateJobNameOverrideSWFWHPPngPassthroughTruePSAlignmentFileHPCLS155HPConsumerCustomPaperTrueHPColorPlaneHPCPHPEnableRAWSpoolingTrueRGBColorDefault-sRGBJRConstraintsJRCHDPartialJRHDInstalledJRHDOffJRHDNotInstalledJRHDOffHPEasyColorOnHPMHDLLNameHPFIE155HP_DIBStitch_TintTestDisabledHPSmartHubInet_SID_263_BID_514_HID_265HPSmartHub_OnlinediagnostictoolsTRUEHPSmartHub_SupportandtroubleshootingTRUEHPSmartHub_ProductmanualsTRUEHPSmartHub_CheckfordriverupdatesTRUEHPSmartHub_ColorprintingaccessusageTRUEHPCustomDUplexableRange3.00x5.00_8.5x14.0HPXMLFileUsedhpcm6516.xmlPSServices_DeviceandSuppliesStatusTRUEPSServicesOptionPSServicesDummyOptionPaperSizeLETTERIUPH"xMkA*dt/`>M,E n΍M=A)=9Aqo3_kaHk چ& DjeQQdV{Rtڏ8FEMhׁ~XeM\y<WgCCa;yE6r_WWٷHx=Ji*]lx ۱t4Zp.5:yM;$[~vrl e\2Bm}du[nF+ە|,kYMT1O0V;/aL@ejS,ޫ,pvrK{}[?8}uz{ϻ^uE[    d%{<r";XX??&U} } }  } ] } ] } .} ] } . } } ] } . } 3. } 47. } 8@48484\4\4\4\4\48 48 48 48r8r8r8r8r8r8r8r8r8r8r8r8r8r8r\r\  c       ?        8Z         Z         Z         "                   >   3   ~ ? @    L @   @   @   @(  @    @   "@(  $@  &@(  (@%   *@(  ,@  .@( >   3   (Z9  Z9   Z9  % Z9   Z9  3Z9 2 Z9  Z9 / Z9 Z9 %Z9 3Z9 -Z9 %Z9 %Z9 > P:Z Z B%D ZB~ @      LLA          (     %     46z8q  P:Z Z B%D ZB~ @      LLA                   46z8q !P:Z Z B%D ZB~ @      LLA         #          46z8q P:Z Z B%D ZB~ @      LLA                   46z8q "P:Z Z B%D ZB~ @      LLA                   46z8q P:Z Z B%D ZB # # % $ #    - #      #  # # # # # # # # # #     46z8q #P:Z Z B%D ZB~ @      LLA                   46z8q $T>ZZ" D ZZ"B    ,  D Z A,  D Z A,  D Z A, D Z A,D Z A,DZ A,DZ A,DZ A,DZ A,DZ A,DZ A,DZ A,DZ A,DZ A 46z8q %T)>ZZ" D ZZ"B    ,  D Z A,  D Z A,  D Z A, D Z A,D Z A,DZ A,DZ A,DZ A,DZ A,DZ A,DZ A,DZ A,DZ A, DZ A 46z8q &P3 :Z Z B%D ZB~ @      LLA                   46z8q 'P#:Z Z B%D ZB~ @      LLA                   46z8q  P:Z Z B%D ZB~ @      LLA                   46z8q  P:Z Z B%D ZB~ @      LLA                   46z8q:N1D,*&hhj&:@$ r \!h"D!#D$D!%D&8'8(8)8*8+8,D!-D.8/8 08182838485868788898:D ;8<8=8>8?8  P  :Z Z B%D ZB~ @      LLA                                     (                                                                                                                                       4!                                                                                                                                      4"                                                                                                                                       #(P#:Z Z B%D# ZB ##  # ##  -#  # # (# # # # # # # ## # # ## #)# ## ## #)# #3# ## #                                                                                                                                      4$                                                                                                                                       %? %% 3 % %%  LL% 3 % % % % 3 % % 3 % %% % %3% % % %2% %7% %3% % % %3% %3% %3% %                                                                                                                                      &                                                                                                                                     '@'                                                                                                                                     () (o( ( YZ U Z U B%3Z U Z U Z UB; AB=( ( 'D Z U  :(  B=( 6'D Z U  :(  B=( ) 'D Z U  :(  B=(  'D Z U  :(  B=( 'D Z U  :(  B=()'D Z U  :( B=( 'D Z U  :( B=( 'D Z U  :( B=( 'D Z U  :( B=(2'D Z U  :( B=(2'D Z U  :( B=( 'D Z U  :( B=(3'D Z U  :( B=(('D Z U  :( B(                                                                                                                                       )*) )+ ) ) - ) +)) !L  , B) - ) ) - ) ) - ) )-) )-) )-) ) ) )-) )2 ) )2) )-) )-) )-) )                                                                                                                                      *                                                                                                                                     +,$+ +                                                                                                                                    4,                                                                                                                                       -- -- (- -- L-m- 2 - - 2 - - 7 - - ) - -2- -7- -/- -7- -2- -7- -/- -2- -7- -) - -                                                                                                                                      .                                                                                                                                     / ? /  E/ )/D-   N/AD- ?BN/A/ 7 / 9// /L  N/AL?BN/A/ 7 / N/A/ (/ N/A/ 7 / N/A/ / / N/A/  / N/A/  / N/A/  / N/A/ 8 / N/A/ )/ N/A/  / N/A/ 7/ N/A/ )/ N/A/ / / N/A/                                                                                                                                      0                                                                                                                                     1.1                                                                                                                                     2/2 - 2 U22 KL L L B%LLLBA2 72 2 )2 2 )2 2 32 27 2 2/2 2 2 2)2 2) 2 2 2 22 2 222 2/2 2/2 2                                                                                                                                     303  3 733 -L LLBA3 % 3 3 % 3 3 3 3  3 3%3 33 3%3 3%3 3%3 3/3 3%3 3-3 373 3%3 3                                                                                                                                    4                                                                                                                                     515                                                                                                                                     626C6 8-D6 D6 B%% B%%6  D6D8A6 6 6 66 D6LA6 8 6 6 6 6 6 8 6 686 666 686 686 686 686 686 686 686 686 6                                                                                                                                     737 8 7 ,77 "L  L B7 77 7 / 7 7 ( 7 7 /7 7/7 7 7 7-7 727 7/7 7 7 727 777 7 7 7/7 7                                                                                                                                     8468 D8 $ B86 Z H8 (8 / D8D6 D7 8 6 8 88 LLL8 8 8 8 6 8 8 68 888 868 868 868 868 868 868 868 868 88 8                                                                                                                                    9                                                                                                                                    :: :                                                                                                                                    ;; ;                                                                                                                                    <                                                                                                                                    =                                                                                                                                    >                                                                                                                                    ?                                                                                                                                    DOClu88r8 5+H8% J, q!F8        c   .   (    %   )   5   %   (   5   5   5      @  )  \     #   :#   #  #  4#  )# -# (# -# !%  %% )% (% 4% !( %( 4( 9) %) --  -  -/  ./ )/ 4/ 5/ N/ O2  2  .2  52 )2 .3  (3  6 7 %7 %7 .7 47 L8 $8 "8 &8 8 >F    7 Sheet12ggD PrintModule Sheet251ThisWorkbook*__SRP_2-  !"#$%&'()*+,./01234579:;<=>?@ABCDEFGIJKLMNOPQRSTUVWYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~j9hq ,B@.a1$4B@HCONTENTS$6B@HoH J!L9N n9P? (%V9T? (%V9X? (%V9Z? (%V9\? (%V9^? (%V9`9b9d9f j9hqh ,B@.a1$4B@HCONTENTS$6B@Ho  J!L9N R9P? (%V9T? (%V9X? (%V9Z? (%V9\? (%V9^? (%V9`79b9d9f j9hq@ ,B@.a1$4B@HCONTENTS$6B@Ho J!L9N n9P? (%V9T? (%V9X? (%V9Z? (%V9\? (%V9^? (%V9`9b9d9f j9hq ,B@.a1$4B@HCONTENTS$6B@Ho׳Attribute VB_Name = "PrintModule" Sub DSigPage(()  Application.GoTo Reference:="rangeh^SelecZOut Copies:=1,! llat:TrPue 0RC("C7").<@SheetsONTENTS TC ! End EligBasisLimi_@* ihpBreakdown˟_ba`F`Carryover+ [A1ÙJT0 ]A 0iN0`Percent#zc?zF262,  JOperInch2_2dzJyf2NOIJ)??C?y!*bRQC%#yprtEcWith Ave".SetLup .CgerHorizontally b8OrixlPortraitLeftMar8gin )V`Yhe sToPo`s(p0.25` B R8igh Top 5Botxtomp Header Foot҃?:ZoomFalstBFit sWid1NTPaESizApLegalQ#'!EssahN{n7`+1s+ ?+`S?+?+9=+LandsccrO+$ojO+O+#nO+O+$.5O+f O+/=`.O+{N+2O+O+rO+thu!c,s,,,rt2,iWBW;WWWIII,,o[ .,,B[,,,,,((0>.,,55!  .^,WqYWwWWT,*3*s *h*QV3O*O*s2O*O*VVVVn~._*_*ints(0.2 5) .TopMargin = Application.InchesToP o5 Bott om#r Header19Foot39ZoomFalDse}FitpagesWideB1Tall PaperSizxlLegalEnd WithSelecDPrOut Range("a1").hee"CONTENLTS  0Sub " 8Ph "   " 8Ph '#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0HHxAttribute VB_Name = "Sheet251"  Bas|0{00020820-; C$0046} |GlobalSpac False dCr@eatablPredeclaDIdTru BE xposeTemplateDeriv$Bust0omizD2H`x8/=q #</ 7C+qF @oEߣx @oEߣ/ 7C+qME P[LSS0|6"L<N0{00020819-xME &@  8  : <  >@  @  B  D  F@  H l p r@@@h @" (@X x " & "  0H` "    " 0H` " $ " 8Ph "   " 8Ph  "  0HPX`h p   "  (@Xpx      "   8Ph  "   (0H`x  ( 8  rangeSigPage* (B@P02 ,B@.C7$4B@Hnho CONTENTS TC$6B@Hh\o@rangeEligBasisLimits* (B@02 ,B@.C7$4B@H CONTENTS TC$6B@HorangeBreakdown* (B@02 ,B@.C7$4B@H CONTENTS TC$6B@HoxrangeCarryover* (B@02 ,B@.A1$4B@H CONTENTS TC$6B@Ho rangeTies* (B@02 ,B@.A1$4B@H CONTENTS TC$6B@Hox@rangePercentLimits* (B@02 ,B@.F26$4B@H CONTENTS TC$6B@Ho rangeOperInc* (B@02 ,B@.A1$4B@H CONTENTS TC$6B@HoprangeNOI* (B@02 ,B@.A1$4B@H CONTENTS TC$6B@HorangeRQC* (B@02 ,B@.A1$4B@H CONTENTS TC$6B@Hop@ J!L9N R9P? (%V9T? (%V9X? (%V9Z? (%V9\? (%V9^? (%V9`9b9d9f 0000-0000-C000-000000000046} x`tk@h)z `me %h%%v% zx %(@t hh@lh***\R1*#29a$*\Rffff*0^65cb676b*\R1*#1d*\R1*#12e4 "    (  ((~S\o`XAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2 PA Sub _WindowActiv (ByVal Wn As  )tpplication. St$= xlMaxi8ed End-6rU 0I  1 Y 74 a ` d, l x t! t t,( Vxt4XrU @,`hn__SRP_3 6xSheet10 8Sheet7HformPrintX '*#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0p&p&xAttribute VB_Name = "Sheet10" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2'X#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0PPxAttribute VB_Name = "She@et7" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2     *% !"#$5='()+L,./01234&6789:;<>A?@BECDFJGHIKPMNO_QSTUVWXYZ[\]^HLO SxME(SPSSS0{F54E2653-DA5D-4FBF-81D4-36CC202D10E3}{9A04753B-97F0-4C2D-88BD-7DF2B51E2C89}p @    @    @  % %@@@  xx8 "  "  (8"@ HX "` h x "  "  "       ( 8 H X "` h x "  "   "  "B@Fo`@ "B@& o@ "B@8o  "B@: o "B@@o`@ "B@>o@ "B@& "B@F "B@8 "B@: "B@< "B@> "B@@ "B@B "B@Do "B@<o "B@Bo`@ "B@Do@o0(ֱAttribute VB_Name = "formPrint" " Bas0{F54E2653-DA5D-4FBF-81D4-36CC202D10E3}{9A04753B-97F0-4C2D-88BD-7DF2B51E2C89} dGlobalSpaco False Cr@eatablPredeclaDIdTru BE`xpose0TemplateDerivCus tomizD  v Sub CommandButton10_Click()ntModule.RQC End"9"SigPagw$CFElig@|isLimits%*2pBlkdXownA6!93X'P@ercent&4јTied85XF^svNXILNCarryover3 LMOperInc NOI{6#\68$hJe7ǘ Ion8 UserF`H'#xME Sheet11Sheet13 PrintMenuYProcedures(SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0jjxAttribute VB_Name = "Sheet11" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2'+#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0LLxAttribute VB_Name = "Sheet13" Basx0{00020820- C$0046} |GlobaBlSpacFalse dCre atablPr@edeclaI"dTru BExposeTemplateDer iv$BustomizD2Lg FxME(SPSSS0{FA530003-1295-4EB9-B819-0F494F717E32}{4FB3FACB-4B23-4370-8E9F-2A180E663BFE}( @    @    @ % %@@@ @  M " ( 0 "8 @ "H Ph p "x   "(0HPpx  "  "  "  ( "08P X "` hxCASHFLOW* (B@as\A@loH@o8F10A* (B@_A@HoF10B* (B@A@poXF10A* (B@A@HF10B* (B@A@pF10C* (B@A@HF10D* (B@A@HF10E* (B@A@HCASHFLOW* (B@A@lSandU* (B@A@ro`@F10E* (B@A@Ho0F10D* (B@A@HoF10C* (B@A@HoSandU* (B@A@ro@oAttribute VB_Name = "PrintMenu" " Bas0{FA530003-1295-4EB9-B819-0F494F717E32}{4FB3FACB-4B23-4370-8E9F-2A180E663BFE} dGlobalSpaco False Cr@eatablPredeclaDIdTru BE`xpose0TemplateDerivCus tomizD  v Sub cmdPrtCashFlow_Click()Appation.GoTo Reference:="CASHFLOWprt1End(q2S_U/CommandBu tton1&$F10A#"2B2 /3Ro. ] CEC D]% E" NSzU3n6+6?+T + Non7? % &? AY8? % F7{? ! 9? " x-)-UserForm T[ xME@ S ##`s.@ x` @ `‪8o8o7 " L` Bx 0 \h x $       !#$%&'()*+,-./013456789:;<=>?@ACDEFGHIJKLMNPQRSTUVWXYZ[\]^`abcdefghijklmnopqrstvwxyz{|}~  4  0P  (hx0 8 "@ H h $x> 0  ]Ethis sub obtains a dsr value from the user and initaites optimization]Xp0Have you completed all of Forms 10A through 10E? $'* user dialogue to obtain a valid DSR input  6Enter a numeric value for the DSR (Debt Service Ratio)MORTGAGE CALCULATOR$' $b Are You canceling? $'  |8k0k(*You must enter a numeric value for the DSRA@ X' DSR J%4(freddie JB@! call to the optimizing procedureA@freddie JB@dH.You must complete all of Form 10 (A through E) (before a new mortgage can be calculated. A@ko optimizing procedure] Net_Operating J%4!'  ' Mortgage$4Agency_DebtServ$4B@ WKS_Mortgage$4B@H message to report output I have calculated a new mortgage  using a debt service ratio of   MORTGAGE CALCULATORA@o@8Attribute VB_Name = "Procedures" Dim dsr As Single Public Su@b C1()$'@this s"obtains anvalue from the user and iniLtes optimiz ationote mppng, ponse, @CancelIntegerzMsgBox("Have you completed all of Forms 10AroughE?", vbYesNofSdialog_8to jjhid DSRaputp IfP@# TheeEQr0: m= LD9z{*]D:AM:ҽ H rP% t O&#,]SlaQN-kA ro5 Excel+ VBAWin16~Win32Win64xMacVBA6#VBA7# VBAProjectstdole`OfficeuMSFormsC SOLVER PrintModule& _Evaluate (PrintSigPage ' Application* Referencee SelectionZPrintOut.Copies?CollateRange Sheets (PrintEligBasisLimits-,(printBreakdown.(PrintCarryover  (PrintTies(PrintPercentLimits= (PrintOperIncAZ(PrintNOI(PrintRQC(prtD ActiveSheet%N PageSetupCenterHorizontally Orientationw xlPortraitD LeftMargin]InchesToPointsI RightMargin[ TopMargini BottomMarginu HeaderMargin8 FooterMarginZoomFitToPagesWideFitToPagesTallZ PaperSize xlPaperLegal(prt1 xlLandscape&(prt2(prt3 Sheet251U$ ThisWorkbook|Workbook_WindowActivateWn_Window6 WindowState| xlMaximizedZp Sheet10 P Sheet7 formPrint_rCommandButton10_ClickbCommandButton9_ClickiCommandButton1_ClickCommandButton2_ClickCommandButton3_ClickFACommandButton4_ClickVyCommandButton5_ClickCommandButton6_ClickCommandButton7_Click0CommandButton8_ClickYxUserForm_Click Sheet11!P Sheet13#P PrintMenuPcmdPrtCashFlow_ClickQ:cmdPrtS_U_Click) Proceduresdsr;h C1\tempRresponseCancelMsgBoxRvbYesNovbYesa?EnterDSRInputBox  IsNumeric$*ValueK Unprotect?( C2\ProtectfvbCr$ vbCritical+}ADSsNOj^GoalSeekY'GoalI ChangingCell? vbExclamation Sheet16&P Sheet12"P Module1b Sheet8WorkbookkWindowActivatedt Worksheet)   #uw     !*p` ` S65cb676a Sheet7X`-formPrint0T65cb676aformPrintSx Sheet110U65cb676aSheet11-Sheet130V65cb676aSheet13+-PrintMenu0W65cb676aPrintMenuFm Proceduresa  ,*\G{000204EF-0000-0000-C000-000000000046}#4.2#9#C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL#Visual Basic For Applications&*\G{00020813-0000-0000-C000-000000000046}#1.9#0#C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXE#Microsoft Excel 16.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\SysWOW64\stdole2.tlb#OLE Automation4*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.8#0#C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\MSO.DLL#Microsoft Office 16.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\windows\SysWOW64\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{E79117B1-BC07-4C35-BFB9-B18F57AEFF89}#2.0#0#C:\Users\lshields\AppData\Local\Temp\Excel8.0\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M *\CU:\DOCUME~1\durban\LOCALS~1\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\LIBRARY\solver\SOLVER.XLA*\CU:\DOCUME~1\durban\LOCALS~1\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\LIBRARY\solver\SOLVER.XLA 3 OS  PrintModule0O65cb676a"PrintModuleSheet2510P65cb676auSheet251-ThisWorkbook0^65cb676bwThisWorkbookq 0Sheet100R65cb676aSheet10*H- Sheet70S65cb676a Sheet7X`-formPrint0T65cb676aformPrintSx Sheet110U65cb676aSheet11-Sheet130V65cb676aSheet13+-PrintMenu0W65cb676aPrintMenuFm Procedures0X65cb676aProcedures Sheet160Y65cb676aSheet165F-Sheet120Z65cb676aSheet12-Module10[65cb676aModule1t  Sheet80]65cb676a Sheet88-XH 08`xΨ{ I!xb EmޥUD\dZ 4Fԋeycy`O'}^Mr OS J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\SysW OW64\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files (x86)\Common \Microsoft Shared\OFFICE16\MSO.DLL#P 16 .0 Ob LibraryNMSFo@rms>SFrmHs3D452EE1-E08F1A-8-02608C4D0BB41wTFM20L'B @a&/;"1lrAr00}#:0r# 50 AE79117B1-BC07-4C35-BFB9-B18F57AEFF896Users\lshields\AppData\Local\Temp\Exce0l8.0@d8.e DocumentLibraryFormDocumentLibraryFormDocumentLibrarMsoDataStore)@1,@1,MWZS5OWCSLWO==2,*@1,@1,Item +RProperties 4ATJU51GO0XB==2-@1,@1,Item . Properties This value indicates the number of saves or revisions. The application is responsible for updating this value after each revision. yForm