Complete Excel Templates

Excel Financical Analysis Templates: Balance Sheet, Business Valuation, Cash Flow Forecast

 

You can download 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.

The Complete Excel Templates 2010 Collection provides all 180 business finance spreadsheets within 30 workbooks. Plus Excel add–ins and Risk Analysis spreadsheets which will help you manage financial assets, analyze investments, control cash flows, set up budgets and model financial statements and forecasts quickly and effectively.

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 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 transform these into simulated balance sheets, income forecasts and cash flows.

 

You can also buy the "Excel Financial Templates" from this page