|
The Complete Excel Templates
2010 Collection provides all 180 business finance
spreadsheets within 30 workbooks. Plus Excel addins 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.
|