Forecast cash flow

Yahoo Archive
1
Reverse aging works like an AR aging report except that it displays when cash is due in. Allows you to see what cash inflows to expect (making the grand assumption that a customer will actually pay on time) for the coming weeks. For example:

Customer Past Due This week Next Week Yada Yada Yada

Dalton Mfg. $45,987 $12,544 $9,877 $5444 $22,399 $45,877 etc...


Put together with a planned cash outflow report in a similar format should give you what you need.

For us, we are most concerned with cash coming in so that's all our report includes.

In essence, "She me the money!"

Mike

-----Original Message-----
From: Ajitesh K [mailto:servit@...]
Sent: Friday, May 21, 2004 5:29 AM
To: vantage yahoogroups
Subject: Fw: [Vantage] forcast cash flow


Hey Mike,

What is reverse aging report?
I never came across this term. Is cash requirement report? Help me out
buddy.

With Regards

Ajitesh K

MIS Programmer
U.S. Aeroteam, Inc
One Edmund St,
Dayton, OH 45404


----- Original Message -----
From: "Mike Lowe" <MLowe@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, May 20, 2004 3:29 PM
Subject: RE: [Vantage] forcast cash flow


> Create a reverse aging report.
>
> Mike
>
> -----Original Message-----
> From: Ajitesh K [mailto:servit@...]
> Sent: Thursday, May 20, 2004 12:10 PM
> To: vantage yahoogroups
> Subject: [Vantage] forcast cash flow
>
>
> Hi Friends,
>
> What we are trying to accomplish is forecast weekly/Monthly cash flow. Any
> suggestions?
>
> With Regards
>
> Ajitesh K
>
> MIS Programmer
> U.S. Aeroteam, Inc
> One Edmund St,
> Dayton, OH 45404
>
> servit@...
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/> .
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
>
>
>
>
>
>




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=1299ccos0/M=295196.4901138.6071305.3001176/D=groups/S=1705007183:HM/EXP=1085229217/A=2128215/R=0/SIG=10se96mf6/*http://companion.yahoo.com> click here
<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=:HM/A=2128215/rand=514895390>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
Ajitesh,

I wrote a program like this about 10 years ago in BAL on an IBM 4381 ( ah,
the good old days ... )

We took all open payables --- date received + Days to pay --- or --- date
due + Days to pay. Days to pay was pulled from our Vendor file. As in,
some vendors we paid in 30 days, some we paid in 60 days, some we paid in
90 days ... some we really didn't like we paid in 120 days. The idea was
to simulate incoming invoices and payments with the correct bumps for delay
days on checks going out. ( This would be all open PO's and all unpaid
invoices )

Then we took receivables and did the same basic math. Delivery date to
customer or due date at customer + the average days it took for all of the
deadbeats to PAY US !!!! ( This would be all open sales orders + unpaid
invoices )

Merge the two and it's about as accurate as you can get - say 30% ?

Todd Anderson


-----Original Message-----
From: Matt Finn [mailto:matt@...]
Sent: Thursday, May 20, 2004 2:55 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] forcast cash flow


I've been using my crystal ball while building my time machine.

You can get somewhat close for a week, starts getting fuzzy at two weeks.
Monthly would be a great exercise for a young intern with nothing else to
do, and some comic relief to laugh about six months later.........I guess
I'm a little jaded by the owner sending me a note about the 400m he spent
while I was on vacation......the joys of small business, you might have a
little more 'structure' than we do. I guess it wouldn't hurt to try! Make
that a lot of guesses......

Matt



-----Original Message-----
From: Ajitesh K [mailto:servit@...]
Sent: Thursday, May 20, 2004 2:10 PM
To: vantage yahoogroups
Subject: [Vantage] forcast cash flow

Hi Friends,

What we are trying to accomplish is forecast weekly/Monthly cash flow. Any
suggestions?

With Regards

Ajitesh K

MIS Programmer
U.S. Aeroteam, Inc
One Edmund St,
Dayton, OH 45404

servit@...





Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=1293v25kc/M=295196.4901138.6071305.3001176/D=groups
/S=1705007183:HM/EXP=1085169447/A=2128215/R=0/SIG=10se96mf6/*http://companio
n.yahoo.com> click here

<http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=groups/S=
:HM/A=2128215/rand=499782705>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]