need to find the balance sheet for june 30, from this income statement and Case budget?

Format Tools Data Windo Insert cel File View Edit AutoSave Data Formulas Review de Insert Draw Page Layout 3 Calibrl (Body) 12 ' A to B ID fx E27 E28 Column Columns Columns Columns DI Columns Cash Budget May 4175 June April 0 45305.5 Beginning Cash Balance Cash Receipts Cash Sales Financing Promotion Deposit Equity Investment Total Cash Reciepts 33975 0 O 50.000 51980 D O 0 56155 38955 12995 1500 0 53490 1 83,975 83975 Total Cash wallable 56155 987855 14 15 16 11 TH 13 26 21 22 Cash Disbursements Operating cost Wage Expense Rent expense Insurance expense Lighting And display Racks 6000 4000 O 6000 4000 5000 4000 2.400 5400 129000 1000 o 0 147300 6735 Dividend Advertising Expert Uudes perde Total Cash Dist 120 24 35 20 2009 130 11219.6 453055 20 23 Cash Balance Before Borrowing Anal Loan Going Gash Balance -5825 68000 4175 0 ES 45 11 33 13 a esc SH 30 F3 090 D Foto Wanders Q6 0.669 . Ci . . D May June Columns Column Sauser Sale To COGS Apr 20990 1225 Total 2010 51580 30 SCHLE OS 38000 24500 9475 77970 7290 57000 20070 16.25 23950 45 G OGGET 12000 4000 170 ONE 1000 180 200 102 4200 200 1567 200 2006 1718 While 10 A 11 Swap 11 Depec 15 Total IN 200 6000 451 Asa DOR 000 ET SET w SP SY 13 3071 14 350 3063 DNS 18 11 Mke 7 7 2 . 3 4 5 6 7 & Tan Q w E R T Y U u A S S D F G H J Z N C V B N 36 control option command Jane's Casey File Vert Format Tools Data Window Hele BB 2.0 Dia Page Farms Date View Dar Cult 1 39 f . 1 New 0302 CA T. 11 1 Mock Dre 3 1 2 3 . ) 5 6 UN 7 Q w W E R T Y U U A A S D D F G H N Z x C > B B N X option command Format Tools Data Windo Insert cel File View Edit AutoSave Data Formulas Review de Insert Draw Page Layout 3 Calibrl (Body) 12 ' A to B ID fx E27 E28 Column Columns Columns Columns DI Columns Cash Budget May 4175 June April 0 45305.5 Beginning Cash Balance Cash Receipts Cash Sales Financing Promotion Deposit Equity Investment Total Cash Reciepts 33975 0 O 50.000 51980 D O 0 56155 38955 12995 1500 0 53490 1 83,975 83975 Total Cash wallable 56155 987855 14 15 16 11 TH 13 26 21 22 Cash Disbursements Operating cost Wage Expense Rent expense Insurance expense Lighting And display Racks 6000 4000 O 6000 4000 5000 4000 2.400 5400 129000 1000 o 0 147300 6735 Dividend Advertising Expert Uudes perde Total Cash Dist 120 24 35 20 2009 130 11219.6 453055 20 23 Cash Balance Before Borrowing Anal Loan Going Gash Balance -5825 68000 4175 0 ES 45 11 33 13 a esc SH 30 F3 090 D Foto Wanders Q6 0.669 . Ci . . D May June Columns Column Sauser Sale To COGS Apr 20990 1225 Total 2010 51580 30 SCHLE OS 38000 24500 9475 77970 7290 57000 20070 16.25 23950 45 G OGGET 12000 4000 170 ONE 1000 180 200 102 4200 200 1567 200 2006 1718 While 10 A 11 Swap 11 Depec 15 Total IN 200 6000 451 Asa DOR 000 ET SET w SP SY 13 3071 14 350 3063 DNS 18 11 Mke 7 7 2 . 3 4 5 6 7 & Tan Q w E R T Y U u A S S D F G H J Z N C V B N 36 control option command Jane's Casey File Vert Format Tools Data Window Hele BB 2.0 Dia Page Farms Date View Dar Cult 1 39 f . 1 New 0302 CA T. 11 1 Mock Dre 3 1 2 3 . ) 5 6 UN 7 Q w W E R T Y U U A A S D D F G H N Z x C > B B N X option command