|
Table A-9. Scenario 1
<br />Baseline Cashflow
<br />Cash Flow Escalator
<br />Tenant Rents 2.50%
<br />Rental Subsidy
<br />Vacancy 5%
<br />Effective Gross Income
<br />Operating Expenses (Less Services)3.50%
<br />Resident Service Expenses 3.50%
<br />% of Service Expense Target
<br />Net Operating Income
<br />Replacement Reserves 3.50%
<br />% of Replacement Reserve Target
<br />Proposed Ordinace Fee 3.50%
<br />Cash available for debt service
<br />Debt Service
<br />Net Cash
<br />Debt Service Coverage Ratio
<br />Additional Subsidy Required
<br />General Partner Fee
<br />Residual Receipts
<br />Developer 35%
<br />Other Public Funding 44%
<br />City of Redwood City 22%
<br />100%
<br />Yr31 Yr32 Yr33 Yr34 Yr35 Yr36 Yr37 Yr38 Yr39 Yr40
<br />$3,948,293 $4,047,001 $4,148,176 $4,251,880 $4,358,177 $4,467,132 $4,578,810 $4,693,280 $4,810,612 $4,930,877
<br />$576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600
<br />($226,245)($231,180)($236,239)($241,424)($246,739)($252,187)($257,770)($263,494)($269,361)($275,374)
<br />$4,298,649 $4,392,421 $4,488,537 $4,587,056 $4,688,038 $4,791,545 $4,897,639 $5,006,386 $5,117,852 $5,232,104
<br />$2,376,625 $2,459,806 $2,545,900 $2,635,006 $2,727,231 $2,822,684 $2,921,478 $3,023,730 $3,129,561 $3,239,095
<br />$280,679 $290,503 $300,671 $311,194 $322,086 $333,359 $345,027 $357,103 $369,601 $382,537
<br />100%100%100%100%100%100%100%100%100%100%
<br />$1,641,345 $1,642,111 $1,641,967 $1,640,856 $1,638,721 $1,635,502 $1,631,134 $1,625,554 $1,618,690 $1,610,471
<br />$141,743 $146,704 $151,839 $157,153 $162,653 $168,346 $174,238 $180,337 $186,649 $193,181
<br />100%100%100%100%100%100%100%100%100%100%
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br />$1,499,602 $1,495,407 $1,490,128 $1,483,703 $1,476,068 $1,467,155 $1,456,896 $1,445,217 $1,432,041 $1,417,290
<br />$1,186,621 $1,186,621 $1,186,621 $1,186,621 $1,186,621 $1,186,621 $1,186,621 $1,186,621 $1,186,621 $1,186,621
<br />$312,981 $308,786 $303,507 $297,082 $289,446 $280,534 $270,275 $258,596 $245,420 $230,669
<br />1.26 1.26 1.26 1.25 1.24 1.24 1.23 1.22 1.21 1.19
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br />$25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
<br />$287,981 $283,786 $278,507 $272,082 $264,446 $255,534 $245,275 $233,596 $220,420 $205,669
<br />$99,714 $98,262 $96,434 $94,209 $91,566 $88,480 $84,927 $80,883 $76,321 $71,214
<br />$125,511 $123,683 $121,382 $118,582 $115,254 $111,370 $106,898 $101,808 $96,066 $89,637
<br />$62,755 $61,841 $60,691 $59,291 $57,627 $55,685 $53,449 $50,904 $48,033 $44,818
<br />Economic & Planning Systems, Inc. A-8 Appendix A
<br />Cont.
<br />8.A. - Page 117 of 168
<br />127
|