This is not the document you are looking for? Use the search form below to find more!

Report

# Understanding the Ratio Analysis Report

Document Description
The Ratio Analysis Report function in the General Ledger module generates a report that helps you compare the company’s financial status and performance; not only with your company’s own goals, but also with your competitor’s goals and the industry standards. It also provides information necessary to help you make intelligent business decisions. This Technical Note discusses the prerequisites for using the Ratio Analysis Report, shows the formula for calculating each ratio, and identifies which ratio is preferable - a higher or lower one. This document is also provided to explain the significance of the ratio group in the GL Account ID record and to identify which ratios are not applicable in a company that uses fund accounting
File Details
• File size: 79.55kb
• Pages: 6
• Tags: understanding, ratio, report
• content preview
Submitter
• Name: monkey
• Documents: 474
Embed Code:

Related Documents

## Data Analysis: Analyzing Data - Ratio Analysis

by: monkey, 6 pages

Ratio analysis is an attempt to express the relationship between two or more Return to Table of Contents accounts or variables in a simpler, more comprehensive way. Ratios are usually

## Sales Analysis Report with Detail and CM Options

by: ville, 6 pages

This Extended Solution adds a Sales Analysis report that draws information from A/R Invoice History on Item Number, Description, Quantity in Cases, Weight in Lbs., Dollar Amount Sold, the Average ...

## Ratio Analysis

by: hendrik, 5 pages

A financial ratio is a relationship of two values of financial statements. Ratios basically are mathematical expressions, which are calculated to derive certain conclusion. The ratio may be expressed ...

## Used Vehicle Sales Log & Analysis Report

by: alide, 5 pages

The ExcelÂ® spreadsheets within this workbook are designed to assist both the General and Used Vehicle Sales Manager monitor Used Vehicle Sales within their dealership. They were originally created ...

## Analysis Report

by: Mert, 14 pages

Park Master Analysis Report

## Financial Ratio Analysis: the Development of a Dedicated Management Information System

by: samanta, 8 pages

This paper disseminates the results of the development process for a financial analysis information system. The system has been subject to conceptual design using the Unified Modeling Language (UML) ...

## Auditing and Assurance Services: Understanding the Integrated Audit, 1st edition, Karen L. Hooks, WILEY(March 2010, ©2011), TB

by: mysmandtb, 9 pages

Solution Manuals and Test Banks I have huge collection of solution manuals and test banks. I strive to provide you unbeatable prices with excellent support. So, I assure you that you won’t be ...

## Understanding The Work of Investigators

When talking about the constitution, two of the most common questions that usually pops up include when was the constitution written and why was the constitution created. This document changed the ...

## Understanding the Difference Between Reflex and Laser Sights

The reflex sights have become one of the most common ways to enhance one's shooting ability. There are several types available, including full tube and open sights. Often confused with laser sights, ...

## financial ratio analysis,financial ratios, financial modeling, financial ratios template

by: edupristine6, 2 pages

Financial Ratios are used to create a fully integrated Financial Model. Pristine conducts trainings on Financial Modeling to teach concepts such as Financial Ratios. Click here to read more.

Content Preview

Article # 1126
Technical Note: Understanding the Ratio Analysis Report
Difficulty Level: Beginner Level AccountMate User
Version(s) Affected: AccountMate 7 for SQL, Express and LAN
AccountMate 6.5 for SQL, MSDE and LAN
Module(s) Affected: General Ledger
Posting Date: 10/21/2009
DESCRIPTION
The Ratio Analysis Report function in the General Ledger module generates a
report that helps you compare the company’s financial status and performance; not
only with your company’s own goals, but also with your competitor’s goals and the
This Technical Note discusses the prerequisites for using the Ratio Analysis
Report
, shows the formula for calculating each ratio, and identifies which ratio is
preferable - a higher or lower one. This document is also provided to explain the
significance of the ratio group in the GL Account ID record and to identify which
ratios are not applicable in a company that uses fund accounting.
SOLUTION
A. Prerequisites to using the Ratio Analysis Report
If you would like to use the Ratio Analysis Report, you must first activate the
Ratio Analysis feature by performing these steps:
1. Access the GL Module Setup function from the Housekeeping menu.
2. In the General (1) Tab, mark the Use Ratio Analysis checkbox.
3. Click the OK button to close the GL Module Setup window.
4. Access the Chart of Accounts Maintenance function; then, verify in the
Information tab that an appropriate ratio group is assigned to each
applicable GL Account ID record.

B. Ratio Formula and Preferred Ratio Level
When you have activated the Ratio Analysis feature, you can access the Ratio

Analysis Report and select in the report interface an option to generate the
ratio you need. The table below illustrates for each ratio the calculation formula
and the preferred ratio level that is either higher or lower than your company’s
goals, your competitors’ performance or industry standards:

Preferred
Ratio
Formula
Ratio

Level
Accounts Receivable Ratios

Average Age of
Average Accounts Receivable
Lower
Receivables
Credit Sales

Note: Below is the computation for the

Average Account Receivables:

Beginning A/R balance \$ xxx.xx

-----------

Total xxx.xx

Divided by 2

-----------

Average Accounts Receivable \$ xxx.xx

======

Accounts
Credit Sales
Higher
Receivable
Average Accounts Receivable

Turnover

Days of Sales
Accounts Receivable
Lower
in Accounts
Credit Sales

Receivable

Inventory Ratios

Average Days to
Average Inventory
Lower
Turnover
Cost of Goods Sold

Note: Below is the computation for the

Average Inventory amount:

Beginning Inventory balance \$ xxx.xx

---------

Total xxx.xx
Divided by 2

---------

Average Inventory \$ xxx.xx

=====

Days of Sales
Ending Inventory
Lower
in Inventory
Cost of Goods Sold

Inventory
Cost of Goods Sold
Higher
Turnover
Average Inventory

Profitability Ratios

Asset
Net Sales
Higher
Turnover
Average Total Assets

Note: Below is the computation for the

Average Total Assets:

Beginning Total Assets amount \$ xxx.xx
Add: Ending Total Assets amount xxx.xx

---------

Total xxx.xx
Divided by 2

---------

Average Total Assets \$ xxx.xx

=====

Gross Profit
Gross Profit
Higher
Ratio
Net Sales

Profit Margin
Net Income
Higher
Net
Sales

Return on
Total
Net Income + Int. Expense (Net of Tax)
Higher
Assets
Average Total Assets

Return on
Net Income
Higher
Stockholder’s
Average Stockholder’s Equity
Equity

Note:
Below is the computation for the

Average Stockholder’s Equity:

Beginning Stockholder’s Equity \$ xxx.xx

---------

Total xxx.xx

Divided by 2

---------

Average Stockholder’s Equity \$ xxx.xx

=====

Liquidity Ratios

Acid-Test
Quick Assets
Higher
Current Liabilities

Note:
Below is the computation for the

Quick Assets:

Cash \$ xxx.xx

Receivables (Net) xxx.xx
---------
Total Quick Assets \$ xxx.xx

=====

Current Ratio
Current Assets
Higher
Current Liabilities

Stability Ratios

Debt Ratio
Total Liabilities
Lower
Total Assets

Debt-to-Equity
Total Liabilities – Stockholder Loans
Lower
Ratio
Stockholder Equity + Stockholder Loans

Equity Ratio
Stockholder Equity + Stockholder Loans
Higher
Total Assets

Return on
Net Income+Int. Exp. on Long-Term Debt
Higher
Long-Term
Ave. Total Assets – Ave. Current Liabilities
Capital

Note: Below is the computation for the

Average Current Liabilities:

Beginning Current Liabilities \$ xxx.xx

---------

Total xxx.xx
Divided by 2

---------
Average Current Liabilities \$ xxx.xx

=====

Times Interest
Pre-tax Operating Income
Higher
Earned
Interest Expense

Note: Below is the computation for the Pre-
tax Operating Income:

Net Income \$ xxx.xx

Taxes xxx.xx

---------
Pre-tax Operating Income \$ xxx.xx
=====

Stockholder Valuation Ratios

Book Value
Common Stockholder’s Equity
Higher
per Common
Outstanding Common Shares
Share

Earnings per
Net Income – Preferred Dividends
Higher
Share
Average Common Shares Outstanding

Note: Below is the computation for the
Average Common Shares Outstanding:

Beg. Common Shares Outstanding \$xxx.xx

Outstanding xxx.xx

---------
Total xxx.xx
Divided by 2

---------
Ave. Common Shares Outstanding \$xxx.xx

=====

Price /
Ending Market Price per Common Share
Higher
Earnings
Earnings per Share

C. Significance of the Ratio Group in the GL Account ID Record
You must assign an appropriate ratio group in the applicable GL Account ID
record. Incorrect assignment or non-assignment of a ratio group in a GL
Account ID record results in an inaccurate ratio. Analysis of the company’s
financial status and performance based upon incorrect ratios may result in
For example, if you assign a “Cash” ratio group to the Trade Accounts Receivable
GL Account ID record, the Age of Receivables ratio will be understated. The
presence of a low Age of Receivables ratio means that it takes a short amount of
time to collect your accounts receivable. If the reported Age of Receivables ratio
is lower than what it should be, you may not be aware that there is a problem

with collecting your accounts receivables; and thus, will not make decisions for
its resolution.
D. Ratios that are Not Applicable to a Non-Profit Company
If your company is using fund accounting, the following ratios are not applicable:
• All Profitability Ratios including Asset Turnover, Gross Profit, Profit Margin,
Return on Total Assets, and Return on Stockholder’s Equity
• Debt-to-Equity Ratio
• Equity Ratio
• All Stockholder Valuation Ratios including Book Value per Common Share,
Earnings per Share, and Price / Earnings.

As you can see from the information presented, understanding the Ratio Analysis
Report
provides a clearer understanding of the Ratio Analysis feature, the formulae
for the financial and performance ratios, the significance of assigning appropriate
ratio groups in the GL Account ID records as well as the ratios that are not applicable
to nonprofit companies.

This information is provided "AS IS" without warranty of any kind. AccountMate
Software Corporation (“AccountMate”) disclaims all warranties, either express or
implied. In no event shall AccountMate be liable for any damages whatsoever
including direct, indirect, incidental, consequential, loss of business profits, or special
damages, even if AccountMate has been advised of the possibility of such damages.

Understanding the Ratio Analysis Report

Share Understanding the Ratio Analysis Report to:

example:

http://myblog.wordpress.com/
or
http://myblog.com/

Share Understanding the Ratio Analysis Report as:

From:

To:

Share Understanding the Ratio Analysis Report.

Enter two words as shown below. If you cannot read the words, click the refresh icon.

Share Understanding the Ratio Analysis Report as:

Copy html code above and paste to your web page.