Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2004

Tip: Looking for answers? Try searching our database.

Six Week Cash Flow Forecast Template

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Thndrchf - 27 Sep 2004 15:37 GMT
I need a six week cash flow template which includes the following:

Beginning checking account balance
Accounts Receivable:
    30 day
    60 day
    90 day
    over 90

Payroll is biweekly
Payroll taxes (due on the 15th of each month)
ABC Vendor total amount due)
     (amount is current, terms 2/10 net 30)
CBS Vendor total due (currently on COD)
Monthly truck lease
Payment on building
Accountant
Telephone, (average) due on the 20th of the month
Utilities, (average) due on the 4th of each month

All sales are posted to Accounts Receivable, averages sales of $6000 per
week.
Cost of goods sold is evenly split between the two vendors.

Thanks

jparker587@yahoo.com
Gordon - 27 Sep 2004 15:40 GMT
> I need a six week cash flow template which includes the following:
>
[quoted text clipped - 19 lines]
> week.
> Cost of goods sold is evenly split between the two vendors.

Well you've just done one! Set up rows with the legend as above, and put in
your values!
Gordon - 27 Sep 2004 15:45 GMT
> > I need a six week cash flow template which includes the following:
> >
[quoted text clipped - 22 lines]
> Well you've just done one! Set up rows with the legend as above, and put in
> your values!

And don't forget, enter the payments on the estimated day they are cleared
through your bank, NOT on the day you pay the bill
Lady Layla - 27 Sep 2004 17:48 GMT
: > > I need a six week cash flow template which includes the following:
: > >
[quoted text clipped - 26 lines]
: And don't forget, enter the payments on the estimated day they are cleared
: through your bank, NOT on the day you pay the bill

Why would you add this afterthought?
Gordon - 27 Sep 2004 22:34 GMT
Lady Layla cogitated deeply and scribbled thusly:
> : > > I need a six week cash flow template which includes the following:
> : > >
[quoted text clipped - 28 lines]
>
> Why would you add this afterthought?

Because the OP is obviously not familiar with cashflow forecasting,
otherwise they would not have made the original post!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.