|
Cont.
<br />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 />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 />$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br />$1,430,117 $1,438,108 $1,445,807 $1,453,189 $1,460,229 $1,466,898 $1,473,169 $1,479,012 $1,484,395 $1,489,287
<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 />$243,496 $251,487 $259,186 $266,568 $273,607 $280,277 $286,548 $292,391 $297,774 $302,666
<br />1.21 1.21 1.22 1.22 1.23 1.24 1.24 1.25 1.25 1.26
<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 />$218,496 $226,487 $234,186 $241,568 $248,607 $255,277 $261,548 $267,391 $272,774 $277,666
<br />$75,655 $78,422 $81,088 $83,644 $86,081 $88,391 $90,562 $92,585 $94,449 $96,143
<br />$95,227 $98,710 $102,066 $105,283 $108,351 $111,257 $113,990 $116,537 $118,883 $121,016
<br />$47,614 $49,355 $51,033 $52,641 $54,175 $55,629 $56,995 $58,268 $59,442 $60,508
<br />Economic & Planning Systems, Inc. A-6 Appendix A
<br />8.A. - Page 115 of 168
<br />125
|