|
Table A-10. Scenario 2:
<br />Post -1995 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 />$133,522 $138,195 $143,032 $148,038 $153,220 $158,582 $164,133 $169,877 $175,823 $181,977
<br />$1,366,080 $1,357,212 $1,347,096 $1,335,665 $1,322,848 $1,308,573 $1,292,763 $1,275,339 $1,256,218 $1,235,313
<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 />$179,459 $170,591 $160,475 $149,043 $136,227 $121,952 $106,142 $88,718 $69,597 $48,692
<br />1.15 1.14 1.14 1.13 1.11 1.10 1.09 1.07 1.06 1.04
<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 />$154,459 $145,591 $135,475 $124,043 $111,227 $96,952 $81,142 $63,718 $44,597 $23,692
<br />$53,482 $50,411 $46,909 $42,951 $38,513 $33,570 $28,096 $22,063 $15,442 $8,203
<br />$67,318 $63,453 $59,044 $54,062 $48,476 $42,255 $35,364 $27,770 $19,437 $10,326
<br />$33,659 $31,726 $29,522 $27,031 $24,238 $21,127 $17,682 $13,885 $9,718 $5,163
<br />Economic & Planning Systems, Inc. A-12 Appendix A
<br />Cont.
<br />8.A. - Page 121 of 168
<br />131
|