|
<br />Monthly Operating Cash Flow Analysis
<br />Hamline Commons
<br />First Year Operating
<br />
<br />Proforma
<br />
<br />Month ~Ionth ~Ionth ~lonth Month ~lonth ~lonth Month ~Ionth Month Month Month Year I
<br />I 2 3 4 5 6 7 8 9 10 I I 12 T otnl
<br />Units Rented 37 52 67 82 97 113 118 118 118 118 118 118
<br />Percent Occupancy 30% 42% 54% 66% 79% 91 % 95% 95% 950/0 95% 95% 95% 78%
<br />
<br />".Revenuesa...
<br />TotaVAverage Independent 45,655 64,470 83,285 102,100 120,914 139,729 146,148 146,148 146,148 146,148 146,148 146,148 1,433,041
<br />Total/Average Assisted
<br />TotaVAverage RetaiVCom 25,102 35,447 45,791 56,136 66,480 76,825 80,354 80.354 80,354 80,354 80,354 80.354 787.906
<br />Total/Average Office Space
<br />Garage 1,353 1.911 2,469 3,026 3,584 4.142 4,332 4,332 4,332 4,332 4,332 4,332 42,477
<br />Daycare rent
<br />Staff Meals
<br />Optional Meal Revenues
<br />2nd Occupant monthly income
<br />Misc. Income 74 105 135 166 196 227 238 238 238 238 238 238 2,329
<br />Debt Service Reserve Income @ ( 10.000 10.000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 120,000
<br />Unused
<br />Other /unit
<br />
<br />Tot;I'Revecnue 82185 "1.932 141.630 171.428201.175 230923 24107~ 241.072241.072241.072241.0722410722.385.752
<br />
<br />UExpenn,..
<br />Social Service,
<br />
<br />Staffing
<br />Activity Supplies Indep
<br />Activity Programs Indep
<br />Activity Supplies Assisted
<br />Activity Programs IAssisted
<br />.:-:::.:: Totlil Sod.1 'S.frio...:-:.:.
<br />Dietary
<br />
<br />Staffing
<br />Dietary Supplies
<br />Dietary Consult
<br />Food
<br />Linen
<br />Minor Equip
<br />Chemicals
<br />::ro;ip;~::::
<br />
<br />Housekeeping
<br />
<br />Staffing
<br />Hskg Supplies
<br />Laundry/Linen Supplies
<br />Linen
<br />Floor Care
<br />Window washing
<br />Minor equip
<br />.. ::::~~~D;:fI~~~~~~p'i~::: ..
<br />Maintenance/Engineering
<br />Staffing
<br />Maintenance Sup.
<br />Trash
<br />Purchased Services
<br />Building Repair
<br />Unused
<br />V nused
<br />
<br />Unused
<br />:: Tqi1i!: M~iR!~R~til'A!g;~eiiAIi:::::
<br />Utilities
<br />GaslHeat
<br />Electric
<br />WaterlSewer
<br />.. ::1~i\.1\rriliii,;C
<br />
<br />Home Care
<br />
<br />Staffing
<br />Healthcare Supplies
<br />Healthcare misc.
<br />Healthcare Ed
<br />Conlracl Healthcare
<br />.'.:,:::::: ::t~laf~!i1.:<;iii~:::
<br />Administration
<br />
<br />S taffi n g
<br />Employee Benefiu
<br />License & fees
<br />
<br />.. .
<br />
<br />2,427 2,427 2.427 2,427 2,427 2,427 2,427 2.427 2,427 2.427 2.427 2.427 29,120
<br />100 100 100 100 100 100 100 100 100 100 100 100 1,200
<br />150 150 150 150 150 150 150 150 150 150 150 150 1,800
<br />: '2;57-7,:,:,: :-2;67]: <2~ci#::::: :-:-2;(;7'7.-: <:::~,~1i: <-:'l.61.7. :-:-:-: <2;677: 2~6#::::. :::2;67:7: :.:.::i,cin: :-:::-:2;67]:':- :::::2~6ii::: :::::jZ,:I~O<
<br />
<br />.
<br />
<br />-
<br />
<br />1,820 1,820 1,820 1,820 1.820 1,820 1,820 1,820 1,820 1,820 1,820 1,820 21.840
<br />333 333 333 333 333 333 333 333 333 333 333 333 4.000
<br />200 200 200 200 200 200 200 200 200 200 200 200 2,400
<br />167 167 167 167 167 167 167 167 167 167 167 167 2.000
<br />125 125 125 125 125 125 125 125 125 125 125 125 1.500
<br />::::::2;54:5: .. . ::;?~~:: :::::::2;5i5: . . ::::2;645::: . . ::2;645::: :!,64S::: .. ;:2;6~,( ::::2:,54:5: ';':';.:2:64:5 :-:,2',045,:- -:.::i6~5:::- -:,2;64-5::' :::1i;740:
<br />. . . . . . . . .
<br />4,940 4,940 4.940 4,940 4,940 4,940 4,940 4,940 4,940 4,940 4,940 4,940 59,280
<br />667 667 667 667 667 667 667 667 667 667 667 667 8,000
<br />375 375 375 375 375 375 375 375 375 375 375 375 4,500
<br />650 650 650 650 650 650 650 650 650 650 650 650 7,800
<br />438 438 438 438 438 438 438 438 438 438 438 438 5,250
<br />
<br />::::7:,P~~:::: :::::'1;Q69::: ::::::7:,P~~ :-::M~()': :::::1;Q<i~::: :-::::7.Q~9:::: -:.:.:7;069:-: i,p~~:: :'1;Q69::-: :::::7:,P~9:::: :::::'7;Q69< 7;P~~:::::: ~4)W
<br />
<br />8,295
<br />11.890
<br />4,148
<br />::.::::::::::::?;4;~~:(
<br />
<br />8,295 8,295 8,295 8,295 8,295 8,295 8,295 8,295 8,295 8,295 8,295 99,540
<br />11.890 II ,890 11,890 11.890 11,890 11,890 11.890 11,890 11.890 11,890 11,890 142,674
<br />4,148 4,148 4,148 4,148 4,148 4,148 4,148 4,148 4,148 4,148 4,148 49,770
<br /> . . . . . . . . . )~;~~~:::: :)4;i3~>::: :::~4;i3~: ::::~632:
<br />:~4)31: : :::::t4;~31:: ::::::~;~~:: :::~4:.~~2::: ::~~~~~:::: : : :: ~.~~?~~: : ::::$~~~~::: ::>::;iJl)Ii/4::
<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 />5,772
<br />3,740
<br />167
<br />
<br />5.772
<br />3,740
<br />167
<br />
<br />69,264
<br />44,816
<br />2.000
<br />
<br />5,772
<br />3.740
<br />167
<br />
<br />5,772
<br />3,740
<br />167
<br />
<br />5,772
<br />3,740
<br />167
<br />
<br />5,772
<br />3,740
<br />P~~e 11
<br />
<br />5,772
<br />3,740
<br />167
<br />
<br />5,772
<br />3,740
<br />167
<br />
<br />5,772
<br />3,740
<br />167
<br />
<br />5,772
<br />3,740
<br />167
<br />
<br />5,772
<br />3,740
<br />167
<br />
<br />5,772
<br />3,740
<br />167
<br />
|