Payables =

Cash In Bank =

Inventory Not Funded =

Shipments Not In Inventory =

Inventory Not To Be Funded =

Reserve Release =

Surplus/Deficit =

This Template will calculate the cash flow surplus or deficit over the next 30-60 days for any company using a factor given 6 variables: Payables; Cash; Invoices Not Yet Funded; Shipments Not Yet Invoiced That Will Be Funded; Invoices Not To Be Funded and Reserve Release.

It is assumed that: Vender payments will be made 30-60 days; Customer payments will be made in 30-60 days and Reserve Release is every 30 days. A factor of .785 is used for all funded or to be funded invoices to account for the 20% with held for reserves and the 1.5% front end fee.

Contributed by Clarke Blackman

Payables: 60,000

Cash In Bank: 1,000

Inventory Not Funded: 16,000

Shipments Not In Inventory: 8,000

Inventory Not To Be Funded: 7,000

Reserve Release: 14,000

Surplus/Deficit: -19,160

Payables

Cash In Bank

Inventory Not Funded

Shipments Not In Inventory

Inventory Not To Be Funded

Reserve Release

Surplus/Deficit

-------------