Manufacturer : Millennium Software Inc.

Provides quick cash flow forecasting table for A/R-A/P items over 91 days using Excel's working days function. Calculates daily closing cash balances and update daily and interim balances quickly after any changes. Supplies forecasting capacity for up to 500 separate receipt/expense items.

Excel generated cash flow forecast table:

1-15 year cash flow forecasts with annual sales and more

The Cash Flow spreadsheet provides a ready-made template for developing 1-15 year cash flow forecasts with annual sales, expenses, working capital, capital investments for quick calculation of annual pre- and after tax earnings, net cash flows, opening/closing cash balances and the annual rate of shareholder return. You can create your own income and expenditure category descriptions and create any budget forecast. The template can be used to calculate the investment rate of return of an acquisition and to evaluate investor returns from the purchase of a new business.

Loan Repayments, Depreciation, Tax Calculations, Working Capital Changes

Scroll down to review calculations of yearly after tax profits, loan repayments, depreciation, financing charges, tax calculations, working capital changes and Net Closing cash balance forecasts.

Profit & Loss Budget forecast template

The Profit & Loss Budget forecast template provides quick straightforward calculation of the next 12 months pre-tax income, expenses and profit/loss forecast with monthly budgets, actuals, variances and running monthly averages.

Net Present Value of Cash Flows, Rate of Return from a capital investment budget

The Capital Budget spreadsheet calculates yearly after tax cash flows, net present value of cash flows, the rate of return from a capital investment budget. You can change the sales forecast, working capital, cost of sale and depreciation period to fine tune the forecast.

Accounts Receivable / Accounts Payable Ledger Cash Flow Spreadsheets

There are two A/R-A/P Ledger Cash Flow spreadsheets, one to forecast daily receipts and outflows for the next 91 day period and closing daily cash balances. Roll this budget forward by changing the starting date.

Accounts Receivable / Accounts Payable Spreadsheet of Actual Receipts and checks / payments

The second AR-AP spreadsheet maintains records of actual receipts and checks/payments issued to reconcile the bank account to the cash book.

Output Budget Plans Calculating the monthly output variances plau human resource productivity budgets

The human resources productivity template provides a ready made spreadsheet for creating output budget plans (monthly units-prices - budget - monthly actuals - variances) calculating the monthly output variances, plus human resource productivity budgets (monthly hours, unit labor costs, total costs).

Budget Plan and Cost Calculations

Scroll down to the human resources budget plan and cost calculations:

Summary Budget - actual cost calculations

Cash Flow Forecasting Excel Spreadsheets View

Recent changes in US accounting regulations regarding treatment of goodwill and intangible assets (FASB 141 & 142) require goodwill and intangibles to be separately accounted, and for intangibles to be depreciated over their assumed life of value. Two additional asset depreciation tables provided with Budget-Calc PRO supply variable term depreciation calculations for new and partly written down assets and a Goodwill register accounting for impairment adjustments. Run the fixed asset depreciation table for any number of months (maximum 180) to calculate individual and total written down asset values and cumulative depreciation calculated over any period.

Order

Requires MS Excel 95/Excel97/Excel 2000/Excel XP/Excel 2003 or MS Office

Platform : Windows XP/2000/2003 or Mac