13 Week Cash Flow Analysis
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View 13 Week Cash Flow Analysis as PDF for free.
More details
- Words: 5,074
- Pages: 45
Application: 13-Week Cash Flow Model About ModelSheet This Excel workbook was generated using ModelSheet, a revolutionary new spreadsheet technology. ModelSheet allows you to develop business models using readable formulas, while avoiding the details of cell addresses and hardto-change sheet layouts. The end result is a conventional Excel workbook just like this one. We built ModelSheet because we believe that spreadsheets are a great way of communicating results but we think it's just too hard to use them to develop reliable, maintainable, expressive and collaborative models.
You'll be able to get a glimpse of ModelSheet's advantages when you take a look at the "Formulas" tab and realize how few separate, readable formulas are needed to produce all of the other worksheets. In addition to formulas, ModelSheet knows about the "dimensions" in your model (e.g., products, locations, departments) as well as the time series that you're using (e.g., 5 years in quarters.) ModelSheet raises the level of thinking and acting from individual cells to natural modeling concepts. It enhances model reliabilty, auditability and maintainability; it enables you to build models that better reflect your intentions; it allows easier collaboration between modelers, developers, and report users; and it improves productivity, especially when making changes to a model. ModelSheet will be available in several forms. ModelSheet Authoring is a SaaS application for developing and maintaining business models and delivering them in conventional spreadsheets. With this product you can build models from scratch or explore and modify existing models. ModelSheet Templates provides a simple interface that allows you to pick an existing model and easily specify time frames, dimensions and layout parameters and produce an Excel template like this one to your exact specifications. ModelSheet also offers pre-built models and consulting services. We have a lot more to tell you about ModelSheet and we'd really like to hear from you about your needs for modeling and templates. Please visit our website at www.modelsheetsoft.com or contact us at [email protected]. Acknowledgements This cash flow model was designed by Marilyn Magett of Corporate Restructuring Solutions, Inc. Marilyn is a CFO for businesses in transition and distress. She serves her clients as a Consulting, Interim, or Turnaround CFO. Please visit her website at www.restructuringsolutions.com or contact her at [email protected]. Description of the application This application is a basic 13-week cash flow model. It 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.
ModelSheet is a trademark of ModelSheet Software, LLC
page 1 of 45
The basic model includes these features. • A cash flow worksheet with starting and ending cash and sources and uses of cash. • Collections from trade accounts receivable and other sources. • Disbursements for several types of production expenses, salaried and hourly employee expenses, facilities, and other expenses. • Two Excel databases for hourly and salaried employee data. • Excel graphs of key variables. These graphs are integrated into the ModelSheet model from which they get their source data. You can add more graphs, and optionally import them to ModelSheet and include them in future exported Excel workbooks. As you explore the model, we suggest that you • Read some of the Excel comments that are attached to Analysis Variables throughout the workbook. These comments also appear in ModelSheet in convenient places. • View worksheet "Formulas" which shows the named variables and symbolic formulas of the model in a compact and readable form. The symbolic formulas are not active in this Excel workbook, but they give you some idea how the model works, and how it looks in ModelSheet. This model serves as the basis for more advanced cash flow models that include the following additional features. • A borrowing base worksheet that presents the borrowing asset base and loan balances. • An Excel database for accounts receivable data, estimates of future receipts, and new sales, a pivot table summary of accounts receivable, and a receivables aging report. • An Excel databases for accounts payable data, estimates of future payments, new purchases, a pivot table summary of accounts receivable, and a payables aging report. • Department cost centers, and business unit profit centers. Contact ModelSheet Software, LLC for access to these models. Suggestions for using this model 1. Use this workbook as-is to model your cash flows. You can change the data in the dark blue input cells. You can change display names of dimension items and variables in the dark blue cells on worksheet "Labels." 2. Customize this Excel workbook to make the model fit your cash flow. For example, you can add or remove sources and uses of cash. 3. Use ModelSheet to edit the formulas in this model, using named variables, symbolic formulas (and far fewer formulas), segmentation dimensions and time series, without ever touching a cell address -- and end up with a conventional Excel workbook. To obtain a trial account for ModelSheet, go the the ModelSheet website below and request a trial account. This Excel workbook was generated by ModelSheet on March 20, 2009, except for this worksheet of comments. Copyright © 2009 ModelSheet Software, LLC ModelSheet and the ModelSheet logo are registered trademarks of ModelSheet Software, LLC.
ModelSheet is a trademark of ModelSheet Software, LLC
page 2 of 45
Ending Cash $1 $1 $1 $1 $1 $0
Column A
$0 $0 $0 $0
Ro w
1
$0
Receipts $1 $1 $1 $1 $1 $0
Column A
$0 $0 $0 $0
Ro w
1
$0
Disbursements $1 $1 $1 $1 $1 $0
Column A
$0 $0 $0 $0
Ro w
1
$0
Company Name
ABC Corp.
Preparer Name
Corporate Restucturing Solutions, Inc.
Cash Initial Cash
$15,000.00 WE 4/11/2009
WE 4/18/2009
Receipts A/R - Trade
$92,464.00
$7,632.00
$0.00
$465.00
$10.00
$12.00
Other
$0.00
$0.00
Total
$92,474.00
$8,109.00
$3,225.00
$222.00
$0.00
$0.00
A/R Line of Credit DIP Financing
Expenses Production Disbursements Raw Material Capital Expenditures Tooling
$2,554.00
$0.00
Total
$5,779.00
$222.00
$0.00
$200.00
Interest Expense
$62.00
$0.00
Other Expense
$11.00
$11.00
$0.00
$0.00
Bankruptcy
Travel & Entertainment
Labor WE 4/11/2009
WE 4/18/2009
Cash Payroll Hourly Payroll
$6,307.50
$6,307.50
Salaried Payroll
$16,685.85
$16,685.85
Total
$22,993.35
$22,993.35
Hourly Employees Hourly Payroll Tax %
15.00%
Hourly Benefits %
10.00%
Designed by Corporate Restructuring Solutions, Inc. Built with software from ModelSheet Software, LLC.
ABC Corp. 13-Week Cash Flow - Basic Prepared by Corporate Restucturing Solutions, Inc. Inputs
WE 4/25/2009
Apr 2009
WE 5/2/2009
WE 5/9/2009
WE 5/16/2009
WE 5/23/2009
$8,320.00
$108,416.00
$3,552.00
$0.00
$500,048.00
$0.00
$0.00
$465.00
$0.00
$0.00
$0.00
$745.00
$0.00
$22.00
$0.00
$0.00
$15.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$8,320.00
$108,903.00
$3,552.00
$0.00
$500,063.00
$745.00
$520.00
$3,967.00
$2,776.00
$0.00
$254.00
$0.00
$0.00
$0.00
$0.00
$0.00
$25,554.00
$0.00
$5,445.00
$7,999.00
$0.00
$2,554.00
$0.00
$0.00
$5,965.00
$11,966.00
$2,776.00
$2,554.00
$25,808.00
$0.00
$178.00
$378.00
$80.00
$0.00
$165.00
$178.00
$0.00
$62.00
$0.00
$76.00
$0.00
$0.00
$11.00
$33.00
$11.00
$11.00
$11.00
$11.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
WE 4/25/2009
Apr 2009
WE 5/2/2009
WE 5/9/2009
WE 5/16/2009
WE 5/23/2009
$6,607.50
$19,222.50
$6,607.50
$6,607.50
$6,607.50
$5,857.50
$16,685.85
$50,057.54
$17,548.91
$17,548.91
$17,548.91
$17,548.91
$23,293.35
$69,280.04
$24,156.41
$24,156.41
$24,156.41
$23,406.41
Salaried Employees Salaried Payroll Tax %
15.00%
Salaried Benefits %
10.00%
uring Solutions, Inc.
WE 5/30/2009
May 2009
WE 6/6/2009
WE 6/13/2009
WE 6/20/2009
WE 6/27/2009
Jun 2009
$44,416.00
$548,016.00
$12,320.00
$168,848.00
$2,000.00
$0.00
$183,168.00
$0.00
$745.00
$0.00
$0.00
$1,012.00
$0.00
$1,012.00
$0.00
$15.00
$0.00
$17.00
$0.00
$0.00
$17.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$44,416.00
$548,776.00
$12,320.00
$168,865.00
$3,012.00
$0.00
$184,197.00
$0.00
$3,030.00
$548.00
$5,445.00
$0.00
$0.00
$5,993.00
$0.00
$25,554.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$2,554.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$31,138.00
$548.00
$5,445.00
$0.00
$0.00
$5,993.00
$80.00
$503.00
$0.00
$0.00
$80.00
$178.00
$258.00
$69.00
$145.00
$0.00
$0.00
$0.00
$0.00
$0.00
$11.00
$55.00
$11.00
$11.00
$11.00
$11.00
$44.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
WE 5/30/2009
May 2009
WE 6/6/2009
WE 6/13/2009
WE 6/20/2009
WE 6/27/2009
Jun 2009
$5,857.50
$31,537.50
$5,857.50
$5,857.50
$5,857.50
$5,857.50
$23,430.00
$17,548.91
$87,744.53
$17,548.91
$17,548.91
$17,548.91
$17,548.91
$70,195.63
$23,406.41
$119,282.03
$23,406.41
$23,406.41
$23,406.41
$23,406.41
$93,625.63
WE 7/4/2009
Jul 2009
$51,600.00
$51,600.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$51,600.00
$51,600.00
$3,225.00
$3,225.00
$0.00
$0.00
$0.00
$0.00
$3,225.00
$3,225.00
$80.00
$80.00
$0.00
$0.00
$11.00
$11.00
$0.00
$0.00
WE 7/4/2009
Jul 2009
$5,857.50
$5,857.50
$17,548.91
$17,548.91
$23,406.41
$23,406.41
WE 4/11/2009 Week Beginning Cash Balance
WE 4/18/2009 1
WE 4/25/2009 2
Apr 2009 3
WE 5/2/2009 3
4
$15,000.00
$72,880.32
$51,814.64
$15,000.00
$24,863.95
$92,464.00
$7,632.00
$8,320.00
$108,416.00
$3,552.00
Receipts A/R - Trade A/R Line of Credit
$0.00
$465.00
$0.00
$465.00
$0.00
$10.00
$12.00
$0.00
$22.00
$0.00
Other
$0.00
$0.00
$0.00
$0.00
$0.00
Total
$92,474.00
$8,109.00
$8,320.00
$108,903.00
$3,552.00
$3,225.00
$222.00
$520.00
$3,967.00
$2,776.00
$0.00
$0.00
$0.00
$0.00
$0.00
Tooling
$2,554.00
$0.00
$5,445.00
$7,999.00
$0.00
Subtotal
$5,779.00
$222.00
$5,965.00
$11,966.00
$2,776.00
DIP Financing
Disbursements Production Raw Material Capital Expenditures
Employee Hourly Payroll
$6,307.50
$6,307.50
$6,607.50
$19,222.50
$6,607.50
$16,685.85
$16,685.85
$16,685.85
$50,057.54
$17,548.91
Payroll Taxes
$3,449.00
$3,449.00
$3,494.00
$10,392.01
$3,623.46
Benefits
$2,299.33
$2,299.33
$2,329.33
$6,928.00
$2,415.64
$0.00
$0.00
$0.00
$0.00
$0.00
$28,741.68
$28,741.68
$29,116.68
$86,600.05
$30,195.51
Rent
$0.00
$0.00
$0.00
$0.00
$0.00
Utilities
$0.00
$0.00
$0.00
$0.00
$0.00
Subtotal
$0.00
$0.00
$0.00
$0.00
$0.00
Bankruptcy
$0.00
$200.00
$178.00
$378.00
$80.00
Salaried Payroll
Travel & Entertainment Subtotal Facility
Interest
$62.00
$0.00
$0.00
$62.00
$0.00
Other
$11.00
$11.00
$11.00
$33.00
$11.00
Total
$34,593.68
$29,174.68
$35,270.68
$99,039.05
$33,062.51
Cash Source / (Use)
$57,880.32
($21,065.68)
($26,950.68)
($26,950.68)
($29,510.51)
Ending Cash
$72,880.32
$51,814.64
$24,863.95
$24,863.95
($4,646.56)
ABC Corp. 13-Week Cash Flow - Basic Prepared by Corporate Restucturing Solutions, Inc. Cash Flow WE 5/9/2009
WE 5/16/2009
WE 5/23/2009
WE 5/30/2009 7
May 2009 8
WE 6/6/2009 8
WE 6/13/2009
5
6
9
10
($4,646.56)
($37,483.06)
$406,400.43
$377,698.42
$24,863.95
$392,696.41
$375,199.40
$0.00
$500,048.00
$0.00
$44,416.00
$548,016.00
$12,320.00
$168,848.00
$0.00
$0.00
$745.00
$0.00
$745.00
$0.00
$0.00
$0.00
$15.00
$0.00
$0.00
$15.00
$0.00
$17.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$500,063.00
$745.00
$44,416.00
$548,776.00
$12,320.00
$168,865.00
$0.00
$254.00
$0.00
$0.00
$3,030.00
$548.00
$5,445.00
$0.00
$25,554.00
$0.00
$0.00
$25,554.00
$0.00
$0.00
$2,554.00
$0.00
$0.00
$0.00
$2,554.00
$0.00
$0.00
$2,554.00
$25,808.00
$0.00
$0.00
$31,138.00
$548.00
$5,445.00
$6,607.50
$6,607.50
$5,857.50
$5,857.50
$31,537.50
$5,857.50
$5,857.50
$17,548.91
$17,548.91
$17,548.91
$17,548.91
$87,744.53
$17,548.91
$17,548.91
$3,623.46
$3,623.46
$3,510.96
$3,510.96
$17,892.31
$3,510.96
$3,510.96
$2,415.64
$2,415.64
$2,340.64
$2,340.64
$11,928.20
$2,340.64
$2,340.64
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$30,195.51
$30,195.51
$29,258.01
$29,258.01
$149,102.54
$29,258.01
$29,258.01
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$165.00
$178.00
$80.00
$503.00
$0.00
$0.00
$76.00
$0.00
$0.00
$69.00
$145.00
$0.00
$0.00
$11.00
$11.00
$11.00
$11.00
$55.00
$11.00
$11.00
$32,836.51
$56,179.51
$29,447.01
$29,418.01
$180,943.54
$29,817.01
$34,714.01
($32,836.51)
$443,883.49
($28,702.01)
$14,997.99
$14,997.99
($17,497.01)
$134,150.99
($37,483.06)
$406,400.43
$377,698.42
$392,696.41
$392,696.41
$375,199.40
$509,350.39
WE 6/20/2009
WE 6/27/2009 11
Jun 2009 12
WE 7/4/2009 12
13
Jul 2009
Total 13
13
$509,350.39
$483,013.39
$392,696.41
$453,566.38
$453,566.38
$15,000.00
$2,000.00
$0.00
$183,168.00
$51,600.00
$51,600.00
$891,200.00
$1,012.00
$0.00
$1,012.00
$0.00
$0.00
$2,222.00
$0.00
$0.00
$17.00
$0.00
$0.00
$54.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$3,012.00
$0.00
$184,197.00
$51,600.00
$51,600.00
$893,476.00
$0.00
$0.00
$5,993.00
$3,225.00
$3,225.00
$16,215.00
$0.00
$0.00
$0.00
$0.00
$0.00
$25,554.00
$0.00
$0.00
$0.00
$0.00
$0.00
$10,553.00
$0.00
$0.00
$5,993.00
$3,225.00
$3,225.00
$52,322.00
$5,857.50
$5,857.50
$23,430.00
$5,857.50
$5,857.50
$80,047.50
$17,548.91
$17,548.91
$70,195.63
$17,548.91
$17,548.91
$225,546.61
$3,510.96
$3,510.96
$14,043.84
$3,510.96
$3,510.96
$45,839.12
$2,340.64
$2,340.64
$9,362.56
$2,340.64
$2,340.64
$30,559.41
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$29,258.01
$29,258.01
$117,032.03
$29,258.01
$29,258.01
$381,992.63
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$80.00
$178.00
$258.00
$80.00
$80.00
$1,219.00 $207.00
$0.00
$0.00
$0.00
$0.00
$0.00
$11.00
$11.00
$44.00
$11.00
$11.00
$143.00
$29,349.01
$29,447.01
$123,327.03
$32,574.01
$32,574.01
$435,883.63
($26,337.01)
($29,447.01)
($29,447.01)
$19,025.99
$19,025.99
$19,025.99
$483,013.39
$453,566.38
$453,566.38
$472,592.37
$472,592.37
$472,592.37
ABC Corp. 13-Week Cash Flow - Basic Prepared by Corporate Restucturing Solutions, Inc. Formulas Variable
Display As
Cash_Beginning
Beginning Cash Balance
Cash_Ending
Ending Cash
Cash_Initial
Initial Cash
Cash_Payroll
Cash Payroll
Cash_Source
Cash Source / (Use)
Company_Name
Company Name
Database_Offset
Database Offset
Database_Start_Date
Database Start Date
Disbursements
Disbursements
Expense_Bankruptcy
Bankruptcy
Expense_Other
Other Expense
Hourly_Benefits_pct
Hourly Benefits %
Hourly_Payroll_Tax_pct
Hourly Payroll Tax %
Interest_Expense
Interest Expense
Preparer_Name
Preparer Name
Production_Disbursements
Production Disbursements
Receipts
Receipts
Salary_Benefits_pct
Salaried Benefits %
Salary_Payroll_Tax_pct
Salaried Payroll Tax %
Time_Weeks
Week
Travel_Entertainment
Travel & Entertainment
s, Inc.
Dimension Index Global
Data:
Global
Data:
Payroll_Cash.Hourly_Payroll
Data:
Payroll_Cash.Salaried_Payroll
Data:
Global
Data:
Databases.Hourly
Data:
Databases.Salaried
Data:
Databases.Salaried
Data:
Databases.Hourly
Data:
Disbursements.Production.Capital_Expenditures
Data:
Disbursements.Other
Data:
Disbursements.Interest
Data:
Disbursements.Bankruptcy
Data:
Disbursements.Employee.Benefits
Data:
Disbursements.Employee.Hourly_Payroll
Data:
Disbursements.Production.Tooling
Data:
Disbursements.Production.Raw_Material
Data:
Disbursements.Employee.Salaried_Payroll
Data:
Disbursements.Employee.Payroll_Taxes
Data:
Disbursements.Employee.Travel___Entertainment
Data:
Global
Data:
Global
Data:
Formula / Data preve(Cash_initial, Cash_Ending) Cash_Beginning+Cash_Source
extdata("Employee Data", "Hourly_WeeklyEarnings", 1, Time_Weeks+Database_Offset["Databases.Hourly"]) extdata("Employee Data", "Salaried_WeeklyEarnings", 1, Time_Weeks+Database_Offset["Databases.Salaried"]) Receipts-Disbursements
round((model_date(1)-Database_Start_Date["Databases.Hourly"])/7, 0) round((model_date(1)-Database_Start_Date["Databases.Salaried"])/7, 0) extdata("Employee Data", "Salaried_Data_StartDate", 1, 1) extdata("Employee Data", "Hourly_Data_StartDate", 1, 1) Production_Disbursements["Production_Cash.Capital_Expenditures"] Expense_Other Interest_Expense Expense_Bankruptcy
Disbursements["Disbursements.Employee.Hourly_Payroll"]*Hourly_Benefits_pct+Disbursements["Disbursements.Employee.Salaried_Payroll"]*Salary_Be Cash_Payroll["Payroll_Cash.Hourly_Payroll"] Production_Disbursements["Production_Cash.Tooling"] Production_Disbursements["Production_Cash.Raw_Material"] Cash_Payroll["Payroll_Cash.Salaried_Payroll"]
Disbursements["Disbursements.Employee.Hourly_Payroll"]*Hourly_Payroll_Tax_pct+Disbursements["Disbursements.Employee.Salaried_Payroll"]*Salary Travel_Entertainment
preve(0)+1 preve(0)
Receipts_1 WE 4/11/2009 4/5/2009
WE 4/18/2009 4/12/2009
WE 4/25/2009 4/19/2009
Apr 2009 4/1/2009
WE 5/2/2009 4/26/2009
Receipts_2 WE 4/11/2009 WE 4/11/2009
WE 4/18/2009 WE 4/18/2009
WE 4/25/2009 WE 4/25/2009
Apr 2009 WE 4/4/2009
WE 5/2/2009 WE 5/2/2009
Cash_Ending_1 WE 4/11/2009 4/5/2009
WE 4/18/2009 4/12/2009
WE 4/25/2009 4/19/2009
Apr 2009 4/1/2009
WE 5/2/2009 4/26/2009
Cash_Ending_2 WE 4/11/2009 WE 4/11/2009
WE 4/18/2009 WE 4/18/2009
WE 4/25/2009 WE 4/25/2009
Apr 2009 WE 4/4/2009
WE 5/2/2009 WE 5/2/2009
Disbursements_1 WE 4/11/2009 4/5/2009
WE 4/18/2009 4/12/2009
WE 4/25/2009 4/19/2009
Apr 2009 4/1/2009
WE 5/2/2009 4/26/2009
Disbursements_2 WE 4/11/2009 WE 4/11/2009
WE 4/18/2009 WE 4/18/2009
WE 4/25/2009 WE 4/25/2009
Apr 2009 WE 4/4/2009
WE 5/2/2009 WE 5/2/2009
ABC Corp. 13-Week Cash Flow - Basic Prepared by Corporate Restucturing Solutions, Inc. Default Shadow
WE 5/9/2009 5/3/2009 WE 5/9/2009 WE 5/9/2009 WE 5/9/2009 5/3/2009 WE 5/9/2009 WE 5/9/2009 WE 5/9/2009 5/3/2009 WE 5/9/2009 WE 5/9/2009
WE 5/16/2009 5/10/2009 WE 5/16/2009 WE 5/16/2009 WE 5/16/2009 5/10/2009 WE 5/16/2009 WE 5/16/2009 WE 5/16/2009 5/10/2009 WE 5/16/2009 WE 5/16/2009
WE 5/23/2009 5/17/2009 WE 5/23/2009 WE 5/23/2009 WE 5/23/2009 5/17/2009 WE 5/23/2009 WE 5/23/2009 WE 5/23/2009 5/17/2009 WE 5/23/2009 WE 5/23/2009
WE 5/30/2009 5/24/2009 WE 5/30/2009 WE 5/30/2009 WE 5/30/2009 5/24/2009 WE 5/30/2009 WE 5/30/2009 WE 5/30/2009 5/24/2009 WE 5/30/2009 WE 5/30/2009
May 2009 5/1/2009 May 2009 WE 5/2/2009 May 2009 5/1/2009 May 2009 WE 5/2/2009 May 2009 5/1/2009 May 2009 WE 5/2/2009
WE 6/6/2009 5/31/2009 WE 6/6/2009 WE 6/6/2009 WE 6/6/2009 5/31/2009 WE 6/6/2009 WE 6/6/2009 WE 6/6/2009 5/31/2009 WE 6/6/2009 WE 6/6/2009
WE 6/13/2009 6/7/2009 WE 6/13/2009 WE 6/13/2009 WE 6/13/2009 6/7/2009 WE 6/13/2009 WE 6/13/2009 WE 6/13/2009 6/7/2009 WE 6/13/2009 WE 6/13/2009
WE 6/20/2009 6/14/2009 WE 6/20/2009 WE 6/20/2009 WE 6/20/2009 6/14/2009 WE 6/20/2009 WE 6/20/2009 WE 6/20/2009 6/14/2009 WE 6/20/2009 WE 6/20/2009
WE 6/27/2009 6/21/2009 WE 6/27/2009 WE 6/27/2009 WE 6/27/2009 6/21/2009 WE 6/27/2009 WE 6/27/2009 WE 6/27/2009 6/21/2009 WE 6/27/2009 WE 6/27/2009
Jun 2009 6/1/2009 Jun 2009 WE 6/6/2009 Jun 2009 6/1/2009 Jun 2009 WE 6/6/2009 Jun 2009 6/1/2009 Jun 2009 WE 6/6/2009
WE 7/4/2009 6/28/2009 WE 7/4/2009 WE 7/4/2009 WE 7/4/2009 6/28/2009 WE 7/4/2009 WE 7/4/2009 WE 7/4/2009 6/28/2009 WE 7/4/2009 WE 7/4/2009
Jul 2009 7/1/2009 Jul 2009 WE 7/4/2009 Jul 2009 7/1/2009 Jul 2009 WE 7/4/2009 Jul 2009 7/1/2009 Jul 2009 WE 7/4/2009
ABC Corp. 13-Week Cash Flow - Basic Prepared by Corporate Restucturing Solutions, Inc. Default Variables Database Offset Databases Hourly
0.00
Salaried
0.00
Total
0.00
Database Start Date Databases Hourly
4/5/2009
Salaried
4/5/2009
ABC Corp. 13-Week Cash Flow - Basic Prepared by Corporate Restucturing Solutions, Inc. Labels Variable
Display Label
Cash_Beginning
Beginning Cash Balance
Cash_Ending
Ending Cash
Cash_Initial
Initial Cash
Cash_Payroll
Cash Payroll
Cash_Source
Cash Source / (Use)
Company_Name
Company Name
Database_Offset
Database Offset
Database_Start_Date
Database Start Date
Disbursements
Disbursements
Expense_Bankruptcy
Bankruptcy
Expense_Other
Other Expense
Hourly_Benefits_pct
Hourly Benefits %
Hourly_Payroll_Tax_pct
Hourly Payroll Tax %
Interest_Expense
Interest Expense
Preparer_Name
Preparer Name
Production_Disbursements
Production Disbursements
Receipts
Receipts
Salary_Benefits_pct
Salaried Benefits %
Salary_Payroll_Tax_pct
Salaried Payroll Tax %
Time_Weeks
Week
Travel_Entertainment
Travel & Entertainment
Dimension (item)
Display Item As
Total As
Level As
Databases
Databases
Total
Databases
Hourly
Hourly
Salaried
Salaried
Disbursements Production
Disbursements
Total
Disbursements
Production
Subtotal
Disbursements
Raw_Material
Raw Material
Capital_Expenditures
Capital Expenditures
Tooling
Tooling
Employee
Employee
Hourly_Payroll
Hourly Payroll
Salaried_Payroll
Salaried Payroll
Payroll_Taxes
Payroll Taxes
Benefits
Benefits
Travel___Entertainment
Travel & Entertainment
Facility
Databases
Facility
Rent
Rent
Utilities
Utilities
Bankruptcy
Bankruptcy
Interest
Interest
Other
Other
Disbursements 2
Subtotal
Subtotal
Payroll_Cash
Payroll Cash
Hourly_Payroll
Hourly Payroll
Salaried_Payroll
Salaried Payroll
Production_Cash
Production Cash
Raw_Material
Raw Material
Capital_Expenditures
Capital Expenditures
Tooling
Tooling
Receipts
Receipts
A_R___Trade
A/R - Trade
A_R_Line_of_Credit
A/R Line of Credit
DIP_Financing
DIP Financing
Other
Other
Total
Payroll_Cash Employee_Exp
Total
Production_Cash Production_Exp
Total
Collections Collections
Comment Cash balance at the start of each time period Cash balance at the end of each time period Initial cash balance at the start of the first time period Payroll expenses for hourly and salaried employees. Payroll benefits and taxes are computed elsewhere in the model. This variable holds input data. Net cash flow (sources less uses) for each time period Name of the company whose cash flow is being modeled
Cash flow from disbursements, for each time period Expenses incurred due to bankruptcy process, for each time period Miscellaneous cash expenses not counted elswhere in the cash flow analysis Cash cost of benefits for hourly employees as a percentage of wage disbursements, by hourly employee, by time period Cash cost of payroll taxes as a percentage of wage disbursements Interest expense Name of the person or organization that designed or prepared the report. Production expenses on a cash basis, including raw material, capital expenditures and tooling. This variable holds input data. Cash flow from collections, for eah time period Cash cost of benefits for salaried employees as a percentage of salary disbursements, by salaried employee, by time period Cash cost of payroll taxes as a percentage of wage disbursements Time in weeks, counted from the start of the first time period Travel and entertainment expense, by time period Comment
A list of the payables accounts
A list of types of payroll cash expense (excluding benefits and taxes)
A list of types of production cash expenses, including material, capital expenditures and tooling
A list of the receivables accounts
ZZZ_Ranges!Receipts_Receipts_A_R___Trade 92464 7632 8320 3552 0 500048 0 44416 ZZZ_Ranges!Receipts_Receipts_A_R_Line_of_Credit 0 465 0 0 0 0 745 0 ZZZ_Ranges!Receipts_Receipts_DIP_Financing 10 12 0 0 0 15 0 0 ZZZ_Ranges!Receipts_Receipts_Other 0 0 0 0 0 0 0 0 ZZZ_Ranges!Receipts_Receipts 92474 8109 8320 3552 0 500063 745 44416 ZZZ_Ranges!Receipts_Time_Period WE 4/11/2009 WE 4/18/2009 WE 4/25/2009 WE 5/2/2009 WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 ZZZ_Ranges!Receipts_Date 04/05/09 04/12/09 04/19/09 04/26/09 05/03/09 05/10/09 05/17/09 05/24/09 ZZZ_Ranges!Cash_Ending 72880.32 51814.64 24863.95 -4646.56 -37483.06 406400.43 377698.42 392696.41 ZZZ_Ranges!Cash_Ending_Time_Period WE 4/11/2009 WE 4/18/2009 WE 4/25/2009 WE 5/2/2009 WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 ZZZ_Ranges!Cash_Ending_Date 04/05/09 04/12/09 04/19/09 04/26/09 05/03/09 05/10/09 05/17/09 05/24/09 ZZZ_Ranges!Disbursements_Disbursements_Production_Raw_Material 3225 222 520 2776 0 254 0 0 ZZZ_Ranges!Disbursements_Disbursements_Production_Capital_Expenditures 0 0 0 0 0 25554 0 0 ZZZ_Ranges!Disbursements_Disbursements_Production_Tooling 2554 0 5445 0 2554 0 0 0 ZZZ_Ranges!Disbursements_Disbursements_Production 5779 222 5965 2776 2554 25808 0 0 ZZZ_Ranges!Disbursements_Disbursements_Employee_Hourly_Payroll 6307.5 6307.5 6607.5 6607.5 6607.5 6607.5 5857.5 5857.5 ZZZ_Ranges!Disbursements_Disbursements_Employee_Salaried_Payroll 16685.85 16685.85 16685.85 17548.91 17548.91 17548.91 17548.91 17548.91 ZZZ_Ranges!Disbursements_Disbursements_Employee_Payroll_Taxes 3449 3449 3494 3623.46 3623.46 3623.46 3510.96 3510.96 ZZZ_Ranges!Disbursements_Disbursements_Employee_Benefits 2299.33 2299.33 2329.33 2415.64 2415.64 2415.64 2340.64 2340.64 ZZZ_Ranges!Disbursements_Disbursements_Employee_Travel___Entertainment 0 0 0 0 0 0 0 0 ZZZ_Ranges!Disbursements_Disbursements_Employee 28741.68 28741.68 29116.68 30195.51 30195.51 30195.51 29258.01 29258.01 ZZZ_Ranges!Disbursements_Disbursements_Facility_Rent 0 0 0 0 0 0 0 0 ZZZ_Ranges!Disbursements_Disbursements_Facility_Utilities 0 0 0 0 0 0 0 0 ZZZ_Ranges!Disbursements_Disbursements_Facility 0 0 0 0 0 0 0 0 ZZZ_Ranges!Disbursements_Disbursements_Bankruptcy 0 200 178 80 0 165 178 80 ZZZ_Ranges!Disbursements_Disbursements_Interest 62 0 0 0 76 0 0 69 ZZZ_Ranges!Disbursements_Disbursements_Other 11 11 11 11 11 11 11 11 ZZZ_Ranges!Disbursements_Disbursements 34593.68 29174.68 35270.68 33062.51 32836.51 56179.51 29447.01 29418.01 ZZZ_Ranges!Disbursements_Time_Period WE 4/11/2009 WE 4/18/2009 WE 4/25/2009 WE 5/2/2009 WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 ZZZ_Ranges!Disbursements_Date 04/05/09 04/12/09 04/19/09 04/26/09 05/03/09 05/10/09 05/17/09 05/24/09
12320 168848 2000 0 51600 0 0 1012 0 0 0 17 0 0 0 0 0 0 0 0 12320 168865 3012 0 51600 WE 6/6/2009 WE 6/13/2009 WE 6/20/2009 WE 6/27/2009 WE 7/4/2009 05/31/09 06/07/09 06/14/09 06/21/09 06/28/09 375199.4 509350.39 483013.39 453566.38 472592.37 WE 6/6/2009 WE 6/13/2009 WE 6/20/2009 WE 6/27/2009 WE 7/4/2009 05/31/09 06/07/09 06/14/09 06/21/09 06/28/09 548 5445 0 0 3225 0 0 0 0 0 0 0 0 0 0 548 5445 0 0 3225 5857.5 5857.5 5857.5 5857.5 5857.5 17548.91 17548.91 17548.91 17548.91 17548.91 3510.96 3510.96 3510.96 3510.96 3510.96 2340.64 2340.64 2340.64 2340.64 2340.64 0 0 0 0 0 29258.01 29258.01 29258.01 29258.01 29258.01 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 80 178 80 0 0 0 0 0 11 11 11 11 11 29817.01 34714.01 29349.01 29447.01 32574.01 WE 6/6/2009 WE 6/13/2009 WE 6/20/2009 WE 6/27/2009 WE 7/4/2009 05/31/09 06/07/09 06/14/09 06/21/09 06/28/09
Company_Name[]| ABC Corp. Preparer_Name[]| Corporate Restucturing Cash_Initial[]|Solutions, 15000 Receipts["Receipts.A_R___Trade", Inc. 92464 Receipts["Receipts.A_R___Trad DATE(2009,4,5)]| Receipts["Receipts.DIP_Financing", 0 Receipts["Receipts.DIP_Financing", DATE(2009,4,26)]|=0/4 0 Receipts["Receipts.DIP_Financing", DATE(2009,5,3)]|=0/4 15 Receipts["Receipts.DIP_Financing", DATE(2009,5,10)]| 0 Receipts["Receipts.DIP_Financin DATE(2009,5,17)]| Production_Disbursements["Production_Cash.Raw_Material", 5445 Production_Disbursements["Production_Cash.Raw_Material", 0 Production_Disbursements["Production_Cash.Raw_Material", DATE(2009,6,7)]| 0 Production_Disbursements["Production_Cash.Raw_Ma 3225 DATE(2009,6,14)]| Production_Disbursements["Prod DATE(2009,6,2 Expense_Bankruptcy[DATE(2009,4,19)]| 178 Expense_Bankruptcy[DATE(2009,4,26)]| 80 Expense_Bankruptcy[DATE(2009,5,3)]| 0 Expense_Bankruptcy[DATE(2009,5,10)]| 165 Expense_Bankruptcy[DATE(200 Expense_Other[DATE(2009,5,31)]|=11 11 Expense_Other[DATE(2009,6,7)]|=11 11 Expense_Other[DATE(2009,6,14)]|=11 11 Expense_Other[DATE(2009,6,21)]|=11 11 Expense_Other[DATE(2009,6,28 Cash_Payroll["Payroll_Cash.Salaried_Payroll", 16685.85 Cash_Payroll["Payroll_Cash.Salaried_Payroll", 16685.85 Cash_Payroll["Payroll_Cash.Salaried_Payroll", DATE(2009,4,12)]|=INDEX(Salaried_WeeklyEarnings, 17548.91 Cash_Payroll["Payroll_Cash.Salaried_Payroll", DATE(2009,4,19)]|=INDEX(Salaried_WeeklyEarning 17548.91 Cash_Payroll["Payroll_Cash.Sala DATE(2009,4,26)]|=INDEX(Sa 1, 'Cash Flow'!C7+'D DATE(2 :A:0:Disbursements Disbursements :A:-1:Disbursements Cash flow from :A:0:Receipts disbursements, Receipts for:A:-1:Receipts each time Cash periodflow from :A:0:Cash_Beginning collections, for eah time peri :A:0:Production_Disbursements Production :A:-1:Production_Disbursements Disbursements Production :A:0:Cash_Payroll expenses on Cash a cash Payroll basis, :A:-1:Cash_Payroll including Payroll raw expenses material, :A:0:Preparer_Name capital for hourly expenditures and salaried andem to :D:0:Disbursements.Bankruptcy Bankruptcy:D:0:Disbursements.Interest Interest :D:0:Disbursements.Other Other :D:-1:Receipts A list of the:D:0:Receipts receivables accounts :D:2:Databases.Hourly Databases :D:0:Databases.Salaried Salaried :WS:Output 0 :WS: 0 :WS: 0 :WS: ABC Corp. :WS:
7632 Receipts["Receipts.A_R___Trade", 8320 Receipts["Receipts.A_R___Trade", DATE(2009,4,19)]| 3552 Receipts["Receipts.A_R___Trade", DATE(2009,4,26)]| 0 Receipts["Receipts.A_R___Trade", DATE(2009,5,3)]| 500048 DATE(2 0 Receipts["Receipts.DIP_Financing", 0 Receipts["Receipts.DIP_Financing", DATE(2009,5,31)]|=0/4 17 Receipts["Receipts.DIP_Financing", DATE(2009,6,7)]| 0 Receipts["Receipts.DIP_Financing", DATE(2009,6,14)]|=0/4 0 DATE(2 0 Production_Disbursements["Production_Cash.Capital_Expenditures", 0 Production_Disbursements["Production_Cash.Capital_Expenditures", 0 Production_Disbursements["Production_Cash.Capital_Expenditure 0 Production_Disbursements["Production_Cas DATE(2009,4,12)]|0 DATE(2009,4,19)]| 178 Expense_Bankruptcy[DATE(2009,5,24)]| 80 Expense_Bankruptcy[DATE(2009,5,31)]|=0 0 Expense_Bankruptcy[DATE(2009,6,7)]|=0 0 Expense_Bankruptcy[DATE(2009,6,14)]| 80 11 Travel_Entertainment[DATE(2009,4,5)]|=0 0 Travel_Entertainment[DATE(2009,4,12)]|=B34 0 Travel_Entertainment[DATE(2009,4,19)]|=C34 0 Travel_Entertainment[DATE(2009,4,26)]|=D 0 17548.91 Cash_Payroll["Payroll_Cash.Salaried_Payroll", 17548.91 Cash_Payroll["Payroll_Cash.Salaried_Payroll", 17548.91 Cash_Payroll["Payroll_Cash.Salaried_Payroll", DATE(2009,5,17)]|=INDEX(Salaried_WeeklyEarnings, 17548.91 Cash_Payroll["Payroll_Cash.Salaried_Payro DATE(2009,5,24)]|=INDEX(Salaried_Wee 17548.91 DATE(2009,5,31)]| 1, 'Cash Beginning Cash :A:-1:Cash_Beginning Balance Cash balance :A:0:Cash_Initial at the start Initial of each Cash:A:-1:Cash_Initial time periodInitial cash :A:0:Cash_Source balance at the Cash start Source of the/ (Use) first time period Preparer Name :A:-1:Preparer_Name Name of the:A:0:Database_Start_Date person orDatabase organization Start :A:-1:Database_Start_Date that Date designed or prepared 0 :A:0:Database_Offset the report. Database Offset Receipts :D:2:Receipts Collections:D:1:Receipts Total :D:0:Receipts.A_R___Trade A/R - Trade:D:2:Receipts.A_R___Trade Collections 0 :WS:
ABC Corp. :WS:
ABC Corp. :WS:Employee Current DataDate :WS:Employee Current DataDate
Receipts["Receipts.A_R___Trade", 0 Receipts["Receipts.A_R___Trade", DATE(2009,5,17)]| 44416 Receipts["Receipts.A_R___Trade", DATE(2009,5,24)]| 12320 Receipts["Receipts.A_R___Trade", DATE(2009,5,31)]| 168848 Receipts["Receipts.A_R___Trad DATE(2009,6,7)]| Receipts["Receipts.DIP_Financing", 0 Receipts["Receipts.Other", DATE(2009,6,28)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,4,5)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,4,12)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,4,19)]|=0/4DATE Production_Disbursements["Production_Cash.Capital_Expenditures", 25554 Production_Disbursements["Production_Cash.Capital_Expenditures", 0 Production_Disbursements["Production_Cash.Capital_Expenditures", 0 Production_Disbursements["Production_Cash.Capital_E DATE(2009,5,10)]|0 Production_Disbursements["Prod DATE(2009,5,17)]| DATE(2 Expense_Bankruptcy[DATE(2009,6,21)]| 178 Expense_Bankruptcy[DATE(2009,6,28)]| 80 Interest_Expense[DATE(2009,4,5)]| 62 Interest_Expense[DATE(2009,4,12)]|=0 0 Interest_Expense[DATE(2009,4, Travel_Entertainment[DATE(2009,5,3)]|=F34 0 Travel_Entertainment[DATE(2009,5,10)]|=G34 0 Travel_Entertainment[DATE(2009,5,17)]|=H34 0 Travel_Entertainment[DATE(2009,5,24)]|=I34 0 Travel_Entertainment[DATE(200 Cash_Payroll["Payroll_Cash.Salaried_Payroll", 17548.91 Cash_Payroll["Payroll_Cash.Salaried_Payroll", 17548.91 Cash_Payroll["Payroll_Cash.Salaried_Payroll", DATE(2009,6,14)]|=INDEX(Salaried_WeeklyEarnings, 17548.91 Hourly_Payroll_Tax_pct[]| DATE(2009,6,21)]|=INDEX(Salaried_WeeklyEarning 15.00% Hourly_Benefits_pct[]| DATE(2009,6,28)]|=INDEX(Sa 1, 'Cash Flow'!N7+'D :A:-1:Cash_Source Net cash flow :A:0:Cash_Ending (sourcesEnding less uses) Cash :A:-1:Cash_Ending for each time Cash period balance :A:0:Time_Weeks at the end Week of each time :A:-1:Time_Weeks period :A:-1:Database_Offset 0 :D:-1:Disbursements A list of the:D:0:Disbursements payables accounts Disbursements :D:2:Disbursements Disbursements :D:1:Disbursements :D:0:Receipts.A_R_Line_of_Credit A/R Line of:D:0:Receipts.DIP_Financing Credit DIP Financing :D:0:Receipts.Other Other :D:-1:Production_Cash A list of types :D:0:Production_Cash of production cash expenses, :WS:
ZZZ_Ranges!Receipts_Receipts_A_R___Trade :WS: Company_Name[]|
2000 Receipts["Receipts.A_R___Trade", 0 Receipts["Receipts.A_R___Trade", DATE(2009,6,21)]| 51600 Receipts["Receipts.A_R_Line_of_Credit", DATE(2009,6,28)]| 0 Receipts["Receipts.A_R_Line_of_Credit", 465 DATE(2009,4,5)]|=0/4 D 0 Receipts["Receipts.Other", 0 Receipts["Receipts.Other", DATE(2009,5,3)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,5,10)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,5,17)]|=0/4 0 DATE(2009,5,24 0 Production_Disbursements["Production_Cash.Capital_Expenditures", 0 Production_Disbursements["Production_Cash.Capital_Expenditures", 0 Production_Disbursements["Production_Cash.Capital_Expenditure 0 Production_Disbursements["Production_Cas DATE(2009,6,14)]| 2554 DATE(2009,6,21)]| 0 Interest_Expense[DATE(2009,4,26)]|=0 0 Interest_Expense[DATE(2009,5,3)]| 76 Interest_Expense[DATE(2009,5,10)]|=0 0 Interest_Expense[DATE(2009,5,17)]|=0 0 0 Travel_Entertainment[DATE(2009,6,7)]|=L34 0 Travel_Entertainment[DATE(2009,6,14)]|=M34 0 Travel_Entertainment[DATE(2009,6,21)]|=N34 0 Travel_Entertainment[DATE(2009,6,28)]|=O 0 10.00% Salary_Payroll_Tax_pct[]| 15.00% Salary_Benefits_pct[]| 10.00% Time in weeks, :A:0:Salary_Benefits_pct counted Salaried from the Benefits start :A:-1:Salary_Benefits_pct of% the first Cash time cost period of :A:0:Hourly_Payroll_Tax_pct benefits for Hourly salaried Payroll employees :A:-1:Hourly_Payroll_Tax_pct Tax % Cash as a percentage cost of payroll of salary taxes disburs as a p Total :D:0:Disbursements.Production Production :D:2:Disbursements.Production Disbursements :D:1:Disbursements.Production Subtotal :D:0:Disbursements.Production.Raw_Materi Raw Material Production :D:2:Production_Cash Cash Production_Cash :D:1:Production_Cash Total :D:0:Production_Cash.Raw_Material Raw Material :D:2:Production_Cash.Raw_Material Production_Exp
Receipts["Receipts.A_R_Line_of_Credit", 0 Receipts["Receipts.A_R_Line_of_Credit", DATE(2009,4,19)]|=0/4 0 Receipts["Receipts.A_R_Line_of_Credit", DATE(2009,4,26)]|=0/4 0 Receipts["Receipts.A_R_Line_of_Credit", DATE(2009,5,3)]|=0/4 0 Receipts["Receipts.A_R_Line_of DATE(2009,5 Receipts["Receipts.Other", 0 Receipts["Receipts.Other", DATE(2009,5,31)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,6,7)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,6,14)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,6,21)]|=0/4DATE Production_Disbursements["Production_Cash.Tooling", 0 Production_Disbursements["Production_Cash.Tooling", 5445 Production_Disbursements["Production_Cash.Tooling", DATE(2009,4,12)]| 0 Production_Disbursements["Production_Cash.Tooling", DATE(2009,4,19)]| 2554 Production_Disbursements["Prod DATE(2009,4,26)]| Interest_Expense[DATE(2009,5,24)]| 69 Interest_Expense[DATE(2009,5,31)]|=0 0 Interest_Expense[DATE(2009,6,7)]|=0 0 Interest_Expense[DATE(2009,6,14)]|=0 0 Interest_Expense[DATE(2009,6, Cash_Payroll["Payroll_Cash.Hourly_Payroll", 6307.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", 6307.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", DATE(2009,4,5)]|=INDEX(Hourly_WeeklyEarnings, 6607.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", DATE(2009,4,12)]|=INDEX(Hourly_WeeklyEarnings, 6607.5 Cash_Payroll["Payroll_Cash.Hou DATE(2009,4,19)]|=INDEX(Hou 1, 'Cash Flow'!B7+'Defau DATE(201
:A:0:Hourly_Benefits_pct Hourly Benefits :A:-1:Hourly_Benefits_pct % Cash cost of :A:0:Salary_Payroll_Tax_pct benefits for Salaried hourly Payroll employees :A:-1:Salary_Payroll_Tax_pct Tax % asCash a percentage cost of :A:0:Travel_Entertainment payroll of wage taxes disbursements, as a percentage by ho :D:2:Disbursements.Production.Raw_Material Disbursements :D:0:Disbursements.Production.Capital_Expenditures 2 Capital Expenditures :D:0:Disbursements.Production.Tooling Tooling :D:0:Disbursements.Employee Employee :D:1:Disbursements.Employee :D:0:Production_Cash.Capital_Expenditures Capital Expenditures :D:0:Production_Cash.Tooling Tooling :D:-1:Payroll_Cash A list of types :D:0:Payroll_Cash of payrollPayroll cash expense Cash :D:2:Payroll_Cash (excluding benefits and taxe
745 Receipts["Receipts.A_R_Line_of_Credit", 0 Receipts["Receipts.A_R_Line_of_Credit", DATE(2009,5,24)]|=0/4 0 Receipts["Receipts.A_R_Line_of_Credit", DATE(2009,5,31)]|=0/4 0 Receipts["Receipts.A_R_Line_of_Credit", 1012 DATE(2009,6,7)]|=0/4 D 0 Production_Disbursements["Production_Cash.Raw_Material", 3225 Production_Disbursements["Production_Cash.Raw_Material", 222 Production_Disbursements["Production_Cash.Raw_Material", DATE(2009,4,5)]| 520 Production_Disbursements["Production_Cas 2776 DATE(2009,4,12)]| DAT 0 Production_Disbursements["Production_Cash.Tooling", 0 Production_Disbursements["Production_Cash.Tooling", 0 Production_Disbursements["Production_Cash.Tooling", DATE(2009,5,17)]| 0 Production_Disbursements["Production_Cas DATE(2009,5,24)]| 0 DATE(200 0 Interest_Expense[DATE(2009,6,28)]|=0 0 Expense_Other[DATE(2009,4,5)]|=11 11 Expense_Other[DATE(2009,4,12)]|=11 11 Expense_Other[DATE(2009,4,19)]|=11 11 6607.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", 6607.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", 5857.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", DATE(2009,5,10)]|=INDEX(Hourly_WeeklyEarnings, 5857.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll" DATE(2009,5,17)]|=INDEX(Hourly_Weekly 5857.5 DATE(2009,5,24)]|=I 1, 'Cash Flow
Travel & Entertainment :A:-1:Travel_Entertainment Travel and :A:0:Expense_Bankruptcy entertainment Bankruptcy:A:-1:Expense_Bankruptcy expense, by time period Expenses incurred :A:0:Interest_Expense dueInterest to bankruptcy Expense process, for each Subtotal :D:0:Disbursements.Employee.Hourly_Payroll Hourly Payroll :D:0:Disbursements.Employee.Salaried_Payroll Salaried Payroll :D:0:Disbursements.Employee.Payroll_Taxes Payroll Taxes :D:0:Disbursements.Employee.Benefits Benefits Payroll_Cash :D:1:Payroll_Cash Total :D:0:Payroll_Cash.Hourly_Payroll Hourly Payroll :D:2:Payroll_Cash.Hourly_Payroll Employee_Exp :D:0:Payroll_Cash.Salaried_Payroll Salaried Payroll
Receipts["Receipts.A_R_Line_of_Credit", 0 Receipts["Receipts.A_R_Line_of_Credit", DATE(2009,6,21)]|=0/4 0 Receipts["Receipts.DIP_Financing", 10 DATE(2009,6,28)]|=0/4 Receipts["Receipts.DIP_Financing", DATE(2009,4,5)]| 12 Receipts["Receipts.DIP_Financin DATE(2009,4,12)]| Production_Disbursements["Production_Cash.Raw_Material", 0 Production_Disbursements["Production_Cash.Raw_Material", 254 Production_Disbursements["Production_Cash.Raw_Material", DATE(2009,5,3)]| 0 Production_Disbursements["Production_Cash.Raw_Ma DATE(2009,5,10)]| 0 Production_Disbursements["Prod DATE(2009,5,1 Production_Disbursements["Production_Cash.Tooling", 0 Production_Disbursements["Production_Cash.Tooling", 0 Production_Disbursements["Production_Cash.Tooling", DATE(2009,6,14)]| 0 Expense_Bankruptcy[DATE(2009,4,5)]|=0 DATE(2009,6,21)]| 0 Expense_Bankruptcy[DATE(200 DATE(2009,6,28)]| Expense_Other[DATE(2009,4,26)]|=11 11 Expense_Other[DATE(2009,5,3)]|=11 11 Expense_Other[DATE(2009,5,10)]|=11 11 Expense_Other[DATE(2009,5,17)]|=11 11 Expense_Other[DATE(2009,5,24 Cash_Payroll["Payroll_Cash.Hourly_Payroll", 5857.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", 5857.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", DATE(2009,6,7)]|=INDEX(Hourly_WeeklyEarnings, 5857.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", DATE(2009,6,14)]|=INDEX(Hourly_WeeklyEarnings, 5857.5 Cash_Payroll["Payroll_Cash.Sala DATE(2009,6,21)]|=INDEX(Hou 1, 'Cash Flow'!M7+'Defau DATE(201
:A:-1:Interest_Expense Interest expense :A:0:Expense_Other Other Expense :A:-1:Expense_Other Miscellaneous :A:0:Company_Name cash expenses Company notName :A:-1:Company_Name counted elswhere in the cash flo :D:0:Disbursements.Employee.Travel___Entertainment Travel & Entertainment :D:0:Disbursements.Facility Facility :D:1:Disbursements.Facility Subtotal :D:0:Disbursements.Facility.Rent Rent :D:0:Disbursements.Facility.Utilit :D:-1:Databases 0 :D:0:Databases Databases :D:2:Databases Databases :D:1:Databases Total :D:0:Databases.Hourly
0 548 200 11 16685.85 Name of the company whose cash flow is being modeled Utilities Hourly
Current Date
ABC Corp. Hourly Employee Data
4/5/2009
Color code: This color background (dark blue on my PC) indicates input data Totals
Employee First Name
Employee Last Name
$207.25
Employee ID #
Hourly Rate
$820.00
Standard Biweekly Hours
$13,215.00
Standard Biweekly Wage
Peter
Staudt
1001
$10.00
60.00
$600.00
Maynard E.
Chau
1002
$12.00
50.00
$600.00
Cornelius M.
Peterman
1003
$8.75
60.00
$525.00
Santos
Linthicum
1004
$9.50
80.00
$760.00
Freddie
Haden
1005
$13.00
70.00
$910.00
John
Ashe
1006
$14.00
80.00
$1,120.00
Philip
Gamblin
1007
$14.00
40.00
$560.00
Rene L.
Callender
1008
$15.00
40.00
$600.00
Brandon
Tuma
1009
$21.00
40.00
$840.00
Antonio
Blackwood
1010
$25.00
60.00
$1,500.00
Sharan
Barboza
1011
$30.00
80.00
$2,400.00
Peter
Demaree
1012
$18.00
80.00
$1,440.00
Danille
Aarons
1013
$17.00
80.00
$1,360.00
When adding more data records (rows): 1. Insert new rows above the final row, so that the formulas on top include all data records. 2. Copy formulas for weekly payments (if any) down to the new rows.
Employee Data
Wages
Start Period
Termination Period
3.0
7.0
$6,307.50
$6,307.50
$6,607.50
$6,607.50
1
2
3
4
4/5/2009
4/12/2009
4/19/2009
4/26/2009
$300.00
$300.00
$300.00
$300.00
$0.00
$0.00
$300.00
$300.00
$262.50
$262.50
$262.50
$262.50
$380.00
$380.00
$380.00
$380.00
$455.00
$455.00
$455.00
$455.00
$560.00
$560.00
$560.00
$560.00
$280.00
$280.00
$280.00
$280.00
$300.00
$300.00
$300.00
$300.00
$420.00
$420.00
$420.00
$420.00
$750.00
$750.00
$750.00
$750.00
$1,200.00
$1,200.00
$1,200.00
$1,200.00
$720.00
$720.00
$720.00
$720.00
$680.00
$680.00
$680.00
$680.00
Accrued Earnings $6,607.50
$6,607.50
$5,857.50
$5,857.50
$5,857.50
$5,857.50
5
6
7
8
9
10
5/3/2009
5/10/2009
5/17/2009
5/24/2009
5/31/2009
6/7/2009
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$262.50
$262.50
$262.50
$262.50
$262.50
$262.50
$380.00
$380.00
$380.00
$380.00
$380.00
$380.00
$455.00
$455.00
$455.00
$455.00
$455.00
$455.00
$560.00
$560.00
$560.00
$560.00
$560.00
$560.00
$280.00
$280.00
$280.00
$280.00
$280.00
$280.00
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$420.00
$420.00
$420.00
$420.00
$420.00
$420.00
$750.00
$750.00
$0.00
$0.00
$0.00
$0.00
$1,200.00
$1,200.00
$1,200.00
$1,200.00
$1,200.00
$1,200.00
$720.00
$720.00
$720.00
$720.00
$720.00
$720.00
$680.00
$680.00
$680.00
$680.00
$680.00
$680.00
$5,857.50
$5,857.50
$5,857.50
11
12
13
6/14/2009
6/21/2009
6/28/2009
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$262.50
$262.50
$262.50
$380.00
$380.00
$380.00
$455.00
$455.00
$455.00
$560.00
$560.00
$560.00
$280.00
$280.00
$280.00
$300.00
$300.00
$300.00
$420.00
$420.00
$420.00
$0.00
$0.00
$0.00
$1,200.00
$1,200.00
$1,200.00
$720.00
$720.00
$720.00
$680.00
$680.00
$680.00
Current Date
ABC Corp. Salaried Employee Data
4/5/2009
Color code: This color background (dark blue on my PC) indicates input data Totals
Employee First Name
Employee Last Name
Employee ID #
$950,000.00
$36,440.35
Annual Salaries
Biweekly Salary
Donald
Bergen
10001
$175,000.00
$6,712.70
Amber
Bourgeois
10002
$120,000.00
$4,602.99
Robert
Browne
10003
$75,000.00
$2,876.87
Albert
McConnell
10004
$80,000.00
$3,068.66
Irene
Ruggles
10005
$60,000.00
$2,301.50
Daniel
Rainwater
10006
$35,000.00
$1,342.54
Michael
Valentin
10007
$35,000.00
$1,342.54
Christina
Mcelhaney
10008
$30,000.00
$1,150.75
Hilda
Joy
10009
$50,000.00
$1,917.91
Candace
Boutte
10010
$80,000.00
$3,068.66
Juana
Bond
10011
$75,000.00
$2,876.87
Jacqueline
Brummett
10012
$75,000.00
$2,876.87
George
Baugher
10013
$60,000.00
$2,301.50
When adding more data records (rows): 1. Insert new rows above the final row, so that the formulas on top include all data records. 2. Copy formulas for weekly payments down to the new rows.
Start Period
4.0
Accrued Earnings Wages
$16,685.85
Termination Period
4.0
$16,685.85
$16,685.85
$17,548.91
$17,548.91
1
2
3
4
5
4/5/2009
4/12/2009
4/19/2009
4/26/2009
5/3/2009
$3,356.35
$3,356.35
$3,356.35
$3,356.35
$3,356.35
$2,301.50
$2,301.50
$2,301.50
$2,301.50
$2,301.50
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$671.27
$671.27
$671.27
$671.27
$671.27
$671.27
$671.27
$671.27
$0.00
$0.00
$575.37
$575.37
$575.37
$575.37
$575.37
$958.96
$958.96
$958.96
$958.96
$958.96
$0.00
$0.00
$0.00
$1,534.33
$1,534.33
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$17,548.91
$17,548.91
$17,548.91
$17,548.91
$17,548.91
$17,548.91
6
7
8
9
10
11
5/10/2009
5/17/2009
5/24/2009
5/31/2009
6/7/2009
6/14/2009
$3,356.35
$3,356.35
$3,356.35
$3,356.35
$3,356.35
$3,356.35
$2,301.50
$2,301.50
$2,301.50
$2,301.50
$2,301.50
$2,301.50
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$671.27
$671.27
$671.27
$671.27
$671.27
$671.27
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$575.37
$575.37
$575.37
$575.37
$575.37
$575.37
$958.96
$958.96
$958.96
$958.96
$958.96
$958.96
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$17,548.91
$17,548.91
12
13
6/21/2009
6/28/2009
$3,356.35
$3,356.35
$2,301.50
$2,301.50
$1,438.43
$1,438.43
$1,534.33
$1,534.33
$1,150.75
$1,150.75
$671.27
$671.27
$0.00
$0.00
$575.37
$575.37
$958.96
$958.96
$1,534.33
$1,534.33
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,150.75
$1,150.75
You'll be able to get a glimpse of ModelSheet's advantages when you take a look at the "Formulas" tab and realize how few separate, readable formulas are needed to produce all of the other worksheets. In addition to formulas, ModelSheet knows about the "dimensions" in your model (e.g., products, locations, departments) as well as the time series that you're using (e.g., 5 years in quarters.) ModelSheet raises the level of thinking and acting from individual cells to natural modeling concepts. It enhances model reliabilty, auditability and maintainability; it enables you to build models that better reflect your intentions; it allows easier collaboration between modelers, developers, and report users; and it improves productivity, especially when making changes to a model. ModelSheet will be available in several forms. ModelSheet Authoring is a SaaS application for developing and maintaining business models and delivering them in conventional spreadsheets. With this product you can build models from scratch or explore and modify existing models. ModelSheet Templates provides a simple interface that allows you to pick an existing model and easily specify time frames, dimensions and layout parameters and produce an Excel template like this one to your exact specifications. ModelSheet also offers pre-built models and consulting services. We have a lot more to tell you about ModelSheet and we'd really like to hear from you about your needs for modeling and templates. Please visit our website at www.modelsheetsoft.com or contact us at [email protected]. Acknowledgements This cash flow model was designed by Marilyn Magett of Corporate Restructuring Solutions, Inc. Marilyn is a CFO for businesses in transition and distress. She serves her clients as a Consulting, Interim, or Turnaround CFO. Please visit her website at www.restructuringsolutions.com or contact her at [email protected]. Description of the application This application is a basic 13-week cash flow model. It 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.
ModelSheet is a trademark of ModelSheet Software, LLC
page 1 of 45
The basic model includes these features. • A cash flow worksheet with starting and ending cash and sources and uses of cash. • Collections from trade accounts receivable and other sources. • Disbursements for several types of production expenses, salaried and hourly employee expenses, facilities, and other expenses. • Two Excel databases for hourly and salaried employee data. • Excel graphs of key variables. These graphs are integrated into the ModelSheet model from which they get their source data. You can add more graphs, and optionally import them to ModelSheet and include them in future exported Excel workbooks. As you explore the model, we suggest that you • Read some of the Excel comments that are attached to Analysis Variables throughout the workbook. These comments also appear in ModelSheet in convenient places. • View worksheet "Formulas" which shows the named variables and symbolic formulas of the model in a compact and readable form. The symbolic formulas are not active in this Excel workbook, but they give you some idea how the model works, and how it looks in ModelSheet. This model serves as the basis for more advanced cash flow models that include the following additional features. • A borrowing base worksheet that presents the borrowing asset base and loan balances. • An Excel database for accounts receivable data, estimates of future receipts, and new sales, a pivot table summary of accounts receivable, and a receivables aging report. • An Excel databases for accounts payable data, estimates of future payments, new purchases, a pivot table summary of accounts receivable, and a payables aging report. • Department cost centers, and business unit profit centers. Contact ModelSheet Software, LLC for access to these models. Suggestions for using this model 1. Use this workbook as-is to model your cash flows. You can change the data in the dark blue input cells. You can change display names of dimension items and variables in the dark blue cells on worksheet "Labels." 2. Customize this Excel workbook to make the model fit your cash flow. For example, you can add or remove sources and uses of cash. 3. Use ModelSheet to edit the formulas in this model, using named variables, symbolic formulas (and far fewer formulas), segmentation dimensions and time series, without ever touching a cell address -- and end up with a conventional Excel workbook. To obtain a trial account for ModelSheet, go the the ModelSheet website below and request a trial account. This Excel workbook was generated by ModelSheet on March 20, 2009, except for this worksheet of comments. Copyright © 2009 ModelSheet Software, LLC ModelSheet and the ModelSheet logo are registered trademarks of ModelSheet Software, LLC.
ModelSheet is a trademark of ModelSheet Software, LLC
page 2 of 45
Ending Cash $1 $1 $1 $1 $1 $0
Column A
$0 $0 $0 $0
Ro w
1
$0
Receipts $1 $1 $1 $1 $1 $0
Column A
$0 $0 $0 $0
Ro w
1
$0
Disbursements $1 $1 $1 $1 $1 $0
Column A
$0 $0 $0 $0
Ro w
1
$0
Company Name
ABC Corp.
Preparer Name
Corporate Restucturing Solutions, Inc.
Cash Initial Cash
$15,000.00 WE 4/11/2009
WE 4/18/2009
Receipts A/R - Trade
$92,464.00
$7,632.00
$0.00
$465.00
$10.00
$12.00
Other
$0.00
$0.00
Total
$92,474.00
$8,109.00
$3,225.00
$222.00
$0.00
$0.00
A/R Line of Credit DIP Financing
Expenses Production Disbursements Raw Material Capital Expenditures Tooling
$2,554.00
$0.00
Total
$5,779.00
$222.00
$0.00
$200.00
Interest Expense
$62.00
$0.00
Other Expense
$11.00
$11.00
$0.00
$0.00
Bankruptcy
Travel & Entertainment
Labor WE 4/11/2009
WE 4/18/2009
Cash Payroll Hourly Payroll
$6,307.50
$6,307.50
Salaried Payroll
$16,685.85
$16,685.85
Total
$22,993.35
$22,993.35
Hourly Employees Hourly Payroll Tax %
15.00%
Hourly Benefits %
10.00%
Designed by Corporate Restructuring Solutions, Inc. Built with software from ModelSheet Software, LLC.
ABC Corp. 13-Week Cash Flow - Basic Prepared by Corporate Restucturing Solutions, Inc. Inputs
WE 4/25/2009
Apr 2009
WE 5/2/2009
WE 5/9/2009
WE 5/16/2009
WE 5/23/2009
$8,320.00
$108,416.00
$3,552.00
$0.00
$500,048.00
$0.00
$0.00
$465.00
$0.00
$0.00
$0.00
$745.00
$0.00
$22.00
$0.00
$0.00
$15.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$8,320.00
$108,903.00
$3,552.00
$0.00
$500,063.00
$745.00
$520.00
$3,967.00
$2,776.00
$0.00
$254.00
$0.00
$0.00
$0.00
$0.00
$0.00
$25,554.00
$0.00
$5,445.00
$7,999.00
$0.00
$2,554.00
$0.00
$0.00
$5,965.00
$11,966.00
$2,776.00
$2,554.00
$25,808.00
$0.00
$178.00
$378.00
$80.00
$0.00
$165.00
$178.00
$0.00
$62.00
$0.00
$76.00
$0.00
$0.00
$11.00
$33.00
$11.00
$11.00
$11.00
$11.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
WE 4/25/2009
Apr 2009
WE 5/2/2009
WE 5/9/2009
WE 5/16/2009
WE 5/23/2009
$6,607.50
$19,222.50
$6,607.50
$6,607.50
$6,607.50
$5,857.50
$16,685.85
$50,057.54
$17,548.91
$17,548.91
$17,548.91
$17,548.91
$23,293.35
$69,280.04
$24,156.41
$24,156.41
$24,156.41
$23,406.41
Salaried Employees Salaried Payroll Tax %
15.00%
Salaried Benefits %
10.00%
uring Solutions, Inc.
WE 5/30/2009
May 2009
WE 6/6/2009
WE 6/13/2009
WE 6/20/2009
WE 6/27/2009
Jun 2009
$44,416.00
$548,016.00
$12,320.00
$168,848.00
$2,000.00
$0.00
$183,168.00
$0.00
$745.00
$0.00
$0.00
$1,012.00
$0.00
$1,012.00
$0.00
$15.00
$0.00
$17.00
$0.00
$0.00
$17.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$44,416.00
$548,776.00
$12,320.00
$168,865.00
$3,012.00
$0.00
$184,197.00
$0.00
$3,030.00
$548.00
$5,445.00
$0.00
$0.00
$5,993.00
$0.00
$25,554.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$2,554.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$31,138.00
$548.00
$5,445.00
$0.00
$0.00
$5,993.00
$80.00
$503.00
$0.00
$0.00
$80.00
$178.00
$258.00
$69.00
$145.00
$0.00
$0.00
$0.00
$0.00
$0.00
$11.00
$55.00
$11.00
$11.00
$11.00
$11.00
$44.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
WE 5/30/2009
May 2009
WE 6/6/2009
WE 6/13/2009
WE 6/20/2009
WE 6/27/2009
Jun 2009
$5,857.50
$31,537.50
$5,857.50
$5,857.50
$5,857.50
$5,857.50
$23,430.00
$17,548.91
$87,744.53
$17,548.91
$17,548.91
$17,548.91
$17,548.91
$70,195.63
$23,406.41
$119,282.03
$23,406.41
$23,406.41
$23,406.41
$23,406.41
$93,625.63
WE 7/4/2009
Jul 2009
$51,600.00
$51,600.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$51,600.00
$51,600.00
$3,225.00
$3,225.00
$0.00
$0.00
$0.00
$0.00
$3,225.00
$3,225.00
$80.00
$80.00
$0.00
$0.00
$11.00
$11.00
$0.00
$0.00
WE 7/4/2009
Jul 2009
$5,857.50
$5,857.50
$17,548.91
$17,548.91
$23,406.41
$23,406.41
WE 4/11/2009 Week Beginning Cash Balance
WE 4/18/2009 1
WE 4/25/2009 2
Apr 2009 3
WE 5/2/2009 3
4
$15,000.00
$72,880.32
$51,814.64
$15,000.00
$24,863.95
$92,464.00
$7,632.00
$8,320.00
$108,416.00
$3,552.00
Receipts A/R - Trade A/R Line of Credit
$0.00
$465.00
$0.00
$465.00
$0.00
$10.00
$12.00
$0.00
$22.00
$0.00
Other
$0.00
$0.00
$0.00
$0.00
$0.00
Total
$92,474.00
$8,109.00
$8,320.00
$108,903.00
$3,552.00
$3,225.00
$222.00
$520.00
$3,967.00
$2,776.00
$0.00
$0.00
$0.00
$0.00
$0.00
Tooling
$2,554.00
$0.00
$5,445.00
$7,999.00
$0.00
Subtotal
$5,779.00
$222.00
$5,965.00
$11,966.00
$2,776.00
DIP Financing
Disbursements Production Raw Material Capital Expenditures
Employee Hourly Payroll
$6,307.50
$6,307.50
$6,607.50
$19,222.50
$6,607.50
$16,685.85
$16,685.85
$16,685.85
$50,057.54
$17,548.91
Payroll Taxes
$3,449.00
$3,449.00
$3,494.00
$10,392.01
$3,623.46
Benefits
$2,299.33
$2,299.33
$2,329.33
$6,928.00
$2,415.64
$0.00
$0.00
$0.00
$0.00
$0.00
$28,741.68
$28,741.68
$29,116.68
$86,600.05
$30,195.51
Rent
$0.00
$0.00
$0.00
$0.00
$0.00
Utilities
$0.00
$0.00
$0.00
$0.00
$0.00
Subtotal
$0.00
$0.00
$0.00
$0.00
$0.00
Bankruptcy
$0.00
$200.00
$178.00
$378.00
$80.00
Salaried Payroll
Travel & Entertainment Subtotal Facility
Interest
$62.00
$0.00
$0.00
$62.00
$0.00
Other
$11.00
$11.00
$11.00
$33.00
$11.00
Total
$34,593.68
$29,174.68
$35,270.68
$99,039.05
$33,062.51
Cash Source / (Use)
$57,880.32
($21,065.68)
($26,950.68)
($26,950.68)
($29,510.51)
Ending Cash
$72,880.32
$51,814.64
$24,863.95
$24,863.95
($4,646.56)
ABC Corp. 13-Week Cash Flow - Basic Prepared by Corporate Restucturing Solutions, Inc. Cash Flow WE 5/9/2009
WE 5/16/2009
WE 5/23/2009
WE 5/30/2009 7
May 2009 8
WE 6/6/2009 8
WE 6/13/2009
5
6
9
10
($4,646.56)
($37,483.06)
$406,400.43
$377,698.42
$24,863.95
$392,696.41
$375,199.40
$0.00
$500,048.00
$0.00
$44,416.00
$548,016.00
$12,320.00
$168,848.00
$0.00
$0.00
$745.00
$0.00
$745.00
$0.00
$0.00
$0.00
$15.00
$0.00
$0.00
$15.00
$0.00
$17.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$500,063.00
$745.00
$44,416.00
$548,776.00
$12,320.00
$168,865.00
$0.00
$254.00
$0.00
$0.00
$3,030.00
$548.00
$5,445.00
$0.00
$25,554.00
$0.00
$0.00
$25,554.00
$0.00
$0.00
$2,554.00
$0.00
$0.00
$0.00
$2,554.00
$0.00
$0.00
$2,554.00
$25,808.00
$0.00
$0.00
$31,138.00
$548.00
$5,445.00
$6,607.50
$6,607.50
$5,857.50
$5,857.50
$31,537.50
$5,857.50
$5,857.50
$17,548.91
$17,548.91
$17,548.91
$17,548.91
$87,744.53
$17,548.91
$17,548.91
$3,623.46
$3,623.46
$3,510.96
$3,510.96
$17,892.31
$3,510.96
$3,510.96
$2,415.64
$2,415.64
$2,340.64
$2,340.64
$11,928.20
$2,340.64
$2,340.64
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$30,195.51
$30,195.51
$29,258.01
$29,258.01
$149,102.54
$29,258.01
$29,258.01
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$165.00
$178.00
$80.00
$503.00
$0.00
$0.00
$76.00
$0.00
$0.00
$69.00
$145.00
$0.00
$0.00
$11.00
$11.00
$11.00
$11.00
$55.00
$11.00
$11.00
$32,836.51
$56,179.51
$29,447.01
$29,418.01
$180,943.54
$29,817.01
$34,714.01
($32,836.51)
$443,883.49
($28,702.01)
$14,997.99
$14,997.99
($17,497.01)
$134,150.99
($37,483.06)
$406,400.43
$377,698.42
$392,696.41
$392,696.41
$375,199.40
$509,350.39
WE 6/20/2009
WE 6/27/2009 11
Jun 2009 12
WE 7/4/2009 12
13
Jul 2009
Total 13
13
$509,350.39
$483,013.39
$392,696.41
$453,566.38
$453,566.38
$15,000.00
$2,000.00
$0.00
$183,168.00
$51,600.00
$51,600.00
$891,200.00
$1,012.00
$0.00
$1,012.00
$0.00
$0.00
$2,222.00
$0.00
$0.00
$17.00
$0.00
$0.00
$54.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$3,012.00
$0.00
$184,197.00
$51,600.00
$51,600.00
$893,476.00
$0.00
$0.00
$5,993.00
$3,225.00
$3,225.00
$16,215.00
$0.00
$0.00
$0.00
$0.00
$0.00
$25,554.00
$0.00
$0.00
$0.00
$0.00
$0.00
$10,553.00
$0.00
$0.00
$5,993.00
$3,225.00
$3,225.00
$52,322.00
$5,857.50
$5,857.50
$23,430.00
$5,857.50
$5,857.50
$80,047.50
$17,548.91
$17,548.91
$70,195.63
$17,548.91
$17,548.91
$225,546.61
$3,510.96
$3,510.96
$14,043.84
$3,510.96
$3,510.96
$45,839.12
$2,340.64
$2,340.64
$9,362.56
$2,340.64
$2,340.64
$30,559.41
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$29,258.01
$29,258.01
$117,032.03
$29,258.01
$29,258.01
$381,992.63
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$80.00
$178.00
$258.00
$80.00
$80.00
$1,219.00 $207.00
$0.00
$0.00
$0.00
$0.00
$0.00
$11.00
$11.00
$44.00
$11.00
$11.00
$143.00
$29,349.01
$29,447.01
$123,327.03
$32,574.01
$32,574.01
$435,883.63
($26,337.01)
($29,447.01)
($29,447.01)
$19,025.99
$19,025.99
$19,025.99
$483,013.39
$453,566.38
$453,566.38
$472,592.37
$472,592.37
$472,592.37
ABC Corp. 13-Week Cash Flow - Basic Prepared by Corporate Restucturing Solutions, Inc. Formulas Variable
Display As
Cash_Beginning
Beginning Cash Balance
Cash_Ending
Ending Cash
Cash_Initial
Initial Cash
Cash_Payroll
Cash Payroll
Cash_Source
Cash Source / (Use)
Company_Name
Company Name
Database_Offset
Database Offset
Database_Start_Date
Database Start Date
Disbursements
Disbursements
Expense_Bankruptcy
Bankruptcy
Expense_Other
Other Expense
Hourly_Benefits_pct
Hourly Benefits %
Hourly_Payroll_Tax_pct
Hourly Payroll Tax %
Interest_Expense
Interest Expense
Preparer_Name
Preparer Name
Production_Disbursements
Production Disbursements
Receipts
Receipts
Salary_Benefits_pct
Salaried Benefits %
Salary_Payroll_Tax_pct
Salaried Payroll Tax %
Time_Weeks
Week
Travel_Entertainment
Travel & Entertainment
s, Inc.
Dimension Index Global
Data:
Global
Data:
Payroll_Cash.Hourly_Payroll
Data:
Payroll_Cash.Salaried_Payroll
Data:
Global
Data:
Databases.Hourly
Data:
Databases.Salaried
Data:
Databases.Salaried
Data:
Databases.Hourly
Data:
Disbursements.Production.Capital_Expenditures
Data:
Disbursements.Other
Data:
Disbursements.Interest
Data:
Disbursements.Bankruptcy
Data:
Disbursements.Employee.Benefits
Data:
Disbursements.Employee.Hourly_Payroll
Data:
Disbursements.Production.Tooling
Data:
Disbursements.Production.Raw_Material
Data:
Disbursements.Employee.Salaried_Payroll
Data:
Disbursements.Employee.Payroll_Taxes
Data:
Disbursements.Employee.Travel___Entertainment
Data:
Global
Data:
Global
Data:
Formula / Data preve(Cash_initial, Cash_Ending) Cash_Beginning+Cash_Source
extdata("Employee Data", "Hourly_WeeklyEarnings", 1, Time_Weeks+Database_Offset["Databases.Hourly"]) extdata("Employee Data", "Salaried_WeeklyEarnings", 1, Time_Weeks+Database_Offset["Databases.Salaried"]) Receipts-Disbursements
round((model_date(1)-Database_Start_Date["Databases.Hourly"])/7, 0) round((model_date(1)-Database_Start_Date["Databases.Salaried"])/7, 0) extdata("Employee Data", "Salaried_Data_StartDate", 1, 1) extdata("Employee Data", "Hourly_Data_StartDate", 1, 1) Production_Disbursements["Production_Cash.Capital_Expenditures"] Expense_Other Interest_Expense Expense_Bankruptcy
Disbursements["Disbursements.Employee.Hourly_Payroll"]*Hourly_Benefits_pct+Disbursements["Disbursements.Employee.Salaried_Payroll"]*Salary_Be Cash_Payroll["Payroll_Cash.Hourly_Payroll"] Production_Disbursements["Production_Cash.Tooling"] Production_Disbursements["Production_Cash.Raw_Material"] Cash_Payroll["Payroll_Cash.Salaried_Payroll"]
Disbursements["Disbursements.Employee.Hourly_Payroll"]*Hourly_Payroll_Tax_pct+Disbursements["Disbursements.Employee.Salaried_Payroll"]*Salary Travel_Entertainment
preve(0)+1 preve(0)
Receipts_1 WE 4/11/2009 4/5/2009
WE 4/18/2009 4/12/2009
WE 4/25/2009 4/19/2009
Apr 2009 4/1/2009
WE 5/2/2009 4/26/2009
Receipts_2 WE 4/11/2009 WE 4/11/2009
WE 4/18/2009 WE 4/18/2009
WE 4/25/2009 WE 4/25/2009
Apr 2009 WE 4/4/2009
WE 5/2/2009 WE 5/2/2009
Cash_Ending_1 WE 4/11/2009 4/5/2009
WE 4/18/2009 4/12/2009
WE 4/25/2009 4/19/2009
Apr 2009 4/1/2009
WE 5/2/2009 4/26/2009
Cash_Ending_2 WE 4/11/2009 WE 4/11/2009
WE 4/18/2009 WE 4/18/2009
WE 4/25/2009 WE 4/25/2009
Apr 2009 WE 4/4/2009
WE 5/2/2009 WE 5/2/2009
Disbursements_1 WE 4/11/2009 4/5/2009
WE 4/18/2009 4/12/2009
WE 4/25/2009 4/19/2009
Apr 2009 4/1/2009
WE 5/2/2009 4/26/2009
Disbursements_2 WE 4/11/2009 WE 4/11/2009
WE 4/18/2009 WE 4/18/2009
WE 4/25/2009 WE 4/25/2009
Apr 2009 WE 4/4/2009
WE 5/2/2009 WE 5/2/2009
ABC Corp. 13-Week Cash Flow - Basic Prepared by Corporate Restucturing Solutions, Inc. Default Shadow
WE 5/9/2009 5/3/2009 WE 5/9/2009 WE 5/9/2009 WE 5/9/2009 5/3/2009 WE 5/9/2009 WE 5/9/2009 WE 5/9/2009 5/3/2009 WE 5/9/2009 WE 5/9/2009
WE 5/16/2009 5/10/2009 WE 5/16/2009 WE 5/16/2009 WE 5/16/2009 5/10/2009 WE 5/16/2009 WE 5/16/2009 WE 5/16/2009 5/10/2009 WE 5/16/2009 WE 5/16/2009
WE 5/23/2009 5/17/2009 WE 5/23/2009 WE 5/23/2009 WE 5/23/2009 5/17/2009 WE 5/23/2009 WE 5/23/2009 WE 5/23/2009 5/17/2009 WE 5/23/2009 WE 5/23/2009
WE 5/30/2009 5/24/2009 WE 5/30/2009 WE 5/30/2009 WE 5/30/2009 5/24/2009 WE 5/30/2009 WE 5/30/2009 WE 5/30/2009 5/24/2009 WE 5/30/2009 WE 5/30/2009
May 2009 5/1/2009 May 2009 WE 5/2/2009 May 2009 5/1/2009 May 2009 WE 5/2/2009 May 2009 5/1/2009 May 2009 WE 5/2/2009
WE 6/6/2009 5/31/2009 WE 6/6/2009 WE 6/6/2009 WE 6/6/2009 5/31/2009 WE 6/6/2009 WE 6/6/2009 WE 6/6/2009 5/31/2009 WE 6/6/2009 WE 6/6/2009
WE 6/13/2009 6/7/2009 WE 6/13/2009 WE 6/13/2009 WE 6/13/2009 6/7/2009 WE 6/13/2009 WE 6/13/2009 WE 6/13/2009 6/7/2009 WE 6/13/2009 WE 6/13/2009
WE 6/20/2009 6/14/2009 WE 6/20/2009 WE 6/20/2009 WE 6/20/2009 6/14/2009 WE 6/20/2009 WE 6/20/2009 WE 6/20/2009 6/14/2009 WE 6/20/2009 WE 6/20/2009
WE 6/27/2009 6/21/2009 WE 6/27/2009 WE 6/27/2009 WE 6/27/2009 6/21/2009 WE 6/27/2009 WE 6/27/2009 WE 6/27/2009 6/21/2009 WE 6/27/2009 WE 6/27/2009
Jun 2009 6/1/2009 Jun 2009 WE 6/6/2009 Jun 2009 6/1/2009 Jun 2009 WE 6/6/2009 Jun 2009 6/1/2009 Jun 2009 WE 6/6/2009
WE 7/4/2009 6/28/2009 WE 7/4/2009 WE 7/4/2009 WE 7/4/2009 6/28/2009 WE 7/4/2009 WE 7/4/2009 WE 7/4/2009 6/28/2009 WE 7/4/2009 WE 7/4/2009
Jul 2009 7/1/2009 Jul 2009 WE 7/4/2009 Jul 2009 7/1/2009 Jul 2009 WE 7/4/2009 Jul 2009 7/1/2009 Jul 2009 WE 7/4/2009
ABC Corp. 13-Week Cash Flow - Basic Prepared by Corporate Restucturing Solutions, Inc. Default Variables Database Offset Databases Hourly
0.00
Salaried
0.00
Total
0.00
Database Start Date Databases Hourly
4/5/2009
Salaried
4/5/2009
ABC Corp. 13-Week Cash Flow - Basic Prepared by Corporate Restucturing Solutions, Inc. Labels Variable
Display Label
Cash_Beginning
Beginning Cash Balance
Cash_Ending
Ending Cash
Cash_Initial
Initial Cash
Cash_Payroll
Cash Payroll
Cash_Source
Cash Source / (Use)
Company_Name
Company Name
Database_Offset
Database Offset
Database_Start_Date
Database Start Date
Disbursements
Disbursements
Expense_Bankruptcy
Bankruptcy
Expense_Other
Other Expense
Hourly_Benefits_pct
Hourly Benefits %
Hourly_Payroll_Tax_pct
Hourly Payroll Tax %
Interest_Expense
Interest Expense
Preparer_Name
Preparer Name
Production_Disbursements
Production Disbursements
Receipts
Receipts
Salary_Benefits_pct
Salaried Benefits %
Salary_Payroll_Tax_pct
Salaried Payroll Tax %
Time_Weeks
Week
Travel_Entertainment
Travel & Entertainment
Dimension (item)
Display Item As
Total As
Level As
Databases
Databases
Total
Databases
Hourly
Hourly
Salaried
Salaried
Disbursements Production
Disbursements
Total
Disbursements
Production
Subtotal
Disbursements
Raw_Material
Raw Material
Capital_Expenditures
Capital Expenditures
Tooling
Tooling
Employee
Employee
Hourly_Payroll
Hourly Payroll
Salaried_Payroll
Salaried Payroll
Payroll_Taxes
Payroll Taxes
Benefits
Benefits
Travel___Entertainment
Travel & Entertainment
Facility
Databases
Facility
Rent
Rent
Utilities
Utilities
Bankruptcy
Bankruptcy
Interest
Interest
Other
Other
Disbursements 2
Subtotal
Subtotal
Payroll_Cash
Payroll Cash
Hourly_Payroll
Hourly Payroll
Salaried_Payroll
Salaried Payroll
Production_Cash
Production Cash
Raw_Material
Raw Material
Capital_Expenditures
Capital Expenditures
Tooling
Tooling
Receipts
Receipts
A_R___Trade
A/R - Trade
A_R_Line_of_Credit
A/R Line of Credit
DIP_Financing
DIP Financing
Other
Other
Total
Payroll_Cash Employee_Exp
Total
Production_Cash Production_Exp
Total
Collections Collections
Comment Cash balance at the start of each time period Cash balance at the end of each time period Initial cash balance at the start of the first time period Payroll expenses for hourly and salaried employees. Payroll benefits and taxes are computed elsewhere in the model. This variable holds input data. Net cash flow (sources less uses) for each time period Name of the company whose cash flow is being modeled
Cash flow from disbursements, for each time period Expenses incurred due to bankruptcy process, for each time period Miscellaneous cash expenses not counted elswhere in the cash flow analysis Cash cost of benefits for hourly employees as a percentage of wage disbursements, by hourly employee, by time period Cash cost of payroll taxes as a percentage of wage disbursements Interest expense Name of the person or organization that designed or prepared the report. Production expenses on a cash basis, including raw material, capital expenditures and tooling. This variable holds input data. Cash flow from collections, for eah time period Cash cost of benefits for salaried employees as a percentage of salary disbursements, by salaried employee, by time period Cash cost of payroll taxes as a percentage of wage disbursements Time in weeks, counted from the start of the first time period Travel and entertainment expense, by time period Comment
A list of the payables accounts
A list of types of payroll cash expense (excluding benefits and taxes)
A list of types of production cash expenses, including material, capital expenditures and tooling
A list of the receivables accounts
ZZZ_Ranges!Receipts_Receipts_A_R___Trade 92464 7632 8320 3552 0 500048 0 44416 ZZZ_Ranges!Receipts_Receipts_A_R_Line_of_Credit 0 465 0 0 0 0 745 0 ZZZ_Ranges!Receipts_Receipts_DIP_Financing 10 12 0 0 0 15 0 0 ZZZ_Ranges!Receipts_Receipts_Other 0 0 0 0 0 0 0 0 ZZZ_Ranges!Receipts_Receipts 92474 8109 8320 3552 0 500063 745 44416 ZZZ_Ranges!Receipts_Time_Period WE 4/11/2009 WE 4/18/2009 WE 4/25/2009 WE 5/2/2009 WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 ZZZ_Ranges!Receipts_Date 04/05/09 04/12/09 04/19/09 04/26/09 05/03/09 05/10/09 05/17/09 05/24/09 ZZZ_Ranges!Cash_Ending 72880.32 51814.64 24863.95 -4646.56 -37483.06 406400.43 377698.42 392696.41 ZZZ_Ranges!Cash_Ending_Time_Period WE 4/11/2009 WE 4/18/2009 WE 4/25/2009 WE 5/2/2009 WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 ZZZ_Ranges!Cash_Ending_Date 04/05/09 04/12/09 04/19/09 04/26/09 05/03/09 05/10/09 05/17/09 05/24/09 ZZZ_Ranges!Disbursements_Disbursements_Production_Raw_Material 3225 222 520 2776 0 254 0 0 ZZZ_Ranges!Disbursements_Disbursements_Production_Capital_Expenditures 0 0 0 0 0 25554 0 0 ZZZ_Ranges!Disbursements_Disbursements_Production_Tooling 2554 0 5445 0 2554 0 0 0 ZZZ_Ranges!Disbursements_Disbursements_Production 5779 222 5965 2776 2554 25808 0 0 ZZZ_Ranges!Disbursements_Disbursements_Employee_Hourly_Payroll 6307.5 6307.5 6607.5 6607.5 6607.5 6607.5 5857.5 5857.5 ZZZ_Ranges!Disbursements_Disbursements_Employee_Salaried_Payroll 16685.85 16685.85 16685.85 17548.91 17548.91 17548.91 17548.91 17548.91 ZZZ_Ranges!Disbursements_Disbursements_Employee_Payroll_Taxes 3449 3449 3494 3623.46 3623.46 3623.46 3510.96 3510.96 ZZZ_Ranges!Disbursements_Disbursements_Employee_Benefits 2299.33 2299.33 2329.33 2415.64 2415.64 2415.64 2340.64 2340.64 ZZZ_Ranges!Disbursements_Disbursements_Employee_Travel___Entertainment 0 0 0 0 0 0 0 0 ZZZ_Ranges!Disbursements_Disbursements_Employee 28741.68 28741.68 29116.68 30195.51 30195.51 30195.51 29258.01 29258.01 ZZZ_Ranges!Disbursements_Disbursements_Facility_Rent 0 0 0 0 0 0 0 0 ZZZ_Ranges!Disbursements_Disbursements_Facility_Utilities 0 0 0 0 0 0 0 0 ZZZ_Ranges!Disbursements_Disbursements_Facility 0 0 0 0 0 0 0 0 ZZZ_Ranges!Disbursements_Disbursements_Bankruptcy 0 200 178 80 0 165 178 80 ZZZ_Ranges!Disbursements_Disbursements_Interest 62 0 0 0 76 0 0 69 ZZZ_Ranges!Disbursements_Disbursements_Other 11 11 11 11 11 11 11 11 ZZZ_Ranges!Disbursements_Disbursements 34593.68 29174.68 35270.68 33062.51 32836.51 56179.51 29447.01 29418.01 ZZZ_Ranges!Disbursements_Time_Period WE 4/11/2009 WE 4/18/2009 WE 4/25/2009 WE 5/2/2009 WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 ZZZ_Ranges!Disbursements_Date 04/05/09 04/12/09 04/19/09 04/26/09 05/03/09 05/10/09 05/17/09 05/24/09
12320 168848 2000 0 51600 0 0 1012 0 0 0 17 0 0 0 0 0 0 0 0 12320 168865 3012 0 51600 WE 6/6/2009 WE 6/13/2009 WE 6/20/2009 WE 6/27/2009 WE 7/4/2009 05/31/09 06/07/09 06/14/09 06/21/09 06/28/09 375199.4 509350.39 483013.39 453566.38 472592.37 WE 6/6/2009 WE 6/13/2009 WE 6/20/2009 WE 6/27/2009 WE 7/4/2009 05/31/09 06/07/09 06/14/09 06/21/09 06/28/09 548 5445 0 0 3225 0 0 0 0 0 0 0 0 0 0 548 5445 0 0 3225 5857.5 5857.5 5857.5 5857.5 5857.5 17548.91 17548.91 17548.91 17548.91 17548.91 3510.96 3510.96 3510.96 3510.96 3510.96 2340.64 2340.64 2340.64 2340.64 2340.64 0 0 0 0 0 29258.01 29258.01 29258.01 29258.01 29258.01 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 80 178 80 0 0 0 0 0 11 11 11 11 11 29817.01 34714.01 29349.01 29447.01 32574.01 WE 6/6/2009 WE 6/13/2009 WE 6/20/2009 WE 6/27/2009 WE 7/4/2009 05/31/09 06/07/09 06/14/09 06/21/09 06/28/09
Company_Name[]| ABC Corp. Preparer_Name[]| Corporate Restucturing Cash_Initial[]|Solutions, 15000 Receipts["Receipts.A_R___Trade", Inc. 92464 Receipts["Receipts.A_R___Trad DATE(2009,4,5)]| Receipts["Receipts.DIP_Financing", 0 Receipts["Receipts.DIP_Financing", DATE(2009,4,26)]|=0/4 0 Receipts["Receipts.DIP_Financing", DATE(2009,5,3)]|=0/4 15 Receipts["Receipts.DIP_Financing", DATE(2009,5,10)]| 0 Receipts["Receipts.DIP_Financin DATE(2009,5,17)]| Production_Disbursements["Production_Cash.Raw_Material", 5445 Production_Disbursements["Production_Cash.Raw_Material", 0 Production_Disbursements["Production_Cash.Raw_Material", DATE(2009,6,7)]| 0 Production_Disbursements["Production_Cash.Raw_Ma 3225 DATE(2009,6,14)]| Production_Disbursements["Prod DATE(2009,6,2 Expense_Bankruptcy[DATE(2009,4,19)]| 178 Expense_Bankruptcy[DATE(2009,4,26)]| 80 Expense_Bankruptcy[DATE(2009,5,3)]| 0 Expense_Bankruptcy[DATE(2009,5,10)]| 165 Expense_Bankruptcy[DATE(200 Expense_Other[DATE(2009,5,31)]|=11 11 Expense_Other[DATE(2009,6,7)]|=11 11 Expense_Other[DATE(2009,6,14)]|=11 11 Expense_Other[DATE(2009,6,21)]|=11 11 Expense_Other[DATE(2009,6,28 Cash_Payroll["Payroll_Cash.Salaried_Payroll", 16685.85 Cash_Payroll["Payroll_Cash.Salaried_Payroll", 16685.85 Cash_Payroll["Payroll_Cash.Salaried_Payroll", DATE(2009,4,12)]|=INDEX(Salaried_WeeklyEarnings, 17548.91 Cash_Payroll["Payroll_Cash.Salaried_Payroll", DATE(2009,4,19)]|=INDEX(Salaried_WeeklyEarning 17548.91 Cash_Payroll["Payroll_Cash.Sala DATE(2009,4,26)]|=INDEX(Sa 1, 'Cash Flow'!C7+'D DATE(2 :A:0:Disbursements Disbursements :A:-1:Disbursements Cash flow from :A:0:Receipts disbursements, Receipts for:A:-1:Receipts each time Cash periodflow from :A:0:Cash_Beginning collections, for eah time peri :A:0:Production_Disbursements Production :A:-1:Production_Disbursements Disbursements Production :A:0:Cash_Payroll expenses on Cash a cash Payroll basis, :A:-1:Cash_Payroll including Payroll raw expenses material, :A:0:Preparer_Name capital for hourly expenditures and salaried andem to :D:0:Disbursements.Bankruptcy Bankruptcy:D:0:Disbursements.Interest Interest :D:0:Disbursements.Other Other :D:-1:Receipts A list of the:D:0:Receipts receivables accounts :D:2:Databases.Hourly Databases :D:0:Databases.Salaried Salaried :WS:Output 0 :WS: 0 :WS: 0 :WS: ABC Corp. :WS:
7632 Receipts["Receipts.A_R___Trade", 8320 Receipts["Receipts.A_R___Trade", DATE(2009,4,19)]| 3552 Receipts["Receipts.A_R___Trade", DATE(2009,4,26)]| 0 Receipts["Receipts.A_R___Trade", DATE(2009,5,3)]| 500048 DATE(2 0 Receipts["Receipts.DIP_Financing", 0 Receipts["Receipts.DIP_Financing", DATE(2009,5,31)]|=0/4 17 Receipts["Receipts.DIP_Financing", DATE(2009,6,7)]| 0 Receipts["Receipts.DIP_Financing", DATE(2009,6,14)]|=0/4 0 DATE(2 0 Production_Disbursements["Production_Cash.Capital_Expenditures", 0 Production_Disbursements["Production_Cash.Capital_Expenditures", 0 Production_Disbursements["Production_Cash.Capital_Expenditure 0 Production_Disbursements["Production_Cas DATE(2009,4,12)]|0 DATE(2009,4,19)]| 178 Expense_Bankruptcy[DATE(2009,5,24)]| 80 Expense_Bankruptcy[DATE(2009,5,31)]|=0 0 Expense_Bankruptcy[DATE(2009,6,7)]|=0 0 Expense_Bankruptcy[DATE(2009,6,14)]| 80 11 Travel_Entertainment[DATE(2009,4,5)]|=0 0 Travel_Entertainment[DATE(2009,4,12)]|=B34 0 Travel_Entertainment[DATE(2009,4,19)]|=C34 0 Travel_Entertainment[DATE(2009,4,26)]|=D 0 17548.91 Cash_Payroll["Payroll_Cash.Salaried_Payroll", 17548.91 Cash_Payroll["Payroll_Cash.Salaried_Payroll", 17548.91 Cash_Payroll["Payroll_Cash.Salaried_Payroll", DATE(2009,5,17)]|=INDEX(Salaried_WeeklyEarnings, 17548.91 Cash_Payroll["Payroll_Cash.Salaried_Payro DATE(2009,5,24)]|=INDEX(Salaried_Wee 17548.91 DATE(2009,5,31)]| 1, 'Cash Beginning Cash :A:-1:Cash_Beginning Balance Cash balance :A:0:Cash_Initial at the start Initial of each Cash:A:-1:Cash_Initial time periodInitial cash :A:0:Cash_Source balance at the Cash start Source of the/ (Use) first time period Preparer Name :A:-1:Preparer_Name Name of the:A:0:Database_Start_Date person orDatabase organization Start :A:-1:Database_Start_Date that Date designed or prepared 0 :A:0:Database_Offset the report. Database Offset Receipts :D:2:Receipts Collections:D:1:Receipts Total :D:0:Receipts.A_R___Trade A/R - Trade:D:2:Receipts.A_R___Trade Collections 0 :WS:
ABC Corp. :WS:
ABC Corp. :WS:Employee Current DataDate :WS:Employee Current DataDate
Receipts["Receipts.A_R___Trade", 0 Receipts["Receipts.A_R___Trade", DATE(2009,5,17)]| 44416 Receipts["Receipts.A_R___Trade", DATE(2009,5,24)]| 12320 Receipts["Receipts.A_R___Trade", DATE(2009,5,31)]| 168848 Receipts["Receipts.A_R___Trad DATE(2009,6,7)]| Receipts["Receipts.DIP_Financing", 0 Receipts["Receipts.Other", DATE(2009,6,28)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,4,5)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,4,12)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,4,19)]|=0/4DATE Production_Disbursements["Production_Cash.Capital_Expenditures", 25554 Production_Disbursements["Production_Cash.Capital_Expenditures", 0 Production_Disbursements["Production_Cash.Capital_Expenditures", 0 Production_Disbursements["Production_Cash.Capital_E DATE(2009,5,10)]|0 Production_Disbursements["Prod DATE(2009,5,17)]| DATE(2 Expense_Bankruptcy[DATE(2009,6,21)]| 178 Expense_Bankruptcy[DATE(2009,6,28)]| 80 Interest_Expense[DATE(2009,4,5)]| 62 Interest_Expense[DATE(2009,4,12)]|=0 0 Interest_Expense[DATE(2009,4, Travel_Entertainment[DATE(2009,5,3)]|=F34 0 Travel_Entertainment[DATE(2009,5,10)]|=G34 0 Travel_Entertainment[DATE(2009,5,17)]|=H34 0 Travel_Entertainment[DATE(2009,5,24)]|=I34 0 Travel_Entertainment[DATE(200 Cash_Payroll["Payroll_Cash.Salaried_Payroll", 17548.91 Cash_Payroll["Payroll_Cash.Salaried_Payroll", 17548.91 Cash_Payroll["Payroll_Cash.Salaried_Payroll", DATE(2009,6,14)]|=INDEX(Salaried_WeeklyEarnings, 17548.91 Hourly_Payroll_Tax_pct[]| DATE(2009,6,21)]|=INDEX(Salaried_WeeklyEarning 15.00% Hourly_Benefits_pct[]| DATE(2009,6,28)]|=INDEX(Sa 1, 'Cash Flow'!N7+'D :A:-1:Cash_Source Net cash flow :A:0:Cash_Ending (sourcesEnding less uses) Cash :A:-1:Cash_Ending for each time Cash period balance :A:0:Time_Weeks at the end Week of each time :A:-1:Time_Weeks period :A:-1:Database_Offset 0 :D:-1:Disbursements A list of the:D:0:Disbursements payables accounts Disbursements :D:2:Disbursements Disbursements :D:1:Disbursements :D:0:Receipts.A_R_Line_of_Credit A/R Line of:D:0:Receipts.DIP_Financing Credit DIP Financing :D:0:Receipts.Other Other :D:-1:Production_Cash A list of types :D:0:Production_Cash of production cash expenses, :WS:
ZZZ_Ranges!Receipts_Receipts_A_R___Trade :WS: Company_Name[]|
2000 Receipts["Receipts.A_R___Trade", 0 Receipts["Receipts.A_R___Trade", DATE(2009,6,21)]| 51600 Receipts["Receipts.A_R_Line_of_Credit", DATE(2009,6,28)]| 0 Receipts["Receipts.A_R_Line_of_Credit", 465 DATE(2009,4,5)]|=0/4 D 0 Receipts["Receipts.Other", 0 Receipts["Receipts.Other", DATE(2009,5,3)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,5,10)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,5,17)]|=0/4 0 DATE(2009,5,24 0 Production_Disbursements["Production_Cash.Capital_Expenditures", 0 Production_Disbursements["Production_Cash.Capital_Expenditures", 0 Production_Disbursements["Production_Cash.Capital_Expenditure 0 Production_Disbursements["Production_Cas DATE(2009,6,14)]| 2554 DATE(2009,6,21)]| 0 Interest_Expense[DATE(2009,4,26)]|=0 0 Interest_Expense[DATE(2009,5,3)]| 76 Interest_Expense[DATE(2009,5,10)]|=0 0 Interest_Expense[DATE(2009,5,17)]|=0 0 0 Travel_Entertainment[DATE(2009,6,7)]|=L34 0 Travel_Entertainment[DATE(2009,6,14)]|=M34 0 Travel_Entertainment[DATE(2009,6,21)]|=N34 0 Travel_Entertainment[DATE(2009,6,28)]|=O 0 10.00% Salary_Payroll_Tax_pct[]| 15.00% Salary_Benefits_pct[]| 10.00% Time in weeks, :A:0:Salary_Benefits_pct counted Salaried from the Benefits start :A:-1:Salary_Benefits_pct of% the first Cash time cost period of :A:0:Hourly_Payroll_Tax_pct benefits for Hourly salaried Payroll employees :A:-1:Hourly_Payroll_Tax_pct Tax % Cash as a percentage cost of payroll of salary taxes disburs as a p Total :D:0:Disbursements.Production Production :D:2:Disbursements.Production Disbursements :D:1:Disbursements.Production Subtotal :D:0:Disbursements.Production.Raw_Materi Raw Material Production :D:2:Production_Cash Cash Production_Cash :D:1:Production_Cash Total :D:0:Production_Cash.Raw_Material Raw Material :D:2:Production_Cash.Raw_Material Production_Exp
Receipts["Receipts.A_R_Line_of_Credit", 0 Receipts["Receipts.A_R_Line_of_Credit", DATE(2009,4,19)]|=0/4 0 Receipts["Receipts.A_R_Line_of_Credit", DATE(2009,4,26)]|=0/4 0 Receipts["Receipts.A_R_Line_of_Credit", DATE(2009,5,3)]|=0/4 0 Receipts["Receipts.A_R_Line_of DATE(2009,5 Receipts["Receipts.Other", 0 Receipts["Receipts.Other", DATE(2009,5,31)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,6,7)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,6,14)]|=0/4 0 Receipts["Receipts.Other", DATE(2009,6,21)]|=0/4DATE Production_Disbursements["Production_Cash.Tooling", 0 Production_Disbursements["Production_Cash.Tooling", 5445 Production_Disbursements["Production_Cash.Tooling", DATE(2009,4,12)]| 0 Production_Disbursements["Production_Cash.Tooling", DATE(2009,4,19)]| 2554 Production_Disbursements["Prod DATE(2009,4,26)]| Interest_Expense[DATE(2009,5,24)]| 69 Interest_Expense[DATE(2009,5,31)]|=0 0 Interest_Expense[DATE(2009,6,7)]|=0 0 Interest_Expense[DATE(2009,6,14)]|=0 0 Interest_Expense[DATE(2009,6, Cash_Payroll["Payroll_Cash.Hourly_Payroll", 6307.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", 6307.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", DATE(2009,4,5)]|=INDEX(Hourly_WeeklyEarnings, 6607.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", DATE(2009,4,12)]|=INDEX(Hourly_WeeklyEarnings, 6607.5 Cash_Payroll["Payroll_Cash.Hou DATE(2009,4,19)]|=INDEX(Hou 1, 'Cash Flow'!B7+'Defau DATE(201
:A:0:Hourly_Benefits_pct Hourly Benefits :A:-1:Hourly_Benefits_pct % Cash cost of :A:0:Salary_Payroll_Tax_pct benefits for Salaried hourly Payroll employees :A:-1:Salary_Payroll_Tax_pct Tax % asCash a percentage cost of :A:0:Travel_Entertainment payroll of wage taxes disbursements, as a percentage by ho :D:2:Disbursements.Production.Raw_Material Disbursements :D:0:Disbursements.Production.Capital_Expenditures 2 Capital Expenditures :D:0:Disbursements.Production.Tooling Tooling :D:0:Disbursements.Employee Employee :D:1:Disbursements.Employee :D:0:Production_Cash.Capital_Expenditures Capital Expenditures :D:0:Production_Cash.Tooling Tooling :D:-1:Payroll_Cash A list of types :D:0:Payroll_Cash of payrollPayroll cash expense Cash :D:2:Payroll_Cash (excluding benefits and taxe
745 Receipts["Receipts.A_R_Line_of_Credit", 0 Receipts["Receipts.A_R_Line_of_Credit", DATE(2009,5,24)]|=0/4 0 Receipts["Receipts.A_R_Line_of_Credit", DATE(2009,5,31)]|=0/4 0 Receipts["Receipts.A_R_Line_of_Credit", 1012 DATE(2009,6,7)]|=0/4 D 0 Production_Disbursements["Production_Cash.Raw_Material", 3225 Production_Disbursements["Production_Cash.Raw_Material", 222 Production_Disbursements["Production_Cash.Raw_Material", DATE(2009,4,5)]| 520 Production_Disbursements["Production_Cas 2776 DATE(2009,4,12)]| DAT 0 Production_Disbursements["Production_Cash.Tooling", 0 Production_Disbursements["Production_Cash.Tooling", 0 Production_Disbursements["Production_Cash.Tooling", DATE(2009,5,17)]| 0 Production_Disbursements["Production_Cas DATE(2009,5,24)]| 0 DATE(200 0 Interest_Expense[DATE(2009,6,28)]|=0 0 Expense_Other[DATE(2009,4,5)]|=11 11 Expense_Other[DATE(2009,4,12)]|=11 11 Expense_Other[DATE(2009,4,19)]|=11 11 6607.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", 6607.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", 5857.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", DATE(2009,5,10)]|=INDEX(Hourly_WeeklyEarnings, 5857.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll" DATE(2009,5,17)]|=INDEX(Hourly_Weekly 5857.5 DATE(2009,5,24)]|=I 1, 'Cash Flow
Travel & Entertainment :A:-1:Travel_Entertainment Travel and :A:0:Expense_Bankruptcy entertainment Bankruptcy:A:-1:Expense_Bankruptcy expense, by time period Expenses incurred :A:0:Interest_Expense dueInterest to bankruptcy Expense process, for each Subtotal :D:0:Disbursements.Employee.Hourly_Payroll Hourly Payroll :D:0:Disbursements.Employee.Salaried_Payroll Salaried Payroll :D:0:Disbursements.Employee.Payroll_Taxes Payroll Taxes :D:0:Disbursements.Employee.Benefits Benefits Payroll_Cash :D:1:Payroll_Cash Total :D:0:Payroll_Cash.Hourly_Payroll Hourly Payroll :D:2:Payroll_Cash.Hourly_Payroll Employee_Exp :D:0:Payroll_Cash.Salaried_Payroll Salaried Payroll
Receipts["Receipts.A_R_Line_of_Credit", 0 Receipts["Receipts.A_R_Line_of_Credit", DATE(2009,6,21)]|=0/4 0 Receipts["Receipts.DIP_Financing", 10 DATE(2009,6,28)]|=0/4 Receipts["Receipts.DIP_Financing", DATE(2009,4,5)]| 12 Receipts["Receipts.DIP_Financin DATE(2009,4,12)]| Production_Disbursements["Production_Cash.Raw_Material", 0 Production_Disbursements["Production_Cash.Raw_Material", 254 Production_Disbursements["Production_Cash.Raw_Material", DATE(2009,5,3)]| 0 Production_Disbursements["Production_Cash.Raw_Ma DATE(2009,5,10)]| 0 Production_Disbursements["Prod DATE(2009,5,1 Production_Disbursements["Production_Cash.Tooling", 0 Production_Disbursements["Production_Cash.Tooling", 0 Production_Disbursements["Production_Cash.Tooling", DATE(2009,6,14)]| 0 Expense_Bankruptcy[DATE(2009,4,5)]|=0 DATE(2009,6,21)]| 0 Expense_Bankruptcy[DATE(200 DATE(2009,6,28)]| Expense_Other[DATE(2009,4,26)]|=11 11 Expense_Other[DATE(2009,5,3)]|=11 11 Expense_Other[DATE(2009,5,10)]|=11 11 Expense_Other[DATE(2009,5,17)]|=11 11 Expense_Other[DATE(2009,5,24 Cash_Payroll["Payroll_Cash.Hourly_Payroll", 5857.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", 5857.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", DATE(2009,6,7)]|=INDEX(Hourly_WeeklyEarnings, 5857.5 Cash_Payroll["Payroll_Cash.Hourly_Payroll", DATE(2009,6,14)]|=INDEX(Hourly_WeeklyEarnings, 5857.5 Cash_Payroll["Payroll_Cash.Sala DATE(2009,6,21)]|=INDEX(Hou 1, 'Cash Flow'!M7+'Defau DATE(201
:A:-1:Interest_Expense Interest expense :A:0:Expense_Other Other Expense :A:-1:Expense_Other Miscellaneous :A:0:Company_Name cash expenses Company notName :A:-1:Company_Name counted elswhere in the cash flo :D:0:Disbursements.Employee.Travel___Entertainment Travel & Entertainment :D:0:Disbursements.Facility Facility :D:1:Disbursements.Facility Subtotal :D:0:Disbursements.Facility.Rent Rent :D:0:Disbursements.Facility.Utilit :D:-1:Databases 0 :D:0:Databases Databases :D:2:Databases Databases :D:1:Databases Total :D:0:Databases.Hourly
0 548 200 11 16685.85 Name of the company whose cash flow is being modeled Utilities Hourly
Current Date
ABC Corp. Hourly Employee Data
4/5/2009
Color code: This color background (dark blue on my PC) indicates input data Totals
Employee First Name
Employee Last Name
$207.25
Employee ID #
Hourly Rate
$820.00
Standard Biweekly Hours
$13,215.00
Standard Biweekly Wage
Peter
Staudt
1001
$10.00
60.00
$600.00
Maynard E.
Chau
1002
$12.00
50.00
$600.00
Cornelius M.
Peterman
1003
$8.75
60.00
$525.00
Santos
Linthicum
1004
$9.50
80.00
$760.00
Freddie
Haden
1005
$13.00
70.00
$910.00
John
Ashe
1006
$14.00
80.00
$1,120.00
Philip
Gamblin
1007
$14.00
40.00
$560.00
Rene L.
Callender
1008
$15.00
40.00
$600.00
Brandon
Tuma
1009
$21.00
40.00
$840.00
Antonio
Blackwood
1010
$25.00
60.00
$1,500.00
Sharan
Barboza
1011
$30.00
80.00
$2,400.00
Peter
Demaree
1012
$18.00
80.00
$1,440.00
Danille
Aarons
1013
$17.00
80.00
$1,360.00
When adding more data records (rows): 1. Insert new rows above the final row, so that the formulas on top include all data records. 2. Copy formulas for weekly payments (if any) down to the new rows.
Employee Data
Wages
Start Period
Termination Period
3.0
7.0
$6,307.50
$6,307.50
$6,607.50
$6,607.50
1
2
3
4
4/5/2009
4/12/2009
4/19/2009
4/26/2009
$300.00
$300.00
$300.00
$300.00
$0.00
$0.00
$300.00
$300.00
$262.50
$262.50
$262.50
$262.50
$380.00
$380.00
$380.00
$380.00
$455.00
$455.00
$455.00
$455.00
$560.00
$560.00
$560.00
$560.00
$280.00
$280.00
$280.00
$280.00
$300.00
$300.00
$300.00
$300.00
$420.00
$420.00
$420.00
$420.00
$750.00
$750.00
$750.00
$750.00
$1,200.00
$1,200.00
$1,200.00
$1,200.00
$720.00
$720.00
$720.00
$720.00
$680.00
$680.00
$680.00
$680.00
Accrued Earnings $6,607.50
$6,607.50
$5,857.50
$5,857.50
$5,857.50
$5,857.50
5
6
7
8
9
10
5/3/2009
5/10/2009
5/17/2009
5/24/2009
5/31/2009
6/7/2009
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$262.50
$262.50
$262.50
$262.50
$262.50
$262.50
$380.00
$380.00
$380.00
$380.00
$380.00
$380.00
$455.00
$455.00
$455.00
$455.00
$455.00
$455.00
$560.00
$560.00
$560.00
$560.00
$560.00
$560.00
$280.00
$280.00
$280.00
$280.00
$280.00
$280.00
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$420.00
$420.00
$420.00
$420.00
$420.00
$420.00
$750.00
$750.00
$0.00
$0.00
$0.00
$0.00
$1,200.00
$1,200.00
$1,200.00
$1,200.00
$1,200.00
$1,200.00
$720.00
$720.00
$720.00
$720.00
$720.00
$720.00
$680.00
$680.00
$680.00
$680.00
$680.00
$680.00
$5,857.50
$5,857.50
$5,857.50
11
12
13
6/14/2009
6/21/2009
6/28/2009
$300.00
$300.00
$300.00
$300.00
$300.00
$300.00
$262.50
$262.50
$262.50
$380.00
$380.00
$380.00
$455.00
$455.00
$455.00
$560.00
$560.00
$560.00
$280.00
$280.00
$280.00
$300.00
$300.00
$300.00
$420.00
$420.00
$420.00
$0.00
$0.00
$0.00
$1,200.00
$1,200.00
$1,200.00
$720.00
$720.00
$720.00
$680.00
$680.00
$680.00
Current Date
ABC Corp. Salaried Employee Data
4/5/2009
Color code: This color background (dark blue on my PC) indicates input data Totals
Employee First Name
Employee Last Name
Employee ID #
$950,000.00
$36,440.35
Annual Salaries
Biweekly Salary
Donald
Bergen
10001
$175,000.00
$6,712.70
Amber
Bourgeois
10002
$120,000.00
$4,602.99
Robert
Browne
10003
$75,000.00
$2,876.87
Albert
McConnell
10004
$80,000.00
$3,068.66
Irene
Ruggles
10005
$60,000.00
$2,301.50
Daniel
Rainwater
10006
$35,000.00
$1,342.54
Michael
Valentin
10007
$35,000.00
$1,342.54
Christina
Mcelhaney
10008
$30,000.00
$1,150.75
Hilda
Joy
10009
$50,000.00
$1,917.91
Candace
Boutte
10010
$80,000.00
$3,068.66
Juana
Bond
10011
$75,000.00
$2,876.87
Jacqueline
Brummett
10012
$75,000.00
$2,876.87
George
Baugher
10013
$60,000.00
$2,301.50
When adding more data records (rows): 1. Insert new rows above the final row, so that the formulas on top include all data records. 2. Copy formulas for weekly payments down to the new rows.
Start Period
4.0
Accrued Earnings Wages
$16,685.85
Termination Period
4.0
$16,685.85
$16,685.85
$17,548.91
$17,548.91
1
2
3
4
5
4/5/2009
4/12/2009
4/19/2009
4/26/2009
5/3/2009
$3,356.35
$3,356.35
$3,356.35
$3,356.35
$3,356.35
$2,301.50
$2,301.50
$2,301.50
$2,301.50
$2,301.50
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$671.27
$671.27
$671.27
$671.27
$671.27
$671.27
$671.27
$671.27
$0.00
$0.00
$575.37
$575.37
$575.37
$575.37
$575.37
$958.96
$958.96
$958.96
$958.96
$958.96
$0.00
$0.00
$0.00
$1,534.33
$1,534.33
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$17,548.91
$17,548.91
$17,548.91
$17,548.91
$17,548.91
$17,548.91
6
7
8
9
10
11
5/10/2009
5/17/2009
5/24/2009
5/31/2009
6/7/2009
6/14/2009
$3,356.35
$3,356.35
$3,356.35
$3,356.35
$3,356.35
$3,356.35
$2,301.50
$2,301.50
$2,301.50
$2,301.50
$2,301.50
$2,301.50
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$671.27
$671.27
$671.27
$671.27
$671.27
$671.27
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$575.37
$575.37
$575.37
$575.37
$575.37
$575.37
$958.96
$958.96
$958.96
$958.96
$958.96
$958.96
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,534.33
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$1,150.75
$17,548.91
$17,548.91
12
13
6/21/2009
6/28/2009
$3,356.35
$3,356.35
$2,301.50
$2,301.50
$1,438.43
$1,438.43
$1,534.33
$1,534.33
$1,150.75
$1,150.75
$671.27
$671.27
$0.00
$0.00
$575.37
$575.37
$958.96
$958.96
$1,534.33
$1,534.33
$1,438.43
$1,438.43
$1,438.43
$1,438.43
$1,150.75
$1,150.75
Related Documents
13 Week Cash Flow Analysis
April 2020 8
Cash Flow Analysis Fy09
May 2020 20
Cash Flow Analysis (mba)
May 2020 8
13-cash Flow Statement
June 2020 9
Cash Flow Analysis - Final
May 2020 8