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

    • 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, ...

    • Suppress Zero Lines On Reports

      By default, zero lines on the report sets will be suppressed. If you would like to show all line, you can go to Settings > Preferences > Report Settings & Security and untick Suppress Zero Rows:   Refresh your reports and the lines will appear or ...