|
ANOKA COUNTY HRA
<br /> u City of Centerville Senior Housing - Draft Numbers Only - Current Rent Assumptions
<br /> 01 Cash Flows - Income, Expenses and Debt •
<br /> OJ
<br /> CO
<br /> w
<br /> v CASH FLOW - INCOME
<br /> - 1998 1.990 2990 7 001 2002 2003 2094 Zo 2Q9
<br /> 1 RENTAL REVENUE 78,880 118,320 120,686 123,100 125,562 128,073 130,6355 133,248 135,912
<br /> 2 INTEREST INCOME ( +) 0 0 0 0 0
<br /> 5,912
<br /> 3 GROSS REVENUE 78,880 118,320 120,686 123,100 125,562 128,073 130,635 139328 139912
<br /> 4 VACANCIES ( -) 23,664 11,832 8,448 8,617 8,789 8,965 9,t44
<br /> 5 NET INITIAL REVENUE 55,216 106,488 112,238 114,483 116,773 119,108 121,490 123,920 126,399
<br /> 1 6 HRA LEVY (4-) 8,000 8,000 8,900 8,000 8,000 8,000 8,000 8,000 8,000
<br /> 7 EFFECTIVE INCOME 63,216 114,488 120,238 122,483 124,773 127,108 129,490 131,920 134,399
<br /> g 8
<br /> a
<br /> a 9 CASHFLOW - EXPENSES AND DEBT
<br /> 1 Q 1999 7-0052 2041 2002 2003 29_Q4 2005
<br /> h- 11 + PER Ubla 1998
<br /> 0 12 OPERATING EXP. ( -)
<br /> o 13 GENE RAL A DMINISTRATIVE 225 2,400 3,600 3,744 3,894 4,050 4,211 4,380 4,555 4,73
<br /> o 110 1,173 1,760 1,830 1,904 1,980 2,059 2,141 2,227 2316
<br /> 14 INSURANCE 4,400 4,576 4,759 4,949 5,147 5,353 5567 5,790
<br /> 15 SALARIES 275 2,933
<br /> 1 6 MANAGEMENT FEE 333 3,550 5,324 5.612 5,724 5,839 5,955 6,075 6,196 6.320
<br /> 17 PAYING AGENT - 40 427 640 666 692 720 749 779
<br /> 18 CONTRACTS 150 1.,600 2,400 2,496 2,596 2,700 2,808 2,920 3,037 3,153
<br /> 19 E
<br /> 1 LECTRICITY 100 1,067 1,600 1,664 1,731 1,800 1,872 1,947 2,025 2,105
<br /> 1,200 1248 1,298 1,350 1,404 1,460 1,518 1,579
<br /> .. 2 21 R1 GATER/SEWER/TRASH 75 800
<br /> EP 300 3,200 4,800 4,992 5,192 5,399 5,615 5,840 6,074 6,316
<br /> _ 15 1
<br /> 22 REPAIRS & MAINT. 15Q 1,600 2,400 2,496 2,596 2,700 2,808 2,920 3,037 3,1
<br /> 1400
<br /> 2,400
<br /> 23 REPLACEMENT (-) 0 0 -) 2,400 2,400 2,400 2,400 2,400 2,454000
<br /> 24 PILOT 309 2,507 4.944 5,217 5,313 5,411 5,511 5,612 50 0 4,000 _-
<br /> in 25 HRA MANAGEMENT FEE 250 2,667 4,000 4,000 4,000 4,000 4,000 4,000
<br /> i
<br /> v 26 i TOTAL EXPENSES 7 2,467 21,416 34,532 40,668 42,001 43,199 44,439 45,26 47,057 48,435
<br /> m 27 765 84,583 85,960 _
<br /> r J 28 NET OPERATING INCOME _41,800 _ 79,856 79,570 80,482 81,574 82,669 83, 29 80,482 81,574 82,669 83,765 -- --
<br /> 85,900.__
<br /> 30 CASHFLOW AVAIL FOR BONDS 41,800 79,85 __ 51 -
<br /> (0.0.) _ 7,745 90,490 89,80 95,230 93,955
<br /> o- 32 CASH FLOW AFTER FINANCING at 95% (9,791) 99
<br /> N 31 (G0) BONDS DEBT SERVICE (-) 3 90 815 89,125 93,420 92,460 96A
<br /> � 4,055 {10,634) (10,245) (8,643) {11,846) ( ) 12,715) {10,357) (7,
<br /> 33
<br /> •
<br /> 88% 89% 90% 87% 89% 87% 89% 91%
<br /> EXTRA SERVICE COVERAGE _ -
<br /> ° 34 EXTRA CITY PLEDGE TO 110 %DSC 19_683 19,226 17,556 21,188 19,037 22,363 19,890 17a 9_
<br /> a 35 CASH FLOW a t 100% Occupancy 27,719 1,198 (1,797) (26) (3,057) (826) (3,570) (1_340) 1p
<br /> 0
<br /> o
<br /> N
<br /> 0
<br /> H
<br /> 'X
<br /> o
<br /> L
<br /> L
<br /> 0
<br /> X
<br /> •}
<br /> co
<br /> H
<br /> Prepared by EhlerslPUblicorp, Inc. - Estimates Subject to Change n:lanokhra196hsgCcl
<br /> !i! 06/17/97 12:08 PM
<br />
|