Excel Financial Templates w/ 2011 Editions

Consolidated Departmental Expense Budgeting.xls & .xlsx. Ten monthly department/divisional expense budget spreadsheets linked to a new revenue/cost of sales forecast combines all expenses and revenues into an overall budget for 2011. Revenue and cost of sales spreadsheet expanded to 100 rows each. Expenses spreadsheets also expanded to 100 rows.

Consolidated Profit Center Budgets .xls & .xlsx. Ten monthly revenues/cost of sales/department/divisional expense budget spreadsheets combines all divisional revenues, cost of sales and expenses into an overall budget for 2011. Revenue and cost of sales spreadsheet expanded to 100 rows each. Expenses spreadsheets also expanded to 100 rows for each profit center.
Screen image of consolidated budgets > http://twitlk.com/t/pyp

Lease/Loan Accounting 2011 has been expanded to 15 individual lease/loan accounts. Keeps track of your loan accounts and consolidates current outstanding balances, monthly interest and repayment and forecasts annual cumulative totals and balances until repayment. Another large file we will send to you via file sharing.

Investment-Calc provides project analysis cash flow spreadsheets. Incorporates Present values and internal rates of return of periodic cash flows over any forecasting period, calculates acquisition synergy net present values, cost of capital. Includes a 30 page Guide to Investment Rate of Return Calculations with formulas including worked examples.

Cash forecasting and control workbooks provides extra cash management oversight for any business.

Fixed Assets & Expenses Registers with Disposals Web Marketing for 2011 will help you log asset purchase costs, supplier information, addresses and contact addresses, asset serial numbers, bar code IDs, depreciation rules, depreciation lives, department location and manager responsible.
Monthly and cumulative depreciation plus book value for each asset, total asset class, department location and by manager responsible are all provided. Plus disposals marketing web software. Create web vouchers, the most powerful and successful tool available on the web to sell unwanted and surplus assets. Access to our web voucher software and examples of voucher html codes to add into Wordpress or your own website are included in the download workbook. Earn 40% of referred voucher revenues.

Risk Analysis Sales forecasting probability analysis, investment return risk, break even analysis with Monte Carlo methods.

Instant Balance Sheets gives you quick calculations of source and application of funds (bank balance forecasting).

Standard costing spreadsheets including ctivity based costing, cost drivers, economic batch quantities, allocate overhead costs by department, allocate depreciation costs.

Financial ratios. 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 prepares and analyzes 5 year financial plans. Develops financial forecasts with simulated balance sheets, income forecasts and cash flows. Includes monthly sales forecasting, expenses by item.