|
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 47 Year 48 Year 49 Year 50 Year 51 Year 52 Year 53 Year 54 Year 55
<br />$125,488 $128,625 $131,841 $135,137 $138,515 $141,978 $145,528 $149,166 $152,895
<br />367,746 376,939 386,363 396,022 405,923 416,071 426,472 437,134 448,063
<br />(49,326)(50,559)(51,823)(53,119)(54,447)(55,808)(57,203)(58,633)(60,099)
<br />$443,908 $455,006 $466,381 $478,040 $489,991 $502,241 $514,797 $527,667 $540,859
<br />$331,925 $343,543 $355,567 $368,012 $380,892 $394,223 $408,021 $422,302 $437,082
<br />10,444 10,653 10,866 11,083 11,305 11,531 11,761 11,997 12,237
<br />48,183 49,869 51,615 53,421 55,291 57,226 59,229 61,302 63,447
<br />6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000
<br />$396,552 $410,065 $424,047 $438,516 $453,487 $468,980 $485,011 $501,600 $518,766
<br />$47,356 $44,941 $42,334 $39,525 $36,504 $33,261 $29,786 $26,067 $22,093
<br />0 0 0 0 0 0 0 0 0
<br />$47,356 $44,941 $42,334 $39,525 $36,504 $33,261 $29,786 $26,067 $22,093
<br />$47,356 $44,941 $42,334 $39,525 $36,504 $33,261 $29,786 $26,067 $22,093
<br />0 0 0 0 0 0 0 0 0
<br />$47,356 $44,941 $42,334 $39,525 $36,504 $33,261 $29,786 $26,067 $22,093
<br />$16,270 $15,440 $14,544 $13,579 $12,541 $11,427 $10,233 $8,956 $7,590
<br />$7,408 $7,031 $6,623 $6,183 $5,711 $5,203 $4,660 $4,078 $3,456
<br />$23,678 $22,471 $21,167 $19,762 $18,252 $16,631 $14,893 $13,033 $11,046
<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 />6
|