Balance Sheet Chart

 

Asset to Debt Ratio

Explanation

Determines how much of the Organisations assets have been financed by debt. A good ratio is usually 2:1, for every dollar of liabilities you have $2 of assets.

Formula

Assets / Liabilities

 

Balance sheet components

Explanation

Shows proportion of assets (green) compared to liabilities (orange). The darker the shade the more liquid the asset or liability.

 

Current ratio trend

Explanation

Current ratio is used to test company’s liquidity. Derives the proportion of current assets available to cover current liabilities. The black line represents the trend

Formula

Current Assets / Current Liabilities

 

Equity trend

Explanation

Assesses the level of equity at the end of each month. The black line represents the trend.

Formula

Assets - Liabilities

 

Liquidity - cash and debtors

Explanation

Shows the level debtors and cash on hand at month end. The potential bank balance is shown if all debtors were to pay today.

Report Codes

Cash = ASS.CUR.BAN

Debtors = ASS.CUR.REC

 

Liquidity monitor

Explanation

Shows the availability of cash and other assets to cover accounts payable, short term debt and other liabilities.

Formula

Current Assets - Current Liabilities

 

Return on Capital Employed

Explanation

Indicates the efficiency and profitability of a company’s capital investments. Should always be higher than the rate at which the organisation borrows, otherwise any increase in borrowing will reduce investor’s earnings.

Formula

EBIT / (Total Assets - Current Liabilities) * 100

 

Receivables

Explanation

Shows total accounts receivable split between current debtors (0-30 days green) and aged debtors (30+ days orange).

Formula

Aged Receivables = Accounts Receivable (ASS.CUR.REC)

Current Receivables = Trading Revenue (REV.TRA)

 

Return on Investment

Explanation

Evaluates the efficiency of an investment or compares the efficiency of a number of different investments.

Formula

EBIT / (Total Assets - Total Liabilities) * 100

 

Stock on Hand

Explanation

Shows the level of stock at month end to assist with making decisions around ordering and storage.

Formula

EXP.COS.CLO

Release Notes - Terms of Use - Privacy Policy - Launch Application - Copyright Spotlight Reporting 2019