ModelSheet is a trademark of ModelSheet Software, LLC page 1 of 45

Application: 13-Week Cash Flow Model

About ModelSheet

Acknowledgements

Description of the application

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 hard-to-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.comor contact us at info@modelsheetsoft.com.

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.comor contact her at mjmagett@restructuringsolutions.com.

ModelSheet is a trademark of ModelSheet Software, LLC page 2 of 45

Application: 13-Week Cash Flow Model

The basic model includes these features.

As you explore the model, we suggest that you

This model serves as the basis for more advanced cash flow models that include the following additional features.

• Department cost centers, and business unit profit centers. Contact ModelSheet Software, LLC for access to these models.

Suggestions for using this model

To obtain a trial account for ModelSheet, go the the ModelSheet website below and request a trial account.

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.

• 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.

• 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.

• 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.

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.

ModelSheet is a trademark of ModelSheet Software, LLC page 3 of 45

Application: 13-Week Cash Flow Model

This Excel workbook was generated by ModelSheet on March 20, 2009, except for this worksheet of comments.

Copyright © 2009 ModelSheet Software, LLCModelSheet and the ModelSheet logo are registered trademarks of ModelSheet Software, LLC.

WE 4

/11/2

009

WE 4

/18/2

009

WE 4

/25/2

009

WE 5

/2/2

009

WE 5

/9/2

009

WE 5

/16/2

009

WE 5

/23/2

009

WE 5

/30/2

009

WE 6

/6/2

009

WE 6

/13/2

009

WE 6

/20/2

009

WE 6

/27/2

009

WE 7

/4/2

009

($100,000)

$0

$100,000

$200,000

$300,000

$400,000

$500,000

$600,000

Ending Cash

Ending Cash

1 2 3 4 5 6 7 8 9 10 11 12 13

$0

$100,000

$200,000

$300,000

$400,000

$500,000

$600,000

Receipts

Total Receipts

Trade Receivables

1 2 3 4 5 6 7 8 9 10 11 12 13

$0

$100,000

$200,000

$300,000

$400,000

$500,000

$600,000

Receipts

Total Receipts

Trade Receivables

WE 4

/11/2

009

WE 4

/18/2

009

WE 4

/25/2

009

WE 5

/2/2

009

WE 5

/9/2

009

WE 5

/16/2

009

WE 5

/23/2

009

WE 5

/30/2

009

WE 6

/6/2

009

WE 6

/13/2

009

WE 6

/20/2

009

WE 6

/27/2

009

WE 7

/4/2

009

$0

$5,000

$10,000

$15,000

$20,000

$25,000

$30,000

$35,000

Disbursements

Production

Employees

Facilities

Company Name ABC Corp.

Preparer Name Corporate Restucturing Solutions, Inc.

CashInitial Cash $15,000.00

WE 4/11/2009 WE 4/18/2009

Receipts

A/R - Trade $92,464.00 $7,632.00

A/R Line of Credit $0.00 $465.00

DIP Financing $10.00 $12.00

Other $0.00 $0.00

Total $92,474.00 $8,109.00

ExpensesProduction Disbursements

Raw Material $3,225.00 $222.00

Capital Expenditures $0.00 $0.00

Tooling $2,554.00 $0.00

Total $5,779.00 $222.00

Bankruptcy $0.00 $200.00

Interest Expense $62.00 $0.00

Other Expense $11.00 $11.00

Travel & Entertainment $0.00 $0.00

LaborWE 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 - BasicPrepared 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%

ABC Corp.13-Week Cash Flow - BasicPrepared by Corporate Restucturing Solutions, Inc.Inputs

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 WE 4/18/2009 WE 4/25/2009 Apr 2009 WE 5/2/2009

Week 1 2 3 3 4

Beginning Cash Balance $15,000.00 $72,880.32 $51,814.64 $15,000.00 $24,863.95

Receipts

A/R - Trade $92,464.00 $7,632.00 $8,320.00 $108,416.00 $3,552.00

A/R Line of Credit $0.00 $465.00 $0.00 $465.00 $0.00

DIP Financing $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

Disbursements

Production

Raw Material $3,225.00 $222.00 $520.00 $3,967.00 $2,776.00

Capital Expenditures $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

Employee

Hourly Payroll $6,307.50 $6,307.50 $6,607.50 $19,222.50 $6,607.50

Salaried Payroll $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

Travel & Entertainment $0.00 $0.00 $0.00 $0.00 $0.00

Subtotal $28,741.68 $28,741.68 $29,116.68 $86,600.05 $30,195.51

Facility

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

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 - BasicPrepared by Corporate Restucturing Solutions, Inc.Cash Flow

WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 May 2009 WE 6/6/2009 WE 6/13/2009

5 6 7 8 8 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 Jun 2009 WE 7/4/2009 Jul 2009 Total

11 12 12 13 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

$0.00 $0.00 $0.00 $0.00 $0.00 $207.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 - BasicPrepared 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

ABC Corp.13-Week Cash Flow - BasicPrepared by Corporate Restucturing Solutions, Inc.Formulas

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:

ABC Corp.13-Week Cash Flow - BasicPrepared by Corporate Restucturing Solutions, Inc.Formulas

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_Benefits_pct

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_Payroll_Tax_pct

Travel_Entertainment

preve(0)+1

preve(0)

ABC Corp.13-Week Cash Flow - BasicPrepared by Corporate Restucturing Solutions, Inc.Formulas

Receipts_1

WE 4/11/2009 WE 4/18/2009 WE 4/25/2009 Apr 2009 WE 5/2/2009

4/5/2009 4/12/2009 4/19/2009 4/1/2009 4/26/2009

Receipts_2

WE 4/11/2009 WE 4/18/2009 WE 4/25/2009 Apr 2009 WE 5/2/2009

WE 4/11/2009 WE 4/18/2009 WE 4/25/2009 WE 4/4/2009 WE 5/2/2009

Cash_Ending_1

WE 4/11/2009 WE 4/18/2009 WE 4/25/2009 Apr 2009 WE 5/2/2009

4/5/2009 4/12/2009 4/19/2009 4/1/2009 4/26/2009

Cash_Ending_2

WE 4/11/2009 WE 4/18/2009 WE 4/25/2009 Apr 2009 WE 5/2/2009

WE 4/11/2009 WE 4/18/2009 WE 4/25/2009 WE 4/4/2009 WE 5/2/2009

Disbursements_1

WE 4/11/2009 WE 4/18/2009 WE 4/25/2009 Apr 2009 WE 5/2/2009

4/5/2009 4/12/2009 4/19/2009 4/1/2009 4/26/2009

Disbursements_2

WE 4/11/2009 WE 4/18/2009 WE 4/25/2009 Apr 2009 WE 5/2/2009

WE 4/11/2009 WE 4/18/2009 WE 4/25/2009 WE 4/4/2009 WE 5/2/2009

ABC Corp.13-Week Cash Flow - BasicPrepared by Corporate Restucturing Solutions, Inc.Default Shadow

WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 May 2009 WE 6/6/2009 WE 6/13/2009

5/3/2009 5/10/2009 5/17/2009 5/24/2009 5/1/2009 5/31/2009 6/7/2009

WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 May 2009 WE 6/6/2009 WE 6/13/2009

WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 WE 5/2/2009 WE 6/6/2009 WE 6/13/2009

WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 May 2009 WE 6/6/2009 WE 6/13/2009

5/3/2009 5/10/2009 5/17/2009 5/24/2009 5/1/2009 5/31/2009 6/7/2009

WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 May 2009 WE 6/6/2009 WE 6/13/2009

WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 WE 5/2/2009 WE 6/6/2009 WE 6/13/2009

WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 May 2009 WE 6/6/2009 WE 6/13/2009

5/3/2009 5/10/2009 5/17/2009 5/24/2009 5/1/2009 5/31/2009 6/7/2009

WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 May 2009 WE 6/6/2009 WE 6/13/2009

WE 5/9/2009 WE 5/16/2009 WE 5/23/2009 WE 5/30/2009 WE 5/2/2009 WE 6/6/2009 WE 6/13/2009

WE 6/20/2009 WE 6/27/2009 Jun 2009 WE 7/4/2009 Jul 2009

6/14/2009 6/21/2009 6/1/2009 6/28/2009 7/1/2009

WE 6/20/2009 WE 6/27/2009 Jun 2009 WE 7/4/2009 Jul 2009

WE 6/20/2009 WE 6/27/2009 WE 6/6/2009 WE 7/4/2009 WE 7/4/2009

WE 6/20/2009 WE 6/27/2009 Jun 2009 WE 7/4/2009 Jul 2009

6/14/2009 6/21/2009 6/1/2009 6/28/2009 7/1/2009

WE 6/20/2009 WE 6/27/2009 Jun 2009 WE 7/4/2009 Jul 2009

WE 6/20/2009 WE 6/27/2009 WE 6/6/2009 WE 7/4/2009 WE 7/4/2009

WE 6/20/2009 WE 6/27/2009 Jun 2009 WE 7/4/2009 Jul 2009

6/14/2009 6/21/2009 6/1/2009 6/28/2009 7/1/2009

WE 6/20/2009 WE 6/27/2009 Jun 2009 WE 7/4/2009 Jul 2009

WE 6/20/2009 WE 6/27/2009 WE 6/6/2009 WE 7/4/2009 WE 7/4/2009

ABC Corp.13-Week Cash Flow - BasicPrepared 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 - BasicPrepared 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 Databases

Salaried Salaried

Disbursements Disbursements Total Disbursements

Production Production Subtotal Disbursements

Raw_Material Raw Material Disbursements 2

Capital_Expenditures Capital Expenditures

Tooling Tooling

Employee Employee Subtotal

Hourly_Payroll Hourly Payroll

Salaried_Payroll Salaried Payroll

Payroll_Taxes Payroll Taxes

Benefits Benefits

Travel___Entertainment Travel & Entertainment

Facility Facility Subtotal

Rent Rent

Utilities Utilities

Bankruptcy Bankruptcy

Interest Interest

Other Other

Payroll_Cash Payroll Cash Total Payroll_Cash

Hourly_Payroll Hourly Payroll Employee_Exp

Salaried_Payroll Salaried Payroll

Production_Cash Production Cash Total Production_Cash

Raw_Material Raw Material Production_Exp

Capital_Expenditures Capital Expenditures

Tooling Tooling

Receipts Receipts Total Collections

A_R___Trade A/R - Trade Collections

A_R_Line_of_Credit A/R Line of Credit

DIP_Financing DIP Financing

Other Other

ABC Corp.13-Week Cash Flow - BasicPrepared by Corporate Restucturing Solutions, Inc.Labels

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

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

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.

Cash flow from collections, for eah 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

Payroll expenses for hourly and salaried employees. Payroll benefits and taxes are computed elsewhere in the model. This variable holds input data.

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

Production expenses on a cash basis, including raw material, capital expenditures and tooling. This variable holds input data.

Cash cost of benefits for salaried employees as a percentage of salary disbursements, by salaried employee, by time period

A list of types of payroll cash expense (excluding benefits and taxes)

A list of the receivables accounts

A list of types of production cash expenses, including material, capital expenditures and tooling

ZZZ_Range 92464 7632 8320 3552 0 500048 0 44416ZZZ_Ranges 0 465 0 0 0 0 745 0ZZZ_Range 10 12 0 0 0 15 0 0ZZZ_Range 0 0 0 0 0 0 0 0ZZZ_Range 92474 8109 8320 3552 0 500063 745 44416ZZZ_RangeWE 4/11/2 WE 4/18/2 WE 4/25/2 WE 5/2/20 WE 5/9/20 WE 5/16/2 WE 5/23/2 WE 5/30/2ZZZ_Range 39908 39915 39922 39929 39936 39943 39950 39957ZZZ_Range72880.32 51814.64 24863.95 -4646.555 -37483.06 406400.4 377698.4 392696.4ZZZ_RangeWE 4/11/2 WE 4/18/2 WE 4/25/2 WE 5/2/20 WE 5/9/20 WE 5/16/2 WE 5/23/2 WE 5/30/2ZZZ_Range 39908 39915 39922 39929 39936 39943 39950 39957ZZZ_Range 3225 222 520 2776 0 254 0 0ZZZ_Ranges 0 0 0 0 0 25554 0 0ZZZ_Ranges 2554 0 5445 0 2554 0 0 0ZZZ_Range 5779 222 5965 2776 2554 25808 0 0ZZZ_Range 6307.5 6307.5 6607.5 6607.5 6607.5 6607.5 5857.5 5857.5ZZZ_Range16685.85 16685.85 16685.85 17548.91 17548.91 17548.91 17548.91 17548.91ZZZ_Range3449.002 3449.002 3494.002 3623.461 3623.461 3623.461 3510.961 3510.961ZZZ_Range2299.335 2299.335 2329.335 2415.641 2415.641 2415.641 2340.641 2340.641ZZZ_Range 0 0 0 0 0 0 0 0ZZZ_Range28741.68 28741.68 29116.68 30195.51 30195.51 30195.51 29258.01 29258.01ZZZ_Ranges 0 0 0 0 0 0 0 0ZZZ_Ranges 0 0 0 0 0 0 0 0ZZZ_Ranges 0 0 0 0 0 0 0 0ZZZ_Range 0 200 178 80 0 165 178 80ZZZ_Ranges 62 0 0 0 76 0 0 69ZZZ_Range 11 11 11 11 11 11 11 11ZZZ_Range34593.68 29174.68 35270.68 33062.51 32836.51 56179.51 29447.01 29418.01ZZZ_RangeWE 4/11/2 WE 4/18/2 WE 4/25/2 WE 5/2/20 WE 5/9/20 WE 5/16/2 WE 5/23/2 WE 5/30/2ZZZ_Range 39908 39915 39922 39929 39936 39943 39950 39957

12320 168848 2000 0 516000 0 1012 0 00 17 0 0 00 0 0 0 0

12320 168865 3012 0 51600WE 6/6/20 WE 6/13/2 WE 6/20/2 WE 6/27/2 WE 7/4/2009

39964 39971 39978 39985 39992375199.4 509350.4 483013.4 453566.4 472592.4

WE 6/6/20 WE 6/13/2 WE 6/20/2 WE 6/27/2 WE 7/4/200939964 39971 39978 39985 39992

548 5445 0 0 32250 0 0 0 00 0 0 0 0

548 5445 0 0 32255857.5 5857.5 5857.5 5857.5 5857.5

17548.91 17548.91 17548.91 17548.91 17548.913510.961 3510.961 3510.961 3510.961 3510.9612340.641 2340.641 2340.641 2340.641 2340.641

0 0 0 0 029258.01 29258.01 29258.01 29258.01 29258.01

0 0 0 0 00 0 0 0 00 0 0 0 00 0 80 178 800 0 0 0 0

11 11 11 11 1129817.01 34714.01 29349.01 29447.01 32574.01

WE 6/6/20 WE 6/13/2 WE 6/20/2 WE 6/27/2 WE 7/4/200939964 39971 39978 39985 39992

Company_NABC Corp. Preparer_NCorporate RCash_Initial 15000 Receipts[" 92464 Receipts["Receipts[" 0 Receipts[" 0 Receipts[" 15 Receipts[" 0 Receipts["Production 5445 Production 0 Production 0 Production 3225 ProductionExpense_Ba 178 Expense_Ba 80 Expense_Ba 0 Expense_Ba 165 Expense_BaExpense_Ot 11 Expense_Ot 11 Expense_Ot 11 Expense_Ot 11 Expense_OtCash_Payro16685.85 Cash_Payro16685.85 Cash_Payro17548.91 Cash_Payro17548.91 Cash_Payro:A:0:Disbu Disbursem :A:-1:Disb Cash flow f:A:0:ReceipReceipts :A:-1:ReceiCash flow f:A:0:Cash_:A:0:Produ Production :A:-1:Prod Production :A:0:Cash_Cash Payro:A:-1:Cash Payroll exp:A:0:Prepa:D:0:Disbu Bankruptcy:D:0:DisburInterest :D:0:Disbu Other :D:-1:ReceiA list of t :D:0:Recei:D:2:Datab Databases :D:0:Datab Salaried:WS:Outpu 0 :WS: 0 :WS: 0 :WS: ABC Corp. :WS:

7632 Receipts[" 8320 Receipts[" 3552 Receipts[" 0 Receipts[" 5000480 Receipts[" 0 Receipts[" 17 Receipts[" 0 Receipts[" 00 Production 0 Production 0 Production 0 Production 0

178 Expense_Ba 80 Expense_Ba 0 Expense_Ba 0 Expense_Ba 8011 Travel_Ent 0 Travel_Ent 0 Travel_Ent 0 Travel_Ent 0

17548.91 Cash_Payro17548.91 Cash_Payro17548.91 Cash_Payro17548.91 Cash_Payro17548.91Beginning :A:-1:Cash Cash balanc:A:0:Cash_IInitial Cash:A:-1:Cash_Initial cash :A:0:Cash_Cash SourcPreparer :A:-1:Prep Name of the:A:0:Datab Database S:A:-1:Data 0 :A:0:Datab Database OReceipts :D:2:Recei Collections :D:1:Recei Total :D:0:Recei A/R - Trad :D:2:Recei Collections

0 :WS: ABC Corp. :WS: ABC Corp. :WS:EmploCurrent Da :WS:EmploCurrent Da

Receipts[" 0 Receipts[" 44416 Receipts[" 12320 Receipts[" 168848 Receipts["Receipts[" 0 Receipts[" 0 Receipts[" 0 Receipts[" 0 Receipts["Production 25554 Production 0 Production 0 Production 0 ProductionExpense_Ba 178 Expense_Ba 80 Interest_E 62 Interest_E 0 Interest_ETravel_Ent 0 Travel_Ent 0 Travel_Ent 0 Travel_Ent 0 Travel_EntCash_Payro17548.91 Cash_Payro17548.91 Cash_Payro17548.91 Hourly_Payr 0.15 Hourly_Bene:A:-1:Cash Net cash fl :A:0:Cash_Ending Ca :A:-1:Cash Cash balanc:A:0:Time Week :A:-1:Tim:A:-1:Data 0 :D:-1:Disb A list of t :D:0:Disbu Disbursem :D:2:Disbu Disbursem :D:1:Disbu:D:0:Recei A/R Line of:D:0:Recei DIP Financ:D:0:Recei Other :D:-1:Prod A list of t :D:0:Produ

:WS: ZZZ_Range:WS: Company_Name[]|

2000 Receipts[" 0 Receipts[" 51600 Receipts[" 0 Receipts[" 4650 Receipts[" 0 Receipts[" 0 Receipts[" 0 Receipts[" 00 Production 0 Production 0 Production 0 Production 25540 Interest_E 0 Interest_E 76 Interest_E 0 Interest_E 00 Travel_Ent 0 Travel_Ent 0 Travel_Ent 0 Travel_Ent 0

0.1 Salary_Payr 0.15 Salary_Bene 0.1Time in wee:A:0:SalarySalaried Be:A:-1:Salar Cash cost o:A:0:Hourl Hourly Pay :A:-1:Hour Cash cost oTotal :D:0:Disbu Production :D:2:Disbu Disbursem :D:1:Disbu Subtotal :D:0:Disbu Raw MateriProduction :D:2:Produ Production :D:1:Produ Total :D:0:Produ Raw Materi:D:2:Produ Production

Receipts[" 0 Receipts[" 0 Receipts[" 0 Receipts[" 0 Receipts["Receipts[" 0 Receipts[" 0 Receipts[" 0 Receipts[" 0 Receipts["Production 0 Production 5445 Production 0 Production 2554 ProductionInterest_E 69 Interest_E 0 Interest_E 0 Interest_E 0 Interest_ECash_Payro 6307.5 Cash_Payro 6307.5 Cash_Payro 6607.5 Cash_Payro 6607.5 Cash_Payro

:A:0:HourlyHourly Ben:A:-1:Hourl Cash cost o:A:0:Salar Salaried Pa:A:-1:Sala Cash cost o:A:0:Trave:D:2:Disbu Disburseme:D:0:Disbu Capital Ex :D:0:Disbu Tooling :D:0:Disbu Employee :D:1:Disbu:D:0:Produ Capital Ex :D:0:Produ Tooling :D:-1:Payr A list of t :D:0:Payro Payroll Ca :D:2:Payro

745 Receipts[" 0 Receipts[" 0 Receipts[" 0 Receipts[" 10120 Production 3225 Production 222 Production 520 Production 27760 Production 0 Production 0 Production 0 Production 00 Interest_E 0 Expense_Ot 11 Expense_Ot 11 Expense_Ot 11

6607.5 Cash_Payro 6607.5 Cash_Payro 5857.5 Cash_Payro 5857.5 Cash_Payro 5857.5

Travel & E :A:-1:TraveTravel and :A:0:ExpenBankruptcy:A:-1:Expe Expenses in:A:0:Inter Interest ESubtotal :D:0:Disbu Hourly Payr:D:0:Disbu Salaried Pa:D:0:Disbu Payroll Ta :D:0:Disbu BenefitsPayroll_Ca :D:1:Payro Total :D:0:Payro Hourly Payr:D:2:Payro Employee_:D:0:PayrolSalaried Pa

Receipts[" 0 Receipts[" 0 Receipts[" 10 Receipts[" 12 Receipts["Production 0 Production 254 Production 0 Production 0 ProductionProduction 0 Production 0 Production 0 Expense_Ba 0 Expense_BaExpense_Ot 11 Expense_Ot 11 Expense_Ot 11 Expense_Ot 11 Expense_OtCash_Payro 5857.5 Cash_Payro 5857.5 Cash_Payro 5857.5 Cash_Payro 5857.5 Cash_Payro

:A:-1:Inte Interest e :A:0:ExpenOther Exp :A:-1:Expe :A:0:Comp Company :A:-1:Com:D:0:Disbu Travel & E :D:0:DisburFacility :D:1:DisburSubtotal :D:0:DisburRent :D:0:Disbur:D:-1:Data 0 :D:0:Datab Databases :D:2:Datab Databases :D:1:Datab Total :D:0:Datab

Miscellaneous cash expenses not counted elswhere in the cash flow analysis

0548200

1116685.85

Name of the company whose cash flow is being modeledUtilitiesHourly

Current Date 4/5/2009 ABC Corp.Hourly Employee Data

Color code: This color background (dark blue on my PC) indicates input data

Totals $207.25 $820.00 $13,215.00

Hourly Rate

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.

EmployeeFirst Name

EmployeeLast Name

EmployeeID #

Standard Biweekly

Hours

Standard Biweekly Wage

Hourly Employee Data

Accrued Earnings

Wages $6,307.50 $6,307.50 $6,607.50 $6,607.50

1 2 3 4

Start Period 4/5/2009 4/12/2009 4/19/2009 4/26/2009

$300.00 $300.00 $300.00 $300.00

3.0 $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

7.0 $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

Termination Period

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 4/5/2009 ABC Corp.Salaried Employee Data

Color code: This color background (dark blue on my PC) indicates input data

Totals $950,000.00 $36,440.35

Annual Salaries Biweekly Salary Start Period

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 4.0

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.

EmployeeFirst Name

EmployeeLast Name

EmployeeID #

Accrued Earnings

Wages $16,685.85 $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

4.0 $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

Termination Period

Accrued Earnings

$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