|
TABLE 4
<br />CASH FLOW ANALYSIS
<br />FRANCIS XAVIER RESIDENCE
<br />SANTA ANA, CALIFORNIA
<br />I.Gross Residential Income 1
<br />Tenant-Paid Income
<br />PBV Subsidy Income
<br />NPLH COSR
<br />SNHP COSR
<br />(Less) Vacancy Allowance
<br />Effective Gross Base Income
<br />II.Operating Expenses 2
<br />General Operating Expenses
<br />Property Taxes
<br />Supportive Services
<br />NLPH Annual Fee
<br />SNHP Annual Fee
<br />Replacement Reserve
<br />Total Operating Expenses
<br />III.Net Operating Income
<br />V.Cash Flow Available for Residual Receipts Payments
<br />Nominal Dollars
<br />VI.Residual Receipt Payments to NPLH Loan 4
<br />Nominal Dollars
<br />VII.Residual Receipt Payments to SNHP Loan 4
<br />Nominal Dollars
<br />VII.Residual Receipt Payments to OCHTF Loan 4
<br />Nominal Dollars
<br />IX.Residual Receipt Payments to Authority Loan 4
<br />Nominal Dollars
<br />X.Residual Receipt Payments to Developer
<br />Nominal Dollars
<br />1
<br />2
<br />3
<br />4
<br />The affordable rents and VASH subsidy are assumed to increase by
<br />102.5%/year. The SNHP income is increased by 101.0%/year.
<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 />Based on pro rata share of 50% of Residual Receipts.
<br />Year 18 Year 19 Year 20 Year 21 Year 22 Year 23 Year 24 Year 25 Year 26
<br />$80,950 $82,974 $85,048 $87,174 $89,354 $91,588 $93,877 $96,224 $98,630
<br />80,494 82,506 84,569 86,683 88,850 91,071 93,348 95,682 98,074
<br />111,630 37,466 -
<br />- - -
<br />(11,301)(11,584)(11,873)(12,170)(12,474)(12,786)(13,106)(13,433)(13,769)
<br />$261,773 $191,362 $157,744 $161,687 $165,729 $169,873 $174,119 $178,472 $182,934
<br />$172,648 $178,690 $184,945 $191,418 $198,117 $205,051 $212,228 $219,656 $227,344
<br />7,561 7,713 7,867 8,024 8,185 8,348 8,515 8,686 8,859
<br />93,079 96,337 99,709 103,199 106,811 110,549 114,418 118,423 122,568
<br />11,845 12,259 12,689 13,133 13,592 14,068 14,560 15,070 15,597
<br />7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500
<br />8,500 8,500 8,500 8,500 8,500 8,500 8,500 8,500 8,500
<br />$301,133 $311,000 $321,209 $331,773 $342,705 $354,017 $365,722 $377,835 $390,369
<br />($39,361)($119,637)($163,465)($170,086)($176,976)($184,144)($191,603)($199,362)($207,435)
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0
<br />$0 $0 $0 $0 $0 $0 $0 $0 $0
<br />Prepared by: Keyser Marston Associates, Inc.
<br />Filename: Francis Xavier Residence PF_8 27 21.xlsm; CF_w 3 PBV; trb 6 of 12
<br />EXHIBIT 3
|