home *** CD-ROM | disk | FTP | other *** search
- >a1:" CASH FLOW ASSESSMENT (For use with Lessons 4 and 5)
- >a1:\wc27
- >b2:"JAN
- >c2:"FEB
- >d2:"MARCH
- >e2:"APRIL
- >f2:"MAY
- >g2:"JUNE
- >h2:"JULY
- >i2:"AUGUST
- >j2:"SEPT
- >k2:"OCT
- >l2:"NOV
- >m2:"DEC
- >a2:\jlc
- >b3:"------
- >c3:"------
- >d3:"------
- >e3:"------
- >f3:"------
- >g3:"------
- >h3:"------
- >i3:"------
- >j3:"------
- >k3:"------
- >l3:"------
- >m3:"------
- >a3:\jlc
- >a4:" Cash Flow In
- >a5:" Sales
- >b5:0
- >c5:0
- >d5:0
- >e5:0
- >f5:0
- >g5:0
- >h5:0
- >i5:0
- >j5:0
- >k5:0
- >l5:0
- >m5:0
- >a6:" Services
- >b6:0
- >c6:0
- >d6:0
- >e6:0
- >f6:0
- >g6:0
- >h6:0
- >i6:0
- >j6:0
- >k6:0
- >l6:0
- >m6:0
- >a7:" Accounts Receivables
- >b7:0
- >c7:0
- >d7:0
- >e7:0
- >f7:0
- >g7:0
- >h7:0
- >i7:0
- >j7:0
- >k7:0
- >l7:0
- >m7:0
- >a8:" Other
- >b8:0
- >c8:0
- >d8:0
- >e8:0
- >f8:0
- >g8:0
- >h8:0
- >i8:0
- >j8:0
- >k8:0
- >l8:0
- >m8:0
- >a9:"
- >a10:" Total Cash Flow In
- >b10:=sum(b5:b8)
- >c10:=sum(c5:c8)
- >d10:=sum(d5:d8)
- >e10:=sum(e5:e8)
- >f10:=sum(f5:f8)
- >g10:=sum(g5:g8)
- >h10:=sum(h5:h8)
- >i10:=sum(i5:i8)
- >j10:=sum(j5:j8)
- >k10:=sum(k5:k8)
- >l10:=sum(l5:l8)
- >m10:=sum(m5:m8)
- >a12:" Cash Flow Out
- >a13:" Rent
- >b13:0
- >c13:0
- >d13:0
- >e13:0
- >f13:0
- >g13:0
- >h13:0
- >i13:0
- >j13:0
- >k13:0
- >l13:0
- >m13:0
- >a14:" Utilities
- >b14:0
- >c14:0
- >d14:0
- >e14:0
- >f14:0
- >g14:0
- >h14:0
- >i14:0
- >j14:0
- >k14:0
- >l14:0
- >m14:0
- >a15:" Supplies
- >b15:0
- >c15:0
- >d15:0
- >e15:0
- >f15:0
- >g15:0
- >h15:0
- >i15:0
- >j15:0
- >k15:0
- >l15:0
- >m15:0
- >a16:" Other
- >b16:0
- >c16:0
- >d16:0
- >e16:0
- >f16:0
- >g16:0
- >h16:0
- >i16:0
- >j16:0
- >k16:0
- >l16:0
- >m16:0
- >a18:" Total Cash Flow Out
- >a20:" Monthly Cash Position
- >b20:=b10-b18
- >c20:=c10-c18
- >d20:=d10-d18
- >e20:=e10-e18
- >f20:=f10-f18
- >g20:=g10-g18
- >h20:=h10-h18
- >i20:=i10-i18
- >j20:=j10-j18
- >k20:=k10-k18
- >l20:=l10-l18
- >m20:=m10-m18
- >a1