|
ANOKA COUNTY KRA
<br /> " City of Centerville Senior Housing - Draft Numbers Only - Current Rent Assumptions
<br /> Cash Flows - Income, Expenses and Debt
<br /> N
<br /> M
<br /> m
<br /> CASH FLOW -INCOME _
<br /> N 7998 7999 2904 2-091 200 .. 2003_ 2004 - - -- 2.00_2` 21
<br /> 1 RENTAL REVENUE 78,880 118,320 120,686 123,100 125,562 128,073 130,635 133,240 135,412
<br /> 2 INTERE INCOME (+-) O O O O
<br /> 3 GROSS REVENUE 78,880 1 18,320 120,686 723,100 125,562 728,373 130,635 "133,248 735,912
<br /> 4 VACANCIES ( -) 23,664 11,832 8,448 $,677 $,789 8,965 9,144 9,327 9,5 _
<br /> 5 NET INITIAL REVENUE 55,276 706,485 712 ?38 114,483 116,773 119,108 121,493 123,920 126,399
<br /> 1 6 HRA LEVY (�) 8_ 000 8.000 8,000 8, 000 8,000
<br /> 000 8,000 8;000 8, 8,0 00
<br /> 7 EFFECTIVE INC OME 63,218 174 ,488 720,238 722,483 124,773 127,10 129,490 131,920 134,349
<br /> z -
<br /> 8
<br /> ° 9 CASHFLOW - EXPENSES AND DEBT _
<br /> } 10
<br /> R _1 ��9 2044 ?001 2_043 2.403 2004 zQ05 2400
<br /> PE l fLyL
<br /> 12 OPERATING EXP. ( -) 4,050 4.211 4,380 4,555 4,737
<br /> ° 13I GENERAL ADMINISTRATIVE 225 2,400 3,600 3,744 3.894 °
<br /> 110 1,173 1,0 1,904 1,950 2,059 2,141
<br /> 760 1,83 2,227 2- 316
<br /> 14 INSURANCE 4,949 5,147 5,353 5,567 `'
<br /> 151 SALARIES 275 2,933 4,400 4,576 4,759
<br /> 612 5,724 5,839 5,955 6,075 6,196 6.342'
<br /> 16 MANAGEMEN 'r FEE 333 3,550 5,324 5, 666 692 720 749 779 $10 8 *=
<br /> - . 17I PAYING AGENT 40 427 640
<br /> 18 CONTRACTS 150 1.,600 2,400 2,496 2,596 2.700 2,808 2,923 3,037 3
<br /> 19� ELECTRICITY 100 1,067 1,600 1,664 1,731 1.800 1,872 1,947 2,025 2, 105
<br /> 800 1 ?O0 1 ,248 1,299 1 ,350 1,404 1.460
<br /> t,518 1.573
<br /> 201 SMATER/SEWERITRASH 75 4,992 5,192 5,399 5,615 5,840 6,074 66,316
<br /> 21 GAS 300 3,200 4,800
<br /> 700 2,838
<br /> - 150 1,600 2,400 2,496 2,596 2, 2,920 "5,037 3,1
<br /> 22 REPAIRS 8 MAMT. 40]
<br /> .' p 2,400 2,400 2,400 2,400 2,400 2,400 5715
<br /> 23I REPLACEMENT( -) 150 O 313 5,477 5,511
<br /> 24 5.812
<br /> 2,507 4,944 5,217 5, 4,000 4, 000
<br /> �n 25 L PILOT 309 HRA MAN AGEMEN T FEE 4,030 4,000 4_ -1 4.0 4 ,070 -
<br /> a
<br /> 26;TOTAL EXPENSES 2,467 �27,m16 34,832 40,668 41,001 43,199 44,439 45,725 47,057 48,433
<br /> w
<br /> 27 -
<br /> c+ 2S INET O INCOME __ _ 41,800 _ 79,85679,57 80482 8_7 82,669 83,785 E4, %63 85, 6v
<br /> f 30ICASHFLQW AVAIL. FOR BONDS _41,800 79, 856 79,570 80,482 81,574 _ 82 ,669 83. _PA,863
<br /> 37 (G O.j BONDS DEBT SERVICE ( -) 3 7,745 _90,4 89,515 89,125 93,420 92,460 9'0,480 5 ;,230 93,955
<br /> o e - 4,055 (70,5 (1 p,2 d5) ( 8,643) (4 (9,791 (12,775)
<br /> 3 88 {10,3b7) (7,93
<br /> - 2 CA SH F'LCIVY AFTER FINANCING at 931° __ °� v 87% 89%
<br /> 33 �EBT SERV{CE COVERA _ _^ _ % 89,0
<br /> 90/0 -
<br /> 34�EX,TRA QiTY PLEDGE TO 11 %DS 1 9_683 _ 7,556 21188 19,037 22.363 - 19,890 1;
<br /> 19,226 1 , 7) (826)
<br /> --
<br /> 35 CAS FFLO at 100 %O ccuparac y _ _ 1,198, (1,797) ( 26) 53,0 (3,570) f (1
<br /> o -
<br /> u
<br /> m
<br /> F-
<br /> x
<br /> 0
<br /> t
<br /> m
<br /> X
<br /> }
<br /> m
<br /> z prepare
<br /> b Ehlers /Publico n1anokhra1961*kCEE
<br /> w 06f17/97 12:08 PM eP y rp, kr7c. - Estimates Subject to Change
<br />
|