Complete Excel Templates Financial Management

Our Complete Excel Templates 2009 Collection provides 180 business finance spreadsheets, Excel add–ins plus nine new Risk Analysis spreadsheets which will help you manage financial assets, analyse investments, control cash flows, set up budgets and model financial statements and forecasts quickly and effectively.

Our 2009 Collection includes 30 new Financial Intelligence Programs with free Document & Spreadsheet Connectivity Software included (from Feb 01, 2009). We do not have the space here to tell you about all our new Excel financial workbooks, so we have created a profile in this Word document which you can read as a web page by copying this link into your browser.


Plus all our other workbooks as follows:

Investment-Calc 2008 spreadsheets analyses Present values and internal rates of return of periodic cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, present value of periodic investments, acquisition synergy net present values, cost of capital, terminal (to infinity) net present values.

Includes a 30 page Guide to Investment Rate of Return Calculations with formulas including worked example rate of return spreadsheets.

Plus Project analysis spreadsheets analyse cash flows, EBITDA, operating and after tax profits, average annual income, ROIC, net present values & IRR.

Master Budgeting for 1-10 departments. Consolidates individual budgets year to date and provides monthly variance analysis. 12 months departmental budgets consolidated.

The Fixed Asset Accounting workbook provides all you need to keep track of and forecast depreciation for a maximum 3,000 assets. Use Excel 97-2003, 2007 & 2008 to work with depreciation records, book values and disposals. It will save you many hours of work with MACRS tax depreciation and deferred tax balances. Recalculate or model asset balances at any month end date.

Lease Accounting aggregates repayment and interest balances for up to 3,000 capital leases. Models variations in lease repayment terms anytime during a lease payment.

Excel Costing templates provide standard costing models. Now includes Profit Margin risk analysis by simulating probable profit outcomes when different cost variances are consolidated.

Financial ratio analysis. Balance sheet, income statement and cash flow analysis calculates 50 key ratios, including operating ratios, shareholder returns, working capital, debt, sales days, inventory turnover, and liquidity.

FastPlan 9.16 for five year financial plans. Develop your 5 year financial forecast and transfom these into simulated balance sheets, income forecasts and cash flows.

Our new Cash Management & Optimization workbooks will help you optimise your business finances. It organises accounts payable and receivable into late and overdue plus a 150 day cash flow forecast, and enables you to alter any or all operational variables to calculate your cumulative period ending cash balance. Calculates balance sheets, income and cash flows to calculate closing cash under any scenario you care to forecast.

If you need to calculate your cash burn each day for 150 days ahead use the extra CASH BURN forecasting spreadsheet provided within this zip file.

Bank Cash Flows _ Budgets _ Actuals_Forecasts_Variances for Excel. With this workbook you can identify each individual expense and income by category flowing through your bank account in each of 12 monthly periods, budget and forecast your monthly cash flows.

You can download 30 workbooks now (or order the CD version). When we have received your order we will email passwords to your second download page which is located on our web site.

No comments:

Post a Comment