Saturday, October 3, 2009

Complete Excel Templates Financial Management 2009

This Complete Excel Templates Financial Management 2009 Collection provides 180 business finance spreadsheets, Excel add–ins and 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.

The 2009 Collection includes Cash Flow 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 examples.
  • 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.
  • Instant Balance Sheets.
  • 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...
You can download (or order the CD version) all these financial workbooks as well within this collection : Financial Plan for Bankers & Investors – Risk Forecasting – Capital Project Justification - Future Values – Merger & Acquisition Synergy Values – Company Valuation - Rate of Return Solutions – Multi Variable Investment Forecasting – Net Return on capital After Cost of Capital Calculations – Present Value of Capital Investment - …and more