Return Home
Financial Statement Forecasting
For Excel 2003-2007

When you need a quick snap way to create your financial statement forecasts for your Senior managers, Bank manager or Shaerholders use 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.

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

Inputs and Outputs:

Download or select CD shipping:

 

User inputs Financial Statement Forecasts Financial Ratios Forecasts
  • Company name.
  • Variable Starting dates
  • Monthly Additions to fixed assets
  • Monthly depreciation
  • Forecast revenues, cost of sale, & expenses budgets
  • Forecast days sales, purchases & inventories outstanding, & payables forecasts.

 

 

 

 

 

 

 

 

 

 

Monthly:

  • Balance sheets.
  • Current assets
  • Total assets
  • Current liabilities
  • Total liabilities
  • Shareholder equity and liabilities to balance.
  • Net Asset value per share.
  • Operating Cash Flows
  • Investment Cash Flows
  • Monthly Cash Balances

 

 

 

 

 

Monthly:

Return on sales

Asset turnover

Asset leverage

Return on equity

Return on capital employed

Return on invested capital

Return on total assets

Current ratios

Quick ratios

EBIT/interest

Debt ratios

Debt Covenant coverages.