I was wondering if anyone had a template built for a financial forecasting for 8 month period. One that would include the AP, AR Current WIP and the account for possible sales on the books. I had one i used at my last company the former President created for me, but when I was let go they wouldn't let me take anything with me. I found that sheet extremely helpful but since I didn't create it, i don't know how it was done.

I would like it to give me an idea of what the cash balance would be at any given time if the forecast were to be played out as predicted.

Thank you