Saturday, May 6, 2017

Excel Add-ins & Training Bible Complete Collection

Excel Add-ins & Training Bible Complete Collection


This extensive collection contains multiple Excel templates/workbooks for business finance applications and financial analysis. Included in the financial analysis template library are: Excel Templates for Cash Flow Forecasting. Cash Flow Templates provide cash flow reports and forecasts to forecast exact cash positions ahead with quick look up of any daily balance 1-120 days ahead. Financial Ratios. Calculates over fifty financial ratios to monitor company performance from two and five period balance sheet figures, income statements and cash flow templates. Ratios include profit ratios, return on assets, return on equity, economic value added, return on invested capital, working capital ratios, cash flow ratios, operating ratios, asset ratios, inventory ratios, payable and receivable ratios, acid test, quick ratio, debt ratios, solvency ratios, DuPont Ratios, and Core Ratios. Plus Altman's Z liquidity score. Project Evaluation. Net Present Value (NPV) and Internal Rate of Return (IRR) The NPV and IRR Excel templates calculate the NPV/ROIC and IRR of business investment projects. Asset Register. The Asset Register can be used with S/L, DB, DDB depreciation rules. Consolidates monthly and total depreciation and book values by item, class and department. Company Budgeting Templates. Provides linked monthly budgeting for any 12 month period. Starting any date, divisional budgets can be created to report actual and variances, allocate overheads to divisions, set differing cost of sales for each revenue line and generate a year to date budget report. Financial Plan Forecasting. Allows the creation of a 5 year monthly profit and loss, balance sheet and cash flow forecasts by creating simple monthly budgets. Setting up a start date, capital budget and optional share issues enables the automatic calculation of detailed financial plans. Investment and Company Valuations. These spreadsheet templates calculate the present value of any investment project or company based on cash flows and income forecasts. Revenue and EBITDA valuation benchmarks are provided for 100 business sectors help secure a current valuation based the financial forecasts. Costing Templates. The Excel costing templates assign individual, activity based, standrad or average costs to production or services, applying overhead recovery including depreciation to each product or service. The analysis includes benchmarking to other company cost expense ratios. Quick 5-Year Financial Plan with Ratios. Provides month by month budgets that extrapolate to produce five year monthly income statements, balance sheets and cash flow forecasts, bank balances and shareholder returns. Includes Executive Summary for an overview of key five year financial data with ratios. These templates are ideal for shareholders, investors, banks, business owners, and managers. Inventory Scheduling. Organizes product delivery timetables and stock level forecasting schedules. These spreadsheets indicate when to issue purchase order to sustain minimum stock balances. Lease and Loan Calculation. Calculates and combines current period payments of principal and interest, provides outstanding balances, months remaining, payments remaining and asset book values. Bond Valuations, Interest Rate Swap P/L and Present Value Tables. Many companies are pursuaded by banks to engage in swaping loan interest rates for another. Our Bond workbook enables you to evaluate interest rate swap potential for profit or loss. Compensation for Loss of Employment. Present values of loss of employment income over any future period.