|
The Complete Excel Templates 2008 Collection provides 150 business finance spreadsheets, Excel addins and Excel Learning Modules plus nine new Monte Carlo Risk Analysis & Forecasting spreadsheets which will help you manage financial risks and set goals quickly and effectively. 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. The new 2008 edition includes 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. 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 (complete 2008 collection) provides equipment, employee and materials data values to calculate standard costs. 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 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. ?Job one in 2008 is liquidity management?. 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. Sales & Profit Forecasting 2008 will help you forecast sales and profits from combining up to 15 different product or profit centers with varying ranges of inputs and costs, including volumes of incoming sales leads, costs per lead, lead conversion rates, price yields, profit margins, G&A recovery rates. Forecasts probabilities of achieving sales and profit goals. Zip file download or select CD edition shipping. You can download a zipped file containing 12 bonus excel files/workbooks/templates immediately after purchase including Monte Carlo Forecasting 2008, Balanced Scorecard, Capital Project Appraisal, Excel Amortization, Source & Application of Cash flows, Financial Models. THESE ARE NOT OUR PRINCIPAL FINANCIAL APLLICATIONS SEE BELOW. Despite the notice below that "You will be able to download the product immediately after ordering!", there will be a small time delay as explained above.
|
