|
<br />Annual Operating Proforma
<br />
<br />Hamline Commons
<br />
<br />5 Year Proforma
<br />
<br />Proforma
<br />
<br />Vcar Year Year Year Year Year
<br />I 2 3 4 5
<br />Units Rented 118 96 118 118 118 118
<br />Percent Occupancy 95% 78% 95% 95% 95%) 95%
<br />
<br />Third (Stabilized)
<br />
<br />"Revenues..
<br />Total/Average Independent
<br />TotaV Average Assisted
<br />TotaVAverage RetaiVCom
<br />Total/Average Office Space
<br />Garage
<br />Daycare rent
<br />Staff Meals
<br />Optional Meal Revenues
<br />2nd Occupant monthly income
<br />Misc. Income
<br />Debt Service Reserve Income @ 6%
<br />Unused
<br />Other lunit
<br />
<br />1,806,389 1,433,041 1,753,776 1.806,389 1,860,581 1.916,398
<br />993,178 787.906 964,250 993,178 1,022,973 1,053,662
<br />53,544 42,477 51.984 53,544 55,150 56,804
<br />
<br />2,936
<br />120,000
<br />
<br />2,329
<br />120,000
<br />
<br />2,850
<br />120,000
<br />
<br />2,936
<br />120,000
<br />
<br />3,024
<br />120,000
<br />
<br />3,114
<br />120,000
<br />
<br />TOIaI Revenue 2.976.046 2.185.752 2.892.860 2.976046 1.061.727 1.149979
<br />
<br />..Expenses..
<br />Social Services
<br />
<br />Staffing
<br />Activity Supplies [ndep
<br />Activity Programs Indep
<br />Activity Supplies Assisted
<br />Activity Programs [Assisted . .. .
<br />. . . . . . :T~iai:Se~i81:Sef:Vie:es::::::
<br />
<br />Dietary
<br />
<br />31,044 29,120 30,066 31,044 32,052 33,094
<br />1,279 1.200 1,239 1,279 1,321 1,364
<br />1,919 1,800 1,859 1,919 1,981 2,046
<br />:: /34;24i:: ::::3:2:1:20 :::::ri;:[6.4<: :::: 311;142:: ::35)55::: ::j:6;5.0~::::::::
<br />
<br />Staffing
<br />Dietary Supplies
<br />Dietary Consult
<br />Food
<br />Linen
<br />Minor Equip
<br />Chemicals
<br />
<br />.. -, ....
<br />
<br />:.:.:,::rqt~:Qi:.~.:.
<br />Housekeeping
<br />
<br />..
<br />
<br />. .
<br />
<br />. .
<br />
<br />..... .
<br />
<br />..
<br />
<br />...... ..
<br />
<br />. ..
<br />
<br />.. .
<br />
<br />, .
<br />
<br />.. ...
<br />
<br />.... .
<br />
<br />. ..
<br />
<br />... .
<br />
<br />..... .
<br />
<br />.. .
<br />
<br />...... .
<br />
<br />" ,
<br />
<br />..... .
<br />
<br />. . . . .
<br />
<br />Staffing
<br />Hskg Supplies
<br />LaundrylLinen Supplies
<br />Linen
<br />Floor Care
<br />Window washing
<br />Minor equip
<br />:::.::::::: :::;::::: ;T:i>j;;1 :r-iO:U~ke~piris::::
<br />Maintenance/Engineering
<br />
<br />.... ,.,
<br />
<br /> 23,283 21,840 22,550 23,283 24.039 24,821
<br /> 4.264 4,000 4,\30 4,264 4,403 4,546
<br /> 2.559 2,400 2,478 2,559 2.642 2.728
<br /> 2.132 2,000 2,065 2,132 2.201 2.273
<br /> 1.599 1,500 1,549 1,599 1,651 1.705
<br />. . :.:. :33;8:31:.: :31;140:: :3:2;1.'7i:::. ..,jj~ji: . . 34,~36 ::: . J);;an: -:' .... " . .
<br /> . .. .. . " . .
<br /> 63,196 59,280 61,207 63,196 65,250 67,370
<br /> 8,528 8,000 8,260 8,528 8,806 9,Q92
<br /> 4,797 4,500 4,646 4,797 4,953 5,114
<br /> 8,315 7,800 8.054 8,315 8.585 8,865
<br /> 5,597 5,250 5,421 5,597 5.779 5,966
<br />
<br />Staffing
<br />Maintenance Sup.
<br />Trash
<br />Purchased Services
<br />Building Repair
<br />Unused
<br />Unused
<br />Unused
<br />: tG!~i Mi!I~!14i1i:~~njji~.~(;~g::
<br />Utilities
<br />GaslHeat
<br />Electric
<br />WaterlSewer
<br />::r..;~i:!i\~,,~~::: ".
<br />Home Care
<br />Staffing
<br />Healthcare Supplies
<br />Heatthcare misc.
<br />
<br />..... .
<br />
<br />........ .
<br />, , . . . . . . . .'.:.:.-:.::90;4-34-:
<br />
<br />-:~;~JQ::
<br />
<br />::XI;~87:
<br />
<br />'90;4;>4
<br />
<br />: :9~:i,~:
<br />
<br />:9:6;~o1:
<br />
<br />. . . . . . . . . . .
<br />.."...... .
<br />. . . . . . . . . . .
<br />
<br />106,115
<br />152.099
<br />53.058
<br />:iii;i.'ij<-:
<br />
<br />99,540 102.775 106,115 109,564 1 \3,125
<br />142,674 147.311 152.099 157,042 162.146
<br />49,770 5 \,388 53,058 54.782 56,562
<br />:~~n;984::: jcil;~i3::: .:::j:ii,11.i: :::ii};jiili :~:!:I;!t:!:3:::
<br />
<br />.,
<br />
<br />.... .
<br />
<br />-.. -.
<br />
<br />Cont~~~ ~~:;t-I~~c~e, .
<br />:T~t~ll;iom~q.r... :.:.:.:
<br />Administration
<br />Staffing
<br />Employee Benefits
<br />License & Fees
<br />
<br />. . . . . . .
<br />
<br />......... .
<br />,.-... .-..
<br />.",..., "
<br />
<br />....,..., .
<br />.......,. .
<br />, . . . . . -, " . . , . .. ."..
<br />.... ."., ......
<br />
<br />..." .
<br />
<br />..- ,.
<br />.. .
<br />... ..,.,....
<br />
<br />.", "",.. .,.
<br />
<br />. .
<br />
<br />73,839
<br />47,840
<br />2,132
<br />
<br />69,264
<br />44,876
<br />2.000
<br />
<br />71,515
<br />46,334
<br />p~~6J 15
<br />
<br />73,839
<br />47,840
<br />2,132
<br />
<br />76,239
<br />49,395
<br />2,201
<br />
<br />78,717
<br />51,000
<br />2,273
<br />
|