|
The new Complete Excel Financial Templates 2008 Collection provides 150 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.
Investment-Calc 2008 spreadsheets for analysing 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, acquisition synergy net present values, cost of capital, terminal (to infinity) net present values.
Includes a 30 page Guide to Investment Calculations with formulas and rate of return spreadsheets.
Plus Project investment analysis spreadsheets analysing cash flows, EBITDA, operating and after tax profits, average annual income and 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. Model variations in lease repayment terms anytime during a lease payment.
Excel Costing templates provides 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 workbook just added 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.
Capital project simulations with 15 variable inputs.
New Excel Finance Spreadsheets.
COMPLEMENTARY BONUS:
Stanford University Professor Tom Byers says all companies need to pay extra attention to cash flows because if they run out of cash - game over for them. Use our PRE-RELEASE 2009 Excel Finance spreadsheets.
24 extra Excel files free with purchase.
Link to this web site for screen images of a selection of complementary files you will receive:
http://directory.managementcorner.net/2009edition/index.htm
Download files or select the CD edition.
|
