Excel Templates

FinExcelSoft FinStat Excel Templates

FinExcelSoft Correlation & Regression Templates

FinExcelSoft Annuities Excel Templates

FinExcelSoft Amortization Excel Templates

Financial Statement Forecasting PRO

Financial Statement Forecasting PRO enables you to set up a 12 month forecast of your financial statements starting at any month of your choice. As well as calculating monthly balance sheets, income statements and cash flows (source and application of funds) the workbook outputs all key operating, financial and shareholder ratios and financing covenant ratios.

Plus our 10 year financial statement forecasting workbook.

Quick and simple to use. No accounting knowledge is required.

Download as a zip file with tutorial instructions or select CD shipping option.

Financial Ratios with Excel

• Rate of Return on Assets (ROA)
• Rate of Return on Common Equity (ROE)
• Return on Capital (ROIC)
• Common Earnings Leverage
• Cash Flow from Operations/Total Cash Flow Ratio
• Cash Flow from Investments/Total Cash Flow Ratio
• Cash Flow from Financing/Total Cash Flow Ratio
• Operating Cash Flow/Current Liabilities Ratio
• Operating Cash Flow/Total Liabilities
• Operating Cash Flow/Capital Expenditures
• Working Capital/Current Liabilities Ratio
• Working Capital/Long Term Liabilities Ratio
• Working Capital/Total Debt Ratio
• Working Capital/Current Assets Ratio
• Working Capital/Total Assets Ratio
• Income Tax Expense/Revenues Ratio
• Total Assets Turnover Ratio
• Fixed Assets Turnover
• Current Ratio
• Acid Test (See note for Quick Ratio)
• Accounts Payables Turnover
• Days Accounts Payables outstanding
• Accounts Receivable Turnover Ratio
• Days Receivables Outstanding Ratio
• Inventory Turnover
• Days Inventory Outstanding
• Total Debt to Equity Ratio
• Total Debt Coverage ratio
• Long Term Debt Ratio
• Long Term Debt to Total Assets
• Long Term Debt to Shareholder Equity
• Total Liabilities/Total Assets
• Interest Coverage Ratio
• Altman’s Z (Solvency) Ratio.

Zip file download or select CD edition shipping.

Financial Excel All Programs Edition

Excel file sharing, online HTML Editor, Amortization NPV, HTML Emailer for your very own email templates, Gallery of images, professional headers for excel spreadsheets and much more all with this Complete Edition.

Investment-Calc 2008 spreadsheets for analysing 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, acquisition synergy net present values, cost of capital, terminal (to infinity) net present values.

Includes a 30 page Guide to Investment Calculations with formulas and rate of return spreadsheets.

Plus Project investment analysis spreadsheets analysing cash flows, EBITDA, operating and after tax profits, average annual income and ROIC, net present values & IRR.

Master Budgeting for 1-10 departments. Consolidates individual budgets year to date and provides monthly variance analysis. 12 months departmental budgets consolidated.

The Fixed Asset Accounting workbook provides all you need to keep track of and forecast depreciation for a maximum 3,000 assets. Use Excel 97-2003, 2007 & 2008 to work with depreciation records, book values and disposals. It will save you many hours of work with tax depreciation and deferred tax balances.

Lease Accounting aggregates repayment and interest balances for up to 3,000 capital leases. Models variations in lease repayment terms anytime during a lease payment.

Excel Costing templates provides standard costing models. 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 financial forecast and transfom these into simulated 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.

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.

BONUS EXCEL SKILLS PACK included.

FES emailer – POP3 emailer with anti-SPAM, re-sender, and encryption tools.

FastPlan 2008 Five Year Company Forecasting

With FastPlan you can quickly and easily change any variable input and drive the financial statements and cash flows to your target goals.

No accounting knowledge is required.

Plus three separate and additional workbooks.

1. Twelve months income statements, balance sheets and cash flows forecasting spreadsheet to develop high – low forecast scenarios to analyse your sales, profits, accounts receivable, accounts payable and total cash flows for each year for all possible outcomes.

2. Sales and Profits Risk Forecasting using Monte Carlo formulas.

3. Forecasting Risk analysis (probability of reaching goals) using Monte Carlo formulas.

FastPlan and the three additional bonus workbooks all run in Excel 2003-2007.

Download the zip file now or choose CD shipping.

Core fundamentals 1.

Keyboard functions, Cut, Copy, Insert, Delete, Paste Special, Custom Formatting, Undo, Redo, Excel Formulas – The least you should know, Useful functions and Paste Function, Calc, Comments, Drawing toolbar, Edit Replace, Delete Clear, Essential Printing, Data Sorting, Hiding, AutoFormats, Protection, Basic Charts, Basic Formatting, If Function.

Core fundamentals 2.

Improved working with Formulas, Worksheet Formulas, Extracting Data for Decision Making, Data Validation, Importing external data. Core fundamentals of Advanced Filters, AutoFilters, Names Charts, Under Utilized Features, Protection, Shared Workbooks, Track Changes, Merging Shared Workbooks, Custom Views, Report Manager, Hyperlinks, Outlining.

Core fundamentals 3.

Learn Advanced Formulas, Advanced Filters, Text To Columns, Importing Text Files, Pivot Tables 1, Pivot Tables 2, Pivot Tables 3, Scenarios, Goal Seek, Data Tables and Consolidation, Excel on the Web, Macros 1, Macros 2.

Plus Core Knowledge chapters 4, 5, 6 and 7 VBA and Macro developments.

Special Bonus: Excel Add-Ins improve your spreadsheets presentations and reduce your spreadsheet working hours.

• Duplication Manager • Formula Manager • Number Manager • Text Manager • Excel Plus • Named Range Manager • Formula Reference Changer • Sheet Index Creator • File Size Reducer Download or CD shipping.