Balance Sheet by Minor Group6/26/2007 Page 1 Concordia Lutheran Church11:32 AM Jul 1, 2006 through Jun 30, 2007 Balance As Of Balance As Of Current Year Percent Minor Group Jul 1, 2006 Jun 30, 2007 Change Change Fund: 01 General Fund Assets Dedicated Funds Receivable 0.00 1,674.65 1,674.65 0.00% Bank Acct 26,906.11 19,472.13 -7,433.98 -27.63% Stock Etc. 0.00 0.00 0.00 0.00% Stock Etc. 0.00 0.00 0.00 0.00% Preschool Receivable -953.93 100.00 1,053.93 -110.48% Lunch Receivables 6,182.17 0.00 -6,182.17 -100.00% Total Assets 32,134.35 21,246.78 -10,887.57 -33.88% Liabilities Dedicated Funds Payable 42,892.82 45,590.71 2,697.89 6.29% Salary Exp Payable 6,500.00 6,500.00 0.00 0.00% Prepaid Tuition 4,470.00 45.00 -4,425.00 -98.99% WBP Payable -7,444.82 -7,616.08 -171.26 2.30% TSA -76.76 -25.08 51.68 -67.33% FICA Payable 0.00 0.00 0.00 0.00% Fed W/H Payable 0.00 0.00 0.00 0.00% State W/H Payable 0.00 0.00 0.00 0.00% Worker Comp Payable 1,692.80 764.67 -928.13 -54.83% Missions Payable 3,182.00 1,708.33 -1,473.67 -46.31% Mortgage Payable 0.00 0.00 0.00 0.00% Lutheran High Payable 4,590.00 2,366.00 -2,224.00 -48.45% Total Liabilities 55,806.04 49,333.55 -6,472.49 -11.60% Fund Balance Totals for Fund Balance -23,671.69 -28,086.77 -4,415.08 18.65% Total Fund Balance/Equity -23,671.69 -28,086.77 -4,415.08 18.65% Total Liability and Fund Balance 32,134.35 21,246.78 -10,887.57 -33.88%