|
Cash Flow Escalator
<br />Tenant Rents 2.00%
<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 />$2,797,029 $2,852,969 $2,910,028 $2,968,229 $3,027,594 $3,088,145 $3,149,908 $3,212,907 $3,277,165 $3,342,708
<br />$576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600
<br />($168,681)($171,478)($174,331)($177,241)($180,210)($183,237)($186,325)($189,475)($192,688)($195,965)
<br />$3,204,947 $3,258,091 $3,312,297 $3,367,588 $3,423,984 $3,481,508 $3,540,183 $3,600,031 $3,661,076 $3,723,343
<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 $208,014 $195,357 $181,411 $166,114 $149,402 $131,207 $111,459
<br />100%100%100%94%86%77%68%59%50%41%
<br />$1,321,134 $1,308,344 $1,294,310 $1,291,568 $1,295,241 $1,299,043 $1,302,978 $1,307,050 $1,311,265 $1,315,628
<br />$39,857 $23,754 $6,291 $0 $0 $0 $0 $0 $0 $0
<br />40%23%6%0%0%0%0%0%0%0%
<br />$94,656 $97,969 $101,398 $104,947 $108,620 $112,422 $116,357 $120,429 $124,644 $129,007
<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 />$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 />$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br />1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00 1.00
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br />Economic & Planning Systems, Inc. A-15 Appendix A
<br />Cont.
<br />Table A-11. Scenario 3:
<br />Pre -1995 Cashflow
<br />8.A. - Page 124 of 168
<br />134
|