8Financial Statements
Option 8Ratios List
This function prints a list of the Ratios file. The following processing steps accomplish this job.
- Step 1In preparation for performing a sort/selection process on the Ratio Detail information, this step provides you with a default sequencing of data records by Ratio No, Numerator/Denominator, and Sequence No, with the option to change the sequence at run time. Selection of data records is provided by Ratio No and Changed On, with the option to enter user-specified comparisons at run time.
- Step 2This disposition type is used for all lists of master file information.
- Step 3According to previously specified criteria, this step actually performs the desired selection and/or sorting process.
- Step 4In order to print the Ratios List, this step formats the Ratio Detail information. The following data items are shown: Numerator/Denominator, Sequence No, Constant, Account Description, Balance Type, Start Month, Start Fiscal Year, End Month, End Fiscal Year, Operation, Currency Code, and Unit/Budget Type. As appropriate, group headings appear whenever a change occurs in Ratio No.
A sample output is shown below.
Expert Computing, Inc.
11/03/94 16:59 LGG Page: 1
Ratios List
Bal Start End Unit/Budget
N/D Seq Constant Account Description Type Month Month Op Currency Type
=================================================================================================================================
0001 Current Ratio
N 010 19000999 Assets, Current B 000 000
D 020 29000999 Liabilities, Current B 000 000
D 030 -1.00 *
0002 Inventory Turnover
N 010 4010000000 Cost of Goods Sold, Interco. B 000 000
N 020 4010000000MA Cost of Goods Sold, Corp./Mfg. B 000 000 +
N 030 4010000000WH Cost of Goods Sold, Corp/Whlsl B 000 000 +
N 040 4010000001MA Cost of Goods Sold, Sales/Mfg. B 000 000 +
N 050 4010000001WH Cost of Goods Sold, Sales/Whls B 000 000 +
D 010 1070001000MA Inventory, Corp./Mfg. B SOY 89 SOY 89
D 020 1070002000MA Inventory, Canadian Corp./Mfg. B SOY 89 SOY 89 +
D 030 1080001000MA Work in Process, Corp./Mfg. B SOY 89 SOY 89 +
D 040 1080002000MA Work in Proc, Canada Corp/Mfg B -12 000 +
D 050 1090001000MA Finished Goods B SOY 89 SOY 89 +
D 060 1090002000MA Finished Goods, Canadian B SOY 89 SOY 89 +
D 070 1100001000WH Resale Inventory B SOY 89 SOY 89 +
D 080 1100001001WH Resale Inventory, Sales Outlet B SOY 89 SOY 89 +
D 090 1100002000WH Resale Inventory, Canadian B SOY 89 SOY 89 +
D 100 1070001000MA Resale Inventory, Canadian EOY 89 EOY 89 +
D 110 1070002000MA Inventory, Canadian Corp./Mfg. B EOY 89 EOY 89 +
D 120 1080001000MA Work in Process, Corp./Mfg. B EOY 89 EOY 89 +
D 130 1080002000MA Work in Proc, Canada Corp/Mfg B EOY 89 EOY 89 +
D 140 1090001000MA Finished Goods B EOY 89 EOY 89 +
D 150 1090002000MA Finished Goods, Canadian B EOY 89 EOY 89 +
D 160 1100001000WH Resale Inventory B EOY 89 EOY 89 +
D 170 1100001001WH Resale Inventory, Sales Outlet B EOY 89 EOY 89 +
D 180 1100002000WH Resale Inventory, Canadian B EOY 89 EOY 89 +
D 190 2.00 /
0003 Debt Ratio
N 010 29002999 Total Liabilities B EOY 89 EOY 89
N 020 -1.00 *
D 010 19002999 Total Assets B EOY 89 EOY 89
0004 Receivable Turnover
N 010 3010001000 Sales, Intercompany B -12 EOY 89
N 020 3010001000 Sales, Intercompany B SOY 90 000 +
N 030 3010001001MA Sales, Manufacturing B -12 EOY 89 +
N 040 3010001001MA Sales, Manufacturing B SOY 90 000 +
N 050 3010001001WH Sales, Wholesale B -12 EOY 89 +
N 060 3010001001WH Sales, Wholesale B SOY 90 000 +
N 070 3010002001MA Sales, Canadian Manufacturing B -12 EOY 89 +
N 080 3010002001MA Sales, Canadian Manufacturing B SOY 90 000 +