excel financials model 2012 072

7/28/2019 Excel Financials Model 2012 072

1/201

Enter Period End Date Here 6/30/12 41090

This is a financial statement reporting model for a hypothetical company

populated with fictitious trial balance data from January 2011 through June 2012.

This model demonstrates the potential with combining tools such as Pivot Tables,

Vlookup Formulas, Getpivot Formulas, Date Formulas, Named Ranges and Cross

References, in Excel.

You are welcome to make use of this model without charge.

If you are interested in learning more about these tools just drop me a line..

[email protected]

The Lau
mailto:[email protected]?subject=From%20the%20Excel%20Financial%20Statement%20Set%20of%202012-07mailto:[email protected]?subject=From%20the%20Excel%20Financial%20Statement%20Set%20of%202012-07mailto:[email protected]?subject=From%20the%20Excel%20Financial%20Statement%20Set%20of%202012-07mailto:[email protected]?subject=From%20the%20Excel%20Financial%20Statement%20Set%20of%202012-07mailto:[email protected]?subject=From%20the%20Excel%20Financial%20Statement%20Set%20of%202012-07mailto:[email protected]?subject=From%20the%20Excel%20Financial%20Statement%20Set%20of%202012-07mailto:[email protected]?subject=From%20the%20Excel%20Financial%20Statement%20Set%20of%202012-07mailto:[email protected]?subject=From%20the%20Excel%20Financial%20Statement%20Set%20of%202012-07mailto:[email protected]?subject=From%20the%20Excel%20Financial%20Statement%20Set%20of%202012-07


2/201

rel Wreath Symbolizes "Champion"


3/201


4/201

PJ Thomas Academic

YTD Trailing 12 Mo 6/30/12 5/31/12 4/30/12 3/31/12

Sales 12,000,000 24,000,000 2,000,000 2,000,000 2,000,000 2,000,000

Material Costs 8,400,000 16,800,000 1,150,000 1,650,000 1,150,000 1,650,000

Gross Product Margin 3,600,000 7,200,000 850,000 350,000 850,000 350,000

Other Cost of Sales 874,800 1,749,600 145,800 145,800 145,800 145,800

Gross Profit 2,725,200 5,450,400 704,200 204,200 704,200 204,200

General and Administrative 181,200 362,400 30,200 30,200 30,200 30,200

Income From Operations 2,544,000 5,088,000 674,000 174,000 674,000 174,000

Interest 42,000 84,000 7,000 7,000 7,000 7,000

Net Income Before Tax 2,502,000 5,004,000 667,000 167,000 667,000 167,000

Income Tax Provision 875,700 1,751,400 233,450 58,450 233,450 58,450

Net Income After Tax 1,626,300 3,252,600 433,550 108,550 433,550 108,550

EBITDA 2,616,000 5,232,000 686,000 186,000 686,000 186,000

Other Cost of Sales

Labor 480,000 960,000 80,000 80,000 80,000 80,000

Freight 108,300 216,600 18,050 18,050 18,050 18,050

Maintenance 132,000 264,000 22,000 22,000 22,000 22,000

Occupancy 52,500 105,000 8,750 8,750 8,750 8,750

Depreciation 72,000 144,000 12,000 12,000 12,000 12,000

Insurance 30,000 60,000 5,000 5,000 5,000 5,000

Total 874,800 1,749,600 145,800 145,800 145,800 145,800

Sales, General and Administrative

Labor 90,000 180,000 15,000 15,000 15,000 15,000

Professional 42,000 84,000 7,000 7,000 7,000 7,000

Occupancy 22,200 44,400 3,700 3,700 3,700 3,700

Insurance 24,000 48,000 4,000 4,000 4,000 4,000

Other 3,000 6,000 500 500 500 500

Total 181,200 362,400 30,200 30,200 30,200 30,200


5/201

PJ Thomas Academic

YTD 2012 6/30/12 5/31/12 4/30/12 3/31/12 2/29/12 1/31/12

Cash Flow From Operating Activities:

Net Income 1,626,300 433,550 108,550 433,550 108,550 433,550 108,550

Adjustments:

Depreciation 72,000 12,000 12,000 12,000 12,000 12,000 12,000

Changes in Working Capital

Accounts receivable, net (171,000) (206,000) 16,000 (4,000) (9,000) 26,000 6,000

Inventory (450,000) (250,000) 250,000 (250,000) 250,000 (485,000) 35,000

Prepaid expenses and other current assets 2,000 5,000 5,000 7,000 5,000 5,000 (25,000)

Accounts payable - - - - - - -

Taxes payable - 233,450 58,450 (116,900) 58,450 233,450 (466,900)

Accrued expenses - - - - - - -

Accrued interest - 7,000 7,000 (14,000) 7,000 7,000 (14,000)

Other liabilities - - - - - - -

Net cash provided (used) by operating activities 1,079,300 235,000 457,000 67,650 432,000 232,000 (344,350)

Cash Flow From Investing Activities:Purchase of PP&E (655,000) (85,000) (301,000) (75,000) (75,000) (80,000) (39,000)

Net cash provided (used) by investing activities (655,000) (85,000) (301,000) (75,000) (75,000) (80,000) (39,000)

Cash Flow From Financing Activities:

Proceeds from Long Term Debt - - - - - - -

Repayments of Long Term Debt (200,000) - - - (200,000) - -

Proceeds from Credit Line - - - - - - -

Repayments of Credit Line (43,000) - (6,000) (9,000) (10,000) (5,000) (13,000)

Net cash provided (used) by financing activities (243,000) - (6,000) (9,000) (210,000) (5,000) (13,000)

Net increase (decrease) in cash and cash equivalents 181,300 150,000 150,000 (16,350) 147,000 147,000 (396,350)

Cash and cash equivalents, beginning of period 610,450 641,750 491,750 508,100 361,100 214,100 610,450

Cash and cash equivalents, end of period 791,750 791,750 641,750 491,750 508,100 361,100 214,100


6/201

Statement BS

Sum of Ending Balance Column Labels

Row Labels Opening Balance 1/31/2011 2/28/2011 3/31/2011

Accounts Payable -300,000.00 -310,000.00 -313,000.00 -328,000.00

Accounts Receivable 1,805,000.00 1,814,000.00 1,773,000.00 1,732,000.00

Accrued Expenses -90,000.00 -90,000.00 -90,000.00 -90,000.00Accrued Interest -15,000.00 -22,000.00 -29,000.00 -36,000.00

Accum Depreciation -2,000,000.00 -2,012,000.00 -2,024,000.00 -2,036,000.00

Cash 300,000.00 447,000.00 597,000.00 744,000.00

Credit Line -500,000.00 -350,000.00 -200,000.00 -35,000.00

Curr Portion LTD -200,000.00 -200,000.00 -200,000.00 -200,000.00

Intangible Assets 0.00 0.00 0.00 0.00

Inventory 2,000,000.00 1,750,000.00 2,000,000.00 1,750,000.00

Long Term Debt -2,000,000.00 -2,000,000.00 -2,000,000.00 -1,800,000.00

LTD Curr Contra 200,000.00 200,000.00 200,000.00 200,000.00

Other Assets 1,000.00 1,000.00 1,000.00 1,000.00

Other Payables 0.00 0.00 0.00 0.00

Owner's Contributed Capital -200,000.00 -200,000.00 -200,000.00 -200,000.00

PP&E 4,917,000.00 5,212,000.00 5,544,000.00 5,671,000.00

Prepaid Assets 120,000.00 115,000.00 113,000.00 116,000.00

Retained Earnings -4,022,000.00 -4,022,000.00 -4,022,000.00 -4,022,000.00

Taxes Payable -16,000.00 -126,950.00 -412,900.00 -523,850.00

Grand Total 0.00 206,050.00 737,100.00 943,150.00

Statement IS

Sum of Period Net Column Labels


General and Administrative 30,200.00 30,200.00 30,200.00

Material Costs 1,500,000.00 1,000,000.00 1,500,000.00

Other Cost of Sales 145,800.00 145,800.00 145,800.00

Sales -2,000,000.00 -2,000,000.00 -2,000,000.00

Interest 7,000.00 7,000.00 7,000.00

Tax Provision 110,950.00 285,950.00 110,950.00


7/201

Grand Total -206,050.00 -531,050.00 -206,050.00

Statement IS



Depreciation 12,000.00 12,000.00 12,000.00

Freight 18,050.00 18,050.00 18,050.00

Insurance 5,000.00 5,000.00 5,000.00

Labor 80,000.00 80,000.00 80,000.00

Maintenance 22,000.00 22,000.00 22,000.00

Occupancy 8,750.00 8,750.00 8,750.00

Grand Total 145,800.00 145,800.00 145,800.00

Statement IS



Insurance 4,000.00 4,000.00 4,000.00

Labor 15,000.00 15,000.00 15,000.00

Occupancy 3,700.00 3,700.00 3,700.00

Other 500.00 500.00 500.00

Professional 7,000.00 7,000.00 7,000.00

Grand Total 30,200.00 30,200.00 30,200.00


8/201

Statement BS


Row Labels Opening Balance 1/31/2011 2/28/2011 3/31/2011Accounts Payable -10,000.00 -3,000.00 -15,000.00

Accounts Receivable 9,000.00 -41,000.00 -41,000.00

Accrued Expenses

Accrued Interest -7,000.00 -7,000.00 -7,000.00

Accum Depreciation -12,000.00 -12,000.00 -12,000.00

Cash 147,000.00 150,000.00 147,000.00

Credit Line 150,000.00 150,000.00 165,000.00

Curr Portion LTD

Intangible Assets

Inventory -250,000.00 250,000.00 -250,000.00

Long Term Debt 200,000.00

LTD Curr Contra

Other Assets

Other Payables

Owner's Contributed Capital

PP&E 295,000.00 332,000.00 127,000.00

Prepaid Assets -5,000.00 -2,000.00 3,000.00

Retained Earnings

Taxes Payable -110,950.00 -285,950.00 -110,950.00

Grand Total 206,050.00 531,050.00 206,050.00


9/201

4/30/2011 5/31/2011 6/30/2011 7/31/2011 8/31/2011 9/30/2011 10/31/2011

-336,000.00 -351,000.00 -359,000.00 -314,000.00 -354,000.00 -354,000.00 -354,000.00

1,721,000.00 1,927,000.00 2,136,000.00 2,142,000.00 2,351,000.00 2,355,000.00 2,339,000.00

-90,000.00 -90,000.00 -90,000.00 -90,000.00 -120,000.00 -120,000.00 -120,000.00-7,000.00 -14,000.00 -21,000.00 -7,000.00 -14,000.00 -21,000.00 -7,000.00

-2,048,000.00 -2,060,000.00 -2,072,000.00 -2,084,000.00 -2,096,000.00 -2,108,000.00 -2,120,000.00

334,150.00 484,150.00 634,150.00 237,800.00 384,800.00 534,800.00 313,450.00

-35,000.00 -35,000.00 -27,000.00 -72,000.00 -95,000.00 -109,000.00 -106,000.00

-200,000.00 -200,000.00 -200,000.00 -200,000.00 -200,000.00 -200,000.00 -200,000.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00

2,000,000.00 1,750,000.00 2,000,000.00 1,750,000.00 2,000,000.00 1,750,000.00 2,000,000.00

-1,800,000.00 -1,800,000.00 -1,800,000.00 -1,800,000.00 -1,800,000.00 -1,800,000.00 -1,800,000.00

200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00

1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00

-200,000.00 -200,000.00 -200,000.00 -200,000.00 -200,000.00 -200,000.00 -200,000.00

5,989,000.00 6,084,000.00 6,164,000.00 6,447,000.00 6,625,000.00 6,926,000.00 7,230,000.00

106,000.00 106,000.00 106,000.00 103,000.00 98,000.00 93,000.00 88,000.00

-4,022,000.00 -4,022,000.00 -4,022,000.00 -4,022,000.00 -4,022,000.00 -4,022,000.00 -4,022,000.00

-234,500.00 -292,950.00 -527,450.00 -60,550.00 -294,000.00 -352,450.00 -235,550.00

1,378,650.00 1,487,200.00 1,922,700.00 2,031,250.00 2,464,800.00 2,573,350.00 3,006,900.00

4/30/2011 5/31/2011 6/30/2011 7/31/2011 8/31/2011 9/30/2011 10/31/2011

30,200.00 30,200.00 30,200.00 30,200.00 30,200.00 30,200.00 30,200.00

1,150,000.00 1,650,000.00 1,150,000.00 1,650,000.00 1,150,000.00 1,650,000.00 1,150,000.00

142,800.00 145,800.00 145,800.00 145,800.00 145,800.00 145,800.00 145,800.00

-2,000,000.00 -2,000,000.00 -2,003,000.00 -2,000,000.00 -2,000,000.00 -2,000,000.00 -2,000,000.00

7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00

234,500.00 58,450.00 234,500.00 58,450.00 233,450.00 58,450.00 233,450.00


10/201

-435,500.00 -108,550.00 -435,500.00 -108,550.00 -433,550.00 -108,550.00 -433,550.00

4/30/2011 5/31/2011 6/30/2011 7/31/2011 8/31/2011 9/30/2011 10/31/2011

12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00

18,050.00 18,050.00 18,050.00 18,050.00 18,050.00 18,050.00 18,050.00

5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00

80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00

19,000.00 22,000.00 22,000.00 22,000.00 22,000.00 22,000.00 22,000.00

8,750.00 8,750.00 8,750.00 8,750.00 8,750.00 8,750.00 8,750.00

142,800.00 145,800.00 145,800.00 145,800.00 145,800.00 145,800.00 145,800.00

4/30/2011 5/31/2011 6/30/2011 7/31/2011 8/31/2011 9/30/2011 10/31/2011

4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00

15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00

3,700.00 3,700.00 3,700.00 3,700.00 3,700.00 3,700.00 3,700.00

500.00 500.00 500.00 500.00 500.00 500.00 500.00

7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00

30,200.00 30,200.00 30,200.00 30,200.00 30,200.00 30,200.00 30,200.00


11/201

4/30/2011 5/31/2011 6/30/2011 7/31/2011 8/31/2011 9/30/2011 10/31/2011-8,000.00 -15,000.00 -8,000.00 45,000.00 -40,000.00

-11,000.00 206,000.00 209,000.00 6,000.00 209,000.00 4,000.00 -16,000.00

-30,000.00

29,000.00 -7,000.00 -7,000.00 14,000.00 -7,000.00 -7,000.00 14,000.00

-12,000.00 -12,000.00 -12,000.00 -12,000.00 -12,000.00 -12,000.00 -12,000.00

-409,850.00 150,000.00 150,000.00 -396,350.00 147,000.00 150,000.00 -221,350.00

8,000.00 -45,000.00 -23,000.00 -14,000.00 3,000.00

250,000.00 -250,000.00 250,000.00 -250,000.00 250,000.00 -250,000.00 250,000.00

318,000.00 95,000.00 80,000.00 283,000.00 178,000.00 301,000.00 304,000.00

-10,000.00 0.00 0.00 -3,000.00 -5,000.00 -5,000.00 -5,000.00

289,350.00 -58,450.00 -234,500.00 466,900.00 -233,450.00 -58,450.00 116,900.00

435,500.00 108,550.00 435,500.00 108,550.00 433,550.00 108,550.00 433,550.00


12/201

11/30/2011 12/31/2011 1/31/2012 2/29/2012 3/31/2012 4/30/2012 5/31/2012

-354,000.00 -354,000.00 -354,000.00 -354,000.00 -354,000.00 -354,000.00 -354,000.00

2,313,000.00 2,522,000.00 2,516,000.00 2,490,000.00 2,499,000.00 2,503,000.00 2,487,000.00

-120,000.00 -120,000.00 -120,000.00 -120,000.00 -120,000.00 -120,000.00 -120,000.00-14,000.00 -21,000.00 -7,000.00 -14,000.00 -21,000.00 -7,000.00 -14,000.00

-2,132,000.00 -2,144,000.00 -2,156,000.00 -2,168,000.00 -2,180,000.00 -2,192,000.00 -2,204,000.00

463,450.00 610,450.00 214,100.00 361,100.00 508,100.00 491,750.00 641,750.00

-121,000.00 -113,000.00 -100,000.00 -95,000.00 -85,000.00 -76,000.00 -70,000.00

-200,000.00 -200,000.00 -200,000.00 -200,000.00 -200,000.00 -200,000.00 -200,000.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00

1,982,000.00 2,232,000.00 2,197,000.00 2,682,000.00 2,432,000.00 2,682,000.00 2,432,000.00

-1,800,000.00 -1,800,000.00 -1,800,000.00 -1,800,000.00 -1,600,000.00 -1,600,000.00 -1,600,000.00

200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00 200,000.00

1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00

0.00 0.00 0.00 0.00 0.00 0.00 0.00

-200,000.00 -200,000.00 -200,000.00 -200,000.00 -200,000.00 -200,000.00 -200,000.00

7,340,000.00 7,417,000.00 7,456,000.00 7,536,000.00 7,611,000.00 7,686,000.00 7,987,000.00

73,000.00 68,000.00 93,000.00 88,000.00 83,000.00 76,000.00 71,000.00

-4,022,000.00 -4,022,000.00 -7,571,000.00 -7,571,000.00 -7,571,000.00 -7,571,000.00 -7,571,000.00

-294,000.00 -527,450.00 -60,550.00 -294,000.00 -352,450.00 -235,550.00 -294,000.00

3,115,450.00 3,549,000.00 108,550.00 542,100.00 650,650.00 1,084,200.00 1,192,750.00

11/30/2011 12/31/2011 1/31/2012 2/29/2012 3/31/2012 4/30/2012 5/31/2012

30,200.00 30,200.00 30,200.00 30,200.00 30,200.00 30,200.00 30,200.00

1,650,000.00 1,150,000.00 1,650,000.00 1,150,000.00 1,650,000.00 1,150,000.00 1,650,000.00

145,800.00 145,800.00 145,800.00 145,800.00 145,800.00 145,800.00 145,800.00

-2,000,000.00 -2,000,000.00 -2,000,000.00 -2,000,000.00 -2,000,000.00 -2,000,000.00 -2,000,000.00

7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00

58,450.00 233,450.00 58,450.00 233,450.00 58,450.00 233,450.00 58,450.00


13/201

-108,550.00 -433,550.00 -108,550.00 -433,550.00 -108,550.00 -433,550.00 -108,550.00

11/30/2011 12/31/2011 1/31/2012 2/29/2012 3/31/2012 4/30/2012 5/31/2012

12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00 12,000.00

18,050.00 18,050.00 18,050.00 18,050.00 18,050.00 18,050.00 18,050.00

5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00

80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00 80,000.00

22,000.00 22,000.00 22,000.00 22,000.00 22,000.00 22,000.00 22,000.00

8,750.00 8,750.00 8,750.00 8,750.00 8,750.00 8,750.00 8,750.00

145,800.00 145,800.00 145,800.00 145,800.00 145,800.00 145,800.00 145,800.00

11/30/2011 12/31/2011 1/31/2012 2/29/2012 3/31/2012 4/30/2012 5/31/2012

4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00

15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00 15,000.00

3,700.00 3,700.00 3,700.00 3,700.00 3,700.00 3,700.00 3,700.00

500.00 500.00 500.00 500.00 500.00 500.00 500.00

7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00 7,000.00

30,200.00 30,200.00 30,200.00 30,200.00 30,200.00 30,200.00 30,200.00


14/201

11/30/2011 12/31/2011 1/31/2012 2/29/2012 3/31/2012 4/30/2012 5/31/2012

-26,000.00 209,000.00 -6,000.00 -26,000.00 9,000.00 4,000.00 -16,000.00

-7,000.00 -7,000.00 14,000.00 -7,000.00 -7,000.00 14,000.00 -7,000.00

-12,000.00 -12,000.00 -12,000.00 -12,000.00 -12,000.00 -12,000.00 -12,000.00

150,000.00 147,000.00 -396,350.00 147,000.00 147,000.00 -16,350.00 150,000.00

-15,000.00 8,000.00 13,000.00 5,000.00 10,000.00 9,000.00 6,000.00

-18,000.00 250,000.00 -35,000.00 485,000.00 -250,000.00 250,000.00 -250,000.00

200,000.00

110,000.00 77,000.00 39,000.00 80,000.00 75,000.00 75,000.00 301,000.00

-15,000.00 -5,000.00 25,000.00 -5,000.00 -5,000.00 -7,000.00 -5,000.00

-58,450.00 -233,450.00 466,900.00 -233,450.00 -58,450.00 116,900.00 -58,450.00

108,550.00 433,550.00 108,550.00 433,550.00 108,550.00 433,550.00 108,550.00


15/201

6/30/2012 Grand Total

-354,000.00 -6,505,000.00

2,693,000.00 42,118,000.00

-120,000.00 -2,040,000.00-21,000.00 -312,000.00

-2,216,000.00 -40,052,000.00

791,750.00 9,093,750.00

-70,000.00 -2,294,000.00

-200,000.00 -3,800,000.00

0.00 0.00

2,682,000.00 40,071,000.00

-1,600,000.00 -34,000,000.00

200,000.00 3,800,000.00

1,000.00 19,000.00

0.00 0.00

-200,000.00 -3,800,000.00

8,072,000.00 127,914,000.00

66,000.00 1,782,000.00

-7,571,000.00 -97,712,000.00

-527,450.00 -5,662,600.00

1,626,300.00 28,620,150.00


30,200.00 543,600.00

1,150,000.00 24,750,000.00

145,800.00 2,621,400.00

-2,000,000.00 -36,003,000.00

7,000.00 126,000.00

233,450.00 2,786,700.00


16/201

-433,550.00 -5,175,300.00


12,000.00 216,000.00

18,050.00 324,900.00

5,000.00 90,000.00

80,000.00 1,440,000.00

22,000.00 393,000.00

8,750.00 157,500.00

145,800.00 2,621,400.00


4,000.00 72,000.00

15,000.00 270,000.00

3,700.00 66,600.00

500.00 9,000.00

7,000.00 126,000.00

30,200.00 543,600.00


17/201

6/30/2012 Grand Total-54,000.00

206,000.00 888,000.00

-30,000.00

-7,000.00 -6,000.00

-12,000.00 -216,000.00

150,000.00 491,750.00

430,000.00

250,000.00 682,000.00

400,000.00

85,000.00 3,155,000.00

-5,000.00 -54,000.00

-233,450.00 -511,450.00

433,550.00 5,175,300.00


18/201

Account Account Description Period Net Ending Balance Period End

1001 Cash 300,000.00 Opening Balance

1100 AR 1,800,000.00 Opening Balance

1101 AR Allowance (7,000.00) Opening Balance

1110 AR Other 12,000.00 Opening Balance

1200 Inventory 2,000,000.00 Opening Balance

1300 Prepaid 120,000.00 Opening Balance1400 Land 500,000.00 Opening Balance

1405 Buildings 200,000.00 Opening Balance

1410 Building Improvements 25,000.00 Opening Balance

1415 Leasehold Improvements 800,000.00 Opening Balance

1420 Vehicles 300,000.00 Opening Balance

1425 Equipment 3,000,000.00 Opening Balance

1430 Furniture & Fixtures 20,000.00 Opening Balance

1440 Deposits 72,000.00 Opening Balance

1450 Acc Depr (2,000,000.00) Opening Balance

1500 Intangibles - Opening Balance

1550 Accu Amortization - Opening Balance

1600 Other Assets 1,000.00 Opening Balance

2000 Accounts Payable (300,000.00) Opening Balance

2100 Vendor Accruals (90,000.00) Opening Balance

2200 PR Tax Payable - Opening Balance

2300 Accrued PR - Opening Balance

2405 Accrued Insurance - Opening Balance

2410 Accrued Taxes (16,000.00) Opening Balance

2415 Accrued Interest (15,000.00) Opening Balance

2500 Curr Portion LTD (200,000.00) Opening Balance

2510 Credit Line (500,000.00) Opening Balance2600 Long Term Debt (2,000,000.00) Opening Balance

2610 LTD Curr Contra 200,000.00 Opening Balance

3100 Contributed Capital (200,000.00) Opening Balance

3200 Retained Earnings (4,022,000.00) Opening Balance

4000 Product Sales - Opening Balance

5000 Product Purchases - Opening Balance

5005 Inventory Adjustments - Opening Balance

5010 Labor - Opening Balance

5050 Freight - Opening Balance

5055 Repair - Opening Balance

5060 Supplies - Opening Balance

5100 Rent - Opening Balance

5105 Taxes - Opening Balance

5110 Utilities - Opening Balance

5115 Security - Opening Balance

5120 Depreciation - Opening Balance

5200 Insurance - Opening Balance

6010 Admin Labor - Opening Balance

6020 Audit - Opening Balance


19/201

6025 Legal Fees - Opening Balance

6030 Professional Development - Opening Balance

6050 Rent - Opening Balance

6055 Utilities - Opening Balance

6060 Taxes - Opening Balance

6100 Insurance - Opening Balance

6200 Other - Opening Balance7000 Interest - Opening Balance

7500 Tax Provision - Opening Balance

1001 Cash 147,000.00 447,000.00 1/31/2011

1100 AR 10,000.00 1,810,000.00 1/31/2011

1101 AR Allowance (1,000.00) (8,000.00) 1/31/2011

1110 AR Other 12,000.00 1/31/2011

1200 Inventory (250,000.00) 1,750,000.00 1/31/2011

1300 Prepaid (5,000.00) 115,000.00 1/31/2011

1400 Land 40,000.00 540,000.00 1/31/2011

1405 Buildings 200,000.00 400,000.00 1/31/2011

1410 Building Improvements 25,000.00 1/31/2011

1415 Leasehold Improvements 800,000.00 1/31/2011

1420 Vehicles 25,000.00 325,000.00 1/31/2011

1425 Equipment 20,000.00 3,020,000.00 1/31/2011

1430 Furniture & Fixtures 10,000.00 30,000.00 1/31/2011

1440 Deposits 72,000.00 1/31/2011

1450 Acc Depr (12,000.00) (2,012,000.00) 1/31/2011

1500 Intangibles - 1/31/20111550 Accu Amortization - 1/31/2011

1600 Other Assets 1,000.00 1/31/2011

2000 Accounts Payable (10,000.00) (310,000.00) 1/31/2011

2100 Vendor Accruals (90,000.00) 1/31/2011

2200 PR Tax Payable - 1/31/2011

2300 Accrued PR - 1/31/2011

2405 Accrued Insurance - 1/31/2011

2410 Accrued Taxes (110,950.00) (126,950.00) 1/31/2011

2415 Accrued Interest (7,000.00) (22,000.00) 1/31/2011

2500 Curr Portion LTD (200,000.00) 1/31/2011

2510 Credit Line 150,000.00 (350,000.00) 1/31/2011

2600 Long Term Debt (2,000,000.00) 1/31/2011

2610 LTD Curr Contra 200,000.00 1/31/2011

3100 Contributed Capital (200,000.00) 1/31/2011

3200 Retained Earnings (4,022,000.00) 1/31/2011

4000 Product Sales (2,000,000.00) (2,000,000.00) 1/31/2011

5000 Product Purchases 1,250,000.00 1,250,000.00 1/31/2011

5005 Inventory Adjustments 250,000.00 250,000.00 1/31/2011

5010 Labor 80,000.00 80,000.00 1/31/2011


20/201

5050 Freight 18,050.00 18,050.00 1/31/2011

5055 Repair 20,000.00 20,000.00 1/31/2011

5060 Supplies 2,000.00 2,000.00 1/31/2011

5100 Rent 5,000.00 5,000.00 1/31/2011

5105 Taxes 1,250.00 1,250.00 1/31/2011

5110 Utilities 2,000.00 2,000.00 1/31/2011

5115 Security 500.00 500.00 1/31/20115120 Depreciation 12,000.00 12,000.00 1/31/2011

5200 Insurance 5,000.00 5,000.00 1/31/2011

6010 Admin Labor 15,000.00 15,000.00 1/31/2011

6020 Audit 4,000.00 4,000.00 1/31/2011

6025 Legal Fees 2,000.00 2,000.00 1/31/2011

6030 Professional Development 1,000.00 1,000.00 1/31/2011

6050 Rent 2,000.00 2,000.00 1/31/2011

6055 Utilities 700.00 700.00 1/31/2011

6060 Taxes 1,000.00 1,000.00 1/31/2011

6100 Insurance 4,000.00 4,000.00 1/31/2011

6200 Other 500.00 500.00 1/31/2011

7000 Interest 7,000.00 7,000.00 1/31/2011

7500 Tax Provision 110,950.00 110,950.00 1/31/2011

1001 Cash 150,000.00 597,000.00 2/28/2011

1100 AR (40,000.00) 1,770,000.00 2/28/2011

1101 AR Allowance (1,000.00) (9,000.00) 2/28/2011

1110 AR Other 12,000.00 2/28/2011

1200 Inventory 250,000.00 2,000,000.00 2/28/20111300 Prepaid (2,000.00) 113,000.00 2/28/2011

1400 Land 250,000.00 790,000.00 2/28/2011

1405 Buildings 27,000.00 427,000.00 2/28/2011



1420 Vehicles 25,000.00 350,000.00 2/28/2011

1425 Equipment 20,000.00 3,040,000.00 2/28/2011


1440 Deposits 72,000.00 2/28/2011

1450 Acc Depr (12,000.00) (2,024,000.00) 2/28/2011

1500 Intangibles - 2/28/2011

1550 Accu Amortization - 2/28/2011

1600 Other Assets 1,000.00 2/28/2011


2100 Vendor Accruals (90,000.00) 2/28/2011

2200 PR Tax Payable - 2/28/2011

2300 Accrued PR - 2/28/2011


2410 Accrued Taxes (285,950.00) (412,900.00) 2/28/2011


21/201


2500 Curr Portion LTD (200,000.00) 2/28/2011

2510 Credit Line 150,000.00 (200,000.00) 2/28/2011

2600 Long Term Debt (2,000,000.00) 2/28/2011

2610 LTD Curr Contra 200,000.00 2/28/2011


3200 Retained Earnings (4,022,000.00) 2/28/20114000 Product Sales (2,000,000.00) (4,000,000.00) 2/28/2011


5005 Inventory Adjustments (250,000.00) - 2/28/2011

5010 Labor 80,000.00 160,000.00 2/28/2011

5050 Freight 18,050.00 36,100.00 2/28/2011

5055 Repair 20,000.00 40,000.00 2/28/2011

5060 Supplies 2,000.00 4,000.00 2/28/2011

5100 Rent 5,000.00 10,000.00 2/28/2011

5105 Taxes 1,250.00 2,500.00 2/28/2011

5110 Utilities 2,000.00 4,000.00 2/28/2011

5115 Security 500.00 1,000.00 2/28/2011

5120 Depreciation 12,000.00 24,000.00 2/28/2011

5200 Insurance 5,000.00 10,000.00 2/28/2011

6010 Admin Labor 15,000.00 30,000.00 2/28/2011

6020 Audit 4,000.00 8,000.00 2/28/2011

6025 Legal Fees 2,000.00 4,000.00 2/28/2011


6050 Rent 2,000.00 4,000.00 2/28/2011

6055 Utilities 700.00 1,400.00 2/28/2011

6060 Taxes 1,000.00 2,000.00 2/28/2011

6100 Insurance 4,000.00 8,000.00 2/28/20116200 Other 500.00 1,000.00 2/28/2011

7000 Interest 7,000.00 14,000.00 2/28/2011

7500 Tax Provision 285,950.00 396,900.00 2/28/2011

1001 Cash 147,000.00 744,000.00 3/31/2011

1100 AR (40,000.00) 1,730,000.00 3/31/2011

1101 AR Allowance (1,000.00) (10,000.00) 3/31/2011

1110 AR Other 12,000.00 3/31/2011

1200 Inventory (250,000.00) 1,750,000.00 3/31/2011

1300 Prepaid 3,000.00 116,000.00 3/31/2011

1400 Land 790,000.00 3/31/2011

1405 Buildings 427,000.00 3/31/2011



1420 Vehicles 75,000.00 425,000.00 3/31/2011

1425 Equipment 42,000.00 3,082,000.00 3/31/2011



22/201

1440 Deposits 72,000.00 3/31/2011

1450 Acc Depr (12,000.00) (2,036,000.00) 3/31/2011

1500 Intangibles - 3/31/2011


1600 Other Assets 1,000.00 3/31/2011


2100 Vendor Accruals (90,000.00) 3/31/20112200 PR Tax Payable - 3/31/2011

2300 Accrued PR - 3/31/2011


2410 Accrued Taxes (110,950.00) (523,850.00) 3/31/2011


2500 Curr Portion LTD (200,000.00) 3/31/2011

2510 Credit Line 165,000.00 (35,000.00) 3/31/2011

2600 Long Term Debt 200,000.00 (1,800,000.00) 3/31/2011

2610 LTD Curr Contra 200,000.00 3/31/2011



4000 Product Sales (2,000,000.00) (6,000,000.00) 3/31/2011



5010 Labor 80,000.00 240,000.00 3/31/2011

5050 Freight 18,050.00 54,150.00 3/31/2011

5055 Repair 20,000.00 60,000.00 3/31/2011

5060 Supplies 2,000.00 6,000.00 3/31/2011

5100 Rent 5,000.00 15,000.00 3/31/2011

5105 Taxes 1,250.00 3,750.00 3/31/2011

5110 Utilities 2,000.00 6,000.00 3/31/20115115 Security 500.00 1,500.00 3/31/2011

5120 Depreciation 12,000.00 36,000.00 3/31/2011

5200 Insurance 5,000.00 15,000.00 3/31/2011

6010 Admin Labor 15,000.00 45,000.00 3/31/2011

6020 Audit 4,000.00 12,000.00 3/31/2011

6025 Legal Fees 2,000.00 6,000.00 3/31/2011


6050 Rent 2,000.00 6,000.00 3/31/2011

6055 Utilities 700.00 2,100.00 3/31/2011

6060 Taxes 1,000.00 3,000.00 3/31/2011

6100 Insurance 4,000.00 12,000.00 3/31/2011

6200 Other 500.00 1,500.00 3/31/2011

7000 Interest 7,000.00 21,000.00 3/31/2011

7500 Tax Provision 110,950.00 507,850.00 3/31/2011

1001 Cash (409,850.00) 334,150.00 4/30/2011

1100 AR (10,000.00) 1,720,000.00 4/30/2011


23/201

1101 AR Allowance (1,000.00) (11,000.00) 4/30/2011

1110 AR Other 12,000.00 4/30/2011

1200 Inventory 250,000.00 2,000,000.00 4/30/2011

1300 Prepaid (10,000.00) 106,000.00 4/30/2011

1400 Land 790,000.00 4/30/2011

1405 Buildings 220,000.00 647,000.00 4/30/2011

1410 Building Improvements 25,000.00 4/30/20111415 Leasehold Improvements 800,000.00 4/30/2011

1420 Vehicles 25,000.00 450,000.00 4/30/2011

1425 Equipment 55,000.00 3,137,000.00 4/30/2011


1440 Deposits 72,000.00 4/30/2011

1450 Acc Depr (12,000.00) (2,048,000.00) 4/30/2011

1500 Intangibles - 4/30/2011


1600 Other Assets 1,000.00 4/30/2011


2100 Vendor Accruals (90,000.00) 4/30/2011

2200 PR Tax Payable - 4/30/2011

2300 Accrued PR - 4/30/2011


2410 Accrued Taxes 289,350.00 (234,500.00) 4/30/2011

2415 Accrued Interest 29,000.00 (7,000.00) 4/30/2011

2500 Curr Portion LTD (200,000.00) 4/30/2011

2510 Credit Line (35,000.00) 4/30/2011

2600 Long Term Debt (1,800,000.00) 4/30/2011

2610 LTD Curr Contra 200,000.00 4/30/2011

3100 Contributed Capital (200,000.00) 4/30/20113200 Retained Earnings (4,022,000.00) 4/30/2011

4000 Product Sales (2,000,000.00) (8,000,000.00) 4/30/2011



5010 Labor 80,000.00 320,000.00 4/30/2011

5050 Freight 18,050.00 72,200.00 4/30/2011

5055 Repair 17,000.00 77,000.00 4/30/2011

5060 Supplies 2,000.00 8,000.00 4/30/2011

5100 Rent 5,000.00 20,000.00 4/30/2011

5105 Taxes 1,250.00 5,000.00 4/30/2011

5110 Utilities 2,000.00 8,000.00 4/30/2011

5115 Security 500.00 2,000.00 4/30/2011

5120 Depreciation 12,000.00 48,000.00 4/30/2011

5200 Insurance 5,000.00 20,000.00 4/30/2011

6010 Admin Labor 15,000.00 60,000.00 4/30/2011

6020 Audit 4,000.00 16,000.00 4/30/2011

6025 Legal Fees 2,000.00 8,000.00 4/30/2011


6050 Rent 2,000.00 8,000.00 4/30/2011


24/201

6055 Utilities 700.00 2,800.00 4/30/2011

6060 Taxes 1,000.00 4,000.00 4/30/2011

6100 Insurance 4,000.00 16,000.00 4/30/2011

6200 Other 500.00 2,000.00 4/30/2011

7000 Interest 7,000.00 28,000.00 4/30/2011

7500 Tax Provision 234,500.00 742,350.00 4/30/2011

1001 Cash 150,000.00 484,150.00 5/31/2011

1100 AR 207,000.00 1,927,000.00 5/31/2011

1101 AR Allowance (1,000.00) (12,000.00) 5/31/2011

1110 AR Other 12,000.00 5/31/2011

1200 Inventory (250,000.00) 1,750,000.00 5/31/2011

1300 Prepaid - 106,000.00 5/31/2011

1400 Land 790,000.00 5/31/2011

1405 Buildings 647,000.00 5/31/2011

1410 Building Improvements 40,000.00 65,000.00 5/31/2011


1420 Vehicles 25,000.00 475,000.00 5/31/2011

1425 Equipment 20,000.00 3,157,000.00 5/31/2011


1440 Deposits 72,000.00 5/31/2011

1450 Acc Depr (12,000.00) (2,060,000.00) 5/31/2011

1500 Intangibles - 5/31/2011


1600 Other Assets 1,000.00 5/31/2011

2000 Accounts Payable (15,000.00) (351,000.00) 5/31/20112100 Vendor Accruals (90,000.00) 5/31/2011

2200 PR Tax Payable - 5/31/2011

2300 Accrued PR - 5/31/2011


2410 Accrued Taxes (58,450.00) (292,950.00) 5/31/2011


2500 Curr Portion LTD (200,000.00) 5/31/2011

2510 Credit Line (35,000.00) 5/31/2011

2600 Long Term Debt (1,800,000.00) 5/31/2011

2610 LTD Curr Contra 200,000.00 5/31/2011



4000 Product Sales (2,000,000.00) (10,000,000.00) 5/31/2011



5010 Labor 80,000.00 400,000.00 5/31/2011

5050 Freight 18,050.00 90,250.00 5/31/2011

5055 Repair 20,000.00 97,000.00 5/31/2011

5060 Supplies 2,000.00 10,000.00 5/31/2011


25/201

5100 Rent 5,000.00 25,000.00 5/31/2011

5105 Taxes 1,250.00 6,250.00 5/31/2011

5110 Utilities 2,000.00 10,000.00 5/31/2011

5115 Security 500.00 2,500.00 5/31/2011

5120 Depreciation 12,000.00 60,000.00 5/31/2011

5200 Insurance 5,000.00 25,000.00 5/31/2011

6010 Admin Labor 15,000.00 75,000.00 5/31/20116020 Audit 4,000.00 20,000.00 5/31/2011

6025 Legal Fees 2,000.00 10,000.00 5/31/2011


6050 Rent 2,000.00 10,000.00 5/31/2011

6055 Utilities 700.00 3,500.00 5/31/2011

6060 Taxes 1,000.00 5,000.00 5/31/2011

6100 Insurance 4,000.00 20,000.00 5/31/2011

6200 Other 500.00 2,500.00 5/31/2011

7000 Interest 7,000.00 35,000.00 5/31/2011

7500 Tax Provision 58,450.00 800,800.00 5/31/2011

1001 Cash 150,000.00 634,150.00 6/30/2011

1100 AR 210,000.00 2,137,000.00 6/30/2011

1101 AR Allowance (1,000.00) (13,000.00) 6/30/2011

1110 AR Other 12,000.00 6/30/2011

1200 Inventory 250,000.00 2,000,000.00 6/30/2011

1300 Prepaid - 106,000.00 6/30/2011

1400 Land 790,000.00 6/30/2011

1405 Buildings 647,000.00 6/30/20111410 Building Improvements 65,000.00 6/30/2011


1420 Vehicles 25,000.00 500,000.00 6/30/2011

1425 Equipment 20,000.00 3,177,000.00 6/30/2011


1440 Deposits 72,000.00 6/30/2011

1450 Acc Depr (12,000.00) (2,072,000.00) 6/30/2011

1500 Intangibles - 6/30/2011


1600 Other Assets 1,000.00 6/30/2011


2100 Vendor Accruals (90,000.00) 6/30/2011

2200 PR Tax Payable - 6/30/2011

2300 Accrued PR - 6/30/2011


2410 Accrued Taxes (234,500.00) (527,450.00) 6/30/2011


2500 Curr Portion LTD (200,000.00) 6/30/2011

2510 Credit Line 8,000.00 (27,000.00) 6/30/2011


26/201

2600 Long Term Debt (1,800,000.00) 6/30/2011

2610 LTD Curr Contra 200,000.00 6/30/2011



4000 Product Sales (2,003,000.00) (12,003,000.00) 6/30/2011


5005 Inventory Adjustments (250,000.00) - 6/30/20115010 Labor 80,000.00 480,000.00 6/30/2011

5050 Freight 18,050.00 108,300.00 6/30/2011

5055 Repair 20,000.00 117,000.00 6/30/2011

5060 Supplies 2,000.00 12,000.00 6/30/2011

5100 Rent 5,000.00 30,000.00 6/30/2011

5105 Taxes 1,250.00 7,500.00 6/30/2011

5110 Utilities 2,000.00 12,000.00 6/30/2011

5115 Security 500.00 3,000.00 6/30/2011

5120 Depreciation 12,000.00 72,000.00 6/30/2011

5200 Insurance 5,000.00 30,000.00 6/30/2011

6010 Admin Labor 15,000.00 90,000.00 6/30/2011

6020 Audit 4,000.00 24,000.00 6/30/2011

6025 Legal Fees 2,000.00 12,000.00 6/30/2011


6050 Rent 2,000.00 12,000.00 6/30/2011

6055 Utilities 700.00 4,200.00 6/30/2011

6060 Taxes 1,000.00 6,000.00 6/30/2011

6100 Insurance 4,000.00 24,000.00 6/30/2011

6200 Other 500.00 3,000.00 6/30/2011

7000 Interest 7,000.00 42,000.00 6/30/2011

7500 Tax Provision 234,500.00 1,035,300.00 6/30/2011

1001 Cash (396,350.00) 237,800.00 7/31/2011

1100 AR 7,000.00 2,144,000.00 7/31/2011

1101 AR Allowance (1,000.00) (14,000.00) 7/31/2011

1110 AR Other 12,000.00 7/31/2011

1200 Inventory (250,000.00) 1,750,000.00 7/31/2011

1300 Prepaid (3,000.00) 103,000.00 7/31/2011

1400 Land 790,000.00 7/31/2011

1405 Buildings 647,000.00 7/31/2011


1415 Leasehold Improvements 28,000.00 828,000.00 7/31/2011

1420 Vehicles 25,000.00 525,000.00 7/31/2011

1425 Equipment 20,000.00 3,197,000.00 7/31/2011


1440 Deposits 72,000.00 7/31/2011

1450 Acc Depr (12,000.00) (2,084,000.00) 7/31/2011

1500 Intangibles - 7/31/2011


27/201


1600 Other Assets 1,000.00 7/31/2011

2000 Accounts Payable 45,000.00 (314,000.00) 7/31/2011

2100 Vendor Accruals (90,000.00) 7/31/2011

2200 PR Tax Payable - 7/31/2011

2300 Accrued PR - 7/31/2011

2405 Accrued Insurance - 7/31/20112410 Accrued Taxes 466,900.00 (60,550.00) 7/31/2011


2500 Curr Portion LTD (200,000.00) 7/31/2011

2510 Credit Line (45,000.00) (72,000.00) 7/31/2011

2600 Long Term Debt (1,800,000.00) 7/31/2011

2610 LTD Curr Contra 200,000.00 7/31/2011



4000 Product Sales (2,000,000.00) (14,003,000.00) 7/31/2011



5010 Labor 80,000.00 560,000.00 7/31/2011

5050 Freight 18,050.00 126,350.00 7/31/2011

5055 Repair 20,000.00 137,000.00 7/31/2011

5060 Supplies 2,000.00 14,000.00 7/31/2011

5100 Rent 5,000.00 35,000.00 7/31/2011

5105 Taxes 1,250.00 8,750.00 7/31/2011

5110 Utilities 2,000.00 14,000.00 7/31/2011

5115 Security 500.00 3,500.00 7/31/2011

5120 Depreciation 12,000.00 84,000.00 7/31/2011

5200 Insurance 5,000.00 35,000.00 7/31/20116010 Admin Labor 15,000.00 105,000.00 7/31/2011

6020 Audit 4,000.00 28,000.00 7/31/2011

6025 Legal Fees 2,000.00 14,000.00 7/31/2011


6050 Rent 2,000.00 14,000.00 7/31/2011

6055 Utilities 700.00 4,900.00 7/31/2011

6060 Taxes 1,000.00 7,000.00 7/31/2011

6100 Insurance 4,000.00 28,000.00 7/31/2011

6200 Other 500.00 3,500.00 7/31/2011

7000 Interest 7,000.00 49,000.00 7/31/2011

7500 Tax Provision 58,450.00 1,093,750.00 7/31/2011

1001 Cash 147,000.00 384,800.00 8/31/2011

1100 AR 210,000.00 2,354,000.00 8/31/2011

1101 AR Allowance (1,000.00) (15,000.00) 8/31/2011

1110 AR Other 12,000.00 8/31/2011

1200 Inventory 250,000.00 2,000,000.00 8/31/2011


28/201

1300 Prepaid (5,000.00) 98,000.00 8/31/2011

1400 Land 100,000.00 890,000.00 8/31/2011

1405 Buildings 647,000.00 8/31/2011



1420 Vehicles 25,000.00 550,000.00 8/31/2011

1425 Equipment 20,000.00 3,217,000.00 8/31/20111430 Furniture & Fixtures 33,000.00 156,000.00 8/31/2011

1440 Deposits 72,000.00 8/31/2011

1450 Acc Depr (12,000.00) (2,096,000.00) 8/31/2011

1500 Intangibles - 8/31/2011


1600 Other Assets 1,000.00 8/31/2011


2100 Vendor Accruals (30,000.00) (120,000.00) 8/31/2011

2200 PR Tax Payable - 8/31/2011

2300 Accrued PR - 8/31/2011


2410 Accrued Taxes (233,450.00) (294,000.00) 8/31/2011


2500 Curr Portion LTD (200,000.00) 8/31/2011

2510 Credit Line (23,000.00) (95,000.00) 8/31/2011

2600 Long Term Debt (1,800,000.00) 8/31/2011

2610 LTD Curr Contra 200,000.00 8/31/2011



4000 Product Sales (2,000,000.00) (16,003,000.00) 8/31/2011

5000 Product Purchases 1,400,000.00 10,750,000.00 8/31/20115005 Inventory Adjustments (250,000.00) - 8/31/2011

5010 Labor 80,000.00 640,000.00 8/31/2011

5050 Freight 18,050.00 144,400.00 8/31/2011

5055 Repair 20,000.00 157,000.00 8/31/2011

5060 Supplies 2,000.00 16,000.00 8/31/2011

5100 Rent 5,000.00 40,000.00 8/31/2011

5105 Taxes 1,250.00 10,000.00 8/31/2011

5110 Utilities 2,000.00 16,000.00 8/31/2011

5115 Security 500.00 4,000.00 8/31/2011

5120 Depreciation 12,000.00 96,000.00 8/31/2011

5200 Insurance 5,000.00 40,000.00 8/31/2011

6010 Admin Labor 15,000.00 120,000.00 8/31/2011

6020 Audit 4,000.00 32,000.00 8/31/2011

6025 Legal Fees 2,000.00 16,000.00 8/31/2011


6050 Rent 2,000.00 16,000.00 8/31/2011

6055 Utilities 700.00 5,600.00 8/31/2011

6060 Taxes 1,000.00 8,000.00 8/31/2011

6100 Insurance 4,000.00 32,000.00 8/31/2011


29/201

6200 Other 500.00 4,000.00 8/31/2011

7000 Interest 7,000.00 56,000.00 8/31/2011

7500 Tax Provision 233,450.00 1,327,200.00 8/31/2011

1001 Cash 150,000.00 534,800.00 9/30/20111100 AR 5,000.00 2,359,000.00 9/30/2011

1101 AR Allowance (1,000.00) (16,000.00) 9/30/2011

1110 AR Other 12,000.00 9/30/2011

1200 Inventory (250,000.00) 1,750,000.00 9/30/2011

1300 Prepaid (5,000.00) 93,000.00 9/30/2011

1400 Land 890,000.00 9/30/2011

1405 Buildings 647,000.00 9/30/2011



1420 Vehicles 39,000.00 589,000.00 9/30/2011

1425 Equipment 20,000.00 3,237,000.00 9/30/2011


1440 Deposits 27,000.00 99,000.00 9/30/2011

1450 Acc Depr (12,000.00) (2,108,000.00) 9/30/2011

1500 Intangibles - 9/30/2011


1600 Other Assets 1,000.00 9/30/2011

2000 Accounts Payable (354,000.00) 9/30/2011

2100 Vendor Accruals (120,000.00) 9/30/2011

2200 PR Tax Payable - 9/30/2011

2300 Accrued PR - 9/30/20112405 Accrued Insurance - 9/30/2011

2410 Accrued Taxes (58,450.00) (352,450.00) 9/30/2011


2500 Curr Portion LTD (200,000.00) 9/30/2011

2510 Credit Line (14,000.00) (109,000.00) 9/30/2011

2600 Long Term Debt (1,800,000.00) 9/30/2011

2610 LTD Curr Contra 200,000.00 9/30/2011



4000 Product Sales (2,000,000.00) (18,003,000.00) 9/30/2011



5010 Labor 80,000.00 720,000.00 9/30/2011

5050 Freight 18,050.00 162,450.00 9/30/2011

5055 Repair 20,000.00 177,000.00 9/30/2011

5060 Supplies 2,000.00 18,000.00 9/30/2011

5100 Rent 5,000.00 45,000.00 9/30/2011

5105 Taxes 1,250.00 11,250.00 9/30/2011

5110 Utilities 2,000.00 18,000.00 9/30/2011


30/201

5115 Security 500.00 4,500.00 9/30/2011

5120 Depreciation 12,000.00 108,000.00 9/30/2011

5200 Insurance 5,000.00 45,000.00 9/30/2011

6010 Admin Labor 15,000.00 135,000.00 9/30/2011

6020 Audit 4,000.00 36,000.00 9/30/2011

6025 Legal Fees 2,000.00 18,000.00 9/30/2011

6030 Professional Development 1,000.00 9,000.00 9/30/20116050 Rent 2,000.00 18,000.00 9/30/2011

6055 Utilities 700.00 6,300.00 9/30/2011

6060 Taxes 1,000.00 9,000.00 9/30/2011

6100 Insurance 4,000.00 36,000.00 9/30/2011

6200 Other 500.00 4,500.00 9/30/2011

7000 Interest 7,000.00 63,000.00 9/30/2011

7500 Tax Provision 58,450.00 1,385,650.00 9/30/2011

1001 Cash (221,350.00) 313,450.00 10/31/2011

1100 AR (15,000.00) 2,344,000.00 10/31/2011

1101 AR Allowance (1,000.00) (17,000.00) 10/31/2011

1110 AR Other 12,000.00 10/31/2011

1200 Inventory 250,000.00 2,000,000.00 10/31/2011

1300 Prepaid (5,000.00) 88,000.00 10/31/2011

1400 Land 225,000.00 1,115,000.00 10/31/2011

1405 Buildings 647,000.00 10/31/2011



1420 Vehicles 25,000.00 614,000.00 10/31/20111425 Equipment 20,000.00 3,257,000.00 10/31/2011


1440 Deposits 99,000.00 10/31/2011

1450 Acc Depr (12,000.00) (2,120,000.00) 10/31/2011

1500 Intangibles - 10/31/2011


1600 Other Assets 1,000.00 10/31/2011


2100 Vendor Accruals (120,000.00) 10/31/2011

2200 PR Tax Payable - 10/31/2011

2300 Accrued PR - 10/31/2011


2410 Accrued Taxes 116,900.00 (235,550.00) 10/31/2011


2500 Curr Portion LTD (200,000.00) 10/31/2011

2510 Credit Line 3,000.00 (106,000.00) 10/31/2011

2600 Long Term Debt (1,800,000.00) 10/31/2011

2610 LTD Curr Contra 200,000.00 10/31/2011



31/201


4000 Product Sales (2,000,000.00) (20,003,000.00) 10/31/2011



5010 Labor 80,000.00 800,000.00 10/31/2011

5050 Freight 18,050.00 180,500.00 10/31/2011

5055 Repair 20,000.00 197,000.00 10/31/20115060 Supplies 2,000.00 20,000.00 10/31/2011

5100 Rent 5,000.00 50,000.00 10/31/2011

5105 Taxes 1,250.00 12,500.00 10/31/2011

5110 Utilities 2,000.00 20,000.00 10/31/2011

5115 Security 500.00 5,000.00 10/31/2011

5120 Depreciation 12,000.00 120,000.00 10/31/2011

5200 Insurance 5,000.00 50,000.00 10/31/2011

6010 Admin Labor 15,000.00 150,000.00 10/31/2011

6020 Audit 4,000.00 40,000.00 10/31/2011

6025 Legal Fees 2,000.00 20,000.00 10/31/2011


6050 Rent 2,000.00 20,000.00 10/31/2011

6055 Utilities 700.00 7,000.00 10/31/2011

6060 Taxes 1,000.00 10,000.00 10/31/2011

6100 Insurance 4,000.00 40,000.00 10/31/2011

6200 Other 500.00 5,000.00 10/31/2011

7000 Interest 7,000.00 70,000.00 10/31/2011

7500 Tax Provision 233,450.00 1,619,100.00 10/31/2011

1001 Cash 150,000.00 463,450.00 11/30/2011

1100 AR (25,000.00) 2,319,000.00 11/30/2011

1101 AR Allowance (1,000.00) (18,000.00) 11/30/2011

1110 AR Other 12,000.00 11/30/2011

1200 Inventory (18,000.00) 1,982,000.00 11/30/2011

1300 Prepaid (15,000.00) 73,000.00 11/30/2011

1400 Land 1,115,000.00 11/30/2011

1405 Buildings 647,000.00 11/30/2011



1420 Vehicles 80,000.00 694,000.00 11/30/2011

1425 Equipment 20,000.00 3,277,000.00 11/30/2011


1440 Deposits 99,000.00 11/30/2011

1450 Acc Depr (12,000.00) (2,132,000.00) 11/30/2011

1500 Intangibles - 11/30/2011


1600 Other Assets 1,000.00 11/30/2011



32/201

2100 Vendor Accruals (120,000.00) 11/30/2011

2200 PR Tax Payable - 11/30/2011

2300 Accrued PR - 11/30/2011


2410 Accrued Taxes (58,450.00) (294,000.00) 11/30/2011


2500 Curr Portion LTD (200,000.00) 11/30/20112510 Credit Line (15,000.00) (121,000.00) 11/30/2011

2600 Long Term Debt (1,800,000.00) 11/30/2011

2610 LTD Curr Contra 200,000.00 11/30/2011



4000 Product Sales (2,000,000.00) (22,003,000.00) 11/30/2011



5010 Labor 80,000.00 880,000.00 11/30/2011

5050 Freight 18,050.00 198,550.00 11/30/2011

5055 Repair 20,000.00 217,000.00 11/30/2011

5060 Supplies 2,000.00 22,000.00 11/30/2011

5100 Rent 5,000.00 55,000.00 11/30/2011

5105 Taxes 1,250.00 13,750.00 11/30/2011

5110 Utilities 2,000.00 22,000.00 11/30/2011

5115 Security 500.00 5,500.00 11/30/2011

5120 Depreciation 12,000.00 132,000.00 11/30/2011

5200 Insurance 5,000.00 55,000.00 11/30/2011

6010 Admin Labor 15,000.00 165,000.00 11/30/2011

6020 Audit 4,000.00 44,000.00 11/30/2011

6025 Legal Fees 2,000.00 22,000.00 11/30/20116030 Professional Development 1,000.00 11,000.00 11/30/2011

6050 Rent 2,000.00 22,000.00 11/30/2011

6055 Utilities 700.00 7,700.00 11/30/2011

6060 Taxes 1,000.00 11,000.00 11/30/2011

6100 Insurance 4,000.00 44,000.00 11/30/2011

6200 Other 500.00 5,500.00 11/30/2011

7000 Interest 7,000.00 77,000.00 11/30/2011

7500 Tax Provision 58,450.00 1,677,550.00 11/30/2011

1001 Cash 147,000.00 610,450.00 12/31/2011

1100 AR 210,000.00 2,529,000.00 12/31/2011

1101 AR Allowance (1,000.00) (19,000.00) 12/31/2011

1110 AR Other 12,000.00 12/31/2011

1200 Inventory 250,000.00 2,232,000.00 12/31/2011

1300 Prepaid (5,000.00) 68,000.00 12/31/2011

1400 Land 1,115,000.00 12/31/2011

1405 Buildings 647,000.00 12/31/2011


33/201



1420 Vehicles 25,000.00 719,000.00 12/31/2011

1425 Equipment 20,000.00 3,297,000.00 12/31/2011


1440 Deposits 99,000.00 12/31/2011

1450 Acc Depr (12,000.00) (2,144,000.00) 12/31/20111500 Intangibles - 12/31/2011


1600 Other Assets 1,000.00 12/31/2011


2100 Vendor Accruals (120,000.00) 12/31/2011

2200 PR Tax Payable - 12/31/2011

2300 Accrued PR - 12/31/2011


2410 Accrued Taxes (233,450.00) (527,450.00) 12/31/2011


2500 Curr Portion LTD (200,000.00) 12/31/2011

2510 Credit Line 8,000.00 (113,000.00) 12/31/2011

2600 Long Term Debt (1,800,000.00) 12/31/2011

2610 LTD Curr Contra 200,000.00 12/31/2011



4000 Product Sales (2,000,000.00) (24,003,000.00) 12/31/2011



5010 Labor 80,000.00 960,000.00 12/31/2011

5050 Freight 18,050.00 216,600.00 12/31/20115055 Repair 20,000.00 237,000.00 12/31/2011

5060 Supplies 2,000.00 24,000.00 12/31/2011

5100 Rent 5,000.00 60,000.00 12/31/2011

5105 Taxes 1,250.00 15,000.00 12/31/2011

5110 Utilities 2,000.00 24,000.00 12/31/2011

5115 Security 500.00 6,000.00 12/31/2011

5120 Depreciation 12,000.00 144,000.00 12/31/2011

5200 Insurance 5,000.00 60,000.00 12/31/2011

6010 Admin Labor 15,000.00 180,000.00 12/31/2011

6020 Audit 4,000.00 48,000.00 12/31/2011

6025 Legal Fees 2,000.00 24,000.00 12/31/2011


6050 Rent 2,000.00 24,000.00 12/31/2011

6055 Utilities 700.00 8,400.00 12/31/2011

6060 Taxes 1,000.00 12,000.00 12/31/2011

6100 Insurance 4,000.00 48,000.00 12/31/2011

6200 Other 500.00 6,000.00 12/31/2011

7000 Interest 7,000.00 84,000.00 12/31/2011

7500 Tax Provision 233,450.00 1,911,000.00 12/31/2011


34/201

1001 Cash (396,350.00) 214,100.00 1/31/2012

1100 AR (5,000.00) 2,524,000.00 1/31/2012

1101 AR Allowance (1,000.00) (20,000.00) 1/31/2012

1110 AR Other 12,000.00 1/31/20121200 Inventory (35,000.00) 2,197,000.00 1/31/2012

1300 Prepaid 25,000.00 93,000.00 1/31/2012

1400 Land 1,115,000.00 1/31/2012

1405 Buildings 647,000.00 1/31/2012



1420 Vehicles 22,000.00 741,000.00 1/31/2012

1425 Equipment 7,000.00 3,304,000.00 1/31/2012


1440 Deposits 99,000.00 1/31/2012

1450 Acc Depr (12,000.00) (2,156,000.00) 1/31/2012

1500 Intangibles - 1/31/2012


1600 Other Assets 1,000.00 1/31/2012


2100 Vendor Accruals (120,000.00) 1/31/2012

2200 PR Tax Payable - 1/31/2012

2300 Accrued PR - 1/31/2012


2410 Accrued Taxes 466,900.00 (60,550.00) 1/31/2012

2415 Accrued Interest 14,000.00 (7,000.00) 1/31/20122500 Curr Portion LTD (200,000.00) 1/31/2012

2510 Credit Line 13,000.00 (100,000.00) 1/31/2012

2600 Long Term Debt (1,800,000.00) 1/31/2012

2610 LTD Curr Contra 200,000.00 1/31/2012



4000 Product Sales (2,000,000.00) (2,000,000.00) 1/31/2012



5010 Labor 80,000.00 80,000.00 1/31/2012

5050 Freight 18,050.00 18,050.00 1/31/2012

5055 Repair 20,000.00 20,000.00 1/31/2012

5060 Supplies 2,000.00 2,000.00 1/31/2012

5100 Rent 5,000.00 5,000.00 1/31/2012

5105 Taxes 1,250.00 1,250.00 1/31/2012

5110 Utilities 2,000.00 2,000.00 1/31/2012

5115 Security 500.00 500.00 1/31/2012

5120 Depreciation 12,000.00 12,000.00 1/31/2012

5200 Insurance 5,000.00 5,000.00 1/31/2012


35/201

6010 Admin Labor 15,000.00 15,000.00 1/31/2012

6020 Audit 4,000.00 4,000.00 1/31/2012

6025 Legal Fees 2,000.00 2,000.00 1/31/2012


6050 Rent 2,000.00 2,000.00 1/31/2012

6055 Utilities 700.00 700.00 1/31/2012

6060 Taxes 1,000.00 1,000.00 1/31/20126100 Insurance 4,000.00 4,000.00 1/31/2012

6200 Other 500.00 500.00 1/31/2012

7000 Interest 7,000.00 7,000.00 1/31/2012

7500 Tax Provision 58,450.00 58,450.00 1/31/2012

1001 Cash 147,000.00 361,100.00 2/29/2012

1100 AR (25,000.00) 2,499,000.00 2/29/2012

1101 AR Allowance (1,000.00) (21,000.00) 2/29/2012

1110 AR Other 12,000.00 2/29/2012

1200 Inventory 485,000.00 2,682,000.00 2/29/2012

1300 Prepaid (5,000.00) 88,000.00 2/29/2012

1400 Land 1,115,000.00 2/29/2012

1405 Buildings 647,000.00 2/29/2012



1420 Vehicles 25,000.00 766,000.00 2/29/2012

1425 Equipment 15,000.00 3,319,000.00 2/29/2012


1440 Deposits 99,000.00 2/29/20121450 Acc Depr (12,000.00) (2,168,000.00) 2/29/2012

1500 Intangibles - 2/29/2012


1600 Other Assets 1,000.00 2/29/2012


2100 Vendor Accruals (120,000.00) 2/29/2012

2200 PR Tax Payable - 2/29/2012

2300 Accrued PR - 2/29/2012


2410 Accrued Taxes (233,450.00) (294,000.00) 2/29/2012


2500 Curr Portion LTD (200,000.00) 2/29/2012

2510 Credit Line 5,000.00 (95,000.00) 2/29/2012

2600 Long Term Debt (1,800,000.00) 2/29/2012

2610 LTD Curr Contra 200,000.00 2/29/2012



4000 Product Sales (2,000,000.00) (4,000,000.00) 2/29/2012



36/201


5010 Labor 80,000.00 160,000.00 2/29/2012

5050 Freight 18,050.00 36,100.00 2/29/2012

5055 Repair 20,000.00 40,000.00 2/29/2012

5060 Supplies 2,000.00 4,000.00 2/29/2012

5100 Rent 5,000.00 10,000.00 2/29/2012

5105 Taxes 1,250.00 2,500.00 2/29/20125110 Utilities 2,000.00 4,000.00 2/29/2012

5115 Security 500.00 1,000.00 2/29/2012

5120 Depreciation 12,000.00 24,000.00 2/29/2012

5200 Insurance 5,000.00 10,000.00 2/29/2012

6010 Admin Labor 15,000.00 30,000.00 2/29/2012

6020 Audit 4,000.00 8,000.00 2/29/2012

6025 Legal Fees 2,000.00 4,000.00 2/29/2012


6050 Rent 2,000.00 4,000.00 2/29/2012

6055 Utilities 700.00 1,400.00 2/29/2012

6060 Taxes 1,000.00 2,000.00 2/29/2012

6100 Insurance 4,000.00 8,000.00 2/29/2012

6200 Other 500.00 1,000.00 2/29/2012

7000 Interest 7,000.00 14,000.00 2/29/2012

7500 Tax Provision 233,450.00 291,900.00 2/29/2012

1001 Cash 147,000.00 508,100.00 3/31/2012

1100 AR 10,000.00 2,509,000.00 3/31/2012

1101 AR Allowance (1,000.00) (22,000.00) 3/31/20121110 AR Other 12,000.00 3/31/2012

1200 Inventory (250,000.00) 2,432,000.00 3/31/2012

1300 Prepaid (5,000.00) 83,000.00 3/31/2012

1400 Land 1,115,000.00 3/31/2012

1405 Buildings 647,000.00 3/31/2012



1420 Vehicles 15,000.00 781,000.00 3/31/2012

1425 Equipment 50,000.00 3,369,000.00 3/31/2012


1440 Deposits 99,000.00 3/31/2012

1450 Acc Depr (12,000.00) (2,180,000.00) 3/31/2012

1500 Intangibles - 3/31/2012


1600 Other Assets 1,000.00 3/31/2012


2100 Vendor Accruals (120,000.00) 3/31/2012

2200 PR Tax Payable - 3/31/2012

2300 Accrued PR - 3/31/2012


37/201


2410 Accrued Taxes (58,450.00) (352,450.00) 3/31/2012


2500 Curr Portion LTD (200,000.00) 3/31/2012

2510 Credit Line 10,000.00 (85,000.00) 3/31/2012

2600 Long Term Debt 200,000.00 (1,600,000.00) 3/31/2012

2610 LTD Curr Contra 200,000.00 3/31/20123100 Contributed Capital (200,000.00) 3/31/2012


4000 Product Sales (2,000,000.00) (6,000,000.00) 3/31/2012



5010 Labor 80,000.00 240,000.00 3/31/2012

5050 Freight 18,050.00 54,150.00 3/31/2012

5055 Repair 20,000.00 60,000.00 3/31/2012

5060 Supplies 2,000.00 6,000.00 3/31/2012

5100 Rent 5,000.00 15,000.00 3/31/2012

5105 Taxes 1,250.00 3,750.00 3/31/2012

5110 Utilities 2,000.00 6,000.00 3/31/2012

5115 Security 500.00 1,500.00 3/31/2012

5120 Depreciation 12,000.00 36,000.00 3/31/2012

5200 Insurance 5,000.00 15,000.00 3/31/2012

6010 Admin Labor 15,000.00 45,000.00 3/31/2012

6020 Audit 4,000.00 12,000.00 3/31/2012

6025 Legal Fees 2,000.00 6,000.00 3/31/2012


6050 Rent 2,000.00 6,000.00 3/31/2012

6055 Utilities 700.00 2,100.00 3/31/20126060 Taxes 1,000.00 3,000.00 3/31/2012

6100 Insurance 4,000.00 12,000.00 3/31/2012

6200 Other 500.00 1,500.00 3/31/2012

7000 Interest 7,000.00 21,000.00 3/31/2012

7500 Tax Provision 58,450.00 350,350.00 3/31/2012

1001 Cash (16,350.00) 491,750.00 4/30/2012

1100 AR 5,000.00 2,514,000.00 4/30/2012

1101 AR Allowance (1,000.00) (23,000.00) 4/30/2012

1110 AR Other 12,000.00 4/30/2012

1200 Inventory 250,000.00 2,682,000.00 4/30/2012

1300 Prepaid (7,000.00) 76,000.00 4/30/2012

1400 Land 1,115,000.00 4/30/2012

1405 Buildings 647,000.00 4/30/2012



1420 Vehicles 22,000.00 803,000.00 4/30/2012


38/201

1425 Equipment 11,000.00 3,380,000.00 4/30/2012


1440 Deposits 99,000.00 4/30/2012

1450 Acc Depr (12,000.00) (2,192,000.00) 4/30/2012

1500 Intangibles - 4/30/2012


1600 Other Assets 1,000.00 4/30/20122000 Accounts Payable (354,000.00) 4/30/2012

2100 Vendor Accruals (120,000.00) 4/30/2012

2200 PR Tax Payable - 4/30/2012

2300 Accrued PR - 4/30/2012


2410 Accrued Taxes 116,900.00 (235,550.00) 4/30/2012


2500 Curr Portion LTD (200,000.00) 4/30/2012

2510 Credit Line 9,000.00 (76,000.00) 4/30/2012

2600 Long Term Debt (1,600,000.00) 4/30/2012

2610 LTD Curr Contra 200,000.00 4/30/2012



4000 Product Sales (2,000,000.00) (8,000,000.00) 4/30/2012



5010 Labor 80,000.00 320,000.00 4/30/2012

5050 Freight 18,050.00 72,200.00 4/30/2012

5055 Repair 20,000.00 80,000.00 4/30/2012

5060 Supplies 2,000.00 8,000.00 4/30/2012

5100 Rent 5,000.00 20,000.00 4/30/20125105 Taxes 1,250.00 5,000.00 4/30/2012

5110 Utilities 2,000.00 8,000.00 4/30/2012

5115 Security 500.00 2,000.00 4/30/2012

5120 Depreciation 12,000.00 48,000.00 4/30/2012

5200 Insurance 5,000.00 20,000.00 4/30/2012

6010 Admin Labor 15,000.00 60,000.00 4/30/2012

6020 Audit 4,000.00 16,000.00 4/30/2012

6025 Legal Fees 2,000.00 8,000.00 4/30/2012


6050 Rent 2,000.00 8,000.00 4/30/2012

6055 Utilities 700.00 2,800.00 4/30/2012

6060 Taxes 1,000.00 4,000.00 4/30/2012

6100 Insurance 4,000.00 16,000.00 4/30/2012

6200 Other 500.00 2,000.00 4/30/2012

7000 Interest 7,000.00 28,000.00 4/30/2012

7500 Tax Provision 233,450.00 583,800.00 4/30/2012


39/201

1001 Cash 150,000.00 641,750.00 5/31/2012

1100 AR (15,000.00) 2,499,000.00 5/31/2012

1101 AR Allowance (1,000.00) (24,000.00) 5/31/2012

1110 AR Other 12,000.00 5/31/2012

1200 Inventory (250,000.00) 2,432,000.00 5/31/2012

1300 Prepaid (5,000.00) 71,000.00 5/31/2012

1400 Land 1,115,000.00 5/31/20121405 Buildings 647,000.00 5/31/2012



1420 Vehicles 25,000.00 828,000.00 5/31/2012

1425 Equipment 20,000.00 3,400,000.00 5/31/2012


1440 Deposits 99,000.00 5/31/2012

1450 Acc Depr (12,000.00) (2,204,000.00) 5/31/2012

1500 Intangibles - 5/31/2012


1600 Other Assets 1,000.00 5/31/2012


2100 Vendor Accruals (120,000.00) 5/31/2012

2200 PR Tax Payable - 5/31/2012

2300 Accrued PR - 5/31/2012


2410 Accrued Taxes (58,450.00) (294,000.00) 5/31/2012


2500 Curr Portion LTD (200,000.00) 5/31/2012

2510 Credit Line 6,000.00 (70,000.00) 5/31/2012

2600 Long Term Debt (1,600,000.00) 5/31/20122610 LTD Curr Contra 200,000.00 5/31/2012



4000 Product Sales (2,000,000.00) (10,000,000.00) 5/31/2012



5010 Labor 80,000.00 400,000.00 5/31/2012

5050 Freight 18,050.00 90,250.00 5/31/2012

5055 Repair 20,000.00 100,000.00 5/31/2012

5060 Supplies 2,000.00 10,000.00 5/31/2012

5100 Rent 5,000.00 25,000.00 5/31/2012

5105 Taxes 1,250.00 6,250.00 5/31/2012

5110 Utilities 2,000.00 10,000.00 5/31/2012

5115 Security 500.00 2,500.00 5/31/2012

5120 Depreciation 12,000.00 60,000.00 5/31/2012

5200 Insurance 5,000.00 25,000.00 5/31/2012

6010 Admin Labor 15,000.00 75,000.00 5/31/2012

6020 Audit 4,000.00 20,000.00 5/31/2012

6025 Legal Fees 2,000.00 10,000.00 5/31/2012


40/201


6050 Rent 2,000.00 10,000.00 5/31/2012

6055 Utilities 700.00 3,500.00 5/31/2012

6060 Taxes 1,000.00 5,000.00 5/31/2012

6100 Insurance 4,000.00 20,000.00 5/31/2012

6200 Other 500.00 2,500.00 5/31/2012

7000 Interest 7,000.00 35,000.00 5/31/20127500 Tax Provision 58,450.00 642,250.00 5/31/2012

1001 Cash 150,000.00 791,750.00 6/30/2012

1100 AR 207,000.00 2,706,000.00 6/30/2012

1101 AR Allowance (1,000.00) (25,000.00) 6/30/2012

1110 AR Other 12,000.00 6/30/2012

1200 Inventory 250,000.00 2,682,000.00 6/30/2012

1300 Prepaid (5,000.00) 66,000.00 6/30/2012

1400 Land 1,115,000.00 6/30/2012

1405 Buildings 647,000.00 6/30/2012



1420 Vehicles 25,000.00 853,000.00 6/30/2012

1425 Equipment 20,000.00 3,420,000.00 6/30/2012


1440 Deposits 99,000.00 6/30/2012

1450 Acc Depr (12,000.00) (2,216,000.00) 6/30/2012

1500 Intangibles - 6/30/2012

1550 Accu Amortization - 6/30/20121600 Other Assets 1,000.00 6/30/2012


2100 Vendor Accruals (120,000.00) 6/30/2012

2200 PR Tax Payable - 6/30/2012

2300 Accrued PR - 6/30/2012


2410 Accrued Taxes (233,450.00) (527,450.00) 6/30/2012


2500 Curr Portion LTD (200,000.00) 6/30/2012

2510 Credit Line (70,000.00) 6/30/2012

2600 Long Term Debt (1,600,000.00) 6/30/2012

2610 LTD Curr Contra 200,000.00 6/30/2012



4000 Product Sales (2,000,000.00) (12,000,000.00) 6/30/2012



5010 Labor 80,000.00 480,000.00 6/30/2012

5050 Freight 18,050.00 108,300.00 6/30/2012


41/201

5055 Repair 20,000.00 120,000.00 6/30/2012

5060 Supplies 2,000.00 12,000.00 6/30/2012

5100 Rent 5,000.00 30,000.00 6/30/2012

5105 Taxes 1,250.00 7,500.00 6/30/2012

5110 Utilities 2,000.00 12,000.00 6/30/2012

5115 Security 500.00 3,000.00 6/30/2012

5120 Depreciation 12,000.00 72,000.00 6/30/20125200 Insurance 5,000.00 30,000.00 6/30/2012

6010 Admin Labor 15,000.00 90,000.00 6/30/2012

6020 Audit 4,000.00 24,000.00 6/30/2012

6025 Legal Fees 2,000.00 12,000.00 6/30/2012


6050 Rent 2,000.00 12,000.00 6/30/2012

6055 Utilities 700.00 4,200.00 6/30/2012

6060 Taxes 1,000.00 6,000.00 6/30/2012

6100 Insurance 4,000.00 24,000.00 6/30/2012

6200 Other 500.00 3,000.00 6/30/2012

7000 Interest 7,000.00 42,000.00 6/30/2012

7500 Tax Provision 233,450.00 875,700.00 6/30/2012


42/201


43/201


44/201


45/201


46/201


47/201


48/201


49/201


50/201


51/201


52/201


53/201


54/201


55/201


56/201


57/201


58/201


59/201


60/201


61/201


62/201


63/201


64/201


65/201


66/201


67/201


68/201


69/201


70/201


71/201


72/201


73/201


74/201


75/201


76/201


77/201


78/201


79/201


80/201


81/201


82/201


83/201


84/201


85/201


86/201


87/201


88/201


89/201


90/201


91/201


92/201


93/201


94/201


95/201


96/201


97/201


98/201


99/201


100/201


101/201


102/201


103/201


104/201


105/201


106/201


107/201


108/201


109/201

Statement Line OCS Line G&A Line

BS Cash 0 0

BS Accounts Receivable 0 0



BS Inventory 0 0

BS Prepaid Assets 0 0BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS Accum Depreciation 0 0

BS Intangible Assets 0 0


BS Other Assets 0 0

BS Accounts Payable 0 0

BS Accrued Expenses 0 0

BS Other Payables 0 0



BS Taxes Payable 0 0

BS Accrued Interest 0 0

BS Curr Portion LTD 0 0

BS Credit Line 0 0BS Long Term Debt 0 0

BS LTD Curr Contra 0 0

BS Owner's Contributed Capital 0 0

BS Retained Earnings 0 0

IS Sales 0 0

IS Material Costs 0 0


IS Other Cost of Sales Labor 0

IS Other Cost of Sales Freight 0

IS Other Cost of Sales Maintenance 0


IS Other Cost of Sales Occupancy 0




IS Other Cost of Sales Depreciation 0

IS Other Cost of Sales Insurance 0

IS General and Administrative 0 Labor

IS General and Administrative 0 Professional


110/201



IS General and Administrative 0 Occupancy



IS General and Administrative 0 Insurance

IS General and Administrative 0 OtherIS Interest 0 0

IS Tax Provision 0 0

0 0 0 0

0 0 0 0

0 0 0 0

BS Cash 0 0




BS Inventory 0 0

BS Prepaid Assets 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0


BS Intangible Assets 0 0BS Intangible Assets 0 0

BS Other Assets 0 0









BS Credit Line 0 0

BS Long Term Debt 0 0




IS Sales 0 0





111/201







IS Other Cost of Sales Occupancy 0IS Other Cost of Sales Depreciation 0










IS General and Administrative 0 Other

IS Interest 0 0


0 0 0 0

0 0 0 0

0 0 0 0

BS Cash 0 0




BS Inventory 0 0BS Prepaid Assets 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0




BS Other Assets 0 0








112/201



BS Credit Line 0 0




BS Retained Earnings 0 0IS Sales 0 0




















IS General and Administrative 0 InsuranceIS General and Administrative 0 Other

IS Interest 0 0


0 0 0 0

0 0 0 0

0 0 0 0

BS Cash 0 0




BS Inventory 0 0


BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0


113/201

BS PP&E 0 0




BS Other Assets 0 0


BS Accrued Expenses 0 0BS Other Payables 0 0






BS Credit Line 0 0





IS Sales 0 0









IS Other Cost of Sales Occupancy 0IS Other Cost of Sales Occupancy 0











IS General and Administrative 0 Other

IS Interest 0 0


0 0 0 0

0 0 0 0

0 0 0 0

BS Cash 0 0



114/201



BS Inventory 0 0


BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0

BS PP&E 0 0




BS Other Assets 0 0









BS Credit Line 0 0



BS Owner's Contributed Capital 0 0BS Retained Earnings 0 0

IS Sales 0 0



















115/201


IS General

excel financials model 2012 072

Documents