Excel Spreadsheets For Cash Flow Forecasting

Cash Flow Spreadsheets provide all the "cash flow reports and forecasts" you need to forecast your exact cash position ahead with quick look up of any daily balance 1-120 days forward using simple listing of payables and receivables. Plus consolidation of five subsidiary offices or divisional daily cash reports into one combined cash flow report. Plus two free bonus spreadsheets calculate the NPV and IRR of investment cash flow forecasts.

CASH FLOW SPREADSHEETS Plug-ins for Excel

Business Cash Flow Reporting 3.0.xls

Business Cash Flow Reporting supplies six plug in templates for managers to enter daily cash sales, returns & allowances, receivables, other receipts.

Supplies 25 expense items including wages, pensions, staff salaries, employee benefits, insurances, materials and supplies, security, office expenses.

Capital purchases, loan repayments, non recurring costs and amounts to escrow.

Business Cash Flow Reporting compute daily balances and updates month to date balances.

Each of five spreadsheets are consolidated into the final combined Cash Flow report, which display daily combined totals for all headings above and the net cash position each day.

NPV/IRR modelling cash flows for up to 60 years and 120 months.

Cash Flow Forecasting 3.2 plus demo:

Cash Flow Forecasting provides the complete plug in tools for cash flow management, supplies all the following:

Calculator 1: Present value of cash to be received in the future. (Adjust delayed cash receipts for inflation).

Calculator 2: Late payment charge between any two dates calculated at any interest rate.

Calculator 3: Future value of a cash amount compounded from todays date.

Calculator 4: Future value of a cash amount compounded between any two dates.

120 days cash forecasting spreadsheet: Excel grid forecasts your cash balances on any date between 1-120 days from any starting date following entry of payables and receivables and days due. Quick view forecasts any number of days ahead and summary cash flow totals for the entire period.

Plus: Payables/Receivables conversion foreign currency to/from your local currency: If you import or export goods in a foreign currency and need to convert your receivables and payables into your local currency at the most recent exchange rate, use these plug in templates to calculate your current total receivables/payables in your currency. Latest exchange rates are updated daily using Excels Import web data toolbar.

Plus: Adjustable Investment Cash Flow Forecasting spreadsheet:
Use this spreadsheet to prepare capital project cash flows. Calculate net present values and internal rate of return. You can adjust cash flow out and cash flow in by simply entering any percentage variances and the spreadsheet recalculate all balances and rates of return.

Plus: Working Capital Cash Requirement spreadsheets.

Calculator table: Enter your days sales outstanding forecast, days inventories outstanding forecast and days payables outstanding forecasts, for any period, plus sales forecast and the calculator displays working capital cash requirements and changes in cash requirements for five consecutive annual periods starting at any date.

EBITDA Forecasting spreadsheet:
Templates forecast monthly sales by product, gross margin, company expenses and EBITDA, EBIT, Cash Flows and profit/loss.

Daily Cash Flow Forecast spreadsheet:

A quick way to calculate daily cash balances using payables receipts and cash expenses out.

Zip download

The download file contains: Business Cash Flow Reporting 3.0, Cash Flow Forecasting 3.2 & demo. Locate the download file and unzip first of all before you try to run in Excel. There are three separate files within the download zip file.