home *** CD-ROM | disk | FTP | other *** search
- >a1:" CASH FLOW ASSESSMENT
- >a1:\wc27
- >a2:"Copyright, 1982, Perfect Software, Inc.
- >a4:"*************************************************************************
- >f4:"*************************************************************************
- >h4:"*************************************************************************
- >a5:" Beginning Cash Balance:
- >b5:0
- >a6:"*************************************************************************
- >b8:"JAN
- >c8:"FEB
- >d8:"MARCH
- >e8:"APRIL
- >f8:"MAY
- >g8:"JUNE
- >h8:"JULY
- >i8:"AUGUST
- >j8:"SEPT
- >k8:"OCT
- >l8:"NOV
- >m8:"DEC
- >a8:\jlc
- >b9:"------
- >c9:"------
- >d9:"------
- >e9:"------
- >f9:"------
- >g9:"------
- >h9:"------
- >i9:"------
- >j9:"------
- >k9:"------
- >l9:"------
- >m9:"------
- >a9:\jlc
- >a10:" Cash Flow In
- >a11:" Sales
- >b11:0
- >c11:0
- >d11:0
- >e11:0
- >f11:0
- >g11:0
- >h11:0
- >i11:0
- >j11:0
- >k11:0
- >l11:0
- >m11:0
- >a12:" Services
- >b12:0
- >c12:0
- >d12:0
- >e12:0
- >f12:0
- >g12:0
- >h12:0
- >i12:0
- >j12:0
- >k12:0
- >l12:0
- >m12:0
- >a13:" Accounts Receivables
- >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:" Contract Accounts
- >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:" Other
- >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:"
- >a17:" Total Cash Flow In
- >b17:=sum(b11:b15)@
- >c17:=sum(c11:c15)@
- >d17:=sum(d11:d15)@
- >e17:=sum(e11:e15)@
- >f17:=sum(f11:f15)@
- >g17:=sum(g11:g15)@
- >h17:=sum(h11:h15)@
- >i17:=sum(i11:i15)@
- >j17:=sum(j11:j15)@
- >k17:=sum(k11:k15)@
- >l17:=sum(l11:l15)@
- >m17:=sum(m11:m15)@
- >a20:" Cash Flow Out
- >a21:" Rent
- >b21:0
- >c21:0
- >d21:0
- >e21:0
- >f21:0
- >g21:0
- >h21:0
- >i21:0
- >j21:0
- >k21:0
- >l21:0
- >m21:0
- >a22:" Utilities
- >b22:0
- >c22:0
- >d22:0
- >e22:0
- >f22:0
- >g22:0
- >h22:0
- >i22:0
- >j22:0
- >k22:0
- >l22:0
- >m22:0
- >a23:" Phone
- >b23:0
- >c23:0
- >d23:0
- >e23:0
- >f23:0
- >g23:0
- >h23:0
- >i23:0
- >j23:0
- >k23:0
- >l23:0
- >m23:0
- >a24:" Payroll
- >b24:0
- >c24:0
- >d24:0
- >e24:0
- >f24:0
- >g24:0
- >h24:0
- >i24:0
- >j24:0
- >k24:0
- >l24:0
- >m24:0
- >a25:" Supplies
- >b25:0
- >c25:0
- >d25:0
- >e25:0
- >f25:0
- >g25:0
- >h25:0
- >i25:0
- >j25:0
- >k25:0
- >l25:0
- >m25:0
- >a26:" Insurance
- >b26:0
- >c26:0
- >d26:0
- >e26:0
- >f26:0
- >g26:0
- >h26:0
- >i26:0
- >j26:0
- >k26:0
- >l26:0
- >m26:0
- >a27:" Postage
- >b27:0
- >c27:0
- >d27:0
- >e27:0
- >f27:0
- >g27:0
- >h27:0
- >i27:0
- >j27:0
- >k27:0
- >l27:0
- >m27:0
- >a28:" Advertising
- >b28:0
- >c28:0
- >d28:0
- >e28:0
- >f28:0
- >g28:0
- >h28:0
- >i28:0
- >j28:0
- >k28:0
- >l28:0
- >m28:0
- >a29:" Maintenance
- >b29:0
- >c29:0
- >d29:0
- >e29:0
- >f29:0
- >g29:0
- >h29:0
- >i29:0
- >j29:0
- >k29:0
- >l29:0
- >m29:0
- >a30:" Other
- >b30:0
- >c30:0
- >d30:0
- >e30:0
- >f30:0
- >g30:0
- >h30:0
- >i30:0
- >j30:0
- >k30:0
- >l30:0
- >m30:0
- >a32:" Total Cash Flow Out
- >b32:=sum(b21:b30)@
- >c32:=sum(c21:c30)@
- >d32:=sum(d21:d30)@
- >e32:=sum(e21:e30)@
- >f32:=sum(f21:f30)@
- >g32:=sum(g21:g30)@
- >h32:=sum(h21:h30)@
- >i32:=sum(i21:i30)@
- >j32:=sum(j21:j30)@
- >k32:=sum(k21:k30)@
- >l32:=sum(l21:l30)@
- >m32:=sum(m21:m30)@
- >a35:" Monthly Cash Position
- >b35:=b17-b32@
- >c35:=c17-c32@
- >d35:=d17-d32@
- >e35:=e17-e32@
- >f35:=f17-f32@
- >g35:=g17-g32@
- >h35:=h17-h32@
- >i35:=i17-i32@
- >j35:=j17-j32@
- >k35:=k17-k32@
- >l35:=l17-l32@
- >m35:=m17-m32@
- >a37:" WORKING CAPITAL
- >b37:=b5+b35@
- >c37:=b37+c35@
- >d37:=c37+d35@
- >e37:=d37+e35@
- >f37:=e37+f35@
- >g37:=f37+g35@
- >h37:=g37+h35@
- >i37:=h37+i35@
- >j37:=i37+j35@
- >k37:=j37+k35@
- >l37:=k37+l35@
- >m37:=l37+m35@
- >a1
- >f28:0
- >g28:0
- >h28:0
- >i28:0
- >