The Financial Excel All Programs Edition provides 150 business finance 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 tax depreciation and deferred tax balances.
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 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.
Cash Flow & Liquidity Forecasting 2008.xls creates a cash flow forecast to 150 days horizon from Excel list of accounts payable and receivable with forecast banking dates.
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.
Key Features of Financial Excel All Programs Edition
Upgrade versions (Gold editions) for all programs and files listed above.
Gold edition files provide easy to follow demo/tutorials.
Full 24/7 support ... weekdays and weekends Millennium Software Inc. is available to answer your questions and provide assistance. There is nothing worse when you have a question than to have to wait for an answer. With purchase of the Gold Edition you get 24/7 support, always available and free.
Business templates with formulas
Quick Statistic Analysis for Business & Investments.
Operations Manager for inventory control, minimum stock management, re-ordering scheduling and least cost order quantities.
Free bonus Investment-CalcPlus Pack containing time saving short cuts for project valuation NPV & IRR forecasting using automated annuity factor calculations.
