| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Cash Flow with Optional Line of Credit | |||||
2 | ||||||
3 | You can get your own custom version of this template in minutes. Visit our website, select the model, fill-in the simple online form, and export the generated spreadsheet to your Google Docs account. | |||||
4 | Get yours now! | |||||
5 | ||||||
6 | Need more? Let us build spreadsheet solutions for you. | |||||
7 | Our deep experience and powerful, proprietory tools help us build customizable models that are realistic and reliable, taking a fraction of the time and cost required by conventional approaches. | |||||
8 | Learn more about consulting services. | |||||
9 | ||||||
10 | ||||||
11 | ||||||
12 | Description of the Cash Flow with Optional Line of Credit | |||||
13 | ||||||
14 | This cash flow model should be utilized as a planning tool for the management of cash flows, and to allow a business owner or manager to know in advance when there will be a cash shortfall or excess cash. It includes an analysis of line of credit and borrowing base under an asset-based borrowing agreement. | |||||
15 | ||||||
16 | The model includes these features. Not all features are included in the Standard version. | |||||
17 | ||||||
18 | • A cash flow worksheet with starting and ending cash and sources and uses of cash for each time period | |||||
19 | ||||||
20 | • A line of credit worksheet that displays | |||||
21 | – the weekly borrowing asset base composed of accounts receivable and inventory, with eligilibity factors | |||||
22 | – starting end ending loan balances, including new loan funds and funds applied to loans | |||||
23 | – Line of credit worksheet is not included in the Basic version of the model | |||||
24 | ||||||
25 | • 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. | |||||
26 | ||||||
27 | • Accounts receivable data | |||||
28 | – You can custom-specify many receivables accounts | |||||
29 | – Optional Excel database for accounts receivable by invoice number and customer, with estimates of future receipts and new sales | |||||
30 | – A receivables aging report | |||||
31 | ||||||
32 | • Accounts payable data | |||||
33 | – You can custom-specify many payables accounts | |||||
34 | – Optional Excel database for accounts payable by invoice number and vendor with estimates of future payments | |||||
35 | – A payables aging report | |||||
36 | ||||||
37 | • Optional checking account float, to estimate the extra cash available from cash float. | |||||
38 | – Database with checking account data provides basis for computation of cash float. | |||||
39 | ||||||
40 | • Optional comparison of actual cash flow with planned cash flow and variance reporting | |||||
41 | ||||||
42 | • Optional segmentation of cash flow into business segments. Includes summary cash flow and optional separate cash flow worksheet for each segment. | |||||
43 | ||||||
44 | • Time grain can be weeks, months, quarters or years | |||||
45 | ||||||
46 | • Excel graphs of key variables | |||||
47 | ||||||
48 | Acknowledgements | |||||
49 | ||||||
50 | The original version of this cash flow model was designed by Marilyn Magett of CRS Financial Management Solutions, Inc. Marilyn is a CFO for businesses in transition and distress. She serves her clients as a Consulting, Interim, or Turnaround CFO. | |||||
51 | Please visit her website at www.crsfinmgmt.com | |||||
52 | or contact her at mjmagett@crsfinmgmt.com. | |||||
53 | ||||||
54 | ||||||
55 | This workbook was generated by ModelSheet on March 11, 2011, except for this worksheet of comments. | |||||
56 | ||||||
57 | Copyright © 2009-2011 ModelSheet Software, LLC | |||||
58 | ModelSheet and the ModelSheet logo are registered trademarks of ModelSheet Software, LLC. |