|
Judson Brown, City of Santa Ana
<br />May 9, 2017
<br />Santa Ana Arts Collective Financial Feasibility
<br />Page 3 of 5
<br />Table 2: Variance Analysis of Developer's Budget (Cont.)
<br />Budget Item
<br />Developer
<br />CSG
<br />Variance
<br />Explanation of Variance
<br />Developer has provided documentation
<br />supporting $1,486,811 of Relocation costs,
<br />Deferred Developer Fee
<br />$3,491,484
<br />$269,942
<br />($3,221,542)
<br />rather than the $1,610,00 included in the
<br />budget. We have therefore reduced the
<br />Total Other Costs488627
<br />$0
<br />JLaL5438
<br />($123,189)
<br />Relocation by the difference (i.e., $123,189)
<br />Subtotal Development Costs
<br />$32,178,764
<br />$32,061,736
<br />($117,028)
<br />Federal Equity reflects $0.989 net pricing per
<br />Developer Overhead/Profit
<br />$2.000,000
<br />$2.000.000
<br />$0
<br />developer
<br />Notal Project Cost
<br />$34,178,764
<br />$34,061,736 _
<br />($234,055J�_��
<br />SOURCES
<br />Increase loan amount assuming 2017 CTCAC
<br />rents and underwriting rate of 5.65%
<br />CCRC $2,093,389 $2,709,532 $616,143 (consistent with CCRC termsheet)
<br />Citv of Santa Ana $4.635.000 $4,635.000 $0
<br />AHSC $22,500 $22,500 $0
<br />AHSC $1,288,000 $1,288,000 $0
<br />AHSC $4.944,130 $4.944.130 $0
<br />4FI NAN C I N G GAP _ _ ($7)_� _ ($1,481,215)
<br />Discussion of Table 1
<br />The "Uses" portion of Table 1 shows the Developer's budget, contrasted with necessary modifications
<br />proposed by CSG.
<br />• Total Permanent Financing Costs: The Developer's budget reflects origination fee of 1% (per CCRC
<br />term sheet) of a permanent loan amount of $2,093,389. We have adjusted the fee to reflect a loan
<br />amount of $2,709,532 (reflecting higher 2017 restricted rents as published by CTCAC). The loan
<br />amount reflects:
<br />➢ Effective Gross Rents $653,243 (per Developer unit mix, 2017 CTCAC rents, and 5% vacancy)
<br />> Operatinq Expenses and Reserves ($424,875)
<br />Cash Flow Available to Support
<br />Debt
<br />CSG Iadvisors SAN FRANCISCO 65Aw3Ta LOS ANGELES NEW YORK
<br />Correction of deferred fee to net present
<br />value of maximum 15 -year cash flow
<br />available after asset and partnership
<br />Deferred Developer Fee
<br />$3,491,484
<br />$269,942
<br />($3,221,542)
<br />management fees.
<br />(Proposed) GP Contribution required to net
<br />GP Capital Contribution
<br />$0
<br />$1,000,000
<br />$1,000,000
<br />$1 M Developer Fee
<br />Federal Equity reflects $0.989 net pricing per
<br />Federal Tax Credit Equity
<br />$17,704,254
<br />$17,711,417
<br />$7,163 -
<br />developer
<br />_Total Sources
<br />$34,178,757_
<br />$32,580,522
<br />($1,364,180)_
<br />4FI NAN C I N G GAP _ _ ($7)_� _ ($1,481,215)
<br />Discussion of Table 1
<br />The "Uses" portion of Table 1 shows the Developer's budget, contrasted with necessary modifications
<br />proposed by CSG.
<br />• Total Permanent Financing Costs: The Developer's budget reflects origination fee of 1% (per CCRC
<br />term sheet) of a permanent loan amount of $2,093,389. We have adjusted the fee to reflect a loan
<br />amount of $2,709,532 (reflecting higher 2017 restricted rents as published by CTCAC). The loan
<br />amount reflects:
<br />➢ Effective Gross Rents $653,243 (per Developer unit mix, 2017 CTCAC rents, and 5% vacancy)
<br />> Operatinq Expenses and Reserves ($424,875)
<br />Cash Flow Available to Support
<br />Debt
<br />CSG Iadvisors SAN FRANCISCO 65Aw3Ta LOS ANGELES NEW YORK
<br />
|