Financial Excel Collection

Activity Cost Analysis. Cost categories linked to employee database in Excel linked to work time minutes recording provide complete analysis of project costs by activity and by employee work time. Suitable for R&D tax credits cost analysis, project costing, staff costing records.

Stock Valuations - apply time value of money to determine fair value of shares. Demo example of undervalued PLC share.

Cash management - A/P & A/R controls with Excel workbooks.

Financial ratios. Balance sheet, income statement and cash flow analysis calculates 50 key ratios, including efficiency ratios, earnings ratios, operating ratios, shareholder returns, working capital ratios, debt, sales days, inventory turnover, and liquidity.Balanced Scorecard workbook with Excel.

Consolidating Excel budgeting workbook will save you time and money when you have to prepare monthly budgets for multiple profit departments.

Investment-Calc provides rate of return investment analysis, forecasting and risk control spreadsheets. Present values and internal rates of return, ROIC and discounted cash flows. Synergy net present values, cost of capital.

Asset Accounting. Our Asset Register provides all aspects of fixed asset and property management in an easy-to-use solution.

Lease/Loan Accounting keeps track of your loan accounts and consolidates current outstanding balances, monthly interest and repayment and forecasts annual cumulative totals and balances until repayment.

Inventory Control & Scheduling keeps track of 3,000 inventory items, calculates and remembers month end inventories.

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).

Costing & expense control including activity based costing, cost drivers, economic batch quantities, allocate overhead costs by department, allocates depreciation costs.

FastPlan prepares and analyses 5 year financial plans. Develops financial forecasts with simulated balance sheets, income forecasts and cash flows. Includes monthly sales forecasting, expenses by item.