Loading...
HomeMy WebLinkAboutR-94-0536J-94-619 7/14/94 RESOLUTION NO. 9 4 5 3 6 A RESOLUTION AUTHORIZING A LOAN/GRANT, IN AN AMOUNT NOT TO EXCEED $600,000, FROM THE FY 1994 HOME INVESTMENT PARTNERSHIP PROGRAM TO THE EAST LITTLE HAVANA COMMUNITY DEVELOPMENT CORPORATION, FOR THE PURPOSE OF DEVELOPING CASA GRANDE, A 104-UNIT RENTAL HOUSING PROJECT FOR THE ELDERLY, PLANNED FOR DEVELOPMENT ON SIX (6) VACANT PARCELS LOCATED AT SOUTHWEST 9TH AVENUE AND SOUTHWEST 8TH STREET, IN THE LITTLE HAVANA NEIGHBORHOOD; AUTHORIZING THE CITY ATTORNEY TO EXECUTE THE NECESSARY DOCUMENTS, IN A FORM ACCEPTABLE TO THE CITY ATTORNEY, TO IMPLEMENT SAID LOAN/GRANT. WHEREAS, a severe shortage of affordable housing exists in the City of Miami that is within the financial range of families and individuals of low and moderate income; and WHEREAS, the City Commission recognizes that participation of both the public and private sector is necessary to foster the development of affordable housing for low and moderate income families and individuals; and WHEREAS, the East Little Havana Community Development Corporation proposes to develop Casa Grande, a 104-unit rental housing project for the elderly (Project), to be situated on six (6) vacant parcels of land located at SW 8th Street and SW 9th Avenue in the Little Havana neighborhood; and Jill, i 1� j.P14 Resolution No, 94- 536 I WHEREAS, to expedite the construction of the proposed Project, it is necessary for the Project sponsor to secure $600,000 in financial assistant from the City of Miami.; and WHEREAS, funding, in the amount of $600,000, is available from the City's FY 1994 Home Investment Partnership Program; NOW, THEREFORE, BE IT RESOLVED BY THE COMMISSION OF THE CITY OF MIAMI, FLORIDA: Section 1. The recitals and findings contained in the Preamble to this Resolution are hereby adopted by reference thereto and incorporated herein as if fully set forth in this Section. Section 2. A loan/grant, in an amount not to exceed $600,000, from FY 1994 Home Investment Partnership Program to the East Little Havana Community Development Corporation, for the purpose of developing Casa Grande, a 104-unit rental housing project for the elderly planned for development on six (6) vacant parcels located at Southwest 8th Street and Southwest 9th Avenue in the Little Havana neighborhood, is hereby approved. Section 3. The City Manager is hereby authorized/ to execute the necessary documents, in a form acceptable to the City Attorney, to implement said loan/grant Section 4. This Resolution shall become effective immediately upon its adoption. The herein authorization is further subject to compliance with all requirements that may be imposed by the City Attorney, including but not limited to those prescribed by applicable City Charter and Code provisions. 94- 536 PASSED AND ADOPTED this 4 h day of July 1994. S EPHEN P. CL RK, MAYOR i AT S MAXTY HIRAI CITY CLERK PREPARED AND APPROVED BY: LT D KELLY KEARSON ASSISTANT CITY ATTORNEY APPROVED AS TO FORM AND CORRECTNESS: i6/ A. QUIfiN CT III CITY ATTO LKK:osk:M4495 94- 5:w k -3- CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM To Wifredo Gort DATE July 14, 1994 FILE Commissioner SUBJECT : CASA GRANDE APARTMENTS FROM : Cesa Odico REFERENCES : East Little Havana CDC Cit anager ENCLOSURES. 4 The East Little Havana Community Development Corporation is currently proposing to develop a 104-unit, elderly rental housing project planned at Southwest 8th Street and Southwest 9th Avenue. The proposed Casa Grande Apartmerts will consist of forty-eight (49) efficiency units, fifty-five (55) one -bedrooms and one (1) two -bedroom units. 1 In order for the East Little Havana Community Development Corporation to complete its application for Low -Income Housing `Tax Credits from the State of Florida for both construction and permanent financing for the proposed housing project, it is necessary that the Corporation secure $600,000 in City financial assistance. The subject funding is available from the City's 1994 Home Investment Partnership Program. This memorandum serves to transmit the attached resolution which would authorize making available $600,000 to the East Little Havana CDC in connection with the development of the proposed Casa Grande Apartment project. Attachment: Resolution 1 f cc: Mayor Clark Vice Mayor Dawkins Commissioner De Yurre Commissioner Plummer I i i i I I I I t i i 94- 536 CASA GRANDE RESIDENTIAL APARTMENTS LOW INCOME ELDERLY HOUSING DEVELOPMENT CASA GRANDE (Formerly Rio Grande) JULY 11, 1994 KEY ASSUMPTIONS: 1ST MORTG.LOAN RATE 9.00% 1ST MORTG.LOAN TERM 30 VACANCY RATE .50% OPERATING INCOME INCREASES 3.00% OPERATING EXPENSES INCREASES 5.00% OPERATING EXPENSES PER UNIT PER YR.(STATE) $2,600 SYNDICATION RATE (CENTS PER DOLLAR) $.50 i NUMBER OF UNITS 104 JULY 11, 1994 Ttl sq.ft. No. UNITS Units of Type #A, Effic. & 1 bath 420 48 Units of Type #B, 1-Bdr & 1 bath 550 55 Units of Type #C, 2-Bdr & 1 bath 630 1 TOTAL NET LIVING SQ.FT. CONSTRUCTION 51040 104 TOTAL GROSS SQ.F1. CONSTRUCTION $61.32 59500 Incl.one rec room & two courtyard decks Estimated (lard Cost per NET LIVING SQ.FT $71.49 3,648,608 Estimated Hard Cost per GROSS SQ.FT $61.32. 3,648,608 39% 61% TOTAL Type#A Type#B&C PROJECT ACQUISITION & CONSTRUCTION COSTS 48 56 Subtotal COSTS Acquisition Fee $49 $65 $6,000 $6,000 Acquisition: Land $6,172 $8,103 $750,000 $750,000 Buitding $0 $0 $0 $0 Site Improvements $0 $0 $0 $0 ConSLr.Concrete tests and initial soil tes $81 $106 $9,850 $9,850 Basic Construction $30,024 $39,419 $3,648,608 $3,648,608 Contingency 7% $2,102 $2,759 $255,403 $255,403 OTHER $0 $0 $0 $0 Architect Design and Civil Eng. $864 $1,134 $105,000 $105,000 Cost analysis and inspections/eng $232 $305 $2.8,200 $28,200 Architect construction supervision $2.06 $270 $25,000 $25,000 Constr. Permits & Fees $247 $324 $30,000 $30,000 Real Estate Taxes Construction Period $199 $261 $24,136 $24,136 Insurance Construction Period $165 $216 $20,000 $20,000 Permits Water/Sewer and FPL $568 $745 $69,000 $69,000 SOFT COST CONTINGENCY 10% OF APPLC.COSTS. $959 $1,259 $116,528 $116,528 Financing and Loan Fees $258 $339 $31,367 $31,367 Title & Recording & Credit Report $329 $432 $40,000 $40,000 Appraisal/survey $81 $106 $9,856 $9,856_ Environmental/soil tests $177 $233 $21,550 $21,550 - FHFA ADM & APPL FEES $359 $471 $43,604 $43,604 Accounting/Post Const.Audit./Cost. Cert. $99 $130 $12,000 $12,000 Legal:Transaction $356 $468 $43,300 $43,300 :Organization $82 $108 $10,000 $10,000 :Syndication $58 $76 $7,000 $7,000 other $0 $0 $0 $0 Rent analysis/Market Study $16 $22 $2,000 $2,000 INTEREST ON CONSTR.LOANS $1,511 $1,984 $183,615 $183,615 Initial Op/rent-up Reserve $0 $0 $0 $0 Rent -Lease up Reserve $0 $0 $0 $0 FHFA Tax Credit Allocation Fee $41 $54 $5,000 $5,000 INTEREST ON BRIDGE LOAN $1,539 $2,021 $187,077 $187,077 Developer Fee** $3,042 $3,994 $369,690 $369,690 Administration*" $2,202 $2,891 $267,574 $267,574 Impact fees $706 $927 $85,837 $85,837 TOTAL DEVELOPMENT COSTS $52,724 $69,222 $6,407,195 $6,407,195 $6,407,195 Yearly ANNUAL FINANCING Amount _ Int. Rates Terms P"MENT _ County CDDG & LISC grants (Acqui 3n) $19,650 .00% $0 CITY & COUNTY Refund on Impact fees $85,837 .00% $0 City of Miami grant $300,000 .00% .0 $0 City of Miami loan $300,000 2.50% 20 $19,077 GP Capital and Equity ($5,314) .00% .0 $0 State of Fla. $500,000 3.00% 15 $41,435 Homes For S.FIa. 1st Mortgage $1,600,000 9.00% 30 $154,488 OTHER $0 .00% .0 #VALUE! LP CAPITAL Limited Partner Capital PAY --INS $3,237,331 .00% .0 TOTAL PROJECT FINANCING AVAILABLE $6,037,501, Deferred GP fees/loans & GP Capital $369,690 3.00% 40 $15,881 LP CAPITAL TOTAL PROJECT FINANCING AVAILABLE $6,407,195 Limited Partner Capital PAY -INS $3,237,331 50.00%OF TOTAL TAX CREDITS ALLOCATION TAX CREDIT ALLOCATION OVER 10 YEARS $6,474,662 HFSF Bridge $0 7.00% 7 $0 JULY 11, 1994 T...aL Total Units 104 TOTAL NET LIVING SQ.FT. CONSTRUCTION 51040 TOTAL GROSS SQ.FT. CONSTRUCTION 59500 $71 ( NON ( DEPRECIABLE BASIS DEVELOPHUNI COSTS TOTAL COST PER UNIEIDEPRC'BLE IRESIDNT'L NON-RES. (AMORTIZED EXPENSED I Acquisition Fee $6,000 $58 ( $6,000 $0 $0 $0 $0 Acquisition: Land $750,000 $7,212 ( $750,000 $0 $0 $0 $0 Building $0 $0 ( $0 $0 $0 $0 $0 Site Improvements $0 $0 ( $0 $0 $0 $0 $0 Constr.Concrete tests and initial soil tes $9,850 $95 ( $0 $9,850 $0 $0 $D Basic Construction $3,648,608 $35,083 ( $0 $3,648,608 $0 $0 $0 Contingency 7% $255,403 $2,456 ( $0 $255,403 $0 $0 $0 OTHER $0 $0 ( $0 $0 $0 $0 $0 Architect Design and Civil Eng. $105,000 $1,010 ( $0 $105,000 $0 $0 $0 Cost analysis and inspections/eng $28,200 $271 ( $0 $28,200 $0 $0 $0 Architect construction supervision $25,000 $240 ( $0 $25,000 $0 $0 $0 Constr. Permits & Fees $30,000 $288 ( $0 $30,000 $0 $0 $0 Real Estate Taxes Construction Period $24,136 $232 ( $0 $24,136 $0 $0 $0 Insurance Construction Period $20,000 $192 ( $0 $20,000 $0 $0 $0 Permits Water/Sewer and FPL $69,000 $663 ( $0 $69,000 $0 $0 $0 SOFT COST CONTINGENCY 10% OF APPLC.COSTS. $116,528 $1,120 ( $0 $116,528 $0 $0 $0 Financing and Loan Fees $31,367 $302 ( $0 $0 $0 $31,367 $0 (_ Title & Recording & Credit Report $40,000 $385 ( $0 $40,000 $0 $0 $0 Appraisal/survey $9,856 $95 ( $0 $9,856 $0 $0 $0 Environmental/soil tests $21,550 $207 ( $0 $21,550 $0 $0 $0 FHFA ADM & APPL FEES $43,604 $419 ( $0 $0 $0 $0 $43,604 Accounting/Post Const.Audit/Cost. Cert. $12,000 $115 $0 $12,000 $0 $0 $0 Legal:Transaction $43,300 $416 ( $3,000 $40,300 $0 $0 $0 ,( :Organization $10,000 $96 ( $0 $0 $0 $10,000 $0 :Syndication $7,000 $67 ( $7,000 $0 $0 $0 $0 other $0 $0 ( $0 $0 $0 $0 $0 Rent analysis/Market Study $2,000 $19 ( $0 $2,000 $0 $0 $0 INTEREST ON CONSIR.LOANS $183,615 $1,766 ( $0 $183,615 $0 $0 $0 Initial Op/rent-up Reserve $0 $0 ( $0 $0 $0 $0 $0 Rent -Lease up Reserve $0 $0 ( $0 $0 $0 $0 $0 FHFA Tax Credit Allocation Fee $5,000 $48 ( $0 $0 $0 $5,000 $O INTEREST ON BRIDGE LOAN $187,077 $1,799 ( $0 $0 $0 $0 $187,077 Developer Fee** $369,690 $3,555 ( $0 $369,690 $0 $0 $0 Administration** $267,574 $2,573 ( $0 $267,574 $0 $0 $0 Impact fees $85,837 $825 ( $0 - $85,837 $0 $0 $0 TOTAL DEVELOPMENT CASTS $6,407,195 $61,608 $766,000 $5,364,146 $0 $46` 67 $730,681 TOTAL NON -BASIS EXPENSES$1,043,048 "Housing Finance Agency limits Developer Fee & Overhead to 20% of Total Devetopment Costs Less Land Costs: Maximum Developer Fee Allowable: $5,281,504 20.00% $1,056,301 20.00% of Total Dev.costs Proposed Developer Fee____ $5,281,504 7,0071 $3G9,705 INTEREST ANORT PURR NEWT FINANCING TOTAL % OF TDC1 LOANS/CM FINANCING GRANTS ( RATE TERM I County CDBG & LISC grants (Acquisition) $19,650 .31%(NON -FEDERAL FEDERAL $19,650 ( .00% CITY & COUNTY Refund on Impact fees $85,837 1.34%( $0 $85,837 ( .00% City of Miami grant $300,000 4.68%1 $0 $0 $300,000 ( .00% City of Miami loan $300,000 4.68%1 $0 $300,000 ( 2.50% GP Capital and Equity ( 5 314) -.08%1 ($5,314) $0 $0 ( .00% State of Fla. $500,000 7.80%1 $0 $500,000 ( 3.00% Homes For S.Fta. 1st Mortgage $1,600,000 24.97%1$1,600,000 ( 9.00% OTHER $0 .00%1 $0 ( .00% Limited Partner Capital PAY -INS $3,237,331 50.53%1$3,237,331 ( .00% TOTAL PROJECT FINANCING AVAILABLE $6,037,504 94.23% 832 017 $800,000 $40;,487 1 Deferred GP fees/loans & GP Capital $369,690 5,77%1 $369,690 TOTAL NON -BASIS SLX CES1 TOTAL PROJECT FINANCING AVAILABLE $6,407,195 100.00% $5,201,708 $1,205,487 9 4 _ 536 JULY 11. 1994 Total Units TOTAL NET LIVING SO.FT. CONSTRUCTION TOTAL GROSS SO FT. CONSTRUCTION I PAID DURING CONSTR. CONSTR.- NON- I DEVELOPMENT COSTS COMMENTS I RELATED CONSTR.I Acquisition Fee Seller's option agreement extension fee. I I Acquisition: Land Building I I Site Improvements I I Constr.Concrete tests and initial soil test I I Basic Construction I I Contingency 7% I I OTHER Assumed $1K per unit, subtracted from Contt Cost ( I Architect Design and Civil Eng. Cost analysis and inspections/eng I" Architect construction supervision Constr. Permits & Fees Real Estate Taxes Construction Period Insurance Construction Period Permits Water/Sewer and FPL SOFT COST CONTINGENCY 10% OF APPLC.COSTS. Financing and Loan Fees 2% I �. Title & Recording & Credit Report Appraisal/survey Environmental/soil tests I I FHFA ADM & APPL FEES I I Accounting/Post Const.Audit/Cost. Cert. Expensed at placement in service. I I Legal:Transaction $5,000 Land acquisition and balance over avg. loan term :Organization :Syndication other I I Rent analysis/Market Study Mkt study prepared during pre-dev stage I I INTEREST ON CONSTR.LOANS Project Reserves: Half of 1st full yr's required debt sery +I I Initial Op/rent-up Reserve operating expense at minimum. I Rent -Lease up Reserve - FHFA Tax Credit Allocation Fee $350 per unit due at PIS certification OR maximum $5,000 I I INTEREST ON BRIDGE LOAN Expensed at partnership formation. I I Developer Fee** ( I Administration** I I Impact fees I TOTAL DEVELOPMENT COSTS 0 * 0 "*Housing Finance Agency limits Developer Fee & Overhead to 20% of Total Development Costs less Land Costs: Maximum Developer Fee Allowable: Percent of Construction Period Bridge Interest Capitalized: 97.02% Proposed Developer Fee PERMANENT FINANCING County CDBG & LISC grants (Acquisition) CITY & COUNTY Refund on Impact fees City of Miami grant City of Miami loan GP Capital and Equity State of Fla. Homes For S.Fla. 1st Mortgage OTHER Limited Partner Capital PAY -INS TOTAL PROJECT FINANCING AVAILABLE Deferred GP fees/loans & GP Capital _ TOTAL PROJECT FINANCING AVAILABLE JULY 11, 1994 TAX CREDIT CALCULATION FEDERAL LIHTC DESCRIPTION: TOTAL ACQUISITION CONSTRUCTION DEVELOPMENT COSTS $6,407,195 $756,000 $5,651,195 PLUS: Capizd Bridge Int (constr.period only) $169,960 $0 $169,960 LESS: Non -Depreciable ($766,000) ($756,000) ($10,000) Amortized ($46,367) $0 ($46,367) Expensed (Inct. ttl bridge loan int) ($230,681) $0 ($230,681) Non -Residential Depreciable Basis $0 $0 $0 Res. Portion of Historic Rehab Credit $0 $0 $0 Disallowed Acq. Basis' $0 $0 $0 Subtotal $5,534,106 $0 $5,534,106 LESS: Federal Financing and _grants in excess $0 $0 $0 of non -basis expenses(amortzd,expnsd,& IL $0 non -depreciable) ELIGIBLE LIHTC BASIS $5,534,106 $0 $5,534,106 ADJUSTMENT: For Hard -to -Develop Area or 130% 130% Qualified Census Tract (if app) ADJUSTED ELIGIBLE LIHTC BASIS $7,194,338 $o $7,194,338 APPLICABLE FRACTION 100% 100% 100% $7,194,338 $0 $7,194,338 ' QUALIFIED LIHTC BASIS LIHTC RATE: Locked -in 9.00% 4.00% 9.00% ANNUAL LIHTC AMOUNT CALCULATED: $61,T,490 $0 $64T,490 ACTUAL ALLOCATION: - USED IN FORECAST (Lesser): $64T,490 $0 $64T,490 TOTAL VALUE OF TAX CREDIT OVER 10 YEARS $6,4T4,901. - SYNDICATED TOTAL VALUE OF TAX CREDIT OVER 10 Y $3,237,452 a .50 NUMBER TOTAL APPLICABLE FRACTION OF FRACTION SQ. FEET FRACTION Low Income Apartments 100% Market Rate Apartments ------------------------------------------- 0% TOTAL 100% APPLICABLE FRACTION (Lesser of #Units or Sq) 100% STATE LIMITED PARTNER SYNDICATED TAX CREDITS CALCULATION SYNDICATED TOTAL VALUE OF TAX CREDIT OVER 10 Y $647,490 10 YEAR LIFE $6,474,904 SYNDICATION RATE (CENTS PER DOLLAR) 50.00% SYNDICATION LP CAPITAL $3,237,452 94- 536 JULY 11, 1994 PROJECT PARTNERSIIIP PROJECT EQUITY BRIDGE LOAN (if any) RIO GRANDE. ©ridge Loan for Project? (Y/N) Y 900 S.IJ. 8 STREET NON-- Annual Interest Rate 7.00% MIAMI, FLA. SALE PROFIT GP -BASIS Disbursement Date 12/94-12/95 PROFIT/LOSS PROCEEDS GP? DEPR. General Partner Share 1% 50% Y 27.50 Limited Partner(s) Share 99% 50% years LOW INCOME IISG. TAX CREDITS CREDIT YEAR FEDERAL LIHTC 1993 Acquisition Credit Rate 3.00% PARTNERSHIP EVFTiT SCHEDULE Construction Credit Rate (May Rate) 9.00% NEF Admission to Partnership December 1994 Total Allocation 130% NEF Funding December 1994 100% or 130% Eligible Census Tract #53.02 Property Sale/Partnership TerrnDecember 1013 Credit Rate Locked -In? (Y/N) Y Partnership Life 18 years DEVELOPMENT SCHEDULE TOTAL BLDG #A Number of Units 84 84 GENERAL TERMS Percent of total basis 100.00% 100.00% Start of Construction* December 1994 December 1994 Applicable Fed. Rate (AFR) CompletioniCertificate of OccuDecember 1995 December 1995 Corporate Tax Rate -Federal 34.00% Start of Leasing"* October 1995 October 1995 _ Start Lease-Up/Qualified OccupDecember 1995 December 1995 Complete Lease-Up/Qualified OcMarrh 1996 March 1996 PROJECT DESCRIPTION Leasing Period (Months) 3 months 3 months % LIHTC-Eligible Units 100.00% Overall Constr./Leaseup Period15 months 15 months 81' Apts for families in 1 bldgs--all new construction. Also a community room will ,be built. Minimum Set -aside election is i 100% of units restricted to 60% or less of medi j *Construction contract written with this phased schedule. $200/day liquidated damages clause. _ i i i I **ELHCDC has prior leasing experience in this neighborhood at comparable rents and finds that 4 months is reasonable. 94- 536 DULY 11, 1994 6 USES OF FUNDS BUDGET MONTHS MO, MONT112 MONTHS MONTH4 MONTH5 MONTH6 MONTH 7 MONTH 8 MONTH 9 Acquisition Fee $6,000 $6,000 $0 $0 $C Acquisition: Lan $750,000 $750,000 Bui $0 Site Improvement $0 $0 Cons tr.Concret(, $9,850 $821 $821 $821 $821 $821 $821 $821 $821 $821 Basic COnStructi$3,648,608 $200,000 $160,000 $100,000 $100,000 $115,000 $115,000 $200,000 $300,000 $300,000 $300,OOC Contingency 7 $255,403 $8,000 $6,400 $4,000 $4,000 $4,600 $4,600 $8,000 $12,000 $12,000 $12,000 OTHER $() Architect Design $105,000 $)05,000 Cost analysis an $28,200 $5,000 $1,933 $1,933 $1,933 $1,933 $1,933 $1,933 $1,933 $1,933 $1,933 Architect constr 1,?5,000 $0 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,50C Constr. Permits 1130,000 $30,000 Real Estate Taxe $24,136 Insurance Constr 1,20,000 $20,000 $0 $0 $0 $C Permits Slater/Se $69,000 $50,000 $30,000 $4,000 $500 $500 $500 $500 $500 $500 $2,OOC SOFT COST COW IN $116,528 $9,711 $9,711 $9,711 $9,711 $9,7il $9,711 $9,711 $9,711 $9,711 $9,711 Financing and Lo $31,367 $31,367 $0 $0 $( Title & Recordin $40,000 $40,000 $0 $0 $( Appraisal/survey $9,856 $9,856 Environmental/so $21,550 $0 $21,550 $C FHFA ADM & APPL $43,604 $43,604 $0 $0 $( Accounting/Post $12,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $( LegaL:Transactio $43,300 $4,000 $26,000 $13,300 _ $( :Organizati $10,000 $10,000 $( :Syndicatio $7,000 $7,000 $0 $( other $0 $0 $0 $C Rent analysis/Ma $2,000 $0 $2,000 $0 $( INTEREST ON CONS $183,615 $0 $15 146 $4 658 $5 615 $6,553 $7,616 $8,686 $10,688 $13,224 _ 13 383 Initial Op/rent- $0 $0 $0 $0 Rent -Lease up Re $0 $0 $0 $0 $( FHFA Tax Credit $5,000 $5,000 $0 $0 - $( INTEREST ON BRID $187,077 $0 $0 $( Developer Fee*" $369,690 Administration" $2.67,574 Impact fees $85,837 $85,837 $0 $0 $( TOTAL USES $6,407,195 $1,370,375 $284,511_ $127 623 $125,080 $141,618 -$142,680 $267,000 $338,153 $340,689 $342,34-,, SOURCES OF FUNDS Amount County CUBG & LI $19,650 $19,650 $0 $0 $0 $0 $0 $0 $0 $0 $( CITY & COUNTY Re $85,837 $85,837 $0 $0 $0 $0 $0 $0 $0 $0 $( City of Miami gr $300,000 $300,000 $0 $0 $0 $0 $0 $0 $0 $0 $( City of Miami to $300,000 $300,000 $0 $0 $0 $0 $0 $0 $0 $0 $( GP Capital and E ($5,314) ($5,314) $0 $0 $0 $0 $0 $0 $0 $0 $( State of Fla. $500,000 $500,000 $0 $0 $0 $0 $0 $0 $0 $0 $( Homes For S.FLa.$1,600,000 $170,201 $284,511 $127,623 $125,080 $141,618 $142,680 $267,000 $338,153 $3,134 $( OTHER $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $( Limited Partner $3,237,331 $0 $0 $0 $0 $0 $0 $0 $0 $337,555 1342,34'� TOTAL SOURCES $6,037,504 $1,370,375 $284,511 $127,623 $125,080 $141,618 $142,680 $26T,000 $338,153 $340,689 $342,34� CUMULATIVE STATU Rates County CDBG & LI .00% $19,650 $19,650 $19,650 $19,650 $19,650 $19,650 $19,650 $19,650 $19,650 $19,65( CITY & COUNTY Re .00% $85,837 $85,837 $85,837 $85,837 $85,837 $85,837 $85,837 $85,837 $85,837 $85,83i City of Miami gr .00% $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,00( City of Miami to 2.50% $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,00( GP Capital and E .00% (5,314) (5,314) (5,314) (5,314) (5,314) (5,314) (5,314) (5,314) (5,314) (5,31, State of Fla. 3.00% $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,00( Homes For S.FLa. 9.00% $170,201 $454,712 $582,335 $707,415 $849,033 $991,713 $1,258,713 $1,596,866 $1,600,000 $1,600,001 OTHER .00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $( Limited Partner _ _.00%-- __ $0 _ $0 $0 $0 $0 $0 $0 $0 $337,555 $679,90i MONTHLY INTEREST PAYMENTS $i5 146 $4 658 $5,615 $6,553 $7,616 $8,686 $10,688 13 24 13 $13.52( JULY 11, 1994 50% 50% LEASE -UP C.0 OCCUPANCY OCCUPANCY USES OF FUNDS MONTH 10 MONTH 11 M01 2 MONTH 13 MONTH 14 MONTH 15 MONTH TOTAL Acquisition Fee $0 $0 $0 $0 $6,000 Acquisition: Lan $0 $0 $0 $0 $750,000 Bui $0 $0 $0 $0 $0 Site Improvement $0 $0 $0 $0 $0 Constr.Concrete, $821 $821 $821 FINAL RETAINAGE $0 $0 $9,850 Basic Constructi $300,000 $300,000 $300,000 $858,608 $0 $0 $0 $3,648,608 Contingency 7 $12,000 $12,000 $12,000 $34,344 $0 $109,458 $0 $255,403 OTHER $0 $0 $0 $0 $0 $0 Architect Design and Civil $0 $0 $0 $105,000 Cost analysis an $1,933 $1,933 $0 $1,937 $0 $28,200 Architect constr $2,500 $0 $0 $0 $25,000 Constr. Permits $0 $0 $0 $0 $30,000 Real Estate Taxe $0 $0 $24,136 $0 $0 $24,136 Insurance Constr $0 $0 $0 $0 $20,000 Permits Water/Se $0 $0 $0 $0 $69,000 SOFT COST CONTIN $9,711 $0 $9,711 $0 $116,528 Financing and Lo $0 $0 $0 $0 $31,367 Title & Recordin $0 $0 $0 $0 $40,000 Appraisal/survey $0 $0 $0 $0 $9,856 Environmental/so $0 $0 $0 $0 $21,550 FHFA ADM & APPL $0 $0 $0 $0 $43,604 Accounting/Post $0 $0 $12,000 $0 $0 $12,000 Legal:Transactic $0 $0 $0 $0 $43,300 :Organizati $0 $0 $0 $0 $10,000 :Syndicatic $0 $0 $0 $0 $7,000 other $0 $0 $0 $0 $0 Rent analysis/Ma $0 $0 $0 $0 $2,000 INTEREST ON CONS_ $13,520 $13,656 $13,788 $13,933 $14,296 $14 301 $14,538 $183,601 Initial Op/rent- $0 $0 $0 $0 $0 Rent -Lease up Re $0 $0 $0 $0 $o. FHFA Tax Credit $0 $0 $0 $0 $5,000 INTEREST ON BRID $0 $0 $187,077 $0 $187,077 Developer Fee** $0 $0 $0 $0 $0 Administration** $0 $0 $267,574 $0 $267,574 Impact fees $0 $0 $0 $0 $85,837 TOTAL USES $340,484 $328,410 $362,744 $906,885 $14,296 $590,059 $14,538 $6 037 491 $6,037,491 SOURCES OF FUNDS County CDBG & LI $0 $0 $0 $0 $0 $0 $0 $19,650 CITY & COUNTY Re $0 $0 $0 $0 $0 $0 $0 $85,837 City of Miami gr $0 $0 $0 $0 $0 $0 $0 $300,000 City of Miami to $0 $0 $0 $0 $0 $0 $0 $300,000 GP Capital and E $0 $0 $0 $0 $0 $0 $0 ($5,314) State of Fla. $0 $0 $0 $0 $0 $0 $0 $500,000 Homes For S.FIa. $0 $0 $0 $0 $0 $0 $0 $1,600,000 OTHER $0 $0 $0 $0 $0 $0 $0 $0 Limited Partner $340,484 $328,410 $362,744 $906,885 $14,296 $590,059 $14,538 $3,237,318 TOTAL SOURCES _$340,484 $328,410 $362,744 $906,885 $14,296 $590,059 $14,538 CUMULATIVE STATUS OF SOURCES County CDBG & LI $19,650 $19,650 $19,650 $19,650 $19,650 $19,650 $19,650 CITY & COUNTY Re $85,837 $85,837 $85,837 $85,837 $85,837 $85,837 $85,837 City of Miami gr $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 City of Miami to $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 $300,000 GP Capital and E (5,314) (5,314) (5,314) (5,314) (5,314) (5,314) (5,314) State of Fla. $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 $500,000 Homes For S.FIa.$1,600,000 $1,600,000 $1,600,000 $1,600,000 $1,600,000 $1,600,000 $1,600,000 OTHER $0 $0 $0 $0 $0 $0 $0 Limited Partner $1,020,387 $1,348,797 $1,711,541 $2,618,426 $2,632,722 $3,222,780 $3,237,318 MONTHLY INTEREST $13,656 $13,788 $13,933 $14,296 $.14,301 $14,538 $183,601 94- 536 BRIOGE LOAN MMT17ATION ANALYSIS AND LP CAPITAL CONTRIBUTION PAYINS RATE 9% TERM I LOAN BALANCE EQUITY APPLIED TO APPLIED TO LOAN APPLIED TO YEARLY BEFORE PAY -IN PAYMENT OF PAYMENT OF ENDING PAYMENT OF YEARLY PRINC& YEARLY DATE EQUITY PAY -IN AMOUNT INTEREST PRINCIPAL BALANCE PROJECT INTEREST INTEREST PRINCIPAL 1-1-95 $2,266,216 $0 $0 $0 $2,266,216 $0 $0 $0 $0 11-30-95 $2,266,216 $1,2.94,981 $169,966 $1,125,015 $1,141,202 $0 $169,966 $0 $0 1-31-96 $1,141,202 $971,236 $17,118 $1,141,202 $0 ($187,084) $17,118 $0 $0 04-15-99 $0 $0 $0 $0 $0 $0 $0 $0 $0 04-15-00 $0 $0 $0 $0 $0 $0 $0 $0 $0 04-15-01 $0 $0 $0 $0 $0 $0 $0 $0 $0 04-15-02 $0 $0 $0 $0 $0 $0 $0 $0 $0 04-15-03 $0 $0 $0 $0 $0 $0 $0 $0 $0 TOTAL $2,266,216 $187,084 $2,266,216 ($187,084) $187,084 $0 $0 $187,084 ($187,084) SYNDICATION LP CAPITAL $3,237,452 PAY -IN AT CLOSING $971,236 BALANCE $2,266,216 LESS YEARLY INT EXPENSE ($187,084) LESS YEARLY PRINCIPAL ($2,266,216) EQUITY SURPLUS (DEFICIT) ($187,084) LP CAPITAL CONTRIBUTIONS PAYIN SHECULP CAPITAL GP FEES BALANCE PAYMENT PAYMENTS LP NOTE 1 -FULL AMOUNT $3,237,452 $0 $3,237,452 30% $971,236 AT CLOSING LP NOTE 1 -GP FEES $0 $0 $0 0% $0 AT CLOSING 40% $1,294,981 @CERTIFICATE OF OCCUPA 30% $971,236 @95% OCCUPANCY (2MQNTH CONVENTIONAL FINANCING REQUIRED: APPLICATION OF PAY -INS: _ CONSTRUCTION $3,866,216 PAYIN FOR PROJECT FINANCI $3,237,452 _--> PERMANENT $1,600,000 PAYIN FOR OVLPR FEE $0 DEFERRED DVLPR FEE $369,690 CASA GRANDE (Formerly Rio Grande) LIHTC RENT LEVELS JULY 11, 1994 Units of Type #A, Effic. & 1 bath 48 Units of Type NB, 1-Bdr & 1 bath 55 Units of Type #C, 2-Bdr & 1 bath 1 total 104 100% MAXIMUM MARKET No -or MEDIAN % OF INCOME GROSS UTILITY NET RENT BDRMS BATHS UNITS SQ.FT. PERSONS INCOME MEDIAN LEVEL RENT ALLONANCERENT IN 1996. 0 LIHTC RENT LEVELS a 50% OF MEDIAN 0 1 0 1 29300 .50 14650 366.25 51 315.25 $.00 1 1 0 1.50 31400 .50 15700 392.50 54 338.50 $.00 2 1 0 3 37700 .50 18850 471.25 59 412.25 $.00 TOTAL UNITS 0 .75 78 78 LIHTC RENT LEVELS a 60% OF MEDIAN 0 1 48 1 29300 .60 17580 439.50 51 388.50 $388.00 1 1 30 1.50 31400 .60 18840 471 54 417 $417.00 2 1 0 3 �7700 .60 22620 565.50 59 506.50 $.00 TOTAL UNITS 78 .25 LIHTC RENT LEVELS a 80% OF MEDIAN LESS REQUIRED DEDUCTION OF 880 0 1 0 1 29300 .80 22640 566 51 515 $.00 - 1 1 25 1.50 31400 .80 24320` .608 54 554 $554.00 2 1 1 3 37700 .80 29280 732 59 673 $673.00 TOTAL UNITS 26 TOTAL I I i i i ALL UNITS 104 I i 94- 536 JULY 11, 1994 RENTAL RATES SCHEDULE NET SQUARE FEET 51040 EFF 48 NUMBER OF UNITS 104 1BORM 55 28DRM 1 MONTHLY YEARLY j UNIT TYPES: RENTAL RATES #OF UNITS INCOME INCOME i EFFICIENCIES $388.00 48 46.15% $18,624 $223,488.00 EFFICIENCIES $.00 0 .00% $0 $.00 EFFICIENCIES $.00 0 .00% $0 $.00 EFFICIENCIES $.00 0 .00% $0 $.00 EFFICIENCIES $.00 0 .00% $0 $.00 ONE BEDROOM $417.00 30 28.85% $12,510 $150,12.0.00 ONE BEDROOM $554.00 25 24.04% $13,850 $166,200.00 ONE BEDROOM $.00 0 .00% $0 $.00 TWO BEDROOMS /EXEMPT M $673.00 1 .96% $673 $8,076.00 TOTAL MONTHLY RENTS RESIDENTIAL 104 100.00% $45,657 $547,884.00 GROSS ANNUAL RENT (12 MONTHS) $547,884.00 i *VACANCY LOSSES .5% $2,739 EFFECTIVE GROSS INCOME RESIDENTIAL $545,145 j COMMERCIAL MONTHLY RENTS $0 $0 *VACANCY LOSSES 50.0% $0 EFFECTIVE GROSS INCOME COMMERCIAL $0 OTHER INCOME: AMERIVEND $300 j TRASH FEES $940 PARK & PET FEES $470 EARLY CANCELLATION & REPAIR FEES $400 INTEREST EARNED $50 SUBTOTAL OTHER INCOME $2 160 $25 920 *VACANCY LOSSES .5% $130 TOTAL OTHER INCOME $25,790'" TOTAL EFFECTIVE GROSS INCOME $570,935 *Vacancy losses of only 112 % and 5% rent increases are our past experience with our Rio Towers project which is Located in the same neighborhood and would serve the same type tenant. Also the same rental rates are proposed ** Proposed monthly rental rates are based on current market conditions. 94- 53b JULY 11, 1994 TTL UNIIi 104 } MONTHLY ANNUAL ANNUAL PERCENT *OPERATING EXPENSES: TOTAL 101AL PER UNIT OF E.G.I. TAXES 1.5% $5,498 $65,979 $634 11.72% INSURANCE $1,000 $12,000 $115 2.13% BANK CHARGES $10 $120 $1 .02% MAINTENANCE/REPAIRS $400 $4,800 $46 .85X ELEVATOR $158 $1,896 $18 .34% EXTERMINATION $100 $1,200 $12 .21% UTILITIES { $1,460 $17,520 $168 3.11% TRASH COLLECTION $450 $5,400 $52 .96% LEASING COORDINATOR $1,560 $18,720 $180 3.33% i SUPERINTENDENT $1,056 $12,673 $122 2.25% EMPLOYEE BENEFITS 20% $523 $6,279 $60 1.12% ACCOUNTING/LEGAL $708 $8,500 $82 1.51% TELEPHONE i $120 $1,440 $14 .26% OFFICE SUPPLIES & postage $50 $600 $6 .11% I OFFICE RENT $0 $U $0 .00% MANAGEMENT FEE a 6% $2,686 $32,227 $310 5.73% OTHER $0 $0 $0 .00% OTHER $0 $0 $0 .00% TENANT ACTIVITIES $0 $0 $0 .00% TOTAL OPERATING EXPENSES $15,T79 $189,353 $1,821 33.64% i $189,353 $189,353 Loan f1: Princ ✓4 Int. Pmts. I $0 $0 $0 .00% TOTAL EXPENSES $15,779 $189,353 11,821 _ 33.64% { i $189,353 $152,939 OPERATING RESERVE 3% $1,407 $16,887 $162 3.00% REPLACEMENT RESERVE 2% $938 $11,258 $108 2,00% TOTAL RESERVES $2,345 $28,145 $271 5% TOTAL $18,125 $217,498 $2,091 $217,498 $175,671 OPERATING EXPENSES REQUIRED TOTAL EFFECTIVE GROSS INCOME $562,899 BY STATE APPLICATION PER UNIT TOTAL OPERATING EXPENSES $189,353 $2,600 $270,400 SUBTOTAL $373,547 $292,499 Loan #1: Princ & Int. Pmts. $0 $0 NET OPERATING INCOME i $373,547 $292,499 *OPERATING EXPENSES ARE BASED ON PAST EXPERIENCE ON OUR 82 UNIT RIO TOWERS PROJECT. STATE APPLICATION REQUIRES ASSUMPTION OF $2,600 i PER UNIT/YR, ANN. RESIDENTIAL RENT INCREASE 3.00% REQUIRED AND CONTINGENT DEBT SERVICE ANN. COMMERCIAL RENT INCREASE 3.00% l ANNUAL EXPENSE INCREASE 5.00% FIRST FULL OPERATING YEAR ANN. OTHER INCOME INCREASE 3.00% 1 2 3 4 5 6 7 8 SOURCES 1996 1997 1998 1999 2000 2001 2002 2003 Maximum Gross Residential Rental income $547,884 $564,321 $581,2.50 $598,688 $616,648 $635,148 $654,202 $673,828 Residential Vacancy Allowance .50% $2,739 $2,1w $2,906 $2,993 $3,083 $3,176 $3,271 $3,369 Maximum Gross Commercial. Rental Income $0 $0 $O $(I $0 $0 $0 $0 Commercial Vacancy Allowance 50.00% $0 $0 $0 $0 $0 $0 $0 $0 Interest and other Income $25,920 $26,698 $27,499 $28,323 $29,175 $30,048 $30,950 $31,878 Interest/Other Inccxme Vacancy Allowance _ .50% $130 $133 $;137 142 $146 $150 $155 $159 TOTAL NET EFFECTIVE INCOME $570,935 $588,063 $605,705 $623,876 $642,592 1,661,870 $681,726 $702,178 USES: RLQUIRLD PAYMUNtS OPERATING EXPENSES (incl. R/E taxes) $270,400 $283,920 $2.98,116 $313,02.2 $328,673 $345,107 $362,362 $380,480 Loan #1: Princ & Int. FV61,600,000 9.00% 30 $0 $0 $0 $0 $0 $0 $0 $0 Homes For S.FIa. 1st Mortgage Loan #2: Princ & Int. Pmts. SUBTOTAL REQUIRED DEBT $0 $0 $0 $0 $0 $0 $0 $0 SUBTOTAL REQUIRED PAYMENTS_ $270,400 $283,920 $298,116 $313,022 $328,673 $345,107 $362,362 $380,480 CASH FLOW AFTER REQUIRED PAYMENTS $300,535 $304,143 $307,589 $310,854 $313,919 $316,764 $319,364 $321,698 DEBT SERVICE COVERAGE 2.11 2.OT 2.03 1.99 1.96 1.92 1.88 1.85 Operating Reserve (3% of EGI) $17,128 $17,642 $18,171 $18,716 1,19,278 $19,856 $20,452 $21,065 Replacement Reserve (2% of EGI) $11,419 $11,761 $12,111, $12,478 $12,852 $13,237 $13,635 $14L,044 SUBTOTAL REQUIRED PAYMENTS $798,947 $313,37.3 $328,401 344 216 360 803 $378,200 $396,448 $415,559 CASH FLCkJ AFTER REQUIRED PAYMENTS $271,988 $274,740 $277,304 ;279 660 $281,790 $283,670 $285,278 $286,589 DEBT SERVICE COVERAGE 1.91 1.88 1.84 1.81 1.78 1.75 1.72 1.69 PAYMENTS CONLINGENT ON AVAILABLE CASH FLOW Contingent Loan. #1: Int $300,000 2.50% 20 $0 $19,077 $19,077 $19,077 $19,077 $19,077 $19,077 $19,077 City of Miami loan 'Contirx3ent tint." l�.#2: $500,000 3.00% 15 $0 $0 $0 $0 $0 $0 $0 $0 State of Fla. - "Cantingent Pint." Ln.#3: $0 .00% 0 $0 $0 $0 $0• $0 $0 $0 $0 SUBTOTAL CONTINGENT PAYMENTS $0 $19,077 $19,077 $19,077 $19,077 $19,077 $19,077 $19,077 NET CASH FLOW AFTER REQUIRED & CONTINGENT PYMFS $271,988 $255,663 $258,227 $260,584 $262,713 $264,594 $266,202 $267,513 DEBT SERVICE COVERAGE 1.91 1.77 1.74" • 1.72 1.69 1.67 1.64 1.62 Deferred Dvtpr Fee:Princ $369,690 3.00% 40 $266,988 $250,663 $253,227 $255,584 $257,713 $259,594 $261,202 $262,513 Deferred GP fees/loans & $639,747 INCL.INTEREST Developer Partnership Mg $5,000 3.00% 1 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 Incentive Fee Set -Aside (% of Net Cash) $0 $0 $0 $0 $0 $0 $0 $0 SLBTOTAL PAYMENTS INCL.DVLPR FEES $271,988 $274,740 $277,304 $ZT9,660 $2.81,790 $283,67D $285,278 $286,589 TOTAL ALL PAYMENTS $570,935 $588,063__$605,705 $623,876 $642,592 $661,870 $681,726 $T02,178 NET CASH FLOW AFTER DEVELOPER FEES $0 $0 $0 1O $0 $0 $0 CUMMULATIVE NET CASH FLOW $0 $0 $0 $0 $0 $0 $0 $0 GENERAL PARTNER SHARE 1.00% $0 $0 $0 $0 $0 $0 $0 $0 LIMITED PARTNER SHARE 99.00% $0 $0 $0 $0 $0 $0 $0 $0 CUMMULATIVE RESERVE BALANCES Initial Operating Reserve $0 $17,128 $17,642 $18,171 $18,716 $19,278 $19,856 $20,452 $21,065 Replacement Reserve $0 $11,419 $11,761 $12,114 $12,478 $12,852 $13,237 $13,635 $14,044 Incentive Fee Set -Aside TOTAL RESERVE BALANCES $0 $28,547 $29,403 $30,285 $31,194 $32,130 $33,094 $34,086 $35,109 TOTAL CUMMULATIVE RESERVES $0 $28,547 $57,950 $88,235 $119,429 $151,559 $184,652 $218,738 $253,847 DEFERRED DEV. FEE Begn Pri. Balance $369,690 $369,690 $102,702($150,525)($406,109)($663,822)($923,416)******************** COMPOUNDED INTEREST CHARGE $11,091 $3,081 ($4,516) ($12,183) ($19,915) ($27,702) ($35,539) ($43,414) WSW MGT. FEE Charged 94- 536 ANN. RESIDENTIAL RENT INCREASE ANN. COMMERCIAL RENT INCREASE ANNUAL EXPENSE: INCREASE ANN. OTHER INCOME INCREA 9 10 11 12 13 14 15 16 SOURCES 2004 2005 2006 2007 2008 2009 2010 2011 TOTAL Maximum Gross Residentia $694,043 $714,864 $736,310 $758,400 $781,152 $804,586 $828,724 $853,585 $11,043,633 Residential Vacancy Alto $3,470 $3,574 $3,682 $3,792 $3,906 $4,023 $4,144 $4,268 $55,218 Maximum Gross Commercial $0 $0 $0 $0 $0 $0 $0 $0 $0 Commercial Vacancy Allow $0 $0 $0 $0 $0 $0 $0 $0 $0 Interest and other Incom $32,835 $33,820 $34,834 $35,879 $36,956 $38,064 $39,206 $40,383 $522,466 Interest/Other Income Va _ $164 $169 $171, 1T9 $1185 $190 $196 $202 $2,612 TOTAL NET EFFECTIVE: INCO $723,243 $744,941 $T67,2.89 $790,308 $814,017 $838,437 $863,590 $889,498 $11,508,269 $11,508,269 USES: RLOUIRED PAYMENTS OPERATING EXPENSES (incl $399,501, $419,479 $440,453 $462,476 $485,600 $509,880 $535,374 $559,465 $6,394,309 Loan 01: Prine h Int. Rn $0 $0 $0 $0 $0 $0 $0 $0 $0 Homes For S.Fla. 1st Mortgage loan 02: Prim E Int. Ruts. $0 SUBTOTAL REQUIRED OMIT $0 - $0 $0 $0 $0 $0 $0 $0 $0 SU3TOTAL REQUIRLO 13AYMOI $399,501, $419,479 $440,453 $462.,476 $485,600 $509,880 $535,374 $559,465 $6,394,309 CASH FLO14 AFTER REQUIRED $323,739 $325,462 $326,836 $327,832 $328,417 $328,558 $328,217 $330,033 $5,113,960 DIEBY SERVICE CaveRAGe 1.81 1.78 1.74 1.71 1.68 1.64 1.61 1.59 1.73 Operating Reserve $21,697 $22,348 $23,019 $23,709 $24,421 $25,153 $25,908 $26,685 $345,248 Replacement Reserve $14,465 $14,899 $15 346 $15,806 $16,280 $16,769 $17,272 $17,790 _ 230 165 SUBTOTAL REQUIRED PAYMEN $435,666 $456,726 $478,818 �i01 991 $52=6 3V0 $»1,801 _$578,553 $603,940 $6 969,722 CASH FLOW AFTER REQUIRED $287,517 $288,214 $288,4,71 y28.8,316 $287,716 $286,636 $285,037 $285,558 $4 538 546 DEBT SERVICE (MERAGE 1.66 1.63 1.60 1.w 1.55 1.57 1.49 1.47 1.65 - PAYMENTS CONTIWANT ON AVAILABLE CASH FLOW $4,538,546 Contingfent Loan. 01: Int $19,077 $19,077 $19,077 $19,OT7 $19,07T $19,077 $19,077 $19,077 $286,148 City of Miami loan 'Contirxjent Rnt.' Ln.12: $0 $0 $0 $0 $0 $0 _ $0 $0 $0 State of Fla. 'Contingent Prnt.' In.03: $0 $0 $0 $0 $0 $0 $0 $0 $0 SUBTOTAL CONTINGENT PAYM $19,077 $19,077 $19,077 $19,077 $19,077 $19,OT7 $19,077 $19,077 $286,148 NET CASH FLOW AFTER REQU $2.68,501 $269,138 $2.69,395 $269,240 $268,640 $267,559 $265,961 $266,481 $4,252,399 DEBT SERVICE COVERAGE 1.59 1.57 1.54 1.52 1.49 1.47 . 1.45 1.43 1.59 Deferred Dvlpr Fee:Princ $263,501 $264,138 $264,395 $264,240 $263,640 $262,559 $260,961 $261,481 $4,172,399 Deferred GP fees/Loans & GP Capital. Oeveloocr Partnership Mg $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $80,000 Incentive Fee Set -Aside $0 $0 $0 $0 $0 $0 _$0 $0 $0 SUBTOTAL PAYMENTS INCL.D $287,577 $288,214 $288,471 $288,316 $287,716 $286,636 $285,037 $285,558 $4,538,546 TOTAL ALL PAYMENTS $723,243 $744,941 $767 289 $790 308 $814 017 $8838,437 $863,590 $889,498 411,508,269 NET CASH FLOW AFTER DEVE $0 $0 $0 $0 $0 $0 $0 $0 $0 CUMMULATIVE NET CASH FLO $0 $0 $0 $0 $0 $0 $0 $0 $0 GENERAL PARTNER SHARE $0 $0 $0 $0 $0 $0 $0 $0 $0 LIMITED PARTNER SHARE $0 $0 $0 $0 $0 $0 $0 $0 $0 CUMMULATIVE RESERVE VALANCES Operating Reserve $21,697 $22,348 $23,019 $23,709 $24,421 $25,153 $25,908 $26,685 $345,248 Replacement Reserve $14,465 $14,899 $15,346 $15,806 $16,280 $16,769 $17,2T2 $17,790 $230,165 Incentive Fee Set. -Aside $0 TOTAL RESERVE BALANCES $36,162 $37,247 $38,364 $39,515 $40,701 $41,922 $43,180 $44,475 $575,413 TOTAL CUMMULATIVE RESERV $290,009 $327,256 $365,621 $405,136 $445,837 $487,T59 $530,939 $575,413 $575,413 DEFERRED DEV. FEE Begn Pkk*kW*kkW*Wk*WkWkkWW*WWkWWk*kWkkWkW*kkWk*NWW*k*kkk($3,029,6D3)**"***"*"**($3,552,045) COMPOUNDED INTEREST CHAR ($51,319) ($59,243) ($67,175) ($75,102) ($83,011) ($90,888) ($98,717) ($106,561) ($761,113) WS11P NGT. FEE Charged 9 4 - 536 CASA GRANDE (Formerly Rio Grande) 2 3 4 5 6 7 8 9 1996 1997 1998 1999 2000 2001 2002 2003 2004 TOTAL NET EFFECTIVE INCOME $562,899 $579,786 $597,180 $615,0:>5 $633,548 $652,555 $672,131 $692,295 $713,064 EXPENSES 4 Building Operating Expenses $270,400 $283,920 $298,116 $313,022 $328,6T3 $345,107 $362,362 $380,480 $399,504 "Required Payments" #1 $144,000 $143,056 $142,027 $140,906 $139,684 $138,351 $136,899 $135,316 $133,590 "Required Payments" #2 $0 $0 $0 $0 $0 $0 $0 $0 $0 "Contingent Payments" Loan #1 Interest $7,500 $7,211 $6,914 $6,610 $6,298 $5,979 $5,651 $5,316 $4,972 "Contingent Payments" Loan #2 Interest $15,000 $14,207 $13,390 $12,549 $11,682 $10,790 $9,870 $8,923 $7,948 "Contingent Payments" Loan #3 Interest "Contingent Payments" Loan #4 Interest Deferred Developer Fee Interest $11,091 $3,310 ($4,044) ($11,461) ($18,935) ($26,457) ($34,020) ($41,613) ($49,228) i Equity Bridge Loan Interest $0 Depreciation & Amorti7ation $240,981 $240,981 $240,981 $240,981 $240,981 $240,981 $240,981 $232,981 $232,981 Annual Partnership Management Fee $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 AUDIT/Cost Cert (INCI IN OPER.EXPENSES) $0 Initial Partnership Management Fee $0 _ TOTAL EXPENSES $693,972 $697,685 $702,385 $707,607 $113,383 $719,750 $72.6,744 $726,403 $734,767 TAXABLE PROFIT/LOSS ($131,073)($117,899)($105,205) ($92,511) ( 79,835) ($67,196) ($54,613) ($34,108) ($21 703) TAX SAVINGS OR (COST) 35,00% $45,875 141,265 $36,822 $32,379 $27,942 $23,519 $19,114 $11,938 $77 596 TAX CREDITS: Bldg #1 - LIHTC (Acq) $0 $0 $0 $0 $0 $0 $0 $0 $0 Bldg #1 - LIHTC (Const) $647,490 $647,490 $647,490 $647,490 $647,490 $647,490 $647,490 $0 $0 Bldg #1 - Historic Rehab $0 $0 $0 $0 $0 $0 $0 $0 $0 Bldg #2 - LIHTC (Acq) $0 $0 $0 $0 $0 $0 $0 $0 $0 Bldg #2 - LIHTC (Const) $0 $0 $0 $0 $0 $0 $0 $0 $0 Bldg #2 - Historic Rehab $0 $0 $0 $0 $Q $0 $0 $0 $0 TOTAL TAX BENEFITS $693,366 $688,755 $684,312 $679,869 $675,433 •$671,009 $666,605 $11,938 $7,596 GENERAL PARTNER SHARE 1% $6,934 $6,888 $6,843 $6,799 $6,754 $6 710 $6 666 $119 $76 LIMITED PARTNER SHARE 99% $686,432 $681,867 $677,469 $673,071 $668,678 $664,299 $659,939 $11 818 $7 520 NOTE: Certain expenses may be deferred until the year of sale (and added to the line item in that year), including: -Unexpensed Loan Interest (under "OID" rules, simple interest is discounted to its compounded equivalent for annual expense purl -Unpaid Annual Partnership Management Fees (due to insufficient cash in year earned - payment is from sale proceeds)* -Unpaid Interest on Deferred Developer Fee (due to insufficient cash in year earned - payment is from sate proceeds)** (*Partnership Management Incentive Fee is not paid unless the LP Purchase option is exercised a t time of sate. Due to this cot (**The principal portion of the Deferred Developer Fee is depreciated as a development cost Payment for any unpaid portion is ft 94- 536 CASA GRANDE (Formerly Rio Grande) 10 11 12 13 14 15 16 2005 2006 2.007 2008 2009 2010 2011 TOTAL TOTAL NET EFFECTIVE INC $734,456 $756,490 $779,184 $802,560 $826,63T $851,436 $876,979 $11,346,296 1 $0 EXPENSES $0 Building Operating Expe $419,479 $440,453 $462,476 $485,600 $509,880 $535,374 $559,465 $6,394,309 "Required Payments" #1 $131,710 $129,660 $127,425 $124,990 $122,335 $119,441 $116,287 $2,125,676 "Required Payments" #2 $0 $0 $0 $() $0 $0 $0 $0 "Contingent Payments" L $4,619 $4,258 $3,887 $3,507 $3,118 $2,719 $2,310 $80,869 "Contingent Payments" L $6,943 $5,909 $4,8t,3 $3,745 $2,614 $1,450 $250 $130,113 "Contingent Payments" Loan #3 Interest $0 "Contingent Payments" Loan 111, Interest $0 Deferred Developer Fee ($56,854) ($64,478) ($72,088) ($79,670) ($87,211) ($94,693)($102,181) ($728,532) Equity Bridge Loan Interest $0 Depreciation 8 Amortiza $232,981 $232,981 $232,981 $232,981 $232,981 $232,981 $232,981 $3,783,702 Annual Partnership Maria $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $80,000 AUDIT/Cost Cert (INCL IN OPER.EXPENSES) $0 Initial Partnership Management Fee _ $0 TOTAL EXPENSES $743,879 $753,783 $764,524 $776,152 $788,717 $802,271 $814,113 $11,866,137 $0 TAXABLE PROFIT/LOSS ($9,423) $2 707 $14,660 $26, 407 $37,919 $49,1G4 $G2,866 ($519,842) TAX SAVINGS OR (COST) $3,2.98 ($947) _($5,131) ($9,243) (113,2.72) ($17,208) ($22,003) $181,945 i TAX CREDITS: Bldg #1 - $0 $0 $0 $0 $0 $0 $0 $0 Bldg #1 - $0 $0 $0 $0 $0 $0 $0 $4,532,433 Bldg #1 - $0 $0 $0 $0 $0 $0 $0 $0 Bldg #2 $0 $0 $0 $0 $0 $0 $0 $0 j Bldg #2 - $0 $0 $0 $0 $0 .$0 $0 $0 ' Bldg #2 - $0 $0 $0 $0 $0 $0 $0 $0 I TOTAL TAX BENEFITS $3,298 ($947) ($5,131) ($9,243) ($13,272) ($17,208) ($22,0039 $4,714,377 GENERAL PARTNER SHARE $33 ($9) ($51) ($92) ($133) ($172) ($220) $47,144 I LI14ITED PARTNER SHARE $3 265 ($938) ($5,080) ($9,150) ($13,139) (_tjL 035) ($21,783) $4,667,234 I NOTE: Certain expenses may be deferred unfit the year of sale (and added to the line item in that year), -Unexpensed Loan Interest (under "OID" rules, simple interest is discounted to its compounded equiv -Unpaid Annual Partnership Management Fees (due to insufficient cash in year earned - payment is fr II� -Unpaid Interest on Deferred Developer Fee (due to insufficient cash in year earned - payment is fr ("Partnership Management Incentive Fee is not paid unless the LP Purchase Option is exercised a t t ("The principal portion of the Deferred Developer Fee is depreciated as a development cost Payment 94- 536 CASA GRANDE (Formerly Rio Grande) SCHEDULES OF D°'QECIATION AND AMORTIZATION DEPR'BLE LIFE (YEARS) ANNUAL DEPRECIATION ADJ LP SHARE GP SHARE IN ASSET BASIS 50% 50% SERVICE Res. Bldg. Acquisition $0 27.50 27.50 12/95 Res. Construction $6,407,195 27.50 27.50 12/95 Cortmc'l Bldg. Arq. $0 39 39 12/95 Conmc't Constr. $0 39 39 12/95 Personal Property 56 000 7 7 12/95 TOTAL ASSET 1996 1997 1998 1999 2000 2001 2002 2003 200 Res. Bldg. Acquisition Res. Construction $232,989 $232,989 $232,989 $232,989 $2.32,989 $232,989 $232,989 $232,989 $232 Commc'L Bldg. Acq. Conmc'L Constr. Personal Propert $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $0 ANNUAL TOTAL $240,989 $240,989 $240,989 $240,989 $240,989 $240,989 $240,989 $232,989 $23-f Ct"IULATIVE TOTAL $240,989 $481,978 $722,967 $963,956 $1,204,944 $1,445,933 $1,686,922 $1,919,911 $2,152 ANNUAL AMORTI7ATION TERM IN ASSET BASIS (YEARS) SERVICE Loan Fees, Related Legal & Consulting $31,367 30 12/95 ALL Organization Costs/Fees $10,000 5 12/95 Market Study Rent -Lease Up Reserve $0 1 12/95 ,. Tax Credit Allocation Fee $5,000 10 12/95 _ Relocation Expenses $0 0 12/95 ' (Unused) TOTAL $46,367 I ' ASSET 1996 199T 1998 � 1999 - 2000 2001 2002 2003 20( Loan Fees, Related Legal & Consulting $1,046 $1,046 $1,046 $1,046 $1,046 $1,046 $1,046 $1,046 $' All Organization Costs/Fees $2,000 $2,000 $2,000 $2,000 $2,000 $0 $0 $0 Market Study $0 $0 $0 $0 $0 $0 $0 $0 Tax Credit Allocation Fee $500 $500 $500 $500 $500 $500 $500 $500 Relocation Expenses (Unused) ANNUAL TOTAL $3,546 $3,546 $3,546 $3,546 $3,546 $1,546 $1,546 $1,546 $' CUMMULATIVE TOTAL $3,546 $7,091 $10,637 $14,182 $17,728 $19,273 $20,819 $22,365 $2: UPPER -TIER AMORTIZATION (if any) TERM IN ASSET BASIS (YEARS) SERVICE Capitalized "Master" Bridge Loan Inte 26726.32 27.50 12/95 ASSET 1996 1997 1998 1999 2000 2001 2002 2003 20( Capitalized "Master" Bridge Loan Inte 971.87 971.87 971.87 971.87 971.87 971.87 971.87 971.87 9i 94- 536 CASA GRANDE (Formerly Rio Grande) ANNUAL DEPRECIATION ASSET _ Res. Bldg. Acquisition Res. Construction Commc'l Bldg. Acq. Commc'l Constr. Personal Property TOTAL SALE ASSET 2005 2006 2007 2008 2009 2010 2011 TOTAL Res. Bldg. Acquisition Res. Construction $232,989 $232,989 $232,989 $232,989 $232,989 $232,989 $232.,989 $3,727,822 Conmc'l Bldg. Acq. Conmc'l Constr. Personal Property $0 $0 $0 $0 $0 $0 $0 $56,000 ANNUAL TOTAL $232,989 $232,989 $232,989 $232,989 $232,989 $232,989 $232,989 $3,783,822 CUW*JIATIVE TOTAL $2,385,889 $2,618,878 $2,851,867 $3,084,856 $3,317,845 $3,550,833 $3,783,822 ANNUAL AMORTIZATION ASSET Loan Fees, Related Legal & Consulting All organization Costs/Fees Market Study Rent -Lease Up Reserve Tax Credit Allocation Fee Relocation Expenses , (Unused) TOTAL ` SALE ASSET _ 2005 2006 2007 2008 2009 2010 2011 TOTAL Loan Fees, Related Legal $1,046 $1,046 $1,046 $1,046 $1,046 $1,046 $1,046 $16,72.9 All Organization Costs/Fe $0 $0 $0 $0 $0 $0 $0 $10,000 Market Study $0 $0 $0 $0 $0 $0 $0 $0 Tax Credit Allocation Fee $500 $0 $0 $0 $0 $0 $0 $5,000 Relocation Expenses (Unused) ANNUAL TOTAL $1,546 $1,046 $1,046 $1,046 $1,046 $1,046 $1,046 $31,729 CUMMULATIVE TOTAL $25,456 $26,501 $27,547 $28,592 $29,638 $30,684 $31,729 UPPER -TIER AMORTIZATION (if arty) ASSET _ Capitalized "Master" Bridge Loan Interest ASSET 2005 2006 2007 2008 2009 2010 2011 TOTAL Capitalized "Master" Brid 971.87 971.87 971.87 971.87 971.87 971.87 971.87 $15,550 94- 536 CASA GRANDE (Formerly RiRIO GRANDE 1 2 3 4 5 6 7 8 1996 199T 1998 1999 2000 2001 2002 2003 REQUIRED PAYMENTS LOAN #Homes For S.FLa. 1st Mortgage 1 Loan Amount $1,600,000 Disbursement Date Interest Rate9% Simp(e!Comp. In C Amort Term (y30 Required Ann. P 1 I PAYMENTS MADE IN YEAR 12 12 12 12 12 12 12 12 PRINCIPAL BALANCE (BEFORE Pri Pmt) 1600000 1589512 1578081 1565621 1552039 1537235 1521099 1503510 PRINCIPAL & INTEREST 154488 154488 154488 154488 154488 154488 154488 154488 INTEREST PAYMENT 144000 143056 142027 140906 139684 138351 136899 135316 PRINCIPAL PAYMENT 10488 11431 12460 13582 14804 16136 17589 19172 PRINCIPAL BALANCE (After PH Pmt) $1,589,512 $1,578,081 $1,565,621 $1,552,039 $1,537,235 $1,521,099 $1,503,510 $1,484,338 $1 FACE RATE INTEREST BALANCE (After Int Pmt) MAX "OID" INTEREST EXPENSE OID Rate = --N/A-- ACTUAL INTEREST EXPENSE CASA GRANDE ( 10 11 12 13 14 15 16 17 SALE 2.005 2006 2007 2008 2009 2010 2011 2012 TOTAL REQUIRED PAYMENTS LOAN #1 Loan Amount Interest Rate Amort Term (years) PAYMENTS MADE 12 12 12 12 12 12 •12 12 204 PRINCIPAL RAL 1463441 1440664 1415836 1388773 1359275 1327123 1292076 1253875 24872499 PRINCIPAL & I 154488 154488 154488 1544BB 154488 154488 154488 154488 2626288 INTEREST PAYM 131710 129660 127425 124990 122335 119441 1162.87 112849 2238525 PRINCIPAL PAY 22778 24828 27062 2.9498 32153 35047 38201 41639 387763 PRINCIPAL BAL$1,440,664 $1,415,836 $1,388,773 $1,359,275 $1,327,123 $1,292,076 $1,253,875 $1,212,237 24484736 FACE RATE INTEREST BALANCE (After Int Pmt) MAX "0I0" INTEREST EXPENSE OID Rate =--NIA-- ACTUAL INTEREST EXPENSE 1996 1997 1998 1999 2000 2001 2002 2003 COMTINGUNI PAYMI-NIS LOANCity of Miami I, -1 Loan Amount $300,000 Disbursement D Interest Rate37 Simple/Comp. In C Amort Term (y20 Required Ann. P 1 PAYMENTS MADE IN YEAR 12 12 12 12 12 12 12 12 PRINCIPAL BALANCE (BEFORE Pr) Pmt) 300000 288423 276558 264395 251928 239150 226052 212627 PRINCIPAL & INTEREST 19077 19077 19077 19077 19077 19077 19077 19077 INTEREST PAYMENT 7500 7211 6914 6610 6298 5979 5651 5316 PRINCIPAL PAYMENT 11577 11866 12.163 12467 12T78 13098 13425 13761 PRINCIPAL BALANCE (After- Pri Pmt) $288,423 $276,558 $264,395 $251,928 $239,150 $226,052 $212,627 $198,866 $ FACE RATE INTEREST BALANCE (After Int Pmt) MAX 'DID' INI RUST EXPENSE DID Rate=--N/A-- ACTUAL INILREST EXPENSE CONTINGENT PAYMBRIS LOANState of F(a. Loan Amount $500,000 Disbursement Date Interest Rate3% Simple/Comp. In C Amort Term (y15 Required Ann. P 1 PAYMENTS MADE IN YEAR 12 12 12 12 12 12 12 12 PRINCIPAL_ BALANCE (BEFORE Pri Pmt) 500000 4T3565 446337 418292 389406 359654 329008 297444 PRINCIPAL & INTEREST 1,1435 41435 41435 41435 41435 41435 411,35 41435 INTEREST PAYMENT 15000 14207 13390 12549 11682 1OT90 9870 8923 PRINCIPAL PAYMEIIT 26435 27228 28045 2.8886 29753 30645 31565 32512 PRINCIPAL BALANCE (After Pri Pmt) $473,565 $446,337 $418,292 $389,406 $359,654 $329,008 $297,444 $264,932 $ FACE RATE INTEREST BALANCE (After, Int Pmt) MAX 'DID' INTEREST EXPENSE DID Rate=--N/A-- ACTUAL INTEREST EXPENSE CASA GRANDE ( 10 11 12 13 14 15 16 17 SALE 2005 2006 2007 2008 2009 2010 2011 2012 TOTAL CONTINGENT PAYMENTS LOAN #1 " Loan Amount Interest Rate Amort Term (years) PAYMENTS WADE 12 12 12 12 12 12 12 12 204 PRINCIPAL BAL 184761 170304 155485 140296 124727 108768 92411 75645 3310397 PRINCIPAL & 1 19077 19077 190TT 1907T 19077 19077 19077 19077 324301 INTEREST PAYM 4619 4258 3887 3507 3118 2719 2310 1891 82760 PRINCIPAL PAY 14457 14819 15189 15569 15958 1635T 16766 17185 241541 PRINCIPAL BAL $170,304 $155,485 $140,296 $124,727 $108,768 $92,411 $75,645 $58,459 3068857 FACE RATE INTEREST BALANCE (After lnt Pmt) MAX 'OID' INTEREST EXPENSE DID Rate=--N/A-- ACTUAL INTEREST UPENSE CONTINGENT PAYMENTS LOAN 02 Loan Amount Interest Rate Amort Term (years) PAYMENTS MADE 12 12 12 12 12 12 12 12 204 PRINCIPAL BAL 231445 196954 161427 124835 87145 48325 8340 -32845 4304264 PRINCIPAL & I 41435 41435 41435 41435 41435 41435 41435 41435 704393 INTEREST PAYM 6943 5909 4843 3745 2614 1450 250 -985 129128 PRINCIPAL PAY 34492 35526 36592 37690 38821 39985 41185 42420 575265 PRINCIPAL BAL $196,954 $161,427 $124,835 $87,145 $48,325 $8,340 ($32,845) ($75,265) 3728998 FACE RATE INTEREST BALANCE (After Int Pmt) MAX 'DID' INTEREST EXPENSE DID Rate=--N/A- ACTUAL INTEREST EXPENSE 9 4 _ 536