Our Financial Excel workbooks include:
Project cash flows rate of return targeting using Excel Goal Seek. Adjust any individual income/cost/sale/recovery forecast and drive your project to the desired rate of return.
Investment-Calc 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.
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. For a more complete description copy this link into your browser.
Excel Financial Templates 2010 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.
This is a subscription based order because Lease/Loans Accounts Organiser 2010 software is web based. You will have the Premium Gold edition which allows 25 members to share. You will also receive additional free web office software over the coming months during your subscription period. You can cancel the subscription at any time.