|
<br />Proforma
<br />
<br />Monthly Operating Cash Flow Analysis
<br />Hamline Commons
<br />Second Year Operating
<br />
<br />~lonth Month Month ~Ionth Month ~Ionth Month Month ~lonth Month ~Ionth ~Ionth Year 2
<br />13 14 IS 16 17 18 19 20 21 n 23 24 Total
<br />Umts Rented 118 118 118 118 118 118 118 118 118 118 118 118
<br />Percent Occupancy 95% 95% 95% 95% 95% 95% 95% 95% 95% 95% 95% 95%
<br />
<br />..Revenues..
<br />
<br />Total/Average Independent 146.148 146,148 146,148 146,148 146,148 146,148 146,148 146,148 146,148 146.148 146,148 146,148 1.153,776
<br />TotaVAverage Assisted
<br />TotaVAverage RetaiVCom 80,354 80,354 80,354 80,354 80,354 80,354 80,354 80,354 80,354 80,354 80,354 80,354 964,250
<br />TotaUAverage Office Space
<br />Garage 4,332 4,332 4,332 4.332 4,332 4,332 4,332 4,332 4,332 4,332 4,332 4,332 51,984
<br />Daycare rent
<br />StatT Meals
<br />
<br />Optional Meal Revenues
<br />2nd Occupant monthly income
<br />Misc. Income
<br />Debt Service Reserve Income @
<br />Unused
<br />Other /unit
<br />
<br />238
<br />10.000
<br />
<br />238
<br />10,000
<br />
<br />238
<br />10,000
<br />
<br />238
<br />10,000
<br />
<br />238
<br />10,000
<br />
<br />238
<br />10.000
<br />
<br />238
<br />10,000
<br />
<br />238
<br />10,000
<br />
<br />238
<br />10.000
<br />
<br />238
<br />10,000
<br />
<br />238
<br />10,000
<br />
<br />2,850
<br />120,000
<br />
<br />238
<br />10.000
<br />
<br />Total Revenue 241 072 241.072 241.072 241.072 241.072 241.072 241 072 241.072 241.072 241 072 241.072 241.072 2.8CJ2.860
<br />
<br />.-Expenses..
<br />Social Service,
<br />
<br />Staffing
<br />Activity Supplies Indep
<br />Activity Programs Indep
<br />Activity Supplies Assisted
<br />Activity Programs IAssisted
<br />.:.: .i<:>tiit SdciIilS.",iC",:-:':':
<br />Dietary
<br />
<br />Staffing
<br />Dietary Supplies
<br />Dietary Consult
<br />Food
<br />Linen
<br />Minor Equip
<br />Chemicals
<br />::::-:::::<::'t!it::iI:p!e)'W:>' .
<br />Housekeeping
<br />
<br />Staffing
<br />Hskg Supplies
<br />Laundry/Linen Supplies
<br />Linen
<br />Floor Care
<br />Window washing
<br />Minor equip
<br />>:::: ::>j-~W:H.;~;~epici.
<br />MaintenancelEngineering
<br />Staffing
<br />Maintenance Sup.
<br />Trash
<br />Purchased Services
<br />Building Repair
<br />Unused
<br />Unused
<br />Unused
<br />: tG,~i Mi!I(ltcio4i1i:~;,Jii~.cid~g::::
<br />Utilities
<br />GaslHeat
<br />Electric
<br />Walec/Sewer
<br />......... .
<br />:'f:i>,~lpitG)i~~: . . . .... . ... ..
<br />Home Care
<br />Staffing
<br />Healtheare Supplies
<br />Healthcare misc.
<br />
<br />Contract Healthcare
<br />: :t ~t~t l:io'!i~ c:::it. :
<br />Administration
<br />Staffing
<br />Employee Benefits
<br />License & Fees
<br />
<br />2,506 2,506 2,506 2,506 2,506 2,506 2,506 2,506 2,506 2,506 2,506 2,506 30,066
<br />103 103 103 103 103 103 103 103 103 103 103 103 1,239
<br />155 155 155 155 155 155 155 155 155 155 l55 155 1,859
<br />:.:.:.:.2.,:164-: :2')64<::: : :::2)64:: :-:-:-:Z.'7.64<:-:-: :-2..764-: :<:2')54:-: ::ijM: <:2)54: :~){;4> : :;;;764: :>2)64< ::2)64:: :jJ.:I6.j<
<br />
<br /> .- -.
<br />1,879 1,879 1,879 1,879 1,879 1,879 1.879 1,879 1,879 1,879 1,879 1,879 22,550
<br />344 344 344 344 344 344 344 344 344 344 344 344 4,130
<br />
<br />207 207 207 207 207 207 207 207 207 207 207 207 2,478
<br />172 172 172 172 172 172 172 172 172 172 172 172 2,065
<br />129 129 129 129 129 129 129 129 129 129 129 129 1.549
<br />:::ij31:::' :2;'z3:i ::>:i31: -:.:-:>i,l1i:: ':::2:.731> -:-:-:~1!l:-:-: 2';3< ::: :1,111: <:::::: :2;7:3:1::: :<<2;731> :-:':2;1.11:- :::::::2j3( :32;:1'zi:
<br />........ . ........ .
<br />5,101 5,101 5,101 5,101 5,101 5,101 5,101 5.101 5,101 5,101 5,101 5,101 61,207
<br />688 688 688 688 688 688 688 688 688 688 688 688 8,260
<br />387 387 387 387 387 387 387 387 387 387 387 387 4,646
<br />671 671 671 671 671 671 671 671 671 671 671 671 8,054
<br />452 452 452 452 452 452 452 452 452 452 452 452 5,421
<br /><<i,;i9~ :::: :t.~99:::: :::<i,;i9~:::: :::::t.~~9::::: ::A,;i9~:: :-:-:-:7.29.9:-:.:-: :f,;i9~::::: ::: :t,~99::: :ti9~:::: :-:-7.,199:-: :::::7:~99::: <:>\799:: :::::::~t)~7::
<br />8,565 8.565 8.565 8.565 8,565 8,565 8,565 8,565 8,565 8,565 8,565 8.565 102,775
<br />12,276 12,276 12,276 12.276 12,276 12,276 12.276 12.276 12,276 12,276 12,276 12,276 147,311
<br />4,282 4,282 4,282 4,282 4,282 4,282 4,282 4,282 . . .4.282. . . 4,282. 4,282 4,282 51,388
<br />'<7~;:i2~ ~S):i1::: :25~'i2r . :~sA1-: 7\i7r :<:2S)21:>: >:7~;:i2L: <:~5)2V: ::::~:r~~:: ::2S;li~: :is)23 : :~~~f~:: :::)ril;:4~3
<br />
<br />.-. .-. .-.
<br />5.960 5,960 5,960 5,960 5,960 5,960 5,960 5,960 5,960 5.960 5.960 5,960 71.515
<br />3,861 3,861 3,861 3,861 3.861 3,861 3,861 3.861 3,861 3,861 3.861 3.861 46,334
<br />172 172 172 172 172 l3~ge 13172 172 172 172 172 172 2.065
<br />
|