|
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 />Yr31 Yr32 Yr33 Yr34 Yr35 Yr36 Yr37 Yr38 Yr39 Yr40
<br />$3,409,562 $3,477,753 $3,547,308 $3,618,255 $3,690,620 $3,764,432 $3,839,721 $3,916,515 $3,994,845 $4,074,742
<br />$576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600
<br />($199,308)($202,718)($206,195)($209,743)($213,361)($217,052)($220,816)($224,656)($228,572)($232,567)
<br />$3,786,854 $3,851,636 $3,917,713 $3,985,112 $4,053,859 $4,123,980 $4,195,505 $4,268,459 $4,342,873 $4,418,775
<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 />$90,086 $67,013 $42,160 $15,447 $0 $0 $0 $0 $0 $0
<br />32%23%14%5%0%0%0%0%0%0%
<br />$1,320,143 $1,324,816 $1,329,653 $1,334,659 $1,326,627 $1,301,296 $1,274,026 $1,244,729 $1,213,313 $1,179,680
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0 $0
<br />0%0%0%0%0%0%0%0%0%0%
<br />$133,522 $138,195 $143,032 $148,038 $153,220 $158,582 $164,133 $169,877 $175,823 $181,977
<br />$1,186,621 $1,186,621 $1,186,621 $1,186,621 $1,173,408 $1,142,714 $1,109,894 $1,074,852 $1,037,490 $997,703
<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 ($13,213)($43,907)($76,727)($111,769)($149,131)($188,918)
<br />1.00 1.00 1.00 1.00 0.99 0.96 0.94 0.91 0.87 0.84
<br />$0 $0 $0 $0 $13,213 $43,907 $76,727 $111,769 $149,131 $188,918
<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-16 Appendix A
<br />Cont.
<br />Table A-11. Scenario 3:
<br />Pre -1995 Cashflow
<br />8.A. - Page 125 of 168
<br />135
|