Skip to content

GLRATSCN General Ledger Financial Ratio Report

Financial Ratio Report

Application Overview

 The Financial Ratio Report provides a useful resource in both charting the performance of your organization and comparing it's various financial components over a given period of time. It displays four primary categories that measure business liquidity, activity, profitability, and leverage.  Each of these encompasses a group of ratios, derived from account information posted to the General Ledger File, according to the ratio type you set up in the G/L account file. 

 Before continuing further you should understand that even though ratio analysis is useful it has some limitations. Ratios are calculated with accounting data that can be affected by such variables as methods of depreciation and inventory validation. The interpretation of this information can vary among firms using different accounting procedures. You might want to seek the advice of a financial consultant in clarifying the trends suggested by this report.

 Note:  Due to the nature of the Ratio Calculation, both Year To Date and Current Period values will be calculated using the same data.  The calculation for Gross Profit on Sales will be the only ratio calculated differently for the Year To Date and Current Periods.

 

Calculation of Ratios

 Averages

 Averages are used to calculate Activity Ratios, and affect Balance Sheet type accounts.

 The calculation used to determine the average for one of these values is defined as follows:

 Average Value = (Ending Balance for the Last Fiscal Year + the sum of all of the Ending Balances for the periods up to the Current Period) divided by the number of periods being evaluated plus one.  The denominator or periods are incremented by one to account for the Ending Balance for the Last Fiscal Year added to the numerator.

By using this type of a calculation it is estimated that a more accurate average can be calculated.  For example, a calculation to determine an average Accounts Receivable Balance for period 3 would be calculated as follows:

 

(BBF+EB1+EB2+EB3)/4

 

BBF      =          The Ending Value of the Last Fiscal Year.

EB1      =          The Ending Balance of the 1st. Period

EB2      =          The Ending Balance of the 2nd. Period

EB3      =          The Ending Balance of the 3rd. Period

 

Example

Acct No: 01040-00000-00000    Accounts Receivable

BBF             EB1             EB2             EB3             Total           Average

10,000          11,000          15,000          19,000          55,000          13,750

  

Annualization

 An annualization of a balance is used for P&L type Accounts and BSNI (Net Income).  It is used to forecast an annual value based on the known activity through the current period being evaluated.

 The calculation to be used to estimate the Annualized amount is calculated as follows;

 

[EB(CP)/CP] x (No. of Periods)

 The Ending Balance for the Current Period divided by the period number that you are in multiplied by the number of Periods in the Period Account File.

 EB(CP) = The Ending Balance for the Current Period.

CP = Current Period Number

No. of Periods = The number of periods that are in the Period Account File.

 From a statistical standpoint, using an annualized amount for ratio calculations generates more meaningful ratio data throughout the year.  This Ratio data should be considered an interim value of the projected Year End performance.

 

Example

 Assuming that the Period Account File has 12 Periods and the Current Period is Period Number 3.

Sales:

        EB3             Annualized Amount

        250,000         1,000,000

 

Ratio Categories

 There are four groupings of ratios displayed.  They include Liquidity, Activity, Profitability, and Leverage ratios.

 

Liquidity Ratio Types

 Liquidity ratios measure your organization's capability of meeting its short term obligations. For example if your company has a sufficient amount of liquidity, it can take advantage of new investment opportunities and respond to a crisis.

 

Ratio

Description and Formula

Current Ratio

Measures your organization's ability to pay it's current liabilities from cash, cash equivalents and inventory.

Current Ratio              =              CA/CL

CA                           =              Current Assets

CL                            =              Current Liabilities

Current Assets CA are equal to the sum of the Ending Balance for the Current Period for Cash C + Receivables R + Inventory I + Other Current Assets CA.

Current Liabilities CL are equal to the sum of the Ending Balance for the Current Period for Payables P + Other Current Liabilities CL.

Quick Ratio

This is a more rigid measurement of liquidity than the current ratio. It measures your ability to pay current liabilities with cash and receivables or "Liquid" cash equivalents.

Quick Ratio =  (C + R + CA)/ CL.

These values are equal to the Ending Balance for the Current Period for

C              =              Cash

R              =              Receivables

CA           =              Other Current Assets

CL            =              Current Liabilities.

A/R To A/P Ratio

Indicates whether your company is receiving more money than it is paying out.

A/R To A/P Ratio = R/P .

These values are equal to the Ending Balance for the Current Period for:

R              =              Receivables

P              =              Payables.

 

Activity Ratio Types

 Activity ratios can be considered as a gauge that measures the amount invested in assets by your business relative to the revenue generated by those assets.

 

Ratio

Description and Formula

Asset Turn

Calculates how effectively your business is employing its total assets to generate sales. 

The Asset Turn Ratio = S/TA 

S              =              Sales (annualized)

TA            =              Total Assets

The Sales S value is annualized.  For a complete definition and calculation of annualization, see the Application Overview.

 

Asset Turn (continued)

Total Assets TA is the sum of the Ending Balance for the Current Period for:

Cash C + Receivables R + Inventory I + Current Assets CA + Property, Plant & Equipment E - Depreciation D + Other Non-Current Assets OA.

Fixed Asset Turn

Measures how effectively your business is using its property, plant and/or equipment to generate sales. 

Fixed Asset Ratio = S/(E + D)

These values are equal to the Ending Balance for the Current Period for:

S              =              Sales (annualized)

E              =              Property, Plant and Equipment

D              =              Depreciation.

The Sales S value is annualized.  For a complete definition and calculation of annualization, see the Application Overview.

Receivables Turn

Indicates how successful your business is at collecting receivable accounts or how many times your receivables turn over per year.

Receivable Turn Ratio = S/Avg R

S = Sales (annualized)

Avg R = Average Receivables

The Sales S value is annualized.  For a complete definition and calculation of Annualization, see the Application Overview.

For a complete definition of the Average Calculation, see the Application Overview.

Inventory Turn Ratio

 

 

Calculates the number of times that inventory was sold and replenished during the last year 

Inventory Turn Ratio = CS/Avg I

CS           =              Cost Of Goods Sold (annualized)

Avg I        =              The Average Inventory

The Cost Of Goods Sold CS is annualized.  For a complete definition and calculation of Annualization, see the Application Overview.

For a complete definition of the Average Calculation, see the Application Overview.

A/R To Sales Ratio

Measures the percentage of your total sales where payment was not received at the time of the sale.

A/R To Sales Ratio = Avg R/S

Avg R = Average Receivables

S = Sales (annualized)

The Sales S value is annualized.  For a complete definition and calculation of Annualization, see the Application Overview.

For a complete definition of the Average Calculation, see the Application Overview.

Inventory To Sales Ratio

Measures the percentage of inventory levels relative to sales.  

Inventory To Sales Ratio = Avg I/S

Avg I  =  The Average Inventory

S = Sales (annualized)

The Sales S value is annualized.  For a complete definition and calculation of Annualization, see the Application Overview.

For a complete definition of the Average Calculation, see the Application Overview.

No Of Day's In Inventory

Measures the typical number of days that inventory is in stock.

This ratio coincides with the Inventory Turn Ratio.

Number Of Day's In Inventory = Avg I/(CS/360)

Avg I = The Average Inventory

CS = Cost Of Goods Sold (annualized) /36 

For a complete definition and calculation of Annualization, see the Application Overview.

For a complete definition of the Average Calculation, see the Application Overview.

Avg Payment Period

Measures the timeliness in which your business pays its bills.

Average Payment Period Ratio = Avg P/(CS/360)

Avg P = Average Payables

CS    = Cost of Goods Sold (annualized) /360

For a complete definition and calculation of Annualization, see the Application Overview.

For a complete definition of the Average Calculation, see the Application Overview.

Avg Collection Period

An estimate of the average length of time your business will wait to receive payment after making a sale.  Coincides with Accounts Receivables Turn.

Average Collection Period Ratio = Avg R/S

Avg R  = Average Receivables

S = Sales (annualized) /360

For a complete definition and calculation of Annualization, see the Application Overview.

For a complete definition of the Average Calculation, see the Application Overview.

 

Profitability Ratio Types

 Profitability Ratios measure your rate of success in generating sales over a given period of time.  

 

Ratio

Description and Formula

Return On Assets Ratio

This ratio is also termed the rate of return on investment. It measures your organization's net income, to total asset investment.

Return On Assets Ratio = BSNI/TA

BSNI        =              Balance Sheet Net Income (annualized)

TA            =              Total Assets

The BSNI value is annualized.  For a complete definition and calculation of annualization, see the Application Overview.

Total Assets TA is the sum of the Ending Balance for the Current Period for Cash C + Receivables R + Inventory I + Current Assets CA + Property, Plant & Equipment E - Depreciation D + Other Non-Current Assets OA.

Profit Margin On Sales Ratio

Enables you to discern the percentage of gross profit for each dollar of sales.

Profit Margin On Sales Ratio = (S - CS)/S

These values will use both the period net change value and the Ending Balance value to generate both a Current Period Ratio and a YTD Ratio using the following

S              =              Sales

CS           =              Cost Of Goods Sold.

Return On Net Worth Ratio

This ratio measures your firms net income to its total net worth.

Return On Net Worth Ratio = BSNI/(TA - TL)

BSNI        =              Balance Sheet Net Income  (annualized)

TA            =              Total Assets

TL             =              Total Liabilities

Return On Net Worth Ratio (continued)

The BSNI value is annualized.  For a complete definition and calculation of annualization, see the Application Overview.

Total Assets TA is the sum of the Ending Balance for the Current Period for

Cash C + Receivables R + Inventory I + Current Assets CA + Property, Plant & Equipment E - Depreciation D + Other Non-Current Assets OA. 

Total Liabilities TL is the sum of the Ending Balance for the Current Period for Payables P + Other Current Liabilities CL + Long Term Liability OL.

 

 

Financial Leverage Ratio Types

 Financial Leverage ratios measure the amount of financial burden placed on your business by its debts.

 

Ratio

Description and Formula

Debts To Assets Ratio

Calculates the percentage of your total assets that are financed with creditors money. 

The Debt To Asset Ratio = TL/TA

TL             =              Total Liability

TA            =              Total Assets

Total Assets TA is the sum of the Ending Balance for the Current Period for Cash C + Receivables R + Inventory I + Current Assets CA + Property, Plant & Equipment E - Depreciation D + Other Non-Current Assets OA. 

Total Liabilities TL is the sum of the Ending Balance for the Current Period for Payables P + Other Current Liabilities CL + Long Term Liability OL.

Debt To Equity Ratio

Contrasts your firm's total liabilities to the amount of equity.

Debt To Equity Ratio = TL/EQ

TL             =              Total Liability

EQ           =              Equity

Total Liabilities TL is the sum of the Ending Balance for the Current Period for  Payables P + Other Current Liabilities CL + Long Term Liability OL.

Equity EQ is the sum of the Ending Balance for the Current Period for:

Retained earnings RE + Common/Preferred stock ST + Other Equity OE + BSNI.


 

Run Instructions

 Select Financial Ratio Report from the pull down G/L Reports window.  The following screen will then be displayed:

Financial Ratio Report Entry Screen

 The following options are available:

  • Select the desired mode from the Financial Ratio Report menu bar
  • Enter the data requested on the screen

 To return to the menu bar, press the ESC or F10 key. To leave this application, press X for EXIT when positioned at the menu bar.


Entry Field Descriptions

 

Name

Type and Description

1.  Ratio Period

2 numeric characters.  Enter the period number that you want considered in the report. This number must be on file in the Account Period File application.

2. Print Liquidity  Ratios?

Y or N.  Enter Y to display liquidity ratios or N to decline. This field defaults to Y.

3.  Print Activity  Ratios?

Y or N.  Enter Y to print activity ratios or N to decline. This field defaults to Y.

4.  Print Profitability  Ratios?

Y or N.  Enter Y to print profitability ratios or N to decline. This field defaults to Y.

5.  Print Leverage   Ratios

Y or N.  Enter Y to print leverage ratios or N to decline.  This Field defaults to N.

6.  Financial Entity

5 alphanumeric characters.  Enter a valid financial entity number present in your Financial Entity File.  The entity description will then automatically display.

If you want to skip this field, press RETURN.

7.  Profit Center

A standard profit center number in the standard profit center number format.

If your company does not use profit center, this field will be skipped.  Press RETURN to default to All profit center.

If a non-blank financial entity was entered above, the entry of this field will be skipped.



Financial Ratio Report

 

 

 

Feedback and Knowledge Base