Complete Excel Templates 2008 Collection

The Complete Excel Templates 2008 Collection provides 150 business finance spreadsheets, Excel add–ins and Excel Learning Modules plus eight new Risk Analysis spreadsheets which will help you manage financial risks and set goals quickly and effectively.

Investment-Calc 2008 spreadsheets for Present values and internal rate 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. The new 2008 edition includes acquisition synergy net present values, cost of capital, terminal (to infinity) net present values plus an updated Quick Guide to Investment Decisions. Plus Capital Project Cost recovery Risk Analysis

Project investment analysis: Inputs unit volume and unit price plus adjustments for sensitivity, cost of sale, company expenses, investment amount, debt/equity, tax rate, depreciation rule. Calculates EBITDA, operating and after tax profits, average annual income and ROIC, net present values & IRR.

12 month budgeting spreadsheets for 1-10 departments. Consolidates individual budgets year to date and provides monthly variance analysis.

Asset Register PRO 2008. Straight line depreciation register for max 10,000 assets. Assets may be allocated to any one of 100 classes and 100 locations. Totals depreciation and book values for all individual assets, classes and locations. Any single asset record within a class can be adjusted to any depreciation rate quickly and easily.

Excel Costing templates (complete 2008 collection) provides equipment, employee and materials data values to calculate standard costs. 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.

CheckMy Bank 2008.xls provides a quick way to check and verify compound interest calculations for overdraft bank accounts.

FastPlan 9.16 for five year financial plans. Develop your 5 year monthly budgets and FastPlan transfoms these into balance sheets, income forecasts and cash flows. Plus Risk analysis of profit forecasts.

Cash Flow & Liquidity Forecasting 2008.xls creates a cash flow forecast to 150 day horizon from Excel list of accounts payable and receivable with forecast banking dates. Set targets for late paying clients and Excel will notify you of your current late payers.

Now includes complete income statements, balance sheets and cash flows forecasting schedules which you can use to enter best case, median case and worst case 12 month financial forecasts. “Job one in 2008 is liquidity management”.

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 ahead and track cash flow variances against budget.