The
model includes these features. Not all features are included in the Standard
version. |
|
• A cash flow
worksheet with starting and ending cash and sources and uses of cash for each
time period |
|
• A line of credit worksheet that displays |
– the weekly borrowing asset base composed of accounts
receivable and inventory, with adjustment factors |
– starting end ending loan balances, including new loan funds
and funds applied to loans |
– Line of credit worksheet is not included in the Basic version
of the model |
|
• Two Excel databases for hourly and
salaried employee data. The model extracts from these databases
summaries of cash disbursements
for employee expenses, based on payroll schedules. |
|
• Accounts
receivable data |
– You can custom-specify many receivables accounts |
– Optional Excel database for accounts receivable by invoice
number and customer, with estimates of
future receipts and new sales |
– A receivables aging report |
|
• Accounts
payable data |
– You can custom-specify many payables accounts |
– Optional Excel database for accounts payable by invoice number
and vendor with estimates of future
payments |
– A payables aging report |
|
• Optional
checking account float, to estimate the extra cash available from cash float. |
– Database with checking account data provides basis for
computation of cash float. |
|
• Optional
comparison of actual cash flow with planned cash flow and variance reporting |
|
• Optional
segmentation of cash flow into business segments. Includes summary cash flow
and optional
separate cash flow worksheet for
each segment. |
|
• Time grain can
be weeks, months, quarters or years |
|
• Excel graphs of key variables. These graphs are integrated
into the FinModel model from which they get
their source data. You can add more
graphs, and optionally import them to FinModel and include them
in future exported Excel workbooks. |