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 Budgeting-Calc Version 3.1 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).
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.
Cash Forecasting, Credit Controls, Scheduling $169.95. Or, buy as part of Finance Excel Templates Gold Edition - HUGE Value - 80% Discount! Secure Payment Options
Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
See Also: Business Forms & Excel Templates Index (over 100!) or, All Software
Instant Download and Money Back Guarantee on Most Software
Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft
GIVE YOURSELF OR YOUR COMPANY 24/7 MICROSOFT EXCEL SUPPORT & QUESTIONS