|
PRELIMINARY DRAFT
<br />MONTHLY CASH FLOW PROJECTION
<br />NAME OF BUSINESS:
<br />ADDRESS:
<br />OWNER:
<br />7vaE OF BUSU+e55:
<br />PREPARED BY:
<br />DATE:
<br />The Lamar Colon
<br />1746 Bonham St Paris TX
<br />KG LLP
<br />Assistetl Livin
<br />Kenn Kamer
<br />9/4/2001
<br />Pre-SWrtup
<br />MONTH:
<br />Position
<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 />VEAR MONTH
<br />Columns 1-12
<br />Estimte
<br />Estimate
<br />Estimte
<br />Es[ima[e
<br />Eslimate
<br />Estimate
<br />Estimte
<br />Eslimate
<br />Estimte
<br />Es[imate
<br />Estimate
<br />Estimale
<br />Estimate
<br />Estimte
<br />1. CASHONHAND
<br />0
<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 />211,687
<br />249,411
<br />287,135
<br />324,859
<br />76,760
<br />1
<br />be innin of rtwnth
<br />2. CASH RECEIPTS
<br />Z
<br />a. CashSales
<br />62,000
<br />74,400
<br />86,800
<br />99,200
<br />111,600
<br />124,000
<br />124,000
<br />124,000
<br />124,000
<br />124,000
<br />124,000
<br />124,000
<br />1,302,000
<br />a
<br />b. Cdlections from CreOit Accounts
<br />a
<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 />6
<br />a Loan or O[her Cash in'eclion (SpecifyL
<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 />100,000
<br />62,000
<br />74,400
<br />86,800
<br />99,200
<br />111,600
<br />124,000
<br />124,000
<br />124,000
<br />124,000
<br />124,000
<br />124,000
<br />1
<br />24,000
<br />1,302,000
<br />3
<br />2a-2b+2c=3
<br />4. TOTAL CASH AVAILABLE
<br />100,000
<br />138,160
<br />132529
<br />138,049
<br />154,720
<br />182,542
<br />221,515
<br />260,239
<br />297,963
<br />335,687
<br />373,411
<br />411,135
<br />448859
<br />1,378,160
<br />4
<br />Beforecashout 1+3
<br />5. CASH PAID OUT
<br />5
<br />a. Purchases Merchantlise
<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 />12,490
<br />12,490
<br />12,490
<br />12,490
<br />12,490
<br />131,145
<br />a
<br />b. Gro55Wa es Excludeswdhtlrawals
<br />14,400
<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 />33,250
<br />33,250
<br />33,250
<br />399,000
<br />b
<br />c. Pa roll Ex nses axes, etc.
<br />1,440
<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 />3,325
<br />39,900
<br />c
<br />d. Outsitle Services
<br />500
<br />500
<br />500
<br />500
<br />SOU
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />6,000
<br />d
<br />e. Su lies OficeBo ratin
<br />1,000
<br />1,500
<br />1,500
<br />7,500
<br />7,500
<br />1,500
<br />1,500
<br />1,500
<br />1,500
<br />1,500
<br />1,500
<br />1,500
<br />1,500
<br />18,000
<br />e
<br />( Re airs & Maintenance
<br />0
<br />0
<br />o
<br />0
<br />0
<br />0
<br />1,000
<br />1.000
<br />1.000
<br />1,000
<br />1,000
<br />1,000
<br />6,000
<br />f
<br />. Advertisin
<br />1,000
<br />1,000
<br />1,000
<br />1,000
<br />1p00
<br />1,000
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />0
<br />5,000
<br />h. Car, Delive ,&Trdvel
<br />1,000
<br />1,000
<br />1,000
<br />1,000
<br />1,000
<br />1,000
<br />1,000
<br />1,000
<br />7,000
<br />1,000
<br />1 000
<br />11000
<br />12,000
<br />h
<br />I. Accountin 8 Le 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 />1
<br />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 />2400
<br />k
<br />1. Ulildies
<br />1,200
<br />2,732
<br />2,732
<br />2,732
<br />2,732
<br />?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 />I
<br />m.lnsurance
<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 />rt Tazes Real Estate. etc
<br />4.214
<br />4,214
<br />4,214
<br />4.214
<br />4.214
<br />q214
<br />4,214
<br />4.214
<br />4.214
<br />4.214
<br />4,214
<br />50.568
<br />m
<br />o. Inte2s[
<br />14,741
<br />14,693
<br />14 645
<br />d
<br />14,546
<br />74,498
<br />14,448
<br />14,398
<br />14,347
<br />14,297
<br />14,246
<br />14,194
<br />173,650
<br />0
<br />. Other Ex enses 5 ecifi each
<br />0
<br />Aurolease
<br />950
<br />950
<br />950
<br />950
<br />950
<br />950
<br />9W
<br />950
<br />950
<br />950
<br />950
<br />11,400
<br />0
<br />. Miscellaneous Uns ified
<br />500
<br />WO
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />500
<br />6,000
<br />c Subtolal
<br />23,840
<br />72957
<br />74,158
<br />75,359
<br />77,758
<br />77959
<br />78909
<br />78,859
<br />78,808
<br />78,758
<br />78)07
<br />78,655
<br />927,447
<br />r
<br />s. oan nnci a a men
<br />t Ca ifal Purchases (Specify)
<br />0
<br />t
<br />u. O[her5tart-u Costs
<br />4
<br />u
<br />v. Reserve and/or Excrow (Specify)
<br />0
<br />v
<br />w. Ownefs WrthArawal
<br />0
<br />w
<br />6. TOTAL CASH PAID OUT
<br />23,840
<br />80,031
<br />81,280
<br />82,529
<br />83j78
<br />85,027
<br />85,276
<br />86,276
<br />86,276
<br />86,276
<br />86,276
<br />86,276
<br />86,276
<br />1,015,577
<br />6
<br />Tofal 5a ihru 5w
<br />7. CASXPOSITION
<br />76,760
<br />58,129
<br />51,249
<br />55,520
<br />70,942
<br />97,515
<br />136,239
<br />173963
<br />211,687
<br />249,411
<br />287,135
<br />324,859
<br />362,583
<br />362,583
<br />7
<br />End of month 4 minus 6
<br />ESSENTIAL OPERATING DATA
<br />(Nomcash flow infortnation)
<br />A. Sales Volume Dollars
<br />62,000
<br />74,400
<br />86,800
<br />99,200
<br />111,600
<br />124,000
<br />124,000
<br />124,000
<br />124,000
<br />124,000
<br />124,000
<br />124,000
<br />1,302,000
<br />A
<br />B. Accounis Receivable End of month
<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. Bad Debt Ena 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 />C
<br />D. InveMO on Hand End of monlh
<br />4,000
<br />4,000
<br />4,000
<br />4,000
<br />4,000
<br />4.000
<br />4,000
<br />4,000
<br />4,000
<br />4,000
<br />6,000
<br />4,000
<br />4,000
<br />4,000
<br />D
<br />E. Accounts Pa able EiW o( month
<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 reciation
<br />0
<br />a
<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 Uni[s (03 2 Betls @$3500
<br />70 Unils @ 1 BeA Q$2250
<br />MONTHLV REVENUE AVAIIABLE
<br />Occupancy PercenWge
<br />107,500
<br />22.500
<br />124,000
<br />sai so o 70i eov soq ioa% iooi ioov ioo% iooi iooi iooi
<br />Financing Terms:
<br />Builtling $2,067,200 Q 8%for 15 years
<br />FuMEquip $128,000 Q 8% for 7 years
<br />
|