|
NOKA COUNTY MRA 1
<br /> ty of Centerville Senior Housing - Draft Numbers Only - Current Rent Assumptions I. $251month 1
<br /> 7sh Flows - Income, Expenses and Debt
<br /> CASH FLOW - INCOME
<br /> I
<br /> 1 928. 1942 2009 2001 2 002 2003 2024 244;2 2aos 2442
<br /> 1 RENTAL REVENUE 82,080 123,120 125,582 126,094 130,656 133,269 135,934 138,653 141,426 144,255
<br /> 2I I VE NC E ( +) - O O 0 0 - O O O 0 6 - -0
<br /> 3 GROSS REVENUE 82,080 723,120 125,582 128,094 J 130,656 733,269 135,934 138,653 141,426 144,255
<br /> 4 V ACANCIE S ( - ) 24,6 12,312 8,791 8,967 9,146 9,329 9, 515 9,705 9,900 10,098
<br /> 5 NET INITIAL REVENUE 57,456 790,808 1'16,792 119,127 121,510 123,940 126,410 128,947 .131,526 134,157
<br /> 6 HRA LEVY ( +) 8,00 8,000 8,000 8,00 S,DOO 8 ,000 8000 8000 8 8.000
<br /> 7 EFFECTIVE IN _ 65,456 X18,808 924,792 1!.27,127 129,5'10 131,940 134,419 136,941 139,526 142,15
<br /> 8
<br /> 9 CASHFLOW - EXPENSES AND DEBT
<br /> 10 _ --
<br /> 17 F'�R_1Z 1998 3.9.8 -9 2SZOQ 2401 _202 2S)D 20_04 2445 3906 2407
<br /> 12 OPERATING EXP. ( -)
<br /> 13l GENERAL ADMINISTRATIVE 225 2,400 3,600 3,744 3,894 4,050 4,211 4,380 4,555 4,737 4,927
<br /> 14 INSURANCE 110 1,173 1,760 1,830 1,904 1,980 2,059 2,141 2,227 2,316 2,409
<br /> 15 SALARIES 275 2,933 4,400 4,576 4,759 4,949 5,147 5,353 5,567 5,790 6,022
<br /> 15, MANAGEMENT FEE 346 3,694 5,540 5,840 5,956 6,076 6,197 6,321 6,447 6,576 6,708
<br /> 171 PAYING AGENT 40 427 640 666 692 720 749 779 610 842 876
<br /> 18 CONTRACTS 150 1,600 2,400 2,496 2,596 2,700 2,808 2,920 3,037 3,158 3,285
<br /> 19 ELECTRICITY 100 1,067 1,600 1,664 1,731 1,800 7,872 1,947 2,025 2.105 2
<br /> 20 WATERISEWER/TRASH 75 800 1,200 1,248 1,298 1,350 1,404 - 1,460 1,518 1,579 1,642
<br /> 21 GAS 300 3,200 4,600 4,992 5,192 5,399 5,515 5,840 6,074 6316 6,5691
<br /> 22 REPAIRS & MAINT. 150 1,600 2,400 2,496 2,595 2,700 2,808 2,920 3.037 3,158 3,2851
<br /> 231 REPLACEMENT ( -) 150 0 0 2,400 2,400 2,400 2,400 2,400 2,400 2,400 2,400
<br /> 241 PILOT 323 2,619 5,160 5,444 5,545 5,648 5,752 5,859 5967 6,0761
<br /> 25 HRA M ANAGE ME NT FEE 250 2,667 4 4,000 4,000 _ 4,000 4, 000 4 ,000 4,000 __ 4,000 4,00
<br /> 25 TOTAL EXPENSES 2,494 21 3
<br /> ,560 4,960 _ 41,112 4 43,668 44,918 46,213 47,555 48,946 50,3871
<br /> 2P N ET OP ERATING INCO 43, 8 3,848 83,68 84,6 8 8 7,022 88,206 89,342 90 ,Sb0 ,_91,7769;
<br /> 1
<br /> CASH A FOR BONDS 43,896 8 3,848 83 ,68 0 84,666 _ 85, 842 87,022 68,20 69,392 9C _ 97.769
<br /> 31 '(G. O.) B ONDS .7 EBTSERVICE ( -) 3 90,490 89,815 89,725 93, 420 _ 92,4 95,230 53,95 J 97,655
<br /> 7
<br /> 32'CASH FLOW AFTR FINANCING at 93 °I 6
<br /> 6,151 ,642 - _(6135 ) 459 _ __ )__ ( ) ( ) 274 5,638) (3,3 ?5j _ - {5886
<br /> E ( ) (4, 5,438 ( ) _
<br /> 33M SERVICE COVE _ 93% 93% 95% 92% 94% 96 %_ 94/0
<br /> 34 EX�TRAC1T PLEI?GE TO °f CSC _ 15,691 15,11 - 13,371 '16, 920 'I 4,684 _ _ 1_7,_922_ __ 15,361 _ ._2.710
<br /> � _15,651
<br /> 35 �� SH FLOYV at 100% Occupanc 30,7 5,6 70 2 ,655 4 ,508 . 1,568 3, 891 1 ,241 - 3,868 6,525 - 4,2121
<br /> 1 7/97 12:08 PM Prepared by Ehlers /Publicorp, Inc. - Estimates Subject to Change 0a(1*khta06ns910ENTER7E3 -WK4
<br />
|