Cash Forecasting, Credit Controls, Scheduling

Cash Flow Forecasting 150 days.xls - Forecast 150 days ahead. List current receivable and payable accounts by date, set target payable and receivable days, generate overdue and late account lists, generate daily, weekly and monthly cash flow forecasts, set targets, analysis variances.

Individual (linked) spreadsheet by tabs > Guide, Targets, Accounts Register, Daily balance forecasts, Monthly forecasts, Create Lists.

The workbook provides daily closing cash balances for the entire 150 day period, summarizes late payers, week end and month end forecast balances.

Cash Operating Plan.xls - 12 month sales and expenses plan spreadsheet links to the working capital spreadsheet where the user enters monthly targets for days sales outstanding, percentage payable to sales, days inventories outstanding to monthly cash forecast spreadsheet presented as Operating and working capital monthly changes -capital requirements – loan balances requirements – ending as changes in monthly cash.

Individual (linked) spreadsheet by tabs > Start & Summary, Monthly P_L Budget, Working Capital, Monthly Cash Changes Forecast.

Customer Credit Control.xls – This workbook alerts managers up front if customers will exceed their credit limits if an order is processed using Excel. Incorporates current credit limit values per customer, accepted order values pending, and net credit positions. Posts STOP each order before output costs are incurred.

Individual (linked) spreadsheet by tabs > Guide, Product List, Customer Credit Status, Order Control, Sales Running Rates.

Daily Cash Consolidation.xls – When you have different operating divisions reporting different daily income, expenses and capital expenditures on a cash accounting basis, this workbook will consolidate all daily cash in and out reports into combined totals and compare actuals to the overall budget on a monthly basis.

Individual (linked) spreadsheet by tabs > Set up Income-Expense Categories – Monthly P_L Budget – Divisions 1-12 Daily Reports – Month to Date & Variances – Daily Consolidations.

Scheduling Payments.xls – Everyone has to schedule who to pay and when. This workbook makes that task easier. Enter all your receivables (or forecast receivables) into the Receivable register in simple Excel list format with the amounts, invoice dates and target (or average) days collection. This page will display alerts when each receivable account is overdue. List payable accounts in the Schedule Payments spreadsheet with amounts and due dates. Adjust payment dates so that you do not exceed daily credit limits which are calculated 150 days ahead in the Rescheduled Balances & Credit Available (summary) spreadsheet. Make cash scheduling more effective and manages daily credit forecasting.

Individual (linked) spreadsheet by tabs > Set Bank Holiday Dates – Receivable Register – Schedule Payables – Rescheduled Balances & Credit.

Zip file download or select CD edition shipping.

Links to Financial and Business Planning Sites

www.planware.org - Business plan, financial projection, cash flow forecast, strategic plan, market planning software freeware, templates, samples, online tools, advice, guide.

www.planningtemplates.com - This site offers low cost excel based financial planning tools designed to meet the needs of the middle market.

www.2-small-business.com - Free excel business plan spreadsheets and other templates related to business and financial planning.