|
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 />Yr11 Yr12 Yr13 Yr14 Yr15 Yr16 Yr17 Yr18 Yr19 Yr20
<br />$2,409,529 $2,469,767 $2,531,511 $2,594,799 $2,659,669 $2,726,161 $2,794,315 $2,864,172 $2,935,777 $3,009,171
<br />$576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600
<br />($149,306)($152,318)($155,406)($158,570)($161,813)($165,138)($168,546)($172,039)($175,619)($179,289)
<br />$2,836,822 $2,894,049 $2,952,706 $3,012,829 $3,074,455 $3,137,623 $3,202,369 $3,268,734 $3,336,758 $3,406,483
<br />$1,194,410 $1,236,215 $1,279,482 $1,324,264 $1,370,613 $1,418,585 $1,468,235 $1,519,624 $1,572,810 $1,627,859
<br />$141,060 $145,997 $151,107 $156,396 $161,869 $167,535 $173,399 $179,468 $185,749 $192,250
<br />100%100%100%100%100%100%100%100%100%100%
<br />$1,501,352 $1,511,837 $1,522,116 $1,532,169 $1,541,973 $1,551,503 $1,560,735 $1,569,643 $1,578,199 $1,586,374
<br />$71,235 $73,728 $76,309 $78,980 $81,744 $84,605 $87,566 $90,631 $93,803 $97,086
<br />100%100%100%100%100%100%100%100%100%100%
<br />$67,104 $69,452 $71,883 $74,399 $77,003 $79,698 $82,487 $85,375 $88,363 $91,455
<br />$1,363,013 $1,368,656 $1,373,924 $1,378,790 $1,383,226 $1,387,200 $1,390,681 $1,393,637 $1,396,033 $1,397,832
<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 />$176,392 $182,035 $187,303 $192,169 $196,604 $200,579 $204,060 $207,016 $209,412 $211,211
<br />1.15 1.15 1.16 1.16 1.17 1.17 1.17 1.17 1.18 1.18
<br />$0
<br />$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 />$151,392 $157,035 $162,303 $167,169 $171,604 $175,579 $179,060 $182,016 $184,412 $186,211
<br />$52,420 $54,374 $56,198 $57,883 $59,419 $60,795 $62,000 $63,024 $63,853 $64,476
<br />$65,981 $68,441 $70,737 $72,858 $74,791 $76,523 $78,040 $79,328 $80,372 $81,156
<br />$32,991 $34,220 $35,368 $36,429 $37,395 $38,261 $39,020 $39,664 $40,186 $40,578
<br />Economic & Planning Systems, Inc. A-10 Appendix A
<br />Cont.
<br />8.A. - Page 119 of 168
<br />129
|