Budgeting-Calc PRO for Cash Flow Budgeting - Profit & Loss Budgets - AR/AP Forecasting - Productivity Budgets - 45 Day Grid For Excel

Manufacturer : International Company Services Products

Budget-Calc PRO provides managers with quick ready to use Excel templates for preparing investment plan forecasts, profit/loss plans/budgets, cash flow forecasts, sales and productivity plans, capital budget spreadsheets, plus loan repayment amortization and depreciation tables for Excel.

Budget-Calc PRO supplies ten spreadsheets that provide you with quick answers when you need immediate cash flow, profit/loss and investment forecasting, budgeting and reporting templates for Excel. The Cash Flow template supplies annual income/expenditures/tax schedules/depreciation calculations/loan repayment/financing costs tables for forecasting for any period up to 15 years with quick changes to A/R, A/P and inventory levels available to calculate year end cash balances under any variation of business forecasts. This spreadsheet calculates shareholder's rate of return yield from any budget forecast and can be used to value any business budget or acquisition. Uses dynamic loan amortization and asset depreciation calculation tables to flow annual loan balances, interest costs and/or annual depreciation data into the forecasting template if you wish to prepare investment budgets with loan/mortgage financing and/or a capital-purchasing plan. This budget calculator is particularly useful for companies with revenues in the $1-$25 million range.

Budget-Calc PRO supplies 12 month profit and loss budget forecast for any business using 12 month income/gross profit margins/expense categories forecasts, reporting budget - actual monthly results, average monthly sales, expenses and profit/loss. There are 10 income categories and 100 expense categories, which can be expanded by the user.

The 3 month money flow template provides 91 day forecasting of A/R receipts and A/P outflows with forecast daily closing bank balances and check number tracking for each payable. Set any starting date and this template automates the creation of your money flow forecast between any dates. Can be used for quick reconciliation of bank balances to book balances.

The capital budget template provides a quick way to prepare and present a capital budget, with fast changes available for resetting key assumptions to fine tune money flow forecasts. Calculates Net Present Values and the annual rate of return.

The productivity spreadsheet provides budgets and forecasts for work outputs per cost center combining man hours used and man hours costing to calculate labor productivity. This template supplies budgets and actual data columns for employee cost variance calculations.

The sale performance budget template provides 12 months sales and sales expenses budget forecast for a sales force. Includes a direct sales expense performance budget. The Excel loan amortization table supplied as the final worksheet can be used to calculate reducing monthly loan balances and interest costs for any loan/mortgage between 2 months and 360 month repayment term.

Money Flow Budgeting-Calc Version provides cash flow budgeting workbooks plus Excel tables supplying depreciation and loan amortization data for preparing investment forecasts, profit/loss budgets, cash flow forecasts, capital budgets, sales, 91 day AP/AR forecasts and annual employee productivity plans quickly and accurately. (FASB 141 & 142 goodwill & intangible variable depreciation tables included). Cash Flow Excel Spreadsheets also contain Cash Flow Accounting and Cash Burn 150 day Forecasting Spreadsheets.

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:

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.

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.

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.

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.

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.

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

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).

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

Summary budget - actual cost calculations are supplied:

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.

System Requirements

Platform : Windows XP/2000/2003 or later or Mac.

Requires MS Excel 2000/Excel XP/Excel 2003 or later or MS Office 2000 or later.


30-day Money-Back Guarantee!

Additional Information

Quick Budget Plan

Buy Online

$139.95 buy.gif (540 bytes)

Financial Excel Collection for 2013

Buy Online

$169.95 buy.gif (540 bytes)


Please see also:

All Our Financial Excel Templates (with 80% discount) - All Programs Gold Edition Collection of Business Support Programs for Excel - contains Cash Flow Budgeting and many other programs (just $169.95!)

Platform : Windows 2000/2003 or XP or later.

Requires Excel 97 or later. Web data requires Excel 2000 or above and Windows XP/2000/2003 or later.

Additional Information: All Programs Gold Edition

30-day money-back guarantee!

Financial Excel Collection for 2013

Buy Online  $169.95

buy.gif (540 bytes)

Regular Price : 450.00

buy.gif (540 bytes)  - $169.95  $450.00

MS Excel Add-ins, Spreadsheets, Templates

Copyright © International Company Services All Rights Reserved