|
PRELIMINARY DRAFT
<br />MONTHLY CASH FLOW PROJECTION
<br />NAME OF BUSINESS:
<br />The Lartar Colon
<br />ADDRESS:
<br />1746 Bonham Sf Pans TX
<br />OWNER:
<br />KG LLP
<br />TrPE oF suswess:
<br />Pssisted Livin
<br />PREPARED BY:
<br />Kenn Kamer
<br />DATE:
<br />91412001
<br />Pre-Start-up
<br />Posilion
<br />MONTH:
<br />1
<br />2
<br />3
<br />4
<br />5
<br />6
<br />7
<br />8
<br />9
<br />10
<br />11
<br />12
<br />TOTAL
<br />YEAR MONTM
<br />Column5l-72
<br />Estimate
<br />Estimate
<br />Estimate
<br />Eslimale
<br />Estimate
<br />Estimate
<br />Estimate
<br />Estimate
<br />Estimale
<br />Estimate
<br />Estimale
<br />Estimate
<br />Estimate
<br />Estimate
<br />'I.CASHONHAND
<br />(beginning of month
<br />0
<br />76,180
<br />58,129
<br />57,249
<br />55,520
<br />70,942
<br />97,515
<br />136,239
<br />773,963
<br />277,687
<br />249,411
<br />287,735
<br />324,859
<br />76,760
<br />1
<br />2. CASH RECEIPTS
<br />a. CaSh 5a1e5
<br />62,000
<br />74,400
<br />86,800
<br />99,200
<br />117,600
<br />124,000
<br />124,000
<br />124,000
<br />124,000
<br />124,000
<br />724,000
<br />124,000
<br />1,302,OD0
<br />Z
<br />a
<br />6. Collec{ions hom Credi1 AccounLS
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />b
<br />c. Loan or Olher Cash in'eclion S eci
<br />100,000
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />c
<br />3. TOTAL CASH RECEIPTS
<br />2a+2b*2c=3
<br />70G,000
<br />62,000
<br />74,400
<br />88,800
<br />99,200
<br />711,600
<br />724,000
<br />124,000
<br />126,000
<br />724,000
<br />724,000
<br />724,000
<br />124,000
<br />1,302,000
<br />3
<br />4. TOTAL CASH AVAILABLE
<br />Before cash out 1•3
<br />100,000
<br />138,160
<br />132,529
<br />738,049
<br />154,720
<br />182,542
<br />221,515
<br />260,239
<br />297,963
<br />335,687
<br />373,411
<br />417,735
<br />448,859
<br />1,378,160
<br />4
<br />5. CASH PAID OUT
<br />a. Purcha5e5 MerCh3rbi5e
<br />4,000
<br />6,245
<br />7,494
<br />8,743
<br />9,992
<br />17,241
<br />12,490
<br />12,490
<br />12490
<br />12,d90
<br />12,490
<br />72,490
<br />131,745
<br />5
<br />a
<br />b. GroSSWa es Ezcludesw0hdrawals
<br />33,250
<br />33,250
<br />33,250
<br />33,250
<br />33,250
<br />33,2W
<br />33,250
<br />33,250
<br />33,250
<br />33,250
<br />33,250
<br />399,000
<br />b
<br />c. P rollEz nses axes,NC.
<br />3,325
<br />3,325
<br />3,325
<br />3,325
<br />3,325
<br />3,325
<br />3,325
<br />3,325
<br />3,325
<br />3,325
<br />3,325
<br />39,900
<br />c
<br />tl. Outsitle Services
<br />P
<br />500
<br />500
<br />500
<br />500
<br />500
<br />SDO
<br />500
<br />00
<br />5Q0
<br />500
<br />500
<br />r
<br />6,000
<br />E
<br />e. Su ies OfficeBo eratin
<br />1,500
<br />1,500
<br />1,W0
<br />1,SU0
<br />1,500
<br />1,500
<br />1,500
<br />1,500
<br />1,500
<br />1,500
<br />7,500
<br />18,000
<br />e
<br />f. Re airs&Mainlenance
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />1,000
<br />1,000
<br />1,000
<br />1,000
<br />1,000
<br />6,000
<br />t
<br />. Adverti5in
<br />1 000
<br />1,000
<br />1,000
<br />1,000
<br />1,000
<br />0
<br />0
<br />0
<br />0
<br />. 0
<br />' 0
<br />5,000
<br />h.Car,Delive ,BTravel
<br />1,000
<br />1,000
<br />1,000
<br />1,000
<br />1,000
<br />1,000
<br />1,000
<br />1000
<br />1,000
<br />1,000
<br />1,000
<br />l
<br />12,000
<br />M1
<br />I. Acmuntin & L al
<br />800
<br />300
<br />300
<br />300
<br />300
<br />300
<br />300
<br />300
<br />300
<br />300
<br />300
<br />300
<br />300
<br />3,600
<br />I
<br />J. Rent
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />200
<br />200
<br />200
<br />200
<br />200
<br />200
<br />200
<br />200
<br />200
<br />200
<br />200
<br />200
<br />2,400
<br />k
<br />1. UttlHies
<br />1,200
<br />2,732
<br />2,732
<br />2,732
<br />2,732
<br />2,732
<br />2,732
<br />2,732
<br />2,732
<br />2,732
<br />2,732
<br />2,732
<br />2,732
<br />32,784
<br />1
<br />m.lnsuance
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />2,500
<br />30,000
<br />n
<br />n. Tazes Real Estate.etc
<br />4.214
<br />4,214
<br />4.214
<br />4.214
<br />4.274
<br />4.214
<br />4.270
<br />4.214
<br />4.214
<br />4.214
<br />4.214
<br />41274
<br />50.568
<br />m
<br />o. Irrteresl
<br />14,741
<br />14,693
<br />14,645
<br />14,596
<br />14,546
<br />14,498
<br />14,448
<br />14,398
<br />14,347
<br />14,297
<br />14,246
<br />14,194
<br />773,650
<br />0
<br />. WherEn enses 5 ecifi each
<br />0
<br />Aulolease
<br />950
<br />950
<br />950
<br />950
<br />950
<br />950
<br />950
<br />950
<br />' 950
<br />950
<br />950
<br />950
<br />11,400
<br />0
<br />. Miscellaneous Uns cified
<br />500
<br />SW
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />6,000
<br />f. Subtotal
<br />23,840
<br />72,957
<br />74,158
<br />75,359
<br />76,559
<br />77,758
<br />77,959
<br />78,909
<br />78,859
<br />78,808
<br />78,758
<br />78,707
<br />78,655
<br />927,447
<br />r
<br />s. LoanPrinci IPa ment
<br />7,074
<br />7,122
<br />7,770
<br />7,219
<br />7,269
<br />7,317
<br />7,367
<br />7,417
<br />7,468
<br />7,518
<br />7,569
<br />7,621
<br />88,130
<br />5
<br />L Ca ilal Pumhases (Specify)
<br />'
<br />0
<br />t
<br />U. Olh¢rStartu Cqsts
<br />0
<br />u
<br />v. Reserve and/or Excrow (Specify)
<br />0
<br />v
<br />w. Ownefs W3hdrawal
<br />0
<br />w
<br />8. TOTAL CASH PAID OUT
<br />23,840
<br />80,031
<br />81,280
<br />82,529
<br />83,778
<br />85,027
<br />85,276
<br />86,276
<br />86,276
<br />66,276
<br />86,276
<br />86,276
<br />88,276
<br />7,015,577
<br />6
<br />olal 5a ihN 5w
<br />7. CASHPOSITION
<br />End of month 4 minus 6
<br />76,160
<br />58,129
<br />51,249
<br />55,520
<br />70,942
<br />97,515
<br />136,239
<br />173,963
<br />277,687
<br />249,411
<br />287,1%
<br />324,859
<br />362,583
<br />362,583
<br />7
<br />ESSENTIAL OPERATING DATA
<br />(Noncash Pow infarmalion)
<br />A. SaleS Vdume Dollars
<br />62,000
<br />74,400
<br />86,800
<br />99,200
<br />111,600
<br />724,000
<br />124,000
<br />124,000
<br />124,000
<br />124,000
<br />724,000
<br />124,000
<br />7,302,000
<br />A
<br />B. Accwnts Receivable End of monlh
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />B
<br />C. BaA DeDt Entl of moMh
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />C
<br />D. InveMO on Hand En0 of month
<br />4,000
<br />4,000
<br />4,000
<br />4,000
<br />4, 00
<br />4,000
<br />4,000
<br />4,000
<br />4,000
<br />4,000
<br />4,000
<br />4,000
<br />41000
<br />4 000
<br />O
<br />E. AxouMS Pa ade Entl of rtaMh
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />E
<br />F. De tetia[ion
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />F
<br />ASSUMPTIONS:
<br />Revenue: 29 Unils @ 2 BeAS Q$3500
<br />10 UnNs @ 1 Be0 (aJ $2250
<br />MONTHLV REVENUE AVAILABLE
<br />OcwpanryPercenlage
<br />101,500
<br />22,500
<br />124,000
<br />50% 60No 70% 80% 90% 100% 100% 100°h 100% 100% 100% 700%
<br />Financing Tertns:
<br />BudEing $2,067,200 @ 8% far 15 years
<br />Fum/Equip $128,000 @ e% for 7 years
<br />
|