Definitions for Statistics and Ratio Report

Definitions for Statistics and Ratio Report

How is the Ratio and Statistics report in Forecast 5 calculated:

Break even sales
Is the total sales needed to make zero profit.

Sales cover
This is the ratio of sales to total costs.
  1. Below 1 means you are not making enough money to meet your costs.
  2. Above 1 means you are making profit.
Gross profit margin
This is gross profit / total sales expressed as a percentage.

Net profit margin
This is net profit / total sales expressed as a percentage.

Liquid ratio
Current Assets minus Stock On Hand divided by Creditors Due Within One Year.

Current Ratio
Current assets divided by Current liabilities

Return on Net Assets
Net Profit divided by Fixed Assets plus NWC 
Where NWC = Current assets minus Current liabilities due in one year

Return on Capital
(Operating Profit minus Invest Income divided by Net assets

    • Related Articles

    • One Touch Reporting: The report is showing old figures.

      Question: When running my One Touch Report, it is showing old figures or dates in the reports exported. Answer:  One Touch Reporting saves the exported report into your Documents folder, using the name of your forecast. If you have run the OTR report ...

    • Hotlink: P&L Report Still Reflecting Old Figures

      Issue: When using Hot Links in a forecast, you have updated the figures in the spreadsheet, refreshed the link and the record is correct but when you run the P &L report the old figures are still appearing.   Solution: Remove the Hot Link for each ...

    • Forecast 5 Essentials Guide - the basics of Forecast 5

      This guide will walk you through the steps of setting up and using Forecast 5. Introduction to Forecast 5 Forecast 5 is a purpose-built forecast and budgeting tool that uses a pre-built metric template and contains an integrated report set (P&L, ...

    • Forecast 5 Demo Data

      Downloaded and installed Forecast 5 and you aren't sure where to start? We have provided a demo data forecast that will help you see most of the features and benefits that Forecast 5 has to offer. Download the attached demo data (found at the bottom ...

    • P&L Reports - Unable to view reports

      Issue: When trying to run the P&L report, the report will not display. All other reports are working fine. Solution: This is caused by the use of SQL Server 2008, which is not supported by Forecast 5. Please upgrade to a supported version of SQL, ...