Weekly cash flow forecast for a monthly time series historical and forecast model

weekly cashflow
6 posts / 0 new
Log in or register to post comments.
Last post
11 months ago
#1
blakem X 1
BM
Weekly cash flow forecast for a monthly time series historical and forecast model

A while back I am sure James posted about Monthly to weekly cash flow forecasting? 

What was the name of the post - for the life of me I cannot find it. 

11 months ago
James Longden A+ 103

Hi Blake.

I haven't posted any monthly to weekly analysis on here. It's a messy area and typically impacted by company preference as opposed to any universally correct way of doing things. 

There's the daily cash flow stuff, which converts monthly to daily, so you could bolt some weekly onto that as an option.

Cheers. J.

11 months ago
blakem X 1
BM

Thanks James - I reckon that is the kit I was looking for... 

You installed this for me at Packhorse and it was absolutely sensational - changed the way we looked as cashflow forecasting to a more granular level.  From it we then went to weekly very easily. 

 

 

5 months ago
Sajid Mafahir X 1
SM

Hello James,

You had uploaded a daily cashflow model.xlsb file over the forums here. is it available in the library or else could you please share that xlsb again.

Thanks,

3 months ago
jessegraham98 X 0
CG

Any update?

3 months ago
James Longden A+ 103

Here is the technical support on the model: https://app.modano.com/resources/content_libraries/generic_financial_mod...

The model itself can be accessed in Excel via MODANO / OPEN / EXAMPLE MODELS / ADVANCED and the following item.