|
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 />Yr11 Yr12 Yr13 Yr14 Yr15 Yr16 Yr17 Yr18 Yr19 Yr20
<br />$2,294,538 $2,340,428 $2,387,237 $2,434,982 $2,483,681 $2,533,355 $2,584,022 $2,635,702 $2,688,416 $2,742,185
<br />$576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600 $576,600
<br />($143,557)($145,851)($148,192)($150,579)($153,014)($155,498)($158,031)($160,615)($163,251)($165,939)
<br />$2,727,581 $2,771,177 $2,815,645 $2,861,003 $2,907,267 $2,954,457 $3,002,591 $3,051,687 $3,101,766 $3,152,846
<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,392,110 $1,388,965 $1,385,056 $1,380,343 $1,374,784 $1,368,337 $1,360,957 $1,352,596 $1,343,206 $1,332,737
<br />$71,235 $73,728 $76,309 $78,980 $81,744 $84,605 $87,566 $80,601 $68,223 $54,660
<br />100%100%100%100%100%100%100%89%73%56%
<br />$67,104 $69,452 $71,883 $74,399 $77,003 $79,698 $82,487 $85,375 $88,363 $91,455
<br />$1,253,772 $1,245,784 $1,236,864 $1,226,964 $1,216,037 $1,204,034 $1,190,903 $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 />$67,150 $59,163 $50,243 $40,343 $29,416 $17,413 $4,282 $0 $0 $0
<br />1.06 1.05 1.04 1.03 1.02 1.01 1.00 1.00 1.00 1.00
<br />$0
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0
<br />$25,000 $25,000 $25,000 $25,000 $25,000 $17,413 $4,282 $0 $0 $0
<br />$42,150 $34,163 $25,243 $15,343 $4,416 $0 $0 $0 $0 $0
<br />$14,595 $11,829 $8,740 $5,313 $1,529 $0 $0 $0 $0 $0
<br />$18,370 $14,889 $11,002 $6,687 $1,925 $0 $0 $0 $0 $0
<br />$9,185 $7,445 $5,501 $3,343 $962 $0 $0 $0 $0 $0
<br />Economic & Planning Systems, Inc. A-14 Appendix A
<br />Cont.
<br />Table A-11. Scenario 3:
<br />Pre -1995 Cashflow
<br />8.A. - Page 123 of 168
<br />133
|