|
TABLE 5
<br />NPLH/SNHP COSR ANALYSIS
<br />FRANCIS XAVIER RESIDENCE
<br />SANTA ANA, CALIFORNIA
<br />I.Number of COSR Units
<br />For Revenue
<br />NPLH Units (For COSR)8
<br />SNHP Units (For COSR)4
<br />Total Units 12
<br />For Expenses (Including Manager's Unit)17
<br />II.Gross Income 1
<br />1-Bedroom Units $249
<br />Laundry / Miscellaneous Income $26
<br />(Less) Vacancy Allowance 7.0%
<br />Effective Gross Base Income
<br />III.Operating Expenses 2
<br />General Operating Expenses $5,656
<br />Property Taxes $318
<br />Supportive Services $3,540
<br />NLPH Annual Fee
<br />SNHP Annual Fee
<br />Replacement Reserve $500
<br />Total Operating Expenses
<br />IV.Net Operating Income
<br />V.NPLH COSR 8 NPLH Units
<br />Beginning Balance
<br />Annual Withdrawal
<br />Interest @ 1.0%
<br />Ending Balance
<br />VI.SNHP COSR 4 SNHP Units
<br />Beginning Balance
<br />Annual Withdrawal
<br />Interest @ 1.0%
<br />Ending Balance
<br />1 Escalated at 102.5%/year.
<br />2
<br />Per Unit /
<br />Month
<br />Per Unit / Year
<br />General operating expenses and social services costs are
<br />escalated at 103.5/year; property taxes at 102.0%/year; and
<br />NPLH/ SNHP annual fees and replacement reserve deposits
<br />remain constant.
<br />Year 11 Year 12 Year 13 Year 14 Year 15 Year 16 Year 17 Year 18 Year 19 Year 20
<br />$45,899 $47,046 $48,222 $49,428 $50,664 $51,930 $53,228 $54,559 $55,923 $57,321
<br />4,793 4,912 5,035 5,161 5,290 5,422 5,558 5,697 5,839 5,985
<br />(3,548)(3,637)(3,728)(3,821)(3,917)(4,015)(4,115)(4,218)(4,323)(4,431)
<br />$47,143 $48,322 $49,530 $50,768 $52,037 $53,338 $54,671 $56,038 $57,439 $58,875
<br />$95,742 $99,093 $102,561 $106,151 $109,866 $113,712 $117,692 $121,811 $126,074 $130,487
<br />4,647 4,739 4,834 4,931 5,030 5,130 5,233 5,337 5,444 5,553
<br />59,920 62,017 64,188 66,435 68,760 71,166 73,657 76,235 78,903 81,665
<br />6,600 6,600 6,600 6,600 6,600 6,600 6,600 6,600 6,600 6,600
<br />7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500
<br />6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000
<br />$180,409 $185,950 $191,684 197,616 $203,756 $210,108 $216,681 $223,483 $230,522 $237,805
<br />($133,266)($137,628)($142,154)($146,849)($151,719)($156,770)($162,010)($167,445)($173,083)($178,930)
<br />$804,715 $723,030 $637,591 $548,250 $454,854 $357,245 $255,259 $148,725 $37,466 $0
<br />(88,844)(91,752)(94,769)(97,899)(101,146)(104,513)(108,007)(111,630)(37,466)0
<br />7,159 6,313 5,428 4,504 3,537 2,527 1,473 371 0 0
<br />$723,030 $637,591 $548,250 $454,854 $357,245 $255,259 $148,725 $37,466 $0 $0
<br />$300,684 $258,825 $215,078 $169,370 $121,625 $71,762 $19,701 $0 $0 $0
<br />(44,422)(45,876)(47,385)(48,950)(50,573)(52,257)(19,701)0 0 0
<br />2,563 2,129 1,677 1,204 711 195 0 0 0 0
<br />$258,825 $215,078 $169,370 $121,625 $71,762 $19,701 $0 $0 $0 $0
<br />Prepared by: Keyser Marston Associates, Inc.
<br />Filename: Francis Xavier Residence PF_8 27 21.xlsm; Combined COSR; trb 12 of 12
<br />EXHIBIT 3
|