|
<br />Attachment A: Sources and Uses
<br />
<br />E 14th and Estabrook SITE DATA
<br />Senior Apartments I
<br />Bond-51 Units 41,341 UrHl BulldlngArea 1.022.730 41,019 Slle Sq Fl 5,523 Perim1g
<br />CONCEPTUAL DEVELOPMENT PROFORMA Communlly/Chlld Care1ClrculmlOll 0.94 Tolel Acres o Open Space
<br /> 0 Nonb6SIS SquMe FoolagE! (Retail) 00 U/Acre 229 34% 8llsIs as % of 221 (d) (3) lImH
<br />13-Jul-Q7 o 00% Nonbasls % 100.00% Bas!s% 51 D U l8Clul.'ll YES 15 !t(:husled BasiS below the boosted cav7
<br />FUNDING SOURCES I Per Unit TOTAL A!I~um pUotllS AcqJPredev. CoMtrucllon PltfTTllM1l1nl Of" 01 Tol.l TERMS
<br />HUD C~lal Advance (202) 131,212 6,691.833 2,911.653 0 6,691,633 3595% G~I
<br />!Gap FIn1lnCIn-g 15,054 767,730 3679383 767,730 0 0 412% LOiffi - 5S yr defened 1000 @ 3% slm ple
<br />ICily Lellndro Developmenl Agency 4,ooD,000 2,0&4,096 1,915,904
<br />Conslructlon Flnan~ng 0 625%lnl 0 12,018,037 (12.018.037) 000% Construction Loan @ 6.25%ln\ 22 Months
<br />FHLB - AHP 255,000 255,000 0 137% lo~ 10ye&forgrvlJll@0%
<br />Alameda County Green Building Granl 35,000 35,000
<br />LlH Tax Credll.LP 134,471 6,85f1,035 350% 0 SO.OOO 6,808,035 36 84% Telx Credit umJled Parlner Capllal eonlrlbuhofl
<br />L1H Tax Credtl-GP 137 5.... .99 cents 0 5._ 004% Tal( Credit Gernlrel Parlner Capital Conlrlbutlon
<br />Permanenl FinenclJ'lfl 0 0 0 0 000%
<br />G8T1eml Pe.rtne:r ContrlbullOfl 0 0 000%
<br />TOTAL SOURCES 18,614,564 3,106,826 13,983,941 1,523,197 711.32%
<br /> Surplus/(Oeficit) In 0 0 101 0
<br />DEVELOPMENT BUDGET I TOTAL TIU Crlildl1
<br />LAND & IMPROVEMENTS TOTAL As.urn tlons Aco./Pr&dto..... Conslrue tlon Permen8flt COST 4~. Bnls eost/Unlt C~IISaFl "J. Total
<br />Site Acquisition 2,022,000 4929 per SF 2.022.000 0 0 2,022.000 0 39,154 7 4858 10,86%
<br />PermaTlent Reloc~t'on 0 0 0 0 0 0 0 000 0000/"
<br />Slle DemolJllQn SO,OOO SO,OOO 0 SO .000 SO 000 980 120 0,27%
<br />Envlro~nla1 Remel:ha.t,on 65,000 65,000 0 0 65,000 1.275 158 035%
<br />Slle Maffllenance (I e Security. Clean-Up) 5,000 aJlowl.'ll'\CB 5.000 0 0 5,000 5.000 98 012 0,03%
<br /> TOlaILe~ 2,1"2,000 2,1"2,000 0 0 2,142,000 55,000 42,000 51,47 11.51%
<br />CONSTRUCT ION CON SUL T ANT S'
<br />chllec( 721.000 788% 540,7SO 180,250 0 721,000 72\,000 14,137 17,32 3,87%
<br />Reserve lor Addlllonaj Landscapmg/Pwlng 92.000 92,000 92,000
<br />Cons lruclion Es lrme.tlnglM anageme nl SefVfCes 75.000 20.000 55.000 0 75,000 75,000 1.471 180 040%
<br />Englneefln-g Reports (I e Tapo, Acaus~cs. SOils Report) 25.000 25,000 0 0 25.000 25.000 490 000 0,13%
<br />Envlronmenlal 60.000 60,000 0 0 60,000 60,000 1.176 1.44 0.32%
<br />Tesllng & Inspecllcm SO.OOO 0 SO.ooo 0 SO,OOO SO,OOO 960 120 0_27.~
<br /> Tolal COn-liltr COnllllJI 1,023,OOD 645,750 285,250 92,000 1,D23,()tKI 931,000 20,059 12:17 5.00%
<br />CONSTRUCTION $23751
<br />Off-Site ImprO\iemants $ 300 0 0 0 0 0 0 000 000%
<br />On-Site ImprovemeTlts $ 2132 0 0 0 0 0 0 000 000%
<br />Relail 9,8B5,136 0 $12500 0 0 0 0 0 0 000 000%
<br />Uml Conslructlon 9..985,136 9.885,136 $ 237.39 0 9.885,136 0 9,885,136 9,885,136 193.826 237_51 5310%
<br />Other Construction. PlYklng 9,814.136 0 $ 1SO 00 0 0 0 0 0 0 000 000"10
<br />Solar PV 145,000 145,000 145,000 145,000
<br />JOlnl Trench Ulllity Cosls (NIC) 0 0 0 0 0 'i 000 o r;[l'-~{,
<br />Contractors Band 140% 0 0 0 0 0 0 000 000%
<br />PrfClng E~callltlon 494,257 5% 0 494,257 0 49-4.257 494.257 9,691 1188 2.66%
<br />Fumilure_ Ftxlures & Equlpmenl (common ilfea) 00.000 0 60,000 0 60,000 60,000 1,176 144 032%
<br />Conslruclion Conhr>gency SOl ,507 500% 0 501,S07 0 501.S07 501.507 9.633 12,05 269%
<br /> Tot.1 Constr 11,085,900 0 11,085,900 0 11,035,900 11,0115,900 217,371 262,lIfI 58.78%
<br />INDIRECT COSTS:
<br />Permits & Fees 948,268 17,000 94,827 853,441 0 948,266 948,268 1B,593 2278 509%
<br />Legal Fees 45.000 8,000 32,000 5,000 45,000 45,000 862 1,08 0.24%
<br />Audit Fees 20,000 0 0 20,000 20,000 0 392 048 0_11%
<br />Sponsor Admln'strllhon 975,000 975.000 SO.OOO 150,000 775,000 975.000 975,000 19.118 23.43 524%
<br />Sponsor/GP Conlrlbutl-On 2,321.681 0 0 0 0 0 0 000 000%
<br />Spons or Nll't Worth ReqUl remenl 55% 5% 0 0 0 0 0 0 0.00 000%
<br />Sponsor Operallng Guar<'lnte€ 2 monlhs of EGl 0 0 0 0 0 0 000 000%
<br />Appraisal 6,037 6,037 0 0 6.037 0 "8 015 003%
<br />Markel Sludy 15,000 15,OOQ 0 0 15,000 15,000 2'" 036 006%
<br />LeaSIng and Oth er Reservll's
<br />RentlUpMarkel'll9 30.600 000 0 30,600 0 30,600 0 600 074 016%
<br />Markel'ng & Bond Reserves 0 0 0 0 0 000 000%
<br />Inllial ServIces Rl!serve 125.000 1% 0 125.000 0 125,000 0 2,451 300 o 67"h.
<br />Parlnershlp Managemenl 375,000 375,000 375,000
<br />Investor Services Fee Reserve <172.500 52,500 52,SOO 52,500
<br />Issuer Annu~1 Fee Reservll 45,000 <15,000 45,000
<br />HUD Mel 10,000 10,000 10,000
<br />TCAC Oper~llnQ Reserve 83,967 0 0 83,967 83,967 0 l,&i16 202 045%
<br />Soft Costs Contingency 70,000 4% 35.000 35,000 0 70,000 70,000 1.373 168 038%
<br /> TotallndlrBCI Costs 2,1101,372 2011,864 1,221i,0.4' 1,366,467 2,fl01,372 2,053,268 54.929 55.72 12.40%
<br />FINANCE & CARRYING COSTS'
<br />Liabillly/COClnsur3'f1Ce 76,343 76,128 0 76,128 0 76,128 76,128 1A93 1_83 041"",
<br />Taxes 15.781,555 50,550 1_250% 0 5O,5SO 0 5O,5SO 50,550 991 1.21 027%
<br />Cvnstructoon LOM Pomts 157,816 90,135 075% 0 90_135 0 90,135 90,135 1,767 217 048%
<br />Perml'lOenl FinanCing Poinls 71,017 0 25% 0 0 0 0 0 0 000 000%
<br />Perm FIMlnclt1g Fees 0 0 0 0 0 0 0 000 0,00%
<br />Tille. Escrow 8. Olt~r FIf1~ng FM's 50.000 5,000 12,000 33,000 SO,OOO 50,000 980 1.20 027%
<br />Lender-Appra.saJ, Leglll & CoosuJllng (lnspecllOlls mel) 00000 B,OOO 52,000 0 60,000 60,000 1.176 144 032"10
<br />PredeveJopmenl LOllr1lnlerest 15,000 15.000 0 0 15,000 15,000 29< 0.36 OOB%
<br />ConstructIOn Loan IIller6s1 1,010,892 55% AOS 0 1,010,892 0 1,010.B92 1.010,892 19,821 2429 543%
<br />Costs of Issuance (Bonds) 90,045 0 90,045 0 90,045 0 1,766 2,16 048%
<br />Tol.1 Fin & Carry Callts 1,.442,751 28,000 1,381,751 33,000 1.4.42,75t 1,3!o2.705 1lI,289 ,4.6' 7.75%
<br />TAX CREOITS/SYND1CA lION EXPENSES:
<br />Tax CredllE:.lpenses
<br />TCAC Ap pllcahol1 Fee 2,000 2,000 0 0 2,000 0 39 0,05 0_01%
<br />TCAC Alloc~lion Fee 7.042 1% 7.042 0 0 7,042 0 138 0,17 004%
<br />TCAC PEl r1orm.!l"lCe Deposll 28,170 4% 26,170 0 0 28,170 0 552 068 015%
<br />TCAC Mo I1ltonng File 20.600 410 0 0 20.500 20,500 0 402 0.49 o 11'Y"
<br />TCAC Deposit Refund (28_170) 0 0 (28.170) (2B, 170) 0 (552) {0_6B} (0_00)
<br />Syndication Con SUIlLVII SO.OOO 10,000 5,000 35.000 SO,OOO 0 980 12Q 0_27"10
<br />Syndlcahon Legal Fees -'10,000 35.000 0 5,000 40,000 0 784 0.98 021%
<br />Syndicahon.lnveslor Leglll 0 0 0 0 0 0 0 000 000%
<br />SyndIcation Olhr;>r- Bridge Loan Fees 0 0 0 0 0 0 0 000 0,00%
<br />Syndication Olher Bridge LoanlDev Fee Inlerest 0 0 0 0 0 0 0 000 0,00%
<br /> Tolal TCAClSynd 119,542 112,212 5.000 '2.>30 119,542 0 2.'44 2.87 0,&4%
<br />TOTAL DEVELOPMENT EXPENSES I 18 614,56.4 3,106,826 13,983,941 1523,197 18,6U,564 15,.4n,873 364.991 429.96 96.13%
<br />
|