|
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 />Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10
<br />II.Gross Income 1
<br />1-Bedroom Units $249 $35,856 $36,752 $37,671 $38,613 $39,578 $40,568 $41,582 $42,622 $43,687 $44,779
<br />Laundry / Miscellaneous Income $26 3,744 3,838 3,934 4,032 4,133 4,236 4,342 4,450 4,562 4,676
<br />(Less) Vacancy Allowance 7.0%(2,772)(2,841)(2,912)(2,985)(3,060)(3,136)(3,215)(3,295)(3,377)(3,462)
<br />Effective Gross Base Income $36,828 $37,749 $38,692 $39,660 $40,651 $41,668 $42,709 $43,777 $44,871 $45,993
<br />III.Operating Expenses 2
<br />General Operating Expenses $5,656 $67,873 $70,249 $72,708 $75,252 $77,886 $80,612 $83,434 $86,354 $89,376 $92,504
<br />Property Taxes $318 3,812 3,888 3,966 4,045 4,126 4,208 4,293 4,379 4,466 4,555
<br />Supportive Services $3,540 42,479 43,965 45,504 47,097 48,745 50,451 52,217 54,045 55,936 57,894
<br />NLPH Annual Fee 6,600 6,600 6,600 6,600 6,600 6,600 6,600 6,600 6,600 6,600
<br />SNHP Annual Fee 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500 7,500
<br />Replacement Reserve $500 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000 6,000
<br />Total Operating Expenses $134,264 $138,202 $142,277 $146,494 $150,857 $155,372 $160,043 $164,877 $169,878 $175,054
<br />IV.Net Operating Income ($97,436)($100,454)($103,585)($106,834)($110,206)($113,704)($117,334)($121,100)($125,007)($129,061)
<br />V.NPLH COSR 8 NPLH Units
<br />Beginning Balance $1,443,936 $1,392,769 $1,339,058 $1,282,701 $1,223,593 $1,161,623 $1,096,678 $1,028,640 $957,386 $882,788
<br />Annual Withdrawal (64,957)(66,969)(69,057)(71,223)(73,471)(75,803)(78,223)(80,733)(83,338)(86,040)
<br />Interest @ 1.0%13,790 13,258 12,700 12,115 11,501 10,858 10,185 9,479 8,740 7,967
<br />Ending Balance $1,392,769 $1,339,058 $1,282,701 $1,223,593 $1,161,623 $1,096,678 $1,028,640 $957,386 $882,788 $804,715
<br />VI.SNHP COSR 4 SNHP Units
<br />Beginning Balance $629,924 $603,420 $575,635 $546,517 $516,015 $484,072 $450,633 $415,636 $379,023 $340,727
<br />Annual Withdrawal (32,479)(33,485)(34,528)(35,611)(36,735)(37,901)(39,111)(40,367)(41,669)(43,020)
<br />Interest @ 1.0%5,974 5,699 5,411 5,109 4,793 4,462 4,115 3,753 3,374 2,977
<br />Ending Balance $603,420 $575,635 $546,517 $516,015 $484,072 $450,633 $415,636 $379,023 $340,727 $300,684
<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 />Prepared by: Keyser Marston Associates, Inc.
<br />Filename: Francis Xavier Residence PF_8 27 21.xlsm; Combined COSR; trb 11 of 12
<br />EXHIBIT 3
|