|
TABLE 4
<br />CASH FLOW ANALYSIS
<br />FRANCIS XAVIER RESIDENCE
<br />SANTA ANA, CALIFORNIA
<br />I.Gross Residential Income 1
<br />Gross Affordable Rental Income
<br />VASH/COSR Subsidy
<br />(Less) Vacancy & Collection Allowance
<br />Effective Gross Base Income
<br />II.Operating Expenses 2
<br />General Operating Expenses
<br />Property Taxes
<br />HCD Mandatory Interest Payment
<br />Replacement Reserve
<br />Total Operating Expenses
<br />III.Net Operating Income
<br />(Less) Debt Service 3
<br />Net Income After Debt Service
<br />IV.Cash Flow Available for Contingent Payments
<br />(Less) Deferred Developer Fee
<br />V.Cash Flow after Contingent Payments
<br />Nominal Dollars
<br />VI.Residual Receipt Payments to NPLH Loan
<br />Nominal Dollars
<br />VII.Residual Receipt Payments to Authority Loan
<br />Nominal Dollars
<br />VIII.Residual Receipt Payments to Developer
<br />Nominal Dollars
<br />1
<br />2
<br />3
<br />The affordable rents and VASH/COSR subsidy are assumed to
<br />increase by 102.5%/year. Assumes Year 1 is at stabilization.
<br />General operating expenses are assumed to increase by
<br />103.5%/year, property taxes at 102.0%/year and replacement
<br />reserves remain constant.
<br />SEE TABLE 3
<br />Year 11 Year 12 Year 13 Year 14 Year 15 Year 16 Year 17 Year 18 Year 19 Year 20 Year 21 Year 22
<br />$51,587 $52,877 $54,199 $55,554 $56,943 $58,366 $59,826 $61,321 $62,854 $64,426 $66,036 $67,687
<br />151,178 154,957 158,831 162,802 166,872 171,044 175,320 179,703 184,196 188,801 193,521 198,359
<br />(20,278)(20,785)(21,304)(21,837)(22,383)(22,942)(23,516)(24,104)(24,706)(25,324)(25,957)(26,606)
<br />$182,488 $187,050 $191,726 $196,519 $201,432 $206,468 $211,630 $216,921 $222,344 $227,902 $233,600 $239,440
<br />$96,203 $99,570 $103,055 $106,662 $110,395 $114,259 $118,258 $122,397 $126,681 $131,115 $135,704 $140,453
<br />5,120 5,222 5,327 5,433 5,542 5,653 5,766 5,881 5,999 6,119 6,241 6,366
<br />13,965 14,454 14,960 15,483 16,025 16,586 17,166 17,767 18,389 19,033 19,699 20,388
<br />6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000
<br />$121,288 $125,246 $129,341 133,578 $137,962 $142,497 $147,190 $152,045 $157,069 $162,266 $167,643 $173,207
<br />$61,200 $61,804 $62,385 $62,941 $63,471 $63,971 $64,440 $64,876 $65,275 $65,636 $65,956 $66,232
<br />(45,905)(45,905)(45,905)(45,905)(45,905)0 0 0 0 0 0 0
<br />$15,295 $15,899 $16,480 $17,037 $17,566 $63,971 $64,440 $64,876 $65,275 $65,636 $65,956 $66,232
<br />$15,295 $15,899 $16,480 $17,037 $17,566 $63,971 $64,440 $64,876 $65,275 $65,636 $65,956 $66,232
<br />(15,295)(15,899)(16,480)(17,037)(17,566)(63,971)(64,440)(38,425)0 0 0 0
<br />$0 $0 $0 $0 $0 $0 $0 $26,450 $65,275 $65,636 $65,956 $66,232
<br />$0 $0 $0 $0 $0 $0 $0 $9,087 $22,426 $22,550 $22,660 $22,755
<br />$0 $0 $0 $0 $0 $0 $0 $4,138 $10,212 $10,268 $10,318 $10,361
<br />$0 $0 $0 $0 $0 $0 $0 $13,225 $32,638 $32,818 $32,978 $33,116
<br />Prepared by: Keyser Marston Associates, Inc.
<br />Filename: Francis Xavier Residence PF_1 9 19; CF; trb
<br />E
<br />X
<br />H
<br />I
<br />B
<br />I
<br />T
<br />
<br />3
<br />3
<br />-
<br />3
<br />3
|