Financial Management Excel Templates (All Inclusive 150 Workbook Pack)

Investment-Calc 2008 spreadsheets for 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.

Also included are functions to help you calculate acquisition synergy net present values, cost of capital, terminal (to infinity) net present values plus an updated Quick Guide to Investment Decisions. Plus Capital Project Cost recovery Risk Analysis.

Applicable and highly recommended for all types of business users and financial modeling and analysis learners worldwide.


More Information & Details:

Project investment analysis calculates EBITDA, operating and after tax profits, average annual income and ROIC, net present values & IRR.

12 month budgeting spreadsheets for 1-10 departments. Consolidates individual budgets year to date and provides monthly variance analysis.

Asset Register PRO 2008. Straight line depreciation register for max 10,000 assets. Assets may be allocated to any one of 100 classes and 100 locations. Totals depreciation & book values for individual assets, classes and locations. Any single asset record within a class can be adjusted to any depreciation rate.

Excel Costing templates provides equipment, employee and materials data values to calculate standard costs. Also 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 monthly budgets and FastPlan transfoms these into 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. Set targets for late paying clients and Excel will notify you of your current late payers.

Now includes complete income statements, balance sheets and cash flows forecasting schedules which you can use to enter best case, median case and worst case 12 month financial forecasts.

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.

Bank Cash Flows _ Budgets _ Actuals_Forecasts_Variances for Excel. With this workbook you can identify each individual expense and income by category flowing through your bank account in each of 12 monthly periods, budget and forecast your monthly cash flows ahead and track cash flow variances against budget.

Monte Carlo Sales and Profit Simulators will help you set financial goals and calculate the probability of achievement. Combines Monte Carlo generated sales leads with costs per lead, lead conversion rates, price yields, profit margins, G&A recovery rates to yield most probable sales and profit results for up to 15 products or profit centers.

All Files run in Excel 2003–2007 on a PC and Apple Mac.