| CASH FLOW MANAGEMENT - TREND ANALYSIS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
| |
|
|
VIEW SAMPLE COMMENTS: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
List Box Control |
2 |
|
|
|
SERIES 1 |
SERIES 2 |
SERIES 3 |
SERIES 4 |
FINANCIAL PERIODS |
| |
Current Date: |
15-Oct |
|
The
reports you are viewing require NO data input, they are generated simply by entering basic
information on the |
|
Selected Chart Title |
NET CASH FROM OPERATION |
|
|
BASE |
0 |
0 |
0 |
0 |
Dec-04 |
| |
|
|
|
Edit Financial Data
worksheet. The lack of stored data limits displaying of graphs on the sample view. |
|
|
|
|
|
|
Chart Names-DropDown |
TOP
10 REPORTS |
|
|
MONTH 1 |
0 |
0 |
0 |
0 |
Jan-05 |
| |
FINANCIAL DATA |
|
|
ONLY CHART NAMES ARE |
NET CASH FROM OPERATION |
|
|
MONTH 2 |
0 |
0 |
0 |
0 |
Feb-05 |
| |
EDIT FINANCIAL
DATA |
|
|
|
|
|
FIXED VALUES |
INVENTORY WORKING CAPITAL |
|
|
MONTH 3 |
0 |
0 |
0 |
0 |
Mar-05 |
| |
REVIEW
FINANCIAL PERIOD |
|
|
|
|
NEW VEHICLES TO NOTES PAYABLE |
|
|
MONTH 4 |
0 |
0 |
0 |
0 |
Apr-05 |
| |
DATA VARIANCE
REVIEW |
|
|
|
|
USED VEHICLES TO NOTES PAYABLE |
|
|
MONTH 5 |
0 |
0 |
0 |
0 |
May-05 |
| |
DATE &
DEFAULT SETTINGS |
|
|
|
|
CURRENT ASSETS, Cash & A/R's |
|
|
MONTH 6 |
0 |
0 |
0 |
0 |
Jun-05 |
| |
|
|
|
CURRENT LIABILITIES, w/o floor plan |
|
|
MONTH 7 |
0 |
0 |
0 |
0 |
Jul-05 |
| |
REPORTING OPTIONS |
|
|
|
|
NET SALES TO INVENTORY CAPITAL |
|
|
MONTH 8 |
0 |
0 |
0 |
0 |
Aug-05 |
| |
CASH FLOW
SUMMARY |
|
|
|
|
|
NET SALES TO GROSS PROFIT |
|
|
MONTH 9 |
0 |
0 |
0 |
0 |
Sep-05 |
| |
BALANCE SHEET
TRENDS |
|
|
|
|
|
NET SALES TO BALANCE SHEET |
|
|
MONTH 10 |
0 |
0 |
0 |
0 |
Oct-05 |
| |
COMMON SIZE
ANALYSIS |
|
|
|
|
|
SUSTAINABLE GROWTH |
|
|
MONTH 11 |
0 |
0 |
0 |
0 |
Nov-05 |
| |
RATIO ANALYSIS
SUMMARY |
|
|
|
|
|
CASH
FLOW PERIOD ANALYSIS |
|
|
MONTH 12 |
0 |
0 |
0 |
0 |
Dec-05 |
| |
|
|
|
|
TOTAL CASH FLOW |
|
|
| |
CHART SELECTION OPTIONS |
|
|
|
OPERATING CASH FLOW (OCF) |
|
|
| |
|
|
|
INVESTING CASH FLOW (ICF) |
|
|
| |
|
|
FINANCING CASH FLOW (FCF) |
|
|
Y Axis Name |
DOLLAR
VALUES |
|
| |
|
|
OCF - INVENTORIES |
|
|
2 options assigned by macros: Dollar Value or %
Value |
|
| |
|
|
OCF - ACCOUNTS & NOTES PAYABLES |
|
|
|
| |
|
|
ICF - GROSS ASSETS & WORKING |
|
|
|
| |
|
|
FCF - DEBT, RESERVES, MORTGAGES |
|
| |
|
|
BALANCE
SHEET TRENDS |
|
Chart Footer Comments - 3 Lines Available, Comments
within macro routine |
| |
HINTS AND DIRECTIONS |
|
|
|
NET WORKING CAPITAL |
|
Compares Net Cash from Operations (Net Income +
Depreciation + LIFO Adjustments) to the actual acquisition of |
| |
TEMPLATE
DIRECTIONS |
|
|
|
SALES TO OPERATING INVENTORIES |
|
cash retained by organization (OCF+ICF+FCF). The key
observation is more cash flowing out than generated |
| |
CONTACT US
& FAQ's |
|
|
|
OPERATING ASSETS |
|
by
Net Cash (Income, Depreciation, & LIFO) ? |
| |
ADMINISTRATOR |
|
|
|
TOTAL NON-CURRENT LIABILITIES |
|
| |
|
|
COMMON
SIZED % OF ASSETS |
|
| |
|
Compares
Net Cash from Operations (Net Income + Depreciation + LIFO Adjustments) to
the actual acquisition of |
|
|
OPERATING INVENTORY CAPITAL |
|
| |
cash
retained by organization (OCF+ICF+FCF). The key observation is more cash
flowing out than generated |
|
|
OPERATING ASSET CAPITAL |
|
Balance Sheet Validation
Check |
0 |
|
|
| |
|
by Net Cash (Income,
Depreciation, & LIFO) ? |
|
|
CURRENT ASSETS TO LIABILITIES |
|
| |
|
LIABILITIES & EQUITY % OF ASSETS |
|
| |
Chart Series Names |
NET CASH FROM OPERATION |
|
| |
|
TOTAL CASH FLOW |
|
| |
|
NET INCOME After taxes |
|
| |
|
DEFAULT ZERO |
|
| |
|
|
| |
|
| |
|
| |
|
| |
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|