|
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 />Yr21 Yr22 Yr23 Yr24 Yr25 Yr26 Yr27 Yr28 Yr29 Yr30
<br />$3,084,400 $3,161,511 $3,240,548 $3,321,562 $3,404,601 $3,489,716 $3,576,959 $3,666,383 $3,758,043 $3,851,994
<br />$576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600
<br />($183,050)($186,906)($190,857)($194,908)($199,060)($203,316)($207,678)($212,149)($216,732)($221,430)
<br />$3,477,950 $3,551,205 $3,626,291 $3,703,254 $3,782,141 $3,863,000 $3,945,881 $4,030,834 $4,117,910 $4,207,164
<br />$1,684,834 $1,743,803 $1,804,836 $1,868,005 $1,933,386 $2,001,054 $2,071,091 $2,143,579 $2,218,604 $2,296,256
<br />$198,979 $205,943 $213,151 $220,611 $228,333 $236,324 $244,596 $253,157 $262,017 $271,188
<br />100%100%100%100%100%100%100%100%100%100%
<br />$1,594,138 $1,601,459 $1,608,304 $1,614,637 $1,620,423 $1,625,622 $1,630,194 $1,634,098 $1,637,289 $1,639,721
<br />$100,484 $104,001 $107,641 $111,409 $115,308 $119,344 $123,521 $127,844 $132,319 $136,950
<br />100%100%100%100%100%100%100%100%100%100%
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br />$1,493,653 $1,497,458 $1,500,662 $1,503,228 $1,505,114 $1,506,278 $1,506,673 $1,506,254 $1,504,970 $1,502,771
<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 />$307,032 $310,836 $314,041 $316,607 $318,493 $319,657 $320,052 $319,633 $318,349 $316,150
<br />1.26 1.26 1.26 1.27 1.27 1.27 1.27 1.27 1.27 1.27
<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 />$282,032 $285,836 $289,041 $291,607 $293,493 $294,657 $295,052 $294,633 $293,349 $291,150
<br />$97,655 $98,972 $100,082 $100,970 $101,623 $102,026 $102,163 $102,018 $101,573 $100,812
<br />$122,918 $124,576 $125,973 $127,091 $127,913 $128,420 $128,593 $128,410 $127,850 $126,892
<br />$61,459 $62,288 $62,987 $63,546 $63,957 $64,210 $64,296 $64,205 $63,925 $63,446
<br />Economic & Planning Systems, Inc. A-7 Appendix A
<br />Cont.
<br />8.A. - Page 116 of 168
<br />126
|