AICS Research

Financial
Statement
Graphs

Last updated:

February 15, 1999
Summit Spectrum 28.13
Report highlights

This report is a graphical representation of some of the credit union's financial measures. Budgeted information is manually input. It could be retrieved if you input it into Summit's Budget module, another QueryCalc worksheet or in an ASCII file defined as a pseudodatabase. Actual data is retrieved from the databases. Ratio calculations are made from the data provided and several graphs have been created comparing the budgeted numbers against the actual. This report looks at capital adequacy, liquidity and earnings ratios.

A job and macro are included to allow the report to be automated to run at the end of the month without input or interference from an operator. In this way, the report is printed and waiting with the other month end reports.

Files included
  • FsGraphW - QueryCalc worksheet
  • FsGraphM - QueryCalc macro
  • FsGraphJ - job which runs the macro
  • FsGraphR - ASCII file which stores the delinquent loan history
  • Readme.txt - a text file of instructions
Databases accessed
  • GLDATA - Spectrum Image Database
Special Requirements

PostScript printer. In order to print the graphs you must have a PostScript printer.

QC Reports   QueryCalc
     Top